Information Systems:Auditors - Accounts Payable - Revision history

Norwinu at 17:06, 15 July 2016

2016-07-15T17:06:29Z

New page

Go to InfoNet / Finance / Summarize/Extract A/P 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-4.jpg]]

Key in a starting fiscal period that is older than any accounts payable transaction, and for ending period, the period for which you want the balance. Summarize by supplier (we are not using 'payee'), and do not include preliminary invoices. Click on the search button.

[[File:Audit-5.jpg]]

The total 'Original Amount' should agree with the G/L.

*VA/480B* G/L transaction enquiry 1/27/16 12:27:57 FMR01702
-------------------------------------------------------------------------------
Rec. Bal.per/amount 1512 6426526.10- CAD Total sel.
-------------------------------------------------------------------------------
Main Grou Subg Cost Pro Vou no Vou dt Vt System Amount Per
210000 6000005 040108 76 44302.47 0903
210000 4000157 040108 40 117.67 0903
210000 4000158 040108 40 4431.39 0903
210000 4000159 040108 40 4.48- 0903
210000 4000159 040108 40 30199.31 0903

If it doesn't, the [[A/P 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 almost seven hundred thousand records!

Sheilav at 20:34, 27 January 2016

2016-01-27T20:34:10Z

Sheilav at 20:33, 27 January 2016

2016-01-27T20:33:21Z

Sheilav at 20:27, 27 January 2016

2016-01-27T20:27:12Z

Sheilav: Created page with "Go to InfoNet / Finance Summarize/Extract A/P Transactions. An account balance can be calculated for any period by summarizing all transactions up to that point. Note that t..."

2016-01-27T20:26:35Z

Created page with "Go to InfoNet / Finance Summarize/Extract A/P Transactions. An account balance can be calculated for any period by summarizing all transactions up to that point. Note that t..."

New page

Go to InfoNet / Finance Summarize/Extract A/P 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-4.jpg]]

Key in a starting fiscal period that is older than any accounts payable transaction, and for ending period, the period for which you want the balance. Summarize by supplier (we are not using 'payee'). Click on the search button.

[[File:audit-5.jpg]]

The total 'Original Amount' should agree with the G/L.

← Older revision		Revision as of 20:27, 27 January 2016
Line 1:		Line 1:
−	Go to InfoNet / Finance Summarize/Extract A/P Transactions.	+	Go to InfoNet / Finance / Summarize/Extract A/P 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.		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.

@@ Line 5: / Line 5: @@
 [[File:audit-4.jpg]]
-Key in a starting fiscal period that is older than any accounts payable transaction, and for ending period, the period for which you want the balance. Summarize by supplier (we are not using 'payee'). Click on the search button.
+Key in a starting fiscal period that is older than any accounts payable transaction, and for ending period, the period for which you want the balance. Summarize by supplier (we are not using 'payee'), and do not include preliminary invoices. Click on the search button.
 [[File:audit-5.jpg]]

← Older revision		Revision as of 20:33, 27 January 2016
Line 8:		Line 8:

	[[File:audit-5.jpg]]		[[File:audit-5.jpg]]
		+

	The total 'Original Amount' should agree with the G/L.		The total 'Original Amount' should agree with the G/L.
		+
		+	VA/480B G/L transaction enquiry 1/27/16 12:27:57 FMR01702
		+	-------------------------------------------------------------------------------
		+	Rec. Bal.per/amount 1512 6426526.10- CAD Total sel.
		+	-------------------------------------------------------------------------------
		+	Main Grou Subg Cost Pro Vou no Vou dt Vt System Amount Per
		+	210000 6000005 040108 76 44302.47 0903
		+	210000 4000157 040108 40 117.67 0903
		+	210000 4000158 040108 40 4431.39 0903
		+	210000 4000159 040108 40 4.48- 0903
		+	210000 4000159 040108 40 30199.31 0903
		+
		+	If it doesn't, the [[A/P 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 almost seven hundred thousand records!