Finance | Project Operations, Human Resources, ...

Stored procedures called to post batches

(0) Share

Report

Posted on by Richard Wheeler

75,852 Moderator

I finished an import routine that imports bank transfers and creates a resulting ledger transaction batch. The final piece is the client wants this batch to automatically post.

Running SQL Profiler, I found what I think are the three stored procedures involved. These are:

1) DYNAMICS.dbo.zDP_SY00800SI

2) dbo.glpCreatePostingActivity

3) SCHLD.dbo.glpBatchCleanup

Will calling these three stored procedures be all that is needed?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (15)

Answers (0)

Sort by

Suggested answer

David Musgrave MVP ... 14,151 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi Richard

No, the stored procedures are not enough to correctly post transactions. There is a heap of Dexterity code that runs before and after the call to stored procedure.

That's exactly why I created the Batch Posting Service Toolkit, which can be called by VS Tools code, Dexterity code or as a Service Based Architecture (SBA) Web Service.

BPST wraps all the Dexterity bits into a single simple API.

Regards

David

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

Thanks Dave, I have downloaded build 12 for 18.2 and will attempt to incorporate into my C# code.

Was this reply helpful? Yes No
Flashjunior 10 on at

Like (0)

Report
Copy link

Link copied!

Please can you share with me the stored procedure you used to create a bank transfer batch, I really need to import bank transfer records into GP2018

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

I have invested over two weeks trying to get this completely working. Right now I am stuck getting the batch to post. My program reads from an Excel spreadsheet. Let me get this finished.

Was this reply helpful? Yes No
David Musgrave MVP ... 14,151 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi Richard

Capture the script log and that will give you the parameters to post the batch.

You will not be able to cancel the reports as this required some Dexterity only hacking in the runtime engine that you will not be able to do from visual studio tools. It took me many weeks of development to make it work.

Your time is worth more than the $600 cost of Batch Posting Service Toolkit.

Regards

David

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yes, but then I need to install Web Services and run IIS on the server. Too much over head just to post batches.

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

By the way, the sample code does successfully post the SOP batch so it can be done. I just need to figure out the correct parameter values to send down to

Dynamics.Forms.Batch.Procedures.Post.Invoke(BatchSource, batchNumber, nWindowType, nActivityType, DestID, ref nStatus);

I have BatchSource = "GL_Entry"

batchnumber is the batch ID

nWindowType 2 or 3

nActivityType 2 or 3.

I can live with the journal printing to the screen.

Was this reply helpful? Yes No
David Musgrave MVP ... 14,151 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi Richard

If you only want to call Batch Posting Service Toolkit from a VS Tools Addin. You don't need IIS and SBA set up.

You only need IIS and SBA if you want to call it via a web service.

You can call BPST from Dexterity, C#, VB.Net or GP Power Tools just by installing it.

Regards

David

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (1)

Report
Copy link

Link copied!

David, I just successfully posted my first ledger batch without any edit list appearing on the screen or printing. It was quite the challenge not only finding the method but the parameters to pass to it. I cannot believe there is no documentation for this. I am going to do some routine testing over the weekend and submit this to user acceptance testing. I may or may not need BPST. It is good to know that it is there.

Was this reply helpful? Yes No
Suggested answer

Andrew John Dean 1,337 on at

Like (0)

Report
Copy link

Link copied!

Hi Richard

I have been monitoring your discussion with David and see that you have figured out how to use VST to post batches.

There is just one area of VST logic that I need to make you aware of. If you are simply calling the posting function as a one-shot routine after importing transactions from a spreadsheet, then your code will work successfully

If however, you are running in a continuous timer loop, GP will eventually crash after about 10-20 batches being posted. Hope this information doesn’t come as “rain-on-your-parade”

Regards
Andrew Dean

Was this reply helpful? Yes No