Solved

Data Migration - Excel Add-In - Purchase Order

  • 26 October 2023
  • 5 replies
  • 201 views

Badge +3

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,

icon

Best answer by Nirogini Janstin 27 October 2023, 04:27

View original

5 replies

Userlevel 1
Badge +5

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

Badge +3

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.

Userlevel 1
Badge +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 

Userlevel 4
Badge +8

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

 

Badge +3

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