Inventory transaction import errors when importing stock records with a Bin Location

Problem

Importing an Inventory Stock Transaction CSV file errors '...IN_LogicalID was not supplied'

Solution

The data being provided must be in a specific format and provide all the information requested.  Data to be checked

• the warehouse record needs both physical and logical name e.g. New South Wales / MAIN

• both Quantity In and Quantity Left fields need to be provided

• Bin Location is the Description in the Warehouse Maintenance record, not the Short Name

Open

Attached is a sample to be imported into demo data that works without issue.  Full details with a template and sample CSV file are found in \Program Files (x86)\Jiwa Financials\Jiwa 7\Documentation and Samples\Importing\Inventory\Transactions directory.

Open

Related articles