Insights (Business Reporter and Analysis Models, EOI)

asked in Insights (Business Reporter and Analysis Models, EOI)

Hi,We use IFS Cloud 21.2.11 on Managed Cloud and Power BI desktop connect to Power Bi Cloud.Is it possible to read IFS data from Power BI ?If yes, do you have a documentation ?Regards, Christophe

21035

1 year ago

jzouaouiSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

How to Print Pdf report automatically

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

49814

1 year ago

SKA123Do Gooder

asked in Insights (Business Reporter and Analysis Models, EOI)

Quick report default values in parameters

Hello community,I need to set a default value in quick report parameter.Here is my query in quick report: “ select * from customer_order where order_no = '12345' and customer_no like '&customer_order.customer_no' “Result of “select * from customer_order where order_no = '12345' “ in SQL :When executing on ifs, I got the list of all customers, it doesn’t take the filter into consideration : Is there a solution for this please?Thanks in advance!

3381

1 year ago

WellactuallyjustBennyDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Custom attribute for fact from &AO.[...]API.Decode(&AO.[...]API.[...](Parameters)

A beautiful good afternoon, I am currently trying to add a column from the receipt_Info view that seems to be somewhat customized. Usually I would use the “SQL Column” from the “System Info” Panel.But this one is not a regular term like “STATE” that can be used there but instead “&AO.[...]API.Decode(&AO.[...]API.[...](a list of parameters from the view)”.Can I integrate that column somehow into the information source and if so how?Best regards,Benny (Edit: typo)

1571

1 year ago

JannetteCHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Quick report export to excel error

Hello all, When I try to export to excel my report I am getting the following error - what does this mean please ?

1841

1 year ago

VsoMdsaiIDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter - balance Current Month, Last Month/Year

Dear All,Can anyone tell me how to Set/show GL Account balance in three column cuurent month Balance, Last month Balance, Last year Balance in business reporter?

2352

1 year ago

SshirleyDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter - exclude multiple accounts

In the filter Criteria, I would like to include all Revenue accounts except 3034, 3037, and 3040. however, I’m finding it only allows me to exclude one account. Is there another way to accomplish this?

762

1 year ago

SshirleyDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter - Total multiple sections

Hi I’m trying to get a total for multiple sections and getting an error. Limit the range in the formula to a single section. Is there a way I can total more than one section. here’s an example. we are breaking benefits out to list some accounts by site but want a total for all benefits

513

1 year ago

TopDeepaWSidekick (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Calculations of the Measure Items in BR

Hi, Is there any way to do the calculations like count, max, min using measure items in IFS business reporter? As per the point 1, I have dragged debit balance column to the report. After running it will show sum of debit balances of the accounts as per the point 2. I want to get max amount of debit balance for each account. Thank You.Regards,Deepal.

371

1 year ago

RemyGeilvoetDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Enable history logging on quick reports

Hi all,We are preparing for the upgrade from IFS9 to IFS10 and in the process we would like to clean up unused items as much as possible.Over the years we have created a lot of quick reports and we lost track on their functionality and whether they are still used or not.Is it possible to enable some sort of history logging on them so we can get an idea about who are still using them or at least get an insight on if and how many times reports are used?Thanks in advance for any help.Remy

3494

1 year ago

lemantDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Mappings Apps 10 to PROD

Does documentation exist that maps tables and views between Apps 10 and Cloud? Needing it for a data warehouse project.

312

1 year ago

kkormDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Custom Menu Business Reporter Bundle Execution (IFSAPP10)

Is there a way to enable bundle execution for the “Report” action type in a custom menu? For quick reports, this is easily achieved, but doesn’t seem to be an option for Business Reporter reports. For context, I have a BR report that accepts a string with multiple values for an argument when run from the “Order Report” dialog and a custom menu that works fine with just a single value, but I’m struggling to figure out how I can get a custom menu to work when highlighting multiple rows and sending all rows as an argument value.

330

1 year ago

Nisansala LiyanageHero

asked in Insights (Business Reporter and Analysis Models, EOI)

Operational Report not available for scheduling

Hi,Does anyone know why this error is raised when scheduling a report? What are the specific permissions this user should have or how to grant access to this specific report to this user?

451

1 year ago

pendrivedatarecoveryDo Gooder

asked in Insights (Business Reporter and Analysis Models, EOI)

Import MSG Contacts into Outlook – DIY Guide for Every User ?

How might Pen Drive Recovery import MSG contacts into Standpoint without burning through much time and exertion? How is feasible to import the information in mass without going through any inconveniences or dangers of Standpoint being crashed or contacts being altered? Indeed, there are different strategies that you might find on the web yet the inquiry is are these techniques effective? You will find that out in this blog.We as a whole realize that a MSG document is a solitary message record that contains every one of the messages, contacts, schedules, and so forth in it. In the event that you independently make a MSG record for contacts, just a single contact will be saved in a .msg document. In some cases, clients might need to import .msg contacts into Viewpoint 2010, 2013, 2016, and 2019, which is the reason we are referencing helpful arrangements here.There will be two simple techniques made sense of in this blog. One is an immediate strategy for bringing in the information which

2071

1 year ago

ditomathiasDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Preview Print on IFS Cloud always error

19:32:43 INFO - REQUEST method "POST"19:32:43 INFO - REQUEST uri "https://===========/main/ifsapplications/projection/v1/PrintDialog.svc/ReportDirectPrintRequest?odata-debug=json"19:32:43 INFO - REQUEST protocol "HTTP/1.1"19:32:43 INFO - RESPONSE status {"code":"500","info":"Internal Server Error"}19:32:43 INFO - RESPONSE headers {"OData-Version":"4.0","Content-Type":"application/json"}19:32:43 INFO - RESPONSE body "{\"error\":{\"code\":\"DATABASE_ERROR\",\"message\":\"Database error occurred. Contact administrator.\",\"details\":[{\"code\":20105,\"message\":\"ORA-20105: Report.PRINTJOBERR: Error occured while running the Report. Refer to Print Manager/Print Key 232\"}]}}"19:32:43 TRACE - SERVER version "odata-server-core Version 4.9.0.1-ifs" when try preview purchase order before print always 500 internal server errorany solution?

1812

1 year ago

SuryaDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Labels of order report can do Hindi Language in report designer

Footer and Header, Labels of order report can do Hindi Language in report designer

371

1 year ago

kkormDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter - Run Multiple Reports at Once

I have a BR report in APPS10 where I’d like to run multiple reports at once. In this example, the report takes a work task number for input and generates several pages for the work task. I’d like to either be able to pass in a list of work task numbers to the report itself or have IFS recursively call the report to produce multiple. Ideally, our end users would like a single combined PDF as well, but I’m not sure if that’s possible in the recursive case.So far, I’ve tried using sheet repeaters when allowing multiple values for work task input, thinking that the sheet repeaters could iterate over the list. This doesn’t seem to work, as the report just returns the design version, with no fields populated.I also tried to dig into the package (XLR_TEMPLATE_UTIL_API) that I think actually executes the reports, but I was struggling to successfully generate a report.Does anyone have thoughts on whether the above points are possible, and if so, how?Thanks!

1334

1 year ago

SHAUN_KERSLAKEHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter Execution Server

HelloWe are currently on Apps 10 Update 15, and have IFS BR Execution server setup and working on a Windows server. As part of receiving Update 18, we are required to update the version of BR Execution server as per release notes. However IFS do not provide the steps to perform this, and there is nothing found on this community so far or via the IFS Technical help pages. I downloaded the MSI Installer from the Add-on page, and transferred this to the Windows server. But when executing this, it errors out due to a Windows service already existing. There doesn’t appear to be an option to uninstall or upgrade. Has anyone been through this process, and how do we perform this?Any help would be appreciated!Thanks

894

1 year ago

TopDeepaWSidekick (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Can not load GL Balance source to the Report

Hi,I have tried to load GL_Balance information source to the business reporter. But it shows the following error. I can load other sources without any error. Best Regards,Deepal.

423

1 year ago

MangalaDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Is it possible to export IFS Business Reporter reports as .ins files?

Is it possible to export reports created using IFS Business Reporter as .ins files? I noticed that the sample reports in General Ledger are delivered as .ins files. But I could not find a way to do that using IFS Business Reporter. Any idea how to do this?

510

1 year ago

rajglkDo Gooder (Employee)

asked in Insights (Business Reporter and Analysis Models, EOI)

Streamserve Reports are not created to a folder

Hi All, I got a ticket from a customer that Stream Serve Layout reports are not print in the folder path created in IFS Cloud 22R2 Worked in App9 as below.Enter the folder path which is in the middle ware servicePrint the Report and it will create a file in the folder path given in the system parameter. And they are trying to do the same setup in IFS Cloud 22R2.But while they print the report, they are getting the error as ‘No Such file or directory’ Is there any access problem or any idea for this.Thank you

521

1 year ago

WellactuallyjustBennyDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

IFS BR Information Source Purchase Receipt Status

A beautiful good morning to everyone! :)Is there a way to controll in an IFS BR file for the status of a purchase receipt?I cannot find the status in the light items nor in any of the linked dimensions.My current workaround would be to extract all receipts filtered for the cancelled status from the IFS App 10 GUI and add them manually to the executed report afterwards and link the status for the cancelled ones with a lookup and remove those receipts this way.Does anyone have a better idea?Manipulating the information source itself could be an option?I wouldn’t know how to do that currently, though.The overall goal is to produce a GRNI Report.Best regards,Benny

513

1 year ago

reportingmgrDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

BR email subject line “Excel -File for report is ready”

We are running IFS 10 Update 13 mostly with Aurena.-Two report notification email issues:When scheduling reporting, and setting them to send emails to users, we have noticed that canned (prebuilt) reporting includes the name of the report in the subject line of the email. But, Business Reporter (BR) reports will not move the name of the report to the subject line of the email. Instead, we only see: “Excel -File for report is ready” -How do we get the name of the report into the subject line of the email? We run multiple test environments. Can the environment name be in the Subject line of the email?Thanks!

770

1 year ago

Hassan ShareefDo Gooder (Employee)

asked in Insights (Business Reporter and Analysis Models, EOI)

Post Business Report Installation - Cannot open files larger than 10 MB

My customer is running 23R1 and after they installed BR on their local PC, the users are not able to open any excel file that is over 10 MB. Has anyone seen this problem?

121

1 year ago

mohamed_akrouhSidekick

asked in Insights (Business Reporter and Analysis Models, EOI)

Query Designer - can't specify value as parameter

Hi, I am attempting to create a query with parameters, but when I select my fields, Query Designer doesn't provide the option to choose dynamic parameters. Instead, it requires me to insert specific values. However, I want my query to support user parameters, allowing for a more flexible and dynamic input.thank you for your help

570

1 year ago

Page 6 / 25

Insights (Business Reporter and Analysis Models, EOI)

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded