Solved

Updating Base Prices

  • 12 November 2020
  • 1 reply
  • 351 views
R
Rank
Userlevel 7
Badge +18

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?

icon

Best answer by RutJWhalen 4 January 2021, 18:20

View original

1 reply

R
Rank
Userlevel 7
Badge +18

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