AnsweredAssumed Answered

Applying multiple values from one field to one record

Question asked by ex5931 on Jun 6, 2010
Latest reply on Jun 7, 2010 by philmodjunk

Title

Applying multiple values from one field to one record

Post

I have inventory that needs to be applied across several different stores, but I don't want to apply one piece of inventory to each individual store. I have made a checkbox set to apply to multiple stores, but the calculations don't apply across all the stores, just the most dominate store, I believe. For example if I got a shipment of eggs and I want to send them to stores A,B,C and D and I check all of those in my check box set, it would only calculate what store A needs for inventory times the cost of eggs, I want it to calculate what A, B, C, and D are calling for in eggs and times it by the cost of eggs. Then I want to be able to look at it in a portal and have it only calculate that one stores cost for eggs. 

Outcomes