web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Unanswered

updating procurement category in entity purchtable

(2) ShareShare
ReportReport
Posted on by 25
Good morning,
 
We are continuously improving our utilization of D365 F&O.
So a while back we have created procurement categories assigned them to item numbers.
 
I am trying to update the procurement category through the data management module but so far without success:
I end up with the following error: Results. update not allowed for field 'Procurement category(ProcurementProductCategoryName)'
 
Can anyone help to get around this and update historic data in the tables?
 
Thank you
I have the same question (0)
  • Martin Dráb Profile Picture
    239,452 Most Valuable Professional on at
    Which entity are you using?
  • ÖS-04100536-0 Profile Picture
    25 on at
    Hi Martin,
     
    I tried with: Purchase order lines V2
    Also found the information on the entity: purchase order confirmation lines... but when uploading the excel file seems like mapping does not exisit.
     
    Br,
     
    Oemer
  • Guy Terry Profile Picture
    28,977 Moderator on at
    In general, if you can't do it to one record through the front end, you won't be able to do it using the data entity via any backdoor. There are lots of different reasons why a PO Line might not be editable, some of which will apply to you, and I guess some which won't.... but if you can find a way to update one of these historic POs through the front end, then get the other historic POs in to the same state and you'll be able to update them using the data entity.
     
    That said, if the PO Line has an Item number on it, you probably won't be able to update the Category; I think that's how F&O works. You might need the help of a developer; perhaps they can set the Category on old PO lines by referring to the category which the item is currently assigned to. 
  • ÖS-04100536-0 Profile Picture
    25 on at
    I have tried it with 2 different entity: "Purchase order lines V2" & "Purchase order confirmation lines" both failed
    I found that PO position in these two entity and the procurement category field populate in the newer entries and blank in the old ones
     
  • Martin Dráb Profile Picture
    239,452 Most Valuable Professional on at
    You need to decide what you want to do instead of trying random entities.
     
    You used PurchPurchaseOrderLineV2Entity, so it seemed you wanted to create an update a purchase order line.
     
    But the requirement you mentioned has nothing to do with order lines (or confirmation lines, that you mentioned later).
     
    A category is a property of an item, not a purchase order line. The category is always taken from the item on the order line; you can't start pretending that the item belongs to another category as a particular order line. If you want a different category, you either need to select a different item or you need to change configuration of the item itself.
     
    The ProcurementProductCategoryName field on PurchPurchaseOrderLineV2Entity is the name of a category. If the change was allowed, you'd change the name in EcoResCategory table (which would influence all orders with any item from this category). You may want to do it, but changing EcoResCategory is a completely different thing than creating or changing PurchLine, therefore PurchPurchaseOrderLineV2Entity is a wrong entity for that.
     
    It seems to me that you're trying to do one of two things, none of them related to to purchase lines:
    1. You want to change the category of an item.
    2. You want to change properties of a category, such as the name.
    Please confirm your intention.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 138 Super User 2026 Season 1

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 91 Super User 2026 Season 1

#3
Zain Mehmood Profile Picture

Zain Mehmood 89 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans