x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 5 replies
  • Subscribers 87 subscribers
  • Views 3791 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
44
topics
90
replies
Payroll, Time Tracking, and Job Cost
776
topics
1k
replies
Reporting and Analytics
960
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
anilsson

Writing a windows service in .NET to add sales orders using BOI on a MAS 200 4.4 client machine

Posted By

Hi everyone, 

can anyone tell me if it is possible and what to think about if I want to write a windows service in .NET to add sales orders using BOI on a MAS 200 4.4 client machine. (Preferably the client machine. Its just to simplify my deployment as well as keep the MAS 200 server clean. If its not possible I'll run the service on the MAS 200 server.)

I've read conflicting information about whether its possible or not to use the BOI on a client machine for MAS 200. So does anyone know if its possible or if the BOI only can be used on the server?

And if it's is possible (running on the client) is there any specifics to think about in regards to the setup?

Another idea would be to use the e-Business Web Services. Would anyone care to comment if this approach would be better or worse and if so why?

I am an experienced windows and .NET developer but so far I have only written code to read data from MAS using the ODBC driver. It all works fine. But now I want to start adding data to MAS as well.

I am working out of Stockholm, Sweden so there is little chance for me going to any Sage MAS BOI classes that is often recommended. (Or are any of these available online? I want the advanced stuff not only creating a script in the MAS client.) And is there any way to get hold of the classes documentation otherwise. I'd be willing to pay for it and go the "official way" of course.

And finally does anyone know of a good consultant to use help me with this development? I.e. someone that knows the ins and outs of accessing BOI from Windows services written in .NET? They should be located in Vancouver, Dublin or possibly Stockholm!

Best regards,

Andreas Nilsson

  • 0

    Andreas,  Welcome to the Sage City. All very good questions. As for classes you can take the BOI class on line at SageU I believe. Should be a link there somewhere. What you are wanting to do certainly sounds possible. On the topic of using the web services I would suggest Dawn aka DFeller. She has done a lot of work in this area and should be a very helpful guide. The other person would be Dan aka Connex aka The Smartest Guy In The Room. Very good with code and BOI.  Those two should be able to answer all questions and help.

  • 0

    Greetings,

    The Business Object Interface training is available online.  Please see our Sage University website for details.  

    DCOM is supported for the Business Object Interface and can be used to run PVXCOM on a remote machine.  One of my previous posts includes details on configuring DCOM and I believe this was also added to the BOI Training docs.

    Another option other than e-Business Web Services or BOI would be to use SData.  We are currently putting together some training on SData and will be discussing it at Sage Summit.  I am not sure when the training will be available from Sage University so stay tuned.

    Thank you,

    Kent Mackall

    Sage

  • 0 in reply to Kent Mackall

    Thanks!

    I'll look have a look at the online university in regards to BOI.

    SDATA I didn't know existed but now when reading about it seems perfect for my use case. Are there any differences in costs and licensing between these solutions?

    And are they all available for MAS 200 4.4? Or will we need to upgrade?

    Thanks again,

    Andreas

  • 0 in reply to anilsson

    There are no costs with either BOI or SData.  Both are available as part of Sage 100 ERP although the SData Native adapter does have to be installed separately from the productivity Tools menu of the installation.

    SData is only available starting with Sage 100 ERP 2013 (5.00) so using SData would require an updgrade.

    Thanks,

    Kent

  • 0 in reply to Kent Mackall

    Beware, sData for Sage 100 ERP is read only.

*Community Hub is the new name for Sage City