Finance (Financials)

Hi All,We have come across a requirement to run customer interest proposal including specific customers.  But the existing functionality allows to run the proposal only for a specific range. Therefore, it is requested by users to add a new option as follows.Introduce a new selection Parameter “ Customer : Include Specific Values” Add a new cell to specify customer ID alone with Semicolon (;) Field to enter the semi-colon separated list would appear where you see the From Customer field . Only when this parameter is selected,  From and To customer fields would be hiddenQUESTION : Since this is a modification , can you suggest an alternative to obta

Hello, I would like to add material overhead on consumption on project (Posting M62).Is anybody know how we could do this in IFS 22R2 Thanks

Hi All,I'm getting following error message when saving the customer order. Tax code can only be entered from the tax lines dialog for the customer with mixed tax regimeTax code is selected manually. All basic data is already set up.( sales part is taxable and Customer does not have any specific tax code in delivery tax information tab)RegardsNaadira

We originally setup our Company with Site (WA), and have created a new Site (QLD) last year, and recently again this year (SA)Our finance team have just noticed that the QLD ARR-NONINV Purchase Transactions are not transferring (manually or via a scheduled database task)-there are no errors -just sitting as Status Created-the financial period is open and this is occuring for new Non-inventory PO receipting done under all users even IFSAPP-Site WA and SA both are transferring fine Any help would be hugely appriciatedCheers 

In IFS APPS10, I have a need to restrict the number of characters that can be entered and saved into a specific field.  It is in Manual Supplier Invoice screen → PO Ref field.  I am aware that an IFS Event Action can prevent an action such as this and return an error message to the user.  Can anyone provide the Online SQL code for this?  Also, please advise as to returning a “soft error message” which would be returned to the user but not prevent the user from saving their record. Thank you in advance, Dave

Hi Community,There are two issues with regards to project credit invoice.Issue 1A new project transaction line is entered copying an existing project transaction line. This is entered as a positive entry so that the negative and positive entry is set off in the project credit invoice.Please see below screenshot. The green highlighted line needs to be set off against the blue highlighted line. However, this does not happen.Does it have anything to do with the transaction source? The green being a credit invoice and blue being project?  Issue 2When a project credit invoice is created, some of the project transaction lines attached to a project credit invoice line are removed. For example, if there are 5 project transaction lines attached to a project credit invoice line, 4 lines are r

Hi, I have a Business Requirement to split out my AP and AR control accounts by site for financial reporting.To satisfy this I have a Code Part set to Site and I require Posting Type IP1 & IP2 to have the control type C5. Any ideas welcome.

Hi .We have added some investments to objects that was already active and included in the depreciations each month.After a while we noticed that the depreciations are not working anymore for those objects. We have now activated the new investments (add investment). But now when we try to do the depreciation we get an error message saying:This is because there are depreciations that should have been done in 2021 and 2022.How do we solve this problem? We want the “catching up” of depreciations to be done in 2023.

Hi,How to properly configure so that if the customer exceeds the credit limit, the customer's order will be blocked or a notification will be displayed.

Has anyone been able to set up the intersite profitability between 2 companies?  The documentation only mentions this is available between 2 sites within the same company but we have a need to use this across companies. I’ve set up both companies to allow intersite profitability but the posting controls are not triggering. We are using 21R2.

Dear all,Transactions are stuck with status 99 in the distribution and manufacturing posting analysis .M92 posting type is missing from the entry.posting control window.   Any idea as to what caused the automatic posting (M92)to be missing? Many thanks Udanee 

Is there any direct way to know the Reconciled ID of an invoice when it is matched with a bank reconciliation?Currenlty we need to manually navigate in the Cash Account reconciled transaction analysis to find the reconciled id of a particular invoice

For quite some time now we have been struggling to get the ISO20022  pain.001.001.03 file to transfer Plusgiro payments for us. Danske Bank has told us not to use the combination SESBA and 9600, but to leave these both fields blank. It all sounds simple enough but we just don’t seem to get it right anyway. Any clues?

Hi Team, I have invoiced a customer order and ran the job “Create Customer Order Details Statistics” for statistic type invoiced sales. Still, this does not create any record in “Detail Statistics - Invoiced Sales” window. Are there any specific basic data to be entered or steps to be followed in order to generate records in  "Detail Statistics - Invoiced Sales" window?      Thanks.Nagarjuna

Hello all,We use an external programme to manage employee expenses and we wish to upload the expenses as external supplier invoices to IFS to manage payment and accounting. The problem is that these invoices will not have POs to match to in IFS and therefore the posting proposals can’t be posted to the GL as they are unbalanced. We are able to get around this by manually adding a line to the posting proposal to in order to balance, however, with the amount of expenses (supplier invoices) we process this will be very time consuming.Is there a way to process external invoices with no PO’s to match to or a way to automate the inclusion of a balancing line on the posting proposal? The invoices can be automatically authorized and posted in IFS as they are already manually authorized in the external programme.Thanks in advance! 

Hello, I would like to know if the customer ledger age analysis report is available in cloud version. Thanks 

I am getting syntax error when trying to join SQL query with IAL table. Any clues??  select order_no, order_date from( select *from ifsinfo.icfr_pro_116bwhere project_id = '20012') X join IFSAPP.purchase_order Y on X.order_no = Y.order_no  ThanksHousseiny

We have an Instant Invoice in status PostedAuth that we need to cancel.  Per the field level help in IEE it’s possible to have a Status of Canceled, however, there is no right mouse button option to cancel.  Is there a way to cancel this invoice?  If not how do we clear the amount due from the customer and the AR Balance and correct our revenue account. We are using APPS10, UD12.  Thank you.

Hi all, Getting below bug: ORA-20105: Invoice.ACCERROR1: Error (The Currency Posting Amounts for the Invoice XXXXX are not Balanced) occurred while booking Invoice CR XXXXX   How to debug?    

Hello! We are having an issue with a purchase requisition that has pulled through the wrong purchase authorisation rule. We have seen this before where there was an issue with the purchase group however for this purchase requisition there is no purchase group on the PR line. I’m unsure if this is relevant as well but the issues we had previously were with “no part” PRs and this issue has arisen from a “parts” PR. I have tried to recreate this to see if it was a fluke error however every time I try to replicate the PR, it still pulls the wrong rule through. Any guidance would be greatly appreciated Thanks!

We are merging two companies and therefore using the function Transfer object in fixed assets.When we come to objects that are fully depreciated we get an error message saying that transfer amount need to greater than zero. We want to transfer the acquisition value and the accumulated acquisition value, even though the net is zero.The error message when we try to create the transaction in the transfer object  - progress view! 

Hi All,Could anyone share guidelines on how to set up a solution design for extracting Finance/Treasury data from a third-party tool and into IFS?  

The Norwegian Tax Template S105 used for VAT reporting can now create an XML-file which can be uploaded to the Tax Authority manuallyUnfortunately, I need more information … perhaps more basic data to be able to set this up.Does anyone have a “set up guide” for this ?  I have use the pdf created for update 16 as a documentation…..

Hi IFS community, We have a situation on our end, For a specific supplier a PO was created, we received the invoice after the service had been provided to us and we registered it in Manual supplier invoice without entering the PO number in PO reference. We received the PO through register purchase order arrivals and the PO to closed. However, now we noticed that the costs have duplicated in IFS which is not great. Please is there a method to reverse the duplicate costs? Thank you in advance.

Hi IFS community, Is there a function within IFS to validate all association numbers within IFS? A function which would show which association numbers are correct and the ones which are not. Thank you in advance.