vendor dimension

(0) Share

Report

Posted on by lally

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

All responses (4)

Answers (0)

Suggested answer

Kristi Slininger 66 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 19,790 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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