BL123 - Sub-System Update This program updates the status of invoices and credit memos that have been printed. The following updates take place. Invoices are interfaced into the Accounts Receivable system. You run AR560 (Transaction Interface) to update the Accounts Receivable database. Secondly, journal entries are created (in detail): Sales Discounts Freight Inventory (for returns) Miscellaneous charges Sales tax Cost of Goods Sold Accounts receivable The Order Entry Distribution file is updated and used by BL293 (GL Distribution Report) to list journal entries created by the system. Updated Files ARCODE - Used to validate Accounts Receivable codes. If this is the first time the Accounts Receivable code is referenced, the used flag is set. ARIDISTRIB - ARIITEM - Used in the customer edit routine. ARITRANS - Primary updated by this program. Accounts Receivable invoices are stored in this file. ARPROCLEVL - Used to validate the Accounts Receivable process level. If this is the first time the process level is referenced, the used flag is set. CKPOINT - Used to control program restart logic. JBOOKHDR - OECOMPANY - Used to validate the Billing company. OEDIST - Primary file updated by this program. Billing distribution records are created. OEINVOICE - Invoice status is updated to Ready To Purge after processing by this program. OEINVSGBLK - Stores user analysis values for processing through the Strategic Ledger system. OEPROCLEV - Used to validate the Billing process level. SYSTEMCODE - Used by the General Ledger system edit routine. TXCODEMAST - Stores tax codes, descriptions, and tax types that define how the tax code is used. TXCOMPANY - Stores company information and which tax system the company uses. Includes general ledger accounts if they are defined at the company level. TXTAXCODE - Used to validate tax codes. Also provides General Ledger account for sales tax postings. Referenced Files AGINGCODE - Used in the Accounts Receivable customer edit routine. APACCRCODE - Used in the vendor edit routine. ARCOMP - Used to validate the Accounts Receivable company. ARCUSTFLDS - Used in the Accounts Receivable customer edit routine. ARCUSTGRP - Used in the Accounts Receivable customer edit routine. ARCUSTOMER - Used to validate the Accounts Receivable customer. ARCUSTTOTS - Used in the Accounts Receivable customer edit routine. ARLOCKBOX - Used in the Accounts Receivable customer edit routine. AROITEMS - Used in the Accounts Receivable customer edit routine. ARPAYMENT - Used in the Accounts Receivable customer edit routine. COCOMP - Used to store components for a shipment line if the item shipped is a kit. CUSTDESC - Used in the Accounts Receivable customer edit routine. CUSTORDER - Used to print customer order information. GLADDRESS - Used in General Ledger account edit routine. GLCHART - Used in the General Ledger account verification routine. GLSYSTEM - Used in the General Ledger account edit routine. ICCATEGORY - Used to obtain inventory account for stock lines. ICCOMPANY - Used to validate the Inventory Control company. INSTCTRYCD - Used to validate the Intrastat country code. ITEMLOC - Used to validate the Inventory Control item location. ITEMMAST - Used to validate Inventory Control item numbers. JBKOPCODE - JBKSYSCODE - NATACCT - Used in the Accounts Receivable customer edit routine. NATBALANCE - Used in the Accounts Receivable customer edit routine. OECREDCARD - Used to validate credit card types. OECUST - Used in the Accounts Receivable customer edit routine. OECUSTITEM - Used to store customer item numbers for Inventory Control item numbers. OEFRTCODE - Used to validate freight codes. OEINVCLINE - Used to print invoice line information. OEINVCMISC - Used to print invoice add-on charge information. OEINVCTAX - Used to print invoice sales tax information. OEINVCTYPE - Used to validate invoice types. OEMISC - Used to validate add-on charges. OEORDDISC - Used to validate order discount codes. OESLSACCT - Used to obtain sales and cost of goods sold accounts for stock and non-stock invoice lines, and cost of goods offset account for non-stock lines. STATICCUST - Used in the Accounts Receivable customer edit routine. TXTAXRATE - Used in the tax code edit routine. TXTAXTABLE - Used in the tax code edit routine. WHSHIPCOMP - Used to store the make-to-order kit components to be shipped for this ship line. WHSHIPLINE - Used to store shipline information including feedback quantity. INVOKED Programs IFAC ACAC IFCR IFSG IFCU IFAU SLSE SLSU IFFC IFGT IFCC IFOB IFRS IFSC SLSB SLTV SLFD |