Auto-Update Inventory When Using Materials in Production

1

Hi, can someone help me fix this inventory management and production system. I am using @Connor_McCormick1’s Item Schema Inventory System Template.

I need help updating the material inventory when a certain amount is used in production. So when I register the production of a certain Item, I want it to automatically update adding to the amount of stock of the item and subtracting from the sub items used to make it.
Here a copy of my main doc, I think nothing broke. I added some more explanation about the tables I use and what I want the Stock columns to calculate:

2

good morning,
you have not activated the rights to share.

3

Oh, sorry. Can you check if it works now?

4

Hi Cecilia,

Your question seems to require us to dive deep into your business logic and solve a complex issue for you. This feels a bit like asking for free consulting.

I suggest you take some time to distill the specific technical challenges you’re facing and come back with a more focused question that doesn’t require so much effort from the community to answer.

Hope this helps,
Pablo

4 Likes
5

Hello Pablo,

Ok, I can narrow it down without problem. Should I create a new topic? I still haven’t gotten the handle of this very well.

1 Like
6

Hi Cecilia,

You can respond in this thread, but as Pablo said, it becomes very difficult to jump in in the middle of an existing complex document. it looks as if you want to do BOM-based consumption of materials (backflush), update the finished good?

That is not trivial, in the least.

P

1 Like