-
Email Dataview Results
I'm looking for a way to run a dataview on a scheduled basis and have the results sent to several users in an email.
-
Filtering Records by Date Range in Syteline Form
I'm hoping you can assist me with filtering records in the Syteline Form. I'd like to be able to select records based on a specific date range. For example, I'd like to filter records where the "Due Date" is greater than or equal to 10/15/2024 and less than or equal to 10/20/2024. Could you please guide me on how we can…
-
Printing Object Notes on a Mongoose Report
CSI 9.01.12, on-prem Does anyone have any examples of Mongoose Reports that print Object Notes? I'm being tasked with writing two reports that need to include specific Object Notes in the output. Initially, I had made a Sub-Collection in the IDO for the notes but I think what I need to do is make then Secondary/Tertiary…
-
Application Event System - Event Not Return Output Parameter
I'm currently working on an advance PO Workflow. I use several events that use core/framework events IDO Insert/Update that call a single event that has my custom PO approval logic and prompts. In the PO Workflow standalone event I set the SETPARMVALUES(Status = "0") or SETPARMVALUES(Status = "1") based on the prompts…
-
Attach or merge a pdf to an output report
Hello. Do you know if it is possible to add a pdf from the attached documents to a report generated by SL (version 9.01)? I know you can attach both files with event system to send an email with them, but I need the pdf generated by the background task include the pages of the "external" pdf. Thanks in advance.
-
Setting the value of a global variable via an IDO Method
I have a method that will determine if a user is "clocked into" an order in Syteline. I want to use this method to set a Global Variable so that on forms other than Customer Orders, I can see if they are clocked in or not. They may not load Customer Orders form first so I don't want to tie it to a form event. Is there some…
-
Adding new audit log entrees error
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?
In AES, how do I check when the system puts an order on hold? I'm in cloud version 10.
-
Quantity Usage Report
Hello, We're at year-end and before our Finance team pulled their financial/usage reports, the utility: Set Item/Warehouse PTD and YTD to Zero and the reports reference qty_used_ytd in the items master table (which is now in accurate when looking at the past 12-months). Does anyone have a script that gathers usage…
-
Custom Load Method RECORD CAP
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…
-
ION Api Invoke to trigger Mingle Workflow
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":…
-
ComponetClass BooleanVar
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.
-
ScheduleWebControl Modifications for Cloud Customer???
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…
-
Adding pdf attachment to invoice
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…
-
Does anyone know the SQL to show the Customer Order Number CoNum on the Shipment Master form?
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.