web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Reason Code Offset Acc...
Microsoft Dynamics GP (Archived)

Reason Code Offset Accounts are supposed to be OPTIONAL

(0) ShareShare
ReportReport
Posted on by mebenz 3,815

Each class of items in our inventory have different inventory offset accounts.  We would like to use Reason codes for our adjustments.  Accounting to Dynamics help "Entering an account is optional, if you don’t specify an account for the reason code, the standard account for the item will be used."  When I try and save without an account, it says it's required. 

???? 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Well, I have just been testing this case thoroughly to figure out what is the predefined functionality of the reason code. 

    It seems to me that there is a constraint on the application level not to allow a reason code to be saved without a default offset account. Although, what's mentioned in the documentation is correct, because if there is no offset account, the original offset account of the item will be used. Let me tell how i got to know this,

    After saving a reason code with a dummy offset account, i just updated this offset account field on the SQL level to 0 (Reason Code Setup Table | IV40300). When I went to enter an adjustment with the same reason code, the original offset account was retrieved from this item. 

    Definitely, the update on the SQL level is not a recommended solution to consider, I believe this could be reported on MS connect so that it could be considered in further hot fixes.

  • mebenz Profile Picture
    mebenz 3,815 on at

    I didn't even think of that thank you.  Will update that table.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Most welcome,

  • Community Member Profile Picture
    Community Member on at

    Mr. Mahmoud

    it is a good idea

    i just update the all reason code with  this sql

    update IV40300

    set OFFINDX = '0'

    but is there a statement to make a trigger or a default 0 value for any new reason code.

    thanks

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    How often do you configure new reason codes !

    I would never expect a company to have more than a bunch of reason codes; which are generally common such as hospitality, wastage, damage ...etc

    In case this is a frequent and required task, you can create a trigger on the reason code setup table (on insert) to update the associated offset value to zero.

    Remember, this is not a supported resolution.

  • dschedeler Profile Picture
    dschedeler 15 on at

    I have tried setting the offindx value to '0' and when I try to create an adjustment transaction I still get an error stating that the Inventory Offset posting account is missing and it won't allow the transaction. Am I missing something else as far as set up?

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    You may open the distribution and check the inventory account in addition to the inventory offset account, the error could be related to the inventory account rather than the offset one.

    Your feedback is highly appreciated,

  • dschedeler Profile Picture
    dschedeler 15 on at

    When I open the distributions, the inventory account is correct and the inventory offset account is blank. From what it says earlier in the post, I thought the item inventory offset account should default in.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Go to the item card, and check the inventory offset account.

    Is it filled out ?

    Your feedback is highly appreciated,

  • dschedeler Profile Picture
    dschedeler 15 on at

    All of the accounts are filled in on the item card. Actually, if I run an adjustment transaction without a reason code, the correct distributions are used for the transaction. The problem occurs only when I try and use the reason code.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans