Hi DizzyKP,
Nice work getting 8,000 items and your opening balances across, that’s a sizeable migration job. You shouldn’t need to import one total quantity and then manually shuffle everything between locations. For AccountRight Premier, use an Inventory Adjustments import with one row per item and location. The import can include the Item Number, Location, Quantity and Unit Cost, so you can split each item across your two existing locations, provided the items and locations have already been created in the file: Import and export fields. Before importing all 8,000 items, take a backup and test a small batch first. As you’ve already entered the trial balance, it’s also worth checking the adjustment account and values carefully so the inventory balance isn’t duplicated. Move items between locations can be used to correct any stock that lands in the wrong location.
Cheers,
Doreen
