Order Acknowledgement Custom Issue

Epicor ERP 10
,
1

I am redoing our Custom Order Ack and every part that has an Expression that includes Variables!NoOfOrderShipTos.Value.

I am using a copy of 10.2.600.13 OrderAck and just removing what I don’t need and adding in what I do need. As an example where this is used would be in the ShipVia location where we are saying that if there is more than one Shipvia, look below.

iif(Variables!NoOfOrderShipVias.Value<=1,Fields!Calc_ShipViaDesc.Value,"(See Below)")

Why is it erroring out when I cop this expression into the new OrderAck?

2

There are other places that the variable needs to be declared, and or updated.

Check the following places on the other report (the one that successfully used those variables):

  • Report Properties -> Variables
    image

  • Report Properties -> Code - for any functions that reference your variables.
    image

  • Any fields that mave have code in them that affect that variable.

1 Like
3

I have those corrected, still giving me the same issue. To side step this, is there another ay to do what we are wanting without having to go through this expression? IS there a way to tell if it is a multi-Shipvia order, or a multi-date order?

4

The sales order RDD already has calculated fields in OrderHed
MultiNeedDate
MultiRef
MultiRel
MultiShipContacts
MultiShipTo
MultiShipVia

I would hope you would be able to use those or at least “leverage” those for your logic?

DaveO

5

@ckrusen Well, figured it out! I corrected the variables in the code section of the group and also had it put in the query and list. HOWEVER, I only put ShipTo instead of OrderRel_ShipTo. That fixed the issue…

@DaveOlender I will checking those out as well. Never had to use them so not sure how they work or what they look liek. But, I tis something to dig into for knowledge on future endeavors.