Unbalanced WIP Recon report

[ckrusen (Calvin Krusen)]

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.

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 Order (BTO) items. But some one decided to create part numbers for them, after they were received as BTO items on the PO. The user then went back and changed the Order and PO to use the new P/N’s. It could have all been from some very unfortunate timing. The Tran type to be used when the item is received, is specified by the PO Release.

If the PO Receipt was created while the PO had them as BTO items (instead of stocked items), and then the PO changed, and finally the Receipt saved, then it might have fubar’d the PartTrans for these items.

1. Anyone ever run across this?

2. How should I go about fixing it?

[JasonMcD (Jason McDermott)]

I think you just need to define a GL somewhere in the hierarchy.

Have you looked at the PE Log viewer? (You probably need to enable COS/WIP and/or clear the log, then run the report again, as limited as possible.)

[Norelco2 (Andrew Crank)]

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.

[ckrusen (Calvin Krusen)]

yes. those unbalanced trans showed up in the RJ.

[ckrusen (Calvin Krusen)]

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

[JasonMcD (Jason McDermott)]

Oh, it’s awesome. It’s like a debugger for the GL controls.

That’s the name of it - it’s a screen.

[Norelco2 (Andrew Crank)]

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.

[Rick_Bird]

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

MTO AR Invoice Goes To Review Journal (not balanced)

Thanks Brett, I really think this would help me ID where the problem is. However, after enabling the AR Invoice (heck I even enabled ALL for the company in question) and logging out and back in and attempting both a repost AND revalidate in the Review Journal, when I attempt to bring up the PE Log Viewer I get the error message: ‘Impossible load information from PE Log’ [image] I looked for a file in the location specified on the Settings tab as Export & Import File and there was no pelog.xml…

[ckrusen (Calvin Krusen)]

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:

We are multi site and use GL Controls to substitute the Div segment, based on the site. But everything has worked fine up until now.

[JasonMcD (Jason McDermott)]

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.

[JasonMcD (Jason McDermott)]

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

[ckrusen (Calvin Krusen)]

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 Account specified in the “Inventory COS and WIP” has a GL Acct setup for every site.

[JasonMcD (Jason McDermott)]

Also, you’re in a Cost of Sales section and the issue was PUR-UKN. I know you said it was a BTO thing, and I don’t really have experience with that, but I thought it handled the purchase and shipping transactions independently.

[ckrusen (Calvin Krusen)]

I think the PUR-UKN processed okay. I think its trying to calculate the COS for that item when it was shipped/invoiced.

[JasonMcD (Jason McDermott)]

'Cause the thing is, in that screenshot, it grabbed an account (my green arrow), and that’s enough to post with.

It then tries to substitute a warehouse GL for the division, and didn’t find one, but then it goes to the plant GL and there is one. Then it tries to get a department from the Sales Category, but there is none, so that fails. But that’s still OK. When all else fails, it can always use that first account.

[ckrusen (Calvin Krusen)]

So you’re saying those 4 lines aren’t really a problem, but rather the one pointed to below:

[JasonMcD (Jason McDermott)]

Yahtzee!

[JasonMcD (Jason McDermott)]

@JasonMcD

Then it tries to get a department from the Sales Category, but there is none, so that fails. But that’s still OK. When all else fails, it can always use that first account.

FYI, I think in your case it will still flex the division with the plant GL, even without flexing the department. We don’t use departments GL’s here much. It still flexes the division as I want, though.

[ckrusen (Calvin Krusen)]

Well… I’ve know it doesn’t balance from the start… I pointed out the trans in the original post that have no offsetting GL Tran

We setup a GL Acct for keep BTO separate from real (counted) Inventory. Normally a BTO Receipt Debits this special Acct (1166-00-01) and Credits Accrued Rcvng’s (3324-00-01)

I see Debits to 3324-00-01, but nothing for 1166-00-01

[JasonMcD (Jason McDermott)]

What’s the clearing account show in the PE log viewer?

That “BTO” reference in the guide is misleading, I say… It’s any “Other” PO line.