MarkW1
4 months agoContributing User
MYOB for Excel
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 i...
- 4 months ago
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.