exporting data
I'm trying to export sales - sales type item sales - status orders. My report has exported invoices as well!
Forum Discussion
I know how to export data and to filter the data. The data has been duplicated in MYOB! One record shows the entry as an order and the other entry shows the record as an invoice! Exported file is attached.
Hi dg4
This is a known issue in MYOB. If you use orders, when you convert to an invoice, MYOB hides the Order but leaves it in the file. When exporting, there is a bug an orders are also included even when not selected. You need to sort the export and remove the orders (or get MYOB to fix the bug ;). FYI this does not affect your file accuracy.
If your file gets too big due to the number of converted orders, there is a myob specialist who can remove the Orders out of the system, saving space and improving performance.
Regards
Gavin
Hi Gavin
Thanks for the reply. Funny how after being on hold for 1.5hrs with MYOB they couldnt understand my query, then hung up on me. Who is this MYOB specialist who can fix this problem?
Hi dg4
Tried sending you a private message, however you are not 'allowed' to receive private messages.
Try FGH Tables - they can't 'fix' the export problem but they can remove converted orders so they no longer appear in the export.
Regards
Gavin
Hi dg4,
I am sorry to hear about your experience with our phone support. I understand your frustration, and this is not an experience we want to provide our customers with. Regarding your concern, the workaround that we can provide you with is to remove the unwanted records from the exported file.
Feel free to create a new post if you need further assistance with this, or in the future. We are happy to assist you.
Thanks,
Cel
