Hello,
I am generating a report in business central using the vendor general ledger entry table.
I am trying to sum the balance on each line based on the amount of the line plus the line balance previously calculated. I cannot set a previous amount since I have multiple groups with multiple currencies and would like to retrieve the amount of the previous line based on the group.
I have attached an image with the values I am getting without calculations (Black) with the values I would want to its left (red).
I am still new to business central development.
If i have no way of doing it I think I will have to sort by currency and just do the calculations but i would love to hear your suggestions.
Here is an example how to achieve running totals in a RDLC Report -
That is an interesting way of doing it and will test it the next time I would need to implement such feature!
Thank you!
Thanks for sharing your answer. As an alternate solution, you should also be able to do this in AL using a variable that you include in the dataset.
See the NetWeight example here: learn.microsoft.com/.../devenv-report-ext-object
I was able to fix it using the runningValue function in report builder with the scope as the group.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,993 Most Valuable Professional
nmaenpaa 101,156