Home · Online Publications · Journal of Accountancy · Online Issues · March 1998 · Technology · Exhibit 4 Search Feedback


Technology

Guide to Accounting Software


Exhibit 4: Reference Data in Ledger Accounts for Tracing to Source Journal
  Information provided to trace from
Accounting software poroduct general ledger to general journal sales entry in accounts receivable ledger to the sales journal cash receipt entry in accounts receivable to cash receipts journal purchase entry in accounts payable ledger to purchases journal inventory receipt in inventory ledger to purchases journal inventory issuance in inventory ledger to sales journal
ACCPAC Source codes Posting sequence, batch number and/or entry number Posting sequence, batch number and/or entry number Day-end number Day-end number Day-end number
Great Plains Dynamics Journal entry number Document number Document number Document number Receipt number Receipt number
Impact Encore Journal number Invoice number Check number and/or reference number Invoice number and/or goods received note number Goods received note number and/or purchase order (PO) number Invoice number
MAS 90 Source journal code Invoice number Check number and/or date Receipt number and/or date Receipt number and/or date Source journal number and/or date
Progression Source code Drill down Drill down Drill down Lot number Lot number
SBT Pro Batch number and/or transaction number Batch number, customer number and/or invoice number Batch number, customer number and/or invoice number Batch number, vendor number and/or voucher number Inventory control transaction file has field with PO number and sales order number. The inventory control journal has the transaction number.
Solomon Journal type, batch number, reference number and/or date Invoice number, order number, order type, date and/or transaction type Reference number, transaction type and/or date Reference number, document type, vendor invoice number and/or date In inventory trial balance, look for receiving report with reference number. In PO screen, enter PO number or receipt number. In trial balance, look for invoice reference number, then go to sales journal to look up with F3 key the invoice number.
Traverse Entry number Invoice number Receipt number Invoice number Receipt number Invoice number
Visual Accounting Batch number, user, time and/or date Customer number and/or invoice number Customer number and/or check number Vendor number and/or invoice number PO number and/or vendor number Customer number and/or invoice number

Back
©1999 AICPA