Finance (Financials)

Hi Community,When a credit note is being entered to a project invoice, and in that credit invoice if there are changes to be made to the amount quantity. How can that be done?For example, when the credit note is created, if the quantity is mentioned as 6 hrs but however, only 4 hrs needs to be credited (which means 2 hrs to be charged to the customer). How can this be done? When the internal quantity or sales quantity is changed, the system gives an error message stating that only invoicability and invoice comments can be changed. Will appreciate your assistance on this.Thank youNisha

Hi, In one company can we have a set up that on some customers the tax code is fetched as per address and on some customers the tax code is fetched from Customer card’s invoice tab? Customer would like to have this flexibility as they could have several delivery addresses on one customer but same tax code on all those address, so they are looking for less data maintenance.Br,Rutuja

How do I do Manual Transaction MAthng?The company never used Bank Reconciliation  and we don’t have a Bank set up/linked to IFS.We would love to do that soon, but first how do I reconcile just  by using Manual Transaction function.I have cash transactions in there showing since 2019 but I only want to reconcile 2022. So i just take my bank statement and click boxes?  How do I get rid of all previous years’s data?Also what do I enter as Reconciliation date? Do i enter month end for the period i want to reconcile - what is the function of that date? Please Help???  thank you 

Good Afternoon - We have a GL Voucher showing a value that does not match the project transactions for this specific period. The GL  voucher total is excess to the transactions. Can anyone please suggest the best  way in which a Voucher No can be interrogated to see all attached costs. Thank you.   

Raised on behalf of G2350022 The Document Attachment Icon not appearing in Fixed Asset Objects Window - Aurena for one user. Please assist on how to allow the user to access attachment icon Best regardsZuha

Hello, I have a problem with the tax codes for supplier invoices.I have a purchase order with 2 lines with 2 different tax codes.When I create the supplier invoice, I get the 2 lines with the right tax codes .But at the level of the posting lines, I have the impression that IFS takes only the first tax code and applies it to the two posting lines. I have attached the screenshots that correspond to thisAny ideas how to solve this problem? Best regards

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,Does anyone have information on how our CAMT solution will behave in handling batch of payments? That is when bank batch all our low value transactions to one line? In this case bank will create their End-to-End ID based on the payment information ID we send in our ISO files. Does it pick the payment order from this payment information ID? How payment order acknowledgement should be done in this case?Also, how will it handle the returns? If both generate the same family code, and if the differentiating factor is sub-family code?   Best Regards,Sanusha.

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.