Reason Codes
-
Reason Codes
Posted by Elaine Salyer on July 7, 2020 at 11:36 am-
?We set up reason codes a while back and I just ran into an issue. When the reason codes were setup we assigned a default offset account. It was my understanding when an inventory adjustment was made using this reason code the offset account would default to the account assigned in the reason code. Well that is not happening, yesterday an inventory adjustment was made with a reason code and the distribution register shows a different offset account number.
Can anyone tell me why this is happening?
——————————
Elaine Salyer
MAS, Inc.
Richfield OH
—————————— -
Hi ,
In general what you’ve stated above is true.Ā I’ve run across a few scenarios where things get interesting though.Ā I’ll outline them high level below, and if any seem particularly relevant, I’m happy to go into more detail.
1.) A user with proper access could still override the distribution assigned by the reason code.Ā I’ve seen this happen many times where a user thought they were doing the right thing by reassigning the account number.
2.) Site Substitutions – if you use the “Segment ID’s for sites” option in the inventory control, GP will substitute the related value into the default offset account assigned in the reason code.Ā This may or may not be a good thing depending on your intent and whether or not the account with the substituted value actually exists.
3.) Account Level Security – I’ve seen a few instances where users didn’t have access to the proper accounts under Account Level security.Ā This can cause a distribution to appear blank if a user looks at the distribution window which may then lead them to believe they need to enter an account.
Does that make sense?Ā There may be other scenarios that could cause the issue you’re describing, but the ones listed above are the ones I most commonly come across.
Thanks,
Samantha
——————————
Samantha Higdon ,CPA,CGMA
Consultant
Lagom, LLC
Carmel IN
——————————
——————————————- -
?Samantha,
Thank you for responding. I have ruled out user intervention, but your scenario number 2 might be it. I am not sure I can answer the question about segment IDs, so here is a screen shot of the Inventory Control window. I think we use this option but I am unsure.
——————————
Elaine Salyer
MAS, Inc.
Richfield OH
——————————
——————————————- -
Hi Elaine,
That is the field you’d be looking for.Ā Ā
The next things you’d check to confirm if this is the culprit are below.
1.) Confirm the site(s) involved in the transaction you noticed the issue on.
2.) Go to Inventory>>Cards>>Sites.Ā Pull up the site in question. At the bottom of the window there is a field for Account Segment ID.Ā If this is filled in, take note of it.
3.) Look at the account distribution that’s wrong.Ā Is it “close” – meaning that all segments match expectation except the one you have defined as your Segment for Site ID’s?Ā If so, then theoretically the segment that’s off SHOULD be the segment highlighted in the Site set up window I have shown above.Does that make sense?
Thanks,
Samantha
——————————
Samantha Higdon ,CPA,CGMA
Consultant
Lagom, LLC
Carmel IN
——————————
——————————————- -
?Hi ,
I am beginning to think there is a customization that is behind this. We have many customizations?, so many since I never worked with GP until I came here I don’t always know what is GP and what is custom. Having said that this is what I found.
The account segment ID is filled in on the site maintenance card
The default offset on this particularĀ reason code is 2120-29-000
But the journal entry createdĀ Ā for a decrease inventory adjustmentĀ was
Debit inventory offsetĀ 2120-20-000
Credit inventory 1300-20-000This is so frustrating, I am about ready to give up and just do what I have been doing since I discovered it (making journal entries). But I am concerned that if it is doing it with this reason code, what is it doing with the others.
Thanks for your help.
Elaine
——————————
Elaine Salyer
MAS, Inc.
Richfield OH
——————————
——————————————-
Elaine Salyer replied 6 years, 4 months ago 1 Member · 0 Replies -
-
0 Replies
Sorry, there were no replies found.
The discussion ‘Reason Codes’ is closed to new replies.



