Yes, total quantity of items on the order (excluding BOM components).
If using a sub report is easier, I did manage calculate the total number of items when using a sub report. However I couldn't get the sub report to multiply qty order and the BOM components
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Search found 4 matches
- 17 Apr 2024, 20:53
- Forum: Sage 50 Report Designer
- Topic: Report with BOM
- Replies: 5
- Views: 1473
- 14 Apr 2024, 20:49
- Forum: Sage 50 Report Designer
- Topic: Report with BOM
- Replies: 5
- Views: 1473
Re: Report with BOM
Sorry here it is. thought I had attached my layouts The picking note with sub report shows the correct weight and number of items, but the sub report will not multiply the sop_item.qty_order by stock_comp.component_qty the picking note with bom is the one we would like to use so we can multiply the ...
- 12 Apr 2024, 22:04
- Forum: Sage 50 Report Designer
- Topic: Report with BOM
- Replies: 5
- Views: 1473
Report with BOM
I am trying to create a "picking note" that on some occasions will have a product containing a BOM product code, the issue I am having is that when there is a BOM product the weight and quantity is incorrect, it seems to add up all the product codes as well as the BOM products also. I did ...
- 12 Mar 2024, 06:53
- Forum: Sage 50 Report Designer
- Topic: Picking note totalling overall weight
- Replies: 9
- Views: 4479
Re: Picking note totalling overall weight
Everything is working how I require but i just can't sum these weights. When item contains a "KIT" I wish it to sum the indivi componemts of the kit rather than pull through that Kits SKU weight. The yellow highlighted are none kits just SKU's which contain a BOM and their showing indiv w...