Using customer orders for an assembly, I need to keep a running stock total of assembly components.
For this example I will just work on the magnets.
Today 2 orders for Big Box, order number 2032 and 2033, there are 5 magnets per assembly so I need to deduct 15 magnets from Magnet, Total Quantity, for order 2032 and 5 magnets for order 2033, what formula do I need to use to maintain a "Total Quantity" of components
Tried to look for through other threads but couldn't find one for assemblies
This could be an option using formula's, I added two columns to your stock part
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Thank you Keebellah, I was trying to use a very complex formula that I couldn't get to work, if I had taken a step back and looked at differently, I should have seen that it's simple but works, thanks again
You're welcome, it's a trap wel all fall into, we think too compliacted when the answer is simple. I've run into many walls that way but ... there's always a way
Happy coding
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks