Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Accounting Distribution of Stocked Item

Posted on by Microsoft Employee

How can we do the accounting distribution while generating Purchase Order or Invoice of a stocked items in AX2012R3? Currently it is not allowed to do the distribution of stocked item while creating PO or Invoice, only service type non stocked items can be distributed??

*This post is locked for comments

  • Verified answer
    Kristi Slininger Profile Picture
    Kristi Slininger 66 on at
    RE: Accounting Distribution of Stocked Item

    Hi Mudassar,

    While an accounting distribution is created for stocked items, it works differently than for non-stocked items or procurement categories.  You cannot split the accounting distribution, and you cannot edit the ledger account for the one accounting distribution that is created. If you want to edit the main account on the one distribution, you need to edit the Inventory posting setup.  If you want to edit the financial dimension values, you have to change them on the LINE'S financial dimension tab.  

    Why?  Inventory only supports tracking ONE set of financial dimensions for a stocked items.  Because of this restriction in inventory, we cannot allow the cost of the stocked item to be allocated to different ledger accounts.  This is even true if you try to setup an allocation rule on the main account.  The allocation rule will be ignored.

    This is functionality we would like to support, but first we need some enhancements to inventory. For now the only work around is to have separate lines on the purchase order.  

    Kristi Weekley

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Accounting Distribution of Stocked Item

    Hi Mudassar Hassan,

    I see :-)

    If this is your issue you can either make use of financial allocatio templates in the financial dimension tab or make use of allocation rules.

    How this can be realized was posted recently in a related thread.

    Please check community.dynamics.com/.../215805 and see if this resolves your issue.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Accounting Distribution of Stocked Item

    Thanks Ludwig, but this is only for distribution of charges. What if I purchase a Server and want to allocate the cost to 2 cost centers, 50% each.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Accounting Distribution of Stocked Item

    Hi,

    I did the allocation as follows; probably try if this works the same in your system:

    3122.po3.png

    Enter charge at PO header level

    0407.po2.png

    Allocate charge through allocate charge button

    3122.po3.png

    Result:

    Also the service item gets a part of the charge allocated.

    6735.po5.png

    Would be great if you could have a look at this procedure and let us know if this resolves your issue.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Accounting Distribution of Stocked Item

    Yes check now, i copy paste and it didnt work.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Accounting Distribution of Stocked Item

    Hi Mudassar Hassan,

    Unfortunately, we cannot see the attached Pictures.

    Can you try attaching them once again by using the rich formatting form that can be accessed through the corresponding button right below the text box.

    Sometimes copying & pasting does not work and you need to save the pictures first.

    Many thanks,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Accounting Distribution of Stocked Item

    Please see the screen shots.

    1. the first screen shot shows the PO item (A server whose cost i want to distribute between 2 cost center). The item R715 is a stocked product and is treated as a fixed asset
    2. the second picture shows the accounting distribution form is not allowing me do the distributions
    3. the third picture shows the AX2012R3 version. It is CU 11


    12607.2.PNG

    12607.2.PNG

    6052.3.PNG

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Accounting Distribution of Stocked Item

    Hi,

    What is the exact AX2012 R3 version that you run (cu9/10...) and can you possibly post a screenprint that illustrates the problem?

    Many thanks,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Accounting Distribution of Stocked Item

    The PO is draft and I have the system administrator role and there are no role limitations, as I can do the accounting distribution for the services items

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Accounting Distribution of Stocked Item

    Hi Mudassar Hassan,

    What is the status or your PO?

    Are you aware of any role limiations / modifications that have been implemented and do not allow you making any modifications?

    Ludwig

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans