x Want to participate? Join the group to interact

  • Accessing Business Objects with a Client side script?

    Hello, I have a script complete that runs a SQL Query and returns the results back in a MsgBox. The very last part I need to do is access the Sales Order Number to include this in my "Where" clause for my Query. This needs to be run on the Client…

  • Looking for field location in SQL: Accounts Receivable Posting Date

    Hi all, I have recently created a script for the field "invoiceDate" that restricts how far into the future a user can enter the date for. I am wanting to apply these restrictions as well for the posting date. This should be relatively easy, except…

  • Dynamically pass new connection string for different SQL database to Crystal Report with a script

    Using Sage 100 Premium 2017 Using Crystal Reports 2011 I have six production SQL databases, all structured identically (for regional purposes). I have created a Crystal Report using a Connection based on OLEDB using one of the 6 databases. It uses…

  • Using SQL in script

    Does anyone have a very basic example of how I can integrate a SQL statement in to a script? I've run into plenty of occasions where I wish I knew how to accomplish this, here is my current goal: We ship using Starship and for a variety of reasons…

*Community Hub is the new name for Sage City