Hello All:
We made changes to the pricing of a particular vendor that made it necessary to create a new product category. Becuase we have products in the thousands from this vendor, we thought it would be very time consuming to go into each item record in the item master to change the prod cat. So, I wrote a SQL update query to do the job.
The query looks like this:
update data..imitmidx_sql
set data..imitmidx_sql.prod_cat = '070'
from data..imitmidx_sql
join data..iminvloc_sql on data..imitmidx_sql.item_no = data..iminvloc_sql.item_no
where data..iminvloc_sql.vend_no = 'MIDD01' And data..iminvloc_sql.loc='NY'
All of the product category fields for that vendor updated properly. However, all of our Type 4 Price Codes do not seem to be working for those items. It is still bringing up pricing from the old product category.
If I run a price list report for a particular customer type, it will return pricing based on the new product category. But in order entry it is using the old price product category.
I did find that if I simply go into the item record in item master and save it, the new product category will take effect. I also found that if I enter the item in an order and do not press F4 to get price breaks, it will correct itself. But if you DO use F4, it will not correct itself.
Does anyone have any thoughts on how I can fix this without visiting each and every item record?
Advanced thanks for any light that can be shed.
Running Progression SQL 7.6.300C on SQL 2000.
Regards,
Chris
We made changes to the pricing of a particular vendor that made it necessary to create a new product category. Becuase we have products in the thousands from this vendor, we thought it would be very time consuming to go into each item record in the item master to change the prod cat. So, I wrote a SQL update query to do the job.
The query looks like this:
update data..imitmidx_sql
set data..imitmidx_sql.prod_cat = '070'
from data..imitmidx_sql
join data..iminvloc_sql on data..imitmidx_sql.item_no = data..iminvloc_sql.item_no
where data..iminvloc_sql.vend_no = 'MIDD01' And data..iminvloc_sql.loc='NY'
All of the product category fields for that vendor updated properly. However, all of our Type 4 Price Codes do not seem to be working for those items. It is still bringing up pricing from the old product category.
If I run a price list report for a particular customer type, it will return pricing based on the new product category. But in order entry it is using the old price product category.
I did find that if I simply go into the item record in item master and save it, the new product category will take effect. I also found that if I enter the item in an order and do not press F4 to get price breaks, it will correct itself. But if you DO use F4, it will not correct itself.
Does anyone have any thoughts on how I can fix this without visiting each and every item record?
Advanced thanks for any light that can be shed.
Running Progression SQL 7.6.300C on SQL 2000.
Regards,
Chris