Finance (Financials)

Hi,I’m trying to reconcile the inventory value against the general ledger.I’m using the “Inventory Value per Period” page.Upon closer examination of the "In transit Qty" and how postings are carried out in the general ledger, I have come to suspect that we might have an incorrect setup?In the scenario of inventory transfers between different sites, I've noticed that the transactions do not completely clear account “1433-Stock movements”. Consequently, there remains a balance on this account which is not intended.Our accounting method employs the weighted average cost approach. It appears that when there's already a quantity of a particular item on a site, the system calculates a new weighted average cost prior to fully clearing the account 1433. This discrepancy is causing the account to maintain a balance, whereas I had anticipated it to be zero if the process was executed correctly.To provide more context, here's a breakdown of the

Hi IFS Super community. How do we find the remaining life of Fixed Assets. Is there a report to pull which give this data. Thanks, in advanceSu 

Can anyone advise how to find out where a supplier payment is sat, it has posted through onto the supplier account, but we are unable to see this posted in any bank accounts.

Does anyone know if this had got past R&D Backlog?  This is functionality we are interested in to help streamline the process.  Hoping someone may know.

Hi All,We are having a scenario where the Supplier is having 3 different bank accounts. The same has been added in Supplier Master > Payment Tab > Electronic Payment Addressess. And in that, one account we made as default. Now the Supplier is asking us to pay to the Bank account No 1 for the invoice number 1 and for the second invoice supplier is asking us to pay to the Bank account no 2 and for the third invoice, bank account no 3.How to pick the bank details based on the invoice wise. Is there any way to capture the details related to bank at invoice level or is there any connection available between Invoice & Supplier Bank details. Could anyone please help me. I am facing this in IFS APPS 10.Thanks in Advance.Regards,Mariappan C

I’m setting up a cloud solution surrounding the information regarding the External Payment Parameters.One of the tell me to “Modify Reason Codes in External Payment Parameters”.I cannot find the Reason Codes within External Payment Parameters, the only parameters that I find in regards to External payments are Return Reason Codes. When I look at the External Payment Details, I have the columns Reason Code but even if I have errors, no Reason Code is presented, I assume these needs to be created. Does anyone have a clue of the functionality of the Reason Code and how I set this up?

Hi all,do you have any idea what can cause the problem with the conversion of the exchange rate on the customer order invoice?IFSAPP10 - screen from customer environment - UP17 customer invoice in foreign currency (CZK)customer invoice posting analysis - wrong amount in accounting currency (EUR) Localization dev environment is correct - UPD 20 Assumption is that there is a bug fix for this, but since I couldn't find it, I'm asking for your advice, is it possible that it's some kind of application setting? Thank you in advance. Regards!

Hello All,We received an NSF rom a customer. The chq was deposited in the Customer Checks, and it was reconciled in the Mixed Payment. Is there any way to roll back this chq? If so, how, what screen would I use? Thank you

Hi, every one.Do we have any proforma invoice in IFS for example in purchase order?I will appreciate in the event that anybody can offer assistance me.

What is the most ideal way to handle utility bill expenses in the application

The Invoice has error out.  We have run the Pre-Post to assign the Project ID information but we still cannot post invoice and it remains in Posting Error.

Topic raised on behalf of case G2339508“Customer is trying to go live with Pagero with the eInvoice module but running into issues with defining the tax codes. If we try to use a 0% deductible tax code which is a Non-Deductible Tax Amount there is no place in the external file template to define this.”They are CAD company and do not use VAT code. They are Sales Tax set up.As per below screen shot, the PST tax code is a 0% deductible tax code therefore when used, the amount populates in Non-deductible tax amount column. However, in using the external supplier invoice template if we populate the tax code (fee code) on the tax row it does not. The only fields available is Tax Amount and Tax Amount in Acc Curr which seems not incorrect.  

HiI have created a report in Apps 10 which gives me Actuals by period from the GL Balance. What I would now like to include in Budget for the remaining periods of  this year. Is this possible?I have values in the Budget Version (pulling into Budget Period Amount). What information source holds this info? Here’s a mock up of what I would like  Thanks! 

Hi all,can anyone contribute further information and workflow on MCA Revaluation Snapshot?We have created a snapshot but cannot understand how.Thanks for the info

Does anyone know how and where can we add a column to further classify the above-mentioned in IFS?

HiWe aim to do ‘process mining’ along the accounts payable invoice process:→ Load Invoice into ‘External Supplier Invoice’ to ‘Pay Supplier Invoice’Can IFS APP 10 provide a technical data table by invoice, supplier etc. that provides a time stamp per process step: Create, Match, Authorize, Post, Pay etc.? In addition, the table should also contain information if the invoice had to be manually processed: add manual posting line, authorization template has been adjusted, purchase prices have been overwritten, approval was required because of not matching with POL, manual matching, add receipt ref etc..

Does anyone have any clue as to what drives the Company Tax ID that gets returned against M vouchers, please??We are using Apps9 and have a company registered for Tax in various EU countries.  So far this year, a number of M vouchers have been raised and, as you can see below, they are retrieving sometimes our UK tax ID, sometimes BE, sometimes FR and sometimes none at all.  The Transaction Codes vary betWEEN AP1, AP2, MANUAL and INTERIM.  There is no Supplier or Customer or site being entered or retrieved so no obvious place that a Country is being returned.  I still have a similar unresolved question about random Tax IDs being retrieved against Mixed Payments too.  I did raise a case but it wasn’t picked up as Apps9 is out of support.  Any shared experience/ideas from the “Community Collective Brain” would be much appreciated!    

Hello IFS Experts, Hoping to hear some ideas or solutions to an issue we are having!Currently for our offshore PO shipments, when we are notified of this shipment, we receive into arrival into a non-nettable location. By doing this it allows finance to have a payable and trace ownership of our in-transit materials through GL. Once the material is physically received, we then move the material from that receipt to arrival non-nettable location into a nettable picking location. This was the recommended way from IFS during our implementation 2 years ago. We would like a solution to not have to receive in material that is not physically received because we may need to change the Incoming Dispatch Advice/PO Lines if we find any updates or corrections are needed for the shipment ID #, quantity, or price, or most often the needed to change is the arrival date. Once received the system, it does not allow changes, which this makes sense because it has been received into

Dear Community Manager, As ARO is planning to upgrade from IFS10 upd15 to cloud. sessions are planned by IFS middle east. As I am supporting Finance consultant to ARO drilling. therefore, we are looking for the new features and functionalities in 23R1 version. we have already the relate notes till 22R2. Therefore, you are requested to help me out on this. best Regards,Rohtash Singh

We would like to complete a contra between a customer account and a Supplier Account.  This is not something we have done previously in IFS before and so am unsure if it is even possible.Please can you advise if there is a way to complete this type of transaction in IFS ?  ThanksDarren

Hi, I am getting error “No invoice header is sent before invoice items” while doing Excel Migration of Instant Invoice.  Regards,Kishore Nenwani

I’m trying to figure out the amount available to invoice after orders are shipped, but before they are invoiced.Create Customer Invoices shows me what orders have items available to invoice, but not quantities or lines.  We ship partials on orders and lines, so just knowing the order number is not sufficient.  We also ship consignment, so looking at the Customer Order Line and comparing Delivered to Invoiced doesn’t work either.Any suggestions?

Having an issue where an Invoice Preview is showing all prices rounded up. Example: This is listed as £75.56 which is correct. However, when running the Invoice Preview against the Service Contract this line shows as £76 This has happened on all Lines in the Service Contract - what can cause this?

Apps 10 UPD16 - I’m looking at using Open Balances History and have done some testing but wondering if anyone could confirm what I think to be true - but have a healthy does of skepticism. If we run it for a balance date in the past today it will act like a DeLorean Time Machine and tell us what the outstanding balances and over-due amounts were at that point in time.E.G. - we run it on 03/08/23 but put a Balance Date of 30/05/23 we will see invoices that had just been generated as Outstanding but nothing in Overdue. We then run on 03/08/23 putting a Balance Date of 31/07/23 if that customer was on net-30 day terms and had not paid the Balance it would show as overdue. Even if they had made the payment on 01/08/23. Hoping this is true - if it is, it had saved me a lot of custom dev work!

When supplier invoice payments are sent the ISO20022 pain-file is created with a /1 as a suffix on the supplier invoice number (not all of them, strangely). This causes issues when the CAMT053 file is loaded because then IFS Applications cannot find the invoices automatically and the AP Department needs to spend time identifying the invoices manually.Any ideas folks?