Skip to main content
Solved

Not showing columns in Event Actions

  • November 2, 2020
  • 4 replies
  • 225 views
N
Sidekick
Forum|alt.badge.img+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.

 

Best answer by william.klotz

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

4 replies

tobese
Hero (Employee)
Forum|alt.badge.img+7
  • tobese
  • Hero (Employee)
  • 98 replies
  • November 2, 2020

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
Sidekick
Forum|alt.badge.img+8
  • Narsi
  • Author
  • Sidekick
  • 27 replies
  • November 2, 2020

@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
Superhero (Customer)
Forum|alt.badge.img+21
  • william.klotz
  • Superhero (Customer)
  • 479 replies
  • Answer
  • November 2, 2020

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
Sidekick
Forum|alt.badge.img+8
  • Narsi
  • Author
  • Sidekick
  • 27 replies
  • November 2, 2020

@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.

 


Terms & ConditionsCookie settingsAccessibility statement