CSV Error 4077
Hi, hoping someone on here can help me with importing items via CSV file to Account Right. Currently getting Error code: 4077: See log report below. I have reached out to MYOB support but would've ...
Forum Discussion
Hi Girvan, I thought I'd add that I do an Item Import from a text file once a year or so to update Item Selling Price, and I get the 4077 error every time. I note that it only affects the products added to MYOB since the last time 'the script' was run.
Hi AlexUldis
How are you adding your new items? Manually or via import? If importing ensure the field/column header 'No. Items/Sell Unit' is empty or not imported when the item is not Inventoried. MYOB won't allow you to import 'No. Items/Buy Unit' unless the item is Inventoried, however it does allow you to import 'No. Items/Sell Unit' - which is what causes the error. MYOB could easier fix this - but will it?
Regards
Gavin
Hi Gavin,
New items are manually added throughout the year. When rolling out a price rise all items are exported to a text file, the Selling Price is updated, and the existing products in MYOB are updated via the import process.
The "Item Number' and " Selling Price" are matched during the import process, but the 'No. Items/Sell Unit' is not involved.
I have been having this problem for many years, and as mentioned earlier, it does not affect items that were 'fixed' last time the scrpit was run, only products added manually since the last time the script was run.
Hi AlexUldis
You are correct - just added an item manually using I Buy and I Sell only (not I Inventory) and MYOB set NumberItemsPerSellingUnit to 1 (which is what causes the error if you try to update price via import after you have sold the Item). Updating the price via import before you have sold the item results in a Warning only.
Interestingly NumberItemsPerBuyingUnit was left blank - as it should be.
So it seems whether you import or manually add the Item, it is MYOB itself that is causing this issue. In a previous post Steven_M suggested this was caused when a user creates an Item with I Inventory and then changes it by un-ticking I Inventory.
Hi Steven_M - I trust you will flag this with developers for eventual remedy?
Regards
Gavin
