Finance (Financials)

Dear all, I want to find out how to create a report/overview of AR and AP open invoices per a certain date, split in currencies.When I run standard reports I only get total amounts in accounting currency, where I would like to see the total amount split in currencies as well.

For the operational report customer ledger age analysis standard behaviour of the application is that If an invoice due date is set to 5/6/2021, it will be due on 5/6/2021 (not overdue), therefore the invoice in report will presented as overdue in second column “0-30”. This is the intended functionality of the application which has been implemented back in 2006.My client espect that invoice should be presented in the first column named “Not Due” and te standard behaviour of the application is not acceptable, what do you think about it?Invoice should be presented in first column named “Not Due” Invoice should be presented in second column named “0-30”Below screens are presenting standard behaviour of the application: 

Dear Community, since July 2022 we have to report for Superfund tax for specific chemicals and components in US. Does anybody has recommendations how to treat them in IFS10? Thank you all in advance,Benjamin

Dear Colleagues, Have any one of you implemented E-Invoicing Solution for Supplier Invoicing for 22R1? Could you kindly advice,Set Up Guidelines Integration Tool (Ex - Pagero etc) Current Customers If you have implemented (Especially Middle East) Technical Advice Points Any Other AdviceThank YouBest Regards Ramessh Kanna

Hi This may be a simple one for some, but we don’t have a large knowledge base at our company for IFS system.We are a bit behind on version 8.Is there a way in the system where we can set it up so an Invoice is automatically emailed to a customer once the invoice is generated?All help is appreciated 😊

This is created with reference to LCS case ID - G2298282When creating intercompany eliminations within group consolidation, if the Intercompany elimination rule specifies the same account to “Account From and Account To and Matching Account From and Matching Account To “then the eliminations posting rows are erroneously duplicated.As a workaround, if the elimination rule is not used, transactions will net off to the same account. But this will not create the difference to a separate account as when using intercompany elimination rule. Also, it will restrict the visibility of these intercompany balances in Intercompany Period Balance Analysis.Looking for a suggestion how this requirement of using the same account in inter company elimination is used by other customers.  

Hello! Could you please tell me the process of generating the following reports? (I am new to IFS Financials)1). Laser Check Printing Report2). Pro Forma Invoice Report (Not the Customer Order Pro Forma Invoice)3). Invoice Report Your kind support is highly appreciated!

We have some customers in CA that have a GST tax of 5%.We just did an invoice for 1080 CAD, but tax amount shows at 108 CAD (10% and not 5% as the tax code GST shows).  Error was noticed on the Proforma Invoice, where it was showing: “Taxable Amount” = 1080 CAD and “Tax Amount” 108 CAD.To check it it was just a drop in system, we did complete the final invoice, but that now shows “Taxable Amount” 2160 CAD and “Tax Amount” 108 CAD (which is 5% of 2160, but order is only for 1080 CAD?). But “Sub Total” on the invoice shows correctly 1080 CAD, but “Tax” is back to 108 (10%)? Even on the Customer Order screen, we can see in the bottom of the page that Tax amount is calculated to 10% and not the 5% the tax code says: Anyone have any idea where this is going wrong or if we did something incorrect on the order and/or invoice? Thanks,Michael

We use SEPA payment format. When we pay f.e. 3 invoices, these are paid in one amount to supplier. We want these invoices to be paid separately (so in 3 separate lines on the bank statement). Tried this with “batch booking” untagged, but payment is still done in one amount.  How to setup so that payment is done in 3 lines?

How can we setup a search in the RMA area that will show the RMA’s that are in the ReturnCompleted status but have not had the Credit issued yet?

As a global company, we are trying to eliminate as many separate GL companies as possible but maintain the ability to separate out Financial Statements for Tax Reporting. Any suggested solutions on how to have two separate (views or actual) Financial Statement reporting options on one GL Company?

I am trying to create server columns in with case statements to bucket invoice aging with count.here is the sample of the code: count (case when aging = 1 then 1 end) "current", count (case when aging = 30 then 1 end) "30 Days", count (case when aging = 31 then 1 end) "31-60 Days", count (case when aging = 61 then 1 end) "61-90 Days", count (case when aging = 91 then 1 end) "90+ Days"After I enter the first two in the column section of the data source I get the following error when entering the third and trying to save.---------------------------Validation Error - IFS Applications---------------------------The names of columns 'COUNT(case when aging = 30 then 1 end)' and 'COUNT(case when aging = 31 then 1 end)' must be unique within the first 30 alphanumeric characters.---------------------------[OK]    ---------------------------Any ideas how to get around this?

Hello All,Can some tell me how you can match a CUPOA in USD with an invoice in EUR?The company currency is EUR:Customer invoice in EURPayment on account in USDFor a customer we got the following situation We want to match the invoice with the payment on Account. An offset is no option because of different currecncy.Is ther an other way? Regards,Raymond

A user is getting this when trying to delete lines in the Supplier Payment Proposal:I cannot find where / how to grant this? I have looked through Presentation Objects and Database Objects but cannot find the specific tick box. I have granted ‘Delete’ options in Payment Proposals but User still cannot carry out the action. Thanks, 

Hello, hope this message finds y’all safe and well.Is it possible to create and connect more than one Credit Instant Invoice for the same Instant Invoice?For example, if the Instant Invoice has 5 lines, and I need to create Credit Instant Invoices for two of the lines in different times. Thanks in advance

Currently default grouping criteria is ‘payment date’ . Can this be defaulted to ‘Payment order ID’? 

Hi,I want to create manual supplier invoice with manual date taxe ( the tax liability control date see below have been set): on the invoice I’ve entered the tax and the manual taxe dateI have the error even and the set up is well done , see below Thanks a lot error:  setup ok  

Hi,We have a correction invoice created on top of a project invoice but mistakenly released at 0 (Status is PaidPosted since 0 value). Requirement is to reverse the entire project invoice (project invoice is PostedAuth). So now we are unable to create a credit invoice on top of that project invoice since it prompts below error. This error can be recreated in any Apps10 internal Race environment. We are in UPD16.Could you please advise how can I credit the project invoice totally? Thank YouRegardsNimesh

Following information requested via case ID G2342017. An auditor asked the Finance department for some information. They in turn asked me, but I'm not sure where to find this data in IFS.The auditors want a "static pool" that shows (in a single file) all the company's invoiced sales, credit memos, adjustments, and payments (or any other activity). I thought initially they would want a dump of what's in Customer Analysis, but they want to see each individual payment and transaction. They mentioned that they'd want to see each transaction on another line - like, the invoice for 1000on the first line, a payment for 9000 on a second line, and then a 100 write-off on the third. Obviously, that's just an example. How can I pull this data for them? Does such a thing exist? Apparently they will be asking for this on a semi-monthly basis. I'm happy to pull this out of Oracle if possible, I just don't know where to find this info in IFS. 

Can any one share template or how I can import Journal entries into IFS 9. I have a list of long journal entries I need to pass and it will be nice to have a way to import this into IFS 9 from Ms Excel

Hi All, In Apps 9, can we create a migration job for bulk customer instant invoice upload? if possible please explain the process, as i tried with view names but it is not working. ThanksRaj

Community,can anyone can advise what happened to this supplier invoice? why negative amount is showing up in window Invoiced Purchase Order? is that means the previous match is being cancelled?  Thank you.

Hi All, I'm getting following error in the project invoice.ORA-20105: Invoice.ACCERROR1: Error (The difference in Accounting Currency for the Invoice 2022010001 has exceeded the limit 0) occurred while booking Invoice PJ-CR- 2022010001.Please refer the  screenshots of the company settings for the accounting currency difference. Please advise on this regard ThanksNaadira

Hi Team, I am getting the below error while creating supplier invoices through the external supplier invoice assistance.but the same file I uploaded in the non production system its working fine. Please help. Regards,Na 

Hi all,we want to import salaries to IFS. In our csv file the “currency credit amount” is negative. But after the import to IFS it is positive. Is that the standard way in IFS?And which external file template do you recommend for importing salaries?