Welcome, Guest. Please Login.
05/18/25 at 12:56:35
News:
Home Help Search Login


Pages: 1
Send Topic Print
purpose of bkarhinv & bkarhinvl (Read 212 times)
khays
Member
**


I love YaBB 1G -
SP1!

Posts: 70
purpose of bkarhinv & bkarhinvl
12/06/06 at 12:23:47
 
are these files for archieving sales orders.  if so, how is that done.  I have found details about archieving work orders but see nothing about SO.
 
I am trying to use excel with odbc to generate some reports but having to look through all old so's is slow.  
 
It would also be useful to know what field marks a so as closed. Is it invcd; what are the possible codes?
Back to top
 
 
  IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: purpose of bkarhinv & bkarhinvl
Reply #1 - 12/06/06 at 13:08:46
 
I am pretty sure of this: the files BKARHINV and BKARBINVL are the INVOICED Sales Order files, Header and Line items respectively.  The files without the H are the Sales Order files (BKARINV adn BKARINVL) A Sales order with no invoice towards it will only be in BKARINV and BKARINVL.  Once it is invoiced it is in both until purging takes it out of the BKARINV and BKARINVL files.  
 
I don't think you can currently archive Sales Orders.  You can Delete and Purge them.  I don't think you want to delete and purge your invoice history- I am not even sure that you can.
 
IN excel, using a query, you can choose the columns to list and set parameters for which records to bring in, such as only after a certain date, or in a date range, etc.
 
Hope this helps.
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
Pages: 1
Send Topic Print