MFG-VAR transactions not found

Epicor ERP 10
,
1

Hi all,

So finance just closed many jobs and recorded MFG-VAR transactions to the GL accounts.

The problem is that I can see the transactions posted on the Part Transaction History Tracker but I don’t see those transactions in the Chart Tracker when looking up that GL account.

Here is one of the many parts.

(Transactions are posted in Part History Transactions)

image
image996×565 145 KB

(Job is closed properly)

image
image1110×713 157 KB

(I even ran the Inventory WIP Reconciliation report and it’s shown that the Mfg-Var transactions were posted to 50108-00-000)

image
image1371×963 182 KB

(But then in the Chart Tracker for that GL account, none of the Mfg-Var transactions show up)

image
image1407×495 162 KB

Any pointer or insight would be appreciated.

Thanks,
Dan

2

On your Inventory/WIP report it shows that they have not been posted yet. Look in the ‘Posted?’ column and you’ll see all ‘N’ (No) values.

Capture WIP probably hasn’t been run.

1 Like
3

I don’t use Chart Tracker, but assuming you did run the capture, looks like you’ll see periodic posting here…

image

And the transactions here (I moved some columns):

image

You didn’t show the Cost Transaction tab, so I don’t know if that’s the issue or not.

@andrew.johnson I agree the report says N on the posting, but he has them in PTHT (first pic), so I think that’s an older snapshot of the report.

1 Like
4

Hi Andrew,

Thank you very much for pointing that out Andrew! That is indeed the culprit. Finance swore to me that they did run the Capture WIP and apparently they did. But the catch is that they hit an error while running it and they didn’t even know about it. I retraced their steps, clear out the error from the Review Journal and re-ran the Capture. Everything looks good now!

Thanks again,
DAn

5

Then how on earth were the transactions in the Part Tran History tracker?

I guess some were there just not all?

6

Hey Jason,

To your earlier questions, usually I see the Period Posting Process then I can navigate and see the Transactions Detail & Cost Transaction. However, I couldn’t find those transactions to begin with.

Yes, I guess when Finance ran the Capture the first time and hit the error, some transactions went through and some just did not make it? But yes, that’s strange that I can see on the Part History but not the GL account.

7

Right, the posting engine churns through a day at a time. If March 1 posts without any hiccups, it goes to March 2, then March 3. If March 3 bombs, then that’s it.

You can see this if you look at the system monitor for the capture.

8

@JasonMcD - The transactions on Part Transaction History Tracker are not necessarily posted to GL. A good drilldown and reporting tool like FastClose can help researching these things. Especially helpful for COS/WIP Capture issues, which can be pretty tedious to research.

9

Right, I agree generally, but I have never seen unposted MFG-VAR in PTHT before. In my experience, those specifically only appear at capture.

Huh, although ours always say “phantom purge…” and these say just “purge…”

Perhaps there’s a step we omit routinely with job completion. For example, we hardly ever manually close jobs; I just run auto-close on the night of the 31st (or what have you).

10

You’re right about the Phantom purge WIP to Variance. My understanding is that they do not go to PartTran. But as you note, Purge WIP to Variance does. It might be worthwhile to query PartTran joined to TranGLC to get additional information.

1 Like