Finance (Financials)

Hello,I am new to group consolidation and is working on an implementation. Have one question on consolidation history.Assume my client goes live on IFS on 7/1 (They are on fiscal calendar). They plan to load 20 subsidiary’s GL balance for all 12 months into IFS prior to go-live. They will have one master consolidation company. What is the easiest way to input group consolidation for pre-IFS history?Option 1Load consolidated balance history from legacy to master company only from 7/1/2021-6/30/22 to IFS.In master company start group consolidation in IFS after going live 7/1/22.  Option 2Load GL balance history of each entity from 7/1/2021-6/30/22 to IFS. Run group consolidation in IFS for historical balance each month from 7/1/21-6/30/22.  This is my client’s preference. Option 1 is easy, but no drill down from master to reporting entity on consolidation query.Option 2 will require lots of work but will allow user to drill down from master to reporting entity.Is there any other option I

Hi AllCan anyone help me to identify the exact reason for the below issue. The below error is triggering while trying to match the PO receipts of consignment supplier.  Thanx in Advance Best RegardsRazan

Hi, I’m trying to setup the Historical Rate Consolidation to ensure that certain balances in the consolidation are retained at the historical rate. I have setup the Historical Rate Consolidation page for the accounts in question but when running the consolidation process I’m expecting posting controls GCP23 and GCP24 to be triggered to make the relevant adjustment, however  no vouchers are being created.What setup is required to ensure these posting controls are triggered on consolidation. Thanks!

Is there a report in IFS that provides CTA calculation details per reporting entity in Group Consolidation?When I generate the consolidated details analysis report, CTA only shows the total amount and does not provide the breakdown per entity.  We need to be able to reconcile this number by entity by obtaining the details. Thanks.

We are testing Group Consolidation in Apps 10 and have a couple of subsidiaries that are not 100% owned. One is 90% owned and the other is 50% owned, and both flagged with a Consolidation Method of Equity Majority. When running the consolidation, minority interest is being calculated and posted as per the posting control, but the calculations are not as expected (both are MI profit calculations are lower than they should be).Are there any other factors we need to take into account when setting up Group Consolidation that influence the minority interest calculation?Any help would be great.ThanksDave 

We have implemented IFS10 Aurena Group Consolidation and we confused on the FX rate workings.Does anyone understand the IFS logic to the working of the FX rate applied to periods beyond period 1 when Income Statement period rates is NOT selected and when no rate type for average has been set up.We are confused what rate the system is calculating for Period 2 because it is giving us a rate that is either Period 2 nor average of period 1 & 2.Any advice would be most welcomeMuch appreciatedSheila  

Hi all I have an error when consolidating P1 when you have only completed a Preliminary year end in the prior year.  The error is that the debit/credit balances do not agree. While the year end is in preliminary status the debit / credit balances will not agree, until we run the clearing cost/revenue balances job.  At year end it often takes months before we are ready to run this job while waiting for auditors corrections.   So am I forced to run the clearing cost/revenue balances in order to consolidate? Then again when the final year end adjustments have been posted?   Any thoughts / comments welcome.   Barrie  

Hi team,The Pre-posting values on the project are not copied to Project finance when we are approving the project. Can someone please help if this functionality is not available in IFS10 UPD7?  

Hi, I have a client in IFSAPPs 10 UPD 16 and using group consolidation module. We get two different balances in Consolidation Balance Analysis vs Consolidation Details Analysis. Consolidation Balance AnalysisConsolidation Details Analysis In Consolidation Balance Analysis cuurent period profit moves to the retain earnings and Details Analysis does not show current period balance in retain earins. Any thoughts would be much appreciated. Thanks,Sadeepa

Hi i am looking for an instruction how to do a elimination of interim results. Is there an automatic way or is the elimination fo interim results a manual adjustment? A profit within the same Group must be eliminated. For Example Company A sells Goods to company B for 150’000 EUR. Cost of good sold in Company a would be 130’000 EUR. This means 20’000 EUR must be eliminated during the consolidation. BRSophal

For period 2021-12 I created and adjustment voucher for depreciation of goodwill. When I make an update of opening balance for period 2022-00 via rmb.  the accumulated depreciation on account 1079 is visable in period 2022-00. For period 2022-09 addition depreciation is made via adjustment voucher for period 1-9. When I run consolidation for period 2022-09 the opening balance on account 1079 is not included on account 1079. . Only the adjustment i period 2022-09 is included. Balance on account 1079 is -474366 for the consolidated period 2022-09. Which is incorrect Account 1079 opening balance  2022-00                      -632 488Adjustment A/C 1079 2022-09 ADJ voucher                -474 366Closing balance 2022-09                                               - 1 106  854Account 1079 i a balance sheet account. To me this seems to be an error. Or do I need to handle this in antoher way? I am using IFSAPP 10 upgrade 5

In Business planning functionality, planning entry screen, transaction subtab:- Is there a quick way to delete all transactions lines for a given planning Unit? for the moment I am selecting all the lines manually and then delete them. This is taking some time and energy. - Once Business planning transactions have been loaded using External file assistant, in the case the file is loaded without error, is there a way to cancel the data load instead of deleting all lines manually?

Dear all,We would like to use code string completion to combine 2 code part value to fill in another code part value within IFS apps v10For example, in our case, we would like to be able to combine : account with service to link the combination to another code part valueCurrently we have all these code strings activated in the systemWe would like to fill in automatically the code string “J” (Groupe 2.0) with the combination of “A” (Account) and “B” (Service)Does anyone know if it is possible to use code string completion to do that or any other solution?Thank you 

Hi there,   Anyone implemented and integration to Cantor (https://www.cantor.no/). I believe it is finance related data. Have you used Dell Boomi for this or direct communication? any help much appreciated Best regards/Rajith De Silva

Hello,  I would to shedule a task pour generate a FEC XML.in the first picture we can see a parameter of my reporting.Creation of database task et then sheduling with parameter​My problem is the PATH parameter. I put the output path of my file .xmlWhen i run my task , IFS can’t find the path \\vm-data-grp\bureautique\Extractions\IT i try to make or not the name of xml , same result.Is the syntax good ? I can go to this path too when i’am connected since database serveur. I don’t know why the path is wrong...  Thank you For information i execut this process in the database task.The folder exist :    Info IFS V10 , udpate 5.

Hello, When one user tries to authorize a supplier invoice, they get the following error.  Ifs.Fnd.FndSystemException: Explorer: An Unhandled Exception has occurred ---> System.Runtime.InteropServices.COMException: The requested resource is in use. (Exception from HRESULT: 0x800700AA)   at System.Windows.Forms.UnsafeNativeMethods.IWebBrowser2.Navigate2(Object& URL, Object& flags, Object& targetFrameName, Object& postData, Object& headers)   at System.Windows.Forms.WebBrowser.PerformNavigate2(Object& URL, Object& flags, Object& targetFrameName, Object& postData, Object& headers)   at System.Windows.Forms.WebBrowser.set_Url(Uri value)   at Ifs.Application.Sinwof_.frmInstantAuthInvoiceImage.DisplayImage(SalNumber nImageNumber, SalString sDocType, SalString sDocPath)   at Ifs.Application.Sinwof_.frmInstantAuthHead.frmInstantAuthHead_OnPM_DataSourcePopulate(Object sender, WindowActionsEventArgs e)   at Ifs.Application.Sinwof_.frmInstantAuthHead.frm

The view GEN_LED_VOUCHER_ROW_UNION_QRY, used in a Custom Lobby Data source has a special condition who use a specific Business role. In the view, the condition below limits the access for a user who doesn’t have this Business role:  What is the global impact to give this Business role to a specific (NOT FINANCIAL) user?

Hi,May I know the steps in IFS APP10 for an asset to move from a Capex (Capital Expenditure) Approval process to a requisition / purchase order? Best Regards,Yoshini

Is there any way in IFS to mark in IFS that the invoice is disputed and then it will be reflected in the reports (bad debt, open items) in IFS 9?

Could you please let me know how GRNI report in IFS works? I see in GRNI report invoices which are already paid, however are still reflected in the report. I want to know the details about this report.

We want to create Mixed Payment from External Payments, but it is insensitive, what can be the reason? RMB on the External Payment line for all Mixed Payment options are not sensitive.Rights to create mixed payments is usually granted, I am using IFS_ALL permission set.Any other ideas?Thank you for your help! (Apps 10 Upd 11)  

What is the purpose of this screen?   I can see that I can search and discover any orders without an invoice number (an outstanding sale), but if I populate this screen it appears to give every order that has been raised?   Is there a reason that this includes every order even with an invoice, as this doesn’t appear to suggest ‘Outstanding Sale’?

I am trying to pull a report that shows me all non - AR related cash receipts that would be shown on the deposit slip. Is there a way I can pull this information? I am trying to do a collateral banking report and reconciling between our AR balance and the bank balance. The bank includes everything even if it isn’t AR related.  Thank you!

Hi All - Experiencing an issue when trying to raise an invoice from Customer Order. IFS allows the Invoice to be created - However when calling up the invoice it appears the invoice does not exist. I have checked the background jobs and receive the following Warning - Any advice greatly appreciated. Thank you 

Apps 10Customer Invoice stuck in Printed statusCustomer Invoice Posting Analysis details:ORA-20105: Invoice.ACCERROR1: Error (numeric or value error: character string buffer too smallORA-06512: at "PRIN1APP.GET_BLOCKED_ORDERS", line 6ORA-06512: at "PRIN1APP.LEDGER_ITEM_I_EVI", line 1ORA-04088: error during execution of trigger 'PRIN1APP.LEDGER_ITEM_I_EVI') occurred while booking Invoice CD 219736.