ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> System Manager >> file name for BIN LOCATIONS to export
http://www.istechforum.com/YaBB.pl?num=1291217682

Message started by dbldharris on 12/01/10 at 08:34:42

Title: file name for BIN LOCATIONS to export
Post by dbldharris on 12/01/10 at 08:34:42

Hi All!!!

I am doing an inventory export for to prepare for our physical inventory. I get the majority of the information I need from the BKICMSTR report, but the one piece of information that we can't seem to export is the BIN locations that we entered in IN-B when we set up the items. This is different than the LOCATIONS file, which we do not use. The only way we can seem to get it is if we freeze and export the PI report. We are running DBA version 2000.2.

Does anyone know the name of that piece in DBA? Also, which export file will I find it in? I can merge the two files, no worries, just looking for an easier way to obtain than running the PI file.

Thanks!
Lauren 8-)

Title: Re: file name for BIN LOCATIONS to export
Post by GasGiant on 12/01/10 at 10:56:11

The field is in MTICMSTR in MTIC.PROD.LOC

Title: Re: file name for BIN LOCATIONS to export
Post by dbldharris on 12/01/10 at 12:12:37

Colin....Thank you so very much~ Just made my life a whole lot easier!!!! ;D

Title: Re: file name for BIN LOCATIONS to export
Post by Lynn_Pantic on 12/01/10 at 20:17:18

For anybody with Warehouse control turned on (which allows multiple Bins per item per warehouse) the data is stored in ISBINLOC which can have multiple entries per item so that makes it considerably more complicated. But if you are not using Warehouse Control and multiple Bins then Colin is correct.