Insights (Business Reporter and Analysis Models, EOI)

607 Topics

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

purchaser order operation report not text

Hi could someone help me please, I have created a new operation report in crystal using purchase_order_print_rep as the main data source for our purchase order and I am trying to add the note_text field from the purchase_order. when i run in on crystal i can see the note_text field, however when i run it on IFS the note_text field come back with no data. Is there work around for this by any chance

830

3 years ago

2020

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

Crystal Reports as Operational report and row level security

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

2601

3 years ago

ADNANSidekick

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

THE ERROR WHEN WE RUN THE QUICK REPORT AGAIN

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

610

3 years ago

hhy38Superhero (Customer)

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

About Hiding SHOW SQL option from Quick Reports

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?

1824

3 years ago

dnyandeDo Gooder

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

lobbies behaviour

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

811

3 years ago

PheonixDo Gooder

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

Aurena report is not getting updated with latest changes

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 ?

470

4 years ago

Achilles0129Do Gooder (Customer)

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

Is it possible to have two drill down functions on the same element?

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

1183

4 years ago

sholmesHero (Customer)

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

APPS9 Looby Element Designer Format

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’

1283

4 years ago

LinksGrecianDo Gooder (Customer)

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

Business Report Crashes Excel, ".net framework" error

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

5184

4 years ago

dnyandeDo Gooder

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

How do I access IFS report designer

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

2841

4 years ago

william.klotzSuperhero (Customer)

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

Business Reporter : Creating Pivot Tables

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

4713

4 years ago

CapAvinaKSidekick (Partner)

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

Filter reports on Project Invoice screen

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. !!

591

4 years ago

a.georgeDo Gooder (Customer)

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

ABC Classification

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?

1700

4 years ago

a.georgeDo Gooder (Customer)

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

ANALYZE (analyse) DEMAND DEVIATION

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

961

4 years ago

AnnaSidekick (Customer)

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

Supplier Expiration Date

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.)?

12394

4 years ago

DalShiloZSidekick (Partner)

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

Business Events Analysis

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

2232

4 years ago

WiktorSidekick (Customer)

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

Operational Reporting - emailing PDF under changed filename

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.

6002

4 years ago

fyz29

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

Attachment Window Permission Settings

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

3964

4 years ago

DalShiloZSidekick (Partner)

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

In Company master How can i set Different customers using the same company name, use English or Japanese

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 ?

2682

4 years ago

hcskisaakDo Gooder (Customer)

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

BA report - link to IFS 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?

3593

4 years ago

hapain

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

Business Analytics - Measure item - min or max values

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?

2271

4 years ago

ProMagnusDo Gooder (Partner)

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

Developing Qfact tables for IFS Business reports

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

2781

4 years ago

LahiruDSidekick (Partner)

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

Information Source Dimension DIM_ACCOUNT_BI

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

1641

4 years ago

KPalmieriDo Gooder (Customer)

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

Business Reporter - New "Information Sources"

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

5641

4 years ago

MichaelKowalukDo Gooder (Customer)

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

Route to connect enabling OutputFileName

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!

1571

4 years ago

Page 23 / 25

Insights (Business Reporter and Analysis Models, EOI)

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded