Insights (Business Reporter and Analysis Models, EOI)

I’m in the process of updating the Standard Invoice reports.  Sometimes when I add a label or text they don’t show when previewing the report?  Anyone have any ideas why this is happening?  

Hi everybody,Is it possible in IFS Apps9 to manage the grants like quick reports?Is there something like this screen? Thank you and kind regards.

While I launch IFS Report designer tool I am getting this error.  Here is my java installed details Please help to solve this error.Thanks 

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;  delnote_no_         VARCHAR2(15);  count_              NUMBER := 0;BEGIN  Client_SYS.Clear_Attr(report_attr_);  Client_SYS.Clear_Attr(parameter_attr_);  Client_SYS.Add_To_Attr('REPORT_ID', 'SHIPMENT_HANDLING_UTILITY_REP', report

Hi! I am using IFS Cloud and are trying to create a Quick report.  After filling in the required information (see picture 1) I press Save and get redirected to the detaild view. But the detailed view is empty (see picture 2). For some reason I can´t see my quick report I just created. From the debuger I can see that a ID is created for the report.  My guess is that this is caused by something related to access. 

Is it possible to change Unit Of Measure on a Customer Invoice depending on language? Can i change Unit of Measure depending on which language there is default for the company or customer?Ex: Currenct functionality - When a Customer Invoice is printed the Unit of Measure on the Customer Invoice is the same Unit of Measure as “Sales UoM” on Customer Order Line. If value in “Sales UoM” is “stk” (danish) how can i change this to “pcs”?.This can be useful if the customer or company is not speaking same language as the standard for unit of measure. 

Drill-down and a link back to IFS is available as core already for the GL Balance information source. However, we would like to enable the drill-down also to other information sources, including quick information sources. Is this possible? In Aurena, there is a place to set up the Information Source URL but has anyone got experience in setting this up manually for other Information Sources?  

Was this issue reported to IFS and is there a fix to be able to use the date picker for date ranges?@Charith Epitawatta  investigated and advised to open a Case for investigation.  Was this ever done? 

We have set up our company logo in our system parameters.  Our company logo does show up on Invoices but it does not show on Handling Unit Content Label.  What is the difference between the 2 logos below?  

Hi, I am trying to add an image to a report layout using Report Designer Tool. The image is saved in the Report Images folder in Aurena client. I have used the option ' Dynamic Image Stored on the database ’ and wrote the  sql query  below.select image from ifsapp.report_images where image_name =:p1and passed the image_name as the Bind Variable.But the image is not showing in the layout. Can anyone explain me how to add this image (which is saved in the report images folder) to the report layout. 

Who can I contact to learn more about Business Reporter? 

Hi,We recently upgraded our IFS to IFS10, and am attempting to use the Business Reporter functionality in our test version of the application.Using the setup guide provided I was able to set up a simple and basic report.Nothing more than using the GL Balance Information SourceVariables used in the sheet itself: Year, Account, Balance            Adding simple text header to the above variables.Filtering the design row to year 2022Repeater on year and account  Here I can save and publish without any issues. But then I run into the following issues:When I attempt to Load Report it opens up an empty excel sheet without business reporter. When I look into IFS it does not show up under “Order Report” When attempting to “Download & Validate” I receive the following error: “StartIndex cannot be larger than length of string. Parameter name: startIndex”.  I have attempted with multiple different reports and I get this error message each and every time. Is this a known issue that anyone else

Hi, There are two questions I’m looking for an answer. What is the standard procedure of version controlling IFS BR Reports? We have 75+ BR Reports and is there any way of version controlling these in IFS Cloud with Git? What is the best way of moving reports between environments (Dev →  SIT → UAT → PROD) in IFS Cloud with a delivery. I found below topic on this. Moving Business Reporter Reports between DBs | IFS Community Is it still the same? We have 75+ BR Reports and it is not practical manually moving between environments. It is also not possible to use Application Configuration Packages with BR Reports. Is there any workaround we can attach BR Reports with the delivery process in IFS Cloud? Thanks in advance. Regards,Dasun

Where can one find IFS Business Reporter Development Training Material ?

I am trying to find a way to track employee individual operation efficiencies. I am trying to build a query using query builder to do this. Is there a way to track efficiencies of employees?

We have a question regarding an SSIS connection to IFS.  I am using Visual Studio 2019 - Community Edition and have established a connection to IFS using Microsoft's Oracle connector to pull some data via an SSIS package.We have IALs in IFS that are considered views and have access to them with a "read-only" user account given to us.  I can see and access them in PL/SQL Developer, but I can only access tables in Visual Studio SISS package, I can't access the IAL views.Is there some type of limitation with the Oracle Connector? DetailsMain Requirement – Get some data integrated to a SQL Server database on premisesSSIS requirements and BI tools are installed.User Account – IFSINFO VS Studio Version – Can connect to the database using IFSINFO user but can’t execute a SQL query.  Only some of the views are shown and none of the IAL views are shown.  Question – how to make the IAL views accessible in VS? (They are accessible for the same user in PLSQL Developer)

Trying to create a QIS Draft that utilizes the “_CFV” version of the table so that the Custom Fields are available.  However, due to the fact that a “CF$_” is prepended to the field name and the Created View Definition is not editable to change an alias, the field comes into the Information Source with the CF$_ prefix, which I thought was fine. And the field is visible in the BR, but if you try to put a filter on the field, it errors out, indicating that QFACT_XYZ_CFV.CF is not a dimension or fact.  It appears that the $ in the db field name is being evaluated as a parameter and making BR blow up. Other than writing an IAL where I can alias the field correctly, does anyone know how to get around this issue?

IFS Community, hello! There is a possibility that when I click on my crystal report "Material Rev Board Label" See screenshot, the parameter will be automatically passed to my crystal report. This is without prompting the window to ask for parameter values.I have Case ID 52 in my screenshot, so if I click on Material Rev Board Label, the 52 will pass to the Crystal Report automatically and after the report will display. 

Hi All, Can someone will tell me when this reimbursable amount and gross amount will be different?what can be the scenarios in which it can be different? 

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?