Query about iph_hist

iph_hist is used to keep history of pricing and created at the time of Invoice posting.

I think iph_hist only stores the history for discrete sales orders. For schedule order iph_hist is not created. Reason might be iph_hist is created from pih_hist.

I would like to know Does Mfg/pro provide any table which stores the pricing history of Customer schedules. Does idh_pr_list holds the exact price list applied in schedule line at the time of shipment.
 

lig.qad

New Member
pih_hist and iph_hist are linked to a specific sod_det or idh_hist respectively.

The price used for a customer schedule issue is the one stored in the corresponding sod_det (before posting) and then on the idh_hist.

idh_list_pr is the "list price". idh_price is the "price after any discount". sod/idh also have a "price list" field that doesn't necessarily will be pointing to the same as the "price that item had on that price list"... example: Manual price override during SO maintenance, price list was changed after SO was created... and so on.

Another record that stores price is tr_hist in ORD-SO and ISS-SO transaction types... tr_price field (not true for all transaction types).
 
Top