Skip to main content

Notifications

Microsoft Dynamics NAV forum
Answered

How to Change the Description that Posts to GL ?

Posted on by 768

Hello, I am trying to Post purchase invoice but i want to post the actual line description to G/L Entry instead of "Posting Description"?

Nav 2018

  • Verified answer
    RE: How to Change the Description that Posts to GL ?

    Hi Steven,

    Thank you for your response, I already implemented the same. I did reverse enginerring then i found that there is posting description available and that worked for me.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to Change the Description that Posts to GL ?

    Muhammad,

    Adding to other replies... In new releases of BC, you can use a Posting Description or Line Description. For NAV, you will need to contact your Partner to add some logic to replace the Description posted to the General Ledger Entries table with the Line Description.

    Hope this helps.

    Thanks,

    Steve

  • Suggested answer
    Abdullah Satti Profile Picture
    Abdullah Satti 5 on at
    RE: How to Change the Description that Posts to GL ?

    Hi,

    While Posting Purchase Invoice the data is inserted in Table 49 "Invoice Post. Buffer" temporary. You have to create two fields "Posting Debscription" and "Line No." to save the Purchase Line and Description field.Add "Line No." to the primary key.

    pastedimage1647360943831v1.png

    While Posting Purchase Invoice Code unit 90. It prepares the Purchase invoice post buffer where you can save the purchase line description in custom field.

    Subscribe the "OnAfterInvPostBufferPreparePurchase" the event for table 49 and assign the purchase line description to temperary buffer newly created field.

    You have to subscribe another event  "OnBeforePostInvPostBuffer" for codeunit 90 and then assign the temporaryfield  "Posting Description" to GenJnlLine description.

    pastedimage1647361537157v2.png

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to Change the Description that Posts to GL ?

    I think my users have the same issue as @Muhammad Arif

    We need the Purchase Invoice Line Description to dictate what the Posting Description will be.

    Today I posted an invoice from "BridgeCompany", we had crossed their bridge twice this month. And I had entered these lines on the Purchase Invoice:

    G/L Account: "3000 Sales Department, travel costs" | Description: "Visited Customer ABC"

    G/L Account: "80000 Private costs, to be deducted in salary" | Description: "Employee MBJ, private bridge expense"

    Now when i look at the G/L Entries on these accounts i see 2 entries, with the Description: "BridgeCompany", and that is not useful to us, we need meaningful Descriptions.

    Do you know a fix for this?

    Thank you.

    - Martin Bønnelykke Jensen

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to Change the Description that Posts to GL ?

    Hi Marco

    What are "cross reference setup" and where are "the communities"?

    Best regards

    Martin Bønnelykke Jensen

  • Suggested answer
    RE: How to Change the Description that Posts to GL ?

    Hello! :-)

    you have 2 options:

    a) you can change the code behind here:

    pastedimage1594136533160v1.png

    to what you want to write always as Posting Description automatically instead of the current standard code (Document type + No.)

    b) You can edit the Page 51 to show Posting Description and change it there (manual every time)

    pastedimage1594136672725v2.png pastedimage1594136688838v3.png

    I hope it helps :-)

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: How to Change the Description that Posts to GL ?

    Hello,

    In the communities we did discuss cross reference setup. Maybe that is helpful for you as well?

    Thanks

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,469 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans