How to export open invoice for single customer into Excel including order number

Question

Hi All

We have a customer who requires us to send them all of their outstanding invoices (11 pages currently) by excel and NOT by the standard statement that MYOB produces.

I have tried to export Open invoice by using the report function and doing Aged receivables (Detail) but this report does not show the purchase order numbers.

Is there ANY way that i can export all the open invoice data into excel and it go correctly in each column and row??? Its driving me nuts

i have tried running a statement (which shows all the info i need) and then copy pasting the info from statement PDF to excel but then it bunches all the information in 1 square rather then distributing it into the excel sheet properly.

Mic2 · Accepted Answer

Sorry everyone, i figured it out by myself!

If this is what you are also trying to do, these are the steps i found work.

Go to your Sales module, click on Sales Register, select the particular customer you need to export, select your date period, click on Open invoice, the top left you will see print, click that and it will generate a report in a new window, top left you will see a drop down arrow, click that, go to export and click on Excel and then your are done!

Good luck