cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Reports Linking Sales Order to Delivery Note

Former Member
0 Kudos

I have a Packing Slip that was created in Crystal tro pull from data on the sales order

I need to change the Packing Slip to pull the shipped qty on the Delivery Note instead of the UDF field on the Sales Order we currently useing.

I have tried linking in the Database expert RDR1 to DLN1 and do not get any data.

The fields i linked were:

RDR1.TargetType to DNL1BaseType

RDR1. TargetEntry to DLN1.base Entry

RDR1.LineNum to DLN1.BaseLine

When I add the DNL1 table I no longer get data so I think I am missing a link. I have not tried adding thing to the report yet so I think I am missing the correct links.

Any help would be appreciated.

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Steven

try this

RDR1.ObjType to DNL1BaseType

RDR1.DocEntry to DLN1.base Entry

RDR1.LineNum to DLN1.BaseLine

Rob

Former Member
0 Kudos

There were no responses so I am closing this