Solved

Hello,is there a functionality in IFS which can simulate the packing of a container?For example, the shipment has 10 pallets with a size of 2x2x2 meters. How many can fit in a specific container size, or how much space is left for other things?Thanks, Golo

I have scheduled a Seperate PM Action so that we do it once per year. As I set Valid From to a date one year back, the system created two work orders, wich is correct as two of the dates have passed.However, I decided to cancel the Work Order for previous year as we are going to do the maintenance now (wich is the second created work order). Now when I look in Mainenance Plan Analysis it still shows both work orders. Is there an easy way to not show work orders that have been canceled? Option:Is there a way to open a cancelled scheduled maintenance work order and set Actual Finish date to the same day as the work order was canceled?

We added a custom field for work orders in the mobile app. How do we get that field to show up for all mobile users? Does it require an initialization or a profile push?

Hi,when you are using warehouse mobile edge, you can make a search on a product.1/ Is it possible to see attachments linked (on the product center) to the product ?For example : you could see a procedure for a technical or logistic preparation of this product.2/ Is it possible to know with a Search or other action : How many product are in a location (bin) ? If you are a logistics worker in the field, you often want to know how many prodcuts are in a bin.Thanks and Regards 

Greetings!In Apps 8, a sub project completion was done and as its voucher date was incorrect, a rollback was done for that.Then, when the sub project completion was attempted to run again, attached error message appears.Further, the activity sequence appears in GL Voucher rows analysis only for the first capitalization but not for the rollback.Can someone please explain1. The reason why this error appears?2. Why activity sequence does not appear for the rollback? Does that mean rollback did not happen properly? Thank you!

Hi  I have done partial rollback on supplier payment, as this particular supplier did not get paid. The rollback has correctly reversed the supplier payment on the supplier account. But this showing Rollback status as “PART ROLLED BACK” and its has created Parked Payment. How do I clear this parked payment.  ThanksSwati

Is there a way to change the rule order for conditional field actions? I think by default it appears to be alphabetically ordered unfortunately this is not always the logical order for the rules 

Could you share release notes of IFS Apps 10 Update 13?Best regards,Alexey

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