Welcome, Guest. Please Login.
05/21/24 at 13:25:18
News:
Home Help Search Login


Pages: 1
Send Topic Print
AR Aging Report (Read 782 times)
WARRIOR_BOATS
Browser
*


I love YaBB 1G -
SP1!

Posts: 1
AR Aging Report
06/17/04 at 12:38:44
 
We are cleaning up some old "issues".  Our AR Aging Report shows we have 4 customers with balances due and/or credits that are more than 120 days old.  However, the customers accounts are clear (they do not owe the money, nor do we owe them).
 
The only place this shows up is in the AR Aging.  How can we clear this off the aging report?
 
Thanks for the help!
 
BC
Back to top
 
 
  IP Logged
GinaR
Browser
*


Anything Worth Doing
is Worth Doing Right

Posts: 33
Gender: female
Re: AR Aging Report
Reply #1 - 07/03/18 at 12:42:46
 
I, too, have this issue and have not yet found anything telling me how to get rid of the problem.  Has anybody dealt with this before?
Back to top
 
 
  IP Logged
Laura Oliver
Active Member
*****




Posts: 984
Gender: female
Re: AR Aging Report
Reply #2 - 07/05/18 at 13:26:55
 
Me too!
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
GinaR
Browser
*


Anything Worth Doing
is Worth Doing Right

Posts: 33
Gender: female
Re: AR Aging Report
Reply #3 - 07/06/18 at 13:46:38
 
I have figured it out.  Took some digging, some trial and error, but I have figured it out.
 
Use Maintain Database (System Manager, TAS-D) to find the invoice(s) listed in the BKAPINVT file and make note of the Invoice Number (BKAP.INVT.NUM), which is actually a reference number for the transaction.  Also, make note of the other parameters (I found my error in BKAP.CHK.INVDTE) for the transaction as you will need them for the next step.
 
Then use Maintain Database to open BKAPCHKH and find the payment(s) associated with the invoice (based on the vendor code and invoice date).  Make sure that the Invoice Number (i.e., transaction reference number) is identical to the transaction number listed in BKAPINVT.  Also check your other parameters, such as the BKAP.CHK.INVDTE parameter (that is the check date/payment date parameter).  If they do not match, edit the parameters so that they match those in the BKAPINVT file so that the AP Aging program can match up the two transactions.
 
I sure hope this helps others who have been fighting and struggling with this problem for YEARS!
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print