Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Item GL Account
Microsoft Dynamics GP (Archived)

Item GL Account

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello all,

could you please help me answer the question?  I set up a new inventory item in GP with sales account that has the department number and not default an account in posting account.  It doesn't pull up the account that I set up within that item when in put in an invoice, but default with department 00 in the distribution.  Is there something else that I need to check or turn on in order for the distribution to pick up the sales account number that I have in the item?  Thanks for helping.

*This post is locked for comments

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Item GL Account

    The other place to look is at the customer record and insure that the choice to select from the item and not from the customer.

    What is coming up is likely the Sales / Item account attached to the customer.  To TEST and TEST only - go to the Customer Card, select the Accounts window - write down the accounts in the list - then blank them out.

    Create a new sales document with the item in question and see what happens.  IF the same result, then you have a CLASS issue - if different - then you have a select account flag set wrong.

    Let us know what you find.  Hope this helps.

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Item GL Account

    Is the item type 'sales inventory'?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item GL Account

    Thank you.  I checked the sales order processing setup and for sure it marked for posting from item.  I also checked posting account from Admin. There is no posting account for sales, which makes sense because we use different department number in GL account. Is there other set up that I need to reset or refresh the system to make it works?  Thanks.

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Item GL Account

    If your items are attached to an item class, you need to ensure that the accounts there are consistent

  • Suggested answer
    Angel Nuñez Profile Picture
    Angel Nuñez on at
    RE: Item GL Account

    Dear, check the Sales Order Processing setup to see if it is setup to use the Item or the Customer accounts for posting.

    Posting Accounts From

    Choose whether you want the posting accounts selected for the customer or the item to appear as the default entries during transaction entry. For example, the Cost of Goods Sold account is used in both the Sales series (customers) and the Inventory series (items), but you may have assigned different accounts for each series. Your selection here will determine whether the Cost of Goods Sold account and other accounts assigned to the customer, or those assigned to the item, will appear as default entries when you enter documents.

    Item

    Mark this option to select the posting accounts set up for an item appear as the default entry during transaction entry. The account set up in the Inventory series will be used.

    Customer

    Mark this option to select the posting accounts set up for a customer appear as the default entry during transaction entry. The account set up in the Sales series will be used.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans