Welcome, Guest. Please Login.
05/24/25 at 23:48:57
News:
Home Help Search Login


Pages: 1
Send Topic Print
AR & AP reports dont match GL (Read 946 times)
pas
Browser
*


I Love YaBB 2!

Posts: 4
AR & AP reports dont match GL
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.
Back to top
 
 
  IP Logged
Dawn
Full Member
***


I love YaBB 1G -
SP1!

Posts: 156
Gender: female
Re: AR & AP reports dont match GL
Reply #1 - 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.
Back to top
 
 

Dawn
Classic - 7/5/10 update
WWW   IP Logged
pas
Browser
*


I Love YaBB 2!

Posts: 4
Re: AR & AP reports dont match GL
Reply #2 - 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.
Back to top
 
 
  IP Logged
Dawn
Full Member
***


I love YaBB 1G -
SP1!

Posts: 156
Gender: female
Re: AR & AP reports dont match GL
Reply #3 - 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.
Back to top
 
 

Dawn
Classic - 7/5/10 update
WWW   IP Logged
pas
Browser
*


I Love YaBB 2!

Posts: 4
Re: AR & AP reports dont match GL
Reply #4 - 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.
Back to top
 
 
  IP Logged
Dawn
Full Member
***


I love YaBB 1G -
SP1!

Posts: 156
Gender: female
Re: AR & AP reports dont match GL
Reply #5 - 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. undecided
Back to top
 
 

Dawn
Classic - 7/5/10 update
WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: AR & AP reports dont match GL
Reply #6 - 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.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
pas
Browser
*


I Love YaBB 2!

Posts: 4
Re: AR & AP reports dont match GL
Reply #7 - 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!
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print