Solved

We have need to calculate the number of hours between 2 dates, minus weekends. We’re using the OrderHistory tab’s rows.I have it working for just the number of days between 2 dates, and then did it for the number of hours (I simply removed TRUNC() around the 2 dates).But that included weekends and now the team wants just business days. I was able find a solution for 2 dates, but it doesn’t include the hours.I’m thinking the solution is to add HH24:MM:SS to the to_date() function but am receiving errors.How do I format to_date() to include hours in the calculation? SELECTSite,OrderNo,status,lag_status,dt,lag_dt,TO_CHAR(to_date(dt,'YYYY/MM/DD'),'DY','nls_date_language=english') as DT_DAY,TO_CHAR(to_date(lag_dt,'YYYY/MM/DD'),'DY','nls_date_language=english') as LAG_DT_DAY, (to_date(dt,'YYYY/MM/DD') - to_date(lag_dt,'YYYY/MM/DD') ) - ((((TRUNC(to_date(dt,'YYYY/MM/DD'),'D'))-(TRUNC(to_date(lag_dt,'YYYY/MM/DD'),'D')))/7)*2) - (CASE WHEN TO_CHAR(to_date(lag_dt,'YYYY/MM/DD'),'DY','nls_date_

Hello, I have noticed an issue with existing Sales Parts and I am unsure of the correct way to apply a % increase to the price. Initially, I assumed I could use the contribution margin on a Sales Quotation to accomplish this, however, if the part is existing in your system, that is calculated automatically. The scenario below outlines the issue I am facing:Existing part number XYZ has a Cost of $4.55 and a Price of $18.35 The system calculated Contribution Margin rate is 75.17% The customer has contacted us and stated they want 255 XYZ parts expedited and they would like to see a quote for this. We would like to add 20% to the price of the part for the expediting.  Our Sales team created a quote and modified the contribution margin. They changed it to 20%, which dramatically lowered the price.Modifying the CM does not appear to be the correct method to markup a price of an existing part in this instance.Is there a function in IFS that would accommodate this scenario? Any help would be

Hi, We have had a number of invoices created in the last couple of months with the incorrect due date, this was due to the reduced number of days in Feb skewing the system calculation which has now been fixed. Would it be possible to do a mass change of due dates of invoices in question. I have ran a debug whilst testing the due date amendment and found as expected that this can only be done when the Invoice is in ‘Preliminary’ status.  Most/if not all of the invoices are in ‘PostedAuth’ status. I am thinking that we could possibly achieve this using RMB > Customer Instalment Plan and DiscountsABSTRACT_PAYMENT_PLAN_API.MODIFY__ Would this work? John

Is there any way to show Yes/No dialog box in a custom event and perform operation based on user’s response? 

Within the HANDLING_UNIT_SHIPMENT (Shipment > Handling Unit Structure > Handling Units) there is a field MANUAL_GROSS_WEIGHT and we have created a custom field CF$_MANUAL_NET_WEIGHT The user will enter the Manual Gross Weight and the custom field Manual Net Weight values.    On saving the record we would like the custom event to check the custom field Manual Net Weight value against the Manual Gross Weight and if it is greater than or equal to the Manual Gross Weight then an error message must be displayed:If the Manual Gross Weight already exists and the user only enters the custom field Manual Net Weight then there is no issues.  DECLARE manual_gross_weight_ NUMBER;PRAGMA AUTONOMOUS_TRANSACTION;CURSOR get_data IS SELECT manual_gross_weight FROM HANDLING_UNIT_CFV  WHERE objkey = '&NEW:ROWKEY' ;BEGINOPEN get_data;FETCH get_data INTO manual_gross_weight_;CLOSE get_data;IF  '&NEW:CF$_MANUAL_NET_WEIGHT' >= manual_gross_weight_ THEN Error_SYS.Record_General('HandlingUnitHi

Hi All,I have installed the Business Reporter add-in but its not showing on excel menu?Any idea?  

Hi, We have users who can’t login to the application because they are getting the error message:“IFS account is already logged in by EXAMPLEDOMAIN\RANDOM.USERNAME. Contact your system administrator!.” But we can’t find their session against the database by looking at Solution Manager - Monitoring - Database Sessions.And we have also tried to query the views:fnd_session_runtimev$sessiongv$session They have tried to restart their machines and it still happens from another machine too. Thanks in advance!

Hello, I’ve created an element for purchase requisition lines awaiting approval and it displays the lines correctly the user needs to authorize.  In Aurena I have it working where you can click on the line and open the purchase requisition screen but I’m running into difficulty with clicking on one of the lines and opening the IEE Purchase Requisition screen so they can look at the entire requisition.  Any guidance would be appreciated. Reqards,William Klotz

Hello, There is a reason in Spain (Europe) for having a Tax Code for Purchases and other for Sales?Is it possible to have the same 21% for both, for example. Thanks.

Hi,If the Shop Order has a Weighted Average component, you can’t Cancel it even after revers all the transactions and perform Transfer Inventory Transactions. Feels like the correct functionality due to revaluations happening with Weighted Average components each time when cost is changed.But would like to know the real logic behind this.Cheers,Aan

The IRS has added an new tax form 1099-NEC.  We need to get this new form and understand how to set up IFS to get supplier income to report on the correct for and in the correct box.  Current functionality only allows for one 1099-Misc form. Going forward we will need 2 forms, 1099-MISC and 1099-NEC. Has anyone us run into this yet? This would be for Apps 9 and Apps 10 as we are planning to finish our upgrade soon. 

Hello allHappy New Year to all of youWe have just switched to IFS Apps10. Now we found the following problem in Document Management - Approval Routing.An Approval Step assigned to a user who is not yet in the access schema of the DocIssue. Now he is automatically added by IFS with view rights in the access schema. If this user now wants to approve his step, the message appears that he is not authorized to approve. I have to give the user admin rights so that he can approve the step.In the Solution Manager the security checkpoints for the approvals are activated. However, they are not selected for DocApprovals.In IFS7.5 the approval could be done with view rights without any problems.Have any of you had the same or a similar experience and what can be done against it?Where can this be configured / set?Thanks for your supportPeter

Dear All,IEE Version: IFS Application Version 10 Update 7I am looking for a functionality on work assignment to track time in two below scenarios. My customer is from service management background:Customer personnal (employees) are working in morning shift (6AM to 6 PM) and night shift (6PM to 6 AM) with 12 hours duration each. When work task duration is for more than a day multiple work assignments get created based on HR Schedules. We have status - assigned, accepted, start travel (onroute), waiting at location, work started, pauses and work completion for work assignments currently in standard application. Customer wants to track additional statuses for handover of work between the shift personals at the end of shift and want to track the status for travel back on the work assignments. Is there a way to do that ? For morning shift personal if the work is scheduled to start at 6 AM at customer’s client location then he will start planning work at say 4 AM (planning for necessary tool

 Hi All, I’m not sure how this functionality works?What is the purpose of ClickOnce ? Hope anyone can shed some light. Thanks! 

Hi, When I try to add a Custom Field to the tab ‘Charges’ on the Purchase Order I get this Error: What do I need to do to solve this?

Hi,It did a few months since I am in IFS world. We are working with a third-party company to put in place a transaction site, all transactions must enter to IFS, and one problem we are having is that we need to create the customer in IFS once the transaction finalized. I found all documentation and I didn’t find any BizAPI to create customers. Does anyone know how to do this? I try to find documentation explain how to create a webservice on IFS but I didn’t find it.Thanks,

Instead of the DN-XL constant value, I need to get the technical class code of each part.What is your suggestion?object_connection_transformationpart technical class DN-XLpart technical class DN-AS-NThanks..

Hi all, I’m trying to connect to IFS Business Reporter but not sure how to enter the connect string? Any idea?  Thanks!

I want to make the REST API token from IFS 10 is longer than 3600s. How can I change that value?

HelloOur company has the practice of creating a group email to use in the Custom Event type email to send email to multiple users at once.I tried and successfully send email to two users separated by comma.Question is 1- how many email id’s can we use  separated by commas in this case. Is there any upper limit to send email notifications thru this method2- Any Pro’s and Con’s of this approach, if any. or its best practice to have group email id IFS8: 

Curious to know what are the major changes on the way how PO Charges are distributed in App10 compared to older versions?

We have a situation where a customer was cash in advance but they are now being granted terms. We entered in a couple of orders and created and posted Advanced Invoices, we cannot release the orders now due to the advanced invoices. Is there a way to cancel advanced invoices? 

I am setting up a new report in the same location as my other Operational reports but get the following error.  How do I resolve this? The Report layout file AgrShopOrderPrint_test.rpt does not exist in the Crystal Web Service

We’re on APPS10 UP6.   I’ve configured the IFS History Log to show changes to a specific field on the inventory Part.  The logging works and as an administrator I can see all changes,  but when a user on the Inventory Part does View - Record History  they can only see the changes they made not the field changes that another user made.  To me that defeats the purpose of the Record History - to see who changed a field and to what value.  If I set system Privilege = Administrator in their Role, then they can see changes from all users.  But we don’t want to give Administrator Access to any users.   Is this by design or is there a setting in the Roles that allow this action without setting as Administrator?   I’ve tried to give access through the role but can’t get it to work. 

this is running FSM 5.7it seems that the service history for request and tasks is delayed in getting to the mobile platformi already checked the sync rules and it happens as a BATCH ALL at 9 PM every night. Nothing has been touched from the OOTB integration. For example i am looking at a request that was closed 10 days ago yet still doesn't show on the mobile platform.However when i initialize the history is immediately there.How can i fix this so that it shows up at least on the daily sync?