ISTech Support Forum - A/P & A/R Agings Do Not Match Balance Sheet

Doughmakers Browser Posts: 12	A/P & A/R Agings Do Not Match Balance Sheet 10/04/06 at 09:13:02 Since I can remember, our agings have not matched our balance sheet. The differences vary from month to month. We don't enter anything into the master A/P or A/R accounts, so I don't understand how the Balance Sheet could be out of balance with the agings. I need to know why this could be happening and how I could fix it.
Back to top	Cindy Ellis Doughmakers Gourmet Bakeware IP Logged

JNAPIER Active Member Evil-Evo Bad Dog! Posts: 533 Gender:	Re: A/P & A/R Agings Do Not Match Balance Shee Reply #1 - 10/04/06 at 10:01:59 I have seen this when an entry has a future date, either Ap or AR. Print your agings as of 01-01-2010 or something like that. Make certain that all GL-O transactions have been posted also... John
Back to top	EVO-ERP, ISTS 3.27.08 , 2000I 10 user IP Logged

Lynn_Pantic

Administrator

evolution (n) -
gradual change to a
different form

Posts: 5663

Re: A/P & A/R Agings Do Not Match Balance Shee
Reply #2 - 10/04/06 at 11:46:17

Also, for AR, make sure you are saying N to include Deposits as they belong to a different GL Account (Customer Seposits).

And check AD-A and AD-B and Item classes to be sure nothing else is posting there.

Finally, make sure nobody is entering the AR or AP account as the distribution account when entering vouchers.

Back to top

Lynn Pantic
IS Tech Support
lynn@istechsupport.com

IP Logged

wtsconnects

Full Member

Posts: 113
Gender: female

Re: A/P & A/R Agings Do Not Match Balance Shee
Reply #3 - 10/04/06 at 13:56:48

We share this issue. Have been for a long time too. (I posted another set of problems today which came up as we were investigating this one.)

Based on some of my research of discussions, I'm wondering if non-matching problem is at all related to the issues of reversing recorded payments and the screwy postings that often happens.

Any thoughts?

Back to top

Jackie O.
WTS Connects
DBA Classic 2004.1
IStech update 6/20/05
Workgroup Server NT4.0

IP Logged

wtsconnects

Full Member

Posts: 113
Gender: female

Re: A/P & A/R Agings Do Not Match Balance Shee
Reply #4 - 10/04/06 at 13:59:27

We share this issue. Have been for a long time too. (I posted another set of problems today which came up as we were investigating this one.)

Based on some of my research of discussions, I'm wondering if non-matching problem is at all related to the issues of reversing recorded payments and the screwy postings that often happens.

Any thoughts?

Back to top

Jackie O.
WTS Connects
DBA Classic 2004.1
IStech update 6/20/05
Workgroup Server NT4.0

IP Logged

Doughmakers Browser Posts: 12	Re: A/P & A/R Agings Do Not Match Balance Shee Reply #5 - 10/05/06 at 06:43:32 I have checked the AD-A and the AD-B defaults and they look fine. I also printed the agings without the deposits. No one has entered anything into the AP or AR accounts. I have already ran detail reports af those accounts to check for that possibility. What else could it be?????
Back to top	Cindy Ellis Doughmakers Gourmet Bakeware IP Logged

wontonsnowy

Browser

I love YaBB 1G -
SP1!

Posts: 9

Re: A/P & A/R Agings Do Not Match Balance Sheet
Reply #6 - 02/22/07 at 07:58:39

I've also experienced the same problem - it could be from voiding cks - i have items showing up on the aged ap that you can not see in the AP-F . Try manually checking your open AP against your physical invoices to verify that all is truely open that appear on the aged AP. you may find your answer there. Good luck

Back to top

IP Logged