Procurement Categories – Where is the Item Model Group?

by | Updated June 15, 2016 | Dynamics AX, Procurement and Sourcing, Set Up

Back in my AX support days at Microsoft, which seems like a decade ago (1.5 months ago) I was repeatedly asked the question:  Can you post the packing slip in ledger, for procurement categories on purchase orders?

The answer to this question is “Yes, you can!” But, it’s not in the same location as die-hard AX users are used to from previous versions.

Procurement Categories are new to AX 2012 and have a little different setup as they don’t use item model groups.  There is actually a purchasing policy that you can setup which partially replaces the functionality of the item model group.

The purchasing policy is found at:  Procurement and Sourcing > Setup > Policies > Purchasing Policy.

This policy contains rules that can be setup at the Legal Entity level or at an Organization level (See About Organizations and Organizational Hierarchies in the AX Help for more info on Org Hierarchies).  In my case, I have a policy setup for the LE that I’m using (CEU). One of the rules in this policy is labled Category Policy Rules. If I create a new policy rule for this section, I can see that I can add lines for all my different procurement categories as seen in figure 1.

 

Category Policy Rule

Figure1: Category Policy Rule

The field we’re focused on is the Accrue purchase expense on receipt. Marking this field enables you to post to the ledger on purchase order receipt for the specific procurement category.

There are three other fields that pertain to purchase orders on this rule:

Category Matching Policy:  You can setup the default matching policy for the procurement category.

Receiving Requirements:  Force a physical update before you can financially update a receipt.

Deduction Requirements:  Force a physical update before you can financially update an issue.

When I post the packing slip for a procurement category it hits the Purchase expenditure, un-invoiced and the Purchase, accrual posting types as seen in figure2.

 

Packing slip voucher

Figure2: Packing Slip Voucher

 

Another commonly asked question is:  Procurement categories don’t have an item group setup against them, so how do you specify the ledger posting?

If you navigate to Inventory and Warehouse Management > Setup > Posting > Posting we can find both of the posting types for my packing slip voucher.  You can add an item code of type:  Category and then the Category Relation field will become active. Once the category relation field is active, you can specify a specific category the ledger account will be enforced against.  In figure3, you can see that I’ve add a new ledger account for my phone procurement category under the Purchase expenditure, un-invoiced posting type.

Posting

I hope this helps!

Related Posts

8 Comments

  1. Loz Saunders

    Hi Tom,

    Thanks for an interesting article. When an item has both an Item Model Group and also belongs to a Category in the procurement hierarchy, which posting takes precedence? In other words is the transaction posted based on its Category or its Group?

  2. Brandon Carmichael

    Hi Loz:

    Thank you for visiting our blog; but more importantly, thank you for taking the time to comment.

    Regarding your question, the priority is:
    1. Item specific – Top Priority
    2. Item Group – 2nd priority
    3. Category – 3rd priority
    4. All – Last

    I hope this helps, please let me know if it doesn’t.

    Thanks,
    Brandon

  3. Dhonni

    Hi Tom,

    Thanks for an interesting information about ax 2012, i’ve try the step that you guide in making journal for product receipt procurement categories. After i post the receiving, i can find product receipt list but i can’t find a either voucher or journal transaction of my receiving.

    can you tell me, maybe there’s some step that i’ve forget it. Thanks a lot

  4. Brandon Carmichael

    Hello Dhonni:

    Unfortunately, there is nothing obviously as to why you aren’t able to replicate this. We would be happy to assist you further if you would like to open a support ticket.

    Thanks,
    Brandon

  5. Dhonni

    Hello Brandon,

    Thanks for your response
    The issue has been resolved, i forget to check “post product receipt on ledger”, i found this configure on account payable parameters > updates.

  6. Brandon Carmichael

    Hi Dhonni:

    That is great to hear. Thank you for the update and your solution.

    Thanks,
    Brandon

  7. David

    Hi
    Is there any way that the financial dimensions from an item – linked to a procurement category – can be used to populate them on a purchase order if the procurement category is used for the purchase order?

    Also is there any way of using procurement categories and be able to update stock?

    regards

    David

  8. Brandon Carmichael

    Hello David,
    In regards to your first question, is there any way that the financial dimensions from an item – linked to a procurement category – can be used to populate them on a purchase order if the procurement category is used for the purchase order; not that I know of, I would assume we would have to modify the system to see this behavior.

    Regarding your second question, procurement categories are treated like non-stock items, so to answer your question – not with out a developer modifying the code/logic.

    I hope this helps – thanks,
    Brandon

Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events

august

10aug(aug 10)8:00 am11(aug 11)11:00 amPower BI for Dynamics 365 - Online Workshop

11aug10:00 am10:30 amThe Modern Manufacturer - Enterprise Asset Management

11aug12:00 pm12:30 pmBusiness Intelligence with Dynamics 365 Finance and Supply Chain Management – Game Changing Insights and Analytics

18aug10:00 am11:00 amTop Five Reasons Why NOW is the Right Time to Move from Salesforce to Dynamics 365 Customer Engagement

18aug10:00 am12:00 pmIntro to Power BI for Dynamics 365 Business Central – Online Workshop

18aug12:00 pm1:00 pmSolving the Biggest Challenges in Agribusiness Through Innovation and Technology

25aug2:00 pm2:30 pmUsing Technology to Manage Complex Sales Pricing, Commission, and Rebate Programs

september

01sep10:00 am10:30 amEnsuring Quality and Compliance for Batch Manufacturers in Life Sciences

01sep12:00 pm12:30 pmIs it Worth It to Move to the Cloud? A Look at Considerations for Current Agribusinesses Using Dynamics GP

01sep2:00 pm2:45 pmWhat’s New in Dynamics 365 Finance and Supply Chain

08sep12:00 pm4:00 pmSecurity and Permissions Training for D365 Business Central or Dynamics NAV

22sep10:00 am10:30 amStreamlining Batch Manufacturing with Technology

27sep(sep 27)9:00 am15oct(oct 15)11:00 amDynamics 365 Finance & Supply Chain Development Training - Online Workshop

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X