How to update value of Purchase Header custom field from Purchase Order (sub)Page

jamie89 · 2018-01-13

Hello everyone,

I'm quite new to this field, sorry for the newbie question. I guess the solution will be something trivial.

I Created a new, editable field in the Purchase Header table. I want to let the user set it’s value on the Purchase Order Page (P50), more precisely on the Purchase Order Subpage (P54).

I added a new control to the subpage, set its SourceExpr to "PurchHeader.MyNewField".

However, I just can’t update its value, it remains the default 0.00 as I refresh the page (I’ve turned edit mode on). Why? How could I store the new values of this custom field?

Thank you for any help & advice.

Slawek_Guzek · 2018-01-13

PurchHeader var on a subpage is not the same thing as the purchase header records shown on the Purchase Header. It may be fetched from the same purchase header record, but they are two different things, two different copies of the same record. Therefore if you update one the second does not change.

What you need to do is to push your change on the subpage into the database, and then make the header page to re-read the purchase header rec (basically force refreshing the whole document page)

Slawek_Guzek · 2018-01-13

PurchHeader var on a subpage is not the same thing as the purchase header records shown on the Purchase Header. It may be fetched from the same purchase header record, but they are two different things, two different copies of the same record. Therefore if you update one the second does not change.

What you need to do is to push your change on the subpage into the database, and then make the header page to re-read the purchase header rec (basically force refreshing the whole document page)

jamie89 · 2018-01-14

Thank you for your answer. But I still don't get it... I should see the new value in the Purchase Header table as I hit enter on that field, shouldn't I?

And how do I push the change to the database? I've tried to use SAVERECORD function in the OnValidate trigger of the new field, didn't work.

EDIT: I figured out that if I use MODIFY at the OnValidate trigger of the subpage field, it works. But isn't this an ugly solution? I thought that VALIDATE saves the new value of the field.

How to update value of Purchase Header custom field from Purchase Order (sub)Page

Best Answer

Answers

Categories