Partner Zone
Partner Zone

Sales Register - Closed Invoices

Highlighted
Contributing Cover User kazk
8 Posts
Contributing Cover User
Australia
kazk
Contributing Cover User

8Posts

1Kudos

0Solutions

Solved: Go to Solution

Sales Register - Closed Invoices

Hi. I'm trying to find a report which shows Sales Register of closed invoices and date which the invoice was closed/payment was received. I can see this in the Sales Register reports, but when I export to Excel the column showing Date Closed does not show in the report. Any advice on exporting to excel a report showing sales in a particular year, and date on which payment was received for each sale?

 

Many thanks

Karen

3 REPLIES 3
Contributing Cover User kazk
8 Posts
Contributing Cover User
Australia
kazk
Contributing Cover User

8Posts

1Kudos

0Solutions

Re: Sales Register - Closed Invoices

Update : I've gone into Insert/Modify and added Date Closed to report, I can see it in the MYOB report, but when I export to Excel it shows the Date Closed heading but is blank underneath it.

Ultimate Partner Mike_James
1,775 Posts
Ultimate Partner
New Zealand
Mike_James
Ultimate Partner

4283Posts

1879Kudos

540Solutions

Accepted Solution Solved Solution

Re: Sales Register - Closed Invoices

Hi @kazk , when you add a custom field, you must also refresh the report (green arrow) before exporting to Excel. 


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise Report Writer - Custom Reporting from MYOB programs
(Including AccountRight Classic/Live, and exo Payroll)
New: S.T.P. Reporting solution for (Aust) v19 users, email for details

Contributing Cover User kazk
8 Posts
Contributing Cover User
Australia
kazk
Contributing Cover User

8Posts

1Kudos

0Solutions

Re: Sales Register - Closed Invoices

You're a star! Thanks so much!!!

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post