Reconciling Stock Status to GL - Cost Adj Transactions

[georgeharmon]

I’ve only been working with Epicor for last 10 months and trying to figure out Stock Status to GL Recon. On my journey, I have noticed that Cost Adj - in particular when you change a cost std the inventory will reval and book an adjustment on GL which is correct in my opinion. However stock status does not update for such a transaction and will not agree to GL. My question, is there a method to correct the dollar valuation in SS so that it aligns to GL? Or is it better to think of SS as just a good qty tracker? Should I focus on simply getting the stock qty and use current cost stds in Epicor and do the math to value the inv?

[aosemwengie1 (Alisa Osemwengie)]

This is a perennial topic here . . . one of many threads on the subject. Epicor 10 Stock Status Reports

[JasonMcD (Jason McDermott)]

Agreed this has come up often, and SS is not a subledger, etc. See also:

Everything wrong with Stock Status Report

I think it’s always a good time to bash the SSR. The title is from @ckrusen in this post. We had a fight over this yesterday here, so I thought I’d open some old wounds. #1: It uses company (Part) settings and not Site (PartPlant) settings Like quantity-bearing! Yikes, this is dumb! I'll spell it out, but this is obvious, right? We have two sites. Some parts (like small bolts and washers) are non-QB in the MFG plant but are QB in the service center. If the part is set as non-QB on the PART leve…

But I see you’ve asked about this before, so I’ll try to give you the benefit of the doubt…

@georgeharmon

However stock status does not update for such a transaction and will not agree to GL

This at least should happen. If you compare GL and SS before a cost adjustment to GL and SS after (with nothing else in between), yes it should reconcile.

I mean, if they were out of sync before they’ll be out of sync after.

But the cost-adj. change should be predictable enough.

[timshuwy (Tim Shoemaker)]

The Inventory / wip recon report is more of what you might be looking for. It should show you the change that happened within the period. but note that it is very complex… you can look at it for a specific gl account, and/or a specific date range.