We are on Epicor 9.04.504,
I have been trying to add the tracking number field (ShipHead.TrackingNumber) to AR invoices. I copied & modified the Data Dictionary to include the ShipHead table, included following fields:, Company, CustNum, TrackingNumber. I know I need to link the table to an existing table on the report, however I cant figure out which table to link it to. Every combination I tried, results in "unable to connect to database" error in crystal. I even tried the Auto-Link (by Name), still cannot get the report to "pull" the trackingNumber field into the form.
BTW I cant believe the tracking number field isnt already on the form!
any help or pointer would be appreciated. Thanks
Andy
I have been trying to add the tracking number field (ShipHead.TrackingNumber) to AR invoices. I copied & modified the Data Dictionary to include the ShipHead table, included following fields:, Company, CustNum, TrackingNumber. I know I need to link the table to an existing table on the report, however I cant figure out which table to link it to. Every combination I tried, results in "unable to connect to database" error in crystal. I even tried the Auto-Link (by Name), still cannot get the report to "pull" the trackingNumber field into the form.
BTW I cant believe the tracking number field isnt already on the form!
any help or pointer would be appreciated. Thanks
Andy