Processing Flat Files for RDC Replenishment

If you use flat files in place of Palm devices, you must upload and process the files before using them with RDC Replenishment. After processing the flat files, use the count data to create orders, transfers, or billings of usage, as needed.

To upload a flat file for RDC Replenishment:

From the System > Printers menu, select Your Hold Entries to display the Spooler Control screen.
Use the Upload hot key to display the Select file window.
Browse to the flat file, select it, and click the Open button to display the DOS Path Name and Spooler Title prompt.

The system populates the Enter DOS Path Name field with the flat file's directory pathway.

In the Enter Spooler Title field, enter a name for the flat file, such as RDC Flat File Upload.
Press Enter to upload the file.
Press Esc to return to the Spooler Control screen.
Process the file.

To process a flat file for RDC Replenishment:

Upload the flat file to Hold Entries.
From the Spooler Control screen, select the uploaded flat file and use the Process hot key to display the User Defined Upload Processing screen.
In the Processing Type field, press F10 and select RDC Flat File Import.
Use the Begin hot key to display the Customer Entry prompt.
In the Customer field, enter the customer ID for whom you are processing the data.
In the Processing Mode prompt, select one of the following modes to use in processing the count data:

Mode	Description
Billings	For consignment sites only, creates a billings of usage for the quantities entered in the flat file.
Transfers	For consignment locations only, creates a consignment transfer for the quantities entered in the flat file.
Billings and Transfers	For consignment locations only, creates both a billings of usage and a consignment transfer for the quantities entered in the flat file.
Levels	For non-consignment locations only, processes the quantities entered in the flat file as a normal levels count.
Orders	For non-consignment locations only, processes the quantities entered in the flat file as a normal order count.

Note: The Billings, Transfers, and Billings and Transfers modes display only for customers flagged as consignment locations. The Levels and Orders modes display only for customers who are not flagged as consignment locations.

The system processes the flat file data. If the system comes across any data errors, such as invalid part numbers, it prompts you with the error. Resolve the errors and continue processing the data.

Press Esc to save updates and exit the screen.
Review the processed data for non-consignment or consignment sites, as needed.