ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> AP-I
http://www.istechforum.com/YaBB.pl?num=1421695787

Message started by gina on 01/19/15 at 12:29:47

Title: AP-I
Post by gina on 01/19/15 at 12:29:47

I have an invoice on our AP aging report that apparently was entered years ago. It appears as though someone created an adjustment (perhaps a credit memo) and on the aging report there is no balance but the "aging number of days is in the thousands, over 2000 days old. Believe it or not the original invoice was entered in 2008 and the number of days continues to increase even though there is no balance. I'd really like to get it off of the aging report altogether. Thank you.

Title: Re: AP-I
Post by Lynn_Pantic on 01/19/15 at 14:07:40

Use Maintain Database on the BKAPINVT and BKAPCHKH files and look for the matching entries, or brute force, find the entry based on vendor and invoice date in BKAPINVT and just delete it if its 15 years old.

Title: Re: AP-I
Post by gina on 01/20/15 at 06:10:12

Lynn, thank you for the response. When I try to get into anything in maintain database I now get an error message...
btrieve status 11-the specified file is invalid. key=(h:\dbamfgdefault\bkapinvt.b)dbaerr-invalidfilename

Title: Re: AP-I
Post by gina on 01/20/15 at 07:32:15

Lynn, I also want to mention that our "help" feature is not working and we have received a couple of errors in the Manufacturing Module. When entering labor we received a "too many pushes" error. We have discussed this with our IT person and he seems to think there is a database problem. Any assistance you can provide would be greatly appreciated. Thank you.

Title: Re: AP-I
Post by gina on 01/21/15 at 12:08:06

Lynn, can you please assist with this? It really seems as though we are having database issues and cannot utilize DBA the way we are supposed to. Thank you!

Title: Re: AP-I
Post by Lynn_Pantic on 01/21/15 at 12:33:50

UT-A program MDBFXREG in DBA Classic should eliminate the Maintain Database error.

Title: Re: AP-I
Post by gina on 01/23/15 at 07:06:52

Lynn, maintain database if fine now. We still cannot use the "help" feature. We receive the following message "cannot display this help file. Try opening the help file again, and if you still get this message, copy the help file to a different drive and try again". Also, the "too many pushes error".... are you familiar with that? Do you think that is a database error? Thank you.

Title: Re: AP-I
Post by TGerak on 01/23/15 at 08:17:54

We have had Help menu trouble too. Our take is that it's a Windows security issue. If the help file isn't on a drive that Windows "Trusts" it won't display. The web help from the help menu works great, and it should also be the most current information.