Sage 100

I am trying to attach a crystal report to a Sage Alert. I have crystal reports installed on the Sage Alerts server and Sage 100 workstation installed as well. I have the SAP Crystal runtime engine for .NET framework 64 bit installed as well. The alert…

Ever since the time change last weekend, sage alerts seem to be off an hour. The time and date on the server where sage alerts is installed is correct. Is there another setting somewhere that reads the time? I've never had to change a setting within the…

Wondering if it’s possible to have Sage Alerts & Workflow refresh a power query right before it sends it as a file? Maybe with & Sage Alerts script? Need to send it as a power query file vs. a crystal report since can’t duplicate data in crystal reports…

Trying to do a simple calculated column in Sage Alerts and Workflow query that is linked to Sage 100 providex. The calculation is to return the length of a string field. I've tried LEN and LENGTH eg: LENGTH("AR_Division"."ARDivisionNo") and cannot get…

Hello, I have a request to setup an aggregate query linked to an email event which lists the total sales by salesperson for the day which is pretty straightforward; however on this same email they want a breakout of those sales listing the order number…