Hi,

I have been doing research on this subject. We are hooking up GP with ecommerce and would like to have posing done automatically and but still keeping it manually in GP.
Is there a way to do it? I heard that there is an order of procedures to call to have transactions posted.
Does any one have a clue of those procedures?

Thank you in advance.

Tony

Well, you're in the right place, but your question is kind of broad. 'How to post a transaction' is really too broad for any forum post. However, eCommerce is the correct tool to use to send transactions into Dynamics GP, I do it all day long.

You'll want to get licensed for the product, download it from Microsoft, then follow the instructions included to install the product. After that, you'll want to write code in VB or C#, you'll instantiate the eConnect object and send it transactions.

You can do that by either passing it correctly formed XML documents that make up a transaction, or by using 'serialization', which is much more complicated but allows more options.

I'm happy to help however you can. Install eConnect and send me your first question.

Sorry, I should have refined my question.
We are integrating GP 10 with another system through Scribe Insight and I am new to all of these. The other software isn't an ecommerce, but actually a manufacturing system.

Our customer wants us to post inventory transactions all the way through General Ledger automatically from the other system, but still keep it manually on GP. Oh, yes we have eConnect installed already.

From what I heard, posting inventory transactions all the way through GL requires a set of procedures to be called in an order to make it 'automatically posted'. Right now we are looking into sql trace to get a clue of how it is done. But it's no easy task. I am told that there are more than 30 procedures for the process.

Does any one know something about this? Is there another way beside calling procedures? Several commercial software I found that does this job doesn't support GP 10.

Any advice is appreciated.

I'm not quite clear, but the answer will be simple either way.

It sounds like you want to bring in Inventory Transactions, and have them post through to GL. There is a button in the setup that will do that. I don't know the button, but I'm posative that's all there is to it.

You use eConnect to bring the IV Trans in, then the user must post the trans, then it posts in IV and also - at the same time - into GL. Without pushing the button, you have to go through the posting process twice.

DON'T do the '30 procedure' thing that you're talking about. It's not necessary. 4-8 hour to code the inventory trans import and you're done. I do this all day long.

Hi, thanks for the reply.

We already have the imports in place, but what we are trying to do is to do is to post those transactions.

In our case, we don't want any user involved in this posting process. Can this be done through coding without having user manually click that button?

Ahh, I see.

Nope, can't do it. I've been over this with Microsoft, they just say sorry...

There is a product from a company in South Africa that claims to do 'auto posting', but I've not used it. It's about $500. Basically, you open up a client and leave it running. That client will automatically post in whatever series you want on a schedule.

You have to leave a client open, though.

Hmm..I'll continue dig around see if some solution works.
Thanks

 Hi!

I found a simple way to post IV transactions automatically to the GL.  If you inspect closely the schema taIVTransactionHeaderInsert you will notice a field named "POSTTOGL".  Set it to 1 (the default value) and your transaction will be posted.  This feature was introduced with eConnect 9.0.0.2 but I don't know if it is still available with GP100 and eConnect 10.

Good luck!

Hi, I used the same method to automatically post the transfer request into GL but unfortunely on GP end its still showing the transaction in an unposted state. I dont know whats the reason behind that please help me in this regard. I have tried changing the posting setup in gp also but nothing happened.I am using Econnect API 9.0 with GP 9.0. In Gp it was configured to post only the batch may be thats the reason... please help

I get this question a lot. The answer, unfortunately, is that you can't.

Automated posting is not supported in any form, in any part of Dynamics.

http://www.albaspectrum.com/PressReleases/MS0DYN-eConn.htm

http://www.theitarticles.com/microsoft-dynamics-gp-integration-faq-highlights/299/

I can't say that these products will work, but I can say that it's not possible from eConnect.

There is no post to, post through setup in Inventory. Only in payables and sales module.

Another work-around this limitation is to use a macro like tool, use the continuum tool (the tool is in the tools folder of CD2 GP10 installer). after, the integration to work, pass a sanscript to open the batch window and then pass another sanscript to push the post button.