Primary_supp_ind change, is it generate new row in price_hist?
Hello,
1. My first question about price_hist table. ORMA use this table as a datasource about Retail\Unit cost data...
RMS uses cost at item-location combination, unit_cost from primary supplier\location relationship.
When i try to change primary supplier, there is no new records in price hist. As result, RMS i have unit_cost from new primary supplier, ORMA still have old unit cost....
My question is, how it should work?
2. Data model says that unit_cost of item_supp_country and item_supp_country_loc should be the same where primary_loc_ind = Y
But when, i change primary_loc_ind from loc where unit_cost - 30, to loc where unit_cost - 10, item_supp_country.unit_cost still have 30...