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

SUGGESTED

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.

  • 0
    SUGGESTED

    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.

  • 0

    Also, I suppose you could use a table event script to attempt to override Sage's logic to copy a bill's components to the production entry.  This would probably work best on the quantity's post validate event but I suspect you would need to set a flag so Sage doesn't also attempt to copy the bill's components but I do not know what this would be.

  • 0 in reply to David Speck

    Thanks for your input David.  Not sure if I want to go down this rabbit hole.  I'll look into it and talk to staff to see if we can come up with some workaround.  Perhaps a numbering system on the printed picking sheet or template for mixing product that matches up with alpa/numeric sorting and referencing those line numbers when entering data in Production Entry.