ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> Data Base file location for "Reference" numbers
http://www.istechforum.com/YaBB.pl?num=1262829500

Message started by dashdown on 01/06/10 at 18:58:20

Title: Data Base file location for "Reference" numbers
Post by dashdown on 01/06/10 at 18:58:20

Hello All:

I am trying to locate the data base file location for the reference numbers that appear on the Accounts Payable check stub, and also in the Cash Receipts Journal. I have looked at both BKAPINVT AND BKARHINVT with no success.

Every now and then, a payables invoice reference number is entered incorrectly, and it would be handy to make a quick correction in the data base instead of reversing/voiding the voucher in AP-C.

Likewise, in AR-C the payment reference numbers made a correction as well.

Any help would be greatly appreciated in finding the exact data base files for both!

Thanks!

Title: Re: Data Base file location for "Reference" number
Post by GasGiant on 01/07/10 at 05:42:33

Check info is in BKAPCHKF (unposted) or BKAPCHKH (check history) while vouchers are in BKAPINVL. Not sure what the question is about cash receipts, but AR vouchers are in BKARINVV and payment history is in BKARCHKF.

Title: Re: Data Base file location for "Reference" number
Post by Lynn_Pantic on 01/08/10 at 08:57:51

However... In the case of vendor invoice numbers and customer check numbers, they are not stored in those files. A reference number is stored in those files which points to a cross-reference table - MKECLASS in the case of AR Customer Checks and MKICLASS for AP Invocies.