ISTech Support Forum

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

Message started by newline on 02/10/09 at 20:14:30

Title: AP Aging showing old entries
Post by newline on 02/10/09 at 20:14:30

Since the latest update (December) even after patches installed, when we run AP-I vendor aging or listing a number of really old entries show up (over 120 days) as well as the ones we're expecting, but only for some vendors.

The invoices showing up are long since paid. Has anyone seen this / got any answers

Title: Re: AP Aging showing old entries
Post by Lynn_Pantic on 02/11/09 at 13:03:30

There is a utility program FIXAPAGE.RUN that should help but once it is run, there may be a few stragglers that will need to be edited in Maintain Database. The latest version of the utility is available at www.istechsupport.com/dl/fixapage.zip; unzip to DBAMFG and run FIXAPAGE at UT-A

Once it is run, to clean up any stragglers, you need to use Maintain Database and find the invoices in the BKAPINVT file and make note of the "Invoice Number" which is actually a reference number and then open the BKAPCHKH file and find the payment(s) associated with the invoice (based on vendor code and invoice date) and edit the Invoice number to match the entry in BKAPINVT so the Aging program can match them up. Or, if they are extremely old entries and you don't care about the history that far back, you can delete the entry from BAKPINVT.

Title: Re: AP Aging showing old entries
Post by newline on 02/12/09 at 19:06:54

That seems to have fixed it, Thanks :)

Title: Re: AP Aging showing old entries
Post by Quirk on 02/19/09 at 12:32:21

I have 3 stragglers so I ran fixapage and it fixed 2 and gave me 2 more. 1 remains unchanged. I followed the following instructions and invoice numbers match. So . . . .

Title: Re: AP Aging showing old entries
Post by Dawn on 12/10/09 at 12:41:11

I ran this and got several stragglers. However when I go to Maintain Database and open BKAPINVT I get an error: Btreive Status 35. How do i fix that?

Title: Re: AP Aging showing old entries
Post by Lynn_Pantic on 12/11/09 at 13:51:06

UT-A, program MDBFXREG. Accept the path and exit DBA and go back in. You may also have to rebuild the DDFs using UT-J.