Create a shipping screen from an estimate and scan inventory out
i have been customising the estimates template in FM12 and have slowly been adding features that i need however i am a bit stumped on an area that i have moved on to.
Basically i have an estimate table with a portal that shows line items from another table that are linked to that estimate ID.
what i would like to do is create a sort of "pull Sheet" so when the estimate has been confirmed my warehouse staff can click a button that takes them to a new layout showing the items that need to be shipped for that estimate.
at this point i shoul note that this is rental inventory so what i need from here is for the staff to scan a barcode that is on the list, this would then go to that items record in the inventory table and change the field "Products Serial::In Stock" from yes to no.
i have not yet started work on this so at the minute i am looking for guidence as to how you guys would do this. thanks for any help in advance