Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

vendor dimension

(0) ShareShare
ReportReport
Posted on by 19,790

Hi,

 Dimensions in AX allow you to split the P&L pretty easily.  But what do you do with the balance sheet and subledger level customer/vendor.

We thought of having default dimensions on customers & vendors and it works fine as the customer/vendor groups pick up the related GL control account with the dimension string on customers/vendors. However in events of customers/vendors used by multiple business unit constantly. We don't want the user to change dimensions on master files. Scenarios where transactions (invoice or purchase order lines) can belong to different financial dimension string and works fine with P&L accounts, however the other side will be the control accounts. These control accounts are posting as consolidated amounts of the invoice/purchase order and use the single default dimension string on the customer/vendor(ignoring the fact that there are multiple lines with different dimensions). We would have hoped that the control account would have got split as per the transactions (lines), so the dimension string and amounts will come from transactions and control account from customer/vendor groups.

Hoping anyone can shed some light.

*This post is locked for comments

  • Suggested answer
    Kristi Slininger Profile Picture
    Kristi Slininger 66 on at
    RE: vendor dimension

    Lally,

    On Ax 2012 and higher there is an option in the GL parameters called Financial dimensions: Values used for summary accounts.  If you have this set to Source document, it will use the financial dimensions from the HEADER of a source document (which typically defaults from the vendor, customer).  If you switch that setting to Accounting distributions, your AR/AP ledger account will default from the financial dimensions from the accounting distributions of the document.  This is how you can have your AR/AP split to follow the dimensions of your expense/revenue/asset account.  

    BUT.....you need to understand that this GL parameter is only used for documents that are source documents. This includes PO vendor invoices and the FTI for the vendor and customer side.  It does NOT include any transactions you enter via the journals or the SO customer invoice.

    Kristi

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: vendor dimension

    Hello lally,

    Seems that I understood your question wrong. Would you mind posting some screenshots that illustrate an example that shows your issue in detail?

    Many thanks and best regards,

    Ludwig

  • lally Profile Picture
    lally 19,790 on at
    RE: vendor dimension

    It doesn't really make sense.  It makes sense for GL accounts level only ,what about subledger level as it posts consolidaetd amount.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: vendor dimension

    Hello lally,

    Have you tried making use of the balanced financial Dimension Feature?

    This should be able to generate you Balance Sheets by Business Units.

    Please see:

    technet.microsoft.com/.../jj729752.aspx

    technet.microsoft.com/.../jj729758.aspx

    Best regards,

    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!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans