AnsweredAssumed Answered

Write script for invoicing starter solution to tie 4 locations together

Question asked by LisaRadosta on Aug 7, 2011
Latest reply on Oct 31, 2011 by philmodjunk

Title

Write script for invoicing starter solution to tie 4 locations together

Post

Hello,

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. 

 

Thanks

Lisa

 

 

 

Outcomes