Finance (Financials)

Hello,We have a situation where a customer overpaid on an advanced invoice.  The payment was applied in a prior (closed) period.  We have refunded the customer but are not able to offset the 2 transactions (overpayment and refund) due to the below error.  Please advise how we can offset.  I have tried a mixed payment entry, customer offset, netting screens, etc…  

 We have Created a new Report Layout and under the Reporting Rule we Setup the New layput as Default layout when printing the Instant Invoices but When Printing Manualy it take Correct LayoutBut When we use Send Invoice Function , it send old report Layout,How to set Default invoice layout when we send invoices in IFS CLOUD       

We are unable to use workaround solution with big JPK_KR files. We applied all steps from provided document (to use Talend Open Studio for Data Integration), unfortunetly when we want to passthrou file ~15GB company 1100, year period 202306. Application getting error. (Java heap space). We was trying with different values of -Xmx parameter but without result. How can we use workaround solution with big files?

Hello, We have supplier invoices dated 31/01 however the invoices are being pulled in for payment at the end of March instead of the end of February with the payment terms of 30 days end of month due to there only being 29 days in February this year.Is there any rule that can be created to capture this and automatically change the payment date without it being manually changed? Thanks.

Hi, I am trying to set a RIGHT TRIM function in an external file template (bank statement), but it doesn’t seem to work when it is set according to the template shown in the LOV. My objective is to pick the first 100 characters of the uploaded field.I get an unpack error as below“ExtFileFunctionHandler.VALUEERROR2: Value error on column no TRANSACTION_INFO1 function no 10”  Any idea how to set this function detail? This is on Apps10 Upd13Thank you Pamith

Hi IFS community,I am using IFS version 8.I received an inquiry from our finance team regarding GL year end closing balance and opening year balance. Need your advice on below inquiry:After transferring the year end closing balance (2023) to new year opening balance (2024), should there is a need to perform adjustment to year end closing balance (2023), will the adjustment made reflected automatically to the opening balance (2024)? If the above is No, how should they complete their year end balance (2023) adjustment and make sure the opening balance (2024) is reflected correctly (after adjustment balance)Thanks,Mirza​​​​​​​​​​​​​​

How can I recreate a Positive Pay file? Where do I uncheck the field “Positive Pay Created? I am testing new file layouts but once I run the process I can’t uncheck. Thank you.  

Hi all,We have an IFS Managed App10 customer and when creating Payment Order files via Background job process, it requires Server output path/ Oracle directory to be defined which are generally accessible to FTP Admin user only. Due to this end users (Finance users) are unable to obtain the file without the support from IT.It was proposed to setup IFS Connect Mailsender to share it with the users via a routing rule. Is this viable? are we able to obtain any steps/documentation on this?Also are there any suggestions of how similar customer's are generating this file for end users without the support from IT?Thank you for the help in advance.Best regards,Shamalaka Perera

Hi,We are trying to see if there are any out of the box controls surrounding changes that are made to (supplier banking information) that go beyond permission sets.Location: Application Base Setup > Enterprise > Supplier > Supplier (payment tab) --> Right mouse button (Supplier banking details..) Given this is an area of risk i.e a user with access changing supplier details to their own, we want to know what mitigating controls are available.THanks 

Community,We are working fine with M type voucher, but when we are uploading external Q type vouchers, I encountered below error, does it mean external file in IFS only works with M type voucher?  Thank you.

Hi all, Is there a list of all standard interfaces available in IFS please ? 

Dear All,In standard IFS, is it possible to configurate as mandatory the connection to a financial project when creating a task from a work order. If I create a task from a work order (not linked to any order at that point), I can click on release/work started/work done without filling any financial project. If someone knows if it is possible as standard IFS to configurate it, I would be glad to hear from you !ThanksLaurent 

Hi,  Can these 2 questions be answered if anyone in aware please?Can we re print a printed BOE? Can we re pint a cashed BOE?Thank you

Hi All, Can someone please tell me how to use the function Period Allocation in Manual Supplier invoice as when I clic kon the box of Period Allocation it doesnt mark it. Even when I create a line with the account and Cost Cent it doesnt allow me also nothing when I do RMB on the line it doesnt pop up. Even in Posted Status it doesnt work. Is there some step by step setup guide to get this working? We already created voucher type X in all the periods for the year etc.  

Hi, We are interfacing the AP invoice from third party system to IFS (Manual Supplier Invoice), while interfacing the PO connected invoice .  The invoice is not getting created in IFS. it shows error at interface log as “You are not allowed to use ledger account!”. however the AP accrual account is used in automatic posting on PO connected invoice to post the entry. the AP accrual account is marked as “ledger account” in account master.How to resolve this.? 

Wondering how users are reviewing/auditing the Payment Orders ?Old school was a stack of invoices attached to the ACH total page.In IFS I can see all invoices on Payment Order items,  but doesn’t appear to be any right mouse buttons to take you directly to the supplier invoice to look at the attached document (invoice)

Good morningDoes anyone know what the underlying view is, used in the standard ExtPosPayCheck external file type?

Hi,I am currently going thru a year end audit and don’t know the answer to the following question: What is the difference between the following 2 business events with the same description? Thanks … Mark

One of our customers have opened a Joint Venture in India and states that there are compliances India related to where the backups are been held - "In order to comply with Indian Company Regulations the back-up of the books of account and other books and papers of the company maintained in electronic mode, including at a place outside India, if any, shall be kept in servers physically located in India on a periodic basis."Do we have anyone else out here with similar user stories addressing this concern in their current practices? Specifically looking for cloud hosted customer user stories.. Is this something considered on India localization?

Dear all, the IFS standard setting is that the currency rate will be taken from the invoicing date. As we are handling projects the relevant date is the handover date and not the invoice date - it is not possible to create the invoice on the same day as the handover takes place.We are not allowed to create invoices which are dated back in the past (this will be claimed by the external and internal auditors). Example, we received the handover protocol on 05/01/2023. We already made the tax reconciliation/reporting for january so we closed the period already.The correct currency rate would be the rate from 05/01/2023 but it’s not possible to change the rate directly in project invoice. How should the data set be modified in order to have the correct scenario shown in IFS?How do you handle this scenario.Thanks for your response.BR Linda  

One of the customers is facing challenge with balancing the posting proposal of manual supplier invoice, due to header currency rate is not the same with posting information line currency rate.Error message ID: Accounting Currency not BalancedError Details: Net amount in accounting currency ####.## does not match with posted amount ####.## in accounting currency SEK. This line currency rate cannot be manually edited and only relevance of this currency rate is that it is the rate on original created date of the attached invoice. But the customer has not ticked the “Use File Transaction Date as Voucher Date checkbox” in external supplier invoice parameters window at the time of voucher creation. Please help to share your ideas and any known reason/solution for this issue. Thanks.

We have a number of customers who utilise staged billing and have found that once invoiced a staged billing line cannot be backed out and changed. This is surprisingly common in many industries and requires some very unusual workarounds and fudges. When an invoice is cancelled we think this should reset the staged billing line so it can be edited.

Hello,  I need to create manual customer invoices with a ledger account at manual posting. Is there a way to do that ? I tried through manual voucher wich is impossible too. How is it possible to override this limitation ? Best regards

If you have supplier payments without a tax transaction being created, how do you add them to the automatic tax proposal for 1099 printing?

We are using the cloud based version, and running 1099’s to test and noticing the NEC form is only printing two per page, and not 3 like the standard is. Guess I’m wondering when it will be updated to 3 per page or if I’m going to have to do it by hand this year? Approaching a week before postmark due date!