Thanks Sai
First I have heard about having to add a line with {} on it, when I export the list I dont think it has that.
My items list is about 30,000 products, and I create the list in Excel so they all have the same format regarding 'I sell this item'
Initially in the first import with this one test item, I get the error 42 for Item Name cannot be more than 30 Characters. I then for testing purpose shorten the Item name, then after import the error becomes error 58 for income account, item cant be sold. (Yes you are right the item does import, but no income account filled, cant sell this item, no sale price etc)
I then change the format again by shortening the Item number to 8 numbers instead of 9 and it imports correctly.
So by my deductions there is something happening regarding the length of the item name. For now, I have manually gone through handful of the common products i use that had this issue and manually entered the income account, and filled the sell price in. As a side note when entering the sell price, when you go to the next product manually to do the same thing, the sell price automatically is filled in with the previous products sell price which could cause a issue if you dont catch that.
Hi ryadre
What you are reporting is 'odd'. I recommend getting someone like MYOX Services having a look at the file, particularly inventory. They have software to analyse and look for common issues that might cause what you are reporting. What you are seeing might be caused by duplicate records in the selling price matrix. They don't charge to analyse, only if they need to fix something. Also having 30k items will definitely put a strain on Ar2024. Are they all necessary. FYI MYOX Services has a bulk delete service.
Regards
Gavin
No they arent all necessary, but unfortunetly our suppliers (plumbing products) you can only download the whole price book, and not just a selected amount of commonly used products
