We are upgrading to Kinetic from 10.2.500.40. I am having issues with the ARForm Report Data Definitions not importing from 10.2 to Kinetic. According to the whitepaper Epicor sent me, the Report Data Definition will have to be recreated. Any suggestions other than having to recreate the wheel?
We had to manually add several fields, but the RDDs just came over in the database. What’s your environment?
1 Like
We are vetting Kinetic 2024.1. We are coming from 10.2.500.40. It seems to be just the Report Data Definitions for ARInvoice Form. I was able to import the RDDs for Order Acknowledgement
When I upgraded the DB to Kinetic, many of the RDDs did not work. I was told by Epicor that they no longer deploy the Standard SSRS reports and I had to go to each form and print then I could import the customized reports. I have done that, and it is hit or miss.
1 Like
First question: are your RDDs custom or the default?
They are custom. Former employee did not complete understand how the RDDs worked so he added tables that were already part of the Linked tables. And he may have synced the datasets, which you know should never be done.
I can say that there were a few calculated fields added to the RDDs that we had to manually add in our custom RDDs. It wasn’t too bad once you knew what you were chasing. See if this post helps you identify some of the fields to go after.
1 Like
I don’t think this will apply. We are going from 10.2.500 to 2024.1. This is the link that Epicor gave me.
https://epiccare.epicor.com/epiccare?id=epiccare_kb_article&sys_id=c9617a40db2b6a04b3227e09af96194c
We are still on 2021.2 - so I am not sure what they might’ve added to the reports between my version and yours… but it’s the same principle. Rather than re-create the RDD, though, you might be able to salvage the one you have currently by just adding in the known fields that were added. In that link, I spell out what fields I had to add to each RDD in order to get them working again. That gets you to 2021.2. Are there any more fields added since 2021.2? I’m not sure. You might be able to sniff it out in documentation. Or you might be able to open up the new standard RDD and give it a review to see if there are any new calculated fields beyond what yours has. I can’t say for sure this will work… but it’s a strategy. And it’s one that I know did work when upgrading from a version similar to yours into Kinetic (albeit 2.5 versions earlier in Kinetic). I’m assuming you’re on-prem? Use SSMS if you can. That helped me. You can essentially re-write the query from the RDL file but run it against your report server database and it gives helpful errors that will help you identify which fields are missing.
1 Like
The AR Form RDD is known to misbehave. I think you will have to do that one manually. Other ones should work fine though.
2 Likes
That’s what I’m afraid of. I want to do the RDD the correct way and eliminate the unnecessary tables, etc. But it is what it is.
We just upgraded from 10.2.600 to 2024.1. We also had to recreate the custom RDD for ARForm as well as the Job Traveler.
1 Like
It is a mis-behaver indeed.
2 Likes
I am going to import the RDLs and then recreate the RDDs for the ARForm.
2 Likes
It sucks, but I think that is your best option. At least this way you know it is done correctly.
3 Likes