×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Would like help with writing shipping info back to Sales Order

Would like help with writing shipping info back to Sales Order

Would like help with writing shipping info back to Sales Order

(OP)
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#.

RE: Would like help with writing shipping info back to Sales Order

(OP)
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.

RE: Would like help with writing shipping info back to Sales Order

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.

RE: Would like help with writing shipping info back to Sales Order

(OP)
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.

RE: Would like help with writing shipping info back to Sales Order

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.

RE: Would like help with writing shipping info back to Sales Order

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close