Information Systems:Finance - Revision history

Sheilav at 23:20, 25 November 2015

2015-11-25T23:20:30Z

Sheilav at 21:38, 20 November 2015

2015-11-20T21:38:19Z

172.30.19.104: Replaced content with " =Cannot Close Period= =A/R Reconciliation not in Balance= =Cannot Use A/P Payment Proposal= =Journal in Error= =G/L Balances do Not Roll Over= =Cannot Close Cash..."

2015-10-19T17:24:45Z

Replaced content with " =Cannot Close Period= =A/R Reconciliation not in Balance= =Cannot Use A/P Payment Proposal= =Journal in Error= =G/L Balances do Not Roll Over= =Cannot Close Cash..."

Show changes

172.30.19.104 at 17:10, 19 October 2015

2015-10-19T17:10:06Z

Sheilav at 17:08, 19 October 2015

2015-10-19T17:08:54Z

Sheilav at 17:06, 19 October 2015

2015-10-19T17:06:51Z

172.30.19.104: /* Entry Generated Incorrectly */

2015-10-19T16:46:22Z

Entry Generated Incorrectly

172.30.19.104: /* Debit / Credit Card Transactions */

2015-10-19T16:46:06Z

Debit / Credit Card Transactions

172.30.19.104: /* Out of Balance */

2015-10-19T16:45:40Z

Out of Balance

Sheilav: /* Rebuild the ‘KPMG statement section’ */

2015-10-16T22:48:20Z

Rebuild the ‘KPMG statement section’

← Older revision		Revision as of 23:20, 25 November 2015
Line 1:		Line 1:
	* [[Company consolidation]]		* [[Company consolidation]]
	* [[Upload Budget from Spreadsheet]]		* [[Upload Budget from Spreadsheet]]
		+	* [[Balance Unmatched Purchase Orders]]

← Older revision		Revision as of 21:38, 20 November 2015
Line 1:		Line 1:
		+	* [[Company consolidation]]
−
		+	* [[Upload Budget from Spreadsheet]]
−
−	=Cannot Close Period=
−
−
−	=A/R Reconciliation not in Balance=
−
−
−	=Cannot Use A/P Payment Proposal=
−
−	=Journal in Error=
−
−	=G/L Balances do Not Roll Over=
−
−	=Cannot Close Cash Book Batch=
−
−
−	=Change Document Date=
−	=Rounding Error in Goods Receiving File=
−
−
−
−	=Unmatched Purchase Orders Not in Balance=
−
−	=Problem with EFT Batch=
−
−
−	=Cannot Add to Standing Order=

← Older revision		Revision as of 17:10, 19 October 2015
Line 1:		Line 1:
−	* [[Cannot Close Period]]
−	* [[A/R Reconciliation Not in Balance]]
−	* [[Cannot Use A/P Payment Proposal]]
−	* [[Journal in Error]]
−	* [[G/L Balances do Not Roll Over]]
−	* [[Cash Book Not in Balance]]
−	* [[Cannot Close Cash Book]]
−	* [[Change Document Date]]
−	* [[Rounding Error in Goods Receiving File]]
−	* [[Unmatched Purchase Orders Not in Balance]]

← Older revision		Revision as of 17:08, 19 October 2015
Line 8:		Line 8:
	* [[Change Document Date]]		* [[Change Document Date]]
	* [[Rounding Error in Goods Receiving File]]		* [[Rounding Error in Goods Receiving File]]
		+	* [[Unmatched Purchase Orders Not in Balance]]

← Older revision		Revision as of 17:06, 19 October 2015
Line 1:		Line 1:
		+	* [[Cannot Close Period]]
		+	* [[A/R Reconciliation Not in Balance]]
		+	* [[Cannot Use A/P Payment Proposal]]
		+	* [[Journal in Error]]
		+	* [[G/L Balances do Not Roll Over]]
		+	* [[Cash Book Not in Balance]]
		+	* [[Cannot Close Cash Book]]
		+	* [[Change Document Date]]
		+	* [[Rounding Error in Goods Receiving File]]
		+
		+
	=Cannot Close Period=		=Cannot Close Period=

@@ Line 451: / Line 451: @@
 Force the out of balance journal to post – not as FINADMIN – to put the out of balance amount to 730200.  (See [[Finance#Manually Post Batch]] for instructions.)  Then manually transfer from 730200 to the correct bank.
-===Entry Generated Incorrectly===
+==Entry Generated Incorrectly==
 G/L entries are automatically generated by sales, receiving, and transactions in the warehouse.  To see how this is done, look at the section ‘Generated Journal Entries’.

@@ Line 369: / Line 369: @@
  Credit		5.00		730200	Out of Balance
-==Debit / Credit Card Transactions==
+===Debit / Credit Card Transactions===
 Transactions through the debit / credit card machines in our shareholder stores come to us; we then apply them against the stores’ accounts receivable.

@@ Line 137: / Line 137: @@
 This is a problem with the EDI data received (document type EIN is an EDI invoice).  The correction is to take the minus sign off of the VAT (European terminology for tax).  Then go to the section ‘Manually Post Batch’)’
-=Out of Balance=
+==Out of Balance==
 If there are no invalid transactions, press F3 to see the totals.
@@ Line 153: / Line 153: @@
 So far, we have had two different reasons for a journal to be out of balance; when the tax status has been changed, or when processing credit card transactions has failed.
-==Sales Tax==
+===Sales Tax===
 Base ASW (at least the version modified for the US) has different levels of tax (state, county, etc) but they all add to one bucket – both when they print on the invoice, and add to the G/L.  We need to keep provincial and federal taxes separate.  We have modified DMR343 (invoice generation) to recalculate the individual sales taxes.  Very occasionally, when it does this, it does not agree with total tax amount previously calculated by ASW.  Which means the detail taxes that print on the bottom of the invoice, and the journal entries created, do not add up to the invoice total.  This happens so rarely, and the program is so complex, that I have been fixing the symptoms rather than fixing the source of the problem.
@@ Line 451: / Line 451: @@
 Force the out of balance journal to post – not as FINADMIN – to put the out of balance amount to 730200.  (See [[Finance#Manually Post Batch]] for instructions.)  Then manually transfer from 730200 to the correct bank.
-==Entry Generated Incorrectly==
+===Entry Generated Incorrectly===
 G/L entries are automatically generated by sales, receiving, and transactions in the warehouse.  To see how this is done, look at the section ‘Generated Journal Entries’.

@@ Line 1,075: / Line 1,075: @@
  Cost Center Group 2.    N
  KPMG stmt section...    N
-−
                      NO SUMMARY IDENTITY HAVE BEEN CHANGED
                           THIS JOB WILL BE CANCELLED
-−
 If this process will not run, because no changes have been made, you can force it by setting the changed flag to ‘Y’ in G/L Control File Maintenance.