Finance (Financials)

Want to know how is the field  the Total Cost/Base field in the Detail Statistics  - Invoice Sales screen is  calculated.  We have an issue where the Inventory Part cost from the inventory part transaction  differs from the values shown in the Total Cost/Base .  Know the Total Cost/Base  comes from the CUST_ORD_INVO_STAT  table, but do not know how the  field COST  is calculated.Is there someone who can advise how the Cost  field is calculated in the table or what the code is behind the table   CUST_ORD_INVO_STAT.Jeremy 

Hello Team,I want to test kyriba standard routing rules setup but I am not able to find the setup which will create application message with function as KYRIBA_UPLOAD as this will only picked by routing rule. Note- I have tried to use ISO 20022 format only with payment method as ACH. Can anyone help here? 

One of our Customers have a Lease contract that starts in mid of the month:Commencement date: 19-Sep-2025Termination date: 31-Mar-2028Monthly rental: LKR 3,650,040 (flat, no escalation), paid in arrears on month-end IBR: 13.25% p.a. First period payment: prorated stub of LKR 1,460,016 on 30-Sep-2025 (12/30 × monthly rental)The issue When we create this in IFS cloud, in amortization schedule IFS appears to discount each payment using full-month periods (n = 1, 2, 3, ...), while the customer's working paper uses fractional periods from the actual commencement date (n = 0.40, 1.40, 2.40, ...) to account for the 12-day stub at the start. So there is a difference in the Present Values calculated and the lease liability. Hoping someone here has hit this before and can share how they handled it. Customer Worksheet:

Hi,  We are sending ADVANCE invoice to customer and the first advance invoice is okej in the file, but when we are sending the “real” invoice as a EDI, the advance invoice id is not in the file (it are in the printed invoice).  Any update about this in ifs?

Hi All,We need to change the format of BOC payment file from UTF-8 to ANSI by doing through the batch process in IFS Cloud.The recommended approach is to use the batch process (background job) with defined character sets if we need to generate file encoding with ANSI format.Could you please explain and let me know how to apply a defined character set to the job when it runs?Regards,Vignesh

Hi! We have an arraingement with some customers, that we share cost information openly with them, and then add a specific and previously decided margin on top of the cost. This is however not an easy thing to set up in IFS Cloud, and we use custom reporting as well as lists to keep track on who did what service work as well as the hours, and the real costs of the service work. Then all orders/invoices need to be manually checked and the corrected. Does IFS have any modules/processes to support Open book frameworks? “An open-book arrangement between a supplier and customer means the supplier shares cost information openly with the customer.Instead of only quoting a fixed price, the supplier may show details such as:material costs labor costs overheads logistics costs profit marginThe purpose is to create transparency and trust. The cus

Is there a way to change the currency code in a customer order window that was created based on a work order?

Hi,An external file upload to a external voucher assistant and file is loaded and checked. Then when it’s trying to create voucher below error message appearing. “Savepoint EXT_CREATE_VOUCHER never established in this session or is invalid” Parameter Set : 1 - External Voucher Default SetFile template : used a self defined templateSeeking an answer for this issue. Thank You.

Hello We have customer order below. The net amount/base is 186,370.78 CAD  However, the planned revenue in Project Monitoring is 189,839.39 .  Since planned revenue is expected revenue, shouldn’t it be the same as the customer order net amount/base? What is the interpretation of planned revenue if it differs from the order net amount/base? Any inpout/thoughts would be appreciated.  

Hello,We are trying to set up an action who sends an email to the supplier for UNIFORM_PAYMENT_ADVICE_REP report.  Why are the PDF_PARAMETERS all empty ?Looking at:https://docs.ifs.com/ifsclouddocs/24r2/Procurement/AboutEmailReports.htmI do not see anything about the values for Suppliers Payment Advice 

Our customer is facing an issue in IFS Applications 10 related to Payment Reference validation when generating ISO20022 payment files.For ISO20022 payment files, they need the Payment Reference (not the Invoice Number) to be populated as remittance information.To achieve this, they have set the following:Company → Invoice → Supplier Invoice Validation Method = UsedHowever, Once Supplier Invoice Validation Method is set to Used, IFS enforces validation on the Payment Reference field in the Manual Supplier Invoice page as the validation allows only numeric values.In order to bypass this validation, they have also enabled “Do Not Validate Payment Reference" option at the supplier level > Invoice > General. But it does not seem to work.Is there any workaround or configuration that allows alphanumeric payment references without disabling the company‑level validation?

Hello,We have a situation where an invoice was booked to a prepaid account in November 2015 and amortized using period allocation vouchers over the next 2 years.  The company currency is CAD.  The manual voucher to book the prepaid expense and the period allocation vouchers were booked with USD currency code.  The manual voucher shows USD in both the currency code part and currency code fields.  The period allocation vouchers show USD as the currency code but the currency code part is blank.  Even though the overall balance in the account is zero, because there is a debit balance in the account with USD currency code part and a credit for the same amount in the account with a blank currency code part, the account with USD balance is being revalued every month. Has anyone seen this before?  Is there a way to fix this is the system

We have a company in France that invoices customer project using AD invoices for pre shipment.When the goods are shipped, we create a CD invoice and show on the document the related payments for the AD invoices, leaving a remaining total to be paidFor the remaining total we use the instalment function on the CD invoice to create the payment “stages”. The issue we have in France is, we cannot set an instalment payment date greater than 60 days from the CD invoice date, this is legally not allowed in France.As a workaround, we cancel the CD invoice and manually create II invoices with future dates.We are happy using AD and CD invoicing and do not want to move to staged billing. Has anyone experienced this issue?I was thinking of trying manual customer invoicing instead of II invoices, would they still be connected with the customer order and project?We also have the issue of E-invoicing becoming mandatory in France

Hi IFS Community, This request relates to how cash discounts are applied.Currently, we have customer agreements that offer a 1% discount if payment is made within 10 days. This discount is intended to apply only to parts, not to freight charges. However, when payments are processed, IFS calculates the discount at the total invoice level, which includes freight. As a result, the discount is slightly overstated on each invoice.To correct this, the discount must be manually adjusted on an invoice-by-invoice basis, impacting approximately 300 to 500 invoice lines each week and taking about three hours to complete.Ideally, we would like to configure IFS so that the 1% discount is applied only to part lines and excludes freight charges. This would ensure that payment amounts match invoice totals accurately and eliminate the need for manual adjustments.Is it possible to achieve this in IFS Apps 10 IEE or IFS Cloud without requiring a system modification?

Hi there!We are trying to post a cost entry via a manual voucher/project transaction (Eg: Against the project activity sequence JJ). We need the sales tax amount of the manual voucher/project transaction to be reflected under a separate project activity sequence number (Eg: Against the project activity sequence JJ2) in the COST tab of the project monitoring.For example, if materials worth $500 are consumed and a 10% sales tax is applicable, the material cost of $500 should be posted against the JJ project activity, while the sales tax amount should be posted separately against the JJ2 project activity.We would appreciate it if this requirement could be achieved using standard IFS functionality, preferably without moving toward a customization.Your support on this is highly appreciated. Thanks in advance!

Hello.I would like to import by external file a french standard bank statement for the bank reconciliation.As I have a treasury software, I got the following file (see blow) with the format CFONB120 (CAMT) and I don’t know how to setup my external file in IFS to read it correctly. Could you help me to setup it or send me an example as I suppose I’m not the only person which receive their bank statements by Ebics in a treasury software. Thanks in advanceRegards

Hi Community,A customer has changed their Financial year from July (July to June) to January (January to December). Due to this reason, in accounting year 2023, they have had a 18 month financial year. In IFS, for accounting year 2023, the periods start from July 2023 and goes till December 2024. Accounting year 2024 starts from January 2025 and goes till December 2025. Therefore, the accounting year and accounting periods have a misalignment.Customer wants to get the accounting year and the accounting periods aligned starting 2027.Therefore, accounting year 2026 has been created as follows.  Having only 1/1/2027 as the year opening and closing dates. Then accounting year 2027 as follows. Validity periods starting from 2/1/2027.

We are moving from IFS APPS 10 to IFS Cloud this summer.  The Report Generator is not available in IFS Cloud.  How do you run a trial balance in IFS Cloud?

Is there a solution in IFS App10 for new France CTC requirement?

We currently use IFSAPP10. Our business model has changed, and we need to change period 6 June from dates 06/01/2026 - 06/30/2026 to 06/01/2026 - 06/15/2026, however we have several X voucher transactions that have posted in period 6 with voucher date 06/01/2026.  Due to this I am unable to change the valid period date from 06/30/2026 to 06/15/2026.  I have read that an end user cannot change a period date once a transaction exists within the period, can this be overridden by a script?  Or does anyone have another solution?  

Hi, We are using IFS app9 and we have a scenario where the inbound e-invoice fails when supplier send e-invoice in a foreign currency.Issue triggers when <VatCurrencyVatRateAmount> tag appears in the XML.Application message is failed with error 'Cannot calculate tax amount in accounting currency because the exchange rate is not found.' Does anyone has had a similar issue ? Please let me know if you know how this can be fixed.Thank you!Kind Regards,Ashwini 

We created an advanced invoice (voucher type I). Which debits Prepaids and credits AP. Then we paid this through our normal payment process (voucher type U) which relieved the AP. However, in that process we also matched the advanced invoice to this payment transaction. So it also reversed the original entry by debiting AP and crediting Prepaids. So there is a debit amount left in AP but the invoice shows as being paid creating a difference between the subledger and trial balance amount in AP. How can I reverse that matching of the advanced payment, so I can apply it to the final invoice that’s due?

​ Hi Team,I am exploring Capture Supplier Invoice Data functionality (which works like an OCR tool) from the screen Capture Supplier Invoice Data in IFS Test env wherein I am getting error. Refer attached document for error message.Has anyone faced this error? If yes, then how did you resolved it? Request you to assist.I have enabled below parameter as a prerequisite for above functionality - ‘Capture Supplier Invoice Data using AI’ at Company screen. 

Hello I accidentally ran final year end so the year end entry was posted. There are still periods open since we have not finished the fiscal year. Is there a way to reverse the final year end posting? Can I just go to the posting then cancel it? Any help would be appreciated.

Hi,We have just installed the latest SU9 service pack for IFS Cloud 25R1. This service pack introduces functionality to support the new JPK‑V7M3 structure. However, I have not been able to find support for the replacement tags (BFK, DI, and OFF) within this structure, which are required when an invoice does not have a KSeF number.Am I missing something, or is this functionality not yet supported? If so, this would mean that the current structure is not fully compliant with the legal requirements.