Please find the list below where I'm storing Purchase Order Details and updating "Balance Qty" using SP Designer 2013 workflow.
Now my requirement is to create one more list to issue the Part No from available Balance Qty in above List "Purchase Order".Below is my new list details which I'm going to create
List Name = "Issue Order"
Issue No, Part No, Balance Qty, Issue Qty, Issue Date, Remaining Balance Qty OR Stock Qty
In this second list through lookup column I can call the "Part No" from List but not clear on how to create SP Designer 2013 workflow for below two points :- 1) After selecting the part no (using Lookup column) in list 2 how to call Balance Qty from List 1 using SP Designer workflow. 2) Once part no will issue from list 2 how to update the "Balance Qty" in List1. Can you please help me to provide some guide or steps to create SP Designer 2013 workflow for these two points.
Reason to create new list - In above print screen we are storing the part no with available Qty which have access for Store Department. Now for Sales Department person we don't want to give access for this list and create separate list for them where they can check the available balance Qty for every part no and if they are going to use any parts, they will out the part no with Issue Qty, Issue No, Issue Date etc from this list. Once they will click save / ok for the Out Qty in List2, Same Qty will be deducted from Balance Qty for the particular part no from Store Department List1. So the reason behind to create on more list is to track the record when the Qty has out also both department have different list for IN and OUT with all details.