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

(0) Share

Report

Posted on by KJ-03062255-0

769

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

Categories:

Dynamics 365 Business Central

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (0)

Report

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

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