We have added a custom field to the Order Head and would like it to display on the Commercial Invoice form from Quick Ship. How to do get crystal reports to see the field. It has been a long time since I have worked with crystal. I am thinking I need to update the dataset but I don’t know what connection it is using. I thought it would be ODBC but it doesn’t appear to be. Any help or direction would be greatly appreciated.
So the crystal reports that quickship uses are linked to the database and xml output from the quickship environment.
Depending on your Quickship version you will either map your ud field to using the data mapping tool in kinetic to another field in quickship. Im not sure how good that is.
And i believe that in newer version of kinetic they now have a native incoterms field on order entry customer shipment entry and customer entry. And i think they are passed from kinetic to quickship.
2 Likes
You have to add the field in the data mapping in QS. Out of the box UD fields don’t sync to QS.
3 Likes
This has changed I think. In the most recent versions of QS there is no connection to the dB. It only uses the XML dataset it generates when you run the report.
2 Likes
I’ve got a PRB right now in development because it pulls information from Epicor via rest calls. Our issue is the data for shipments with multiple orders in the shipment get the incorrect items and totals on the international paperwork.
So it does pull from Epicor, but I’m not sure to what extent.
1 Like
The freight service does or the new REST interface does for shipping definitely. But the report data comes from the QS dB. They generate a XML file with the data that gets fed into the crystal report.
If you’ve switched to the rest interface for your workstations, I would switch back to the freight service. The rest service has a bunch of known issues and they don’t recommend using it.
It happens both ways. Quite maddening.
What data is getting mixed up? We don’t have any issues with the legacy freight service. And we ship a lot through QS daily.
If it’s a single order we’re shipping, there are no issues. If it’s multiple orders on the shipment then the product information is all wrong.
PRB0306387
1 Like
That’s really weird. Wonder what’s different. We ship multiple orders together whenever possible and don’t have any issues. I just seen one the other day that was over 20 individual orders combined on one pack going overseas.
Yeah, weird.
Back to the OT question … how do you know which fields are mapped and where they are mapped to?
1 Like
I was told by support to use REST API or the data mapping but the version we are on does not support the data mapping so I am on hold until we upgrade in a few months.
What version are you on? The FreightSVC data mapping has worked for years now.
1 Like
version 2023.2.10
Interesting. I wonder why support said that. The REST API for QS still has a lot of issues. They don’t recommend using it yet. We did some testing with it for Epicor but still use the FreightSvc.
1 Like
I don’t think we can use the FreightSVC. I looked at it and I remember thinking I can’t do that but forget why…it was a week ago. 
I do know when I do the data mapping i don’t see the custom feild.
1 Like