Finance (Financials)

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

Description:The current behavior of the IFS application allows the addition of erroneous characters when creating manual supplier invoices. However, this can lead to issues with successful SAF-T XML file generation.As an example, if we added an erroneous character (Ex: Unicode character without visual representation) as a part of an invoice number, when creating a manual supplier invoice. After that when attempting to generate the Norwegian SAF-T XML file for that specific period, the system does not allow successful creation due to the presence of the erroneous character in that invoice.Steps to recreate the example:Create manual supplier invoice including an erroneous character, when defining the invoice number. Here attached a snap of an external supplier invoice template including a Unicode character as erroneous character in Inv. No tab.  And update it to the GL.  After that, generate the Norwegian SAF-T XML file by using Audit Interface Assistant tool for the particular period. S

Hi All,  As a company we are looking to see about the automation of supplier invoices,  we receive a large percentage of our invoices through email in PDF format, and looking to see if there is a program/ procedure that would take the pdf and enter the relevant information automatically into IFS.  We would need the pdf read to pick up invoice number, supplier name, purchase order etc.  At this point we don’t want the invoices matched to the po we just need them registered on IFS to reduce manual entry.  Many thanks!

Please see my attached files. I want to be able to filter >= &invoicefrom from my report. Settlement Period From is invoice date. Sample, 05.02.2024 from db format is date, month, year from value list. In Filter Criteria, when I set invoice =& invoicefrom   (like 05.02.2024) is returns data as expected. However, if I set to >=&invoicefrom (like 05.02.2024) it returns the whole data, which I don’t need. How can this issue be corrected? Eventually, I want to set my report like   invoice >=& invoicefrom  and  invoice <=& invoiceto. Thank you in advance.

Currently only IFRS16 and US GAAP are provided as Accounting Standards for Lease Accounting in IFS Cloud.  Does anyone know if there are plans to add other Accounting Standards such as FRS102 UK GAAP?

We have an Advance invoice with an open amount of $219.58 and and Advance Credit for (219.58).  Is there any way to offset these in mixed payments?   

Has anybody experience issues submitting CIS Monthly returns and supplier verifications using the IFS Connect functionality in Apps 10 UPD13? error returned in application message Exception while sending data Caused by: java.net.ConnectException:Connection timed out: connect  

Hi,Sometimes our suppliers send sample items to us at zero value which we have to raise a zero value PO for and then book in as “stock item”.I have been informed that when our stores try and GRN an FOC item it brings up an error message (I have not been informed what this error message is).We then have to amend the PO line to 0.01 so stores can book into stock but the supplier invoice will be for zero value.  This 0.01shows on the GRNI report and we have to write it off.Is there another way to book into stock at zero value please?Thank you,

Hi,can someone help me to find below  “matched checks per payment” option in IFS cloud ?  

Hi. Is there a good solution to avoid/accept a balance in parallel currency on Mixed Payment?It is very troublesome to remove it