Importing Inventory

Question

Hi, some help here would be appreciated. Already 2 hours down on the support line and no further forward.

I've purchased an existing wholesale business, and have got AccountRight Premier on trial to make sure it will do everything we need. First thing is to import the inventory that I have been given from the seller.

It came in .csv, and had 6 items

Product Code
Product Description
Unit Cost
Dealer Cost
RRP
Quantity on Hand

I've tried importing, both as a comma delimited csv file, and converting it to a txt file. After some attempts with MYOB support, we got it to upload the Product Code and Description, but nothing else.

I saw on another post that the A1 on the excel sheet should be {} and then start below, so I redid that, again with no luck. I've looked at the importlog, on one attempt I got this:

0 records imported without errors.

1992 records imported with warnings.

5 records skipped.

Summary of errors

Error -1015: The ItemName must be specified.

Warning 44: Invalid Account Number; account ignored.

Warning 59: Expense account invalid; item may not be bought.

Then after another attempt, I got this:

0 records imported without errors.

0 records imported with warnings.

1997 records skipped.

Summary of errors

Error -1015: The ItemName must be specified.

Error -4012: You must specify an expense account for tracking costs.

I wasted 2 hours yesterday going round in circles with support. When we moved our inventory between POS software with csv for our retail stores with 3x the items and 11 catergories, it was seamless. I just can't believe this software falls down on something so basic, so it must be something me or support have missed.

Any help would be appreciated! Thanks!

doreen_p · Answer

Hi Islander,
&nbsp;
Totally hear you, spending 2 hours going around in circles with support is a lot of time. Let’s get these errors to chill out:
&nbsp;
Error -4012: You must specify an expense account for tracking costs.Think of this as MYOB asking “where do these costs live?”Fix: In your import file, add a real Expense or Cost of Sales detail account for that item (the same kind you’d choose under “I buy this item” in item setup). Save, then try the import again.
&nbsp;
Warning 44: Invalid Account Number; account ignored.This one pops up when MYOB doesn’t recognise the account.Fix: Check that the account number actually exists in your chart of accounts, is active, and matches exactly (no extra spaces or typos). Tidy or remove that account number in the file, then re-import.
&nbsp;
Warning 59: Expense account invalid; item may not be bought.Here MYOB is saying “I can’t use that account for buying.”Fix: Make sure the Expense Account for Buying is:

an existing account in your chart
 an Expense or Cost of Sales detail account (not a header, asset, or liability)
 active

Update that account number in your file, then re-import.
&nbsp;
Error -1015: The ItemName must be specified.This just means MYOB wants a name/number for every item.Fix: Give each row a unique Item Number/Name (no blanks), save, and re-import.
Once those pieces line up – real item names, valid accounts, and proper expense/COS links – your import should flow a lot smoother instead of throwing all that noise at you.
&nbsp;
You can also check out this link about importing data for more info. And if you’re still running into issues after that, you can always submit a support case via My Account so the team can dig into your specific file with you.
&nbsp;
Cheers,
Doreen

Forum Discussion

Importing Inventory

1 Reply

Looking for something else?

Related content

Inventory Import Problems

Importing in Westpac

Importing Item Sales with Non Inventoried Items

Import costs added to inventory

Import Error

Inventory adjustments

Inventory Issues

Importing inventory items error - specifying expense account for tracking costs