ITEMSALE.TXT - cannot export Sales Orders
In the Import / Export Assistant, when I export "Item Sales" and specify the sales status as "Orders", some of the records are currently Open Invoices, not currently Orders. So in the exported ITEMS...
Forum Discussion
Hi AlexUldis​,
When you use Orders, and then convert those to an Invoice, the Order remains as hidden in your AR2026 file. Most times the only evidence they are still there is to do an Order export. This shows ALL Orders, including those converted to Invoices.
This is what you are seeing - and FYI it has been this way since 2011. Another one of those things MYOB have never bothered to fix. Makes it almost impossible to export orders and re-import. There is no ready way to identify from the export which are still open as Orders and which have been converted to Invoices.
Perhaps this is something Genreve_S​ can refer to developers for a fix.
If you use orders regularly and then convert to Invoices, you likely have thousands of hidden Orders in your file. This adds to file size and also impacts on performance. If interested in reducing your file and getting rid of converted orders, get in touch with MYOX Services - they are well aware of this issue.
Regards
Gavin
Thank you Gavin, what you are describing is consistent with what I am seeing.
In a spreadsheet I have been able to roughly exclude all the converted orders, by noting if an "Invoice No." appears twice, once as an "O" and again as an "I", but this is far from ideal .......Regards,
Alex
