Insights (Business Reporter and Analysis Models, EOI)

 You can ask anything you wonder about IFS 10 Lobby. I can answer any questions you may have about IFS 10 LOBBY. Element design, data design, where patterns, references, page creation, authorization, etc. I would be happy to help.

How I can schedule quick report on particular day of month and share same to the user in a mail? 

Hi everybody ,I’m new by using IFS ERP and as Data analyst I need the list of tables/views and also the relationship between tables (Foreign keys ) like the Schema  !Regards 

Hello, I need to get Pdf report sent to the default Printer .when the shipment’s status change to Closed . Thanks,  

Hi all, I want to connect IFS Business Reporter with IFS Application 9 environment , Kindly guide  Regards

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.

When I run a quick report through IFSAPP it works fine, after that I run it on any user it shows the error.  When I run Quick report on user ID that error is show  

Hello, FriendsI have a problem in Relationship management module, I’ll describe it in the below:We have some Customized field in Business opportunity page (follow the attached file) that prepared by our ERP developer team, How can we achieve to these fields in Business opportunities page (we want to bring them in Business opportunities columns) for preparing some analysis report and excel output. Thanks guyswish the best

I just went through a successful upgrade from IEE to 23r2 deployed On PremI have the provided IFS_INVENTORY, IFS_SALES, IFS_CRM, and IFS_PRODUCTION_PERFORMANCE models deployed for Data Mart and scheduled.I scheduled my Data Mart Refresh Category, Data Load, and Model Processing in a db task chain, these execute successfully, and I see my logs in both data and process runs.For some reason I don't see any data past the day I did the initial data load in SQL Server, the data is fresh in the MVT and BI tables.Can someone assist with this, if so, please let me know if more information is needed from me?

When using query builder, I get multiple records when I use Join.   In The example below, I get 3x the records I expected, each record being duplicated 3 times.  I am assuming I am getting this due to the Join, my records from View A, the same records from View B, and the same records from the Join.  What can I do to only get 1 set of records and avoid duplicates?    

The documentation states the following, but I cannot find where to download the Layout Migration Tool in the Remote Deployment Guide.Can anyone tell me where I can download the Report Layout Migration Tool?https://docs.ifs.com/techdocs/24r1/070_remote_deploy/400_installation_options/005_operational_reporting/150_layout_migration_tool/--> https://developer.ifs.com/  

Dear All,I can see the background jobs screen in Aurena but if I want to see the detail of a job by selecting it, I am not getting that option. Check attached screenshot. I want to know how can I go to the show details of the job in Aurena.  Thanks in advance! BR,HA

We have a customer on 22R2, hosted in IFS cloud, looking to use Power BI.We’ve read the instructions here https://docs.ifs.com/techdocs/22r2/050_reporting/400_power_bi_int/010_setup_pbi_int/but not sure what customer would do and what would need to be done by IFS managed cloud team.Has anyone done this?Thanks.

Hi, I created a Custom Field in the LU IncomingInvoice which returns the Coordinator Name based on the PO Reference. But there could be multiple PO References separated with a semicolon. When that is the case IFS returns no value. Is it possible to solve this issue, so that IFS returns multiple values when there are multiple PO References. Please see the screenshots below. Arguments:v.company, v.po_ref_numberSelect Statement: SELECT t.cf$_coordinator_name FROM Purchase_Order_cfv t WHERE t.company = :COMPANY AND t.order_no =:PO_REF_NUMBER Kind regards,Simon

Hi, I need some help with a SQL statement for a Quick Report I try to create. I want to show the total amount of a Purchase Order including charges (when a charge or multiple charges are applied on an order) and excluding tax. I created the statement below, but did not get the desired result. The statement is working fine, except the bold part. The statement returns only a value in ‘Total Amount’ when there are charges applied on the Purchase Order. And also, when there are multiple charges applied on the PO, the statement returns multiple lines. See the example below. Purchase Order Wanted Receipt Date Receipt Week Status Total Amount P101306 12-01-2021 02 Closed 726,6 P101306 12-01-2021 02 Closed 701,6  My desired result is: When there are no charges applied on the Purchase Order, the report should show the total amount of the Purchase Order. And when there are charge(s) applied, the report should show the total amount of the PO plus the amount of the charg

Hello All, Can somebody provide a good document/tutorial/work instructions on how to create a Business Report? I don’t seem to find any good manuals that describe the possibilities and ways that we can use business reporter. For example: - If I use a Repeater on a row, can I use this repeater and define this immediatley as a dynamic XLS table? - Can I make a Pivot table of this? - How can I create a bar chart that takes into account the dynamic range of the repeater? - How to add an additional ‘calculated’ column to the table? (Calculated = I just want the difference between 2 source columns). Thanks for your help! Best RegardsRoel

Hi, I have an issue with adding a field on a lay-out in Report Designer. I want to add a field on the pdf lay-out of the Customer Invoice, but two tables overlap in Report Designer with as result that I am not able to add the new field. Does someone know how to resolve this issue? Please refer to the screenshots below.    

Can you program Lobby Parameters have dropdown selections?  Our Managers would like the ability to select the Sales team instead of typing the name. 

We want to remind the suppliers of the deliveries on a daily basis and to come to us as an information report on who the reminder was made to.We did this with 3rd party apps. But I know that IFS is capable enough to do this as well. So we don't want to depend on 3rd party apps.But in order to complete this, I have many questions and problems in my mind.How to send the report sent to each supplier to me as information (e.g attachments)? How do I attach the excel report to the sent emails? How do I send email body as html with "Operational Report -> Report Formatter". How do I send the email sender from our email address like supplier@xyz.com. Or how do I make the sender header "Reminder for Pending Purchase Part"? Can I insert graphics such as lobby elements into the email?We are using IFS 9.4. And we couldn't find answers to most of our questions from the community and the help document.Your every information on the subject is very valuable to us. Thanks.  

Hello,We have an issue surrounding business reporter that is causing frustration in its users. After initial login in Excel, we are able to use BR as needed. However, if we get timed out and attempt to login again, we get the error below. The only workaround we’ve found involves closing all instances of Excel and reopening the business reporter. This is a pain when working on many reports, or when we just have many different documents open. Occasionally this doesn’t even fix the issue and we need to restart the entire computer. Is anyone else experiencing these issues with BR? Anyone have a fix for it? Thank you,Dylan************** Exception Text **************System.Exception: Error while calling the projection BrClientAuthorizationHandler. ---> System.Security.SecurityException: IFS Business Reporter session has expired. Please re-login using the Login button. at Ifs.Application.Br.Authenticator.AuthenticatorService.GetOpenIdAccessToken() at Ifs.Application.Br.Authenticator.Se

Hello IFS Comminity,I found a very strange error today. We are currently using IFS 9.1- When the user log in using English language the Quick Report can run normally.2- When the user log in using French language the Quick Report generated an Error.Screenshot Error Error Log  Messages d'erreur du serveur :0db87c89-3718-4b71-b829-87a67a0cec77 Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-00972: l'identificateur est trop long Failed executing statement (ORA-00972: l'identificateur est trop longORA-06512: à ligne 12)   à Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)   à Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions)   à Ifs.Fnd.AccessProvider.FndConnection.HandleHttpSuccessResult(HttpWebResponse result, FndManualDecisionCollection decisions, String operation, Fn

Hi Everyone,Following error will appearing while connecting to the IFS Cloud instance. IAM client setup is done as per the technical documentation.  Thank You.

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

We use Aurena only, Apps10 Upd13 (soon to be 14) and on a regular basis one or more or all of our SQL order reports start giving errors to all users. But only sql reports, crystals and operational reports are fineThe report in EE works fine, even when in Aurena failsapart from a server restart, this seems to continue for a few hours, then resolves itselfIt feels like were running out of some cache or disk but no one has been able to adviseRunning a refresh server cache sometimes fixes the issue, but not alwayserror:An internal server error occurred. Contact administrator.Url: https://----/main/ifsapplications/projection/v1/QuickReports.svc/QuickReport_844567()?$skip=0&$top=25Request Id = 46e2c0fe-2ce6-4e79-8e0b-09cdeb2b7c37Date = 2022-01-13T12:15:14.661ZClient version = 10.14.123.0