Finance (Financials)

When running the cash flow exposure report, the system is considering purchase order lines invoice payments in the future as intended.  The issue I am having is that the report is considering the total value of the PO line and not subtracting any advance payments that have been made to the supplier.  If the over all invoices is for $1,000,000 but we have made $500,000 in advance payments, then the future cash flow should show -$500,000.  It is currently showing the entire $1,000,000.The advance payments are showing as separate lines under the incoming balance section with the cash flow type = Supplier on Acc. PaymentsDoes anyone know how to solve this issue? 

I am having some trouble using the cash flow exposure feature in IFS. I may have setup something wrong, but the immediate concern is that I am getting an error message in the update cash flow analysis snapshot background job.When I run the update cash flow analysis snapshot - I choose company A.The error message is: PaymentTerm.NOPAYTERMEXIST: Payment Term is not defined for the Supplier 30322 for Company A                    ORA-20105: CfaUpdateUtility.ORA-20105 This supplier is not setup for this company. When I setup the payment terms for this supplier, I received an error for another supplier that isn’t setup for company A.  Cash flow analysis snapshot setup:  Analysis Details Cash Flow source (I am looking to create a cash flow analysis of our payables only) Any help would be appreciated. Here are the setting I used on the Cash Flow Exposure popup:  

I am using Enterprise Explorer Applications 10 and there is a customer order for a customer that is not blocking but it should be because the customer has a credit limit of zero on the Customer screen (“credit info” tab; credit limit) and also on the header of the customer’s Customer Analysis screen.It isn’t a custom event that is casing it not to block, it must be something internal in IFS. I haven’t been able to trace it. Can anyone shed any light on this?Thank you

We are upgrading to Cloud from Apps10, and found while testing functionality that we could not post a Manual Supplier Invoice without unchecking this box. (it was checked in Apps10 and did not have this issue)Just want to make sure that there are no unforeseen repercussions to unchecking this box.We do not use posting proposals...and post each invoice as it is created. 

Hi, Does anyone know a way of making the Payment Term Base Date on a Project Invoice automatically equal that of the Application Date on the Application for Payment?ThanksStephen

We are importing the fixed asset subledger into IFS for an entity that has an Asset Retirement Obligation (ARO) asset with a negative balance.  The asset came to have a negative balance after a valuation adjustment at the end of 2022.IFS does not allow you to import a negative cost or a positive accumulated depreciation resulting in a negative balance on an asset.Does anyone else have an issue with ARO objects having a negative balance and how are these dealt with in IFS?Thanks,Monique

We recently upgraded from IFS 8.1 to IFS Cloud 2023.2.2.In 8, we had the ability to set a shop floor employee job for difference as an indirect operation or a direct operation.  In IFS Cloud, we do not see a place to set a direct job for difference, only indirect.Has this functionality been completely removed with intent, or was it moved?Is anyone handling this situation differently? Screenshots of IFS 8 and IFS Cloud pertinent screens attached.

When creating AFPs with retentions, it has been observed that the retention percentage does not always calculate correctly. This creates issues when we receive payment certificates from customers, as we are unable to match the values accurately.For example, in a contract with a value of £75,542.08 and a 5% retention, the expected retention amount should be £3,777.10. However, the application calculates the retention as £3,777.16, resulting in a 3p discrepancy when releasing the interim retentions.Could you please provide guidance on how to resolve this issue? It may cause problems with customers when paying invoices. 

Dear Community,in our company we’d like to implement MT100 bank payment format for payments in EUR. Could you please kindly advise where to define that the cost of such payment should on our side - ‘OUR’ identifier. I cannot see any place for such info in the Electronic Payment Address. Have you faced such an issue? Do you have any suggestions where to look for? We are also testing the option of Polish Split Payment solution of vat payment in accounting currence. If there are any Polish specialist with experience in this area here, I’d be also grateful for any feedback. Thanks :)

After defining a custom rule with SA070200 code in Avalara, is it possible to apply this custom rule to a charge or non-inventory part in IFS? 

In IFS, when labor clocks into a shop order, the cost is derived from the "Labor Class," which is defined in the routing of the part. However, when labor clocks into an indirect job, the cost is calculated as hours worked × standard cost, where the standard cost is defined in HR > Standard Costs. The issue is that these standard cost rates have not been updated in a long time. We are concerned that changing it might impact other accounts or areas within the system.Before making any updates, We’d like to understand: What specific accounts or financial areas would be affected by a change to the standard cost? Are there any dependencies or system configurations that need to be checked before updating this value? I’d appreciate any insights or experiences from those who have dealt with this before.Thanks in advance! 

Hello,I’m trying to create a new business plan but I’m stuck in this screen. I have added myself as a Business Plan Administrator. I can’t seem to add a USER GROUP? (e.g. missing + signs) This is what I expect: Thanks!

Has anyone used Equity Minority or Proportional Method with Group Consolidation?  If so, can you give me an idea about how this works?  Are there any posting controls that need setup, how the accounting works for each of these methods?  Any help is appreciated.  We are currently in IFSAPP10 UPD21.

Hi Friends,Accounting team proceeded to AR matching, and few days later,, the matching  user ID disappeared. any reason for this?Kindly help 

We are experiencing performance issues with job cost calculation. We would be interested to know if we are unique in having the Job Cost Calculation take hours to process 20,000 - 30,000 transactions and if RnD could consider addressing the issue identified with the specific query described below. Detailed logging in a development environment has pin-pointed that half the time taken by the scheduled job opening this cursor:Job_Cost_Calculation_Util_API.Get_Emp_Std_Agreements___"get_rec"This cursor joins to 2 views (rate_agreement_detail_uiv and job_transaction_parameter_uiv) which both do expensive PIVOT WITHIN GROUP operations pivoting data from child parameter tables. Then this query takes the results of those pivoted views and tries to join to them in a complex filter. The job_transaction_parameter_uiv join is efficient because it uses transaction_id directly pushing the predicate into the view. However, the rate_agreement_detail_uiv join does full table scans to create a data set o

Community, there are “Cost Center ID”  field in both Manufacturing Labor Class and Work Center window. See screenshot for both windows.My question is, if I had Cost Center ID entered in both below 2 windows, will this value be travelling to GL in the end? in other words, will it be showing up in the GL code string (Cost Centr)?  

Hello everyone,Just wondering if anyone knows how to enable writeback on the GL Period Budget information source?  Has anyone done this before?  How is the writeback interface created? 

Hello, We are moving soon from IFS10 IEE to Cloud and I am testing New Customer Check.I am trying to Write-off a small difference, but when I click Finish I receive the message that WO Notice Item already exists.I checked the screen WO Notice Items and I don’t have anything there. Also, I don’t have any WO proposals.What else can I check? Thanks,Cora

Hi, We have a new user and have set them up to view posting proposals but the multi company radial button doesn’t appear to be working.The user can get data in each individual company but the multi company doesn’t work.The user is configured in both Invoice Posting Authoriser and Invoice Payment Authoriser. They are configured as a super user and can see the data individually.I’ve confirmed it’s not a permission set issue but I can’t track down what alternative setting would cause this. ThanksHelen

In IFS CloudMost customers have a valid email in Communication Method. Some don’t.When printing Reminder, a report rule is set up to send the reminder by email to this customer. But for the other customer, how can i set up a report rule to print the reminder only for customer without email?

When it comes to tax calculation with cash discount in Belgium it works a little different then IFS standard. In IFS there is a setting on company which says “tax reduction on discount”. This option lowers the VAT if the payment discount is deducted. However how the Belgium TAX system works is that you need to amend the base amount of the tax regardless of if the payment discount is used or not. Are there any other customers that have this issue in Belgium? How do you solve it?  

Version : 23.1.4External file template STDFRBNKSTAT is used to import standard external CFONB file (file template issued by French banking society)External File Template​​​​A dedicated external file template STATFRANCE has been created by copying standard template STDFRBNKSTATBanking file import has been done based on STDFRBNKSTAT templateExternal File TransactionsHowever lines starting with 04 have not been importedError statement ‘Unpack error’ : “Format de valeur ou symbole décimal non valide dans le fichier chargé.” Meaning format not appropriate Possible root cause:  Standard banking file incorporate alphanumeric values in amounts (eg E on below screenshot).These values are used to determine signs and others information. Below matrix to interprete these values I need some assistance to resolve this issue. 

Hi, Is there any link between Revenue Recognition Forecast and Project Forecast? I am wondering that, how Revenue Recognition Forecast updating would be more automatic instead of update POC % / Amounts manually each month / quarter? Thank you already!

 Hi, I want to create a new external file type, but I can , there is no action avalaible  on the page,is it possible?Thanks 

Hi All I have some posting controls setup for T1 and 2 that define Code parts A,B,C which seem fine however on the T1 postings for labour i am seeing Code part D being used as well which is correct but i have no posting control in place. Does anyone know if there is any rules or processes that would add this extra code part in ?