Insights (Business Reporter and Analysis Models, EOI)

I have created a quick report in IFS. I need to display the updated records as well as the old records of Vendor bank details on the same report.Currently, the History Log only show the meta data but not the actual changed value. And If I run payment table, it only shows changed value.Is there any way I can display the actual changes and the old value?Is there any table/db that holds the original data?

So I’m currently in training for Business Report and have activated Drill Down, but when I select a row from the ‘drill down’ temporary worksheet I don’t get the hyperlink to Query Voucher Rows or Details?

If I try to create a SQL statement QR (IFS10) with column titles longer than 32 characters, it will give an error. Has anyone seen this before? Is there a workaround to this problem please? ThanksHiroshan

Environment: Aurenais there a way to set up a history log Attributes for permission set change (grant and revoke an object or method)?

Is it possible to receive notifications when there is an update  of IFS Business ReporterOr is there a way users can monitor it themselves ? 

Hello All, I am brand new to IFS and  I have been tasked to develop new and update old reports. Is there a definite document on how to do this?

Good Afternoon - We have a case where an employee is not appearing on the Holiday Quick Reports, we have checked his Position and employee set up, however we cant seem to access his details within the Detail or Summary Quick Reports! Any advice welcome Thank you

We have created a quick report in IFS Aurena. We need to display the updated records as well as the old records on the same report. How can we accomplish this? Currently, the History Log only show the meta data but not the actual changed value. We need to display the actual changes and the old value.

I am having an issue with saving/publishing BR Reports in customers on prem IFS Cloud environments. Versions:IFS Aurena framework version: 21.2.2.20211215045945.0IFS Aurena client version: 21.2.2.20211215045945.0IFS Business Reporter Client:  21.2.0 Even with AppOwner account with all the permissions cannot save or publish BR reports. Anyone knows a solution for this? Thanks in advance.

Hi,Requirement: We are printing a report using a RMB. When it gets printed, it must print 2 copies.In general, when we print an order report from any screen using RMB, then the print dialog gives us an option to input the number of copies we need.When I am trying to perform the same from the backend using below code, only one pdf is getting generated. Does this mean that the COPIES() will not work from backend?DECLARE  conf_attr_           VARCHAR2(4000);  ordrsp_site_         VARCHAR2(5);  change_online_     VARCHAR2(4000);  media_code_          VARCHAR2(40);  report_attr_        VARCHAR2(2000);  parameter_attr_     VARCHAR2(2000);  attr_               VARCHAR2(200);  printer_id_         VARCHAR2(100);  result_key_         NUMBER;  print_job_id_       NUMBER;

Hi, I’d like to put a date range for my SQL statement. Could you please advise? SELECT payment_address.Identity,SUPPLIER_INFO_GENERAL.Name,payment_address.Party_Type,payment_address.Way_ID,supplier_info_general.creation_date,payment_address.Description,payment_address.Default_Address,payment_address.Data1,payment_address.AccountFROM   payment_addressFULL JOIN SUPPLIER_INFO_GENERALON payment_address.IDENTITY = SUPPLIER_INFO_GENERAL.SUPPLIER_ID

As EOI is slowly begin deprecated from support I have seen and heard discussions of DTO and discussions on this the Statement of Direction; a lot of these discussion are quite old. For example the two threads below;Interaction of six box model and with value assessments created in EOI and with Scope Tool model? | IFS Community EOI | IFS CommunityWhere has this got in IFS Cloud 22R1; and where is DTO on the Roadmap? Has it been called something else now?Is there still the concept of Biz Map somewhere, or has this been sub-subsumed in

Is it possible to filter a design column or row without having a repeater?  Every time I try to do this, my filter gets wiped out.Here are the steps I’m taking: I create a design row with a repeater and add filter criteria: The design column name and filters.  I delete the repeater because I just want one column - I don’t want the data to repeat. The repeater that I originally had. After I deleted the “repeater” 

Good Afternoon - Can you please assist - I would like to set a users permission to allow them to access various lobby pages  - When they type Lobby at the top of the Navigator bar the option Lobby Overview is not available -Only Date Source and Element options are available. What permission set or profile change is required to allow the Lobby Overview option to become available on the Navigation menu.  Many thanks Dave  

How can i write an expression/query so it’s possible to search on multiple suppliers? Right now my Quick Report only works when one supplier is searched on. See image:Quick Reportselect sig.supplier_id          , sig.name AS "Supplier Account Name"          , sia.address_id          , sia.name AS "Supplier Name"          , sia.country          , sia.address          , sia.address1           , sia.address2          , sia.address3          , sia.zip_code          , sia.city          , se.buyer_code          , PURCHASE_BUYER_API.GET_NAME(se.BUYER_CODE) AS "Buyer Name"          , PURCHASE_CODE_API.Get_Description(se.PURCHASE_CODE) AS "Supplier Category"          , cm.name          , cm.description          , cm.method_id          , cm

What function do I use to create a functional parameter that replace for example business plan id F2022Q1 with F2022Q2, i.e. next courter?If the business plan id would be a number value I could use function ADD but business plan id is a string and I can’t use it as a parameter value as number?

What are some good resources for learning IFS?  I’m not able to attend IFS Academy due to costs.  I’m just wanting to know if anyone has good resources for learning.  I have gone through some of the e-learning available in IFS 8 but I was told it was not available in IFS 10.  Any tips would be appreciated.

Where do I find the Design Row Grouping in Business Analytics?

I am getting the following error while running  an IFS Business Analytics Report. I am using a custom SQL Source to get some Project Management info.  It was working perfectly fine for almost a year.  System.OverflowException: Not a legal OleAut date.at System.DateTime.TicksToOADate(Int64 value)   at Ifs.Application.ExcelReporter.ReportDesigner.ReportController.ParseValue(Datatype type, String value)   at Ifs.Application.ExcelReporter.ReportDesigner.ReportExecutionMgrOld.CreateDataSet(DsrdResultSet resultSet, ArrayList physicalDataSets, ReportGenerator generator, String separator, Int32& recordCount)   at Ifs.Application.ExcelReporter.ReportDesigner.ReportExecutionMgrOld.PrintReport(Dsrd dsrd, XlrTemplate template, ArrayList physicalDataSets, Exception& exception, Int32 lastDataSetId)   at Ifs.Application.ExcelReporter.ReportDesigner.ReportController.ExecuteReport(Exception& exception, Boolean cacheEnabled)   at Ifs.Application

I’ve made a quick report for a user however, they want to be able to right click each row and click view case. How do I make this an option on a quick report?  Thanks!

Hi All,I need to show the text 'SUPPLIER' vertically in a report. I tried using Vertical Text(text) function that is available in report designed but didnt get desired output.It not showing full text during preview. Anyone have an idea how to show text vertically   

I have shut off the First page, but when I preview the report it still shows the Header and Footer on page one.  I only need the Repeat page.  

When creating a custom report in Report Designer 200.2.0000 is there a way to copy from a Standard IFS report?  If not can someone explain to me why this is not available?

Request help for the strange behavior of the BA report extracted from GL Balance fact . The data is filtered on a particular code part . The format (border) for  a column which does not appear if there is not data is set as Underline and for the totals (Operational revenue in below the border line is set as Underline. For some code parts the Underline just appears partially and does not show up for other columns. Below is the issue. Not able to figure out what is causing this issue.  The underlines should extend to the other columns as shwon in RED but NOT hapening 

I have a user request to add Part and Part Description to the Handling Unit Label.  I would appreciate if someone could point me in the right direction.