Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

split voucher transaction with same dimension

Posted on by 922

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

  • Suggested answer
    Pola Profile Picture
    Pola 182 on at
    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 Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    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 Profile Picture
    Khurshid Wali 922 on at
    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 Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    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 Profile Picture
    Khurshid Wali 922 on at
    RE: split voucher transaction with same dimension

    Thank you, Gunjan, for your support.

    version:

    AX 2012 R3

    pastedimage1600539563006v1.png

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,417 on at
    RE: split voucher transaction with same dimension

    Hi Khurshid,

    Please confirm the version of AX 2012 you are on.

  • Khurshid Wali Profile Picture
    Khurshid Wali 922 on at
    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 Profile Picture
    Gunjan Bhattachayya 35,417 on at
    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 Profile Picture
    Khurshid Wali 922 on at
    RE: split voucher transaction with same dimension

    Hi Gunjan,,

    Detail Level setting is already set to details.

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,417 on at
    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?

    pastedimage1600527646522v1.png

    pastedimage1600527702674v2.png

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,773 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,513 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans