Thanks for your reply Doreen.
First time importing anything so yes it has been a big project. So far all good until now.
So there are 2 compulsory fields that need to be selected in the import process, the item number (SKU) and the 'amount' - which from my reading is the quantity times the unit cost. I notice you didnt mention this field in your reply, and it is giving me some grief.
In your experience is there a way of circumventing this manatory field?
Hi DizzyKP,
The Amount field is required for the import. For an AccountRight inventory adjustment import, the Amount field can’t be left blank or bypassed. It needs to match the quantity multiplied by the unit cost for each item and location line. Please include the Item Number, Location, Quantity, Unit Cost and Amount, and make sure the calculation and sign are exact. If you’re only setting opening quantities, you can also enter them through an inventory adjustment in AccountRight instead of importing them. For a large number of items, exporting a sample inventory adjustment first and using its exact column headings may help. You can also visit this help page for more information about: Making inventory adjustments
Regards,
Earl
