Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
September 2021
September 2021
Hello,
I am attempting to import a list of items into accountright so we can set up inventorising, and am returning the below error:
Error -4012: You must specify an expense account for tracking costs
I have exported the current item list, changed the item codes, added in 'I Inventorise' and the relevant COGs/Asset account.
Is this a company wide setting i need to change, or is there something i've missed in the CSV file?
Solved! Go to Solution.
September 2021
September 2021
Hi @rochelle98 , you cannot add the "I inventory" option either manually or via import, once the item has transactions on it. What people often do is export the existing items, set them up as you want, then manually add a prefix to all the existing items (because the item number cannot be changed via importing), so "ABCD" becomes eg "Z-ABCD"), then take a backup and import the items with their new definition.
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
September 2021
September 2021
Hello Mike,
Yes thats correct.
Sorry i forgot to mention i have changed the updated the existing product codes in myob with a prefix so i can reimport the codes as new items to inventorise as per the below.
Have you seen the error code below before?
Error -4012: You must specify an expense account for tracking costs
I'm just unsure as to what this relates to so that i can rectify it.
Thanks!
September 2021
September 2021
Hi @rochelle98 , would you be able to post the top 10 lines of your import file here?
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
September 2021
September 2021
Sure Mike,
I'd appreciate your input.
September 2021
September 2021
Hi @rochelle98 , all the right data seems to be there, but I question the order of columns, which doesn't appear to match a typical item export. I've seen in earlier cases that this can lead to import errors. Can you re-order the columns in line with an item export, and try again?
Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)
Bulk download of attachments (more details...)
September 2021
September 2021
Thanks Mike,
Could you please advise a typical order of columns?
I used the export assistant, therefore columns are exported in the order they are added to the export file in.
I've tried reordering a few different ways & am still coming up with the same error.
September 2021
September 2021
Hi @rochelle98
When you export, ensure you select 'Add All' to ensure all fields are exported. This will give you the complete export file in the correct order.
Regards
Gavin
September 2021
September 2021
Thank you both, Gavin & Mike.
All sorted! 👍🏻👍🏻