Import inventory Batch create

1

OK

Have setup the spreadsheet for the inventory and done a test run, however it fails to pick up the Tax code and custom expenses field in Batch Create, tax code is as below (for Aust)

TaxCode
GST 10%

Batch Create custom expense account
Inventory - cost

Would appreciate any advice on what I am doing wrong as have to many to adjust manually

thanks

2

  1. Enter some representative data manually via the GUI

  2. Do a Batch update

  3. Look at the details of the records exported. They are identical to what you would have required to create them with a batch create except for the final “Key” field

Data base records in Manager have an underlying unique identifier GUID or UUID

  • The GUID is used to link data in one table to another, for example link an inventory item to the Tax code database table.

  • When using batch create or update you need to supply this pointer value/ GUID.

  • Lubos apparently is planning to replace the GUID with unique record names however doing so would require users to use unique names in their businesses.

  • For records which are the same as you testing manual entries you can just copy the GUID form them.

  • GUID is shown in grey in the top right corner of most screens.

  • A list of all GUID for a database table is available by doing a batch update on the destination tab. VLOOKUP can be used in a spread sheet to convert between the GUID and records name.

1 Like