Insights (Business Reporter and Analysis Models, EOI)

Hi,I’m creating reports with Crystal Reports as operational reports on IFS Applications 10 Update 8 and I have question about whether row level security is applied or not when developing the report according to the guidelines. I would guess it is but the documentation is a bit ambiguous.I’m guessing that I don’t understand exactly what is referred to in the first text extraction below. I’m referring to this page: https://docs.ifs.com/techdocs/Foundation1/050_development/025_operational_reporting/200_cr_as_operationalreport/default.htmI’m making the confusing parts bold in the text below.In the ‘Design and Security aspects’, it is stated that:“The Crystal Reports executed this way always access the database using the same user as the Report formatter (i.e. no row based per user security is applied).“Further down in ‘Data integrity and row based security’ it is stated that:“As long as the Crystal Reports only accesses the report result table when querying data, the default IFS Applicatio

Hello,When the report is run, it gives the following error when it is tried to be run again after a certain period of time.1  2  3 Wait 5 minutes 4.  5 ERROR 

We want to hide SHOW SQL option from quick report. We checked debug console and couldn't find presentation object of SHOW SQL option. How can we find it? 

Hi guys is there a way of sending notifications to users when they have a task overdue on their lobby page

I have created a new layout foir both APP10 and Aurena. I have added few more changes to the layout, these changes are visible in APP10 but these changes are not added to Aurena. Is there a way to fix this ?

Hi @ADNAN I have two questions about the Drill Down function. Is it possible to have two drill down functions on the same element? For example, if you press the Picklist_No. that the Picklist Report and a view of the Shop Order table opens at the same time?My second question has to do with the same topic. Is it possible to open a picklist report with the drill down function? I try different options, but I don't get the desired result.ThanksAchilles0129 

Hello AllLobby help again needed please. I’ve got a date field in the data and in the element I’d like to highlight dates that are passed today’s date. The system doesn’t like me putting in ‘TODAY’ as the value but it works when I add today’s actual date - any ideas on how to get this to work?Working when I added a dateNot working when I add ‘TODAY’ 

This regards the IFS Business Reporter add-in for Excel, specifically Excel in Office 2016, 64-bit. There is one specific BR report we run which I’m having these difficulties with, doesn’t seem to occur with any other report and, strangely enough, running this same report works when done on different computers. The error we’re having occurs when trying to “Run Report” once IFS is loaded. We pick the standard parameter values, press OK, then in the Report Execution Progress window, it seems to go through everything (goes through steps 1 - 3 , fetches data) then it crashes Excel, Excel restarts, and it opens to a blank worksheet. I’ve checked the event logs and found the following pop-up at about the same time it crashes, so this should correlate: Event Log Error #1Event Log Error #2I’ve tried many things, like running .net repairs and running as admin. I’ve officially run out of ideas, so I’ve come here, hoping I can be pointed in the right direction if not have the problem solved entir

Hi am new to IFS and I was wondering if any one knew where to find the IFS report designer, when i search for it in the navigations pane nothing comes up

Hi Everyone, We’ve recently upgraded to IFS Application 10 Update 8.  I was asked today to create a Business Report that generated the results in a pivot table format.  In IFS Application 8 with Business Analytics there was a button where I could choose a pivot table but I do not see this option in Business Reporter included in IFS Application 10 Update 8. Has the feature been removed?If so how do we generate a pivot table output using Business Reporter. Thank you,William Klotz

Is it possible to filter Reports on Project Invoice screen?Suppose I have 12 reports for project invoice screen and I want that for a given company it should only show me few reports that are related to that company. Any suggestions would be appreciated. !! 

Hi We ran the ‘ABC Classification’ Module prior to our year end/Stock take.Post year end when we try to run it we get the error message ‘ No Statistical Information was Found’Has anyone any experience of this and could possibly help please?

HiPlease could anyone possibly tell me what ‘ANALYZE DEMAND DEVIATION’ does and its impact Thank you

My company is wanting to set suppliers inactive and we know how to set the expiration date on the Purchase Tab > Misc Supplier Info sub-tab but the definition of the field says “The date after which details of the supplier are not to be retained. The expiration date only controls the creation of new transactions in the system for the supplier”. The first bit is what’s throwing us through a loop. Does this mean that IFS will purge the historical records of the supplier (e.g. purchase orders, invoices, etc.)?

in screen of 【 Accounting Rules > Business Events > Business Events Analysis 】I want get which screen which action show this Event log   1st one details 2nd one details  

Let me join the IFS community with this very first thread! My issue is how to e-mail report (invoice or order confirmation) but under attachment file name different than default (ReportID || ResultKey). I have tried with Report Rule where action is Set Property, then set DocumentFileName to WhateverIWantTo.pdf but it doesn’t seem to be a solution. Next i have prepared Rule with Action SendEmail, then set Attachment Name to new FileName, but it came to me with above mentioned standard filename. The same for Route To Connect action with Output File Name set to new one. But, it didn’t change file name either. I assume, the best way would be to define under which name report should be created, so in earlier stage than e-mail it. However I ran out of ideas how to achieve it. Hope that anyone here can help me.

Hello everyone, How can I give permission for this window?  I’m using IFS9 

In Company master How can i set Different customers using the same company name, use English or Japanese or other language ( Invoices,or other reports)in under screen  or other set up screen ? 

I’m setting up a BA report (or SSRS report), but users want to see invoice details and have a link that leads them back to the invoice screen (or opens up the PDF attached to the invoice). Is there a way to do this from a BA report or SSRS report? What does that link setup look like and what are the dependencies?

When I have a measure like “Price”, i don’t want this to sum up when in a BA or BR report, the summary happens based on repeater fields. If it was “Value” or “Qty” , Sum makes sense. Is this possible? Is there any way the Min or Max value (like in Oracle Grouping) can be displayed?

Hi! Please provide material for developing Qfact tables, which are used in IFS BR.

Hi Community, Have you experience a situation where DIM_ACCOUNT_BI Access View in Business Reporter has multiple records for same Account and Company.  Thanks 

Hello - BR comes with a standard list of “information sources”, how do I add additional sources from within IFS?My current specific example: I am looking to add the source “Inventory Parts Unit Cost” from the Warehouse Management-Financial Control path…Have few other needs so this would be very helpful!Thanks

Hello,How can I enable OutputFileName and OutputType in Action Properties for Route to Connect in Report rule? No matter how hard I try I can’t seem to find a solution. My action properties looks like:And I need this section:Thanks for your help!

IFS Business Reports Information IFS Applications 10 Product Version:  5.0.15.0 Component Version:  BACLI 2.0.0 Build Date:  Tue, 21 Apr 2020   When trying to one of our IFS Business Reporter reports we receive the following error:     Details Ifs.Application.Br.Core.ErrorHandling.ReportException: Parameter name expected, found ''     at Ifs.Application.Br.Generation.BusinessObjects.CriteriaParser.ParseValue(TokenType[] endTokens, Token& token, Datatype type, ReportOperator op)    at Ifs.Application.Br.Generation.BusinessObjects.CriteriaParser.ParseValues(ReportOperator op, Datatype type, Token& token)    at Ifs.Application.Br.Generation.BusinessObjects.CriteriaParser.ParseCondition(String text, ArrayList& values, Datatype type, ReportOperator& op)    at Ifs.Application.Br.Generation.BusinessObjects.CriteriaRowImpl.Parse(Location loc)    at Ifs.Application.Br.Generation.Containers.BrDesignTemplateGen.BuildParentCriteria(DesignDsodSet dsodSet, ArrayList parentV