Distribution (CRM, Commerce)

I am just starting to explore Aurena in IFS Cloud 21R1, but can anyone who has been using Aurnea for a while explain how to create a similar query within Aurena?  It is the type of query that we use all the time in IEE (V9) to provide search results without the need for a quick report when the additional columns from another view are not required on the search display. This particular search finds the customer payments posted in the last 7 days for a given company.   INV_STATE = 'PaidPosted' AND COMPANY = '&COMPANY' AND INVOICE_ID in (SELECT coih.INVOICE_ID from INST1APP.CUST_ORDER_INVOICE_HIST coihINNER JOIN INST1APP.CUSTOMER_ORDER_INV_HEAD_UIV coiON coi.INVOICE_ID = coih.INVOICE_IDAND coi.COMPANY = coih.COMPANYINNER JOIN INST1APP.CUSTOMER_ORDER coON coi.creators_reference = co.order_nowhere coih.DATE_ENTERED > TRUNC(SYSDATE)-7 and coih.MESSAGE_TEXT =  'PaidPosted' and co.country_code IN ('CN'))  My inclination is that this isn’t yet possible in Aurena, but it is a critical ele

In the test environment  activity records displayed in descending order from latest to oldest date.  But in prod environment  activity records displayed in ascending order from oldest to latest date.  does anyone know a setting where this can be changed in Prod?

I have over 200 info change requests that are in the preliminary stage I want to delete them all.  Is there is any functionality in IFS or a job that can handle that?

We are currently using Apps 10 and looking to potentially integration our IFS application to address validation software. Has anyone had experience with utilizing 3rd party software to do this? If so what software platform are you using and what was your experience with the integration? 

please support me for error when create shipment but quantity at reserved qty do not transfer to delivered qty and shipment id can not finish

Hi All, This question is from one of our EU customers. Is it possible to print the intrastat code (Custom Stat No in Inventory Part) on the Customer Invoice through a configuration change?  Thank you. Best RegardsAkila

Check the below requirement of the customer The putaway and handling units were not efficiently developed and as a consequence there is a delay to putaway. Customer accepted that this would take up to 15 seconds a pallet, however in line with recent changes this has increased. In the customer’s scenario, there are 36 bays in the warehouse which have space at the end for 4 pallets. Each Bay has approximately 260 locations, each for a single pallet.The access to the end of the bay is via a standard pallet truck, or manual move. The movements in the bays are with VNA (very narrow aisle) specific devices, which due to their nature and size, need to work within a Bay as much as possible. To achieve the design, customer has worked with drop off locations at the end of each Bay, so a transport task on putaway would first go to the end of the bay, before a second task used by the VNA trucks would be used to locate the pallet in the racking.These trucks typically put one pallet away, then get a

Hi All,In Business Opportunity Pipeline window, I am getting the below error when I include in my filter Business Opportunities  with different currencies (AUD & NZD). Why is it using currency type 1, aren’t they suppose to use currency rate 3 ? thanks 

Hi Everyone, Is there anyway to calculate the commission based on Net amount? Currently we noticed that it is based on Gross amount.  

Upon delivery, one of our inventory part lines changed price.  This is not a configured based part. The price at the part level did not change. What are other reasons why the price would change on a line at delivery?    

Morning,We tend to put a default 6 weeks delivery date on 99% of a spare parts customer orders, and if the parts come in early, we’ll ship early. Happy days.Occasionally we’ll get an order where the customer doesn’t want the goods until the actual promised date. Is there anything within Apps 9 that stops the picking until a specific date?  TIA Chris.

Hi all,my colleague got the following error message in sales quotation while he was saving it. We use IFS Apps 9. What does the error message mean? Thank you and best regards.

Hello, Is there somewhere to set this default?  It is the Create Order in Released Status field on the pop-up box when creating a customer order from a Business Opportunity. From the Bus Opportunity header > RMB > Choose Create Customer Order 

I created a custom tab with two attributes for Master part. Now when adding a value there it saves the value for all master parts not just for that one as it should. How should be done that I could have individual values for each master part?

Hi all, sales department wants to assign NACE rev 2 code to customers in IFS app 10. Is there standard screen/field where this is stored, or anyone has experience of using alternative way to assign this code? Thank you for your input. 

I can’t see a way to add a custom field to the table 'Business Opportunities' in ‘Business Opportunity Pipeline Chart’ Aurena page. This is in App10 UPD12.However the corresponding EE form can have custom fields.Is this a limitation in Aurena?Thanks

HiWe are using incoming customer orders for charges from an external software, but was wondering if anyone knows how to handle incoming credit notes. We have tried sending a negative order but get the following error - Error Message: ORA-20110: CustomerOrderLine.PRICE_LESS_THAN_ZERO: Price must be greater than zero!Thanks in advance.Hayley

We have a small group of users inputting Business Activity information through the CRM Companion App but are finding that none of their input is syncing back to IFS to be reviewed and tracked. Reviewing the Touch Apps Logs in IFS, the following appears to be thrown for quite a few people: Sending push entity data failed: Target exception in method call : EJB Exception: Caused by: ifs.fnd.base.SystemException: Target exception in method call : EJB Exception:  Caused by: java.lang.reflect.InvocationTargetException: null Caused by: javax.ejb.EJBTransactionRolledbackException: EJB Exception:  Caused by: javax.ejb.EJBTransactionRolledbackException: EJB Exception:  Caused by: java.lang.NullPointerException: null - ORA-20105: PlsqlapServer.ERRINV: Target exception in method call : EJB Exception:  Caused by: ifs.fnd.base.SystemException: Target exception in method call : EJB Exception:  Caused by: java.lang.reflect.InvocationTargetException: null Caused by: javax.ejb.EJBTransactionRolledbackEx

In customer header screen co line level column details are not visible with some user while other user can see column details along with data.   Any solution to this issue greatly appreciated. :)Thanks in Advance.

Hi All, is any option available in IFS to create MRB and scrap 10 to 15 parts in single MRB .I want to scrap 10 parts which is available in part in stock.Not want to scrap directly and  need MRB for documenting  also not want to create  10 to 15 MRB for single  parts Regards   

Hi, Has anyone updated the dialog page ‘Add Contact’? This dialog page is accessed from the Business Activity and the Business Opportunities screens when adding a new contact. The page designer on Business Activity and Business Opportunity screens doesn’t show this dialog box to be able to remove/add fields or rename them.Would be really helpful to us to know where to access this from.ThanksAlice

Hi all, I am in the process of transitioning a customers orders and invoices to EDI. I am trying to populate the customers ‘Customers Own Address ID” field. The customer has 10 sites and have provided their ‘location codes’ that we need to use in the EDI submissions when we invoice them. Their sites are simply numbered 1-10.Most of the sites allow me to add the appropriate site number in but a couple of them (1 and 5) give the following error when I try to save the record: This customers own address id already exists on another address for this customer or another customer I have checked through each site for the customer and none of the other sites have the Customers Own Address ID set to 1 or 5 (they all have their own numbers of course) so looking at the error, I am reading it as if ANY other customer has this field set to 1 or 5 then I cannot use these values. Surely this can’t be right? Is it really saying that the value in this field must be unique throughout all our customers de

I would like to know if this check in Order confirmation implicates to send Order confirmation automatically when the customer order is been released. How  to avoid sending order confirmation automatically via email? 

Is there anyone out there that can explain the functionality of this new columns? We upgraded from Applications 10 Upd10 to Upd13.

Is it possible for the customer order discount functionality to work with quantities instead/in addition to price? We have a customer that needs to be discounted a % of quantity, with the price remaining the same.If not, is there a way to enter a negative sales quantity on an order line to show the “discount/credit” so it can all be invoiced together?