The issue is a date String was not recognized as a valid DateTime,I am trying to add the due date, using DATEADD(week,2,RecordDate) this is returning the string error above anyone know why. The event code is this.....DATEADD(week, 2, P("CreateDate")))
How do you access user defined scripts within a form script? Is it possible?
Can anyone help us, we are on site, and have a trigger that inserts data into the opportunities form when an Estimate is entered. Simple on site, but we have one location in the cloud, can this be accomplished in the cloud??
Good Day, I am curious if anyone has had any success with using Formsync via command line to export all non-vendor related items out to XML or SQL files? I am wanting to automate a mass export of our development environment activities on a weekly basis. However, the help file says you need to run it in upgrade or patch…
Is there a cool and simple way to get aggregates over a date range in IDOs? For example, consider this simple SQL: Declare @StartDate DateTime = '1/1/2024' Declare @EndDate DateTime = '3/31/2024' SELECT cust_num, sum(price) AS Total FROM co_mst WHERE order_date between @StartDate and @EndDate GROUP BY cust_num If I need…
I am stuck on Attaching a file with EMAIL in Application Event System (AES). In V9 on-prem, we had some Event Handlers, that used to send Emails with custom subject line and email body. Using "Attach" I was able to give the path of the file from Report Output Files folder and it was very nicely attached with the email. On…
When trying to use the New External Workflow Wizard, I get this error message. I have tried in multiple Syteline multi-tenant cloud sites and get the same results. I have had a case opened with Infor support on this for a few weeks but they have not been able to provide a way to resolve this. Has anyone else gotten this…
Hello, We are a cloud customer. We are working on a new website where we are using Infor Rhythm. I need to make some small changes to LoadProcessSalesOrderSp which is a Stored Procedure. I did an extgen, on LoadProcessSalesOrderSp, extendied the IDO ESBSalesOrderViews and made a copy of the SalesOrder Replication Document.…
We have a IDO we build with a derived field, the similar to the DerNetPrice in the SLcoitems IDO has a slight difference. When we run the dataview it just spins, (it did not before we added the below) What are we doing wrong. Please help, the IDO has co table and coitem table joined on the co_num..…
CSI 9.01.12 on premise, Windows 2016, SQL Server 2014. I've encountered something new. I got a call from our materials handling department stating that none of their labels are being printed. The IDO Custom Assembly isn't loading the method any longer. I've added some debug statements and it makes it to where it makes the…
It looks like you're new here. Sign in or register to get started.