Pending order changes

Hi so I have made a manufacturing software for my factory ... 

so I have created a view for my order log - where the orders received are mentioned and it shows it's status if the order is complete or pending and if half complete then what is the pending quantity.

Now for that I have set up behaviors and also used automation on these behavior to make it work .. 

the issue that I am facing is :-
The first entry it works fine where when the sale form is submitted the dispatched qty gets updated and automatically the pending qty gets showed - the problem arrises when the second entry is put after the sale form is submitted it gets updated on the first entry and not on the second entry - 

showing the screenshot of the formulas used

Screenshot 2023-01-17 at 9.59.44 AM.pngScreenshot 2023-01-17 at 9.59.52 AM.pngScreenshot 2023-01-17 at 9.59.59 AM.pngScreenshot 2023-01-17 at 10.00.17 AM.pngScreenshot 2023-01-17 at 10.00.23 AM.pngScreenshot 2023-01-17 at 10.00.43 AM.pngScreenshot 2023-01-17 at 10.00.59 AM.png

0 1 79
1 REPLY 1

PLEASE SOMEONE HELP STUCK BADLY AT THIS 

Top Labels in this Space