Finance (Financials)

I want to find the user who has created the manual suppier invoice.  Is there any way to find it through the sql query

The following changes in the output of the German Intra Community Sales Report (ZM) will be applicable: CSV Header Update (Version) VAT ID Output Clean-up (Zusammenfassung Länderkennzeichen und USt-ID New Country Code (Nordirland 'XI')  The changes are applicable for the following IFS Cloud/Applications Versions: 24.2.9 - 24R2 SU925.1.3 - 25R1 SU325.2E.0 - 25R2 EAAPP10UPD29 Encoding changes from ISO-8859-15 to UTF was already covered in IFS Applications 8 and is default in IFS Applications 9 and IFS Cloud.

Hello Comminuty, I have been trying to get multiple external payments created for different cash accounts (multiple currencies) through the same CAMT054 file with no luck. Receives the following error: ExecutionException from Sender thread Caused by: ifs.fnd.connect.senders.ConnectSender$PermanentFailureException: ORA-20124: Error.NULLVALUE: Field [LOAD_FILE_ID] is mandatory for Ext File Log and requires a value. The file contains 3 notifications for EUR, USD and SEK iban numbers. Is this not supported by us or are we missing something in the configuration? When I remove the rest of the notifications and try the same file with a single notification, it works and creates an external payment for the relevant cash account.   Appreciate if someone could assist to confirm if this is supported as the customer is currently receiving this from their bank.  BR!  

Since the new SAF-T Financial schema, v.1.30 comes into force, we are unsure if there are new set ups required in order to create a file corresponding to requirements for 1.3 version. Can anyone please provide the documentation of how to set up SAF-T version 1.3 NO in IFS.

Hello,I’m trying to create an IFS Business Planning structure with multiple entities.We have numerous companies, each with different reporting currencies.I would like to create a planning unit for each company. (e.g., plan in local currency for each company, and consolidated to reporting currency USD)How do I best structure this? 1) Do I create a planning unit in each company? or2) Do I create planning units in one company and link them to the Business Plan? (But can’t import General ledger from each company)Any help is appreciated.Thank you!

Dear All, IFS version:  IFS Cloud. I have an issue with Supplier payment. The payment has been done to the supplier and it is been reconciled with Bank statement. The invoice stands Paid Posted. After about 10 days the bank informs us that the supplier payment has been failed due to their bank account closure. Upon reaching out to the supplier we were advised to pay to a different bank accuount. Now I would like to know the process of cancelling the previous payment so that my invoices status would put back to Posted Auth and repay the supplier to correct bank account. We have corrected the bank details at suppier level, now we want to proceed with repayment. Appreciate your valuble time and suggestion. Kindly note that the payment order has multiple supplier payments, we do not want to cancel the entire payment order in Mixed payment.  

Hi,We observed that the debit values when creating an invoice differ from those when creating a credit invoice.Debit Invoice example - Credit Invoice example (Note - The Credit Invoice is created through the ‘Invoice Plan Detail’ window) -Below is the Excel Output of the Invoice Plan Detail - Line No and Unit PriceCould you please clarify why debit invoices display values consistently up to two decimal places, whereas the decimal values in credit invoices vary?

Hi Experts, I’m looking for guidelines on whether we can define period allocation fields when loading an external invoice, the standard template doesn’t have a dedicated field to do this, which I assume the expectation is to do the period allocation only after the invoice is there in IFS.

Hi All We got the CIS verification working when we were testing the connection in our Cloud upgrade however since going live we have not managed to connect to the HMRC live database to do the verification. I have followed all the documents i can and i have been told that the incorrect site is listed in the routing rules so i have also updated that to the live database but i am still getting an error wen trying to do a test transfer. The error references the handshake being cancelled from HMRC and i can only guess we are missing a certificate or something of that form.  has anyone got this working and have some tips. 

Dears, I need Support on “Acknowledge Supplier Payment Orders”  screen: -- The Postings are triggering multiple BANK entries with the same total amount of the Payment Order-- And putting the balance in FX loss.-- The voucher type is U voucher.-- EVEN USING SAME Company currency with rate 1 - same issue I checked posting controls are correct ..(if we use N voucher then is correct).PLEASE SUPPORT TO USE THIS SCREEN AND HAVE A CORRECT ACCOUNTING IMPACT.thank you 

I was wondering if any other IFS users have a checklist for new company creation in IFS. I do have access to the activity diagram in F1 help, so it’s not what I am looking for. Looking for more from the business perspective to read through a checklist. Thanks!  P.S. Not sure if I posted in the right forum, please move if not. 

When I use Project Progress as a POC Method on the Financial Project Revenue Information tab, together with the Project Progress Method as Cost Based, I get 0% POC Current Period on the Revenue Recognition Log even though I have 71.43% Cost Progress on the project. What else is influencing the POC Current Period ?  Is there any documentation on how this is calculated? See the relevant screenshot below:Financial Project Setup: Progress on Project Monitoring: Revenue Recognition Project Log: 

Hi,I have a design question related to credit card integration and EDI invoicing, trying to get input from this forum as well. We have our own web shop, where customers (both B2B and B2C) can order parts using a credit card for the payment. (We do not use IFS Credit Card Integration, nor do we plan to do it.)When creating an order in the web shop, the web shop makes the initial authorize/reserve payment amount towards our Payment Provider based on the order amount. All verification and encryption is done from the web shop communication with our Payment Provider.The order is then passed onto IFS as a customer order and via order attributes, we store the payment provider reference in IFS (i.e. no credit card information is stored in IFS).Then, using IFS standard flows for processing the order, we would like to trigger the payment amount (“capture”) based on the actual delivery (and amount delivered), which means we will also generate an invoice per delivery. For these orders we plan to g

Hello Community,Does anyone know how to do write off using customer offset proposal with offset type Manual?As per ​@IFS RD Product Management , it should be possible but i cannot find proper fields. Write off code, write off amount and write off description - Missing in Cloud | IFS Community   Mixed payment with Net AP/AR is not possible either. if I enter 0 in Pay Amount and just enter write off amount then remaining balance automatically entered in Pay Amount. If i change pay amount to 0 then write off is cleared.  How to apply a partial write off without any payment as in IFS10? ThanksFurkan

I have someone that wants a background job to...not be a background job? I don’t really know why. Has anyone done this?

Hi,When creating a New Supplier Payment Proposal, it is including suppliers with the incorrect payment methods.We only want suppliers with BACS payment methods, but we need POAs included.IFS is picking up POAs on suppliers that do not have the BACS payment method.Is there any other parameters in the background that would need to be set to prevent this from happening?This worked correctly until we installed an update on our IFS system.Thank you,John

Can anyone provide me information on how to modifiy the existing Operational report definations (RDF) in IFS 7.5 ?The requirement is I need to add new field to the Invoice report. (IFS report designer report) Thanks in advance! Regards,Mahendra

We’ve successfully set up the expenses module in the HCM, and it’s functioning as intended. The challenge lies on the Finance side, specifically with allocating expense payments and managing posting controls. Ideally, we’d like to assign each expense to the employee’s name or ID number, but there doesn’t appear to be an option to bulk add employees — they have to be added manually one by one. Is there any way around this? We want to avoid having to add/remove an employee every time there is movement within the workforce. 

Hi,How is the Payment Schedule for Purchase Order used in the best way for Finance? When creating a New Manual Supplier Invoice you receive a warning when saving, that there is a Payment Schedule for the Purchase Order to match with the invoice. For External Supplier Invoices no such warning shows up and the invoice was created without matching with the payment schedule.           Is it not possible to get the warning in External Supplier Invoices or did we miss any setup?(IFS Cloud 22R2)Thanks in advance for your input!

Using External Voucher Assistant to create Q entries.Everything works great except need to change the Voucher date and unable to change date get the following error:Voucher date cannot be modified for automatically created vouchersAny options. 

Hello!Has anyone successfully been able to customize the Printed Bank Reconciliation report? For reference, the bank rec report alone is pretty vague given the standard set-up and I would like for it to show cleared checks along with outstanding checks that were printed but have not cleared the bank yet for the month. Is this even an option using IFS Cloud and if it is, how is it set-up to enable these details?Thank you!

Hi All, Can someone kindly let me know whether we can use the below external file type to load a payment where the loading company is different from the payment company?I couldn't find any field which enables this option in the file type. 

Hi everybody,  I would like to import an external customer payment and match the information with an invoice by creating a mixed payment.  Basic data : Create a template  Create a Payment Format ID ; Create Payment Method and set payment method per institute and external payment parameters When we do that we can import correctly the CSV file and this file will be generated in the path menu External Payments :   When i check the detail i don't have a matching with the invoice and i miss the information   If someone know the setting to do? I think we have some setting to do in the path menu external payment parameters but i don’t know how to do it correctly.  Thank in advance for your reply,  Best Regards,Jeremy

depreciation proposal does not capture one object.I check for the basic data and all look fine and similar to other objects and this  particular object doesn't get included in dep. proposal. and has not depreciated from the activation in 2021.the asset is in active status.        

In Apps 10, using External Voucher Assistant. When the file is loaded the Voucher is set to Approved. How can the loaded Voucher be set to not approved when loading the file?