nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

MYOB for Excel

MarkW1

Can anyone advise on how to select just one instance of an invoice in MYOB for excel. When i run the report for a salesperson it will give me multiple entries for the same invoice. We will often invoice by the day for site attendance. At the end of the month we might have ten or more entries by date in the invoice.

I just need to get the figure per employee per invoice in the spreadsheet. I can then filter as needs be.

Regards

Mark

Find more posts tagged with

Accepted answers

Mike_James

Hi @MarkW1 , testing this issue here I used the sales summary option, and ended up with duplicate entries just as you have. I then found that if I reduce the number of fields selected to the minimum I need, then the duplicates did not appear. My final report included:

Invoice number, Date, Subtotal, Total tax, Total amount, Salesperson ID & Salesperson name.

Hopefully this works for you.

All comments

Kadther_Wu

Hi Earl,

I am experiencing exactly the same issue. I usually have it sort of solved by refreshing the data but I am not able to dispel the error today after multiple attempts. This issue is intermittent and the the pattern on how entries were duplicated is not certain. This is what it looks like when there is error.

And this is when it is working properly, which I pulled up from a backup file.

If MYOB with Excel provides the options to us to present these information in excel, it then should work properly without going around or sacrificing transactions details as I need the records for multiple purposes.

Please have your tech to look into this issue because it is really annoying when it happen and especially when I cannot dispel it. Thank you for your attention.

Earl_HD

Hi @MarkW1 ,

We're glad to hear that the solution provided by Mike_James solved your issue. If you have any more questions, please feel free to start a new post, and we'll be happy to assist you further.

Regards,
Earl

MarkW1

Hi Mike,

Thanks that worked.

Mike_James

Invoice number, Date, Subtotal, Total tax, Total amount, Salesperson ID & Salesperson name.

Hopefully this works for you.