I thought I'd ask this question too... so changing the subject line here. Referring with my example attached, I make a purchase order which has multiple sku items (2'nd tab) . Now the 3'rd tab would show the same PO but with only 1 modifiable column - "Invoice quantity". I'm wondering if on clicking the "Generate Invoice" button at the bottom, I can iterate over the sku items whose "Invoice Quantity" are non zero - make a new invoice record with the date, sku, rate, quantity, value(rate*quantity*(1+taxrate/100)) and then reduce the "bal Inv quantity" from the po_invoice_item table with whatever quantity was invoiced just now.
Basically: 1. How can I create invoice item record from values in po item record. 2. Instead of a per field trigger based action, how can I do a button based trigger and loop over the items in the displayed gridline and programmatically create new invoice item record one-by-one. Do I make sense - guess no ;-) Thanks! Kishan ---------- Forwarded message ---------- From: Kishan Bhat <[email protected]> Date: Sun, Feb 27, 2011 at 9:08 PM Subject: Re: autoNextRecord when the defined primarykey also a masterlink To: Reinhard Mueller <[email protected]> Cc: [email protected] I have attached my full gfd and gsd, hope that is ok. If you move to 2'nd tab and if you tab out of the last gridline from the "PO Histroy" box, then you can see that no new record is created. If you remove the master/detail link for the "id", then you can see new records being auto created. Reinhard, let me know if you need more info. On Sun, Feb 27, 2011 at 8:45 PM, Reinhard Mueller <[email protected]> wrote: > Hi, > > Am Sonntag, den 27.02.2011, 17:22 +0530 schrieb Kishan Bhat: > > Now, my autoNextRecord="Y" stops working when I move out of the last > > block of "purchaseOrder". The moment I remove the master/detail > > relationship, the autonextrecord starts working. > > can you provide me with a small gfd(+gsd) which demonstrates the issue? > > Thanks, > Reinhard >
test.gfd
Description: Binary data
test.gsd
Description: Binary data
_______________________________________________ gnue mailing list [email protected] http://lists.gnu.org/mailman/listinfo/gnue
