Bin Tracking StockCount Program

Bin Tracking includes a custom program (stockcount.exe) to import the stock count. It is designed to work around some limitations of the standard Sage 300 import.

Because the Bin Tracking Workbook is a header/detail/sub-detail (Location/Item/serial and lot numbers) you can only insert - not update rows using the standard Sage 300 import. Accordingly, you need to use the custom import we have created for BT Stock take imports to do an insert and/or update.

You can run it from the OYXXA folder where Sage 300 is installed, or add an icon to the Sage 300 desktop if required.

How to use stockcount.exe?

The program requires four files - preferably tab-separated files, but comma-separated files can also work. header.txt, detail.txt, serial.txt and lot.txt

When you run the stockcount.exe program, select Import and browse to where the .TXT files are saved.

Minimum requirements of the files

HEADER.TXT file MUST contain the Inventory Location, Description and ISIC

Note:

If the worksheet started in IC, the value for ISIC should be 1 or True

If the worksheet started in BT, the value for ISIC should be 0 or False.

DETAIL.TXT : LOCATION, BIN, ITEMNO, UNIT, QTYSTOCK

SERIAL.TXT: LOCATION, BIN, ITEMNO, UNIT, VALUE, ACTION

Note: ACTION=2 to add a serial number ACTION=1 to remove the serial number

LOT.txt: LOCATION, BIN, ITEMNO, UNIT, VALUE, QTY

Noteworthy

  • ITEMNO should be the Unformatted Item number

  • Column headings should be included in the file

  • You need all 4 files, even if not using serialized inventory and lot tracking - in that case leave the serial.txt and lot.txt files blank

  • If you get the error message ERROR: Location ‘XXX’ is an I/C worksheet but the ISIC is False in the header.txt, check the header.txt file.