Finance | Project Operations, Human Resources, ...

split voucher transaction with same dimension

(0) Share

Report

Posted on by Khurshid Wali

928

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

I have the same question (0)

All responses (10)

Answers (0)

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Khurshid,

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

Was this reply helpful? Yes No
Khurshid Wali 928 on at

Like (0)

Report

Hi Gunjan,,

Detail Level setting is already set to details.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Khurshid Wali 928 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Khurshid,

Please confirm the version of AX 2012 you are on.

Was this reply helpful? Yes No
Khurshid Wali 928 on at

Like (0)

Report

Thank you, Gunjan, for your support.

version:

AX 2012 R3

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Khurshid Wali 928 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Pola 182 on at

Like (0)

Report

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

Was this reply helpful? Yes No