I am trying to upload remittance advice data from a text file. I have created an external file template off the ExtCustPayment file type. When I use the External File Assistant to upload the file, I get an error about Payment Method (Way_Id) cannot be null. It is not null and I can see it has data in the External File Transactions Detail page.Payment Method Mandatory Error, but has dataI am not sure if it is just a bad value (thought I did get the value from the dropdown list on the External Payments dropdown for payment type) or if it is not recognizing that there is data in the field.We are using IFS10.In case it is needed, here is the File Template build I am using:External File TemplateI have tried to simplify it down to just the bare bones.Thanks, Ron
Hi!We have problem to get a proper sorting (order by) on the X-axis in Lobby element Bar Chart.In our case we transform a date value to the string for start of the week, using to_char(TRUNC(&AO.Shipment_API.Get_Actual_Ship_Date(shipment_id),'D'),'MM/DD/YYYY') , for example 05/28/2023, 05/15/2023 etc.We are using above string format to get the order for the data. I have also tried using year + week number and truncated date. When I get to the lobby element I check the data source to use the data source order, but it keeps ordering by the y-axis amount. I am doing a horizontal bar chart and get least to most from the Y-axis. Bar ChartSo then my dates are in the X-axis are in the wrong order….??I saw there was a question exactly like this one from 3 years ago, but it did not have a solution. It was closed so couldn’t reply there. It looks like others are having this same problem. Is there anyone who knows a solution for this, or is this some kind of limitation in the Bar Chart?
How do you get an existing field (not a custom field) to show up on a different page?I am trying to display the Organization Code (org_code) from the Organization and Position Assignments page (company_pers_assign_act view) on the Purchase Orders Lines (POL) page (purchase_order_line_all view). So it is an already existing field and not a custom field. When I try to create a custom field so it will display on the POL page I cannot get it to work. I have tried Reference (can’t find the field I want to display), Select (mostly get the not a custom field error) and Expression (Mostly get statement is invalid).I am not 100% sure which is the best route. I thougtht the expression looked the most promising. I have tried:company_pers_assign_api.get_org_code((select assignment_seq_no from company_pers_assign_act where person_id = v.authorize_code))as the expression. The get_org_code needs the assignment_seq_no as the parameter which is what the select statement is trying to get. Looking
I was using report designer without any problems, but now when I try to open a layout nothing happens. No errors, no warnings, no open layout. I have tried copying a coworkers report designer folder that worked on his machine, but did not work on mine. The only thing I did previous is updating to Visual Studio 2021, but my coworker also did this and he had no problems.Any ideas on how to get the layouts to start opening again?
I have created a complete custom report (.Report, .RDF, .RDL, .XML) through IFS Studio Report Designer to replace the IFS PO Report. There were just to many things we wanted to change to make it economical to change the inherent IFS Report. Is there a way to change to the custom report so that the inherent IFS calls (like the RMB on the purchase order to print the work copy) calls the custom created report rather than the IFS Canned Report? We are using IFS10.I am not talking about going to the report definition and just swapping in a new layout, that question has already been answered.
I have modified the Purchase Order Print Rep Operational (giving it a new name so now it is a new report) so I don’t have to worry about updates undoing my changes. Now when I print the Purchase Order, I want it to use my modified report rather than the IFS native report.I have gone to the report definition and “turned off” the native report and turned on the custom modified report. But when I order the report, the report that comes up is the native IFS report rather than my custom report. How do I get the custom report to come up rather than the native IFS report?We are using IFS10.
I am trying to connect an IAL definition to a Data Source Designer Element, but when I click the preview button I get an “SQL command not properly ended”. Here is a screen shot of my IAL Object Developer, below that is a screen shot of my report designer and below that is a screen shot of the error I am getting.IAL Object DeveloperData Source Designer
I would like to a quick report on the 12th of the month for the prior month. So on April 12th it will run for the month of March. On May 12th it will run for the month of Apr and so on. This report is also run manually by the users. Is there a way to dynamically set the From/To date to be the prior month or do I have to create copy of this report with the dates dynamically set in the select statement? I obviously don’t want two exact reports because of having to remember to make all changes twice. Below is the a screen shot of the server task schedule.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
