Don't know whether this helps, but..
The component table is an alias for stock, so you'll need to add the stock table and call it component, then join on stock.component_code_x > component.stock_code. And then as far as I can see, repeat for all (50?) component codes. :?
Hi,
Thanks, but BOM ...
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 2 matches
- 21 Oct 2009, 01:42
- Forum: Sage 50 UK version General Help
- Topic: Description of STOCK.COMPONENT_CODE_1 on SOPBOM.Layout
- Replies: 4
- Views: 4224
- 18 Oct 2009, 14:23
- Forum: Sage 50 UK version General Help
- Topic: Description of STOCK.COMPONENT_CODE_1 on SOPBOM.Layout
- Replies: 4
- Views: 4224
Description of STOCK.COMPONENT_CODE_1 on SOPBOM.Layout
Hi,
I am new to sage, I am using Sage 50 Account Professional 2010.
For printing Sales Order I am using SOPBOM.Layout
It prints STOCK.COMPONENT_CODE_1 and No.of Qty required to build that Item.
I want to insert component description for STOCK.COMPONENT_CODE_1 (this description is not same of SOP ...
I am new to sage, I am using Sage 50 Account Professional 2010.
For printing Sales Order I am using SOPBOM.Layout
It prints STOCK.COMPONENT_CODE_1 and No.of Qty required to build that Item.
I want to insert component description for STOCK.COMPONENT_CODE_1 (this description is not same of SOP ...