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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Sum flowfield on Tax Entry, but only on first matching line

(0) ShareShare
ReportReport
Posted on by 10
I have a need to add a sum flowfield to the Tax Entry/Vat Entry table that sums together specific line information from posted sales invoices. I thought I had this figured out but have now run into instances where there are multiple Tax Entry lines that all match on everything that I can find to differentiate within the Posted Sales Lines table, so my flow field is duplicated if there are two matching lines. Is there anyway to have a flowfield only show on the first found line, for example on the first /Entry No./ of a given Document Number/Tax Group. Is there something else somewhere that identifies which lines from the Posted Invoice lines end up on which entries in the tax entry?
 
Thanks,
Kevin
  • Suggested answer
    YUN ZHU Profile Picture
    103,223 Super User 2026 Season 2 on at
    Hi, as far as I know it can't be done with Flowfield, this needs to create a variable or actual field and handle it in the program.
    Hopefully other experts can give you better advice.
     
    Hope this helps.
    Thanks.
    ZHU

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 757 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 451 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 391 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans