Skip to main content

Solved

13017 Topics
H
Sidekick (Customer)
HousseinySidekick (Customer)
asked in Finance (Financials)
SQL query error when trying to reuse calculated field

HiI got an error with the below  line in red when execute. Any clues please. select X.*,IFSAPP.SUB_PROJECT_API.Get_Description(x.PROJECT_ID, x.SUB_PROJECT_ID) Sub_Proj_Des,x.budget_base_curr/120 ITD_BUD,x.actual - ITD_BUD as  "Deviation",IFSAPP.ACTIVITY_API.Get_Description(X.ACTIVITY_SEQ) activity_des,IFSAPP.Project_Forecast_Item_API.Get_Project_Cost_Element_Desc(x.FORECAST_ID, x.PROJECT_COST_ELEMENT) cost_elm_desfromproject_forecast_item_all Xwhere project_id = '20062' and forecast_version_id = 'M1003' RegardsHousseiny 

1372
H
Sidekick (Customer)
Edie
Sidekick (Partner)
EdieSidekick (Partner)
asked in Assets (Asset Management)
Prepare work order - Coordinator on customer information tab

For a single user the coordinator is not auto-populating. In the prepare work order screen, CO information tab, the coordinator does not fill in automatically.  The default coordinator is setup for the user on site.

2655
Edie
Sidekick (Partner)
N
Do Gooder (Partner)
neville.eliasDo Gooder (Partner)
asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)
FSM IQA in web client

Hello, The IQA button does not appear on the web client. It seems like the functionality is limited to the Smart Client. I am using release 6 and update 23. There are a couple of FSM client scripts that hide the IQA button (REPAIRCENTER_HIDE_IQA and REQUEST_HIDE_BUTTONS).Is there any chance of this functionality being made available in the web client going forward?  ThanksRegardsNeville

913
N
Do Gooder (Partner)
B
Superhero (Customer)
bdoucetteSuperhero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
How to automatically close a Business Opportunity when expiration date gets hit

Hello, I am attempting to have Business Opportunities automatically close when it passes their expiration date. I have used workflows and scheduled database tasks before, but there does not seem to be a way to create a database task to schedule it to run every day to check for expired Business Opportunities, and there does not seem to be a way to schedule a workflow to run every day. I’m not aware of any projection actions or event actions that get run every day.What can I use to achieve what I’m looking for? Any and all advise would be greatly appreciated.Thanks,Bryan

1589
Mathias Dahl
Superhero (Employee)
M
Do Gooder (Customer)
mancelticDo Gooder (Customer)
asked in assyst General
Mobile app critical incident alerts/notifications

Has anyone come up with good ways to enable alerts/notifications using the IFS Assyst Mobile App?We have support personal who want to be alerted especially during off hours whenever a high priority incident or outage occurs. So, we want a push notification not simply that they check email on a regular Candance. 

711
C
Hero (Employee)
B
Superhero (Customer)
bdoucetteSuperhero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Is it possible to use FND_WORKFLOW_CONNECTION_API.START_WORKFLOW to trigger a workflow?

Hello, I am attempting to trigger a workflow via a database task, so that I can schedule the database task to run daily. My end goal is to have a workflow that gets triggered every day. It does not need parameters.Is this possible with FND_WORKFLOW_CONNECTION_API.START_WORKFLOW? I am creating a database task to use this method. I am not sure what it’s asking for, for its parameters. Would anyone be so kind to provide an example of the formatting this is expecting?Any and all advise would be greatly appreciatedThanks,Bryan

1501
B
Superhero (Customer)
D
Do Gooder (Customer)
dmntrnrDo Gooder (Customer)
asked in assyst General
IFS assyst Survey Error

I am trying to set up a survey in IFS assyst using an event query. When I run the query in event monitor, it returns a list of events, with then Affected user field populated.When I add the query to the survey, and click on Issue Request, i receive an error “Event Query returns no users.”Am I missing something? 

751
C
Hero (Employee)
B
Superhero (Customer)
bdoucetteSuperhero (Customer)
asked in Distribution (CRM, Commerce)
Auto close Business Opportunity

Hello, How can you get Business Opportunities to automatically close once their expiration date is equal to the current date? This seems like a pretty basic feature but there doesn’t seem to be any options available on IFS Cloud

611
B
Superhero (Customer)
B
Superhero (Customer)
bdoucetteSuperhero (Customer)
asked in Supply Chain
How to email customer when Business Opportunity expires?

Hello,How would you set up emailing to notify a customer when a Business Opportunity or Sales Quotation has expired? Any and all advise would be greatly appreciated. Thanks,Bryan

731
B
Superhero (Customer)
B
Superhero (Customer)
bdoucetteSuperhero (Customer)
asked in Distribution (CRM, Commerce)
What is the purpose of the expiration date for Business Opportunities?

Hello,What is the purpose of the expiration date for Business Opportunities? Do they auto close once they go past the expiration date? if not, how do I get them to automatically do this? I have a scheduled database task that uses the “Set_Closed” method of the Business Opportunity API but I cannot set this to only occur when the Expiration date = SYSDATE. This results in an error that makes IFS think the opportunity is already deleted, because its not coming up with a result. Any and all advise would be greatly appreciated.Thanks,Bryan

771
B
Superhero (Customer)
B
Superhero (Customer)
bdoucetteSuperhero (Customer)
asked in Distribution (CRM, Commerce)
How to email customer that their Business Opportunity is going to/has expired?

Hello,I would like to set up a process that notifies the customer that their Business Opportunity is going to expire in a week, 5 days, 3 days, and when the BO has actually expired. I can set up an event action to handle when a field has changed… so I’m thinking about having a daily database task that updates a custom field that represents how many days until this BO expires, and basing the event off of that.My only issue is the email portion, for the Business Opportunity, the contact email is not available for the entity. How can I set this up so that field appears on the BO? Obviously IFS has the entity connection set up since the Contacts appear on the BO page, but I cannot access that BusinessObjectContact entity from the BO entity, to add in a custom field that references the email.How should I approach this? Any and all advise would be greatly appreciated.Thanks,Bryan 

1251
B
Superhero (Customer)
B
Superhero (Customer)
bdoucetteSuperhero (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
How to execute a workflow via a database task?

Hello,I’ve been looking for so many ways to execute a workflow on a daily schedule for IFS Cloud. There have been some IFS Employees that have mentioned that they don’t know how to, but I still want to believe there is a way to do this. I am trying to close expired Business Opportunities and Sales Quotations by running a workflow I built. I also would like to send an email out when Sales Quotations and Business Opportunities are 7, 5, or 3 days away from expiring.Is there any way to accomplish this? It seems like IFS Cloud is so limited in what you can do. In Apps10 you had some workarounds for accomplishing this but it seems like there is no way to do this in IFS Cloud. Any and all advise would be greatly appreciated. Thanks,Bryan

2591
B
Superhero (Customer)
M
Hero (Partner)
MitDenukN
asked in Document Management (DocMan)
Add Purchase Order Attachments to the Same Email , When Print Order

Hello Everyone, There is a requirement to send Attachments  with the same email of the Purchase Order’s Print Order...The mail should contain the attachments of the Purchase Order as well as the Purchase Order report.This should be happen only if the attachments are in specific document classes eg: 4600 - 4699.This should be work in Aurena as well. Please let me know if you have any idea of how to do this.  Many Thanks,Denuka

181910
Jonas Feigl
Superhero (Employee)
eqbstal
Superhero (Partner)
eqbstalSuperhero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
mWO Page Designer Content missing

I have done some changes to the list of my work for mWO in the past. I made the changes in the context global (understood: discussable). Now I want to make another change and there is no content available:Three dots below Content show the Order by option, which has a grey > sign which means nothing there as well.I do have a page configuration that is published: I see the work done, in the past, in mWO. If I unpublish the global context I see the standard overview in mWO on the MyWork page.Anyone an idea why I don't see any content?

961
eqbstal
Superhero (Partner)
S
Do Gooder
shewaDo Gooder
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Command Group in Aurena

Hi,I have added Command Group in Automatic Tax Proposal projection to generate a report. When executing the action, it is giving an error saying “14:24:04 ERROR - line 2, column 2: (Server Error) Database error occurred. Contact administrator. undefined14:24:04 ERROR - Command error: (line 2, column 2) - , details: undefined undefined”Method has two parameters and values are passing correctly. To make sure parameters are not causing the error, I created a test method without parameters and attached to Custom Group. It is still giving the same error.Any suggestion to rectify the issue is appreciated.(custom RMB created in EE works fine with the same method)Thank you.

6876
Yehan Opatha
Do Gooder (Partner)
L
Sidekick (Customer)
lisa.gilesABSidekick (Customer)
asked in Assets (Asset Management)
Service Quotations

What does this mean? We have created the Quotation, updated all the Work Orders and Task Information, calculated the costs etc. but when trying to Release the Quotation this is appearing? Thanks, 

5322
Dilini Arandara
Superhero (Employee)
Máté Kubicsek
Sidekick (Customer)
Máté KubicsekSidekick (Customer)
asked in Finance (Financials)
How to add message to tax code / how to change it

Hi IFS community, We would like to add a small message to the tax code so it would appear on the customer invoice which we create via Instant Invoice tab.How is it done? Please see the picture below to see what I am talking about. Thank you in advance. 

1402
R
Hero (Customer)
lopespetro
Hero (Customer)
lopespetroHero (Customer)
asked in Service (Touch Apps, MWO, MRO)
Change sort field MWO Maintenance 10 All Object

Hi All.Does anyone know how to change this sort to MchCode asc, not Mchname?Using Apps10UPD17 MWO Maintenance 10There is no option to change the field.Tried to add another Orderby item but it’s not working.Tks.Br.Lopes

361
lopespetro
Hero (Customer)
P
Do Gooder (Customer)
pramodka46Do Gooder (Customer)
asked in Buying (Procurement, Demand Planner, ASC, SRM)
supplier material tracking

Hi, I am looking for any best solution for below case. ( mapping in IFS)we place PO to supplier A ( 10 m, bar) and asked to delivered to supplier B location.we place PO to supplier B ( supplier B uses the 4m bar , supplied by us from supplier A and deliver the final material)  ( remaining 6, bar will be lying in supplier B place and uses in next PO). how we can track material locations/ remaining qty/paper work - sending material from supplier A to supplier B)Thanks

2732
Vimukthi Mahakumbura
Superhero (Customer)
K
Do Gooder (Customer)
KevinLachDo Gooder (Customer)
asked in Supply Chain
Purchase Order Not Being Automatically Created

Hello,We’ve changed some of our parts to be Primary Supplier Transit on their Sales Part Record. We have Customer Orders currently in the Planned state that contain these parts. I had assumed that if I change the Supply Code of these parts on the Customer Order to be Purch Order Trans, that their PO’s would be automatically created when the job was released. I’m finding that this is not the case. Automatic PO creation was working in our TEST environment if I created a new Customer Order with the changed parts on them and then released the Customer Order. The automatic PO creation just doesn’t seem to be working on Customer Orders that were already created before the parts’ Sales Part sourcing option was changed. Anybody have any ideas?

4556
K
Do Gooder (Customer)
T
Do Gooder (Customer)
ThuveDo Gooder (Customer)
asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)
Development status for FSM in IFS Cloud?

During the Cloud Launch in 2021, Stephen Jeffs-Watts did a presentation of the future plans for FSM in IFS Cloud.https://info.ifs.com/cloud-launch-on-demand-videos.html?_ga=2.18333948.478674707.1616167306-1371162318.1616167306&wchannelid=h0gd1m5rp6&wmediaid=otkpwg9w5d#ValueAs the final stages of development, Depot repair and Reverse logistics was scheduled for Cloud 22R2. What is the present status?  (Se presentation: 3:25 – 7:00)

2432
S
Do Gooder (Employee)
angelodisi
Sidekick (Customer)
angelodisiSidekick (Customer)
asked in Products (Manufacturing, Products, Engineering)
Purchase Order Close when order qty changed

Hello,Checking if this is correct in our version IFSAPP9.The PO order quantity was reduced manually by the buyer after partial receipt to match the quantity received, but neither the PO header nor the line item closed automatically. Both had to be closed manually by the manager.Is it because of the manual change in the PO qty after the receipt?Normally, for us, when the quantity received is equal to the PO quantity, the PO line and the header closes automatically. Angelo DiSipio

1172
angelodisi
Sidekick (Customer)
H
Sidekick (Customer)
HousseinySidekick (Customer)
asked in Finance (Financials)
How to retrieve SQL columns having API in SQL query

Hi,    I am working on a SQL query related to  view PROJECT_FORECAST_ITEM_COST. When opening the project forecast, there is a SQL column address as “&AO.SUB_PROJECT_API.Get_Description(PROJECT_ID,SUB_PROJECT_ID)”. How do I include this column in my SQL query with PROJECT_FORECAST_ITEM_COST table?I would like to understand how API works in general as well when it comes to SQL queries.  Many thanksHousseiny

3156
H
Sidekick (Customer)
I
Do Gooder (Partner)
IniVismiMDo Gooder (Partner)
asked in Finance (Financials)
Business Reporter-Sum of closing balance of previous month and Current month closing balance

Hi All,Can anyone support me on how  to get sum of last month closing balance and current month closing balance to one column in Business Reporter.Thank You 

1994
I
Do Gooder (Partner)
ERPMark1
Do Gooder (Partner)
ERPMark1Do Gooder (Partner)
asked in Buying (Procurement, Demand Planner, ASC, SRM)
Project Supply Request Authorization rule not showing steps

Hi There,I have created a Purchase requisition authorization rule and routing templates, and for some reason all my routing steps are not being displayed on the requisition or routed as per the steps. I’m at a loss for what I may have missed. What could I be missing that I am not seeing by chance?I have been under the assumption all steps will show especially if I have “Include All Steps and Consider Limits” selected on the auth. Rule general tab. Auth. Rule 1 - Priority 1 <$500k - Maximum amount $500kRouting template linked to auth. Rule 1, using project roles, all with auth. limit of $500kStep 10 Step 20 Step 30 Auth. Rule 2 - Priority 2 >$500k - Min $501k to Maximum amount $10mlRouting Template linked to auth. rule, using auth. groups, all have max auth. limit of $10mlStep 40Step 50 Once the requisition is released only the following steps appear when I need all the steps 10-50 to appear (Screen shot below)Step 30Step 40Step 50  

1545
ERPMark1
Do Gooder (Partner)

Badges

  • 5th Reply
    LakshmiVhas earned the badge 5th Reply
  • 10th Reply
    VirajWhas earned the badge 10th Reply
  • 10th Topic
    Abdulhas earned the badge 10th Topic
  • 1st Reply
    BCRJWILSONhas earned the badge 1st Reply
  • 1st Reply
    FRFIBRhas earned the badge 1st Reply
Show all badges
Terms & ConditionsCookie settings