Skip to Content
0
Former Member
Feb 09, 2012 at 06:13 PM

Crystal Reports Linking Sales Order to Delivery Note

130 Views

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