Finance (Financials)

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? 

Hi,The customer has defined a new wage code parameter however, this is not appearing in the payslip. These are the steps followed by the customer:• Define wage code parameter • Defined new wade code class and added the posing control P12 which is connected to the account code.• Defined Wage code ID, RMB – Formulas and connected to wage code Parameter• Added wage code parameter to the Deductions Wage code. Are there additional steps required for the newly defined wage code to appear in the payslip. If so, can you kindly provide these? Many thanks!

Dear Community, we would like to set up the Finacial Project Numberseries like that:First Number HRL0000001, next number HRL0000002 etc.This is the set up in IFS  It is not possible to start with leading 0000000, IFS is formatting it to 0. So if we create the first project with that number series it comes with HRL1 instead of HRL0000001. Of course we could set up series with HRL1000001, that would work. Question is it somehow possible to set up like requested with leading 0 values HRL0000001?Thanks!regardsSebastian

I have a client that would like to perfom the currency revaluation on their Income Statement accounts using an average rate for the month.  They plan to only enter rates once per month at the end of each month.  I created a new currency rate type (calling it average) that I was going to use for these accounts.  However, It appears that only Assets and Liability accounts can be revalued in the Accounting Currency (see below for message when entering a Cost account)  I have explained that IFS captures the rate as of the transaction date so the revaluation of the income statement accounts would not be needed if rates are entered daily, but they prefer to use the method they currently use, which is converting the Income Statement using the average rate for the month. Has anyone run into this issue or have any suggestions?  

Dear community,my colleague created a new company with the assistant. He got the following error message because he didn’t had the permission to see the company creation logs. How can we see these logs?  

Dear Experts,Kindly let me know the steps to resolve the errors in the ‘Create Company Log Details window’ while creating a new company?  

Community, would you please share with me the Cost Rollup Procedure and Working Instructions? We are implementing multi-site BOM, and the cost need to be rolled up to the final product site. Thank you.

Hi Team, Is there any provision in IFS10, to perform batch cancellation of Mixed Payments?As we know, we have provision in Mixed Payment window where we can RMB->Cancel for cancelling an individual Mixed Payment.But, lets say I want to cancel 50 Mixed Payments at once do we have any feature in IFS10 where we can perform batch cancellation of Mixed Payments? Thanks in Advance. Best Regards,Rakesh

Dear All, I'm getting this error message when we run the scheduled database job for the work orders. Value is missing or has an invalid time interval for posting type T3 control type C54 code part A in company ***.       ORA-20105: PostingCtrlPublic.POSTERRMSG    I checked the posting control settings. All the  settings are done. Work order status is finished but the css posting states as CSS not posted.Even if I run the background job again still I get the error message. Kindly please someone help me.