Welcome, Guest. Please Login.
05/25/25 at 20:39:27
News:
Home Help Search Login


Pages: 1
Send Topic Print
Help correcting AP aging in maintain database (Read 723 times)
stl3370
Member
**


I love YaBB 1G -
SP1!

Posts: 80
Help correcting AP aging in maintain database
03/01/05 at 11:54:47
 
I need some assistance correcting our AP aging.  Basically, I have a payment that was processed for a vendor at the same time that the AP clerk had backed out the voucher and re-entered it.  So, I have the new voucher showing on the aging at the full amount when I actually need it to show partially paid.  All GL transactions are correct so I only want to alter the amount that shows on the aging.  I found the transaction in the BKAPINVT and BKAPCHKH files and made sure the AMT, AMTRM, and AMTPD fields were correct, but the aging is still showing the original voucher amount.  Does anyone know where the AP aging pulls from so that I can change that amount to the be correct?
 
Thanks,
Sean
Leybold Optics
Back to top
 
 
WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Help correcting AP aging in maintain database
Reply #1 - 03/01/05 at 13:04:29
 
BKAPHPO, as memory serves. If that is not correct, my friend Lynn will certainly correct my bad memory.... Wink
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
stl3370
Member
**


I love YaBB 1G -
SP1!

Posts: 80
Re: Help correcting AP aging in maintain database
Reply #2 - 03/01/05 at 13:11:34
 
I actually thought of that, but its only an AP voucher and not a PO receipt.
 
Thanks anyway,
Sean
Back to top
 
 
WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Help correcting AP aging in maintain database
Reply #3 - 03/01/05 at 13:17:53
 
Sean,
 
Ooops. You DID say that. Sorry. Try APINVL.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
stl3370
Member
**


I love YaBB 1G -
SP1!

Posts: 80
Re: Help correcting AP aging in maintain database
Reply #4 - 03/02/05 at 06:16:51
 
Checked BKAPINVL.  Found all the voucher lines but didn't see an obvious field where the aging would be pulling from.
 
Thanks anyway,
Sean
Back to top
 
 
WWW   IP Logged
stl3370
Member
**


I love YaBB 1G -
SP1!

Posts: 80
Re: Help correcting AP aging in maintain database
Reply #5 - 03/02/05 at 07:33:35
 
Finally got it figured out.  The transaction date in the APINVT and APCHKH files were different.  Once I corrected this, the aging is now fine.
 
Thanks,
Sean
Back to top
 
 
WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Help correcting AP aging in maintain database
Reply #6 - 03/02/05 at 18:08:19
 
Yes, the aging is based on matching invoices from BKAPINVT and payments in BKAPCHKH.
Back to top
 
 

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