Program EOUT, Process Outbound Records, is used to export outbound sales order records to a flat file. This program only exports sales orders that were previously imported with program E850, Process Incoming Purchase Orders. The sales orders must be status S - Confirmed Complete or V - Invoiced to be exported.
This program exports flat files in the following format.
* Files contain pipe ( | ) separated fields. No trailing pipe is used unless the final filed is empty.
* Dates are stored in the format YYYYMMDD.
* Numbers are unsigned and can have optionally embedded decimal points.
* The records in the files are separated by newline (\n), hex 0D0A.
* The first character of the record determines the record type.
* All records for an order are grouped together.
* All records other than the order header are optional.
Export Record Types and Export Process
Exporting Sales Orders and Invoices to Flat Files
Record types that are exported with this program include the following.
1. S record type: sales order header, one per order.
* Shipment Number: the order number * 100 + order suffix from the sales order header.
* Ship Date: the sales order ship date from the sales order header.
* Status: If the sales order quantity is equal to the shipped quantity on all sales order lines, and the order suffix is 0, the status will be C.
If the sales order quantity does not equal the shipped quantity on any of the sales order lines or the order suffix is not 0, the status will be P.
* Carrier Pro #: the carrier pro number from the sales order summary screen.
* BOL Number: the bill of lading number from the sales order header.
* SCAC Number: the SCAC number assigned to the carrier's vendor record on the remit to screen in program VEMM, Vendor Master Maintenance.
* Carrier Name: the vendor description from the carrier vendor record in program VEMM, Vendor Master Maintenance.
* Carrier Type: the carrier type assigned to the carrier's vendor record on the remit to screen in program VEMM, Vendor Master Maintenance.
* Carton Count: the number of containers for the sales order, from the sales order summary screen.
* Carton Weight: the total weight of the containers for the sales order, from the sales order summary screen.
* Sold To Name: the sales order customer name.
* Sold To Address, City, State, and Zip Code; the customer's address, city, state, and zip code.
* Customer Number: the sales order customer number.
2. O record type: customer purchase order information, one per sales order
* PO Number: the customer purchase order number from the sales order header.
* PO Date: the sales order date from the sales order header.
3. I record type: sales order lines, multiple records can exist.
* Vendor Item: the sales order line item number.
* SKU: the information in the Cust Item No field for the sales order line.
* UPC: the information in the POS Description2 field in the item master record in program ICMM, Inventory Master Maintenance.
* Item Description: the item description from the sales order line.
* Inner Pack: the case quantity from the item's planning record.
* Outer Pack: blank
* Quantity: the quantity shipped for the sales order line.
* Price: the unit price for the sales order line.
* UOM: the sales unit of measure for the sales order line
1. H record type: sales order header, one per order.
* Invoice Number: sales order invoice number from the sales order header.
* Invoice Date: sales order invoice date from the sales order header.
* PO Number: the customer purchase order number from the sales order header.
* PO Date: the sales order date from the sales order header.
* Ship To Name, Address, City, State, and Zip: the ship to information from the sales order header.
* Bill To Number: the bill to code from the sales order header.
* Department Number: 24
* Ship Date: the ship date from the sales order header.
* Status: If the sales order quantity is equal to the shipped quantity on all sales order lines, and the order suffix is 0, the status will be C.
If the sales order quantity does not equal the shipped quantity on any of the sales order lines or the order suffix is not 0, the status will be P.
* Carrier Pro #: the carrier pro number from the sales order summary screen.
* BOL Number: the bill of lading number from the sales order header.
* Shipment Tracking Number: the order number * 100 + order suffix from the sales order header.
* SCAC Number: the SCAC number assigned to the carrier's vendor record on the remit to screen in program VEMM, Vendor Master Maintenance.
* Carrier Name: the vendor name from the carrier's vendor record in program VEMM, Vendor Master Maintenance.
* Carrier Type: the carrier type assigned to the carrier's vendor record on the remit to screen in program VEMM, Vendor Master Maintenance.
* Carton Count: the number of containers for the sales order, from the sales order summary screen.
* Carton Weight: the total weight of the containers for the sales order, from the sales order summary screen.
* Discount Percent: the discount percent for sales orders with status S - Confirmed Complete is calculated from the terms code assigned to the sales order header.
For sales orders with status V- Invoiced, the discount percent is calculated as the discount percent from the sales order header, discount days + invoice date,
* Discount Due Date: the discount due date from the terms code.
* Net Date Due: the net due date from the terms code.
* Customer Number: The customer number from the sales order.
* Routing Description: blank
* Freight Amount: the amount entered in the Freight Charges field on the sales order summary screen.
2. A type record: charges and allowances. There can be multiple A type records per H type record.
* Code: the miscellaneous codes from on the Summary screen in sales order entry. A trailing 0 is added to the miscellaneous codes for export.
* Percent: the invoiced miscellaneous charge is calculated as a percentage of the gross invoiced value. That percentage is entered here, with its sign reversed.
* Amount: the invoiced miscellaneous charge, with its sign reversed.
* Description: the miscellaneous code description from SPMC, Miscellaneous Code Maintenance.
3. D type record: sales order line items. There can be multiple D type records per H type record.
* Quantity: the quantity shipped on the sales order line.
* UOM: the sales unit of measure from the sales order line.
* Price: the unit price for the shipped quantity.
* Vendor Item: the sales order line item number.
* SKU: the information in the Cust Item No field for the sales order line.
* UPC: the information in the POS Description2 field in the item master record in program ICMM, Inventory Master Maintenance.
* Item Description: the item description from the sales order line.
* Inner Pack: the case quantity from the item's planning record.
* Outer Pack: blank
You can only export status S - Confirmed Complete or V- Invoices sales orders that were previously imported with program E850, Process Incoming Purchase Orders.
1. Set the pop-list in the header to indicate which orders you wish to display.
* Status S, V orders only: sales orders with status S - Confirmed Complete and V - Invoiced that have not yet been processed will be displayed.
* Previously Processed Orders: sales orders that have been previously processed through this program.
* All orders: both previously processed orders and sales orders with status S - Confirmed Complete or V - Invoiced that have not been processed will be displayed.
2. The sales orders will be displayed.
3. To include a sales order in the advance shipment notice export, set the I856 Select flag to on.
* Press the [Select All] 
button to set the I856 Select flag to on for all displayed sales orders. The I856 Select flag can be set to off manually for individual sales orders after this button has been pressed.
* Press the [Deselect All 
button in set the I856 Select flag to off for all displayed sales orders. The I856 Select flag can be set to on manually for individual sales orders after this button has been pressed.
* When the I856 Select flag is set to on, a flat file name must be entered in the I856 File field. When the [Start Export] button is pressed, the sales orders selected here will be written to the flat file defined in the I856 File field.
4. To include a sales order in the invoice export, set the I810 Select flag to on.
* Press the [Select All] button to set the I810 Select flag to on for all displayed sales orders. The I810 Select flag can be set to off manually for individual sales orders after this button has been pressed.
* Press the [Deselect All] button in set the I810 Select flag to off for all displayed sales orders. The I810 Select flag can be set to on manually for individual sales orders after this button has been pressed.
* When the I810 Select flag is set to on, a flat file name must be entered in the I810 File field. When the [Start Export] button is pressed, the sales orders selected here will be written to the flat file defined in the I810 File field.
5. In the I856 File field, enter the desired directory and flat file. The sales orders for which the I856 Select flag is set to on will be exported to this file when the [Start Export] button is pressed.
* You can type the desired directory and file name into the field, such as C:\ndslocalfiles\I856.txt
* The directory from which you are importing the file cannot have spaces in the directory name.
* You can use the [...] to find the data file on your computer or network. Press the button, find the desired file, and press [Open]. The program will enter the directory and file in the field.
6. In the I810 File field, enter the desired directory and flat file. The sales orders for which the I810 Select flag is set to on will be exported to this file when the [Start Export] button is pressed.
* You can type the desired directory and file name into the field, such as C:\ndslocalfiles\I810.txt
* The directory from which you are importing the file cannot have spaces in the directory name.
* You can use the [...] to find the data file on your computer or network. Press the button, find the desired file, and press [Open]. The program will enter the directory and file in the field.
7. When the export is complete for sales orders exported to the I856 file, the I856 Select flag will be set to off automatically, and the I856 Status flag will be set to on.
* When the I856 Status flag is set to on, it indicates that the sales order has been previously exported. You can export sales orders with the I856 Status flag set to on.
8. When the export is complete for sales orders exported to the I810 file, the I810 Select flag will be set to off automatically, and the I810 Status flag will be set to on.
* When the I810 Status flag is set to on, it indicates that the sales order has been previously exported. You can export sales orders with the I810 Status flag set to on.
Press this button to select the desired directory and file to which the sales orders will be exported.
Press this button over the I856 Select flags to set the flag to off for all displayed sales orders.
Press this button over the I810 Select flags to set the flag to off for all displayed sales orders.
These flags can be set to on manually for individual sales orders after the button has been pressed.
Press this button over the I856 Select flags to set the flag to on for all displayed sales orders.
Press this button over the I810 Select flags to set the flag to on for all displayed sales orders.
These flags can be set to off manually for individual sales orders after the button has been pressed.
Press this button to export the selected sales orders to the defined flat files.