Welcome, Guest. Please Login.
11/16/24 at 13:25:53
News:
Home Help Search Login


Pages: 1
Send Topic Print
AR-E conflicts with  AR-F (Read 923 times)
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
AR-E conflicts with  AR-F
10/23/08 at 07:21:32
 
AR-E ...A statement for ACME shows they owe us $1000.00 and everything is current
AR-F ... An aging for ACME shows they owe us $950.00, everything is current , but there is a msterious credit referencing inv#75 for $50.00 in the over 90 days amount
 
At first glance of AR-F, one would think that ACME paid us twice for inv#75, but they didnt.     AR-E, the statement is correct.  AR-F, the aging is incorrectly showing a credit with an inocent invoice number.
 
How did this mysterious credit get on AR-R.....Any ideas, all help is appreciated.
Thanks,
 
P.S.  names, dates, amounts, and invoice numbers have been changed to protect the innocent.
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
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: AR-E conflicts with  AR-F
Reply #1 - 11/17/08 at 12:38:58
 
The customer's statement is correct, but the aging has a mysterious credit.
So I guess I need to go inot the database and get this mysterious credit out of the aging/
 
What file in database has the aging?
 
Thanks,
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
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: AR-E conflicts with  AR-F
Reply #2 - 11/18/08 at 08:49:40
 
AR Aging can be tricky to clean up.  The files you need to look at are BKART and BKARINVT.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print