Would like help with writing shipping info back to Sales Order

[tolsen64]

I was tasked with writing tracking numbers and freight costs back to MAS90. The only way I could figure to do it was using SendKeys. This has proven extremely unreliable. I've just recently heard about BOI and wonder if I could use it to send this data back to the particular sales order in MAS.

Someone else mentioned inserting the data into the BO_SalesOrder file.

I'm wondering if anyone has example code that shows how to send data back to MAS, I'd sure appreciate the help. VBScript is preferred but I can translate VB or C#.

 

[dfeller]

SendKeys is a bad way to do this. I would recommend using either Visual Integrator (easiest) or Business Objects Interface (harder).

Dawn

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[tolsen64]

Yeah, that's kinda why I asked for an example of using BOI. I already stipulated that using SendKeys was unreliable. I don't mean to gripe as I am the one asking for help but I perceive that people don't really read the questions. I ask "how do I use 'x' to do this?" and I get a response like "you should use 'x' to do this."

Using a commercial solution is not an option for me. I need to roll my own. I'm hoping someone can shoot me a quick snippet of code on how to send this data back to MAS using Business Objects Interface. Or a tutorial. Thanks.

 

[BigLouie]

What application is this coming from. UPS WorldShip with Crosware will write back to MAS. FedEx software can be modified to write back to MAS.

 

[tolsen64]

BigLouie,

I'm a Crossware technician and work for UPS. It was Crossware that I was referring to in my original post in this thread. Sendkeys is the way Crossware writes data to MAS 90. But it is highly unreliable if extraneous window or messages pop up during the writeback process. I'd like to figure out how to write back directly to the DB whether using BOI or some other method.

 

[BigLouie]

John De La Cruz with Crossware did a great job with our integration. You cannot really lean how to use BOI by posting in this section. You should take the BOI class from Sage if they will let you. With that class and the documentation that comes with it you should be able to use VB for a write back.

 

[chand885]

I have a similar interest in getting UPS & FedEx shipping data back into MAS90 via an easy solution. I have not done any programming in BOI, but have collected some info, and can help with BOI examples in VB and have file layouts. If you are interested let me know.