Billing Update

The Billing Program (IC110E) is called by the Print and Process Invoices option on the Invoice Processing Menu in Future Three.  This program may be run more than once a day. When this batch process is run, Billing File (IC110AP1) transactions are generated for each invoice detail line processed.

Future Three formats a Sequence Number field on IC110AP1 that is the same as the sequence field formatted on the Forecast Shipment Transaction File (IC140AP1) for each corresponding Forecast Shipment File transaction.  For those transactions on IC110AP1 that do not have a corresponding transaction on IC140AP1, Future Three formats a new sequence number in the Sequence Number field on IC110AP1.

Future Three calculates the extended price for each detail line and formats the amount on IC110AP1.  The company and warehouse fields on the file are formatted (left-justified) from the company and warehouse fields on Future Three's Part X-REF File.  The stock location field is formatted from the Shipped Location field on the Part X-REF File.

Once all invoices have been generated by Future Three and all IC110AP1 transactions have been written, Future Three calls the Billing Program (IC110E) to process the transactions in IC110AP1.

The Billing Program (IC110E) performs several functions:

·     Validates all data for each EDI billing transaction on IC110AP1.

·     Prints all invalid transactions on an error report and formats an error field on IC110AP1 with a code identifying that record as having fields in error.

·     Validates that a corresponding forecast shipment transaction exists on IC140AP1.  If one does not exist, the error field is formatted on IC110AP1 with a different error code signifying that inventory updates for the item have not yet been done.  However, the IC110AP1 record should still be processed by IC110E.

·     Checks the Process Non-Release flag on Reference File category D26.  If the field has a value of Y, then the EDI Bill Transaction is processed normally.  If the field has a value of N, then inventory and Sales History processing is bypassed, however, the front end files (ARORDHP and ARORDDP) for the Batch Open Item Post Program are updated.

·     If the transaction does have a corresponding record on IC140AP1 or has a record on IC140AP1 for the same shipper number, company, warehouse, part number, and date, the unit cost is retrieved from the item for IC140AP1.  Otherwise, the unit cost is calculated from the item.

·     Formats all fields on the Sales History File (OP120M) and writes if the transaction on IC110AP1 is valid.

·     Formats all fields on the front-end files for the Batch Open Item Post Program (ARORDHP and ARORDDP) and writes if the transaction on IC110AP1 is valid.  The invoice document number will be the shipper number unless that number has already been used as a MAC-PAC invoice number.  If the number has already been used, a document number is automatically assigned from MAC-PAC Reference File category 440.

·     After all lines for an invoice have been processed, checks Reference File category 432 to determine if customer statistics on the Customer Name and Address File should be updated.  The default inventory adjustment code on Reference File category D26 is used to access category 432.  If the update customer statistics flag on category 432 is equal to Y, the statistics are updated.

·     Writes all valid transactions processed on a valid transactions report.

IC110E deletes IC140AP1 transactions as their corresponding transactions in IC110AP1 are processed.  Once all transactions on IC110AP1 have been processed, IC110AP1 is cleared.

The Batch Open Item Post Program (AR090P) can be called at some later time (for example, in the nightly batch runs) to post the open items to MAC-PAC's open item files.