Solved

11694 Topics

DevBobSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Understanding SQL Date Formatting for QuickReports, IALs, and SQL Query Tool

We’re getting run-time errors due to date logic/formatting/selections. Is there any standardized set of date formatting rules?I have numerous Oracle SQL websites detailing date functions, but we run into issues every now and then, with each case having slightly different requirements/logic.Scenarios:1.) SQL in an IAL runs fine in the quick report using it, but fails when run in the SQL Query Tool.2.) A quick report runs fine (and also runs fine with RMB Output>Save As...) but if you take Export to Excel it fails.For instance, our latest situation is this error when running an IAL’s logic from the SQL Query Tool that doesn’t occur when running a quick report over the same IAL: IAL logic:selectsoi.sub_program_id as PGM,cois.district_code as Class,omi.commission_receiver as Receiver,max(cin2.name) as Receiver_Name,max(cia.name) as Receiver_Company,omi.customer_id as Dealer,max(cin.name) as Dealer_Name,max(cois.country_code) || ' - ' || max(cia.state) as CN_ST,sum(CASE WHEN trunc(cois.i

9642

4 years ago

RutJWhalenSuperhero (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

HTTP server certificate expires in 9 days

IFS Apps 10 - Test Environment When running install of delivery update the following message appeared: HTTP server certificate expires in 9 days How do I rectify this issue?

3492

4 years ago

0guzHero (Employee)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

What Is The Prerequirements For Automatically GTIN Generate

Hello,I want to use automatic gtin generate approach on the IFS V10.8.I created a record on gtin basic data like below. I created a record on company basic data gtin prefix like below. Then i checked a catalog part for generate gtin but the option is not active.What should i do more, can somebody tell me prerequirements about automatically gtin generating.Thanks. Company/Distrubition/General

3111

4 years ago

rkurfmanSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Add Document - Document Text Administration

Is there a way in Apps 8 to add Documents to the Document Text Administration?I am looking for Instant Invoice and Interest Invoice, but do not see them in the list, so was not sure if they could be added.

72211

4 years ago

jdowneyDo Gooder (Customer)

asked in Finance (Financials)

ACH payments to suppliers

Does anyone have information they can share on setting up ACH payments to suppliers? I think I have the basic setup completed, but I’m not able to actually create a payment that shows the invoices are paid. Any help would be greatly appreciated.

6494

4 years ago

RutJWhalenSuperhero (Partner)

asked in HCM (Human Capital Management, Payroll)

Time Clock error

Apps 10. When user swiped they card on Time Clock machine they received the following message: Insufficient access rights. You cannot modify Absence Registration data for employee 62905. Any ideas?

5815

4 years ago

MKG019Hero (Partner)

asked in Finance (Financials)

Supplier invoice posting authorize substitutes,does not work with Group

Hi All, Supplier invoice posting authorize substitutes does not work with Group . I am able to add substitute to authorizer id but when the Substitute go for authorization it does not allows to authorize the invoice. In PO it works. Regards, Mukesh Gupta

3997

4 years ago

snarayananDo Gooder (Partner)

asked in Service (Touch Apps, MWO, MRO)

Bill Period Type in Invoice Templates

Hi, Can anyone help me understand the bill period type in invoice templates? I can see the information in the contract code tables but there is no documentation which explains what does the fields period factor & period type mean?

941

4 years ago

rkurfmanSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Report Rule for different Company - Report Layout

I am trying to create a Report Rule for Customer Order Confirmation, etc. to specify a default Report Layout for each Company, as they each have their own layout. Goal is when a User goes to print a document that the Layout designated for that Company affiliation will be what appears as the Layout. I have not been able to get this to work with Order Confirmation or Pro Forma Invoice from the Customer Order screen.

8669

4 years ago

TDCSOURABHSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Mobile Sync Rule - Initial Query

The below XML gives an error EXCEPTION Message: String was not recognized as a valid DateTime. ... Stack Trace: at Metrix.BusinessServer.BusinessPolicies.SharedTablesComponent.MobileManager.PerformReplicationForTableAndPerson(String tableNameIn, String personIdIn, Boolean truncateTableIn, String deviceSequenceIn, SQLiteCommand sqliteCommandIn, mm_process_defRow syncRuleIn, Dictionary`2 tableColumnsDictionaryIn) at Metrix.BusinessServer.BusinessPolicies.SharedTablesComponent.MobileManager.PerformInitializeMobileDevice(String personId, String deviceSequence, String message, SQLiteConnection theSQLiteDB, Dictionary`2 theSyncRuleTableColumnsDictionary) <hierarchy_select return_only_requested_attrs="true" max_rows='50000'> <primary_table>PERSON_CAL_EXCEPT</primary_table> <from> <table>PERSON_CAL_EXCEPT</table> </from> <attrs> <attr>PERSON_CAL_EXCEPT.*</attr> </attrs> <where> <data_constrain

2321

4 years ago

cjohnsonSuperhero (Customer)

asked in Products (Manufacturing, Products, Engineering)

Multi-Site Product Structure display issue

Hello, I have noticed an issue when using the Multi-Site Part Structure Analysis module in IFS Apps 10. The analysis does not show the full BOM in some cases. Specifically, it stop when when we hit an Inventory Part with a Part Type of Purchased (Purchased Part with a Product Structure). Unfortunately, this paints an incomplete picture when we view a Part using this analysis. Is there another location in IFS where you can view the full structure of a Multi-Site part, or is there a configuration setting that must be enabled to view the structure of a Purchase Part in this screen? Any help would be greatly appreciated. Thank you!

1721

4 years ago

hhy38Superhero (Customer)

asked in Distribution (CRM, Commerce)

How to Disable Column Chooser on Permission set?

Hi,We would like disable column chooser for users, but I could not find right permission. We will hide some price columns from user. If you know better way, you can suggest to hide price datas from user.

8054

4 years ago

HOOJEWINLSidekick (Customer)

asked in Products (Manufacturing, Products, Engineering)

grant IAL to IFSSYS

Can you tell me how we can grant a custom made IAL to user IFSSYS?We find in the documentation the following text. Own views need to be granted to user IFSPRINT and IFSSYS We are able to grant the custom made IAL’s to IFSPRINT (via IFS application – Security – Permission Sets) but we don’t see the IFSSYS user here.Maybe we have to this in PL/SQL ?

7425

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

1681

4 years ago

ManishGDo Gooder

asked in Finance (Financials)

Print Payment Advice

I want to Print Payment Advice form IFS using Order Report but in Order report, there is an option to enter Order ID I don't Know what Order ID system required.

10658

4 years ago

tjhendrikseDo Gooder (Customer)

asked in Service (Touch Apps, MWO, MRO)

How do you cancel a Customer order generated by a Work Order in IFS 10

We used the metering invoicing functionality to generate invoices for customers. The process creates a Work Order, a Work Task and then generates a customer order which we could invoice off of. Unfortunately, I need to cancel some of the customer orders but cannot because they were generated from a work order. Does anyone know the process for cancelling out the work order?

5156

4 years ago

jbernardoHero (Partner)

asked in Service (Touch Apps, MWO, MRO)

PSO is overlapping calls

It seems PSO is scheduling 2 calls on top of one another when the duration and plan start times show that they cant be that close Here is the PSO ScreenPSO screenshotThe first task that was assigned was done so at 4:30PM On 8/6/20 to start on 8/7/20 @ 8:05AM. 120 Min duration At 5AM on 8/7/20 it assigned another call to the same user for 7:30AM. Even though duration is 123 minutes, PSO expects the user to complete the newly assigned task and drive to the next task within 30 mins? This has happened a few times to different users. Not all users are advising if this has happened. Any insight is apprecaited

1585

4 years ago

jbernardoHero (Partner)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

FSM Alert Business Rule - More than 1 alert

Hello, Currently we have an alert set for when a part need is entered, the alert will display the part alternatives for that original part.However, if there are 3 part alternatives, it will only show 1 Below is the business rule, how can i modify it in order to perform this?

1655

4 years ago

cjohnsonSuperhero (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS Changelog

Hello all, I’m curious to know if anyone has found a published changelog with details of what has been added/removed from IFS between updates? The log that comes with the notification contains a very general list of items moved to Aurena, etc. but there isn’t anything beyond that. I find that after we apply an update, there are a litany of items that have been added, some of which turn out to be very beneficial to our company. The issue is because there is no detailed log of what was updated/rolled out, we have no way of knowing unless we stumble upon it by accident. Thank you!

6409

4 years ago

a.georgeDo Gooder (Customer)

asked in Products (Manufacturing, Products, Engineering)

No Revision Found For Inventory Part

Hi, I have an Inventory Part but when we try to raise a Purchase order we get ‘No Revision Found For Inventory Part’This was transferred to Inventory Part form Engineering Part and is Revision 2Can anyone help Please?

10436

4 years ago

jbernardoHero (Partner)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

PSO / FSM - Assign Based on Work Status

In FSM, mobile users have an "On shift" & "Off shift" option. This is located under PERSON.WORK_STATUS.Is it possible to have PSO schedule a tech only when they're ON SHIFT and when they are OFF SHIFT it does not consider them for work?Thanks in advance,

2926

4 years ago

ctaylor56Hero (Partner)

asked in Service (Touch Apps, MWO, MRO)

Benefits of Geographical Object vs Normal Functional Object

What are the benefits of setting a functional object as a Geographical Object? Can’t I just use a functional object with a particular object level to represent a geographical area?I know Geographical Objects are used in Service Contracts but I am still unsure of their advantages and disadvantages. Thanks, Curtis Taylor

1801

4 years ago

NarsiSidekick

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Write PL/SQL functions

Hi,I’m new to IFS.I can see these lines are in Event ActionsGeneral_SYS.Init_Method(lu_name_, 'SUP_BANK_ACCT4', 'Unblock_Sup_Pay_Address', TRUE); Client_SYS.Clear_Attr(attr_);Client_SYS.Add_To_Attr('BLOCKED_FOR_USE', 'FALSE', attr_ );It seems these are system defined fuctions, If I want to understand these type of all fuctions/methods, where can I get? any docs or links or tools? Thanks,Narsi.

19757

4 years ago

ADNANSidekick

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

My OwnTheme

Hello there. I want to create a new theme for myself. The solutions I saw before did not work. I would like the simplest explanation to add a new theme. Question 2 What is FSM?What is PATH_TO_CUSTOM_THEMES ?What is GlobalThemeXaml I would like a screen shot to explain.Thank you so much.I could not understand the examples below.I want a simpler and simpler narration. https://community.ifs.com/service-fsm-touch-apps-document-management-mwo-mro-pso-43/easy-way-to-customize-ifs-fsm-theme-as-per-customer-branding-2829 https://community.ifs.com/service-fsm-touch-apps-document-management-mwo-mro-pso-43/custom-theme-3146

8835

4 years ago

SynNajamHDo Gooder (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Email Configuration and testing email in IFS Apps 10

Hi, I am trying to configure email setup from Setup IFS Connect, I have input the mail settings in MAIL_SENDER1. Now I want to test those setting, what is the procedure to test the mail settings on IFS Apps 10

22886

4 years ago

Page 440 / 468

Solved

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded