Hi,
I am working on a object in which vendor wise balance is calculated till 31.03.2023.
Now i have to find out the documents after which that vendor total crossed.
Example: Vendor A has balance on 31.03.2023 is 20000.00 cr
Now after getting all bill documents till 31.03.2023 , we need to get all the documents till the balance crossed the 20000.0cr.
doc1 30.03.2023 10000.00
doc2 20.03.2023 20000.00
doc3 10.03.2023 50000.00
doc4 05.03.2023 4000.00
doc5 02.03.2023 10000.00.
doc6 20.02.2023 500
here the doc4 cover comes the amount 20000.00. i need documents till doc4.
Thank you
