Finance (Financials)

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

Hello, Community!We faced with issue, which can’t even detect. In some invoices during posting process strange rounding appears in accounting currency. It looks for me as a bug. So some invoices detected as invoices with errors and error is: When we try to proceed invoice with errors all rows post correct exclude Trade debtors: by some reason  Amount posted correct but Amount in Accounting currency posts only in VAT part - Net amount in accounting currency posts as rounding.  That’s how invoice looks like: 

Hello,I have an issue with modifying file ISO 001.001.003, since my customer bank's PKOBP is using format 001.001.007. Is there an option to modify the format or upload a new format that aligns with iso:20022:tech:xsd:pain.001.001.07? When uploading the current format  ISO 001.001.003 to the customer bank I receive an error notifying about the wrong file structure. Regards 

Hello,  I created and posted a customer invoice. Right after that I created and posted a final customer invoice. When the advance invoice was paid, the status of the final invoice remained “Posted Authorized”. IFS did not match the paid part  advance invoice with the finale one. When I checked the postings I saw that the part related to advance invoice payment offset with the final invoice was not generated. Any thoughts why ?  Best regards

Hi all,Our accounting department came up with difference on the report which is ifs’s standard customer transaction report(pdf).The report that I had a bit chance to review details and noticed that an advance invoiced was matched 2 payment separately.(currencies: invoice usd, payment usd, company eur)The transactions probably proceeded as follows: IFS converted invoice currency into company currency and calculated difference due to rounding. Then posting control pp13 worked and added line for the amount of difference. (fx gains)I think the report shows wrong value and wonder that someone might have experience similar problem. It should have shown as 418,12 instead of 418,14. There might be another difference.ps: For related account gl opening and closing report is not showing any difference.Here is the gl vouc

This question has already been submitted but not answered apparently:If we print an instant invoice there is the option of the User Group and then voucher type.However if we send the invoice (E-INVOICE), we cannot choose it, so it selects default ones.But that is not acceptable as we may need to select normal invoice voucher type or credit invoice voucher type. So how can we select this option prior to sending ? So far the only way is to send the invoice in error and then select the right voucher type from Invoice in Error view.(NB: we are using APP10 Entreprise Explorer upd13)

GR’s for one of PO creates with total quantity of the PO lines and not by invoice lines , Here matching in this case not possible , do we need to correct the GR’s as per the invoice to complete matching  please help?