Average Price Per Part

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I have a table where I enter INVENTORY PARTS. The table allows me to add a record for the parts that come in and add a record as the parts are used. Since pricing changes for the parts, I have a master table called PART LIST that houses the complete list of my parts. This PART LIST has a relationship to the INVENTORY PARTS where it summarizes the average cost for all the parts in the inventory. When I use a part, it cost it according to this average price. How do I lock that average price when I save a record? Right now, my historical cost data changes based on the average price....Once I "expense" or "use" items from the inventory at the Average cost, I need that historical data to not change.

Photo of Joshua

Joshua

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,660 Points 50k badge 2x thumb
No problem "snapshot fields".


Just rename your current field to be called [Average Price (lookup)]

Then make a new numeric field and at the very bottom there is a setting to get this field's value from a lookup field and don't allow it to change - ie snapshot the lookup value and freeze it forever. Ask to initialize it's values.

Then check the Usage tab for your lookup field and use the snapshot field where ever the lookup field was used.
Photo of Joshua

Joshua

  • 0 Points
Thanks!  That is what I needed.