Cycle Count Process No Reason Code

Epicor ERP 10
1

When a quantity adjustment is made, our configuration requires the user the select a reason code. But when the cycle count process makes adjustments, it leaves the reason code blank. Is there a way for the cycle count process to add a reason code?

image
image.png1039Ă—167 42.5 KB

Thanks!

2

More importantly, is the desired GL account hit?

We use Reason Codes specifically for determining the GL account to hit.

And if every other ADJ-QTY requires a reason code, wouldn’t it be implied that a blank code means it was a cycle count (and/or physical inventory)?

1 Like
3

If you do not select reason code in “Count Discrepancy Reason Entry” . It will show blank. You need to select a reason code in Count Discrepancy Reason Entry form.

1 Like
4

Hi, a little late to the thread but how do you fix this after posting?

We did not add reason code to one part upon posting the discrepancy and now this part’s variance price is sitting in our Suspense account. Is there an Ops way to fix this or are we limited to journal entry?

5

You could:

  1. Create a reason code with a GLC that points to the suspense acct.
  2. Do a Qty Adj (opposite sign of the CC’s QTY-ADJ tran). That would effectively undo the GL trans from the CC entry.
  3. Finally, do another Qty Adj - using the proper Reason Code - to account for the CC’s original qty change.

Or more simply, have accounting do a JE.

6

Thank you sir!

7

I’d really suggest you go the JE route. Once you use that Reason Code, you might not be able to delete it. Then you’ll forever have that code in the list that users could chose from. And odds are, that someone will choose it by accident.

There are ways to hide it, but that’s a pain to set them up.

8

Change you inventory adjustment account on you default Inventory COS WIP GL control code (it’s pointing to suspense right now per your explanation). If you require reasons for quantity adjustments, you’re probably safe just leaving this set on the control code, but you could set it back to suspense after running your cost capture and finalizing the transaction in question.

9

Understood, we definitely have to go the journal entry route, doing further digging I found that our control code for Inventory Adjustment was pointing at suspense, still working our set ups out before we go live.

10

Yes, that’s perfect. I saw later on that almost all of our COS/WIP codes are pointing to suspense. Thank you so much for your feedback.