Information Systems:Auditors Accounts Receivable - Revision history

Norwinu at 17:15, 15 July 2016

2016-07-15T17:15:22Z

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

Sheilav at 19:02, 27 January 2016

2016-01-27T19:02:47Z

Sheilav at 18:42, 27 January 2016

2016-01-27T18:42:55Z

Sheilav at 18:42, 27 January 2016

2016-01-27T18:42:34Z

Sheilav: Created page with "Go to InfoNet / Finance / Summarize / Extract A/R transactions. File:audit-1.jpg"

2016-01-27T18:39:31Z

Created page with "Go to InfoNet / Finance / Summarize / Extract A/R transactions. File:audit-1.jpg"

New page

Go to InfoNet / Finance / Summarize / Extract A/R transactions.

[[File:audit-1.jpg]]

← Older revision		Revision as of 18:42, 27 January 2016
Line 1:		Line 1:
	Go to InfoNet / Finance / Summarize / Extract A/R transactions.		Go to InfoNet / Finance / Summarize / Extract A/R transactions.
		+
		+	[[File:audit-1.jpg]]

← Older revision		Revision as of 18:42, 27 January 2016
Line 1:		Line 1:
	Go to InfoNet / Finance / Summarize / Extract A/R transactions.		Go to InfoNet / Finance / Summarize / Extract A/R transactions.
−
−
−	[[File:audit-1.jpg]]

← Older revision		Revision as of 19:02, 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.

		+	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-1.jpg]]
		+
		⚫	[[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