Solved

Hi, I have an application-server-task setup for job-type = ‘QuickReport’. When the I runt the task, the generated excel file tell error: “SQL Statement malformed:     [..select statement in quick report..]”   Executing the quick report manually doesn’t have any error.   Does anybody know about this error and how to handle it?   The QR-sql-statement:     SELECT job_id,        state,        t.description,        procedure_name,        t.queue_id,        B.DESCRIPTION, B.PROCESS_NUMBER, B.EXECUTION_PLAN,        arguments_string,        LAG (executed,1) OVER (PARTITION BY t.queue_id ORDER BY started) prev_job_executed,        (started - (LAG (executed,1) OVER (PARTITION BY t.queue_id ORDER BY created)))*24*60*60  time_since_prev_job_executed,        (started-posted)*24*60*60 wait_for_start,        (executed-started)*24*60*60 exec_time,        posted,        created,        started,        executed,        error_text,        username,        t.lang_code,        progress_info,      

Hi , I just created a work flow, and inside it , I would like to call a Projection like this: As you can see, I need pass the “Objkey” to VirtualSet  inside the URL,while, in work flow there is no way to pass parameter to a VirtualSet I passed Objkey , but it failed to call.

Hi, everybodyI want to select the MUSTERI_ADI filter as on the customer screen.While the Department_Id filter works as I want, MUSTERI_ADI filter does not work as I want.Department screen is basic data, maybe that's why the screen appears like that on the filter.

Does anyone have experience modifying the B2B portal so that the documents in the preliminary state are also displayed there?

Hi,Can someone advise how to add the filter $Select using the IFS Projection object?  Thank you

HiI have a quick report like thatbut I can not entry more then 1 value on and ifsapp.report_sys.Parse_Parameter(p.accounting_group,'&mg')='TRUE'part, can someone help meSELECT i.CONTRACT,       i.YEAR,       i.period,       i.PART_NO,       p.description,       p.unit_meas,       p.accounting_group,       accounting_group_api.Get_Description(p.accounting_group) acc_group_tanim,       p.part_product_code asset_class,       sum(i.db_devir_tutar)              db_devir_tutar,       SUM(i.satinalma_giris_tutar)       satinalma_giris_tutar,       SUM(i.satinalma_iadesi_tutar)      satinalma_iadesi_tutar,       SUM(i.uretimde_cikis_tutar)        uretimde_cikis_tutar,       SUM(i.uretimden_giris_tutar)       uretimden_giris_tutar,       SUM(i.satis_tutar)                 satis_tutar,       SUM(i.satistan_iade_tutar)         satistan_iade_tutar,       SUM(i.ic_kullanim_cikislari_tutar) ic_kullanim_cikislari_tutar,       SUM(i.hurda_cikisi_tutar)          hurda_cikisi_tutar,       SUM(i.faso

Hi All, Anyone know on how to change default date format on IFS Cloud. Because the date format is not the same with PC local date format, causing confusion when reading date 03/01/2024 is 3rd January or 1st March of 2024. Have been looking around for solution, but found no answer.  Thanks.

Hello,Is it possible to restrict auto generation of Employee ID per company? This is needed only for some companies and not a system wide change.Thanks,Noel

I want to be able to issue Standard Inventory to a Project Demand.  In several areas, there are references to a command referred to as Net Project Material.  Which is, as I understand and remember it, is a way to reserver standard inventory to a project.  The About section on Project Inventory has the sentence: Project-pegged demands can usually be configured to use either standard or project inventory.We also have this in the Execute Project Miscellaneous Demand process description and it refers to the part being a standard planned itemA material or part can either be standard or project-specific. If the part is a standard planned item, the demand for it will be seen by standard MRP and order point calculations. The part can also be reserved or issued from standard inventory if there is quantity available.I’m looking for some guidance on how to set this up and uses the system to Net the material from standard inventory to a project or to have the demand use standard inventory.Thank yo

Dear All,i have a question for experts,why we can not add custom field for this viewview name:&AO.TRYPE_ALL_VOUCHER_QRYview screen below: look at the screen, lu is not automatically filled here and the + symbol does not appear  

In App 10, the transaction end date and end time are incorrectly shown as 12:00:00 AM the next day. However, the chargeable transaction days are 2, so the ideal transaction end date should be 3/1/2024 at 11:59:59 PM.In App 8, the transaction end date and time are correctly shown, which then tallies with the transaction chargeable days.FYI – The Period Rounding column is set to “Daily Rounding” in both App 10 and App 8.Is there a setting we can change in App 10 to make it display like App 8, or is this a bug?

Sometimes it happens to my customer that they receive invoices they would like to include in the acquisition value (and depreciation base) after they have activated and depreciated an object for a period of time. They normally process those additional invoices as “additional investments”. The problem we have is that subsequent depreciation is not taking into account that the remaining life time is shorter. This leads to a lump sum depreciation an the end of life. My customer would like to depreciate the original acquisition value + additional value - accumulated depreciation evenly over the remaing life time.Any help highly appreciated.Example:Acquisition value: 12000Life: 1 yearAdditional investment after two months of depreciation: 6000 

I wonder if anyone could please help me figure out if there is a way to change the rate of depreciation for a fixed asset object that has been depreciated (straight line) for a period of time. See examples below.Please note that after the break-point I would like the object to be depreciated with equal amounts every period and end up at 0 precisely at end of life. Thanks in advance! 

hellowhere in IFS we can setup the period taken for calculating average inventory price? 

Hi Community,After a fresh installation of IFS 10 I start to install UPD 17. While instilling i got below error on installation window.IFS_HOME\repository\server\install_fndmws.xml:265: Failed to configure Middleware Server. Error is: Error when creating IFS Middleware Domain.null @org.python.core.Py.JavaError(Py.java:368)Configuring IFS PSO Integration 1.0Configuring Documentation after the installation completed with errors then canst start the environment also can't run re-configuration.Even when i start the node manager service still can't run re-configuration.

Hello, I’m trying to delete a sales district , but I get this error message : I don’t know how to delete it in the customer order line , I can’t see any district column in the lines.I’ve already deleted the ones in the header thanks to this tab :  PS : I don’t have the possibility to delete directly in the database. Thank you in advance,Hanane

Hi,I am trying to to invoke a REST endpoint using OAuth Client credentials in IFSAPP10. But it ends up with a 401 Unauthorized access error.It works in Postman for the below configurations. Does anyone have an idea of what I am missing? Or anything else that I could check to figure out what is going wrong? Any help is much appreciated. Thank you

Hi All , What would be the best possible was to delete a warehouse.Tried removing the items but get the below 

HelloI am adding a Standard Parameter with the ability to input multiple values into a BR report.  I can run the report when I input 9 values as shown below, but when I input a 10th value the report will not run - I get the dreaded ‘Microsoft Excel is waiting for another application to complete and OLE action’ message.  This seems odd - any input on whether there is some kind of a limit to multiple values in a parameter?  

I created a custom function within PL/SQL to calculate the number of business days between two dates, based on a particular IFS calendar. I’d like to use this in an IAL Object, but I’m getting an error that it is not-defined. How do I appropriately define it so the IAL Object will deploy without error? We are on IE 10.

In Sum Query the Cancelled Operations Duration not showing as a negative value.  Eg - Time clocked 71.50 Transaction LABOR_IND71.50 UNLAB_IND Transaction to cancel reporting of Indirect Labour TimeWhen I sum the Indirect Hours it is adding 2 x 71.50 , not +71.50 and -71.50 

Hey,As a European, it is very annoying to see the dates in the following US format:Is there a way to adjust the default date format as it appears to me? For example I’d like to have 2016-05-07instead of7/5/2016.I have tried to change the languages and things, but that doesn’t help much because I don’t want my IFS in another language, just the date format to change.

Hi All,This is for an APP10 IFS  application and I’m new to Demand plan server and DP client installations.Would it be possible to know how to make sure the Demand Plan Server is working fine, please?If I hover on the icon, I can see it as started.I don’t see the DP windows service in services window, is there a separate process that I need to follow to get that service, please.Thank you in Advance!

Anyone ever get a 404 error when attempting to use one of the IFS MWO Aurena Native clients?  I launch the app, enter URL and System ID and click connect.  I get the apps 10 login page and enter my username and password.  After I click login there it goes back to mwo and says an error has occurred.  404:   That’s it.   System log on touch app shows my click sign-in so I am a bit stumped here.

Is there a background job or property setting that will automatically set a Work Task's Status to FINISH when: all its Assignments are COMPLETE or CANCELLED and  all its Costs are either AUTHORIZED or TRANSFERRED?Thank you,