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

Owned by Beth Blok (Unlicensed)
Last updated: Nov 23, 2022 by Scott PearceVersion comment
1 min read

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

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.