How do I map a barcode to the barcode field when importing items from an excel file?
G'Day, We are trying to import about 4,500 items (first batch) into Accounts from excel. All is going really well apart from one major issue.
Regarding the data mapping between Accounts and the excel spreadsheet.
The "Barcode" field in the Data Mapping on the quickbooks/accounts side is hardset (and cannot be changed from what I can work out) to "Product Barcode" it should be just "Barcode". If you open up the Mappings popup box in the import a file function in Items, towards the bottom of the list of mappings you will see "Product Barcode" on the QuickBooks side, this should be "Barcode"
"Product Barcode" is a custom field in accounts.
"Barcode" is a normal field in accounts.
When we run an import data goes into the "Product Barcode" field and not into the Barcode field. We can change the from field from whatever we want on the excel side of things but the Accounts side is not changeable, from what we can see.
Is this a bug in Accounts Data Mapping function?
Is there a way to do a bulk change after importing the data into Accounts to move data from the custom "Product Barcode" field to the "Barcode" field.
We REALLY don't want to do this but will POS read the custom "Product Barcode" field instead of the "Barcode" field when scanning products. Is there something that needs to change on POS to make this happen?