Requirements Planning > Forecast Maintenance > MRP Export Forecasts

MRP Export Forecasts

You use this program to generate an ASCII file using selected records from your forecast file. Once created, the file can be imported using the Import Forecasts or the Import Build Schedules program.

Export Forecasts

Field Description
Start Export Select this to export the flat ASCII file forecast file once the path and file name have been entered.

The program aborts if any errors are encountered.
Export details  
Export file Indicate the name of the file to export, including the full pathname.
Target

Indicate the program which will be used to import the file.

Option Description
Forecast import Select this to create a file that can be imported using the Import Forecasts program.

This adds the ;SYSPRO IMPORT - Version=001 - MRPP09 entry to header of the file.
Build schedule import Select this to create a file that can be imported using the Import Build Schedules program.

This adds the ;SYSPRO IMPORT - Version=001 - MRPP15 entry to the header of the file.

See Restrictions and limits in Notes and warnings
Print export file Select this to list the contents of the export file in the Export Report pane.
Dates Indicate the forecast date(s) for which to perform the export process.
Stock codes Indicate the stock code(s) for which to include forecasts in the export process.
Customers Indicate the customer(s) for which to include forecasts in the export process.
Warehouses Indicate the warehouse(s) for which to include stock codes in the export process.
References Indicate the reference(s) for which to include forecasts in the export process.
Forecast types Indicate the forecast type(s) to include in the export process.

Export Report

This displays the contents of the export file if you selected the Print export file option. The file can be printed, Emailed or saved as an Excel file.

File Layout

This table indicates the layout of the file that is exported.

Field Start position Field length and description
Header   The following line is added to the export file when creating the export file for a Forecast import:

;SYSPRO IMPORT - Version=001 - MRPP09

The following line is added to the export file when creating the export file for a Build Schedule import:

;SYSPRO IMPORT - Version=001 - MRPP15

Mandatory entry of this comment on the first line of the import file to distinguish it from a SYSPRO 6.1 layout file. This comment is not case-sensitive.
Line type 1 1

(Mandatory)

F indicates a forecast line; B indicates a build schedule line.
Stock code 2 30

(Mandatory)

This field must be non-blank. If static details for this stock code are not found, then the item will be assumed to be non-stocked.

[Note]

If the warehouse is not ** then the stock code must be held on file.
Warehouse 32 10

(Mandatory)

This indicates the forecast warehouse. If the item is non-stocked, then enter **.
Date 42 8

(Mandatory)

This indicates the forecast date in a valid format (e.g. DDMMYY or MMDDYY).
Quantity 50

19

(Mandatory)

This indicates the quantity required in an edited format (e.g. 1.23 or 1).
Reference 69 30

Enter a forecast reference, if required.
Forecast type 99 1

Enter the type of forecast, if required. This is used solely for selecting forecasts.
Customer 100 15

Enter a valid customer, if required.
Revision 115 5

ECC revision - stocked items only.
Release 120 5

ECC release - stocked items only.

Notes and warnings

Restrictions and limits

  • Inactive forecast records, or forecast records that do not have a positive forecast quantity outstanding, are not exported.

  • Non-stocked warehouse records (denoted by **) are not exported when the Target is set to Build schedule import.