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.