2,395
Hi, i'm trying to setup a smartlist where it would display the current cost for a BOM, is this possible? is this cost saved on a field on a table?
regards.
*This post is locked for comments
A bill of materials or product structure (sometimes bill of material, BOM or associated list) is a list of the raw materials, sub-assemblies, intermediate assemblies, sub-components, parts, and the quantities of each needed to manufacture an end product. mybkexperience
Hello Alvaro,
You can join table like this :
select a.ITEMNMBR,b.CURRCOST from BM010415 a
left join (select ITEMNMBR,CURRCOST from IV00101) b on a.ITEMNMBR = b.ITEMNMBR
where a.ITEMNMBR = 'CHAIR'
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (