Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Converting a Scribe data integration to CozyRoc in SSIS (which really uses GP Web Services 2010)

Posted on by 240

My dilemma is understanding the more object oriented approach of using this, where as scribe is pretty linear.

The process goes like this:

Query returns let's say 12 rows, much of which is repeating data. The data contains batch numbers, and GL Information only.

In the Scribe world, as each line comes in, we:

1. See if the batch exists, if yes, update, if no, insert..all following lines skip if batchid repeats.

2. GetNext GL Number for use in next insert. (skip step if batchid is repeated)

3. Insert GL Header (skip step if batchid is repeated).

4. Insert GL Lines

That being said, I can't even see where I could insert a Batch if needed, this is an integration with Microsoft Dynamics CRM 2011 and the batchnumbers are being generated there in a custom entity.

I wish there was a document that was lets say a table / column to the GP web services kind of cross reference doucment, I'd probably be in good shape then, or better at least.

Any help would be extremely great!

Thanks,

John Klemetsrud

CRM Business Consultant

Altai Systems, Inc.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Converting a Scribe data integration to CozyRoc in SSIS (which really uses GP Web Services 2010)

    Hi John

    Take a look at msdn.microsoft.com/.../ff718572.aspx

    Also found this http://www.microsoft.com/en-us/download/details.aspx?id=36223 (it's for GP2013 but the basics are the same)

  • jklemetsrud Profile Picture
    jklemetsrud 240 on at
    RE: Converting a Scribe data integration to CozyRoc in SSIS (which really uses GP Web Services 2010)

    Thank you Paul, I was kind of wondering if that wasn't the case. My assumption was that perhaps it say "If the exists already attach the GL record to it, if not create it". Do you know where/if there is any documentation on the required parameters for some of these? I've been playing with it, but it would be nice to know the required params for a GL record and for a GL Line. Easy to understand in eConnect, not so much with the web services.

    Thanks, and If I can get this working I'll mark you as the Answer man! thanks :)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Converting a Scribe data integration to CozyRoc in SSIS (which really uses GP Web Services 2010)

    Hi John

    when you push a list of items into GP via the web services, it assumes that a Batch Header needs to be created for each unique Batch ID in the list. You do not have to explicitly create a batch header.

    Regards

  • jklemetsrud Profile Picture
    jklemetsrud 240 on at
    RE: Converting a Scribe data integration to CozyRoc in SSIS (which really uses GP Web Services 2010)

    I'm sorry, perhaps I worded it wrong. I've got no issues with Scribe at all. In fact it's working just great and I use it all the time. The issue is that I'm taking a job that "use to be" in scirbe and trying to re-create that wheel using the Microsoft Dynamics GP Web Servers 2010. The "client" that wraps around the GP Web Services happens to Be the CozyRoc and works in SSIS.

    The issue i'm having, is that the very first step in the Scribe package creates "Batches" in Great Plains....I see no "CreateBatch" function/method in the Great Plains Web Services...and thus am in a bind as how to make sure a batch exists prior to inserting a GL Transaction.

    Thanks,

    John Klemetsrud

  • keoma Profile Picture
    keoma 32,675 on at
    RE: Converting a Scribe data integration to CozyRoc in SSIS (which really uses GP Web Services 2010)

    hi,

    follow these links:

    www.scribesoft.com/microsoft_dynamics_gp

    www.youtube.com/.../DYvTePM9Vwo

    www.youtube.com/watch

    www.youtube.com/watch

    www.youtube.com/watch

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans