Páginas filhas
  • Periodic Export for S&OP Neogrid (FATA801 - SIGAFAT)

This routine can be run manually (via menu) or via Protheus Schedule. It will issue the necessary files for integration with S&OP Neogrid on the directory specified on parameter MV_FATSOPP, set at the moment of running the initial load. This path must be under directory SYSTEM from Protheus (StartPath) for the routine to be run via Schedule.

Must receive as parameters start date and end date of the transaction for file generation, as well as the treatment to be applied in registers that already have being exported within the period entered.

The following files will be issued on the execution of the routine, according to needs:

  • Items

The file will be generated at first execution (initial load) and always where there are items (products) added or edited on Protheus, within a period specified on routine parameters. The generation will be realized from the register of products on Protheus (SB1).

  • Dimension on Demand 1

The file will be generated on the firs execution (initial load) and every time there is an inclusion or modification on the register of selected entity, to be used as dimension on demand 1 of initial load routine.

Example:

If selected the entity Customer for Dimension of Demand 1 and there are 100 registered customers, it will generate 100 DD1 rows with respective codes.

  • Dimension on Demand 2

The file will be generated only in the first execution (initial load).

  • DFU List Price

The file will be generated at first execution (initial load) and always where there is the addition or change of price lists, within a period specified on routine parameters.


Premise

Edit the value, for example, of a product.

  1.    Access Updates/ Register/ Products.
  2.    Select the product and click Edit.
  3.    Edit value and click Save.

Procedures

  1.    Access Updates/ Integration/ Periodic Export S&OP.
  2.    Click Questions.
  3.    Complete the parameters Date From and Date To and select the option Resend to the question Already Imported?
  4.    Click the button Information and next click Run.
  5.    Check if file was successfully generated.
  6.    Access the tab Neogrid, select the file Price List and check if successfully generated.


 Tip

To consider only files that were not yet exported, select the option ignore on the completion of the question Already Exported?



Procedures for the configuration of the Schedule (Automatic Export)

 Important

Through Schedule, the routine considers just those that were not exported.

  1.    Access SIGACFG/ Environment/ Schedule/ Schedule.
  2.    Test with the following configurations:
    • FATA801({1,Nil}) – Run the export of the day database – 1 (according to the number added to parameter)”.
    • FATA801({STOD("20141030"), NIL}) – Export only the entered date 
    • FATA801({STOD("20140101"),STOD("20141030")}) – Run the export entered with date From/To.         
  3.    Check if files were correctly generated according to Schedule.