Finance (Financials)

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.

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 difference

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 acc

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

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 ?