Incorrect syntax near the keyword 'AS'. this is the error from syteline when we receive when creating the new entry. The Table was created by us, the triggers created by the system (we used syteline to create the table) . Any help would be appreciated
In AES, how do I check when the system puts an order on hold? I'm in cloud version 10.
I have a custom load method that retrieves all of the customer ship-to records that do not have corresponding customer document profiles. We have a large amount of ship-to records - almost 10,000. All of my load collections are set with a 0 so that all records are returned. What I have noticed, is that it will only iterate…
Hi everyone, I have an API call that will start a mingle workflow via the process API. When I do the test in API Gateway it works as expected: I have set a logical ID and used JSON for the body { "workflowName": "VOL_PODeviation_Approval", "instanceName": "DEV", "inputVariables": [ { "name": "Configuration", "dataType":…
We are unable to run the Invoice register report. The headers, are the unchecked, but in TRN they are checked. In design mode the componet class is BOOLEANVAR. When that is broke down it has a BOOLEANTRUE = C. (which is readonly). In TRN that value is BOOLEANTRUE = . I need to know how or if possible, to change this value.
We rely heavily on the Service Schedule Calendar (Form Name = ServiceSchedules) but we need to add a few things. Specifically, we want to add an icon to indicate if a service appointment is URGENT or there is a HARD DEADLINE. It doesn't appear that we can modify this since we are a cloud customer....BUT, I thought I would…
Can anyone help we are in need of adding a remittance letter (pdf) to invoices as they are sent. Is this possible, i was thinking to watch the submission of the invoice with event system but not sure how to then email the document. THE catch is they only want it to go 5 times to each customer. We are in the cloud, on site…
I need to show the customer order on the Shipment Master form. I'm planning to use a derived column however I don't remember the SQL to get the CoNum from the order. Any help is appreciated. Thanks in advance.
I am working with SyteLine ver. 10 in the cloud, and I need to make the Customer PO field on the Customer Orders form required (can't save without entering one). Thanks in advance.
First can anyone show me how to create and expression to subtract to properties. Secondly, has anyone used expresssion to replace a value, when we do, it only shows us the replaced value not the remaining data in the property. Example: OfficeLongAddrAndPhone expression( REPLACE( 'HUN OPERATIONS', 'Ens operations.', UPPER(…
It looks like you're new here. Sign in or register to get started.