Hi I am having issues loading an IDO collection for a report form. 1) This IDO has 2 tables po_mst and whse_mst joined by whse.whse and site_ref. I ran it in IdoDataViewer and runs fine. I then check if it will run in DataViews Setup, it will run without the addr##1 property from the whse_mst table. If I add the addr##1…
I am able to get the UserName when using the SyteLine Desktop Client using USERNAME(). However, when the form is opened using the SyteLine Web Client the IIS Datapool App user is returned. I have tried using: USERNAME() System.Security.Principal.WindowsIdentity.GetCurrent().Name Environment.UserName They all return the IIS…
Hello, I am trying to upload file into MT Cloud via Mongoose. I am testing success upload just by showing message with uploaded file path. When file has extension like .txt or .xml everything is working fine. But I often need to process text files with extension like .940 or .bai2 or even without extension. When I try to…
Hello, I am trying to upload file into MT Cloud, and then read this file from Mongoose. I suppose, that file upload is done correctly, I have returned file path: But when I try to read it, I receive IO permission error: So file must be accessed some other way? Here is my Form Script code: using System; using System.IO;…
I have created a Send Email event against SLPoItems that retrieves an e-mail value added to a user field called _ATRO_DerPreqAttn. The event is designed to fire an e-mail to the e-mail address specified in _ATRO_DerPreqAttn when a purchase order is received and it works provided the e-mail is a valid address or series of…
Hi, I need to send XML file from Mongoose to IDM via ION API in MT Cloud. I have this FormScript in which I am downloading XML file from url: //<Ref>System.Net.Http.dll</Ref> using System; using System.IO; using System.Net; using System.Text; using System.Xml; using Mongoose.IDO.Protocol; using Mongoose.Scripting;…
Hi All, I have added a custom field(CMS080) to MMS001 and trying to set a value to the custom field via H5 script. But it doesn't seem to work in the H5.XI UI. var H5SampleHelloWorld = (function () { function H5SampleHelloWorld() { } /** * Script initialization function. */ H5SampleHelloWorld.Init = function (args) {…
Hi, I am trying to setup connection to FTP file server from Mongoose. I am using File Servers form, but always receiving this error message Please what am I doing wrong? I already tested this FPT connection from FileZilla and web client, and it's working just fine.
Hello, we have created a new form in our DEM environment which mut be transferred the TRN and afterwards into the PRD environment. The environments are not "linked" for that the TRN does't show up as "Target" in FormSync. I found the article KB 1833865 which tells that it is not possible to transfer between non linked…
Hello, I'm trying to develop a Purchase Price Variance report in Syteline. It seems like the PO Receipts dataview is close, but I need to get the standard cost of the item in the PO receipt at the time it is issued. And since costs can be updated at any time, I can't take the most recent Standard Cost as it may have…
It looks like you're new here. Sign in or register to get started.