Difference between revisions of "Information Systems:Auditors - Accounts Receivable"
Jump to navigation
Jump to search
m |
|||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 3: | Line 3: | ||
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. |
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. |
||
| − | [[File: |
+ | [[File:Audit-2.jpg]] |
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. |
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. |
||
| − | [[File: |
+ | [[File:Audit-3.jpg]] |
| Line 23: | Line 23: | ||
120000 7500203 040108 75 13.01 0903 |
120000 7500203 040108 75 13.01 0903 |
||
| − | If it doesn't, the [[A/R Reconciliation Not in Balance|Analyser file will have to be rebuilt]] |
+ | If it doesn't, the [[A/R Reconciliation Not in Balance|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! |
||
| + | |||
| + | [[Category: Auditors - I.T.]] |
||
Latest revision as of 11:50, 3 November 2016
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!