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.
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…
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…
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…
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.
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…
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.
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…
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…
It looks like you're new here. Sign in or register to get started.