Finance (Financials)

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!!!! 

In IFS Cloud 23R2,Is there a way to set a leading dollar symbol $ on all amount fields ?Example :  $1,000,000.00 or $10  

IFS has asked us to change a value of the Currency Difference on Tax Localization control center parameter. Does anyone know where to find this?The purpose is to rerun Customer Invoices In Error when they are missing posting lines.

Dear Community,  I bring to you a very weird issue.  It looks the purchase transaction voucher is partially transferred. Have you ever seen this? Do you have any idea how we can fix this?   This is how the transferred “half” voucher looks like: Thank you very much in advance for any suggestion. Kind regards, Balazs

Is it possible to schedule automatic consolidation rollbacks during a specific time frame and frequency? Has anyone had experience with managing consolidations across multiple regions with 1 structure? 

Hello all,Is there a field on accounting_code_part_value_tab table that can be use a BS/PL indicator or any other field/table that can distinguish BS Acc. from PL Acc.?I’m hoping for field/table that is generic to all IFS systems not user-specific.Thank you. 

Please advice which  format IFS support for Electronic Invoice. Is it support some of mentioned formats?- Peppol BIS 5A Billing version 3.0, Svefakaktura BIS 5A 3.0- EHF 3.0.x- Finvoice 3.0- TeappsXML 3.0 Kindly advice

In order for the ‘Inherit authorizer from purchase’ setting in Company ( Invoice> Supplier Invoice Workflow) to work we have to setup the purchase authorizer as Invoice posting authorizers. Is this the correct functionality ?

There has been a Tax Audit of our German company. We have configured the audit assistant and files have been generated for each source. So far so good. To complete the audit we also need the GDPDU-01-08-2002.DTD file. I have created requests (first issue then service request, in the IFS Portal as well as sent two escalations, but noone seem to know what I am asking for. Audit should have been closed already but latest this week. What can I do to get this file?

Community,do you know how to resolve matching out country code error in ISO20022 ACH payment.  We are Canadian company,  Scotiabank told us to fix below error of matching out country code. Instead of US, it should be CA.I beleive our cash account shows clearly we are canadian bank, I have cash account setup screenshot below as well. 

Hi all,One of our clients has a requirement where they want to pass a balance to a stats account, but that balance should not carry forward to next year.Example, Dr Statistical accountCr AR accountThe balance passed to this statistical account should not carry forward to next year.To do this, I created a stat account, connected Statistics account type and enabled Exclude from Voucher Balance Then I created a manual voucher using this stat account.However, when I tried to create the voucher, the following error populated. “The Voucher -1598335 is Not Balanced”The voucher no series is doubtful, and it has a negative sign in front of it.  Can someone please assist me to find the reason for this error?Thank you in advance.

Hello.  I have 2 unpaid items on my cashflow forecast which nett off which each other (this is expected) Both of the items are showing as PaidPosted against supplier invoice analysis. The only subtle difference with these 2 items against this particular supplier are that the payment type is showing as ‘Supplier Offset’ . I want to remove them from the cashflow permanently. How do I do this?  

Hi CommunityI tried to set-up a new company based in Romania in IFS from a STD-FR Model but the RON currency is not available for my Model so i cannot set it up.Does anyone know how to fix it?

Hi,Currently my customer analysis screen only shows the total of all outstanding invoices in GBP.  I also need it to total up the foreign currency column too.How do I do this please without exporting into excel?Thank you,Lisa