Skip to main content

Finance (Financials)

This will include the questions related to Financials.

  • 5,430 Topics
  • 14,337 Replies
5430 Topics
MWitczak
Hero (Customer)
MWitczakHero (Customer)
asked in Finance (Financials)
Options greyed out for Supplier Offset Proposal

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?  

441
Furkan Zengin
Ultimate Hero (Partner)
Mohsin
Do Gooder (Partner)
MohsinDo Gooder (Partner)
asked in Finance (Financials)
Error: Field [TAX_BASE_CURR_AMOUNT] is mandatory for source tax item order and requires a value

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?  

1090
Mohsin
Do Gooder (Partner)
L
Sidekick (Partner)
Lakna KSidekick (Partner)
asked in Finance (Financials)
Budget Billing in IFS Cloud for Propane

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

250
L
Sidekick (Partner)
D
Do Gooder (Customer)
DJPDo Gooder (Customer)
asked in Finance (Financials)
FEC in TXT format rather than XML format

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.

3595
H
Sidekick (Employee)
D
Do Gooder (Employee)
deolseDo Gooder (Employee)
asked in Finance (Financials)
Customer Offset with unchanged currencies

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 

411
TimeMarBou
Hero (Partner)
A
Sidekick (Customer)
andrei.borromeoSidekick (Customer)
asked in Finance (Financials)
FX Gain/Loss on Customer Payment of Advance Invoice

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.

1146
A
Sidekick (Customer)
J
Hero (Customer)
JannetteCHero (Customer)
asked in Finance (Financials)
Pass search criteria to a custom menu

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

280
J
Hero (Customer)
MLCEGLE
Do Gooder (Customer)
MLCEGLE
asked in Finance (Financials)
HRMC Verification Proposal Polling Status

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

972
MLCEGLE
Do Gooder (Customer)
AntonioInfoConsulting
Sidekick (Partner)
AntonioInfoConsultingSidekick (Partner)
asked in Finance (Financials)
Leading $ on all Amount fields

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  

291
Marcel.Ausan
Ultimate Hero (Partner)
JJäthing
Hero (Partner)
JJäthingHero (Partner)
asked in Finance (Financials)
Tax Localization control center

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.

793
JJäthing
Hero (Partner)
B
Sidekick (Customer)
bapehuSidekick (Customer)
asked in Finance (Financials)
Partially transferred purchase transaction

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

592
B
Sidekick (Customer)
B
Sidekick (Partner)
BytLukasLSidekick (Partner)
asked in Finance (Financials)
CAMT.053 automatic matching of supplier payment

Dear experts What is your approach for the automatic supplier payment matching with a CAMT.053 file? On a customer environment (Apps 10, update 15), we have set up CAMT.053 and it works fine for customer payments. What we are missing so far is the automatic matching of the supplier payments with the corresponding payment order. When the CAMT file is loaded into IFS no automatic matching takes place and the order ID has to be added manually (e.g. in the mixed payment window):  Is there a way in IFS standard to automate this process. E.g. when creating a supplier payment order to add the order ID into the payment order XML file (reference tag), so that this information can later be used in the CAMT file for automatic matching with the referred payment order?   Many thanks in advance. Best Regards,Lukas

5076
ArcBenjaL
Sidekick (Partner)
L
Do Gooder (Customer)
lbayhonanDo Gooder (Customer)
asked in Finance (Financials)
Consolidation rollback

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? 

180
L
Do Gooder (Customer)
B
Do Gooder (Customer)
BabsDo Gooder (Customer)
asked in Finance (Financials)
IFS GL BS/PL Indicator

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. 

341
Furkan Zengin
Ultimate Hero (Partner)
S
Sidekick (Employee)
Sanduni AriyarathnaSidekick (Employee)
asked in Finance (Financials)
What is the format IFS support for Electronic Invoice

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

6283
Ralph Gericke
Superhero (Employee)
Lawrence
Sidekick (Customer)
LawrenceSidekick (Customer)
asked in Finance (Financials)
Failed Application Message to HMRC

IFSAPP 8 - Supplier Verification and CIS tax report submissionWe have suddenly started to get the failure1:javax.net.ssl.SSLException: Received close_notify during handshakeon the application messages that are connecting to the HMRC Transaction-engine.tax.serviceLast successful message on 9th May 10:01 - first failure at 13:31 the same day.Last year we implemented an additional Java parameter (-DUseSunHttpHandler=True) that forced a change to TLS 1.2 after HMRC withdrew support for TLS 1.0, and system has been working ever since. Anyone else having this issue? Any clues? :) 

2215
C
Do Gooder (Partner)
M
Do Gooder (Customer)
ManilkaPDo Gooder (Customer)
asked in Finance (Financials)
Inherit Authorise from purchase setting use

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 ?

913
R
Hero (Employee)
VBGLinda
Do Gooder (Customer)
VBGLindaDo Gooder (Customer)
asked in Finance (Financials)
German GDPDU-01-08-2002.DTD file is missing

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?

2244
Ralph Gericke
Superhero (Employee)
R
Hero (Customer)
ronhuHero (Customer)
asked in Finance (Financials)
ISO20022 Matching Out Country Code

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. 

602
R
Hero (Customer)
D
Do Gooder (Partner)
Devanthi ShanikaDo Gooder (Partner)
asked in Finance (Financials)
Stat Account Error

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.

412
D
Do Gooder (Partner)
C
Do Gooder (Customer)
Caroline GDo Gooder (Customer)
asked in Finance (Financials)
Posted and paid Supplier Invoices still showing as unpaid on cashflow forecast

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?  

310
C
Do Gooder (Customer)
C
Do Gooder (Customer)
ChotaDo Gooder (Customer)
asked in Finance (Financials)
RON Currency not available in my Company Model

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?

13320
Malgorzata Palatynska
Hero (Employee)
L
Sidekick (Customer)
LisaTSidekick (Customer)
asked in Finance (Financials)
Foreign currency total on customer analysis

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

270
L
Sidekick (Customer)
U
Do Gooder (Employee)
Uththara HansanieDo Gooder (Employee)
posted in Finance (Financials)
IFS application allows the addition of erroneous characters when creating manual supplier invoices, which can have an impact on successful SAF-T XML file generation.

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

650
U
Do Gooder (Employee)
S
Sidekick (Customer)
s-oflahertySidekick (Customer)
asked in Finance (Financials)
Invoice Handling

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!

1042
S
Sidekick (Customer)

Badges

Show all badges
Terms & ConditionsCookie settings