I have created a board (to manage vendor invoices) and every item under that board I have a unique key (this key will be used for vendor payment against project in Main board)
Now suppose vendor have raised invoices against project which are added against project :
Ex : vendor 1 raised 2000 INR against New_LMS project under Field (Invoice 1) and Vendor 2 raised 5000 INR under same project.
Now in budget under ITEMs Board :
Pending amount must be Total amount – (Vendor 1 + Vendor 2 invoices ) = 418,000 – (2000+5000) = 411,000 INR as a result (This is output what is required from Budget perspective) .
Please let me know if this is understandable or happy to show via webex or zoom .