Reply
This thread is now archived and closed to new comments.
If you have a question please post a new topic.
Experienced User
Action
Posts: 74
Registered: ‎08-11-2010
New Zealand
0 Kudos
Accepted Solution

Orders Report

Good Morning

 

I have a number of customer orders sitting on MYOB v19.5.  Under Sales Register/orders I am able to see who has orders but I can't see what products they have ordered without going into each order individually.

 

Is there a standard report I can do in Myob that just prints total numbers of all products on order from customers.  

 

e.g.10 x fish berley

7 x fishing rods 14'

 

NOT

 

ABC Customer

2 x fish berley

1 x fishing rod

 

DEF customer

8 x fish berley

6 x fishing rods

 

Any help/suggestion is greatly appreciated.

Please use plain text.
Ultimate Partner
Mike_James
Posts: 2,464
Registered: ‎08-05-2007
New Zealand
0 Kudos

Re: Orders Report

The Item Sales summary can be filtered to report only orders, this may help you. On the customising window,change Sale status from "All invoices" to "orders".

Regards Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Multi-user cross-platform sales management add-on
DataWise Report Writer - Specialised Reporting from MYOB programs
Please use plain text.
Ultimate User
ronatbas
Posts: 1,476
Registered: ‎16-03-2011
Australia
0 Kudos

Re: Orders Report

If you are running Inventory, either of the analyse Inventory reports will give you the type of report which you require.

 

Ron

Ron B
BAS Group
1300 BAS GRP (1300 227 477)
info@basgroup.com.au
Please use plain text.
Experienced User
Action
Posts: 74
Registered: ‎08-11-2010
New Zealand
0 Kudos

Re: Orders Report

Thanks for the replies.

 

Do you know if there is any way to remove the inventory items that aren't on order when using the Analyse Inventory Summary report?  

 

Cheers

             Em

Please use plain text.
Ultimate User
ronatbas
Posts: 1,476
Registered: ‎16-03-2011
Australia
0 Kudos

Re: Orders Report

Given the nature of the report I doubt that there is an easy workaround to get rid of zero values in the committed column. Probably easiest to export the list to Excel and filter the non zero amounts.

 

Ron

Ron B
BAS Group
1300 BAS GRP (1300 227 477)
info@basgroup.com.au
Please use plain text.