Replies posted by EntNadeeL

161 Replies

S
Do Gooder (Customer)
Swivel53Do Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Operational Report Parameter Causing No PDF Returned from Crystal Web Service

Hi @Swivel53 Normally if its an additional layout to a standard report, then you can only pass result key as that is what connects to all information.Why would you try to pass shop order no ? If you are trying to get shop order connection, do that by bringing the view that contains shop order no and joining it to the rep view Cheers

1
EntNadeeL
Hero (Partner)
4 months ago
hhy38
Hero (Customer)
hhy38Hero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to use dynamic pivot on Quick Reports?

Hi @hhy38 I can share it here. that is fine.Sorry it took some time to find it. Let me know how it goes.Cheers

4
hhy38
Hero (Customer)
6 months ago
hhy38
Hero (Customer)
hhy38Hero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to use dynamic pivot on Quick Reports?

Hi @hhy38 I have this example with me. I will share the code with you. your approach is fine but i cant exactly fine the problem here. Let me get back to you.  

4
hhy38
Hero (Customer)
6 months ago
H
Sidekick
HananeSidekick
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Custom field number format

Hi @Hanane As @romsar mentioned here, create an event to _CFT table to validate the input of the field.Code would be something simple similar to below.DECLAREBEGINIF (NEW:$field_value) < 0 or INSTR(to_char(2.0), '.', 1, 1)>0 THEN ‘Error msg’END 

7
H
Sidekick
6 months ago
H
Sidekick
HananeSidekick
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Custom field number format

Hi @Hanane Set the data type to number format. I believe you will have to recreate as you cant change the data type after the custom field is created.

7
H
Sidekick
6 months ago
T
Sidekick (Customer)
TTRACYSidekick (Customer)
asked in Finance (Financials)

Projection settings

 

4
EntNadeeL
Hero (Partner)
6 months ago
B
Hero (Customer)
bdoucetteHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to link views together for Operational Reports?

Hi @bdoucette You can join as many views as you need to a crystal report.It is not something IFS recommends but it is still possible. What you need to worry about IFSPRINT is the grants. These kind of reports can only have one parameter and it must have a rep view and joins should start with the rep view.By doing so, you will get to use any view. But be careful on duplicate records as _rep views contains all the header and details level data.I have done this for so many years. and it works. My customer is using below report as a layout to a standard report which includes other views and custom commands as well. The main thing you need to keep in mind is that you will need to grant these views to IFSPRINT because when you run the report from IFS, it is looking through the user IFSPRINT. Below example is a bit of a complicate one. But try to keep it simple as much as possible and be aware about the joins.  

1
EntNadeeL
Hero (Partner)
6 months ago
Chamaka Wimalarathne
Hero (Partner)
Chamaka WimalarathneHero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Quick report date column shows time

 Hi @Chamaka Wimalarathne It looks like Aurena or Cloud adds the time portion by default if you use the date format in a quick report. You can check this with a standard field that does not have a time portion.If you check the planned due date in customer order lines, it does not have a time portion. But if you take it into a quick report, it will show the time portion as  00.00. I believe this is something we will have to ask from IFS as it does not mention anywhere in the documentation.

8
V
Sidekick (Partner)
6 months ago
Chamaka Wimalarathne
Hero (Partner)
Chamaka WimalarathneHero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Quick report date column shows time

@Chamaka Wimalarathne You are right. I was just checking from EE side. However it looks like this does not work for any version of Aurena. Let me check this a bit more and see if I can find anything.

8
V
Sidekick (Partner)
6 months ago
Chamaka Wimalarathne
Hero (Partner)
Chamaka WimalarathneHero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Quick report date column shows time

Hi @Chamaka Wimalarathne Below should work. I have tested it with a quick report.trunc(TO_DATE('01 Jan 2018 08:00:00', 'DD-MON-YYYY HH24:MI:SS'))Give it the right date format and then trunc it.cheers

8
V
Sidekick (Partner)
6 months ago
PRODQ
Hero (Customer)
PRODQHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Has anyone added a Custom Field/activated ROWKEY in MRP Action Proposals?

Hi @PRODQ If you go to the ‘Excluded logical Units’ window and search the logical unit MrpPartAction and remove it from the list you will be able to add custom fields.cheers

2
PRODQ
Hero (Customer)
7 months ago
Chamaka Wimalarathne
Hero (Partner)
Chamaka WimalarathneHero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Quick report date column shows time

Hi @Chamaka Wimalarathne Try using to_date(date_field,'DD/MM/YYYY') or trunc(date_field)Cheers

8
V
Sidekick (Partner)
6 months ago
D
Hero (Customer)
darren j turnerHero (Customer)
asked in Buying (Procurement, Demand Planner, ASC, SRM)

Adding Custom Fields from other view

Hi @darren j turner Is this a read-only custom field?You can check the error from debug console → Server trace or PLSQL Details tab (if you are familiar with it)

4
D
Hero (Customer)
6 months ago
B
Hero (Customer)
bdoucetteHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS Cloud Crystal Reports error

Hi @bdoucette Try running the SQL query of the report logic from IFSPRINT login in the database.It is a bit hard to find crystal errors in IFS cloud.But most of the time this error is generated due to a permission issue. 

5
L
Do Gooder (Partner)
3 months ago
R
Do Gooder (Customer)
roxandcarDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Update url in ExternalNavigationLink

I checked this a bit more and found out that the information is saved to the metadata table. But it is not recommended to edit this table as it could corrupt the page metadata.

3
R
Do Gooder (Customer)
7 months ago
R
Do Gooder (Customer)
roxandcarDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Update url in ExternalNavigationLink

Hi,This is not possible in Aurena.You could try to delete the whole command and recreate it. I believe the commands are created from client code. I could not find a view or a table that stores them.

3
R
Do Gooder (Customer)
7 months ago
C
Do Gooder (Customer)
christian.carlssonDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Divided permissions per Company / Site

Hi @christian.carlsson Once you assign a site/company to a user they will get the same permissions on granted projections for all sites/companies granted to that user. We faced the same issue recently for something similar.You could try creating quick reports for information where you only want to give read only permission. But depending on your business scenario this might not be applicable. But for my customer we just needed a temporary solution till we go Live on regional companies.

2
EntNadeeL
Hero (Partner)
7 months ago
R
Hero (Customer)
romsarHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Display a custom field for all users

Hello @Link  I deployed once again on the base profile and now, the field is visible… Now, I changed both the coordinates and the size of the CF but it’s not updated for every user, is there a specific action to realize? Hi @romsar You need to save the changes to the user profile again.

7
R
Hero (Customer)
7 months ago
L
Hero (Customer)
ludovic.rougeanHero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to fine tune projection grants in Aurena?

Hi Ludovic,I was just looking for something and found this one. Hope this was resolved since it was one year ago. Do you still have this problem?

1
EntNadeeL
Hero (Partner)
7 months ago
D
Sidekick (Partner)
DominikaM
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Overwriting database packages and xsd files of operational reports after release update

Hi @DominikaM I would suggest to keep customized database logics in a separate package (Like a custom package).It would be better to avoid changing existing standard core packages unless the code is added to the cust layer in repository. IFS has provided so many options such as Database tasks, Configurations to allow most of the changes you need to implement. For reports you could switch to crystal report or business reports as it allows to access those custom packages.Or else you will have to manually deploy all these changes during a release.  

9
JohannesKnust
Hero (Partner)
6 months ago
S
Do Gooder (Customer)
szamburDo Gooder (Customer)
asked in IFS Cloud - New Customers

IFS Cloud problem with create association by CF field

Hi @szambur When you use a standard entity to create a new projection it will not bring in the custom attributes as the page data can only be used in read-only mode. If you create a custom page and try to bring the custom field into the page using page designer, still it will not work as the page is read only.I have tried to create a custom page using a standard entity but it never worked as IFS does not allow to do any modifications to the data. If you check the documentation for projection configurations you will notice creating a new projection from a standard entity is not explained.Cheers. 

2
EntNadeeL
Hero (Partner)
7 months ago
E
Do Gooder (Customer)
Eesha1753Do Gooder (Customer)
asked in Data Migration

Navigation command to specific page stuck

Hi @Eesha1753 It is bit hard to troubleshoot commands after creating if navigation is not working. Could you please recreate the command and send a screenshot before saving it so we could see the URL you used and other information?Cheers 

1
EntNadeeL
Hero (Partner)
7 months ago
C
Do Gooder (Customer)
cholusDo Gooder (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Cloud 23R1: Can we pass Quick Report Parameters for Crystal Report for Custom Commands on a Page?

Hi @cholus Unfortunately no!I am working with a customer who has the same problem and we have limited using crystal reports with parameters in Aurena side and for the reports we use, we make sure to have one or two params at max.if there is a standard report view available (CUSTOMER_ORDER_IVC_REP) in the page you could add as an additional report layout. This way it will be able to take the page information automatically. But it will come under share command which might not be your requirement.Cheers.

3
C
Do Gooder (Customer)
2 months ago
I
Do Gooder (Partner)
IniVismiMDo Gooder (Partner)
asked in Finance (Financials)

Business Reporter - Adding repeaters for APP9

@IniVismiMUnfortunately yes!I could not find any other way either.I guess you don't have  to include everything in the repeater (such as amounts). But you have to be careful as each repeater acts as a grouping.Cheers

2
NiyomalN
Hero (Partner)
7 months ago
G
Superhero (Partner)
gumabsSuperhero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Counting Values on Custom Page

@gumabs Have you synchronized the logical unit after changing.?Cheers

6
G
Superhero (Partner)
7 months ago

Badges

Show all badges
Terms & ConditionsCookie settings