Skip to main content
Solved

Data Migration - Excel Add-In - Purchase Order


Forum|alt.badge.img+4

Hello,

I am trying to update a line in the Purchase Order (view PURCHASE_ORDER_LINE_PART). I want to update a price for several lines at the same time. Every time when I am trying to do that I have the following error message:

Entering a new line works perfectly, but the update of existing line doesn’t work. Has anybody encountered the following problem? Is it possible to update the Purchase Line with the Excel Add-In?

 

Thank you in advance,

Best answer by Nirogini Janstin

Have you deleted it on source mapping of your migration job? There should be a column called inventory part on your migration job’s source mapping and you can check the flags of that column, it should be non updatable, so you need to remove the source column of that 

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

Nirogini Janstin
Do Gooder (Employee)
Forum|alt.badge.img+5

You can remove the inventory part in the source mapping since it is not a updatable field


Forum|alt.badge.img+4
  • Do Gooder (Partner)
  • October 26, 2023

Hello @Nirogini Janstin,

The only column that I found that is associated to the inventory part is:

I erased the value it and I tested it, but I still get the same error.


Nirogini Janstin
Do Gooder (Employee)
Forum|alt.badge.img+5

Have you deleted it on source mapping of your migration job? There should be a column called inventory part on your migration job’s source mapping and you can check the flags of that column, it should be non updatable, so you need to remove the source column of that 


Jens
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • October 27, 2023

Hi @ArcAleksS 

go to the tab Method List of your migration job:

 

Press the 3 dots and choose Method List Attribute.

Filter for INVENTORY_PART%

Go into EDIT mode, tick off the On Modify flag for INVENTORY_PART_DB and press SAVE.

 

Try again please.

/Jens

 


Forum|alt.badge.img+4
  • Do Gooder (Partner)
  • October 27, 2023

Hello,

@Nirogini Janstin and @Jens 

 

Yes, I followed you advice and I erased the source for all non updatable columns.

It worked, thank you!

 

Kind regards,


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