LinkedIn
Twitter
I have 2 different tables
Inward and Outward
- Inward
Inward Table serves as my designated space for documenting incoming items. It features a deck view with various columns. Whenever an item arrives, I open the form, record the details, and fill in the corresponding columns. Please find the below attached image for columns
- Outward
Outward Table is just like a requirement form, the people working at my place, request some items which I got from Inward Entry and I will be giving them by approving it, now here I only enter the item and its quantity required. Please find the below attached image for columns (Need to debut the quantity from Inward Table for that Item Quantity they requested). Let say they have requested for something as you see in the below image
Here if you for all the items they have requested 200 quantity, but how it should be divided is ,lets say Inward Table, the first batch ID: FTH6951822 has 100 nuts it should be taking 100 nuts from this Batch ID and it need to take next 100 quantity of nuts from another batch ID: GHT694196, if this batch id doesnโt have the quantity wanted then it need to take all the quantity it is having for the batch id and item and need to move to next batch id and it should be continuing like that (Need to debut the quantity from Inward Table for that Item Quantity they requested)
Now want I wanted is when I generate a report for Outward Table, it should be same as below image
After making the entries in the Outward Table, the Inward Table should become something like this
Please compare first and last image for your understanding
Please help with the proper solutions. Thank You
