Iterate over grid items on pre-foucsout event for the block.

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.

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.

---------- Forwarded message ----------
From: Kishan Bhat <address@hidden>
Date: Sun, Feb 27, 2011 at 9:08 PM
Subject: Re: autoNextRecord when the defined primarykey also a masterlink
To: Reinhard Mueller <address@hidden>
Cc: address@hidden

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 <address@hidden> 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

From:	Kishan Bhat
Subject:	Iterate over grid items on pre-foucsout event for the block.
Date:	Sun, 27 Feb 2011 22:14:19 +0530