Skip to main content

Notifications

Supply Chain Management forum
Unanswered

updating procurement category in entity purchtable

Posted on by 6
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
  • Guy Terry Profile Picture
    Guy Terry 28,584 Super User 2024 Season 2 on at
    updating procurement category in entity purchtable
    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. 
  • updating procurement category in entity purchtable
    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
  • Martin Dráb Profile Picture
    Martin Dráb 229,135 Most Valuable Professional on at
    updating procurement category in entity purchtable
    Which entity are you using?

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

News and Announcements

Give Back to the Community this Month

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,807 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans