Programs that Post Interfacing Transactions to the G/L:

The following programs post interfacing transactions into the General Ledger:

Account Payable

AP31 for invoice distributions and receipts accrual reduction. GL control accounts:

    - CC00/Accounts Payable    GST input tax credit
    - AP01    Accounts Payable, Bank, Discount, Exchange
    - IN01    GST per 'GB' record
    - CC00/Purchasing    Receipts Accrual, Receipts Variance

AP36 for cancelled accrued receipts. GL control account:

    - CC00/Purchasing    Receipts Accrual
    - offsetting account entered by operator

AP43 for computer cheques. GL control accounts per AP01.

AP51 for manual cheques. GL control accounts per AP01.

AP81 for cancelled cheques. GL control accounts per AP01.

Accounts Receibable

AR31 for daily cash receipts. GL control accounts:

    - AR02    Accounts Receivable, Bank, Discount
    - CC00/Accounts Receivable    Interest, GST Input Tax Credit

General Ledger

GL31 for journal entries entered via program GL30.

GL80 for standard journals defined via program GL20.

GL81 for Final M/E report for reversing accrual entries.

  • Note: If any subsystems have generated postings to "xyz" accounts, then to clean up those postings you must set up the 'dummy' GL accounts via GL01 and then transfer the balance out of the "xyz" account into the proper account via GL30.

GL82 for standard allocations defined via program GL25.

GL90 for year end closing entries. Control account for Retained Earnings per CC00/General Ledger.

Invoicing

IN44 for sales invoices. GL control accounts:

    - AR02    Accounts Receivable
    - CC00/Invoicing/General Ledger    Sales, COS, Inventory
    - IN01    Supplementary Charges

IN44 for warehouse in-transit transfers. GL control accounts:

    - CC00/Invoicing    In-Transit Clearing
    - CC00/Invoicing/General Ledger    Inventory

IN44 for any non-standard transactions coded with a special TAT code that defines override Inventory and COS control accounts in IN02. (ie, consignments, internal invoices, credits for defective mdse, etc.)

IN44 for 'real' service charges. GL control account per I
 N01 (Supp. Charge record for Interest)

Note: If no 'hit' in CC00/Invoicing/General Ledger table, program will generate distributions to GL accounts that look like this:

    "xxx....." for Sales
    "yyy....." for COS
    "zzz....." for Inventory

Inventory Control

IC51 for adjustments set up for GL interfacing in program IM44.

Note: If no 'hit' in CC00/Invoicing/General Ledger table, program will generate distributions to GL accounts that look like this:

    "xxx....." for offsetting adjustment account
    "yyy....." for Inventory

IC56 for receipt of whse transfers processed through invoicing cycle with TAT code "WHS".

    - CC00/Invoicing    In-Transit Clearing, Freight Clearing
    - CC00/Invoicing/General Ledger    Inventory

Purchasing

PO64 for receipts accrual interface. GL control accounts:

    - CC00/Purchasing/General Ledger    Inventory
    - CC00/Purchasing    Receipts Accrual
    - PO09/Landing Factors    Landing Charges, Variance on Landing Charges

Note: If no 'hit' in CC00-Purchasing/General Ledger table, program PO64 will generate distributions to a GL account that looks like this:

    "zzz....." for Inventory

Physical Inventory

PI19 for variances between booked and counted inventory.

    - IM44    for adjustment code "P"

Note: Program PI18 reports the GL postings but they do not get posted until PI19 is processed. If no 'hit' in IM44, program PI18 will report/PI19 will post distributions to GL accounts that look like this:

    "www....." for offsetting adjustment account
    "zzz....." for Inventory

 
Back