Finance (Financials)

Hello, IFS currently produces a payment file onto a Windows server which then passes through a 3rd party application called Bottomline PTX to get to the bank. We are being asked to look into direct integration to the bank that removes the file being placed on a windows server and 3rd party product.  The UK bank we use is HSBC and they suggested using their HSBC Connect offering.  I believe IFS Connect may be able to perform this, but we have no knowledge on this area or integrating with banks.  Currently we are using IFS Apps 8. Does anyone have experience of this and can provide some guidance and advise? Thanks in advance Regards Shaun

What is the best report in IFS where I can span years and get trailing twelve months sales revenue?.

What is the formula IFS uses to calculate DSO?  I have seen some help topics that mention they found the formula in the help pages, I am not finding it.

HI , I have below questions regarding AR.1.Is there a feature in IFS Cloud to track the communication history with the customer?2.What would be the first parameter to check by the system (invoice date/ payment amount or invoice number etc) to automatically match the customer payment with invoices when an external file is loaded and created a mixed payment?  Many ThanksLakna

Hello,  We are in the 7.5 version, I found the error at mentionned in the screenshot for the posting M1 “Account N cannot be found”. I  used the Default values for the posting in order to check if it comes from a previous bad setup of the M1 posting. The error persists. Do you have any ideas to solve this problem ? Best regards

Hello.I’m wondering if there is any way to create external voucher and make use of automatic accounting rule AP1/AP2 for Tax Received/Tax Disbursed. When such voucher is created via Voucher Entry manually, it’s enough to insert 2 rows and additional 2 rows for default tax account are created automatically with the usage of AP1/AP2. Whereas external voucher is blocked by imbalance error.Maybe there is some way to insert the rows externally from .csv file to Voucher Entry and modify them there to use the effect of AP1/AP2. I tried Migration Job, but still the rows appear only in View Rows and not in Voucher Postings. Thank you in advance for your tips :)

Hi Community, We work for e French company, an european exportator of goods, and they need to creat an intrastat every month.We got 2 questions concerning this functionnality :- Why the format of the CSV of the intrastats report is not at the format of PRODOUANE (the french customs) ? The column are in english and not in the right order.- The goods under a warranty (at 0 €) shipped, are reassembled in the intrastat report at 0€. But in the european laws, it should reassamble at the sale price they have.

Hi,Can I know whether it the standard solution in IFS app 10 with India localization activated provides the facility to generate GST reports as required by the legislation ? Or else is it required to use the business reporter tool and create GSTR1 and automate the submission via a 3rd party middleware ? If not best thing is to do manually by exporting tax transactions and analyze and submit to tax authorities ? Please advise.

In APP9, we have a RMB option, Work Order…, in Manual Supplier Invoice window.What are the criteria that need to be fulfilled for that RMB option to be enabled for a particular record? 

Hi guys.I had to put couple of assets on hold for depreciation. Those assets ware activated in 2017 without any investment. Recently I notified this error and allocated respective values through “add investment - progress”. Since 2017-2023 accounts are finalised and periods ware closed, I put them on hold until 31 March 2023. The problem is when I’m running depreciation for FY 23/24 “0” value JVs appear for the held periods (those ware already closed). Kindly guide me to overcome this issue and post depreciation 2023 April onwards. 

We are planning to start the GL voucher archiving as our data grows faster in the GL voucher row table.This is impacting day-to-day reporting and some month-end processes where data is fetching from GL voucher row tables.My question is if we archive these data will it impact any process in IFS for example “Calculate Revenue Recognition”? 

Hello! So, I recently just got employed with a company that uses IFS as their accounting software. I work in the accounting department and right now they do not use the bank reconciliation feature in IFS. They use excel spreadsheets and manually reconcile that way. I want to improve that process and utilize the bank rec feature within IFS. Now my question is, how do I go about starting that process? Will I need to make entries for each bank account to show the ending balances from May? I’d like to use the automatic transaction matching function and I’d like to be able to start reconciling for the month of June. I apologize if this seems confusing, I am new to IFS as well and figured this was a good place to start! Thank you for your time!

On behalf of a customer****Imagining the following scenario in the cost allocation functionality. There are the following Code parts defined:    With the cost allocation functionality, the Code Part Value "Preliminary 1" must allocate 25% of costs to "Cost Center A" and 75% to "Cost Center B".  Example:     However, Code part Value "Preliminary 2" must allocate cost to "Cost Center A" and "Cost Center B" according to the percentage of sales in each of these cost centers.   how can it be managed?  

Hello All, My customer has a problem because he sometimes manufacture purchase parts but the manufacturing cost is not considered to valuate parts : buckets ‘200’ Labor and 300 ‘Machine are missing (even missing on the shop order itself) Settings of inventory part:part type = puchase Inventory valuation method = Weighted Average Does someone knows if it’s normal in IFS? Is there any possibility to consider these cost buckets to valuate properly the parts received into stock Thanks in advance :) Antoine  

Q > Please let me know if it is possible to create a dynamic link in CLOUD BA Report. If Yes then How ?

HI 1.I created an instant invoice and allocated the rent income across six months. 2.Following is the voucher created and FULL amount has been debited to the rent income account for the same period.HOw to ensure that the revenue is allocated properly? Many ThanksL.K

We need have different Supplier Invoice Series depending on if the invoice is in positive or negative. This is for our Spanish company that needs this in order to report SII correctly. Does anyone know how to setup such solution?  

Community,We have a supplier invoice when doing receipt matching, come across an error which cannot be resolved at this moment.  My quesiton is, can we do a payment without matching, and we do receipt matching later? Thank you.

Hello, I created a manual supplier invoice for 2 POs and matched the receipts. In general the project linked to the PO gets mapped on the PO preposting, inheriting it from the PO preposting.Since I have done the invoice for 2 POs (for which project ID has the same value), the project ID does not get mapped from neither of the POs. How can I setup the system in order to have the project value automatically mapped in the supplier invoice preposting from one of the POs when the POs have the same project value ? Thank you Tanya

Hello to the community,  I was wondering if there was a way to block some project IDs for use on manual vouchers (just like we block manual connections on PO for some projects for ex, but this time for manual voucher rows)  If there is an option for that, please share your expertise on the matter Thank you :)Tanya

Hello,  I am able to run the automatic matching for supplier account for exemple, but there are some accounts for which the background shows warning message “no matched transaction found” even if there are transactions that have to be matched for the period and account indicated (for ex revenue account).Do you have any idea on the reason why this error message appears for some accounts ?Thanks in advance for your helpTanya

Unable to save On Hold Column, when I add the on-hold column to supplier analysis in application it adds but does not stay there.

Hi Guys,I am trying to deploy our BI Models (Cloud on premises - version 22.2.2). All my models have been deployed, but one, IFS_GENERAL_LEDGER.When I run the process model for this tabular model, I receive the error below:2023-01-30T10:57:15.367: Start processing of model2023-01-30T10:57:29.220: OLE DB or ODBC error: The command has been canceled..2023-01-30T10:57:29.250: Execution of DDL failed. Anybody already have this problem? Thanks,Gianni 

HI ,Can I get an explanation of using this payment tolerance option. Many Thanks,L.K

HI,I get the following error even after having the tax information entered. Please advise.ThanksL.K