Hi everybody, please help me

 I am writting an intergration application with Great Plains version 10.0

Here is my flow:

1. I collected my purchase orders and used Econnect 10 to send to GP sales documents. After sending, I can see my order at Sales\Enqury\Sales Documents.

2.In GP 10 enviroment, I tried to post my sales orders to Sales Invoices. I do not use Invoicing Transaction because of this reason below

 http://www.articlecity.com/articles/computers_and_internet/article_759.shtml

3. After posting Sales Invoices, I used  Econnect Requester 10 again to import  Sales Invoices to my system.

The problem is: As I knew,  sales order, sales Invoice, Fullfillment order, back order are stored in same table (SOP10100). After creating Invoice, SONUMBE column is used to store new InvoiceNumber? How can I get original number Sales Order ID?

Thanks and best regards

Hoang Pham 

Well, this is a bunch to answer. I'm going to try to answer the spirit of your question. If I get it wrong let me know.

Using eConnect (or Web Serivces) you can send Quotes, Orders, Invoices, Returns, Backorders, and Fulfillment docs to Dynamics. These are doc types 1,2,3,4,5 and 6, in order.

You CANNOT post documents. You can send an Order, or you can send an Invoice; but you cannot POST. This has to be done inside Dynamics. The only way to get the ORIGNUM and ORIGTYPE field populated would be to post.

Hi Mr Steve Gray

First of all , I want to say Thanks for your support.

 I have another question. When exporting my purchase order to GP ( I used Econnect 10 with 2 classes taSopHdrIvcInsert. and taSopLineIvcInsert_ItemsTaSopLineIvcInsert). After sending data to GP, I see my orders come to Sales Module\ Enquiry\ Sales Document.

Why orders don't come to Sales Modules\ Sales Order Transaction. I come to Sales Modules\All Sales Transaction but I do not see my orders?

How can I change orders from Enquiry to Sales Transaction? 

Thanks and best regards

Hoang 

Well, that doesn't make sense. If the eConnect transaction completes without error, the doc is in Dynamics. I'm able to view mine at TRANSACTIONS > SALES > SALES TRANSACTION. I'm not sure when they show up in the inquiry form... I don't usually open that. I'm a developer, I only care about getting them in. The users can worry about the rest<smiles>

 In SQL, run this:

select * from sop10100 where sopnumbe = 'myDocNumber'

If you get a line, you're done.