Skip to main content
Question

Mass update Supplier Pricelist

  • December 30, 2024
  • 3 replies
  • 72 views

Forum|alt.badge.img+3

We are currently using IFS V9 and receive an updated price list from our supplier at the beginning of each year. Is there a way to automate the process of uploading the price list into the "Supplier for Purchase Part" - Price List? Manually updating the price list is very time-consuming due to the large number of parts involved, and I’m confident there must be a more efficient solution.

 

Thanks.

 

 

3 replies

Abdul
Superhero (Partner)
Forum|alt.badge.img+12
  • Superhero (Partner)
  • 237 replies
  • December 30, 2024

Hi ​@agovindarajan,

Have you explored migration job process.

A migration job is usually used to update large volumes of data.

 

Regard

Abdul Rehman


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Customer)
  • 3 replies
  • December 30, 2024

Hello,

 

I successfully added a new line to the supplier pricelist for 2025 using the Excel Migration Job, provided the current 2024 line is closed. However, when I attempt to modify the last (existing) 2024 pricelist through excel migration, I encounter the error: "In site XXX, this interval already exists or overlaps another interval."

Could you please guide me on how to batch update the valid-to date for a set of part numbers for 2024 before I insert 2025 pricelist? Any assistance would be greatly appreciated.

 

 


Abdul
Superhero (Partner)
Forum|alt.badge.img+12
  • Superhero (Partner)
  • 237 replies
  • December 31, 2024

Hi ​@agovindarajan,

Please ensure migration job columns are properly configured, seems system trying to create new record instead of updating the existing one.

Mentioned error comes when user try to add new line without closing the existing open line.

can you check system behaviour by modifying 2024 last line directly in Price List screen.

 

Regards

Abdul Rehman

 


Reply


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