ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> purpose of bkarhinv & bkarhinvl
http://www.istechforum.com/YaBB.pl?num=1165436627

Message started by khays on 12/06/06 at 12:23:47

Title: purpose of bkarhinv & bkarhinvl
Post by khays on 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?

Title: Re: purpose of bkarhinv & bkarhinvl
Post by cathyh on 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.