I am working on an app that will decrement inventory on hand each time we make a product. The app uses data from the BOM for the product to present a list of all components used to make the product. General flow of the app is as follows:
User scans a kanban card and the product SKU is loaded as a variable
A dynamic table presents the BOM for the SKU
The user enters the QTY of products made and presses a submit button
At this point, I want all components listed on the BOM to be decremented in the Components Inventory Table by Usage Qty x Qty of products. Example: User needs to record 2 shirts made. BOM lists 13 snaps per shirt. Inventory of snaps is decremented by 26 snaps.
We have many components (part numbers) and the BOM changes for each SKU. Is it possible to make dynamic Record placeholders?
- List item