web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Posted Voucher Narrati...
Microsoft Dynamics NAV (Archived)

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

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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
    Community Member on at

    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
    Community Member on at

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

    thanks a lot

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans