Solved

6 Topics

M
melissahInspiring
asked in Kinetic & Epicor ERP

Excel Data Only Some GL reports error out when trying to print to Excel Data Only

Invty WIP Reconciliation & Journal Listing reports will not render to the Excel Data Only option. Had this issue when upgraded to 2022.2.14. Support said broke will be fixed in future.I updated our test environment to the .25 and then .28 patch and these reports run fine using this option. Updated last night to the .28 patch on Production and still have error out issues.Here is part of message:Program Ice.Services.Lib.RunTask when executing task 1327233 raised an unexpected exception with the following message: RunTask:System.ArgumentException: The shared data source must be specified. (Parameter 'sharedDataSourcePath')   at Ice.Lib.Reporting.SsrsReportImporter..ctor(SsrsReportingServiceCaller serviceCaller, String sharedDataSourcePath) in C:\_releases\ICE\ICE4.2.200.0\Source\Shared\Lib\RoutingBreakingRules\SsrsReportImporter.cs:line 35Any ideas?From a database standpoint I back up Prod DB and restore to Test DB so all is same data. Both dbs are on the Compatibility lever 130 (2016

5
M
4 months ago
M
melissahInspiring
asked in Kinetic & Epicor ERP

STRING_SPLIT error when trying to print a PO for international supplier

Last week we had an issue where we could not get a PO to print for a supplier. Turns out it was for a new ship to that is in Canada. When I looked at System Monitor the error referenced a STRING_SPLIT error.Contacted Epicor and googled it and got a recommendation to up our compatibility level on the SQL Server 2017 to the 140 level from the 120 level I had it set on. Great PO and Subcontract Pack Slip now printed.However, there were some SSRS custom reports that started taking 3-5 minutes to render where they had been seconds. Not all reports, just some. And when those were running the SQL Server CPU pegged out at 100%. Not good. I contacted Epicor again, since they assured me that upping that level would not affect anything else in our system. I put compatibility back at 120 since the Intern’l supplier POs will be few and far between so I’ll just work around it. But now there is a dashboard that shows a “Bad SQL Statement - See Logs” error. When I review the logs, it shows that same S

3
M
7 months ago
K
kstinnettInspiring
asked in Kinetic & Epicor ERP

Calculated Field in Report Data Data Definition (Quote Form)

I am trying to add the Payment Terms to the quote header on the Quote Form. There is a calculated field in tthe RDD but it doesn’t show up in SSRS. I added the field in the query and added the field in the field list. However, it just comes back blank. How do I even know what the Terms Desc field in the RDD is pointing to in the Calculated Field.

4
K
1 year ago
M
melissahInspiring
asked in Kinetic & Epicor ERP

Capture cos\wip activity out of balance

We are trying to do month end and when running the Capture process it errors out. We reviewed the Review Journal and it shows the transaction being out of balance. We found the PO that is the issue and throwing the balance off by 88.10. The PO release did not show or have the default GL account listed. I re-open the PO and releases and did the Get Default button as one of the Epicor knowledge articles suggested. Worked great.Ran capture again but still errored. I wanted to delete the receipt and redo (to have it pull correct info for the transaction)it but we already invoice and posted for this po receipt and it won't allow me to delete and redo.What are our option here so that we can get the capture in balance and finish our month end process?Thank youMelissa H

3
M
2 years ago
M
melissahInspiring
asked in Kinetic & Epicor ERP

10.2.500.30 - HCM to Epicor payroll integration - Reports

We are now integrating with HCM module and I am trying to create some reports for audit purposes using SSRS. I did get setup as a payroll manager so I have the correct security, but when changes are made in HCM and information is successfully updated in Epicor, those employees data is not showing up on my reports.For example, I made a change to an employees Comment field in Epicor Payroll entry. HR staff made some contribution changes to a few staff members that did successfully populate in Epicor as we would expect. However, now those 5 employees deduction data (for example) will not render on my report. If I just run an employee list I got all 195 people. If I add fields for the PREmpDeduct table or rate info from the PREmpRt tables (2 different reports) those 5 staff members info will not render on report.Thank youMelissa

1
M
2 years ago
D
david.hiteKnown Participant
asked in Kinetic & Epicor ERP

Move Request Checkbox in MES

Does anyone have any customization code that can control the Request Move check box on end activity in the MES screen.   I want the ability to always have that unchecked to start with.  Struggling on find the correct customization to force it to be unchecked.  Thanks as always for your thoughts and time!

3
M
3 years ago
Terms & Conditions