Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Posting Issue with Sales Order and Inventory

Posted on by 935

I am having trouble with the posting accounts for a sales orders.  In the setup we have to take accounting distributions from inventory item.  It should be hitting cost of goods sold, accounts receivable, inventory and inventory offset.  But when we create the sales order it is not taking from the inventory item account distributions

*This post is locked for comments

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: Posting Issue with Sales Order and Inventory

    The blank distribution accounts are a result of accounts not being listed in the items.  When you create an item you must fill in those accounts.  Most firms put a list of the accounts, including the 4 you listed, in an Item Class and assign the class to the items.  The system does not pull accounts from the class but, either when you change data in the classes or create a new item, the class information is copied to the items.

    Check your items to make sure the accounts are included in the accounts screen of the items.

    All of this, including how to chase the source of accounts and other posting issues, can be found in our Inventory Flow and Posting manual.   It is available on our web site listed below.

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Posting Issue with Sales Order and Inventory

    KPW, distribution account fetched based on the below SOP setup Posting Accounts From option. Do you setup item/Customer in that window? If customer then changed to item and reenter the SOP transactions. This time it will takes the inventory distribution accounts.

    Hope this help!

  • kpw Profile Picture
    kpw 935 on at
    RE: Posting Issue with Sales Order and Inventory

    Yes we are seeing the wrong accounts or no account in the line item detail and the accounts are not posting to the GL accounts.  

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Posting Issue with Sales Order and Inventory

    How do you know it's not taking the correct inventory account?  Those accounts aren't hit until the invoice is posted.  Are you seeing the wrong account in the Line Item Detail?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans