ITEMSALE.TXT - cannot export Sales Orders

Question

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.

Doreen_P · Answer

Hi @AlexUldis,

Thanks for letting us know you’ve already lodged a support case and I’m sorry you haven’t had a reply yet. I’ve just pinged the team that looks after these, so keep an eye on your email a bit later to see if they’ve replied.

Cheers,

Doreen

AlexUldis · Answer

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

AlexUldis · Answer

Hello Genreve, I lodged a Support Request 10 days ago, and am yet to hear a reply.

Request number 02978662, created 1/4/26