Sage 100

BOM on Sage 100 204 Standard - customer wants to switch BOM items from FIFO to Serial. When using BOM Production Entry I see the ""Starting Serial Number"" and the help file is less than helpful on how (if at all) the customer would be able to assign non-sequential serial numbers to a created BOM in production entry. Before I begin the long trudge to research - has anyone crossed this bridge and if so what was your result?

Entered sample transaction and the S/N were automatically assigned sequentially.

You may enter any starting number in the field on the BoM header. However, all goods produced will be sequential from that starting number. For example, if you enter starting serial as 9000 and produce 5 items, the serials will be 9000, 9001, 9002, 9003, 9004.

I was afraid of that. What happens when the user says that the serial numbers may not be sequential due to production defect, etc.

They want to record the consumption of the component parts, the production of a finished goods/sub-assembly and then account for items that 'failed' qa for example? If the finished good has a defect is is ever disassembled to recover components?

That I don't know. Typical ""poor mans MFG"" with no capabilities but big appetite for full mfg

**Scenario 1 - mfg defect, throw out defects** 1. Run production entry use the next serial number enter what they like 2. After production entry and inspection, defects would be adjusted out of inventory via transaction entry negative adjustment **Scenario 2 - mfg defect, recover components** 1. Same as above step 1 2. After inspection, defect parts are 'disassembled' to recover components used and remove the fg from inventory. Use BoM Disassembly entry and make sure its a production reversal under Disassembly Type. The end user needs to understand that if they want full manufacturing then they will need to let the system know what went into production, what came out as a good item to sell, and what was trashed. Its the trash/scrap that usually fouls up most small mfg since their workers may 're-use' a component from the 'trash bin' for the next job. Later during physical they 'discover' a large cache of components because the workers re-used components that should have been disassembled back into inventory.

We have a client that has the same issue. We solved it with a custom enhancement form ACSG. Now they can randomly assign serial numbers to the BOM Production Entry.