Share
ReportAll ,
I need to add the BOM approved field to the Pick Ticket (ssrs report). From what I understand the approved field is in both tables BOMTABLE.APPROVED and BOMVERION.APPROVED. The pick ticket has the following tables: SalesTable, SalesLine and InventDim. What is the best way to add the field so I can use it in the report? I was hoping the relationship below would work, however no records are returned when I run the script. Any help would be appreciated!!!!!
select SALESID, itemid, APPROVED
from SALESLINE
join BOMTABLE
on salesline.ITEMBOMID = bomtable.BOMID
order by SALESID, itemid
*This post is locked for comments
All responses (
Answers (
100
