Solved

IFS Community,We are finding the auto-reservations is not reserving materials to the CO Lines in order by the Planned ship date. What is the field used to determine what is reserved first and is there a setting we can change to ensure the auto-reservations is using the Customer Order Line Planned Ship Date?

This feels like a n00b question... I'm writing a report in SQL. What is the best JOIN clause from the inventory transaction history (INVENTORY_TRANSACTION_HIST) to the customer order invoices (CUSTOMER_ORDER_INV_JOIN)? I want to see the inventory transaction history so I can see all the cost elements on an invoiced order line. I need a solution capable of handling multiple deliveries on the same line. The closest I've gotten so far is to use the proximity of the invoice and delivery dates, but that doesn’t feel completely right. I don't think I need to handle credits (yet).

We currently have a requirement on a Report Designer layout to convert a Number to a Word. So what I mean and as an example,  a number of ‘100’ to be converted to ‘One hundred’. I have used the below SQL in a CF - which works fine. WITH cte AS(  select '-100' AS num  from dual)SELECT   num AS old_value,  decode( sign( num ), -1, 'NEGATIVE ', 0, 'ZERO', NULL )  || decode( sign( abs(num) ), +1, to_char( to_date( abs(TRUNC(num)),'J'),'JSP') )  ||  CASE     WHEN INSTR (num, '.') > 0     THEN  ' POINT ' || TO_CHAR (TO_DATE (TO_NUMBER (RPAD(SUBSTR(num, INSTR (num, '.') + 1)                                                     ,2,'0')                                                     ),'J'),'JSP')     ELSE NULL  END AS new_valueFROM cte; But, if the number if I enter a number of  ‘-6313343’ I am getting this error message. ORA-01854: Julian date must be between 1 and 5373484 Is anybody aware of any else that I could use to get the ‘number to word’ conversation working to allow me to use i

I have a question from a warehouse manager - why is total cost missing for a lot of products? We do have cost on the products. 

Dear experts,I am trying to post a Manual supplier invoice using a posting proposal through a newly created company. However,  the Manual supplier invoice was directed to posting proposal analysis window via RMB and therefore, I could not able to finally post the invoice. Appreciate it if you can help on this matter. Further, I was not able to find a posting proposal window as well. I am using Apps 10 upd 15.  Thank you

Is there a way to prevent someone from approving their own requisitions?  For example, if the person is in a group that allows them to authorize requisitions up to $5,000, can you set it up so they can approve as long as they are NOT the requisitioner?

Hi Experts,This is related to the same question below raised by a community member. Inbound integration -Table key returns is not working | IFS CommunityThere is a requirement to send the keys to the outer system with the inbound response.→ Inbound request→ Create response with the keyI have tried to achieve this using the ‘Table key returns’ option in xml map.(As shown in the below screenshot )  Postman requestPostman responseBut the response doesn’t have the Task ID information.Am I missing something here? Thanks and regards,Hasara

Is there anyway to scroll right in Aurena to view more columns?

Hi,I am trying to send additional documents with the mail of the order using the topicAdd Purchase Order Attachments to the Same Email , When Print Order Unfortunately, I get the following error message."Failed to read binary data from database: Entity instance not found. (DOCUMENT_FILE_DATA - DOC_CLASS=TECHN-TSPEC, DOC_NO=1250234, DOC_SHEET=1, DOC_REV=A1, DOC_TYPE=VIEW, FILE_NO=1.0)Caused by: ifs.fnd.base.SystemException: Failed to read binary data from database: Entity instance not found. (DOCUMENT_FILE_DATA - DOC_CLASS=TECHN-TSPEC, DOC_NO=1250234, DOC_SHEET=1, DOC_REV=A1, DOC_TYPE=VIEW, FILE_NO=1.0)Caused by: ifs.fnd.base.DatabaseException: Entity instance not found. (DOCUMENT_FILE_DATA - DOC_CLASS=TECHN-TSPEC, DOC_NO=1250234, DOC_SHEET=1, DOC_REV=A1, DOC_TYPE=VIEW, FILE_NO=1.0)"All files in the folder are 0 kByte in sizeWhich right is missing?RegardsAndré

Hi all, How to translate definition of a custom field  to another language? Best Regarts,Ozge

Hello ifs community,Purchase order line Qty=10 kg,Qty per Assembly in component part=1,scrap factor=50Then what will be the required qty?The component part screen is showing the required qty = 20 kg but i am not able to calculate this 20 kg Qty. can someone help me to find the way of calculation  of required qty with qty per assembly and scrap factor.

 Anyone knows how this is setup in IFS?

  Hi, Does anyone have an idea about how to define Backup Path in Demand Plan Server?should we define this in a system parameter by pointing a folder in an extended sever? 

Hi everyone,To let you know I’m using IFS APP 9. We are trying to put a process on our shop order with a subcontractor.This is the scenario :We have a product X , with component A & B. ( I already set up the structure / routing )The product X is made by our subcontractor from component A & B , so we have to send component  A & B. After he mixed component  A & B together he sends us the final product X.We keep the stock in our site because we also sell component  individually to other customer.We have a customer order for product X, which generate a shop order ( beacause we don’t have stock) telling us to prepare items A & B, eveything is correct until the shipping .At any moment we can bring up what's product we send on the delivery note to our subcontractor, so when we get the delievry note after the “Ship WIP to supplier” there is only the operation related to the service "mixed A & B".So how we can send our product to the subcontractor  after getting the item

I am wondering if there is a way to assign a single PR line to multiple activity sequences-for example, if I am ordering 10 of a certain part, can I assign 5 to one activity sequence and 5 to another without having to create multiple PR lines/PO’s?  I am new to IFS but familiar with SAP, and I know that SAP has this functionality.  Thank you!

Hi,On the 15.4 Release, we have the customization option : Attaching an .xml file to a .pdf ReportWhen the report is exported, the xml will show as an attachment in the .pdf file. Could you share an example of a report with a xml file as attachment on the report ? and the xml used for this example ? Thanks and Regards  anthony

Hi GuysI’ve created a Custom api (using PLSQL Developer) and trying to setup a Database Task Schedule using same. Normally, i create DB task using PLSQL developer only but this time change of approach and thought of trying Schedule DB task.Following below process:Created a Package and made sure it got Module_ and lu_name_ declared within header (as suggested by @durette )Step 1: create or replace package CB_MS_LEVEL_1_API is              module_  CONSTANT VARCHAR2(25) := 'FNDBAS';              lu_name_ CONSTANT VARCHAR2(25) := 'CbMsLevel1Api';Step 2: Refreshed the Dictionary CacheStep 3: Granted access to ifssys as well as to public            GRANT EXECUTE ON cb_ms_level_1_api TO ifssys;Step 4: Granted access to FND_USER             BEGIN             security_sys.grant_package('cb_ms_level_1_api','FND_ENDUSER');             END;Still when re-logged into IFS and checked Task Name within New Database Task Schedule i can’t trace the api.What am i missing, any suggestions? Thanks in advan

Hi,I have a Custom Logical Unit created and a projection of type Integration created for it. I am able to retrieve the data from Postman without issues.When I try to update using PATCH, I keep getting the following error. If I pass a non-existing objkey, then it creates a new record in the CLU.Do I need to do anything differently to be able to modify records in the CLU?{    "error": {        "code": "DB_OBJECT_MODIFIED",        "message": "Resource already modified.",        "details": [            {                "code": 20114,                "message": "ORA-20114: TestOrderDetails.MODIFIED2: The Test Order Details for Demo object has been modified by another user. Please refresh the object and reenter your changes."            }        ]    }}Thank You.

What is the setting which controls whether Invoice Tax line is to be created automatically in external supplier invoices? The invoice line has a tax code and but the RMB>Tax Lines doesn’t show any info and the user has to enter it manually. However for some invoices it is created automatically.This is seen in external supplier invoices created using MHShelp. IFSAPP10 UPD13

Hi All,As I know, users can clock in to start their shift.Is there any possibility to know which IFS account was used to clock in the a particular user at given date/time. We are looking for a way to check which IFS terminal someone clocked in on.Please let me know your ideas.Thank you in Advance!

Hi Ive been trying that the system goes to the external supplier invoice tax codes when loading an e-invoice xml file.  The system will always fetch the tax code from the supplier window i dont have a delivery nor a supply country. But as far as the help says it will get the default value from either document adress and company window. If i delete the tax code from the supplier it will get into an error.  How can i make the tax code fetched from the external supplier ionvoice tax code window?

where can I find work order info (workorder #/routing #/labour/mechanic/dept./hours)

Hello Team, Is there any possibility of adding a one-time deduction for “Application For Payment” in IFSAPP10?Using the deduction percentage option in sales contact will add the same deductions to every application created.  Rather than that, is IFS have an option to add different deduction amounts to different AFPs made from the same contract? Then later same can be invoiced including deductions. Thank you..

Hello there,I have a question for you. There are some lobbies which are available on the EE environment but are missing on Aurena environment. Example there is a lobby called “document management” in EE But i couldn’t find lobby called “document management” in Aurena.So how can i get this lobby into Aurena?Thanks and Regards!

Hello IFS community, We would like to create a purchase structure for configurable part in IFS9. However this error appears when adding the parts:  However I read in manual that Configurable purchase structures actually should be allowed in IFS. Is there any option where I can allow it or how it is actually blocked ? Thank you!