Finance (Financials)

We’re looking to facilitate passing the PO number from Customer Order through to Avalara for assessment of project-specific customer tax exemptions.Has anyone done this on Cloud before?

Hi all,A quick heads-up for anyone on IFS Cloud 26R1 (we're on SU3, Oracle 19c). After the update, Account Matching took minutes or showed no data, even for small accounts.Cause: the SELECTs on GEN_LED_VOU_ROW_ACC_MATCH behind Account_Match_Handling_SVC.Do_Add_Transactions (SQL_IDs 17tnfdbgpmvtp and 5zxp5phtpx2du) sometimes pick a plan that reads every voucher row of the company via GEN_LED_VOUCHER_ROW_IX7, instead of going through the account's posting combinations via GEN_LED_VOUCHER_ROW_IX4.Fix: our DBA pinned the good plan with a fixed SQL plan baseline (DBMS_SPM) and purged the cursors. The average call went from 3–7 minutes to about 40 s, and total time dropped about 90% on the same number of calls.If you see multiple plan hash values for these SQL_IDs in AWR, it's worth checking. Has anyone else run into this, or raised it with IFS?Jan

Following a go live onto IFS Apps 10 for a part of our business that uses composite (mixed goods) tax codes we are experiencing issues with our Tax Proposal process.  Due to the number of tax codes set up (approx 2000 codes ranging from UK0000 to UK2000) the standard UK Vat Return template (S089) was amended to use selection based on Tax Subgroups.Up until this point the tax proposal was completing and capturing all tax transactions for the period specified.Since this change and the increased number of transactions the tax proposal includes transactions up to UK0567 and then stops.This leaves all other tax transactions unconnected to a tax proposal.  This happens regardless of the number of transactions (which varies from 58,000 to 143,000 per month).  We are currently running monthly tax proposals. This stop at the same tax code has happened consistently for several months.We have checked:Tax codes are mapped to the relevant tax subgroups (Tax template field control) Tax codes are map

The Polish e-invoice xml files do not include lot batch numbers. The lot batch number is mandatory on sales documents for seeds. Please see the attached relevant documents:1. Regulation of the Ministry of Agriculture and Rural Development2. the Seed Act of 9 November 2012  Under IFS Case CS0568311 IFS have said they will deal with this as an enhancement and produce a fix for 2027.  It had been previously reported to IFS via Case CS0519575 but was rejected so I tried again with the new case (this time it has been accepted).However, the issue is current and 2027 is too vague a date for a solution.Is anyone else facing such an issue?IFS referred us to IDEA ‘IFS UBL eInvoice Missing Lot Batch No’ however that is re Sweden and we need to ensure that Poland is included and in a reasonable time frame for our business.

Hello Everyone, We are currently in 25R2 SU5 and using the intercompany invoicing functionnality to issue invoices from one company to another. The flow is working fine with MHS setup in Message setup screen/table.  BUT, the problem is that the attachements generated from the invoices (project invoices and instant invoices) are not correctly retrieved when the external supplier invoice is created from supplier side.It was said that the SU10 would solve the issue by adding the attachement in supplier invoices analysis screen;  but it still subsists.Did one of you already encountered the issue and would know what setup it would require, if any ?  Thanks a lot for your help ! 

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 everyone,I have a quick question regarding the matching of customer credit notes.When I issue a credit note from an invoice, it is not automatically matched with the related invoice.- Creation of a credit note :  The credit note appears as unmatched in the customer analysis screen :  I have to perform the matching manually in the customer offset :Is this the normal/standard behavior, or is there a setting that allows the credit note to be automatically matched with the invoice?Since I created the credit note directly from an invoice, it would be logical for it to be automatically matched with that invoice.Thank you for your helpRegards

Hello,I’m currently encountering an issue when importing external payments of the transaction type “Direct cash trans.”Although the pseudocode is correctly configured, the project activity ID is not coming through during the importHere’s what I’ve verified so far:    •    The payment method has been created with an active connected identifier.    •    The definition of identifier is properly set up (see details below).    •    The pseudo code is correctly configured to retrieve the following elements: local account, project, and Activity Project ID.When importing the file, both the local account and the project are correctly recognized, but the Activity Project ID is missing from the import result.Please find attached the import file and the External File Template (ExtMixedPayment)  Has anyone encountered a similar issue or could provide any guidance on how to resolve this?Thank you in advance for your help!

Hello Community,We are getting ready to jump from 25R1 → 26R1 shortly and I wanted to see if anyone has had any issues with the Italian E-Invoice XML file changing formats at all. Or in any other way not working with Pagero?

Hello,My customer is using 25r2 NGSM / Request ManagementHow can the “Delivery Address” default be controlled on the resulting customer order when a Request Contract is invoiced?In our testing the customer has 3 addresses, each address is set up as follows:Of the 3 Delivery/Visit addresses the resulting customer order is showing the “first” address, sorted by Address ID.We are looking for a way to control which address is used as the “Delivery Address” on the customer order. FYI…  Customer has 2 additional addresses both defined as ‘Document’.  None have defaults set. 

Trying setup to Email the PaymentAdvice , get this unusual error. Any one knows what this is about? 

Hi All, Supplier invoice posting authorize substitutes does not work with Group . I am able to add substitute to authorizer id but when the Substitute go for authorization it does not allows to authorize the invoice. In PO it works. Regards, Mukesh Gupta  

Hello,We are looking to optimize the processing time of the IFS_GENERAL_LEDGER Tabular Model.Currently, the GL ANALYSIS table is configured in IFS with a single PARTITIONFULL partition using the FACT_TRANS_BAL_SET_AM_CONF data source.The SQL Server data load is already incremental, but the Tabular processing still processes the full GL ANALYSIS partition.We would like to partition GL ANALYSIS by accounting_year_key, for example:Partition_2024Partition_2025Partition_2026and process only the current accounting year partition regularly.We successfully tested this configuration directly in SSAS TEST. However, we cannot find a way in the IFS Cloud configuration to add multiple partitions to the existing GL ANALYSIS table.Could you please confirm whether multiple partitions per table are supported by IFS Analysis Models - Tabular and provide the recommended configuration method?We would also like to know whether creating these partitions directly in SSAS is supported or if they could be over

HiDoes anyone know why the tax amount is showing as zero in the Tax Information tag in the SAF-T XML file?This issue occurs for all tax transactions, with the tax amount consistently showing as zero. Could this be related to a configuration or setup issue?Thank You  

Hi I would like to modify / correct the statement number generation in IFS cloud when creating new mixed payment from external payment function. Today i got incorrect numbers but i can not find where this is set our how. I believe i have seen it before but now i can not find it, any proposals?  

Hi Finance experts,I am trying to export an External File Template using External File Assistant but cannot see Parameter Set 2 which is probably the option for export.Any idea on how to set this up so that I can change file direction as ‘OutputFile’ and then export an External File Template?  

A specific requirement from a client is to involve the activated Authorization Assigning Rule in the Posting Proposal and the status of the same to be “AwaitAuth” where the Finance users will authorize the invoice postings based on the code part combinations in the assigning rule.However, the Posting Authorization is set to “Automatic Authorization” in the PO Matching in the company setup. Due to this, all the PO based invoices are receiving a status of “Auth” in the Posting Proposal and the assigning rule is not being considered.The reason for this requirement is to validate those invoices where expense accounts on which period allocation is required are reviewed by Finance Manager before approval and voucher creation and all other invoices to go directly in “Auth” status and can be posted by finance users without any authorizations.Is there a way to include the assigning rule in the Posting Proposal and the status of the same to be “AwaitAuth” by not changing the company setup?

 HelloWe have a customer requirement to have project pre-posting enabled on the M65 form.We would like to understand how project pre-posting can be included in the M65 form using the standard configuration. Is it possible to configure the standard settings so that the “Pre-posting” field is set to “Yes” by default for the M65 form? Could you please confirm whether this can be achieved through standard configuration, or if any customization is required? Thank you for your guidance. Pre posting for Project ID 80001  Purchase order with charges When I invoice a purchase order that includes charges, the project pre-posting does not appear on the M65 form Can you please help me?

Title: IFS Cloud – Duplicate rows when joining GEN_LED_VOUCHER_ROW_QRY with Customer Order and Invoice dataHi everyone,I’m working on an SQL query in IFS Cloud that retrieves data from the Analysis Rows – GL (PK/KG) view, using GEN_LED_VOUCHER_ROW_QRY.After adding this view to my existing query, some rows are duplicated. I suspect that I might be missing a view or a proper join condition that links customer order lines to the corresponding General Ledger analysis rows.My query joins CUSTOMER_ORDER, CUSTOMER_ORDER_LINE, invoice-related views, customer ledger information, project data, and finally GEN_LED_VOUCHER_ROW_QRY.My query:select glvrq.voucher_no,glvrq.row_no,glvrq.internal_seq_number,glvrq.trans_code,glvrq.text,glvrq.quantity,glvrq.currency_amount,glvrq.amountfrom customer_order co join customer_order_line col on co.order_no=col.order_noleft join customer_order_line_cfv colcf oncol.order_no=colcf.order_noand col.line_no=colcf.line_noand col.rel_no=colcf.rel_noand col.line_item_no

Hi How can access be restricted so that users only see Suplier invoices permitted by the Authority Class rule? Or is there another place where access can be restricted so that not all Supplier invoices are available to all users?Br Kerstin

HiWhen receiving an External Supplier Invoice with Zero or no amount in Tax amount, the functionality in apps 10 used to be, that the Tax free Tax code is fetched instead of the Tax Code. The same functionality is described in IFS Cloud field description. However, we do experience, that the functionality does not work after upgrading to IFS Cloud. Are there any other parameters we must consider, are the functionality changed or is this a Bug?    Regards Brian

Hi Community,I am looking for advice from anyone with experience implementing IFS for Italian companies reporting under OIC.We are currently reviewing the treatment of inventory purchases and statutory reporting requirements, specifically the relationship between:B6 - Purchases of raw materials, consumables and goods B11 - Changes in inventories of raw materials, consumables and goodsWe maintain two ledgers GL for IRS and the IL for Local GaapFrom an IFS perspective, inventory transactions are typically processed using the standard inventory posting framework (M1 Inventory, GRNI, AP, etc.).My questions are,Has anyone implemented separate local-GAAP ledger adjustments to satisfy OIC requirements while retaining standard IFS inventory accounting? How do companies typically handle the month-end and year-end inventory adjustments? Are there any recommended design patterns or lessons learned from Italian IFS implementations?We are trying to understand the most common and audit-friendly appr

have an order, which is status received.  Is on the correct company/entity, receipt isn’t matched to another invoice and I cannot see an error on the posting lineWhat other possible reason would there be for this not to pull through?

Hi Community,Has any of you come across this issue?

Hi all. I have a client (with IFS Cloud 24R2) that send by email, automatically, the invoices. We have set up the Sender email and it is working.The problems is that when the customer click the “Print Invoice”In this case, the system has to create the pdf (Report Design) and send it by email automatically. But, suddenly, this process stop working (we do not if anything in any server was changed) But, from that moment it is not possible to send invoices. We do not know if it’s something related to Print Agent….The status in Print Manager screen is always “Remote Waiting” and the printer is “No printout”.Any idea???? We have a serious problem!!!!