Skip to main content

Can any please advise.

We are due to review and update our prices that will be effective from 01/01/2021 and have created a migration job to load base prices. 

 

Our source file includes PART_NO, PRICE and VALID_FROM.

 

The migration job, updates the SALES_PART and SALES_PART_BASE_PRICES but I am not convinced I am updating correctly.  

 

It looks like I cannot load the prices in advance as the Sales Part price field changes along with the Sales Part Base Price as soon as it is migrated in.

 

Can someone please advise the best way to update our base prices in advance?

In the end the migration job could not be used as even though the API had INSERT and MODIFY ticked received the messaged that the record already existed. Finally, this was was achieved by creating a PL/SQL routine that utilized the MODIFY API call.

Reply


Terms & ConditionsCookie settings