Finance (Financials)

BytLukasLSidekick (Partner)

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

3266

7 months ago

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?

100

7 months ago

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.

261

7 months ago

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

4983

7 months ago

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? :)

1995

7 months ago

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 ?

583

7 months ago

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?

1624

7 months ago

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.

532

7 months ago

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.

292

7 months ago

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?

220

7 months ago

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?

11420

7 months ago

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

250

7 months ago

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

470

7 months ago

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!

572

7 months ago

jgraceDo Gooder (Customer)

asked in Finance (Financials)

IFS Business reporter - invoice date range

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.

492

7 months ago

LauraBSidekick (Customer)

asked in Finance (Financials)

Accounting Standards in Lease Accounting

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?

981

7 months ago

PaulaAdkinsDo Gooder (Customer)

asked in Finance (Financials)

Advance Invoices and Advance Credits

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?

683

7 months ago

JGHJILLDo Gooder (Customer)

asked in Finance (Financials)

CIS Supplier verification and CIS Monthly return submission

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

2085

7 months ago

LisaTSidekick (Customer)

asked in Finance (Financials)

sample parts booked into stock

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,

473

7 months ago

nivslkHero (Employee)

asked in Finance (Financials)

Matched checks Per Payment

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

362

7 months ago

BRSASidekick (Partner)

asked in Finance (Financials)

Mixed payment balance in parallel currency

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

483

7 months ago

RvdBosDo Gooder (Customer)

asked in Finance (Financials)

Error: Field (TAX_BASE_CURR_AMOUNT) is mandatory for Source Tax Item Purch and requires a value

Hi All, What does this error mean and how to fix it? We are trying to create PO from a REQ but receive the following error: Field (TAX_BASE_CURR_AMOUNT) is mandatory for Source Tax Item Purch and requires a value

711

7 months ago

YPADINUSHIDo Gooder (Customer)

asked in Finance (Financials)

Group consolidation: Intercompany Elimination between IS & BS Accounts

As per the current design of the IFS Group Consolidation design, we are not able to combine income statement accounts with balance sheet accounts in one IC elimination rule.What is fundamental rationale behind this design? Is there any accounting basis for it? There are some businesses scenarios where one leg in an expense account of a company whereas the other leg is in a balance sheet account of another company.For example, in reimbursements, one company will credit the amount to reimbursement account (Current Asset) and whereas it will hit an expense account in the other company. So these kind of transactions will not be automatically eliminated as IC rule cannot contain both IS and BS accounts. What is the recommended approach (best practice) to handle such scenarios automatically?

700

7 months ago

andrei.borromeoSidekick (Customer)

asked in Finance (Financials)

Credit Hold

We urgently need a mechanism in IFS to prevent ordering materials or charging time against a customer job with a credit hold. Does anyone have any suggestions on how something like this could be done? I would appreciate any thoughts.

371

7 months ago

Israel de la CruzDo Gooder (Customer)

asked in Finance (Financials)

Posting Proposal - Is there a way to know how long it takes for an approver to authorize

Is there a way to know how long it takes for an approver to authorize?

351

7 months ago

Page 28 / 196

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded