Good morning.

I have a problem with triggers in myself with quotes and a new module i have created with module builder wizard.
the module name is consignments.
4 fields
name - product name
consignment stock
consignment sale
consignment credit

in quotes i have changed the quote type to
consignment stock
consignment sale
consignment credit

First of when a qoute is created it should look at the consignment (same account number) to see if there is a consignment with that product name (if you have 40 products you would have 40 consignments , 1 for each product per account)
if there is not one for that product to create a new consignment with the name the same as the product name in quotes. secondly if there is already a consignment with that product to then check whether it is a
consignment stock
consignment sale
consignment credit. type quote.

depending on the quote type update the consignment with the quantity in quotes(product)

fe if consignment stock is chosen under quotes then update consignment
set consignment stock = consignment stock + products.quantity .

Or if you have any other idea on how to handle consignments, it would be appreciated.

thanking you in advance
Paul van zyl
Paul@datahosting.co.za