Distribution (CRM, Commerce)

Context : Middleware : V10 UPD6 on premise CRM Panel : UPD6 Navigator :  87.0.664.75  compliant with requirement Office : 2016 compliant with requirementCRM Panel doesn’t load. A blanck page appear with an image “Loading”We tested with the 2 scripts XML we found on the add-on page. We tested the EWS script, this one would be adapted for the on premise installation.Problem :With the navigator debugger, we saw attempts to external Microsoft URL. (office.js,...)Our web proxy doesn’t allow to go automatically on these pages.We tested without proxy : the CRM panel load. We need a CRM Panel execution from the on-premise configuration.How to implement CRM Panel execution not depending on web access with Office 2016 ?Thanks

Hi, We have currently the purchase order authorization rule with Allow change after authorization set to ‘Within authorizer limit’ but we would like to change it to ‘Within Order amount’.For PO’s that have a higher value then when it was authorized we need to revoke authorization and re authorize in order to be able to cancel lines.For PO’s in status received this workaround is not possible since you cannot revoke authorization from received PO. We cannot figure out a way to cancel not yet received line from such PO.Is there a way to work around such situation?/Anna

In Apps 10 Trying to create a custom menu on a business lead that searches for an address. If no address throw an error if an address exists then continue with conversion. Here is the code: DECLARElead_id_ varchar2(100)    := &LEAD_ID;found_    number := 0;   p0_ VARCHAR2(32000) := NULL;   p1_ VARCHAR2(32000) := &LEAD_ID;   p2_ VARCHAR2(32000) := &NAME;   p3_ VARCHAR2(32000) := NULL;   p4_ VARCHAR2(32000) := 'Prospect';   p5_ VARCHAR2(32000) := NULL;   p6_ VARCHAR2(32000) := '10';   p7_ VARCHAR2(32000) := 'FALSE';   p8_ VARCHAR2(32000) := 'TRUE';   p9_ VARCHAR2(32000) := '*';CURSOR get_add is select 1 from &AO.BUSINESS_LEAD_ADDRESSwhere lead_id = lead_id_;BEGIN open get_add;fetch get_add into found_; close get_add; if found_ = 0 then error_sys.record_general('Sales Process' , 'Add an Address');else&AO.Business_Lead_API.Convert_Lead__(p0_,p1_,p2_,p3_,p4_,p5_,p6_,p7_ ,p8_,p9_);end if; END; I keep getting the error message 

Need help to cancel a Sales Quotation, it is in Status Revised. When canceling we only get an error message that “The Configuration Spec does not exist”. Someone must have deleted Configuration ID. How to solve the problem?

Hi,Can anyone tell me what are the steps i should follow to apply a sales promotion deal to a customer order?[i am trying to do this in apps-9]Regards-Nahin

Reading in IFS Help about order types, I came across this:  “A default order type defined per site-customer combination has the highest priority, default order type on site has the next priority and default order type on customer has the least priority. “ Can someone tell me what a “site-customer combination” is?I know how to set defaults by customer and by site, but not “customer-site” combined.

Why is it not possible to put discount to the PO header level?Although it is possible to add it as a negative charge it then results in a wrong tax calculation. 

 Is there any standard functionalityto exclude sq lines with zero price from print SQ report in IFS8. Can anyone please check and update me.

Case: IFS Customers customer uses part codes different from what IFS Customer uses internally. There are 3 specific cases which are described in the attached sheet which mainly focus on 1-n and n-1 relationship. Sales Part Cross Reference was the obvious first functionality to investigate, but that didn't work out. Any help and experience with comparable situations, is highly appreciated!(realtion = relation not allowed to update the title  )

Hello,I am trying to invoice one order and I made already the pick up but now I want to Deliver the order and the option it’s not available.

We have a customer order where we have 2 staged billing lines on.  The lines have been completely invoiced and have also been completely delivered.  The lines are still showing delivered as the status instead of invoiced/closed.  Why?

Hi all, When a user is connected to a Person ID, reference screen shot below: the system automatically makes the above Person as the Main Contact Representative in Customer window since, the user is also connected in CRM & SRM Basic Data– Representative window.  Customer Window:  But in Customer window CRM Info tab, there is a separate Main Representative connected.  Please let me know why is the application picking the logged in user as the Main Representative despite Main Representative is already connected in CRM Info tab. Is this is a bug?, if not please explain the functionality.  Thank you. 

Hi, It seems the option ‘Pick by choise’ used from shipment - Report picking of picklist lines does not work if material is customer owned?Is that a limitation to this functionality?We are running IFS 10 upd 3

HI Each time when I opened CRM customer window i received an error :I worked with https://ifspsc1-d02.demo.ifs.cloud/ Database error occurred. Contact administrator.        Url: https://ifspsc1-d02.demo.ifs.cloud/main/ifsapplications/projection/v1/CrmCustomerHandling.svc/Customers(CustomerId='FR_AIRBUS')/CustomerCrmInfoArray?$select=PotentialId,LoyaltyId,SourceId,EmployeeCountId,YearEndPeriod,Turnover,CurrencyCode,MainRepresentativeId,MainRepresentativeName,KeyAccountDb,BusinessLeadId,BusinessLeadName,CustomerId,ReferenceType,Note,Objgrants,luname,keyref&$expand=TurnoverCurrencyRef($select=CurrencyCode,Objgrants,luname,keyref)&$skip=0&$top=25        Date = 2021-07-13T14:18:13.878Z        Request Id = 9d098bb7-1f0d-458b-8330-f32b8b2197d8        Client version = 21.1.1.20210329033206.0 Any ideas ? 

We are currently on Apps8, in the process of moving to Apps10.On occasion, an error is made and we don’t bill a customer enough for a physical product.They agree to be billed the correct amount.What is the best way to charge the additional amount, using the specific physical sales part from the original order (for reporting and accounting purposes), but not moving inventory? 

We recently ran across this backgound job message and I am not familiar with it. COMPANY101PROJECT_IDADSCDORCHEEXCLUDED_STATUS1 EXCLUDED_STATUS2 EXCLUDED_STATUS3 SUB_PROJECT_IDACTIVITY_SEQ Any help is appreciated!

Using Sourcing Rules to select Supply Codes, can this be used to PARTIALLY source the Order Line requirement from inventory, and then raise an order for the remaining balance? I have tried to use this to select Invent Order and then Purch Order Trans, but IFS seems to only be able to select the option that can FULLY deliver the quantity required, and does not allow a partial supply based on Invent Order and then order the rest from a supplier based on Supply Code Purch Order Trans. Can I assume this is not possible?

Is it possible to grab the customer ID value and use it in another tabs search?I have created a custom tab called Product Info, that uses a reference field to find customer contacts and I would like to limit the contacts that appear down to only the associated customer ID.I would like to use the customer ID value from the general info tab for the search. 

Using Apps 10 and want to create a custom event that will send an email to the user who creates a prospect (converts from a business lead) without an address.  IFS deletes the business lead when it converts the lead to a customer/prospect.  Thoughts or suggestions? Which LU would be appropriate to create the custom event on? Which PLsql API would be good to get the Address?

We currently price our parts out to 6 decimal points.  When we try to print a quote with pricing extended to more then 2 decimals, it rounds up and prints only 2 decimals.  How do we fix this?

Hi all,IFSapps 10.Sales part screen. There is a field called “min sales qty” which when entered will put an advisory message on the customer order line if the qty is not met.The requirement is to prevent users from entering qty’s that are not multiples of the min sales qty.E.g min sales qty of 300 EACH.User not allowed to enter 301 but currently would be allowed with no message. I can think of two ways of doing this. One is having a custom event to block this from happening. Second is to set up new sales parts with a different UOM and price/ inventory conversion in place.Is there a better IFS way of doing this? Many thanks,  

One of our users mistakenly raised a CO with a lot of lines to the wrong customer, invoiced and closed it. Now we’ll have to raise an RMA and approve for credit. That can be done. However is there an easy way in IFS, maybe at RMA level to ‘transfer’ the parts to the new customer rather than returning parts to the inventory and reserving them again for the new CO with new customer info? Question might sound stupid, but noticed that this has happened quite a few times in our warehouse so thought of looking at ‘easy ways’ to assist our colleagues when they repeat this mistake. :)

When creating a sales quote - adding a line - line not showing discount(%)

Hi, I want to create a Lobby Data Source which shows the sum of values stored in 3 views. Therefore, I need to create an IAL. But I struggle to get the desired result. I created the SQL Statement in the SQL Query Tool and it gives the result I want. But how do I implement the statement in an IAL? Your help is appreciated. The SQL Statement: select OPPORTUNITY_NO "ID", DESCRIPTION as Description, 'BO' "Type", EST_OPPORTUNITY_VALUE as Valuefrom BUSINESS_OPPORTUNITYWHERE OBJSTATE <> (select ifsapp.BUSINESS_OPPORTUNITY_API.FINITE_STATE_ENCODE__('Cancelled') from dual) and OBJSTATE <> (select ifsapp.BUSINESS_OPPORTUNITY_API.FINITE_STATE_ENCODE__('Closed') from dual)UNIONselect QUOTATION_NO "ID", CATALOG_DESC as Description, 'SQ' "Type", ifsapp.Order_Quotation_Line_API.Get_Base_Sale_Price_Total(QUOTATION_NO, LINE_NO, REL_NO, LINE_ITEM_NO) as Valuefrom Order_Quotation_LineWHERE OBJSTATE = (select ifsapp.ORDER_QUOTATION_LINE_API.FINITE_STATE_ENCODE__('Planned') from dual) or OBJSTA

Some of our projects has multiple tasks, completed at different dates, that generate different orders.  Is it possible to tell, when viewing project connections, which task relates to which order? Below is an example of the Task and Project Connection tabs.   Project Tasks: Project Connections: