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

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

vendor dimension

(0) ShareShare
ReportReport
Posted on by 8

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

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    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

  • lally Profile Picture
    8 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.

  • Ludwig Reinhard Profile Picture
    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

  • Suggested answer
    Kristi Slininger Profile Picture
    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

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 > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 3

#3
Scott_itD Profile Picture

Scott_itD 2 Community Manager

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans