Finance (Financials)

Does IFS cloud has out of the box (pre defined) P&L, Balance sheet and cash flow statement, if yes where to find it. I know the report generator is not available in cloud. Thank you.

Dear Community, I have an issue when creating a new company using STD - Template, only below countries are available in the list. I have checked in ISO Codes and there are more countries used in the application.  Kindly advise me where I can find other countries. Best regards,Thakshila

I’m in 23R1 and I need to setup a company in Canada.  I already have a company setup in USA and that is working fine.  But when I try to enter a new company for Canada, I cannot select Canada from the dropdown.  Only US and Germany appear in the dropdown.  CA is defined in the ISO list of countries.  Can you help with the question. 

Hi,My database is in Apps10 UPD12 I book a supplier invoice in the same transaction currency than the accounting currency of my company (EUR).For this company, parrallel currency is also activated and is also EURSpecific stuff is that i use a Calculated Tax Code   I’ve set up 0.02 accepted difference  Interresting think is that the system, even if there is no balance difference, triggers four IP28  lines in the I voucher . The total balance of these 4 lines is zero both on accounting currency and parallel currency  Does anybody have an idea  why system triggers IP28 ? And why 4 times ?  Thansks for your help. Eric

When I go to the pre posting of a customer order, the Activity sequence field is greyed out. I would like to be able to enter an activity sequence. Does anyone know how the activity sequence field can be made to be editable? Any help would be appreciated.   

Hello. We would like to assign an activity sequence to an Advance Invoice so that when it posts to the general ledger, we are able to determine what project it is related to. Does anyone know how this can be done or whether it is possible? Any help would be appreciated.   

Hello  We would like to see the project number related to advance invoices when we run GL Balance analysis detail for accounts receivable (ie. IP17) and deferred revenue (ie. IP19) . In the customer order, I populated the Project field in the Pre-Posting.   I also set IP17 and IP19 to have a Project code part and Control Type Pre posting.   Then created an advanced invoice. When I printed the invoice, I got the error below.   Is it possible to push the invoice through without assigning an activity sequence in the pre posting of the order? 

Hi Expert,I got some issue from my clients on supplier payment. They record tax invoice on manual supplier invoice ( with tax withholding ) and payment in supplier payment with same currency. But system show them that the different total in Pay Amount in Pay Curr and Pay Amount in Acc curr. Tax withholding was posted with PP13 (gain/loss on exchange) that’s not true.Why 2 field show the different total when invoice and payment with the same currency? Thank you in advance for your help. 

Anyone that can shade some light on…  I get the error trying to run a (scheduled) report for a particular account.

Hi,An external file upload to a external voucher assistant and file is loaded and checked. Then when it’s trying to create voucher below error message appearing. “Savepoint EXT_CREATE_VOUCHER never established in this session or is invalid” Parameter Set : 1 - External Voucher Default SetFile template : used a self defined templateSeeking an answer for this issue. Thank You.

Hello IFS team, Please, I didn´t work much with IFS maybe 1,5 year For 10 months I was working seriously with it as I was transferred to other department where they used it more. However I didn´t have time to study it fully / all aspects of it. We cannot return to IFS as we switched over to another software. There is a service desk for database access they can extract what we want but I don´t think they can help us apart from that. We need your help somehow. In IFS is there a report which shows all POs which were matched with invoices and to what accounts were they booked? Or something similar? 

In the financial project, there is a checkbox for Post Actual and Recognized Revenue Difference. Does anyone know what kind of customer invoices this works with? I am assuming that this works with CD invoices (does it?), but are there other types of invoices that work with this like instant invoices, advanced invoices, staged billing invoices, etc.? Would appreciate any insight.

We are trying to add an overhead rate to a multi company project transaction that had its base in an employee project in the employee company and therefore does not have the source project transaction in the customer company, but other. Does anyone know if it’s possible to add information to a project transaction which is the result of a multi company project transaction?

Hello.I would appreciate it if someone could explain further what is meant by the red bounded statement below.   

Dear all, we want to delete a not used Site, but received an error message. Thank you for your help,Benjamin IFS cloud 23.2.3

After Update from IFS10 UPD13 to IFS10 UPD 17, we experienced an issue, that Invoices ended in status printed, due to an imbalance in postings.Customer invoice posting analysis show the error message ORA-20105: Invoice.ACCERROR1: Error (The difference in Accounting Currency for the Invoice 2023004303 has exceeded the limit .2) occurred while booking Invoice CD 2023004303.The error is caused because IP2 and IP4 postings are missing in the customer invoice postings.This message is caused by bug 164696.Has anyone already done a data correction for corrupted data which was caused by this bug?kind regards 

Hi.This is regarding creating credit/correction invoices in the inter-site flow. The scenario is as follows.Site A in company 1 receives customer orders from the external customers. They will raise an internal purchase order for the items to site B in company 2. Site B will directly deliver the items to the end customer. Site A will send the customer invoice to the end customer based on the customer order in site A.Is it possible to automatically create the credit/correction invoice in site B (Production Site) for the internal customer order, if a credit/correction invoice is raised for the external customer order in site A. Or wise versa. 

Granted user permissions for the projection, and they are part the Accounts Payable finance user group.  Are there other reasons why all of the potential Matching Methods options below are grayed out?  

Following error comes when trying to save Customer Order Line. System only allows to save the Line if Tax Code Column data is null. Can anyone please suggest in this regard?  

Hi All,Is there a functionality in IFS cloud that we can do budget billing for customers (specially for propane) ? Or any reference document which includes ideas of relevant customizations ?Many Thanks,Lakna

We must provide your accountant with audit files in French format.Our accountant cannot process the XML format.Is there a TXT format and if so how to implement it?Business Impact:Tax control, very important, very little time to answer to their questions.

Hello. I have prepayments on a customer in a foreign currency. These are posted with different currencies. When all the payments have been made I would like to create a customer offset… however the customer offset uses todays currency rate…That means that values in accounting currency changes…I would either like it to pick the value from the customer analysis, -4925,50 orI would like the possibility to change the currency rate so that it reflects the value in the customer analysis. This might not look like an issue but the customer I have are dealing with prepayments between 50 000-100 000 Euro which means that it creates currency differences that shouldn’t exist. BRDenny 

Hello. We are using Apps 9 Update 13.When we receive a customer payment for an advanced invoice, the FX gain/loss is not recognized into the FX/Gain loss account but stays in the deferred revenue account. In the example below, accounting currency is in CAD and invoice currency is in USD. When the invoice was booked, it was booked at a CAD equivalent of 165,758.34.   Below is the customer payment (green highlighted). The CAD equivalent of the payment is 167,402.52. So there should be an FX gain on the payment of CAD 1,644.18, but it is not separated out to be posted to the FX gain/loss account. Instead, it is booked into the deferred revenue account, so it stays there.Is there any way to get the FX gain/loss on customer payment of advance invoice to automatically post to a separate FX gain/loss account?   I would appreciate any help or ideas. Thank you.

Hello,I am trying to pass the following search criteria to a custom menu but the results is only giving me 1 record not the 5 as expected.Search screenMy custom menu is as follows :select msi.Identity , msi.Invoice_no,  dr.doc_class, dr.doc_no, dr.doc_rev, dr.doc_sheet, edm.file_data, edm.doc_type from ifsapp.Man_Supp_Invoice msi Left Outer Join ifsapp.doc_reference_object dr On dr.Lu_Name='ManSuppInvoice' and dr.key_ref =  'COMPANY='||company||'^INVOICE_ID='||invoice_id||'^'   Inner join ifsapp.edm_file_storage edm On edm.DOC_CLASS= dr.doc_class and edm.DOC_NO = dr.doc_no and edm.dOC_SHEET=dr.doc_sheet and edm.DOC_REV=dr.doc_revwhere msi.identity= Nvl(:i_hWndFrame.frmManualSupplierInvoice_Ext.cmbsIdentity ,'%')and invoice_date >= to_date(:i_hWndFrame.frmManualSupplierInvoice_Ext.dfdInvoiceDate ,  'DD/MM/YYYY')and invoice_no =  Nvl(:i_hWndFrame.frmManualSupplierInvoice_Ext.dfsInvoiceNo ,'%')and project_id =  Nvl(:i_hWndFrame.frmManualSupplierInvoice_Ext.dfsProjectId ,'%') ; Can anyo

Hi all, We have ran CIS Verifications for HMRC and it got kind of stuck in Polling Status. I can’t cancel or do anything with it. We ran quiet few suppliers, so not sure if that’s what’s caused the error.  Does anyone know how to process this or we just need to wait and it will clear itself, please? Need urgent help if possible!   Thank you!!!!