Real Time Inventory Tracking

[LVO]

I am building an invoice in a wholsaler DB that uses repeating fields (look ups based on stock # if chosen)for description, price, etc. I want a real time way making sure the user only sees what is available in inventory in their pop up list. I.E. if another salesperson sold it 5 mins ago I dont want it to show up again. I see a response similar to what I need from Paul J using set field in the inventory DB, but not understanding how the 'gap' referenced below works real time:

Hi, Cogswell.
In my opinion, the safest, reliable solution is to use a scripted SET FIELD from the invoice file.
Set Field "Inventory::New Bal", "Inventory::Curr Bal" - "Quantity"
.
.
Set Field "Inventory::Curr Bal", "Inventory::New Bal"
The reason for the gap is that the second script step sets the thing in concrete. Up to then you can cope with changes in the Invoice and also cover 'out of stock' situations.
Alternatively, you could leave it until the user accepts the invoice but then you can't do much in the way of editing without being extremely annoying to the user.
HTH
Cheers,
Paul J.



What is the 'event' that triggers setting the field in inventory - and what 'event' sets it in stone, and if the invoice is accepted, then they want to change - how do you put back in inventory? Thanks

 

[Schlogg]

The gap is where you do any editing, maybe getting other items, etc. - whatever you want to do. The second step sets the thing in concrete, which is why you might need some leeway first.
Re adding the stock back - surely you already have a procedure for adding to inventory?
Cheers,
Paul J.