Debugging Debtors and Creditors Reports: Difference between revisions

From Acacia Support Wiki
Jump to navigation Jump to search
(Created page with "Follow these steps to validate and debug problems with debtors and creditors reports. * Run the reconcilation ** Check that the total "Outstanding" amount matches: *** Credito...")
 
No edit summary
Line 1: Line 1:
Follow these steps to validate and debug problems with debtors and creditors reports.
Follow these steps to validate and debug problems with debtors and creditors reports.
* Check that totals of bill/invoice header and line balances match each other. 
** If they don't match, find specific transactions that do not match and review the data.  The calculation of balance on either the header or the line may be incorrect.
* Run the reconcilation
* Run the reconcilation
** Check that the total "Outstanding" amount matches:
** Check that the total "Outstanding" amount matches:
*** Creditors: The sum of balances on bill headers/lines including -ve balances for credit notes.
*** Creditors: The sum of balances on bill headers/lines including -ve balances for credit notes.
*** Debtors: The sum of balances on invoice headers/lines including -ve balances for credit notes.
*** Debtors: The sum of balances on invoice headers/lines including -ve balances for credit notes.

Revision as of 08:36, 16 March 2021

Follow these steps to validate and debug problems with debtors and creditors reports.

  • Check that totals of bill/invoice header and line balances match each other.
    • If they don't match, find specific transactions that do not match and review the data. The calculation of balance on either the header or the line may be incorrect.
  • Run the reconcilation
    • Check that the total "Outstanding" amount matches:
      • Creditors: The sum of balances on bill headers/lines including -ve balances for credit notes.
      • Debtors: The sum of balances on invoice headers/lines including -ve balances for credit notes.