I have an invoice with an invoice items browse list and I want to allow the user to over-ride a back-order by adjusting the product table quantity on the fly. This is how it should work. If the invoice_item_qty entered is greater than the invoice_item_instock then fire a dialog form that queries and shows the same item from the inventory product table. The key is product_id.
Once the dialog form is open I will have to buttons one to confirm the backorder as acceptable and close. The other
will allow adjustment of the products current inventory in the product_instock field and then exit.
Another tricky part of this is when I return to the browse
I want to update the invoice_item_instock column for that record with the same change I made to the product_instock field. This way the invoice_item_orderQty will re-calculate.
I have tried using field rules to cause the dialog form to display but it doesn't fire based on the condition (invoice_item_qty " invoice_item_instock). It fires always.
Also, it doesn't query the correct product record that corresponds to invoice_items browse record.
I will appreciate any tips on how to do this.
Also, another problem is this:
I am having trouble getting a filter to work consistently. I have a different browse of items on the same invoice
but on a different tab than the above problem. In this view I only want to see the lines where the product_id starts with a "Q". I put this filter in the properties of the browse:
left(Product_id,1) = "Q"
When I move to the tab that has this view it works the first time. But, if I change tabs and then come back to it the filter doesn't work and all lines show.
Thanks for the help,
Corey
Once the dialog form is open I will have to buttons one to confirm the backorder as acceptable and close. The other
will allow adjustment of the products current inventory in the product_instock field and then exit.
Another tricky part of this is when I return to the browse
I want to update the invoice_item_instock column for that record with the same change I made to the product_instock field. This way the invoice_item_orderQty will re-calculate.
I have tried using field rules to cause the dialog form to display but it doesn't fire based on the condition (invoice_item_qty " invoice_item_instock). It fires always.
Also, it doesn't query the correct product record that corresponds to invoice_items browse record.
I will appreciate any tips on how to do this.
Also, another problem is this:
I am having trouble getting a filter to work consistently. I have a different browse of items on the same invoice
but on a different tab than the above problem. In this view I only want to see the lines where the product_id starts with a "Q". I put this filter in the properties of the browse:
left(Product_id,1) = "Q"
When I move to the tab that has this view it works the first time. But, if I change tabs and then come back to it the filter doesn't work and all lines show.
Thanks for the help,
Corey