Journal Listing Error

[dmmory (Daniel Mory)]

Our accounting department ran a Journal Listing for the previous month, and it reported this error in the System Monitor:

Program Ice.Services.Lib.RunTask when executing task 10615306 raised an unexpected exception with the following message: RunTask:
Ice.Core.SsrsReporting.SsrsCaller.SsrsException: The SSRS server returned the status code 500 (InternalServerError) with the following error text:
Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 1054048. Maximum rows: 1048575. —> Microsoft.ReportingServices.ReportProcessing.HandledReportRenderingException: Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 1054048. Maximum rows: 1048575. —> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors

We got around this by running the report for shorter date ranges, but we’re now wondering by the report is pulling this many rows.

It appears that journal entries are being created for every STK-MTL transaction.
There are large numbers of rows in GLTrnDtl table with a description like this:

STK-MTL Part:19P583-01 Job:807379/11/160

They seem to coincide with when the Capture COS/WIP Activity process was run.

We updated to Kinetic 2024.2 a couple of months ago, and it started happening shortly afterwards.

Does anyone have any idea what’s happening here?

[gpayne (Greg Payne)]

Yes, They made an ill advised change to not summarize the periodic processing entries.

The quickest way to get them back it to follow this KB

Elimination of Periodic Posting Process - done in 2022.2

I need to get my summary data back, here is my support ticket with Epicor: In October of 2023, after our upgrade, the behavior of posting from “Capture COS/Wip Activity” changed, and we did not make the change. We are aware of the change for the text “Period Posting Process”, and that is not what we are concerned about. Our system went from summarizing the data for IJ COS and WIP to no summarization. We now have millions of records and the GL for inventory is no longer useful. The settin…

Here is a post I made about how to re-summarize them and to get the details on ones you want.

Elimination of Periodic Posting Process - done in 2022.2

@utaylor I found a KB KB0124377 (link below) and the change is not bad, but I also found a gold mine as an offshoot of this change. There is a new function User Extended Description which the word doc at the bottom of the KB tells you how to change the value of the function to False. There is also another function Compose GL Transaction Text for PartTran which sets all of the Transaction Text values and is referenced in every posting rule now. It has every transaction type already built. If you…