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 ITEMSALE.TXT file some of the records with a Sales Status of "O" are not sales orders, they are Open Invoices.
I am sure that in the past, following this process would yield a list of items currently on order.
Hi AlexUldis,
Bit of an odd one, if you’ve set Status: Orders in the export, those rows should be genuine orders.
In the ITEMSALE.TXT layout, Sale Status works like this:
If open invoices are coming out with Sale Status = O, that’s not how it’s meant to work. Best bet is to log a ticket in My Account or jump on live chat via MOCA so the team can take a closer look at the export. Have the ITEMSALE.TXT file and a few sample invoice numbers handy so they can dig into what’s going on.
Regards,
Genreve
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
Hello Genreve, I lodged a Support Request 10 days ago, and am yet to hear a reply.
Request number 02978662, created 1/4/26
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
