E10.1.400.18 - Add FKV (OrderHed) to Invoice head

Epicor ERP 10
1

I have one field in OrderHed (scFOBDest_c) that we write the Named Place for our FOB.
So I added

  1. FKV OrderHed to Invoice Head.
  2. Added SaleOrder Assembly adapters
  3. added the field to my invoice head screen (all is good can be seen my named place)- no other customization to Invoice entry.
    Then
  4. I added to my RDD AR Form - OrderHed table
    Now when I print my invoice form (we purchased Crystal 2013 for our forms) field does not display data.
    Reviewed the XML and field is blank.

I have this working in our V803.409c and works perfect.(everything matches from V803 - E10) except no data?
What am I missing.

2

when you added the table to the RDD, did you define a table relationship between OrderHed and InvoiceHed?

3

Yes my relationship is
company and ordernum

I have 4 other fields that are from OrderHed and they are coming in it is just my Extended UD field.

4

the relationship should be ‘output’ verify that, also verify you don’t have the field excluded.

5

also, if you didn’t already, you may need to do the join in crystal as well…

6

RDD

XML Display

Crystal Table Display

Add 2 fields from OrderHed on to Invoice - Order Date and my UD field (scFOBDest_c)

7

try setting the key to

and make sure your custom field isnt excluded in your OrderHed table

Pasted image763×456 24.5 KB

joined in crystal (set your datasource location to most recent after your rdd changes)

Pasted image703×424 14.8 KB

data should come through after that

Pasted image816×585 40.4 KB

1 Like
8

Nacy,

The exact same thing has been happening to me, but in SSRS. I have found that when I directly link the Erp.Orderhed_UD table by the ForeignSysRowID, it works. It appears that OrderHed is a view in Sql, which consists of Erp.OrderHed and Erp.OrderHed_UD. But for some reason, the view doesn’t merge the two tables correctly. I submitted a support call to Epicor, but all they said was that they couldn’t duplicate the problem.

9

Thanks for all your assistance!
What I ended up doing was I used a field in OrderHed.UserChar1 this field already in available so updated my RDD (both sales acknowledgement and Invoice), added UserChar1 to Order entry screen. Update Crystal forms and
now my field is displaying.
I truly believe there is a problem with the extended UD fields in E10.1 in RDD between OrderHed and InvHead.

Hopefully Epicor doesn’t retire these user defined fields.

10

Thanks Jeromy - I will try that later. Right now using the OrderHed.UserChar1 worked so I am going to leave that dog lie (for now)