How to add a list of assigned serial numbers to Job Traveller SSRS?

Kinetic ERP
, ,
1

Hi All,

I am trying to show a list of all serial numbers assigned to the top level part for a job on the Job Traveller SSRS Report. What would be the best approach to do something like this?

Thanks in advance

2

The table you’re looking for Erp.SNTran. Make it a child to the JobMtl table, and join on JobNum, AsmSeq, MtlSeq and PartNum. Only include SNTran records with TranType = ‘STK-MTL’.