ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> Help correcting AP aging in maintain database
http://www.istechforum.com/YaBB.pl?num=1109706887

Message started by stl3370 on 03/01/05 at 11:54:47

Title: Help correcting AP aging in maintain database
Post by stl3370 on 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

Title: Re: Help correcting AP aging in maintain database
Post by aricon on 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.... ;)

Title: Re: Help correcting AP aging in maintain database
Post by stl3370 on 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

Title: Re: Help correcting AP aging in maintain database
Post by aricon on 03/01/05 at 13:17:53

Sean,

Ooops. You DID say that. Sorry. Try APINVL.

Title: Re: Help correcting AP aging in maintain database
Post by stl3370 on 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

Title: Re: Help correcting AP aging in maintain database
Post by stl3370 on 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

Title: Re: Help correcting AP aging in maintain database
Post by Lynn Pantic on 03/02/05 at 18:08:19

Yes, the aging is based on matching invoices from BKAPINVT and payments in BKAPCHKH.