ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> Old entries on AP Aging
http://www.istechforum.com/YaBB.pl?num=1124823599

Message started by kevind on 08/23/05 at 10:59:59

Title: Old entries on AP Aging
Post by kevind on 08/23/05 at 10:59:59

Back in the May, June, July 2003 time frame, we voided some checks.
Some of the invoices on these checks are showing up on the aging,
but they do not get presented for payment.

One of the vendors shows an open credit on the aging with a description of 'Voided Check # 29496'.
Another Vendor shows a couple of invoices as open bills.

These items should not show up at all.
What table would I need to edit to remove them from the aging??

Title: Re: Old entries on AP Aging
Post by lmk223a on 08/23/05 at 11:54:33

It has been my experience, that DBA will put the liability back into accounts payable when a check is voided.

If one is not going to pay the original invoice, i.e. and you want it removed, you can go back into AP-B and enter the invoice number and select "REVERSE" this entry to clear the invoice from A/P and its aging.

Or if the invoice is against a p.o., go into A/P-C and edit the invoice, but inventory may be affected if the subject invoice was against a purchase order for inventory.

Title: Re: Old entries on AP Aging
Post by kevind on 08/23/05 at 12:04:16

You hit right on the problem ... the items that show on the aging do not show up in AP-B.

Any other Ideas??

Title: Re: Old entries on AP Aging
Post by Lynn Pantic on 08/23/05 at 15:36:18

Aging looks at BKAPINVT and BKAPCHKH - since these are old invoices, if you want to use the brute force method, those are the tables.

Title: Re: Old entries on AP Aging
Post by worlduph on 08/29/05 at 08:55:11

I have this same problem. So how do you use those report names to fix it please?

Title: Re: Old entries on AP Aging
Post by Rbuchanan on 09/09/05 at 05:05:54

Had the same kinds of problems with VOIDs showing up on the aging. Seems like DBA handles the G/L transactions fine, but in the files Lynn mentioned it doesn't always get all the correcting done. For us it only is a problem on a multi-line payments. It handles line #1 and leaves the rest on the aging.

You'll need to go into the files and find the record (line) with the invoices still showing on the aging, one of the columns has an invoice amount and another is either the amount paid or the remaining balance (can't get my tired mind to remember which!) From there adjust the balance to show it as paid, then it'll drop off your A/P Aging without making entries to G/L that put your detail out of sync with the control account!