Absolute legend, exactly what we need.
Thankyou so much
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 5 matches
- 10 Jun 2024, 21:43
- Forum: Sage 50 Report Designer
- Topic: Report with BOM
- Replies: 6
- Views: 42696
- 17 Apr 2024, 20:53
- Forum: Sage 50 Report Designer
- Topic: Report with BOM
- Replies: 6
- Views: 42696
Re: Report with BOM
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
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
- 14 Apr 2024, 20:49
- Forum: Sage 50 Report Designer
- Topic: Report with BOM
- Replies: 6
- Views: 42696
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 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 ...
- 12 Apr 2024, 22:04
- Forum: Sage 50 Report Designer
- Topic: Report with BOM
- Replies: 6
- Views: 42696
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 tag on to ...
I did tag on to ...
- 12 Mar 2024, 06:53
- Forum: Sage 50 Report Designer
- Topic: Picking note totalling overall weight
- Replies: 9
- Views: 59654
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 weight ...