Forum

Notifications
Clear all

Calculation of the remainder of the annual invoice per order

2 Posts
2 Users
0 Reactions
118 Views
(@thasenboehler)
Posts: 1
New Member
Topic starter
 

I have a list of all purchase orders that details the calculation of the balance on the annual bill. In the knight annual order by supplier I can see the remaining amount that is still open the PO. However, I see the same remaining amount in all lines and not the corresponding remaining amount per line for which a goods receipt was posted. Does anyone know of a way how this can be implemented so that I can see the current amount per row. An example is attached

example-from-the-list.jpg

 
Posted : 03/02/2023 2:14 pm
(@keebellah)
Posts: 373
Reputable Member
 

If you are using Excel 2021 or 365 then the XLOOKUP function will work.
You could also then update all your formulas with the newer functions like MAXIFS MINIFS etc...
Here is an attached modification

 
Posted : 04/02/2023 3:20 am
Share: