1
Create / Edit a report (Monthly Purchases - with products)
Question asked by Tom Armstrong - May 6, 2016 at 5:45 AM
Unanswered
Hi, 
I'm trying to create / edit a report which will show me our monthly purchases grouped by purchase order number, then to also show the values of items purchased for example
 
Purchase Order 1 - Supplier 1
                                                Product 1        Product 2        Product 3        Product 4
                                                   £1.50            £1.00                £2.00            £1.20
 
Purchase Order 2 - Supplier 2
                                                Product 1                            Product 3         
                                                   £1.50                                £2.00
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                           Product 1        Product 2        Product 3        Product 4
                                                    £3.00            £1.00                £4.00            £1.20
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
 
 
I've tried editing some reports, still with no luck - Can someone point me in the right direction? 
 
Thanks in Advance
 
Tom

1 Reply

Reply to Thread
0
SliQTools Support Replied
May 8, 2016 at 1:53 AM
Employee Post
Hello Tom
I think you should be able to get what you need by starting with the Sales by Purchase Order item report. This report actually shows items on POs.
 
Using the help on this page:
 
 
edit the report to group on Num.
 
You can also change the report to include the columns you need from POs and products:
 
 
Regards,
 
Mike

Reply to Thread