Hi Thierry,I seem to be able to start the InvWIPRec as a pdf and then immediately start as a CSV and both reports complete at pretty much the same time.I will investigate the Routing option though.Re the CSV export - I only recently discovered the CSV option at the top of the output format list as my screen defaults to pdf with the CSV option hidden at the top of the list:- I’ve used the Excel Data Only option for years and struggled with the format.The CSV format is so much more manageable from a Pivot Table perspective.I shall email you re FastClose as we are keen to understand what Visual Management options are available re Epicor Data.CheersMartin
Hi Thierry,I’m sorted now thanks.Managed to speak to Matthew Sparks (an Epicor gentleman from the States) who helped determine that we had an active PE Log on the COS WIP transaction type - this was dramatically slowing the report. We suspect the log has been active since we went live on Epicor in 2011. :-(Once un-ticked the process went from ~3.5 hrs to ~ 3 minutes (for a months data).In answer to your question when extracted to CSV we have just over 24,000 Dr/Cr transactions on the report (not sure if this a lot).In response to your comment re the Crystal report I now run the report twice - once to pdf and then again to CSV. The CSV output looks a little untidy but is extremely useful when viewed by a Pivot Table in excel - this is quite satisfactory for our purposes but I will investigate FastClose as we are looking for some kind of Visual Management Tool to use with Epicor.If you could forward contact details for Nick that would be great.RegardsMartin
Hi Other Epicor Users.Nobody seems to be experiencing speed issues to the extent I am.Can I ask with what frequency people are running the CCW (weekly/monthly etc) and how long the InvWIPRec is taking to complete?ThanksMartin
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.