The title pretty much explains everything. I'm writing a .net windows app to extract data and insert sales invoices into GP and I would like to know if this is the best forum to ask.
Thank,
Ignacio
*This post is locked for comments
I have created custom webservice using eConnect to get Next Transactions Number.
sandipdjadhav.blogspot.com/.../next-document-number-web-service-using.html
Thanks
Sandip
Use the SOP40200 and SOP40300 tables to get the ID and then the next number.
how do you get the invoice number generated by GP?
I mean, I can let the sales order number be generated by GP right?
There is no automatic log file that logs what invoices were imported, that is up to the programmer. I usually have a flag field I flip in my source tables to indicate whether that invoice was transferred or not. You could either write some code after the entire import is complete to check for any missing invoices or you can do it as you are importing. This is now totally up to you.
Yes, I did.
I saw the example that add a new sales order but I found it kind of weak, all I obtain is a bool indicating if the operation succeed or not, I would like to know the invoice number assigned in case of success and otherwise an error message indicating why the operation failed.
Is there any way of doing that?
Thank again,
Ignacio
eConnect is best for writing since it will do a bunch of data validation for you. I would normally use a stored procedure in SQL or embed a direct SQL statement in my C# code to pull data out of GP. Have you looked at the eConnect sample code examples in the eConnect folder?
Will be a custom app written in C#
First question :)
To export lists from GP (customer, inventory, invoices) , do you use eConnect or go directly to SQL ?
This certainly is a good place to start. Is this going to be a custom application or are you using something like Scribe to get the data into GP? Personally, I use Visual Studio 2008/2010 C# with eConnect. I am sure others with have other options.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,430
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
