Distribution (CRM, Commerce)

Does anyone currently use a 3PL with a third party website where the inventory is transferred to an outside warehouse but the inventory transaction is not done until the customer places an order from the website?We are trying to determine how to process the orders and recognize payment if the order details reside with a 3rd party and the reservation and orders are processed outside IFS but need to be recognized inside IFS.

We would like to automatically add a Shipping & Handling charge to all Sales Orders of a certain Order Type with the users having to enter additional information. What is the best way to enable this?

Hi All Users,I would like to share below information with regard to the Job ‘Cleanup of Customer Orders’.Cleanup is a very dangerous way of getting rid of old data and not a recommended approach either. Archiving is much safer but then customers need to take care of the archiving themselves which is something they do not want invest time in. Unfortunately customers use clean up extensively and we do add on more obvious deletion of dependencies as and when reported by customers. However, we have never guaranteed that all links to the deleted object would be removed. Inventory Transactions are not considered in the clean-up. as there could be postings created and already transferred to General Ledger. It may even be wrong to remove these transactions from an auditing perspective. So ultimately you will end up having inventory transactions for order headers which do not exist. The worst part comes in if you re-use the same order number (not

IFSAPPS 9.We have been using a Business Analytics model to run our sales forecast. This was using Business Opportunities as the Information Source.One of the filter criteria was DIM_OPP_PROBABILITY.CODE BETWEEN 50 and 100. This basically captured any high probability Business Opportunities. After we installed UP17 our Business Analytics model stopped working. I believe the issue was that prior to UP17, the field on the Information source was the value in the PROBABILITY_DB field and it has now changed to be just the PROBABILITY field. The issue is that the PROBABILITY field is suffixed by a % sign, so when we use this field in the filter I receive an ‘Invalid Number’ error message. However I have not been able to use SQL in the Filter Criteria to either TRIM or REPLACE the % value out.Is there a way to point the Information Source back to the PROBABILITY_DB

Hi All, In Document Text Administration we have 2 Output Types defined that put information onto the invoice (doc 4). If I add document text against both of these Output Types on a Sales Part this document text prints out on our invoice directly below the part line.However if I add it to an Inventory Part I get no text printing out and if I add it to a shipment header I also get no text printing out.Can anyone advise if there is something else that needs to be configured to get the text to print, especially for the shipment. We are needing it here to give a full shipment weight and pallet details on each invoice for export reasons and it changes every delivery hence adding it to shipment header. Thanks Sarah

Hi, I would like to know if IFS have its own e-commerce store? and how to set it up? ThanksCarlo

Had anyone recorded there web enquiries and ftp’d the information into IFS within the Business Leads section? It this possible, if so, does anyone have any pointers?Thank you.

We need to create a Custom Field for the EORI number and would like to know how to handle the fact that we require the following format: First 2 characters (Alpha)Next 12 characters (numeric) Would I have to create the field as a text field and then run a custom event to check that the contents meet the format?Can anyone please advise a better way?Thank you.

Hi, so I am trying to configure a “fruit table” which gives indication, what kind of fruits a customer processes. I managed to create a custom logical unit and create a “list” element out of it. The list contains out of two custom fields, one sort of  fruit and the other one of the customer id (which acts as the primary key). Also, I could install a master entity relationship to the customer crm projection, so that only the fruit are displayed, which have the matching customer id. However, when a new entry is done, the key must be primarily entered. Does Aurena support a function, that it automatically fetches the key mappings as IEE did it? I have not found this information in the technical documentation.  Thanks in advance for any hints, maybe somebody can point out what I am missing.

We are deploying CRM Companion 10 to our sales reps and they would really like (i.e. want) the mobile “Business Activities” screen to display activities in reverse chronological order.  They hate scrolling.  The default mobile app behavior is to show ALL ACTIVITIES from oldest to newest so they first see activities from 2018 and have to scroll endlessly to see their activities from this month or last month. Can the default sort be configured for mobile?  Of course, they also want some more filters like “Last Month” and “This Month” so they can quickly get to the info that they want to see easily without any thinking or effort...shamefully lazy users, lol!Much thanks, Tom Bowe

Hi,   Is it possible to create a count report to include Shipment Inventory. We are running a stock take and the system is not generating for those locations (bays) that are of type Shipment. Thanks, Matthew

We have an issue where some users enter a wanted date in the customer order in the past ( 2020Instead of 2021!)perhaps I could create an event which fires a message to user? Would like to stop them altogether really so perhaps an event that doesn’t allow a past date?Any ideas? 

Hi everybody,nice to be back here! I hope everybody is doing fine, stay healthy and in good mood, despite the bitch Corona! :-)Simple question:Were may I “see” the connection between customer order (customer invoice) and ServiceLevelAggrement SLA)?Or:Is there a simple way to seperate “normal” invoices with inventory parts (sales parts)and service articles?Later on we want to aggregate and ask:What part of the service aggrement is done (and invoiced) already and what percentage is still “open”?All the best to you, your family!Michael

How to delete a rolled line?Error message =>Forecast records containing consumed forecast cannot be deleted. But there isn't consumed forecast???? 

Hi, I’m trying to update Sales Prices in Price List, however, it doesnt work for some sepecific customers and  IFS gave me the error as below. I tried but could  not identify the reason.  Server error messages:14ad8bf0-eea6-46e7-b739-75fb62f55be3Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-01476: divisor is equal to zeroFailed executing statement (ORA-01476: divisor is equal to zeroORA-06512: at line 59)   at Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)   at Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions)   at Ifs.Fnd.AccessProvider.FndConnection.HandleHttpSuccessResult(HttpWeb

Create a Customer Order for 100 unit. Release. Reserve 50 units. Create Picklist for reserved quantity. Shipment will be created. Do the Report picking of 50 units. From Shipment Window header => RMB => Print shipment delivery note. Delivery note will be created. It says 100 Delivered and seems misleading.

I want to change the translation of a field, but I don't know how to do it.In Report Designer I added the field ‘CUST_REF’. The default description is the same as the field above ‘CUST_REF’. How can I change the description of this field on this report?

I am not able to run the "Recalculate Price/Currency" on a Sales Quotation Line in Aurena (APPS 10 Update 10) or IFS Cloud. This option is available in IE, but I can't find it in Aurena when looking at the same Sales Quotation. I also checked the other options under the vertical 3 dots.Thank you in advance,SteveIE

What are the capabilities that IFS applications offer that can be identified as ‘Internal Trade’? I know Inter-site setup is one. Inter company is another. What else? can you please elaborate? Thanks in advance. 

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 insta

We have a scenario where product is sold to a customer which is purchased from a supplier and delivered direct. Our current crystal invoice print needs to be reference the purchase order number as that appears on the shipping document. What’s the best way to achieve this? Use an IAL? Or simply reference on the crystal report?  Thanks for help in advance

Hi, I would like to start using the Associate/Associate as Master functionality for Cases. Have tested some and do see I need more info to get it correctly done before start using it. Ex. can I associate a Case as a Master when I have created it or is the only way to Associate by right click the Case line under the Case Overview tab ? If I remove the Association the info in the Master field/column is sometimes not removed.  Do also see that Search window in Case heading and in Case overview are “bugging” eachother (if I add some fields in one it affects the fields in the other, and different ways each time, not possible to save the criteria without affecting the other, same thing happens in Global Solution window)Have tried IFS Application Help function online but without luck. Anyone that have found usefull documentation on this subject?

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

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? 

We use IFS Sales Quotations. Sometimes when we are printing them sharing internally, we need the price figures in it (Price, Net Amount) hidden or zeroed. We wouldn’t want to change the value in IFS to zero. Is there a way I can achieve it only when I am printing the report?