Finance (Financials)

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. 

Hi,Is there a generic Tax Template to generate a simple csv or text file at the Print Definitive step in Tax Proposal?Thanks

Dear Friends,How Can I make the “reconciliation fields” tab mandatory on while opening a new customer card/for all, and how can I create a quick report for  customers showing missing fields for that tab. Thanks. Like Quote

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

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?

Hi, On Apps 10 UPD16  the system defined event CUSTOMER_PMT_RECEIVED is firing for customers when we have an unallocated payment on their account. When they have this payment, but prior to it being allocated, the sum of payment + outstanding orders > credit limit - so the corresponding action will fire. When the payment is allocated shortly after they are below the limit, but it has still fired. Has anyone else experienced this issue / found a way around it. 

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? 

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

Hello,In which database table can i found the data “Customer Type” : Regards,Pierrick

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. 

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  

Hi Team, We have Client which has its Branch/entities across globe and having one entity in India as well. the main head office/group company is in France.Do you foresee any requirement to have a dedicated Code Part for Local COA (Chart of accounts) for Indian Entity in addition to Code A which is for Group COA when we have global mapping to be done. Though this is more on Client business but any has any related expertise to guide on what can be good practice. 

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

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

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

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! 

We struggle with invoices that are rounded up or down to nearest NOK .  The rounding creates tax deviation… are the any accounting rules to be set up to handle these small but irritating deviations ?Today we must add a new posting line with tax code 0 .. and the small rounding amount..  How can this be handled easier… 

Can anyone explain how to approve a budget and load the budget version in the IFS cloud? I found that IFS Cloud removed the budget process and replaced it with business planning. I know that in business planning there is an approval process, but I don’t know how to load an approved budget into the budget version. Thank you,

I’ve set up new payment terms in IFS for 60 days from End of month. This appears to be calculating 60 days from invoice date and then pushing out to End of Month, anything dated in June is due on 31st August. Is it possible to calculate End of Month then 60 days, for example anything dated June would be due on 29th Aug (60days from 30th June)?

 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.   

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

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

Hi,In the documentation in below topic it is mentioned  that the DTD file (GDPDU-01-08-2002.DTD) is delivered by IFS.https://community.ifs.com/finance-financials-42/questions-on-german-localization-gdpdu-8579Does any one know how to generate this file?I can get the data extracts using Audit Interface Assistant. Not sure how to get this DTD file.ThanksGayan  

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 ?    

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?