Finance (Financials)

Hi All Has anyone experienced detailed remittance information requirements for ACH payments? We are trying to use the ISO20022 payment format for ACH payments in the US, and our bank suggested using detailed remittance information. How can we achieve this in IFS?

7 months ago

SethDo Gooder (Customer)

asked in Finance (Financials)

IFS Report Designer and strMid with strScan

Trying to remove the start of a column on a report but the beginning is variable length so I want to remove up to the first space found and I tried this vldtstr:strMid(tns:INVOICE_NO_PP_ID,vldstr:strScan(tns:INVOICE_NO_PP_ID,' ')+1,20) but i get an error - GENREPORTIO:Could not generate report:”TRANS_CONF_ERROR:Failed transforming report data: ‘Syntax error in ‘format:formatDateTime($date_2754,’MM/dd/yyyy’,’vldtstr:strMid(tns:INVOICE_NO_PP_ID,vldstr:strScan(tns:INVOICE_NO_PP_ID,' ')+1,20)’)’.” Of course there is nothing in the column about formatDateTime so not sure where that came from - looked for missing apostrophe but nothing. I also used this in a column by itself and it works fine - vldstr:strScan(tns:INVOICE_NO_PP_ID,' ')+1 to return the position of the space.

7 months ago

HRSDo Gooder (Partner)

asked in Finance (Financials)

Down Payment proportional distribution on partial delivery invoice

Hi, our client have request to distribute netting off of down payment of customer order proportionally with delivered amount (partial delivery).For example:Total Invoice: 1000Down Payment (40%): 400Invoice 1st Delivery (50%): 500Invoice 2nd Delivery (50%): 500Since customer order delivered twice (50% and 50%), down payment need to be netted off proportionally 50% for first invoice (50% * 400 = 200), and 50% for second invoice (50% * 400 = 200).At IFS Standard, since down payment amount (400) less than first invoice (500), all down payment amount will be netted off for first payment.Anyone ever has the same request? Should we make customization to fulfill this requirement?Many Thanks.. Heri Santosa

7 months ago

KIMKIMANDREWHero (Customer)

asked in Finance (Financials)

APPS9 - Consolidated Accounts - problem transferring balances to Parent

Has anyone had experience of setting up/using the ‘old’ Account Consolidation module?‘Consolidated Accounts’We’re in the process of configuring it and getting issues when attempting to transfer the Subsidiary Company Balances across to the Parent Company. I.e. there is no RMB to do it!I can’t see anything in the on-line documentation but I wonder whether there is a ‘gotcha’ on the set-up?

7 months ago

Nagah.khaledHero

asked in Finance (Financials)

Not a valid IBAN account number.

I’m trying to create cash account, but system raised this error message“Not a valid IBAN account number.” please advise

7 months ago

DW_SydneySidekick (Customer)

asked in Finance (Financials)

SFTP - IFS and ADP

Hi All.We use Apps 10 EE and are based in Australia (not that this should make a difference but apparently it does).We are trying to connect our ADP database, that we use for payroll, with IFS. The recommendation was to use a SFTP connection (by ADP). The project has ground to a halt and we are in the middle of a standoff because IFS cannot provide public PGP key and ADP requires public PGP key to make the connection.This solution (ADP (ifs.com)) does not work, we are told, because we are not based in the USA, which I find a little bit incredulous. If anyone in the IFS community has anyone encountered this situation before and can provide guidance, it would be very much appreciated?

7 months ago

RazanRamzyDo Gooder (Partner)

asked in Finance (Financials)

Auto populating of Tax code based on Supply Country and the Company

Hi All,There is a requirement to auto populate the tax code in the customer order lines based on the Company and the Supply country fields, defined in the Customer Basic data in the Address Tab > Delivery Tax Information.Tax Regime = VATExample:Company ABC is in US, and they sell to UK (Supply Country) customers from their warehouse located in UK.In US they have a different Tax code – VAT-01In UK they have a different Tax code – VAT – 10Requirement:Requirement is to automatically populate the tax code VAT-10 (Based on Supply Country’s Tax code)on customer order line when they used the supply country UK on company ABC’s customer order line. Thanx in Advance Best RegardsRazan

21 days ago

Ramessh KannaHero (Employee)

asked in Finance (Financials)

Telegraphic Transfer Payment (TT)

Hi Colleagues, Has anyone implemented TT - Transfer using (any) Payment Method/Payment Format available in IFS Standard? I got a requirement to have a Payment Method as “TT”. Any guidance is much appreciated Thank You

7 months ago

DERYNGVE

asked in Finance (Financials)

Fee on PO stops matching of supplier invoice and PO multi company vocher

Hi!Scenario:A Purchase Order (PO) is created in Company A with a delivery address at a site in Company B. This PO includes a freight fee. The Supplier's invoice arrives at Company A. When a fee is included on the PO, a warning is triggered when attempting to match the supplier's invoice with the PO. The warning message states: "The value for code part B is either missing, is a budget/planning code part value, or has an invalid time interval." The warning is issued because code part B doesn't exist in Company A. However, the fee should be directed to Company B, where the code part exists, just like the rest of the PO, and it should generate a multi-company voucher. This process works seamlessly when the PO doesn't include a fee. In this case, when everything matches, a multi-company voucher is created, and the PO is delivered to the stock in Company B. Does anyone know how to fix this? The fee should also be included in the multi-company voucher that is created when matching an invoic

7 months ago

Florian.PetersDo Gooder (Customer)

asked in Finance (Financials)

German GDPdU DTD File missing

Hello, we currently have an audit of the tax office in the house, this requires data from IFS. We have already exported 2 files from the set via the audit interface, but a 3rd file is missing (see attachment files.png). There is a similar topic, but the manual there is not given us the way how to receive the dtd-file: German GDPdU DTD File | IFS Community Did anyone have an idea how to export this missing file?

5 months ago

FEKTSIRYSidekick (Partner)

asked in Finance (Financials)

Why i don't have the real cost matched in périodical capitalization like the cost in project monitoring.

Hi all,I have one question,When i do the capitalization of my cost and revenue, i don’t have the same amount when i look at my real cost in monitoring of the project and the real cost capitalised.So i don’t Know what is wrong?So can anyone help me for this? For your information, my project is not finalised.Thanks for your answer.

7 months ago

GayanDHero

asked in Finance (Financials)

Restrict Creating Manual Supplier Invoice for Specific Type of Suppliers

Hi,Is there a way to restrict creating Manual Supplier Invoice for specific type of suppliers using standard functionality?ThanksGaya

7 months ago

ken milesDo Gooder (Partner)

asked in Finance (Financials)

balance sheet wrong data

Hi Team, my Financial Year for 2024 runs from September 2023 – August 2024,when I run the finance year/period 2024/1 I should get the data as at 30th September 2023,but it gives until August 30,any idea why ?

7 months ago

Abinesh RDo Gooder (Partner)

asked in Finance (Financials)

Fixed asser

How to move the balance of an object internally that is in investment status to another object which is also in investment status. The move function is not available since the object is in investment status. In this case, how can we move the balance?

7 months ago

IniNaadiJSidekick (Partner)

asked in Finance (Financials)

SQL query written for the inventory transaction history which is used to reconcile with the GL.

Dear All, Can you please share SQL query written for the inventory transaction history which is used to reconcile with the GL.Purpose is to check whether all the inventory related transactions were properly directed to the correct inventory GL accounts. RegardsNaadira

7 months ago

IniNaadiJSidekick (Partner)

asked in Finance (Financials)

GL Vs Inventory value per period not tallying

Dear All,I have come across the following issue. All the inventory related GL accounts and the relevant inventory value per period is not tallying. I have checked the following. Let me know your thoughts.Checked the posting controls. Apparently no issue No posting control issues and posting errors No manual vouchers No date difference (Applied date vs created date) Inventory transactions history vs GL voucher row analysis not tallying.If you have any SQL query written for the inventory transaction history which is used to reconcile with the GL. Please share.Please advice.RegardsNaadira

7 months ago

JoanLscDo Gooder (Customer)

asked in Finance (Financials)

We are having problems closing our accounting periods.

The user groups are closed but the period status on the period is grey for both “Close Period” and “Close Period Finally” There are no vouchers in the GL holding table to post for this year and nothing shows in “Validation Transactions in Progress”. We have rerun “Distribution and Manufacturing Voucher Transfer” and it shows nothing. If I reopen the period above the one I am trying to close it will not allow me to close by means of a right click on period status. It is also greyed out. At a loss. Please advise. Thanks!

7 months ago

Frannie BaileyDo Gooder (Customer)

asked in Finance (Financials)

Closing a period error

When closing a period/Year we are getting a message that we have existing voucher rows (in the hold table). When looking there are no unposted vouchers. Any ideas?

7 months ago

LisaTSidekick (Customer)

asked in Finance (Financials)

How to remove outstanding balances from Debtors

Hi,I have various invoices that have been short paid by the customer by pennies and would like to remove these from the Debtors.Can you please advise of the best way to do this in IFS?Thank you,Lisa

6 months ago

karnDo Gooder (Customer)

asked in Finance (Financials)

po matching line level

Hellowe would like to do a PO matching line by line with always a difference so we would like to do automattically but the tolerence is never coming and we are not able to click on it.The automatic matching is not working we need to do always manualy. Can someone guide us

7 months ago

prabha.ruberuDo Gooder (Partner)

asked in Finance (Financials)

Error when creating customer repayment order

Hi Team,I'm attempting to make a partial credit payment via customer repayment order, and when I try to generate the checks, I get the error shown below. The posting control set up is as follows.And for the PP32 there is no control type available to take from the source. The invoices in the payment order have division as the preposting, however there is no possibility for me to add preposting at the payment level.Is there a way to process the payment?Thanks in advance.Best Regards,prabha

7 months ago

NassimDo Gooder (Partner)

asked in Finance (Financials)

Supplier payment proposal - Who pay the bank fees

Hi team, Is there a standard method for indicating which party will pay the bank charges when creating the supplier payment proposal (each party pays its own commission, the supplier pays the commission or the company pays the charges)?Thanks in advance

7 months ago

haritha.waidyaratneDo Gooder

asked in Finance (Financials)

All Enumerations Lost, upon Changing One (on Report)

Any clue why it comes up like that, after this change (i.e. the enumeration related to Grouping)? Note: The rest of the enumerations (unchanged) of concern are -

6 months ago

Ashni NayantharaDo Gooder (Partner)

asked in Finance (Financials)

Error Message - "No recognition posting to be posted "

Hi All, I created a lease accounting contract and connected an object ID . Generated the amortization schedule and made the lease accounting contract active. Then used the import lease opening balances option to import the balances of the previous period.However , now it is not allowed to perform Create Recognition Posting . The error message is generated as "No recognition posting to be posted ". Appreciate if you can assist to fix the Issue.

7 months ago

Anonymous

asked in Finance (Financials)

Object Hold From Depreciation

Hi,Please can you help me with the Object Hold From Depreciation?We have a number of Objects set on Hold From Date, but no Until Date. What is the best way to get these Objects off Hold and restart the depreciation from the current period? We don’t want the depreciation to recalculate from when the Object was originally set to Hold.Will appreciate your help.Regards, Ivan

7 months ago

Page 25 / 174

4335 Topics

Remittance information requirements for ACH payments( ISO20022)

IFS Report Designer and strMid with strScan

Down Payment proportional distribution on partial delivery invoice

APPS9 - Consolidated Accounts - problem transferring balances to Parent

Not a valid IBAN account number.

SFTP - IFS and ADP

Auto populating of Tax code based on Supply Country and the Company

Telegraphic Transfer Payment (TT)

Fee on PO stops matching of supplier invoice and PO multi company vocher

German GDPdU DTD File missing

Why i don't have the real cost matched in périodical capitalization like the cost in project monitoring.

Restrict Creating Manual Supplier Invoice for Specific Type of Suppliers

balance sheet wrong data

Fixed asser

SQL query written for the inventory transaction history which is used to reconcile with the GL.

GL Vs Inventory value per period not tallying

We are having problems closing our accounting periods.

Closing a period error

How to remove outstanding balances from Debtors

po matching line level

Error when creating customer repayment order

Supplier payment proposal - Who pay the bank fees

All Enumerations Lost, upon Changing One (on Report)

Error Message - "No recognition posting to be posted "

Object Hold From Depreciation

Badges

Finance (Financials)

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded