Hi

I am not sure about this problem but;

Can You try expression with shop_order_operation_api.Get_Operation_Description function It needs 4 parameters and all is available on purchase  requisition line.

I hope it helps.

Regards

servet

Hi @servetsc,

Could you give me an example of that expression? I've never used that expression before, so I don't know what to do yet.

Kind regards,

Karin

Hi,

The problem is because the Part_No isn’t available on the Shop_Order_Operation view.

Regards

John

Hi @johnw66,

I don't agree with you on that statement.

The Part_No is available on the Shop_Order_Operation view in the column ‘Outside Op Item’. 

Hi Karin,

There is a function to get op description ;

ifsapp.shop_order_operation_api.Get_Operation_Description(order_no,release_no,sequence_no,operation_no)

You can define it to purch req line with these variables;

ifsapp.shop_order_operation_api.Get_Operation_Description(DEMAND_ORDER_NO,DEMAND_RELEASE,DEMAND_SEQUENCE_NO,DEMAND_OPERATION_NO)

Like This;

Regards

Servet

Hi,

 

I want to add a custom field to the Purchase Requisition Lines view, which is based on two criteria to make the search unique.

I've made a Read Only Custom Field with one of the key variables, but make it work for each line I need to add a second variable to my select statement. Problem is: I get an error when I want to finish creating the Custom Field.

This is the field I want to add to Purchase Requisition Lines:

This is what I got so far. 

Select Statement:

SELECT Operation_Description FROM Shop_Order_Operation WHERE Order_No = :Demand_Order_No AND Outside_Op_Item = :Part_No

This is the Error that appears after clicking on ‘Finish’:

 

And these are the results when I only use the Shop Order number as criteria:

Does someone know what I am missing here?

Hi @servetsc,

Purchase Requisition Lines is connected to view PURCHASE_REQ_LINE_ALL which is not the base view for this LU PurchaseReqLine

When you declare an argument as v.XXX, it searches in the base view, in this case PURCHASE_REQ_LINE

It seems like PART_NO is not included in the base view PURCHASE_REQ_LINE which the error is about.

You can get the part no using purchase_req_line_part_api.get_part_no(requisition_no_ => :requisition_no_, line_no_ => :line_no_, release_no_ => :release_no_) 

you can find variables to call the function from the base view.

Hope it helps!

Damith

Hi @dsj 

I can guess the problem with the query is about the base view of purch req line. Thank you for the information.

Servet

Hi @servetsc,

Thank you for your example, I tried it and it works perfectly!

Regards,

Karin

you need to delete the space between ‘= : ’

SELECT Operation_Description FROM Shop_Order_Operation WHERE Order_No =:Demand_Order_No AND Outside_Op_Item =:Part_No