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

Notifications

Announcements

No record found.

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 23
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
    237,978 Most Valuable Professional on at
    Which entity are you using?
  • ÖS-04100536-0 Profile Picture
    23 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,924 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
    23 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
    237,978 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 307 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 123 Super User 2025 Season 2

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 67 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans