Solved

Not showing columns in Event Actions

  • 2 November 2020
  • 4 replies
  • 196 views
N
Rank
Userlevel 2
Badge +8

Hi,

I need to get column values of NET_AMOUNT and CLIENT_STATE in Event Action

 

Logical Unit:    CustomerOrderInvHead
View:        &AO.CUST_ORDER_INV_HEAD_UIV_ALL
Package:        &AO.CUSTOMER_ORDER_INV_HEAD_API

I have created an event 

I used table “INVOICE_TAB” which is base tab on LU

I can not see some columns(NET_AMOUNT and CLIENT_STATE) in atrribute list. I have to use those columns in the Event Action.

 

any ideas to get missed columns in event action?

 

Thanks,

Narsi.

 

icon

Best answer by william.klotz 2 November 2020, 15:33

View original

4 replies

tobese
Rank
Userlevel 3
Badge +7

I think that you use the custom attributes for that. If there are public get methods for the desired attributes I think it should be rather straight forward.

Cheers /Tommy
N
Rank
Userlevel 2
Badge +8

@tobese 

thanks for replying 

I have checked, there is a public get method for Status, and no method for NET_AMOUNT, trying to get that Colum using CURSOR in Event Action

 

Thanks

Narsi.

william.klotz
Rank
Userlevel 7
Badge +21

Hi @Narsi ,

 

You don’t mention the version of IFS you are running but I’m using IFS Application 10 Update 8.

I’d recommend you take a look at using Logical Unit: INVOICE and Table: INVOICE_TAB.  You’ll find the CORRECTION_REASON_ID, NET_CURR_AMOUNT and ROWSTATE to use in your event.  The ROWSTATE corresponds to the status on the screen and NET_CURR_AMOUNT should correspond  to the NET_AMOUNT.

 

 

Regards,

William

N
Rank
Userlevel 2
Badge +8

@william.klotz 

Thanks for replying.

I’m using IFS Application 10.

I can also see the CORRECTION_REASON_ID, NET_CURR_AMOUNT, and ROWSTATE with CustomerOrderInvHead(LU) and INVOICE_TAB. I’m happy now I can use it.

 

Thanks,

Narsi.

 

Reply


Terms & ConditionsCookie settings