Finance | Project Operations, Human Resources, ...

split voucher transaction with same dimension

(0) Share

Report

Posted on by Khurshid Wali

926

Hello Everyone,

I want to split voucher transactions which are clubbed during posting based on the same dimension, e.g

I have two line in "expanse table Line" for car maintenance one cost 220 and other is 280 after posting they fall as single line in voucher transaction of amount 500.

How can I achieve this

All responses (10)

Answers (0)

Suggested answer

Pola 182 on at

Like (0)

Report

RE: split voucher transaction with same dimension

Hi Khurshid,

you can do that if you add a new dimension for the cars then link the requested account/s to this dimension in your structure, so any new posted transaction will be separated by car.

Regards,

Pola
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: split voucher transaction with same dimension

Hi Khurshid wali,

You can use General ledger allocation rules and allocate the costs that are posted on a single account-findim combination to different account-findim combinations e.g. based on a % key that you define.

You can find some information how this works here: docs.microsoft.com/.../create-an-allocation-rule

Best regards,

Ludwig
Khurshid Wali 926 on at

Like (0)

Report

RE: split voucher transaction with same dimension

Thank you Dr Ludwing Reinhard for replying,

Can we customize to split the line after posting. e.g From GeneraljournalAccountEntry Table. Based on original document lines. I simply duplicate the lines and distribute the amount based on original document Lines. what will be its impact on other financial tables and functionality.

regards,

Khurshid wali
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: split voucher transaction with same dimension

Hi Khurshid Wali,

The short answer to your question is: You can't do that.

There are a couple of workarounds available e.g. post two single transactions for the 220 and 280 instead one single one.

Alternatively, make a setup that uses different account-findim combinations.

Yet, by default, you cannot have this voucher split if the account-findim combinations are identical.

Best regards,

Ludwig
Khurshid Wali 926 on at

Like (0)

Report

RE: split voucher transaction with same dimension

Thank you, Gunjan, for your support.

version:

AX 2012 R3
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: split voucher transaction with same dimension

Hi Khurshid,

Please confirm the version of AX 2012 you are on.
Khurshid Wali 926 on at

Like (0)

Report

RE: split voucher transaction with same dimension

Yes, I need to do it through code. but I don't have financial's class and table idea where to make changes that it will not affect other modules voucher. I need this splitting for Expense only.
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: split voucher transaction with same dimension

Hi Khurshid,

I don't think there is any other setting available for separating the lines.

You might need to do some code modifications to achieve this.
Khurshid Wali 926 on at

Like (0)

Report

RE: split voucher transaction with same dimension

Hi Gunjan,,

Detail Level setting is already set to details.
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: split voucher transaction with same dimension

Hi Khurshid,

Could you please check the posting details level setting of the journal name set in Travel and Expense parameters?