Information Systems:Auditors - Accounts Receivable - Revision history

Norwinu at 18:50, 3 November 2016

2016-11-03T18:50:54Z

Norwinu at 18:50, 3 November 2016

2016-11-03T18:50:36Z

Norwinu at 17:07, 15 July 2016

2016-07-15T17:07:00Z

New page

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.

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

[[File:Audit-3.jpg]]

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 [[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!

Sheilav at 19:46, 27 January 2016

2016-01-27T19:46:35Z

Sheilav at 19:11, 27 January 2016

2016-01-27T19:11:10Z

Sheilav at 19:06, 27 January 2016

2016-01-27T19:06:35Z

Sheilav: Created page with "We want an Excel file of debtor number, name, account type, and balance as of the fiscal year end. Go to InfoNet / Finance / Summarize / Extract A/R transactions. An account..."

2016-01-27T19:04:47Z

Created page with "We want an Excel file of debtor number, name, account type, and balance as of the fiscal year end. Go to InfoNet / Finance / Summarize / Extract A/R transactions. An account..."

New page

We want an Excel file of debtor number, name, account type, and balance as of the fiscal year end.

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. The 'Remaining Amount' on this display is only correct for the current moment.

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

[[File:audit-3.jpg]]

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

← Older revision		Revision as of 18:50, 3 November 2016
Line 27:		Line 27:
	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!		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]]	+	[[Category: Auditors - I.T.]]

← Older revision		Revision as of 18:50, 3 November 2016
Line 26:		Line 26:

	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!		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]]

← Older revision		Revision as of 19:46, 27 January 2016
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!

← Older revision		Revision as of 19:06, 27 January 2016
Line 1:		Line 1:
−	We want an Excel file of debtor number, name, account type, and balance as of the fiscal year end.
−
	Go to InfoNet / Finance / Summarize / Extract A/R transactions.		Go to InfoNet / Finance / Summarize / Extract A/R transactions.

@@ Line 1: / Line 1: @@
 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.  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:audit-2.jpg]]
@@ Line 8: / Line 8: @@
 [[File:audit-3.jpg]]
 The total 'Original Amount' should agree with the G/L.
@@ Line 21: / Line 22: @@
 7500203 040108 75        3371.32-  0903
 7500203 040108 75          13.01   0903