Welcome, Guest. Please Login.
04/28/24 at 03:12:24
News:
Home Help Search Login


Pages: 1
Send Topic Print
Data Base file location for "Reference" numbers (Read 1049 times)
dashdown
Full Member
***


Be alert.  The
world needs more
lerts.

Posts: 189
Gender: male
Data Base file location for "Reference" numbers
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!
 
Back to top
 
 
Email   IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1523
Gender: male
Re: Data Base file location for "Reference" number
Reply #1 - 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.
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Data Base file location for "Reference" number
Reply #2 - 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.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print