We have recently migrated from E10.1.400.20 on Premise to Kinetic in the Cloud.
Prior to the ‘upgrade’ the InvWIPRec report used to take ~ 7 minutes to complete.
Since the move to Kinetic it’s now taking in excess of 3 hours (for a months data).
The other frustration is that now we’ve lost access to Crystal reports we seem to have to run the report twice - once as a pdf (for audit purposes) and then again as a CSV (which we use for analysis).
In E10 we used to be able to preview and then either export to csv and/or print to pdf.
We do not have an excessive number of transactions per month (~400-500 pages of pdf report).
Epicor are suggesting that the issue relates to old Nil Value ADJ-CST transactions that are not being posted to the GL and are being evaluated each time the report is run. Their solution is to flag the transactions as ‘posted to GL’.
I run the report from 01/01/2020 to end of current period (31/03/2022) to pick up any old transactions.
The report takes 6 minutes to clear data pre 01/03/2022 and then the rest of the time to process/evaluate March transactions.
I’ve pasted an extract of the log file (excel):-
Is anyone else struggling with InvWIPRec report on Cloud?
Does anyone have any idea what may be slowing the report in Cloud when it ran quickly on Prem?
We are generally experiencing slightly slower processing on Cloud than on Prem but nothing like the issues with InvWIPRec.
Appreciate anybody’s feedback as Epicor don’t seem to be able to resolve.
Thanks
Martin