Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Posted Voucher Narration On General Ledger Entries ( Page ID 20)

(0) ShareShare
ReportReport
Posted on by

Hi....!!!!

To show posted voucher narration in general ledger entries page ( ID 20)

I added a narration field (data type - text) in G/l entry table and in field property

Field class : Flowfield

Calcformula : Lookup("Posted Narration".Narration WHERE (Entry No.=FIELD(Entry No.),Document Type=FIELD(Document Type),Document No.=FIELD(Document No.),Posting Date=FIELD(Posting Date)))

But it is showing only first line of the posted voucher narration

So please help me out..... 

Thanks In advance

Please find below image for line narration and voucher narration it is showing same lines

posted-narration.png

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: Posted Voucher Narration On General Ledger Entries ( Page ID 20)

    Ok sir, I will try this one and get back to you.

    thanks a lot

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Posted Voucher Narration On General Ledger Entries ( Page ID 20)

    It will show same only. You can not bring multiple lines from Posted Voucher Table into single line at G/L Entries Page with field relation.  

    What you need here is, you need to have one variable defined as VoucherNarration (Free Text).. Run the Repeat Until Loop and concatenate the multiple Posted Voucher lines into this variable. You can call this function or code on Page OnAfterGetRecord trigger.

    Hope this helps.

  • Community Member Profile Picture
    on at
    RE: Posted Voucher Narration On General Ledger Entries ( Page ID 20)

    6560.posted-narration.png

    Please find above image for line narration and voucher narration it is showing same lines

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Posted Voucher Narration On General Ledger Entries ( Page ID 20)

    Hi,

    Actual relation between Posted Narration Voucher & G/L Entry table is Transaction No. field.

    If you want Posted Narration Lines, then you need Entry No. filter as well...

    Can you please attach the screen shot here, if you still face the issue?

    Hope this helps.

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans