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 ...

    • 7.0. Opening Adjustment Check

      Opening Adjustment Check The Opening Adj. Check module is for checking that the Opening Entry has been completed correctly. Ensure that the following amounts match up: Opening Invoice total with Trade Debtors account(s) Opening Supplier Invoice total ...

    • Trial Balance/General Ledger values not matching with Ageing values.

      When comparing the Trial Balance values against Ageing, we are looking at the Trade Debtor/Creditor accounts. Ageing Report In order for the report to generate values, the Trade Debtor/Creditor accounts needs to have the following information. 'Who' ...

    • 1.0. Opening Entry Overview

      Opening Entry Opening entries are essential for transitioning financial data into the new system accurately. They align general ledger balances, outstanding AR/AP documents, and inventory as of a chosen, audited date. This process ensures the ...

    • 9.0. Accounts Payable in Foreign Multi Currency

      Making a USD deposit to Supplier STEPS: AMOUNT enter 1,000 USD BANK RATE check if it’s 1 PAYMENT AMOUNT check for 1,000 Click ADD Close module STEPS: Click REPORT activity Click AR/AP Click STATEMENT OF ACCOUNT module BUSINESS PARTNER select ...