Troubleshooting improper Trade Debtor/Creditor entries (Aging).

Troubleshooting improper Trade Debtor/Creditor entries (Aging).

  1. Understanding the different Aging reports. 
    1. Standard Aging Reports
      1. the standard aging reports only includes properly created entries.
      2. a proper entry is a entry a entry that affected a trade debtor/creditor account that has a BP code and document number
    2. Legacy Aging Reports
      1. the legacy report include all entries that affect the trade debtor/creditor accounts.
      2. these report gave users the false impression that their entries properly done.

    4. since the legacy reports show all, we can use the reports to help identify entries that have issues.
  2. Using the Legacy report to find entries with missing BP
    1. use either of the legacy report to generate the aging. search for entries similar to the screenshot below.

    3. in the report entries with no BP will appear with just a dash.
    4. since these entries have no BP and document, you'll need to specify both or change the account to a non trade debtor/creditor type account (You should consult your accountant /auditor on which account to use.)
  3. Using Legacy report to fine entries with missing document
    1. use either of the legacy report to generate the aging. seach for entries similar to the screenshot below.

    3. entries with missing document will show up as the Journal Entries.
    4. you'll need to specify the document in the JE. note if the document does not show up when clicking on document column. tick the display document with no outstanding.

  4. Using Standard report to find entries with outstanding accounting currency.
    1. use the aging report with transaction currency.

    3. entries that appear with zero value are entries that have zero transaction currency value but have left over accounting currency value.
    4. common causes are users editing the invoice after importing to the voucher or users editing the accounting currency on the voucher.  these actions override the system's built in action to ensure that when the transaction currency is zero the account currency is zero.
    5. to fix you'll can manually create a JE to move the accounting currency to the exchange gain/loss account or reimport the invoice into the voucher.
    6. if you are choosing to reimport the voucher, you will need to do the action on the existing voucher. 
      1. copy any description you have type.
      2. remove the invoice from the voucher.
      3. import the invoice back in. paste back the description( if any)

    • Related Articles

    • Improper knock off

      Improper knock off occurs when using the Journal Entry module and the entries are improperly created. Sample of incorrect entry. the Trade Debtor row has a Business Partner selected but no document is selected. With no document specified, this ...

    • Payment Voucher trade related

      3.2.2 Payment Voucher 3.2.2.1   Trade Related Location Action Remark PURCHASES> PAYMENT  Click PURCHASES    Click PAYMENT     Click NEW  PAYEE select       Interesting Supplier PteLtd  Click IMPORT  Click DOCUMENT OUTSTANDING  ...

    • Viewing Transaction GL Entries

      4.1 DETAILS TRACING 4.1.1 Viewing Transaction GL Entries General Ledger (GL) entries can be found in all the modules in Sales and Purchases activities, except for Quotation, Delivery Order and Purchase Order Module Location Action Remark SALES> ...

    • Payment Voucher non trade related

      3.2.2.2 Non-Trade Related Location Action Remark PURCHASES> PAYMENT  Click Purchases activity  Click Payment module  Click NEW  PAYEE TYPE click  Non-Trade  PAYEE enter  Singtel  ACCOUNT select  EXP4001  DESCRIPTION enter  Bill No.1234  ...

    • Check if Opening Entries are Correct

      2.1.2 Check if Opening entries are correct Location Action Remark Setup Adjustment> Opening Adjustment Check module  Click ADJUSTMENT activity  Click OPENING  Click OPENING ADJ CHECK module  Click REFRESH To check that you have correctly entered ...