How to Launch Sage 100 Screens from Crystal Reports

It was asked recently if we could open up a Sage 100 Screen from a Crystal Report. After a little work, we have come up with the following solution:

1. Created a simple Crystal Report (Invoice Number, Invoice Date, Customer No, and Bill to Name)

2. Create a .vbs script file to launch the Invoice History Inquiry Interface in Sage 100. You will need to pass the Invoice Number and Invoice Sequence Number to the script.

3. Format the Invoice Field by formatting as a hyperlink. You will need call the .vbs script as shown below.

4. Now when you right click on the Invoice No field and select "Go To Hyperlink" it will launch the Sage 100 Screen

Let us know if you have any questions!