Solved

Community, kindly assist on the SQL query we are building for API method  Inventory_Part_Config_Api.Get_Latest_Purchase_Price()what parameters we should pass to method Get_Latest_Purchase_Price()?Thank you.

Hello,is there any way to upgrade reports from IFS Report Generator to IFS Business reporter as IFS Report generator is not in IFS Cloud.Please suggest RegardsPankaj

Hi everyone,I’m working in the namespace and the pods are getting IPs in the 10.1.x.x range. This is causing some connectivity issues with other services. ifs-db-init-cjp5g                                               10.1.204.235ifs-virus-scanner-7698b7994c-q2g2w        10.1.204.228ifsapp-am-workqueue-7d895cf959-ps29f  10.1.204.252ifsapp-amm-55cd5bb94b-dmwth                 10.1.204.251 Does anyone have advice or experience on how to safely change the pod IP range to a different subnet (like `10.14.x.x`)? Any tips or best practices would be really appreciated.Thanks in advance!

Hi, This is regarding the Swedish Rule for reporting VAT on Foreign Currency invoices of Swedish Suppliers. Would like to know your ideas on the best possible way to handle this. The customer receives the VAT amount in Domestic currency from the Supplier and that amount must be used by the customer for VAT reporting. For example: for a EUR ccy invoice, supplier sends the VAT in SEK amount as well. The customer only calculates the Gross Amount in SEK using the rates in IFS. However, the customer does not know which date the Supplier used to arrive at the VAT in SEK when they send the preliminary invoice. Therefor, there are differences in VAT which the customer today moves into a currency account. Example:Amounts on Invoice from the SupplierGross in EUR        100VAT in EUR              25Total in EUR          125VAT in SEK            250SEK Amounts Calculated by Customer at Booking DateGross                    1000VAT                          275​How the invoice is handled in SEK curre

We have created a simple navigation link with Navigation from Active Work Orders to Work Tasks in the standard View command groupThe command works perfect in CFG and UAT, but in PROD the settings above takes us to  page/WorkTaskSales/List instead. The url for my browser in other envoronments looks like this when the Work Task page has been opened:web/page/WorkTasks/List;$filter=WoNo%20eq%2010679460;path=0.1531594057.655302546.973537261.2023108696 In prod it also contains WorkTask/List and my WO(s) but also much more…. web/page/WorkTask/List;$filter=WoNo%20eq%2010679460;path=0.1531594057.655302546.973537261.1896085532.eyJmIjoiL1BhZ2UiLCJnIjoiV29ya1Rhc2siLCJpIjoiTGlzdCIsImEiOiJ2aXJ0dWFsLTEiLCJiIjoiMTg5NjA4NTUzMiIsImUiOiJXb3JrIFRhc2sgU2FsZXMgTGluZXMiLCJoIjoiV29ObyBlcSAxMDcwOTU2NSBvciBXb05vIGVxIDEwNzA5NTg0IG9yIFdvTm8gZXEgMTA3MDk1NTQiLCIkZmlsdGVyIjoiV29ObyBlcSAxMDcwOTU2NSBvciBXb05vIGVxIDEwNzA5NTg0IG9yIFdvTm8gZXEgMTA3MDk1NTQiLCJkIjp0cnVlLCJjIjpmYWxzZX0%3DThe same settings works as expected w

Hello, After installation we have a “Read Only Grant All Projection to IFSREADONLYSUPPORT” failing database task. How to get rid of this ?Can this job be removed ?

i want to use api method (https://exsto-uat.ifs.cloud/main/ifsapplications/projection/v1/VoucherHandling.svc/VoucherSet) but i dont know the json template to use, i read the api document in api explorer windows, but i don't understand the json template to use, i try to use the same method in get to reuse the result json, but few values "can not be mapped as a property or an annotation", if i delete this values i have a new message "Unable to fulfill the request due to unexpected server state". can you help me ? with a json example ?Product Version: 24.2.3

Iam trying to create an event or even an api call would be fine for when a background job finishes.  Specifically "Create Pick List for Customer Order".  Our goal is to have the associated order’s PCKNOTE document text updated after the shipment is created from the background job.  I have a custom api call that updates it when I test from SQL but I can’t figure out how to get the event to trigger.  We tried when a new record is inserted into the FRT_SHIPPING_INFO_TAB table.

Hello everyone,I'm trying to migrate customer orders and customer order lines. Everything's working fine, no problem. However, I'm trying to migrate the CODE_C of the lines using another job for pre_accounting, and retrieving the pre_accounting_id of a line, but I get an error I don't understand: ORA-20111: Site.NOTEXIST2: The Site object does not exist.Strange, because in the job, this indication does not appear, and only the pre_accounting_id seems mandatory.   How can I make these jobs work easily? 

A couple journal entries were made this month after PCA’s were ran. Is there a way to run PCA’s for the same period after all the steps in the PCA Step Definition have already been Executed?

Hi!A customer reached out and asked about the the SMTP authentication for Event Actions in IFS Cloud 22R1. Are there an option to use a modern authentication (like Oauth 2.0) when connecting to Office 365 Exchange server ?  The background is that Microsoft are moving away from legacy authentication methods (in some areas it’s deprecated) and recommend upgrading your authentication method.  https://docs.microsoft.com/en-us/exchange/clients-and-mobile-in-exchange-online/deprecation-of-basic-authentication-exchange-online 

We have an audit requirement which requires to report the last login date and time for a user in IFS. In APPS8 we could get this information from the SERVER_LOG_TAB using the log category “IFS Sessions’. However, IFS cloud does not have this category as a server log parameter.There are some details in the IAM_LOGIN_EVENT_DETAIL_TAB but seems like it does not keep the long-term history of sessions.Can you advise how to get this data recorded and retrieved on demand?

Dear Experts,We have developed a custom APIs to post transaction data (both header and line-level structures). These APIs have been tested successfully in DEV, TEST, and UAT environments without any issues.Recently, we cloned the UAT environment into a new environment (UAT2). However, in UAT2 the same custom integration fails with the following error:ORA-22813: operand value exceeds system limits The response is always 500 Internal Server Error.We already tried the following: Tested with the original payload (works fine in other environments). Sent a blank/empty JSON payload → still fails with the same error. Verified that standard IFS APIs with POST methods are working fine in UAT2. The problem seems to occur only with the custom API in UAT2. Since the environments are cloned, we expected the behavior to be identical.What could be the possible cause of this error in the cloned environment (UAT2), and what areas should we check (DB settings, CLOB handling, API configuration, etc.

Hello,We are on IFS Applications 8. We need a standard way to record additional attributes/details at the lot level (i.e., information tied to a specific Lot/Batch No, not to the part master).Questions: Does Apps 8 provide any lot-level fields (standard or user-defined) to store extra information on a lot? If so, which screen/table should we use (e.g., Lot/Batch Master, related info tabs, user-defined fields, notes, etc.)? If not, what’s the recommended approach to maintain lot-specific metadata (e.g., configuration, enabling custom fields, using Handling Units, or another object)? Any guidance or configuration pointers would be greatly appreciated. Thanks!

Hi All, Imagine the following data setup and scenario. Demand Site - Site ASupply Site - Site BInternal PO X is created on Site A and sent through to Site B where the internal CO Y is created and processed. The pegging is correctly shown. However, even before Y is delivered, PO X on Site A is available in Register Arrival on Site A and can be receipted while CO Y is in a status prior to Delivered. The expectation is that PO X should only be able to be receipted once CO Y is processed through to Delivered. Am I missing a setting here or does IFS have a different rationale behind this?  Thanks in advance!

Hello,wanted to know process of getting connection to pl/sql developer from hosted environments at IFS Managed Cloud services. Please suggest if we have to raise ticket for the same/get VPN like Build PlaceregardsPankaj

Trying to migrate customer contacts using FNDMIG and we are receiving the error:   ORA-20124: Error.NULLVALUE: Field [PERSON_ID] is mandatory for Customer Info Contact and requires a value. We are currently using the CUSTOMER_INFO_CONTACT view and CUSTOMER_INFO_CONTACT_API 

Hi everyone,I'm working on a custom consolidated task report in FSM where I merge multiple tasks into a single output. I created a new report template (FULL_INSPECTION_REPORT_GROUPED_4) to generate this merged report.When triggering the report generation from the WebClient, I receive the following message:"Report FULL_INSPECTION_REPORT_GROUPED_4 is being generated asynchronously."However, I never receive a follow-up notification or download link. The report doesn't appear in the downloads, and I can’t retrieve it from anywhere else either.Has anyone faced a similar issue with asynchronous report generation? Any guidance on how to debug or force the download (e.g., check report queue, logs, or configurations) would be greatly appreciated.Thanks in advance!

Hi,We have some invoices listed in the Customer Invoices with Errors screen in IFS.When I click on Customer Invoice Postings Analysis, I can see the error detail as below:Value is missing for posting type M30 combined control type GRPSTAT code part A in company RODLTD.The posting control, M30, has been set up with the below control type. This has been set up for over 18 months and works correctly.Control TypeThe customer concerned is set up with a Customer Statistics group, which is valid and it set up with the M30 posting control details.Criteria exists for Control TypeWhen checking Sales Parts on the invoice lines, these have the correct classification also:Sales Part criteria exists for Control TypeThe Sales Group is also set up in the M30 posting control:Sales Group criteria also existsAre you able to identify anything that I’m missing?I believe the customer is new, so a possibility is that the Sales Group was not applied to the customer record until after the order was placed. In

Hi All, I am receiving the emntioned error, Any expirience with ?   

Cannot explain myself around a behaviour in purchase order authorisation. Below is how my auth rule is setup. Note the ‘Use Delta Amounts for Auth’ is set to Yes. Now, my PO is initially a placeholder for total of 0.01 value. Then a POCO is created to add another line with a value of 120,000.An authorisation is expected on this POCO, however is not fetched when the Delta Amt for Authorisation is set to yes. In my pov, there is a clear delta amt which is within the range of the auth rule. When the Delta Amt check is set to no, the auth rule is fetched. System - IFS Cloud 23.1.3 

Hi,we would like to format some dates in the notification messages.There are functions like place_time, person_time and time_window.But is there a function to get the date only, so without the time?Reason is, we like to inform our customers about appointment via email but we don´t want to have a time in those emails.Anybody any suggestions how to archive this?ThanksBenjamin

How to create Single Work Order for Multiple Object ID, through PM action for example multiple Fire and gas detector to be checked on single zone, I need one work order to be generated with List of Object ID I am using Maintenance Module

HiI am processing the employee payments in payment in full page and got the below error message thanks,Ken

Hi dears,Is it the Turn by Turn Licence would activate the MAP Licence Key Included?I did configure the Turnbyturndirectionskey to the key provided and the TurnbyturnDirectionsprovider=BING. But still i have Map License Key Included:No.