GP 2010 Web Services PayablesDocument - Get next voucher number

(0) Share

Report

Posted on by Ed Morris

190

I have developed a C# program which uses the GP 2010 R2 web services model to import expense reports into a payable batch. After getting through many difficult issues I have found myself with one last one, how to get the CreatePayablesInvoice method to auto populate the key field or PayablesDocumentKey object (Voucher Number field on screen 'Payables Transaction Entry') with the next available number.

I have found a way to use an eConnect SQL Stored Procedure to get the next number but I just don't understand why Web Services does not provide this. While I have not used eConnect it appears that it does provide this functionality and since Web Services is based on it why not do the same thing? I feel like I am missing something really simple here.

Ed Morris

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

sandipdjadhav 18,306 on at

Like (0)

Report

ED,
I feel same thing, finally I created custom webservice using eConnect methods so we don't have to install eConnect client on each workstation.
Please find enclosed following code for Next Purchase Receipt Number.

[WebMethod]

        public string NextPOPReceiptNumber()
        {
           // GetNextDocNumbers myPOPNumbers = new GetNextDocNumbers();
            GetNextDocNumbers myPOPNumber = new GetNextDocNumbers();
            try
            {

                string sConnectionString = ConfigurationManager.ConnectionStrings["GpeConnectConnectionString"].ToString();

                string CurrentPOPNum = myPOPNumber.GetNextPOPReceiptNumber(IncrementDecrement.Increment, sConnectionString);
                return CurrentPOPNum;
            }
            catch (Exception ex)
            {// If an error occurs, diplay the error information to the user
                throw ex;
            }
            finally
            {
              // myPOPNumbers.Dispose();
                myPOPNumber.Dispose();
            }
        }

It may helpful to create custom webservice for Purchase Invoice No

Let me know how it goes.

Thanks
Sandip

Was this reply helpful? Yes No
Matt Olson 85 on at

Like (0)

Report

Ed,

Have you considered a cheap integration tool like Dynamics GP SSIS Toolkit available here: www.keelio.com/.../DynamicsGPSSISToolkit.aspx ?

It's much simpler to integrate these types of documents (payables) into Dynamics GP without the need for web services (meaning much faster integrations).

There is even a payables sample in the toolkit download.

Thanks,

Matt

Was this reply helpful? Yes No
Ed Morris 190 on at

Like (0)

Report

Matt,

I appreciate your reply.

We own Scribe which looks similar to Keelio however I have very little control over the format of the input file and frankly the design made it very difficult to process. These are also files which are downloaded by users interactively from a website so it is much simpler for them to process them from their PC. I liked Integration Manager for this but it was even less successful at importing this file. In my case I know the Web Services pretty well so it was not a very long process to create the program but for many users it would be better to use other integration methods.

Thanks,

Ed

Was this reply helpful? Yes No
Ed Morris 190 on at

Like (0)

Report

Sandip,

That is a great idea and I have tested with success. I will likely take this approach with other missing features and hope that Microsoft adds them into future versions.

Thanks,

Ed

Was this reply helpful? Yes No
sandipdjadhav 18,306 on at

Like (0)

Report

ED,

I always create custom webService for missing features..which is available on eConnect but not in WebServices. I have done same for Purchase Receipt with Shipment/Invoice type which is not available on WebService but eConnect schema is available.

Thanks

Sandip

Was this reply helpful? Yes No

Community site session details

GP 2010 Web Services PayablesDocument - Get next voucher number

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates

Community site session details

GP 2010 Web Services PayablesDocument - Get next voucher number

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates