Match BOM Production Entry Line Sequence to BOM Maintenance detail line entry

Question

We are on Sage 100c 2019 and I'm trying to find out a way, that when BOM Production Entry is launched and we go to the lines tab, that the line sequence is NOT alphabetical/numeric ascending (which appears to be the default), but based on the way the Bill was entered in BOM Maintenance. Or how I have used the Find No. field to label the desired sequence. Or by a UDF that I entered in BOM Detail table that mimics the same Find No. field, but it never shows up under the Production Entry Detail table via Custom Office; only header info. is available. 
 Is there a way, either by UDF linkages or scripting, that will show the line sequence that is setup in BOM Maintenance when we go into Production Entry? 
 This seems to be a huge oversight by Sage. When making anything, you have to follow a defined sequence of events, which needs to be inputted in a specific sequence and then printed in a specific sequential order.

David Speck · Answer

BM Production Entry consolidates duplicate items into one row so it doesn't seem like you can source any values from BM_BillDetail into BM_ProductionDetail using standard UDFs. It also places components in ascending order by the component item code. This is likely done because of the consolidation logic and there could be other reasons. 
 Also, BM Production entry is a very straightforward and simple feature to relieve components and put finished goods into inventory, what you are describing was accomplished with the Work Order module (being replaced with Production Management) in which you would define steps, work centers, and activities along with the components' order and the step they belonged to. The BM module by itself is not supposed to be a robust and concise manufacturing solution.

Sage 100

Match BOM Production Entry Line Sequence to BOM Maintenance detail line entry

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING