Finance (Financials)

HI,I ran a consolidation balance analysis report but do not see the balance of the master company included there. Could you please advice how to derive final consolidated balance for the whole group?e.g. GL Balance analysis of the master company has the following balances.This is the extract of Consolidation Detail analysisFor account 3011 - The balance only reflects the amount transferred from the joint venture.Kindly advice.Many ThanksL.K

We have a project where when we run revenue recognition, the revenue is split between two different profit centers. Is there a way to set up the financial project to be able to do this? We did a test whereby we did the below in the reposting tule of the financial project but when we ran revenue recognition, the voucher still directed all revenue to a single profit center.  Would appreciate any thoughts/suggestions. Thank you.

In the revenue recognition detail there is a column for Product Line . Does anyone know where this product line field is pulling from ?  One of the projects need to be a different product line so we are trying to figure out where the change should be made. Any thoughts/assistance would be much appreciated.   

I have a issue I someone can help me with. I will period allocate a F voucher in view Voucher Entry, but i don’t have access to the functionally.That do I miss? I fields are locked. The customer has more than one company and I am apply to do it in the other company.  

I am having trouble finding how the supplier Invoice Tolerance Parameters and the Invoice Posting Authorization works together.What I would like is if the Invoice and Purchase Order are within 5%, not require a authorization.  Over 5% deviance, requires posting authorization.I just have had trouble finding documentation on how these work together.

​​​​​​I need help for  Overhead Adjustments and Weighted Average Cost Detail.I check as below step for “machine overhead1”,”machine overhead2” and “shop order Labor overhead” overhead adjustments and I think Overhead Adjustments only conside cost source ID and accounting year, not conside account no. correct?if yes, what’s the possible reason and where I can check if cost source setup have issue?as below picture 1,we preform the overhead adjustments records which we can found adjustment ID  and cost source as below picture 2, I qurey the “MPCCOM_ACCOUNTING” table for first step adjustment ID  and cost source. if i group by adjustment ID and cost source ID, the balance is 0. as below picture3 ,if i group by adjustment ID ,cost source ID and account no. I found many account no balance not equal 0.second I check the “Cost Details Basic Data” as below picture 4, I want to know for shop order partial receipts where

Hello IFS Friends, When using Oracle SQL Developer I get a different value for balances of GL accounts vs using the GL Balance Analysis screen in IFS. We’re on IFS 10.11 and I’m using IEE. Logging in user App Owner in both cases. Am I using the wrong view? Below is my SQL Query and the result:    And here’s the same searching using IFS front end GL Balance Analysis screen, but getting different result:  System info is telling me this is the right view: 

Is it possible find out who authorised a Depreciation Proposal, it does not seem to be stored in any table?

We have issues with our “Final Invoice Posting” scheduled database task. Some of the supplier invoices post successfully, and others are skipped and have to be manually posted.We have tried running the Task manually and it always skips the same invoices. When users try to manually change the invoices to Finally Posted, they do not receive any errors. Any ideas why the task would be skipping some invoices and not others? Below is our task setup: And an example of one of the background jobs where some invoices are skipped:

We encounter an issue when we enter a customer check for a customer who is set up as “other payer” for multiple customers. We can go in and match the invoices, but once we hit finish, it only matches those invoices that match the Payer Identity and puts the other payment “On account. We then have to go in and perform an offset to apply the payment on account to the invoice. In App 9, this wasn't an issue, and it would match all the selected invoices.Are we missing a step or any required basic data set up?Any insight would be appreciated.   

Hi,We have received an invoice from a supplier but the quantity invoiced was lower than stated on the GRN / PO. We allocated the invoice against the correct quantity received, leaving a balance remaining on the GRN.Since then the PO has been reduced to match the quantity invoiced.  (Incorrect amount GRN’d at the beginning).Can the amount GRN’d be reduced so it removed it from the GRNI as we will not be receiving the balance?The invoice has been paid in full in April 2024.Thank you,Lisa

Hello Community,We have a number of customer invoices that are paid, but the payment was not connected to the invoice. This has created a Customer Ledger Age Analysis report that is incorrect. Is there a way to mark these Invoice paid, so they fall off the report?Thanks. 

When we try to close out a period, we get this error message that there are vouchers in the hold table.However, when I look in the hold table (Vouchers Analysis/Voucher Rows Analysis) it is blank, even using admin credentials.I was able to find these transactions in the database (select * from voucher where voucher_status <> 'Approved').The vouchers causing this issue are all Voucher Type T and have negative voucher numbers. They are all in Not Approved / Waiting voucher status. I also checked that these transactions do not show up if I try to run Update GL Vouchers (with wide open parameters. How can we approve these vouchers?What would cause them to get cre

Hi,HSBC requires an SUN (Bacs Service User Number) so that it comes out in the ISO20022 Bacs xml file.It should come out in the <Dbtr> Section as the <Id>. Where in IFS do we enter this data?<Dbtr><Nm>The Company Ltd</Nm><Id><OrgId><Othr><Id>123456</Id></Othr></OrgId></Id></Dbtr> Thanks for any help.Cheers,Graham

Is it not possible to change the block reason of a customer order that is currently blocked? In this instance, the order was blocked for being over credit limit with an advance invoice created shortly thereafter.  I would like to change the block reason to reflect that an advance invoice exists, but there is no capablitiy to do so without releasing and reblocking.  I do not want to unblock the order as this will trigger purchasing events to take place.IFS Cloud

Hello,  We are trying to migrate from 7.5 to cloud, is there a way to generale a balance sheet from this version without using business reporter ? Best regards.

Hello,I thought I understood this screen but I have a questionI invoiced a purchase order with an amount of 0 instead of 100, I thought that the revaluation would affect all the movements of stock on this lot but I see that it affects other lots and some movements not others why?Do you have a document to help me understand this item? My customer is asking me to detail all the movements on this transaction.Item purchased at PUMP see PJThank you for your help Translated with DeepL.com (free version) 

Hi, There are no supplier payment orders open but when the customer is trying to create amixed payment,  system generates an error message as below. Seeking for an answer!  

Hello,When establishing a company, no period-based receipt series was used. They currently want to switch to plug series like this. Is it possible ?Thanks

Hi,We have a scenario where FA Object is fully Depreciated by 31/05/2024 on our Registers but on the system, the Object still has some Values to be depreciated.Based on the users information, the depreciation commenced on June 2016, However in the system the depreciation started on December 2016Kindly Assist us on how we can manage the Remaining balance which is not depreciated yet its supposed to be fully depreciated. Thanks in Advance!

Dear community, I am having issue with cash discounts calculation. Here is my scenarioCreate a payment term with tax distribution is set to First Installment only Tax Enter a discount for 2nd installment   Create an invoice with a tax code 0 and tax type TAX. Go to installment plan and discount. No discount is calculated for 2nd installment.    I am using 24R1 for my testing. Is anyone able to create an incident ticket for this? Thanks

When working with supplier invoices it would sometimes be handy to be able to transfer posting rows from Excel directly into the posting lines in Posting proposal.We could call Rest Apis that add lines into the posting Proposal. Could that be possible to do from Excel? Would be a nice feature if you had the excel table and entered Supplier id + invoice no as parameters and then it would transfer row data from Excel: Account, Cost center,  Amount directly into  Posting proposal.  Has someone created such? 

Below is the Planned Cost of a project we have. We are now expecting actual costs to be much lower than budgeted. We would like to somehow reflect this new expectation in the planned cost but not completely remove the original planned cost amounts. Is it possible to add a new cost element with a negative planned cost so that the total planned cost is reduced? Any thoughts/suggestions would be appreciated.  

*Please see attached file* We have a project with the following financial project settings:    In the prior period (period 9) after running revenue recognition, the accumulated recognized revenue was modified to 2,591,784.68  (cell AB9 in attached file). Accumulated margin is thus 33.85% . This was done because we decided to take more revenue in the period since there would be little to no additional costs to be incurred. In the current period (period 10) after running revenue recognition, the accumulated recognized revenue fe

Hi,Can I please know the purpose of using Alternative Estimated Life for depreciation. Thank You,L.K