Finance (Financials)

Hi Community,My customer is facing a problem when loading in external file. They are trying to read in a text file with file type .dav but the system gives ‘’restricted file type’’ -error. However, the workaround they have been using is to just rewrite the file type form .dav → -csv after which the system allows the file.Does anyone have any idea why doesn’t the external file template allow the file type .dav?In the input file load file type we have allowed all file types. Also, it was tested to only allow .dav files but neither works for this. 

I am trying to create a Read Only custom field (P2P_EXEMPT) on the Posting Proposal screen that looks at another custom field (P2P_EXEPEMTION) on a different screen (Supplier) select cf$_IR35_exemption as P2P_EXEMPTfrom ifsapp.SUPPLIER_INFO_GENERAL_cfvwhere supplier_id=:identity As sql this runs and returns the CF2 valueHowever, when I put this code into the CF1 build, I get this error when I try to Approve the new field  I have tried both v and t in the ArgumentI have tried everything I can think of and everything gives this errorI have tried this direct accessI have tried using an IALI have added a function to a an APII have created a functionIn all cases the object works and I can select the value I want BUT when I try to out it into the Cust

We have a number of projects that we keep getting an error stating 'Project cannot be completed until all active acquisition values referring to this project has been moved in IFS|Fixed Asset.'The process to follow to get the error is:Go to Financials|Project Accounting|Project, then search for one of the projects, RMB and select Rollback Sub Project Completion. Complete the necessary fields on the window and click ok, this is when we then get the error.In Object Transactions Analysis window those objects/FA records are with object transaction value type as "Acquisition" and status as "Ready". Please guide to resolve the error above Best regardsZuha

Has anyone come across this issue when trying to register arrivals of parts on an RMA?  We have recently migrated to Cloud (currently on 23R1.10) and have raised an RMA (connected to an order that had originally been invoiced in our Apps9 environment).  There are parts lines and two Charge lines.  When we view the Tax lines on the original Customer Order they are blank.  It is a zero rated tax order so the tax amount is zero but we would expect there to be an entry here showing this.   Any thoughts/suggestions/ideas would be appreciated.  

 We recently updated to 24R1 and noticed that a function that is used frequently by us for manually posted invoices was removed. The ability to copy and paste posting information. This is used due to our authorization combination rules that many within the company fail to recognize. After filling in the posting information authorizers and acknowledgers are removed leaving the invoice in status “Balance”. The easiest way to sole is by copying posting information, deleting and pasting to trigger the rule.  I can not find a reason to why it was removed anywhere and if it will return in future updates.   

We are working to get to a point of using the IFS Bank Reconciliation, but need to mass update existing transactions from the past several years.  (Reconciliation was done via spreadsheet outside of IFS)I am able to pull the data into the Migration tool, updated the Matched field only, but when I try to validate or execute I get the following error:   Field [IDENTITY] in Payment Transaction may not be modified.We are not changing the Identity field, is there something that can be done to make this work? 

Hi All,Is there any setting in IFS Application to pre-define the Aging Periods which we have show below without filling it manually when executing report? Regards,MalinG

Hi,Does IFS have a dedicated screen to automatically match Credit Card transactions to expenses? Similar to Automatic Transaction Matching for bank reconciliation. I'd be grateful if someone can briefly share the end-end credit card process from Credit Card statement upload to matching expenses. Best,Shah

Hi IFS 10, Have a leasing contract , that are in use and recognition posting against FA- with 5 term. Now are the leas contract change - to be shooter - so er need to take away the last terms - we have modify the schedule - but can not take away the period for the last term or the last term ….   How to modify a leasing contrat to be shorter ,, 

hello,We have a fixed asset object which is activated in year 1 period 6. This is a 5-year asset using MARCRS 5-year depreciation table (1st year 20% depreciation, 2nd year 32%, 3rd year19.2% 4th year and 5th year of 11.2% and final year 5.76%). The asset is activated and depreciated for year 1 and 1st month of year 2. In 2nd month of year 2, additional cost is added to the object. Now if the object is depreciated for remaining life, the total % depreciation amount does not line up with 5-year MARCRS depreciation table (1st year depreciation is now 18.56%, 2nd year is 32.34% etc.). Is there a setup in IFS that automatically performs a “catch up depreciation” operation such that the total % match the 5-year MARCRS table. I tried using add investment, add acquisition value and other operations but did not get the desired results. This testing was done in IFS cloud 24R1. 

 Hi all,I have a Fixed asset and I received 2 credit notes that are supposed to decrease the acquisition value.I registered the first manual supplier invoice and updated the GL.Then I went into the screen Add Investment. I have found the corresping line in the screen Add Investment progress.Then I registered the second manual supplier Invoice, also updated the GL/But nothing fetch into the screen Add Investment… for this Credit noteany idea why.As you can see the first line remain at the externally created status… and need to be activated.  

According to the current behavior of the IFS system, when creating a payment proposal using the ACH payment method that includes both debit and credit invoices for the same supplier across two companies, the system does not consolidate the amounts into a single total for that supplier. This behavior is observed when the debit and credit invoices belong to separate companies.Due to the discrepancies between the Calculated Total and the Batch Total in the ACH file, the ACH file validator has rejected the file as incorrect.Above issue has been demonstrating by using an example below.Create/select manual supplier invoices as per below combination. Core Company Core Supplier  Inv Type (Credit/Debit) 10 095210 Man. supplier Invoice ($ 1000.00) 10

How to set up payment terms to consider only business days in the calculation of the payment due date?

I get the following error when trying to delete and accounting group. What setup is this tied to that is preventing this?  

Hi teamI would like to understand the functionality behind the “Use Default Payment Method for Installments” option under the Supplier/Payment Tab.I know that when this toggle is enabled, the default payment method is updated in the supplier invoice or installment plan. However, my question is:When this toggle is enabled, is there a limitation that restricts payments to the default payment method only?I have the following scenario:The above toggle is enabled for the supplier. The supplier’s default payment method is ACH, but CHK is also connected. I hve created an invoice so the payment method in installment plan is ACH Create the payment proposal and the Payment method % -So my invoice is included to the payment proposal But when I try to create the payment order for the payment method CHK,I get below error

how to determine external/internal value in cash plan detail screen. ?

Hey Community, we want to use the customer credit management. Does anybody know how to limit the access within the tabel “Customer Credit Analysis”? So far if we set up CRM for each customer, everybody which has access to that table see the turnover of the lase 365 days of all customers.In Credit Management Basic Data it is possible to set up Credit Analysis Groups and allocate User to that Groups. Nevertheless we set up such group with only one User, and allocate that group to one customer, all other user are able to see the Customer Credit Analysis for that Customer.regards Sebastian

When using the bank statement template/upload function for bank reconciliation, how can I upload a Cust/Supp ID on the bank statement for automatic matching?

IFS CLOUDI would like to know some information related to Spain Localization .1.In our TEST environment, it was possible for me to enable Spain localization and do the necessary mapping for SII and Generate XML, however i have not configured IFS connect for this yet . Does this mean that i can enable the localization without further cost?2.If there are some instruction on enabling transformers to get the Generated file , please provide steps2.Also When i enable this Localization what i'm interested only to use SII but with that one more service get enabled and it shows this is mandotory . Does this mean I have to use that as well. We are currently manually preparing this 347 to 115 . We haven't planned use this functionality right now but later on . can you please if this is mandotory to use it ?3-. To submit SII , should we use third party service to submit this to TAX Authority . is it a must or are there any alternative

Hi. I accidentally uploaded 4,000 invoices when I just needed 1. For each line the invoice number had 1 added on to it when I dragged down formula for 4,000 lines, therefore creating 4,000 separate invoices. Is there a way to mass cancel all of them without doing it one by one? Thank you

Hi All,I'm trying to create project invoice and it gives me this error . tax liability with exempt liability is used on this project invoice but tax free tax code missing.The customer is not exempt from tax .Report code is also with VAT .Can I know why this error message is coming which seems to be misleading.Thanks Udanee

HiIs it somehow possible to get the customer reference automatically in instant invoice?Today we need to add the customer reference manually in the “More information” tab. When e-invoices are sent, customer ref is mandatory and it would be much easier if this filed had the customer ref inherited from the customer card. 

When uploading a camt054 file containing only supplier payments which are paid from the same cash account, why does IFS create serveral external payment load id’s? In will then result in several mixed payment?What is the logic between one camt054 file and numbers of external payment load id’s (EXT_PAYMENT_HEAD). I thought it was cash account and date, but there must be something more

Hi Team,When company is not setup to copy the preliminary voucher as final and same time automatic allotment is not enabled in vouhcer type, how we can enter preliminary voucher ID , manually to Final invoice ?This is a posting proposal company

Hi All, I was wondering if someone would be able to help with an issue we have when trying to post a customer invoice please. The invoice in question has popped up on the ‘Customer Invoices with Errors’ screen. When clicking into it to see the detail of the error, “ORA-20105: Invoice.ACCERROR1: Error (Connected advance invoice AD XXXXXXXX already Settled/Cancelled.) occurred while booking Invoice CD XXXXXXXX.” pops up with the Advance invoice and invoice number details. The Advance invoice was paid on 29/08/2024 but it looks like we have processed 2 mixed payments, One on 29/08/2024 which was approved and then one looks to be dated 30/08/2024 which was cancelled. Both mixed payments included the payment of the advance invoice. The CUPIA from the payment on 29/08/2024 looks to be on the account, as it would normally be when an advance invoice is paid. Hence why we are confused why it is saying its ‘settled/cancelled’. We are una