Skip to main content
Solved

Updating Base Prices

  • November 12, 2020
  • 1 reply
  • 400 views
R
Superhero (Partner)
Forum|alt.badge.img+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?

Best answer by RutJWhalen

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.

View original
Did this topic help you find an answer to your question?

1 reply

R
Superhero (Partner)
Forum|alt.badge.img+18
  • RutJWhalen
  • Author
  • Superhero (Partner)
  • 364 replies
  • Answer
  • January 4, 2021

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

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings