Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Description in ledger transaction list

(1) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi Expert,

i need customization since my country not in this list: https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/set-up-default-descriptions-for-automatic-posting

how i change the Description in ledger transaction list (for free tax invoice item)?

what is the related/mapping between CUSTINVOICETABLE table and GENERALJOURNALACCOUNTENTRY table?

thank you.

*This post is locked for comments

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Description in ledger transaction list

    Hi,

    What you enter in the line description text won't be visible in the ledger voucher that Dynamics posts.

    That is, the invoice line descriptions in the free text invoice - and also the description fields in the sales order invoice - are not taken for the voucher.

    This is actually not possible without making a system modification because different free text invoice lines that share the same account and financial dimension are summarized into a single ledger posting line on an account.

    For that reason we have the customer, invoice ledger automatic 'default description' texts.

    If you want to have the invoice line descriptions inherited in the ledger voucher then a system modification is required. Such a modification is, however, not easy because the accounting engine summarizes different invoice lines based on accounts and findims.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Description in ledger transaction list

    Dear Ludwig,

    can you advice me the column i should choose in default descrition

    3823.Item.png

    to fill with the red light item bellow?

    3823.Item.png

    thank you

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Description in ledger transaction list

    Dear Ludwig,

    it works, thank you bro. you save the day

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Description in ledger transaction list

    H7658.default-desc.png"/api/data/v9.1/msdyn_richtextfiles(E63437CE-749B-4604-AE3D-68DC7C16571D)/msdyn_imageblob/$value?size=full">/api/data/v9.1/msdyn_richtextfiles(E63437CE-749B-4604-AE3D-68DC7C16571D)/msdyn_imageblob/$value?size=full

    Once this is done, can you post another free text invoice?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Description in ledger transaction list

    Dear Ludwig,

    this on from General ledger->area page -> inquiries ->voucher transactions

    0451.ledger-transaction-list.png

    and this one is from General ledger->area page ->reports -> groupings ->ledger transaction list

    0451.ledger-transaction-list.png

     

    any idea?

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Description in ledger transaction list

    Hi,

    From which form did you create the second screenprint?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Description in ledger transaction list

    Dear Ludwig,

    this method i already try before couple times and try again a minutes ago.

    the result is same, the description only show "free text Invoice".

    5621.Result.png

    result:

    5621.Result.png

    maybe my country (indonesia) not yet on the list?

    ([View:https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/set-up-default-descriptions-for-automatic-posting:750:50])?

    that's why i need some customization in the class to add and change description information.

    or do you have another method Ludwig?

    thank you

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Description in ledger transaction list

    Hi,

    Not sure if we talk about the same thing. I was referring to the default descriptions that are posted with the voucher. Example:

    7484.t2.png

    7484.t2.png

    Is this what you are looking for or something else?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Description in ledger transaction list

    Hi Ludwig,

    thanks for your reply.

    the default description in ledger transaction list report is text "Free text invoice"

    0451.fti.png

    this base on generalJournalAccountEntry.text in LedgerTransListReportHelper class.

    if we can find related key between generalJournalAccountEntry and CUSTINVOICETABLE, we can add more information in description like Invoice Number and  Customer Name.

    that is my issue. if you have the solution, please let me know.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Description in ledger transaction list

    Hi,

    Can you test whether the default description 'customer invoice, ledger' will be filled when you post a free text invoice?

    My home country is also not listed on the site you shared but default descriptions for free text invoices work nevertheless.

    Would be great if you could test and let us know.

    Many thanks and best regards,

    Ludwig

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans