Skip to main content

Hello,

 

I am trying to create a new report rule that helps me to print the only handling unit layout that was created for the specific layout.

 

 I have created the rule like this:

 

 

Expression 1 :

 

 

I have tried both APTR and ‘APTR’  for the Expression 2.

 

Only one part number is going to be related for only one specific customer. That’s why i have referenced sales part cross reference. And also part nos are same with the catalo nos

This label should have been printed on the shop order handling unit structure , before packing.

 

When i print this label from the shop order , i am waiting from that system that i chooses the correct layout for me.

 

 

But it still chooses the labels according to the report definition sequence.

 

 

I want the system to choose the label i have defined on the action of the report rule.

 

If you check the window “Report Rule Log” and look for your report rule id. There you can see the execution if the condition is met. You can also see if anything goes wrong.

​@Fatih YILDIRIM Gumabs one option to try could be:

  • create custom attribute in Handling Unit - make it available for Reports
  • then you can see in the XML if you get the value you expect
  • change your Expression1 in the Report Rule to take the Custom Attribute you just created 

Hey there  , i have solved the problem  , the query that i have written is wrong , i accidentally forgot to take the “Handling Unit Id” i have just typed “Handling Unit”

it should have been written like this:

i&SELECT c.customer_no FROM handling_unit_extended a ,      shop_ord b ,      sales_part_cross_reference c WHERE a.source_ref_type_db ='SHOP_ORDER' AND a.source_ref1=b.order_no AND a.source_ref2=b.release_no AND a.source_ref3=b.sequence_no AND a.contract=b.contract AND a.contract=c.contract AND a.handling_unit_id=a@HANDLING_UNIT_LABEL_REP/HANDLING_UNIT_IDS/HANDLING_UNIT/HANDLING_UNIT_ID] AND c.catalog_no=b.part_no]

 

and 

the expression 2 should have been like = APTR not ‘APTR’

 

Thank you for your help.

 

Reply


Terms & ConditionsCookie settings