Solved

Hi All.I’m trying to migrate some data with double quotation but after load the file, the system automatic inserts double quotions before and after the record, also in the middle.is there a way to fix this?   Br.Lopes

We have created a payment method CHK and attached the CHECK payment format id for this payment method. Payment also generated in IFS for a supplier using this payment method. I would like to know if we can change the format id connected to the payment method at this point? thanks you in advance.

We are currently using APPS10 update 20We have a report rule working to generate a PDF file on a local server with an OutputFileName naming convention:INV_6302_IFS[@CUSTOMER_ORDER_IVC_REP/CUSTOMER_NO]_[@CUSTOMER_ORDER_IVC_REP/INVOICE_NO].pdfThis works perfectlyI now want to add the invoice date as a string ‘YYYYDDMM’When I try to add the field I get no error but also no output.INV_6302_IFS[@CUSTOMER_ORDER_IVC_REP/CUSTOMER_NO]_[@CUSTOMER_ORDER_IVC_REP/INVOICE_NO]_[@CUSTOMER_ORDER_IVC_REP/INVOICE_DATE].pdf Assuming this is because of the date format being pulled from the field but how do I change it. Any help appreciatedAction properties: 

Hi,With the workflow DC functionality we have the ability to use the function : data source consolidated email.What is the best way to do that with process flow ? Do we have another solution to generate and to send an Excel file by email ?For example, do you know a macro in API to simulate the export function of an excel file by email ? Thanks and Regardsanthony

Hello, I have a question related to a large stock up and I am hoping there is a way IFS can handle. I setup a large qty PO for a bank build. However, I am hoping to somehow flag that PO to be ignored by MRP, as it is unique. The issue is that this large purchase skews the forecasting/demand. I’ve gone through the help and do not see anything that seems to indicate if this scenario can be handled. Any guidance would be appreciated. Thank you.

What is the purpose of the data in the screen Project Management/Basic Data/Pricing/Internal Price on the Employee Price tab?This information is also available on Human Resources/Employee Management/Employment/Standard Costs.

Hi All,I am trying to activate an event action that send the report “Payment Advice” to an email address. But I am having a hard time getting it to work. All the parameters starting with pdf_ are blank except PDF_PARAMETER_1 and PDF_PARAMETER_2  I believe PDF_PARAMETER_1 is value in AP Supplier Contact and PDF_PARAMETER_2 is Report ID in Report Definition.I have been gone through the table in the below link but it doesn’t include how values are fetched for Payment Advice https://docs.ifs.com/ifsclouddocs/22r2/default.htm?openpage=https://docs.ifs.com/ifsclouddocs/22r2/Procurement/AboutEmailReports.htmCan someone help me out find out how the rest of values are fetched? Additionally I have tried to set value for default PDF_PARAMETER_3 using function Pdf_Report_Event_Param_API.New_Parameter after referring ifs community link but still value for PDF_PARAMETER_3 is still empty. 

One of the customers had a delivery failure (PROD) due to a DB connection issue. There weren't any issues in non-prod delivery installation. The error shows (!!!Error, no database connection exists). The customer is asking whether there are any corrective actions that could be taken in order to avoid the same error in the future for the same environment followingly other environments as well and also asking the reason for this connection timeout. 

PR authorization rules not getting fetched even after the PR auth rules are in released status. This issue started from new year.   

Dear Community, we have a big issue with a Time Clock Clockings for a Customer which went Live 4 days ago. There is an already identified Bug that we cannot use Swipe cards since Auto Resume Option of corresponding Operations in Manufacturing is not working. For this we get a Fix but unfortunately first with 23.R1.SU10. This is why we have to enter the employee Number manually or via Drop. But while using this “manual Entry” of the Employee number in Time Clock terminal we found that often Employee A is doing the Clocking but the Action will be performed on Another Employee. The Employee who left in real is then still clocked in and another is clocked out which causes a big Problems in time Cards since all booking must be checked and even cannot be found which are correct or wrong… IFS Support is already alarmed but has anybody experience with this behaviour? Thanks Stefan

I have created a custom field for MRBs that uses enumeration with two values (Internal and Customer) and set it to have a default value of Internal.However, when creating a new MRB the field does not get a default value and is instead empty.Is there something I am missing?

Today I was trying to test a technique to run a MODIFY__() PROCEDURE that will affect a bunch of Inventory Parts in order to update the Safety Lead Time Value. The code I wrote was like this. -- Use IFS API repeatedly to perform some action-- (In this case updating Safety Lead Time on Inventory Parts)DECLARE -- p0 -> __lsResult p0_ VARCHAR2(32000) := NULL; -- p1 -> __sObjid p1_ VARCHAR2(32000) := 'AAAWhqAAGAAHl+JAAO'; -- p2 -> __lsObjversion p2_ VARCHAR2(32000) := '20240110114450'; -- p3 -> __lsAttr p3_ VARCHAR2(32000) := 'SAFETY_LEAD_TIME'||chr(31)||'5'||chr(30); -- p4 -> __sAction p4_ VARCHAR2(32000) := 'DO'; sql_stmt VARCHAR2(1024); tbl_count number;BEGIN FOR inventory_part_to_update_rec IN ( SELECT INVENTORY_PART_PLANNING.PART_NO, INVENTORY_PART_PLANNING.OBJID, INVENTORY_PART_PLANNING.OBJVERSION FROM PRD_08 INNER JOIN INVENTORY_PART_PLANNING ON PRD_08.PART_NO = INVENTORY_PART_PLANNING.PART_NO WHERE

Does anyone know what the function is for these two fields? 

Hi Everyone,We’ve run into an issue after deploying a ‘utility model’ to our database using IFS Developer Studio and the ‘Generate Code and Deploy’ action. We followed that up with a ‘Refresh Dictionary Cache’ actions. We deployed this way to our DEV environment without issue but we are running into problems in our QA environment. After deploying our code we start to get errors when we attempt to create orders in our system using a custom API that was created for us. The code that we deployed is unrelated to this custom API and should not impact it’s functioning in any way:ORA-04061: existing state of has been invalidatedORA-04061: existing state of package "IFSAPP.C_CPQ_CUST_ORDER_UTIL_API" has been invalidatedORA-04065: not executed, altered or dropped package "IFSAPP.C_CPQ_CUST_ORDER_UTIL_API"ORA-06508: PL/SQL: could not find program unit being called: "IFSAPP.C_CPQ_CUST_ORDER_UTIL_API"ORA-06512: at line 1ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 1831ORA-06512: at "IFSAPP.TRANSA

Hi,I'm currently trying to add new command to the Suppliers page, which leads to SQL quick report based on this entity. I need the quick report to run just on the selected suppliers. Is there a way to do it? There is a possibility to add parameter when creating the command, but I cannot figure out how to make it work.Adding SQL Quick report command parameterI believe that selection should be based on SupplierId from the selected supplier(s). So I put it into the “Context value” on the right. But what should go into “Destination Attribute field?Also - is there necessary WHERE clause in the Quick Report SQL statement, or should I leave it without it? 

Hi allHas anyone been in a similar position to us & found a better solution ? ScenarioAll our raw material safety data sheets (SDS) are in IFS (APPS10 UPD18), stored in the db as PDF files.If there was an incident, eg someone spills a potentially hazardous product, the first aiders will need quick & easy access to the relevant SDS. Where are we now ?We have a custom shortcut that launches the general search function, with DocumentContent pre-selected as a search domain This works fine. You can search for, say “acid” and IFS will provide sensible results. the only snag is that when you click on a  result, you go to the document revision page.There’s a further click required to actually get to the document itself.While this works, the objective from the start was to make this process as easy and intuitive as possible. It feels like we haven’t achieved that goal. Is there a trick we’ve missed ? Thanks  

I’m trying to set a default value for the Supplier Invoice Consideration list on the Inventory Part Page using BPA.  The BPA is able to set the note to Ignore Invoice Price, but is not able to put that value in the Supplier Invoice consideration When adding execution.setVariable('InvoiceConsideration', 'Ignore Invoice Price');and the variable in the ExportValue Section I get the following error  InventoryPart/Form (server error)Error while serializing contents. see file (serializingBPA)  the field is present in the REST CALL response : ….    "TechnicalCoordinatorId": null,    "InvoiceConsideration@odata.type": "#IfsApp.InventoryPartHandling.InvoiceConsideration",    "InvoiceConsideration": null,    "MaxActualCostUpdate@odata.type": "#Decimal",    "MaxActualCostUpdate": null,….see file (defaultPartResponse.txt) Thnak’s in advance for your help

Hi,The issue we have happen regularly (once every one or two months) on one of our customer (V15.1) . The production environment is down and need to be restarted. Each time we have this error message on the servers : Astea.AO.WDLReflectorHelper.IsAPIWrapperService failed Unable to cast object of type 'System.String' to type 'System.Xml.XmlNode'.StackTrace:    at Astea.AO.WSDLReflector.0(String A_0) Have you already encounter this errror message ? THanks for your feedbackRGdsChristophe

Hi,During testing I implemented some conditional formatting which produced an error.The only actions available are "reload", "details" or "go to home page".How do I reset this setting.To resolve it, I deleted the user and recreated it. (not a good solution)Kind regards.Mickael CORMIER

What is GL structure in project reporting and invoicing ?and what is meaning by code part function PRRAC is not used  

Hi all,  My client has implemented purchase order authorization with 3 steps. I would like to know if step 3 is refused, how is it possible to revoke all authorization for the buyer to change his purchase order? For now, I can see that if step 1 was authorized by one user and step 2 by another user, the user of step 3 cannot revoke previous steps. Laura

Has anyone used Windows 2022 CORE for the Installation and Management Server?  Can anyone recommend Desktop over Core for this server?

Hi Experts, We have a customer where we need to hide a tab information with the status in MWO. For an Example:when status is “accepted” it needs to be shown only task information when status is “waiting at location” it needs to be shown only task information and assignment information Could you please let me know how can we configure this and where we can we configure this Thanks,Hesh.

Hi,I’m trying to create our permission set for our MWO users and I am having a hard time identifying the projection required to display the tiles. Does anyone know what’s required?Thanks,Rob

Hi all, For a client we’re trying to set up a Delivery Route linked to our internal customers with two departures per day. The Business Requirement is to have a shuttle leaving in the morning and in the afternoon. This shuttle will leave from the logistics warehouse and deliver to a route of internal production sites. We have created the following Delivery Route for this:IFS > Delivery RouteThis Route was attached to all internal customers on the address level. When creating a CO the route is automatically filled in the Order Details. When adding a CO Line, the Planned Ship/Date should change according to the Wanted Delivery Date and pick the departure in the morning or in the afternoon. The Planned Delivery Period should then fetch this information in order to display a period linked to the assigned calendar (Site or Customer level).The problem is that the Planned Ship/Date always picks the departure route in the morning. Has anyone worked with multiple deliveries per day yet in th