We’ve run into a problem where the Capture COS/WIP won’t process, because of out of balance transactions. Here’s the Wip Recon report. [image] 1 it doesn’t balance 2. there are no offsetting GL trans for those PUR-UKN transactions. I think this happened because 4 parts were initially Buy To Or…

Did anything hit the review journal or is it not even making it that far? We have the capture COS/WIP hit the review journal a couple times a year due to… helpful users.

yes. those unbalanced trans showed up in the RJ.

I feel Like I should know this … But what is the “PE Log viewer” ??

Oh, it’s awesome. It’s like a debugger for the GL controls. That’s the name of it - it’s a screen.

If inventory is accurate and you just need it to balance and post you should be able to add the offsetting accounts in the review journal. Then you can re validate and confirm the entry to at least get this one posted.

Calvin, Here was my adventure with figuring out a similar problem with the PE Log Viewer: [image] MTO AR Invoice Goes To Review Journal (not balanced) Epicor ERP 10 Thanks Brett, I really think this would help me ID where the problem is. However, after enabling the AR In…

Ahhhh… so “PE” is for “Posting Engine”… So after enabling logging and re-running the Wip Recon Report (which uses the posting rules to process - this duplicating the error condition), I see: [image] We are multi site and use GL Controls to substitute the Div segment, based on the site. But ever…

Calvin, those warnings are common and not bad, per se. Maybe you don’t WANT to define a division GL. We have them on one site but not the other (the main site). There has to be another error somewhere.

OK wait, I read the second error more closely. It looks like there’s a sales category GL that exists but is blank.

I jumped on them being the issue, as I’ve had problems in the past where a substituting GLC (Like Site -> Division) was specifying an Account number that didn’t exist (we added a site but missed creating a GL account with that Division specified). But this doesn’t appear to be my case. Every Accou…

Unbalanced WIP Recon report

Epicor ERP 10

Rick_Bird (Rick Bird) May 1, 2020, 7:08pm 8

Calvin,
Here was my adventure with figuring out a similar problem with the PE Log Viewer:

Topic		Replies	Views
Unbalanced Inventory/WIP Recon Epicor ERP 10 wip-recon	7	1343	November 27, 2020
Capt COS/WIP won't post Epicor ERP 10 wip	7	1691	September 3, 2019
COS/WIP balance issue Epicor ERP 10 epicor	5	2743	January 19, 2021
COS/WIP capture is out of balance - help Epicor ERP 10	13	5511	November 27, 2024
Work In Process Epicor ERP 10 epicor	4	6535	December 8, 2022

Unbalanced WIP Recon report

Related topics