Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Sales Order Location

Posted on by 585

Hi,

I have written some code to pull a list of Sales Orders:

wsDynamicsGP.GetSalesOrderList(new SalesOrderCriteria(), context);

wsDynamicsGP is the web service API:

http://msdn.microsoft.com/en-us/library/cc508537.aspx

I have MS Dynamics GP 2013. I cannot find any of these transactions under Sales > Sales Orders Transactions. Am I looking in the wrong place? Is there a way to look up transactions by customer?

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Order Location

    What do you mean exactly by "All Sales Order Transactions" tab ?  I have GP 10.0 so maybe it is a new feature I dont know yet... ;)

    But if you mean by the Sales Transactions Entry window, using the search, these are open sales orders.  Once they are closed, they are moved to history.  Thus, you can get back to it by the "Sales Document" inquiry and open them in read-only via the Sales Document detail.

    Use the SalesOrderCriteria variable to filter for the Transaction State in parameter 1...  this parameter accepts a list of  Sales Transaction states, which you can find here : msdn.microsoft.com/.../cc533768.aspx

    Specify whether you want to filter for "Work" or "History", in this case, I suppose you are looking for "Work" only sales transactions.

  • jmawebtech Profile Picture
    jmawebtech 585 on at
    RE: Sales Order Location

    Hi,

    I see the transactions in that area ( see above image ). Thanks!

    How do I get them into the Sales > All Sales Order Transactions tab? Are these documents in a pending state? Do they need to be associated with a sales person? I feel like I am missing a field.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Order Location

    And if you go under under "Sales / Inquiry / Sales Documents", do you see all these transactions you get from the API ?

  • jmawebtech Profile Picture
    jmawebtech 585 on at
    RE: Sales Order Location

    Hi,

    Here is my code:

           public SalesOrderSummary[] GetSalesOrders()

           {

               // Create a context with which to call the service

               context = new Context();

               // Specify which company to use (sample company)

               companyKey = new CompanyKey();

               companyKey.Id = (-1);

               // Set up the context object

               context.OrganizationKey = (OrganizationKey)companyKey;

               return wsDynamicsGP.GetSalesOrderList(new SalesOrderCriteria(), context);

           }

    I am using the sample company, Fabrikam, Inc.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Order Location

    How are you declaring your context variable ?  If your issue is that you are not finding any of the transactions listed, I would bet you are not connected to the right company....

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans