Distribution (CRM, Commerce)

Hi,I have set as follows, but the fixed freight charge amount is not shownin the invoice.  Could you tell me how this can be resolved please?Thank you very much!Kind regards,Kokubo  

Hi, We have a case where we have document text added to select customers on the Order tab, who can be identified by their Form of Businesses - to print out on Invoices and Credit notes. This works very well.  Now I have been told that it is not appropriate for the text to appear on orders from one site. Any ideas how to manage this. I have suggested adding “where applicable” to the text - but that is not liked.Thanks, Matthew

Dear all,I would like to translate the label of a “NavigationLink type Command”   in Aurena. Has anyone got an idea how I can do this? Best regards,Johannes

Hi,I can’t make the cursor start in customer_no by default in the business opportunity view.Do you know if this is a general thing or is it a bug in my client version 9.0.21.0 ?How does this work in version 10?BR Kresten

Hello,i have a question about CRM - Convert Lead.We converted a Lead into a customer and found that -  if the Delivery Terms and the Ship-via are not filled out, it will not take over the Region and District from Lead to Customer.Only if Del. Terms and Ship-Via Code have a value, the other two fields will be transferred to the customer. It does not matter whether I work with or without a customer template.Is that the Intention?Thanks in AdvacedSusanne

We have a custom field ‘Salesman’ in IEE that we would like to use as a search field on the Business Opportunity.  I have tried to add this using the page designer but I am not having any luck on how to add it to this list to be chosen as a Search field.  Any guidance would be greatly appreciated.  

We are currently using a 3rd party haulier to deliver goods produced at our sites. When doing this we have an event based solution that fires when a new shipment is created with a particular ship via. The event registers key shipment information in a custom table. That table is then captured and sent to an FTP folder via IFS connect/application messages.It can be a little unreliable, due to the fact that users are able to update shipments and events aren’t always firing. Coupled with the occasional application message fail, and table lock it’s not a reliable solution.I am tempted to reconfigure the events to fire from the shipment table only, but am finding that as the changes are registered on the customer order, the shipment is only a reference so doesn’t recognise any changes! Am wondering best way to approach this. Does anyone else have any 3rd party hauliers you need to send information almost real time with updates? Our customers change their mind frequently and we like to be fle

Hi, Is it possible to connect certain column orders to saved searched in one view screen. For example if we wanted to use the detailed statistics - invoiced sales screen starting with Order Number in one saved search and Invoice Number in another saved search is there a way of doing that?TIA

HiHas anyone encountered the issue with sending Customer Order EDI Invoices too soon? In a small number of cases, the Customer will reject the invoice because the goods are still ‘in transit’. We are not using Delivery Confirmation in these cases.So we want to delay the sending of the invoice by say 5 days.  We cannot use the ‘Invoice Date Offset’ setting that will delay Print/Send because we want to account for the revenue with a real invoice. We also have considered ‘Interim Posting of Outstanding Sales’ but this only accrues for the revenue - we want the invoice on the Sales Ledger. In summary, we want the Invoice in the ‘PostedAuth’ status but the Sending Delayed. Perhaps there is a way in connectivity or something? 

We have an issue where we have printed a lot of Customer invoices that should have been emailed ( The PDF created event was not enabled)is there a way I can do this en masse? I have around 800 that need to go :( 

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 recommended) later for any reason. This could ta

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 field?

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(HttpWebResponse result, FndManualDecisionCollection decisions, String operation, FndBodyType responseBodyType, Object responseBody)   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(O