Hi _Zentra
Please send me your product serial number and company file name by Private Message, and I'll run the script to check if that resolves this issue.
Update: Ran script to fix the issue
Hey _Zentra just letting you know, your screen shots don't seem to be visible, at least not to me. Also cannot locate the thread you mentioned. Good luck!
Hi _Zentra
As mentioned by tbaalham , the images are blocked (until a moderator reviews and clears them). So difficult to know exact cause of the issue. Most likely cause is the Description field. Some fields such as Description allow a user to enter a 'new line' or a carriage return. This looks fine on screen however is known to mess exports. In the export file this new line causes a new line, throwing all subsequent columns out.
If this is the cause, try exporting without and field that causes this issue.
Regards
Gavin
Hi gavin12345 and tbaalham ,
Thanks for your reply. It doesn't appear to be description issue as data is exporting to correct columns, just in the incorrect fields. I did have this as a solution previously (https://community.myob.com/t5/AccountRight-Sales-and-purchases/Item-Export-Data-Corrupt-Possible-Cause-of-Issue/m-p/748469) but unfortuately is not the case for this one. I did try exporting without extended description and same issue occurs.
Previously, I have had a script run over the file and this has helped, but so far no contact from MYOB to assist with this. The only other option was a third party report (https://community.myob.com/t5/AccountRight-Sales-and-purchases/Item-Export-Data-Corrupt/td-p/584668/page/2) but this was also not feasable as had to be altered everytime an upgrade was completed. We did not want to continue spending additional money on a service that should work in the monthly rate we already pay to MYOB.
All suggestions appreciated though, and happy to try any other ideas anyone may have! :)
Hi _Zentra
Not sure what you mean by 'data is exporting to correct columns, just in the incorrect fields' - perhaps explain by way of an example - images would be great however MYOB moderators take ages to 'approve' the images.
The issue in the linked post is caused by duplicate entries in the Price Matrix - this is a table in MYOB that stores prices per item per buying level etc. A bug causes duplicate entries, so for the same item, pricing level and breakpoint, there are 2 or more entries. On screen you see one, on export you see another. This can also lead to inconsistent invoice pricing!
MYOB have scripts that fix this, however they don't fix the bug that causes the problem. So after they run the script you get a temporary solution, until a new duplicate is created. Solution is to get MYOB to run the script again, and again.....
Regards
Gavin
