Subledger invoice

When the interface records are generated from the incoming interface files into IP1; this program can be used to post the transactions to either AR, AP or G/L.

  1. In the menu, expand Base Modules > Other options > Data Interfaces > DSR and double-click Sales Report Posting. DSO400 Subledger Invoice panel appears. 
  2. Enter the following information, as required.
Field Description
Company Select the company to be used.
Mode Select the mode to be used. Mode can either be Trial or Post. Post will post the transactions to AR and AP.
System Select the sub-ledger system for the interface. These are defined in control file TMSGL/SUBLSYS.
Transaction type Select the sub-ledger transaction type for the selected sub-ledger system. Transaction types are defined in control file TMSGL/SUBLTRN.
  1. Click OK to post the transactions.

Subledger invoice consolidation and posting

When the interface records are generated from the incoming interface files into IP1; this program can be used to consolidate the invoices/credits into a single invoice/credit note before posting it.

  1. In the menu, expand Base Modules > Other options > Data Interfaces > DSR and double-click Sales Report Posting Consolidated. DSO400 Subledger Invoice panel appears. 
  2. Enter the following information, as required.
Field Description
Report ID Select the Report ID to identify the type of sales transactions.
Mode Select the mode ‘Consolidate and Post‘ to allow all transactions for the specified document type to be consolidated into a single document and posted.
Document type You can select to consolidate & post only invoices or only credits or both. 
  1. Click OK to consolidate and post the interface records.