This will include the questions related to CRM and Commerce.
Recently active
When we export information from an IFS window (ie. Customer Order Lines) the information is exported in to Excel with a format of General. Unfortunately, it drops the zeros off the front of our customer numbers. Right now our work around is it export the information to a txt file, then use Excel’s “Get Data” functionality to convert the cells from General to Text format.Is there a set-up available that will automatically do this when we export from IFS?
We are using IFS 9 Patch 17 as of November. Recently I had an employee who created a quote to order situation for parts. They reserved the parts and then created the picklist. This area does not use Shipment so it was just a picklist. When they got out to the area the part was not there and cannot be fulfilled. In the past they thought they could still pull it off of the picklist (but no one remembers how they did it). I took the situation to our test environment and proved if the part did not make it to the pick list you can still unreserve it. Once on the pick list you cannot unreserve, you cannot change quantities, and I cannot seem to figure out how to report the line not picked. Anything I try to change on the line of the pick list just does not let us save. Could this be an issue in SP 17 or is there something I am missing when trying to help them out?
We are currently working on some solutions to improve our dates for our customers. One gap we currently have within IFS is that ATP (Available to Promise) and CTP (Capability check or Capable to Promise) do not include open supply, unless the Wanted Date is within the Open Supply window. Example where Supply is not seen:Customer Order Wanted Delivery Date - 5/10/21 Shop Order Due Date 5/12 ATP runs and shows you can only fulfill so much of the order (based on qty on hand and selling qty). Thus the user runs CTP moves the promise date on the customer order to the full part lead time (30 days) even though the supply is coming in on the 12th. Example where Supply is seen:Customer Order Wanted Delivery Date - 5/10/21 Shop Order Due Date 5/8 ATP or CTP see the supply and the date properly plans the customer order. With the supply not being seen on the first one example, we get an extended lead time that is no necessary. Do any other customers run into this issue? If so, have you come up wi
Good evening, does any one know if and/or how I can reset the status of a customer order back from Released to Planned? I haven’t found a way how to do so. Any advice is welcome. Thanks in advance! Bart
Hi,One of our customers is asking the following. Is this possible in Aurena?“Is there a view to look at and/or extract that shows IFS Aurena logins, date, and person in IFS? Want to use it as a KPI for tracking account managers use of IFS Aurena CRM. “Thanks, Jo
Hello, I created a scheduled Batch Load job to input an external Bank Reconciliation .csv filed saved to a folder location on the server. When setting up the External File Template, I believe I configured the ‘Input Files’ section correctly. I have a File Name and Input File Directory. When I run the Scheduled Database Task, I receive the following error:ORA-20110: ExternalFileUtility.File \\servername\External\BankReconciliation\filename.csv not exist EDIT: I can upload the external file successfully from the same location using Online processing.Can anyone suggest possible solutions to fix this error?
Hello,I am looking for a way to create conditional formatting for the available Qty column within Customer Order Lines. I am looking to have the cell highlight green if the value is greater than the Sales Qty (BUY_QTY_DUE). I am trying to put in the below formula, but it doesn’t look like conditional formatting has the ability to compare the value against a different column value. Is that accurate, or is there a way to accomplish this that I am missing? Thank you,Matt
Can we integrate IFS ERP Application (version 10) with the Salesforce CRM? If Yes, then How?
