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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Sales Order Distribution Problem

(0) ShareShare
ReportReport
Posted on by

I have a problem that I have not encountered before.  I am implementing a new GP system for a distributon business and have set the options under Tools-->Setup-->Sales-->Sales Order Processing-->Posting Accounts From to pull from the Item and not the Customer.  This is necessary as my customer has different Sales and COGS for each Item type.

The issue is that when I have the system set like that and I create an Invoice via the SOP process, the Distribution on the Invoice is hitting AR (as it should) and Inventory (as it should), but the Sales and COGS are hitting the Inventory Account.  In other words, the Invoice Distribution has one entry for AR and three hitting Inventory - not good.

It works fine if I change the option from Posting Accounts From - Item to Posting Accounts From - Customer, but that won't work for my situation.

I've also tried this with multiple Items and multiple Customers.  In addtion, I've removed the GL Accounts entirely from the Item and it still created the same entry.  Further, I've looked at every possible setup I can think of - all of the Posting, Sales, Purchasing, and Inventory settings via Tools-->Setup.

Does anyone have ideas on what the issue may be?  Or where else I should look?  This is killing me!

Todd Bowlsby

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    Todd:

    What version of GP are you using, and what service pack do you have installed? Do you have any 3rd party apps installed. I am running GP 10 with SP 3 installed and I just changed my setup options from Account from Customer to Item and then created a Sales Transaction. When I go into the line details window for an inventory item and then click on Distributions I see the COGS account from the Item Card and when I change it back to account from Customer then repeat the process I see the account from the customer card.

    I would try deleting the COGS and Sales account from the Inventory and Sales series in the Posting Accounts setup to see if that is where the accounts are coming from.

    Kevin

  • Bullsai Profile Picture
    on at

    Kevin:

    Forgive me, I should've mentioned that.  Yes, I am currently running GP 10.0 SP3.  I also tried deleting all the Accounts from the Item, as well as creating an entirely new Item - this did not change the situation.  Also, when I go into Fabrikam there is no issue, so I'm pretty certain it's just a setting I'm missing somewhere.  That being said, I don't know where that would be, since I've through every setting at least four times.

    Thanks for the response.

    Todd

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans