Electronic Data Collection Transaction Router - Calculations

A.   Housekeeping

1.   See the Common Processing Routines - Housekeeping section of this manual for a general description of this subroutine.  Processing specific to this program is described below.

2.   The company name, manufacturing company and warehouse, lot control option, and balances available for distribution are retrieved from the System Control file (CT100M).

3.   The following arrays and fields are initialized from the Reference file (REFERP).

B.   Mainline

1.   Non-Shipping Transactions

Purchase order receipts, stock transfers, inventory adjustments, manufacturing order receipts, component issues, flow receipts, deduct issues, lot issues, unplanned usage, and shop floor transactions are routed without any further validation being performed.

2.   For labor and machine transactions, the Reference File (REFERP) category C11 is checked to see if the transactions specify a time range or a number of hours. 

This allows the router to place the records in the appropriate files.  Aside from this category check, no other validation is performed for labor and machine transactions.

3.   Shipping Transactions

a.   Header fields are validated first.  These include the following:  order number, release number and shipment number.  Record should exists in shipment master file and in shipment picker line master file.  In batch mode, shipment status should either be open or ready while in called mode, status should be either confirmed or in process.  If these fields are valid, other field validation is performed for company/warehouse, user authorization to the co/whs, order type, order status, customer name, document type, GL company and location, currency code, exchange rate, VAT information, state tax code, county tax code and city tax code.  If all fields are valid, each order shipment selected must be logically locked.  This locking logic is bypassed in "called" mode.  If this is successful, book code is validated and if document type is cash, cash account number assignment and discount account number assignment are performed.  Customer master record is also locked.

b.   Upon completion of the header validation, key maintenance line fields are validated.  Next, reference and non-reference part validation occurs.  Fields validated include the shipped quantity, ship unit of measure, stock location, balance type, and lot number.  This validation occurs for both add and change transactions.

c.   Once a record is found to be valid, the header, line, discount detail, comment, and line location workfiles are written.  Before this is done, however, the following functions are performed:  pricing, costing, gross margin checking, tax processing, weight and volume calculations, and unit of measure conversions.  For changes, inventory update calculations are performed.

d.   After the workfiles are written, the valid record is deleted from the error file, and the sales order header record is unlocked.

Note:  the line location workfile (OP120AP4) is built from sales order line location from existing sales order line/lot file.  If line status is not closed then this is considered a new shipment.  The following functions are performed:  costing, inventory update calculations, pricing, gross margin checking, tax processing and weight and volume calculations.  Header, line, discount detail workfile records are updated.  If no errors occur and if order is for a company/location that uses VAT, shipping/billing VAT detail workfile record (OP120AP5) is written.  Customer master record is updated.

In Batch mode only - note the following:

b.   Upon completion of the header validation, key maintenance line fields are validated.  Next, reference and non-reference part validation occurs.  Fields validated include the shipped quantity, ship unit of measure, stock location, balance type, and lot number.  This validation occurs for both add and change transactions.

c.   Once a record is found to be valid, the header, line, discount detail, comment, and line location workfiles are written.  Before this is done, however, the following functions are performed:  pricing, costing, gross margin checking, tax processing, weight and volume calculations, and unit of measure conversions.  For changes, inventory update calculations are performed.

d.   After the workfiles are written, the valid record is deleted from the error file, and the sales order header record is unlocked.

BC200E Program Menu

• Purpose
• Calculations
• Files
• Reports