Information Systems:Auditors - Accounts Receivable
(Redirected from Auditors - Accounts Receivable)
Jump to navigation
Jump to search
Go to InfoNet / Finance / Summarize / Extract A/R transactions.
An account balance can be calculated for any period by summarizing all transactions up to that point. Note that the 'Remaining Amount' on this display is only correct for the current moment.
Key in a starting fiscal period that is older than any accounts receivable transaction, and for ending period, the period for which you want the balance. Summarize by debtor. Click on the search button.
The total 'Original Amount' should agree with the G/L.
*VA/480B* G/L transaction enquiry 1/27/16 10:58:12 FMR01702 ------------------------------------------------------------------------------- Rec. Bal.per/amount 1512 4998385.36 CAD Total sel. ------------------------------------------------------------------------------- Main Grou Subg Cost Pro Vou no Vou dt Vt System Amount Per 120000 7500201 040108 75 172395.85- 0903 120000 7500202 040108 75 78744.50- 0903 120000 7500202 040108 75 71.84 0903 120000 7500203 040108 75 3371.32- 0903 120000 7500203 040108 75 13.01 0903
If it doesn't, the Analyser file will have to be rebuilt.
Click on 'Summary to Excel' - be careful NOT to click on 'Detail to Excel'; as of January 2016 that would be over 8 million records!