[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

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

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.

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 ;-)


---------- 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:

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?


Attachment: test.gfd
Description: Binary data

Attachment: test.gsd
Description: Binary data

reply via email to

[Prev in Thread] Current Thread [Next in Thread]