Bill of materials

[Wayne_Uren]

Hi Appsheet Creators

I am very new to APP buildings I was asked to come up with the following demonstration for a chemical manufacturing entity.

Each Product has a Bill of Material (Standard Formula)
At times due to expired/Damaged/stock they will use alternative material to replace certain of the standard formula items.
The alternative items are more expensive so they want to see what is the cost difference if they have to use an alternative.
Standard Formula cost vs Alternative Formula cost.

Regards
Wayne

[Aleksi]

Are you able to open your table/column structure little more so we could help with a correct solution, thanks.

[Wayne_Uren]

Hi Alexis

Busy working on it will send as soon as I have it.

Regards

Wayne

[Rifad]

I think you should create each child part in the items master list. Create another BOM table. Reference BOM Table first column to item master you create. When you create child parts for each master Item in BOM we are dereferencing parts from the same master list. Consider your item with 10 parts. Add 10 parts inside your item. So 1 item includes 10 parts. When you create a work order, you can write as 0.5 or 0.7, etc. so instead of full item, it will take only partially.