Finance (Financials)

Dear all,why is it possible to connect a Finished Work Task No with a supplier invoice?The Invoice will be shown in the Cost Tab:  But not in Tab “Sales”:We work with IFS10 Update 13 Best regards,Linda 

Hi All,I don’t think this is a new item (i.e. GL Balance Analysis in Aurena | IFS Community) but has come up a few times from end-users since our go-live.In GL Balance Analysis the Account column is merged to include the code and name as well as a hyperlink to the record. This is great for UI navigation but causes challenges to users who like to export data to review.A simple solution to this would be to add static columns in the column selector for these fields (i.e. Account Code” & “Account Name”)Ideally I would like to see this as a common standard practice across IFS Cloud tables. Is this a possibility? 

Hi all, Appreciate your help on this matter.Do you know if there are any limitations in using ‘External File Assistant’ in Aurena for transferring data which includes letters from Scandinavian Alphabet like å, ö and ä..?The issues faced are:When transferring (input) data, the transferring does not happen right and the letters from Scandinavian alphabet transfers as ‘?’.  When transferring (output) data with External File Assistant’ in Aurena, row data is not been transferred into the right columns. The language is set to Finnish at company level and the issue is replicated when logged in English as well as in Finnish. The issues are not replicated in EE client, but only in Aurena. Anyone who has an idea? Thank you in advance :)  

we try to create  Manual supplier invoice for supplier 202147 in company 101 and the Po related to company 111.after matching system displayed the below error entering invoices for the same supplier in company 101 and  Po related to other companies (NOT 111) is working without any issueplease advice.

Hi,WHT is not applied when customer order invoice is created. Invoice is for 1000$Customer paid us only 980$ after withholding tax of 20$ ( 1000$ x 2%)What is the process in ifs to process customer payment of 980$ along with WHT of 20$? BR/Dinesh

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!

It looks like I cannot see the highlighted option in our APPS10 instance. Any special security settings required? 

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.