ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> System Manager >> AR & AP reports dont match GL
http://www.istechforum.com/YaBB.pl?num=1219182743

Message started by pas on 08/19/08 at 14:52:22

Title: AR & AP reports dont match GL
Post by pas on 08/19/08 at 14:52:22

Recently my A/P Aging shows a balance due to a vendor that is paid and does not match my GL. Now I have a Credit balance due to an A/R customer that has disappeared from my A/R aging & now does not match my G/L. How do I go about correcting the Aging reports? Everything else is correct, just the reports are off.

Title: Re: AR & AP reports dont match GL
Post by Dawn on 08/20/08 at 09:54:13

On your AP you may want to check that the when the check was printed it was "saved" as a printed check. I've had that happen before or it was posted to the wrong - done that too. As for the AR when I print the aging there is a Y/N for Do you want to include deposits? I always say no. If you say yes it does not match the AR aging as any deposits (AR-N) are liabilities and not an asset.

Title: Re: AR & AP reports dont match GL
Post by pas on 08/20/08 at 10:13:41

The amount is off only by by aging reports. The A/P check was saved as a printed check, and does not show as an amount due to the vendor anywhere except on the aging . The same goes for the A/R. The balance as a credit was there on last months aging. Now it is missing on the aging , but shows as a credit due on the customer account. I'm thinking I may just need to reindex the files, but DBA is very unclear how to do this.

Title: Re: AR & AP reports dont match GL
Post by Dawn on 08/20/08 at 14:32:09

Have you tried running UT-K-D. Some times that fixes things. Otherwise the last time I had a bad file I sent it to Bill and he sent it back fixed.

Title: Re: AR & AP reports dont match GL
Post by pas on 08/21/08 at 10:05:34

I tried UT-K-D and no luck. I have also tried to reindex just the A/P Files amd no luck.
The A/P aging is showing 2 check numbers that have been paid and posted to the check register as the invoice #. These two check numbers are showing on the aging only as unpaid invoices. Does anyone know with file I might try to re index the aging file? Again the balance due to the vendor is 0.

Title: Re: AR & AP reports dont match GL
Post by Dawn on 08/22/08 at 08:15:34

The AP file is BKAPINVT and the check file is BKAPCHKF. I would suggest you make a test copy first and try it in there before doing it live. If that doesn't work I am at a loss. Contact Lynn or Bill directly for help. Sorry I couldn't help more. :-/

Title: Re: AR & AP reports dont match GL
Post by Lynn_Pantic on 08/22/08 at 17:08:04

Actually, the 2 files to look at are BKAPINVT & BKAPCHKH. The invoice is in BKAPINVT and the corresponding payments in BKAPCHKH. If they get out of synch, you can see things on the Aging that are actually paid. Reindexing alone will probably not correct it; you will need some behind the scenes manipulation.

Title: Re: AR & AP reports dont match GL
Post by pas on 08/25/08 at 11:44:42

Thank you all for your imput,
If I can't get this to work out, I will contact Lynn & Bill.
Thank's for trying!