Write script for invoicing starter solution to tie 4 locations together
I am using the invoicing starter solution. We have inventory at 4 locations. Each location has its own field. The values from those fields are summed to make QOH.
In invoicing, I would like for the user to be able to put a letter or word into the invoicing field (location) which would tell the field to subtract the amount on that line under quantity from that item's location (in the products database) so that the correct location would automatically be adjusted for that sale. Ideally, it would be one letter, but if not, we can use the word associated with the location.
I have tried to write the script myself and am having some trouble. Before I mess things up completely, I would like a little advice about how to go about it.