Sage 100

Is there a way in crystal to link the BM_ProductionDetail line seq no to the BM_BillDetail line seq no and sort by the line seq no off the bill of material entry screen?

Strange... no way to flow a UDF from BM detail to production detail. If you link tables in the report, make sure you use an outer join to prevent added production lines (not in the BM recipe) from being omitted. I'd think each item component would have to be unique in the recipe for table links to work.

Might have to try the UDF option. Right now, when I link the table it duplicates all the lines from the production detail line seq no even when I adjust the join types.

For the UDF, I didn't see the business objects. You may have to script a lookup to grab the value from the bill detail table into production entry.

Thank you @KevinMoyes for the suggestions!