AnsweredAssumed Answered

How to calculate Latest Supplier and Latest Cost?

Question asked by starstuff on Jun 18, 2015
Latest reply on Jun 18, 2015 by philmodjunk

Title

How to calculate Latest Supplier and Latest Cost?

Post

Hi All!

 

i have a Products Table with fields that i would like to tell the latest supplier and latest cost of the product

latest_supplier = the current supplier where i bought the product

latest_cost = the price of the product from the current supplier

 

i will be using a Purchase Invoice Form with Portal Line Items to enter bought Products from a supplier

Sometimes another supplier will give you a better price, and you will have a new supplier.

The Products last_supplier will be different or the same depending on where you bought the products.

 

what is the basic way to do this?

 

Thank You!

 

 

 

Outcomes