I have an inventory management style App in which I have a datapage where the warehouse operative can manage collection requests made from head office.
The datapage shows all open collection requests and I want the users to be able to check a "Collected" check box to confirm collection (which closes off the collection request in the Shipments table), but I also want them to be able to receive the collected items back into inventory (updating the Products table).
For the receiving back into inventory, I have created a control button that opens up a submission form for the Products table and carries over parameters to create the addition into inventory. The button works just fine and does what I want it to do, but I would like it to also close off the collection receipt too when I click it.
At the moment the problem I have is that I can either click the checkbox on my collection datapage and update the shipments table by clicking the automatically added "Update" button... and then not have a receipt record created in the product table or I can click on the "Putaway Stock" button I created and receive the collected items back into inventory updating the Products table, but not both.
Ideally I would like the standard "Update" button not to be there and to have my "Putaway Stock" button perform both tasks simultaneously.
The script for my "Putaway Stock" button is currently as follows:
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Stepford
Hi,
I have an inventory management style App in which I have a datapage where the warehouse operative can manage collection requests made from head office.
The datapage shows all open collection requests and I want the users to be able to check a "Collected" check box to confirm collection (which closes off the collection request in the Shipments table), but I also want them to be able to receive the collected items back into inventory (updating the Products table).
For the receiving back into inventory, I have created a control button that opens up a submission form for the Products table and carries over parameters to create the addition into inventory. The button works just fine and does what I want it to do, but I would like it to also close off the collection receipt too when I click it.
At the moment the problem I have is that I can either click the checkbox on my collection datapage and update the shipments table by clicking the automatically added "Update" button... and then not have a receipt record created in the product table or I can click on the "Putaway Stock" button I created and receive the collected items back into inventory updating the Products table, but not both.
Ideally I would like the standard "Update" button not to be there and to have my "Putaway Stock" button perform both tasks simultaneously.
The script for my "Putaway Stock" button is currently as follows:
Any help would be much appreciated.
Link to comment
Share on other sites
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.