CSV Error 4077

Hi Girvan , that's a common issue (which support should have been able to determine themselves), which arises due to a duplication of price level records in your file. A moderator will be able to run a script over your file to correct it, that should eliminate that error. The duplication may occur again. 

 If you run a price level detail report to the screen you may be able to see one or more items which have two columns for quantity break zero. 

Hi Girvan 

As mentioned by Mike_James , if your file is online, the moderator/support staff can simply run a script to fix 4077 errors. If your file is offline (local), you could use an app called File Utility MYOX to fix. The tax code error and warning seem like errors in your import file.

Regards

Gavin

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 Girvan 

I've happy to arrange for the 4077 script to be run over the company file for you. We would need for you to confirm the following information to arrange for that:

• Where the company file is stored i.e. online or local
• What the LAST FOUR DIGITS of the serial number is - Setup>>Company Information
• What is the company file ID - Help>>About AccountRight

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