Finance (Financials)

Hello, Has anyone more detailed information on the full setup of the financial connector? I have done the setup to transfer Customer Invoices. I got to the point that the application messages are generated and xml files written to SFTP.  What I don’t see is data in Transferred Customer Invoices Analysis screen. This makes me think the setup I did is not complete. I’d appreciate any feedback from anyone that worked with the Financial Connector before. What I was able to do thus far regarding Transfer of Customer Invoices via Financial Connector:Make sure Send_Customer_Invoice is enabled + correct Receiver/Sender is set  Define for which companies the transfer process should be executedDefined Routing Address:Defined Routing Rule” Run Transfer Customer InvoicesApplication Messages are generated and files transferred to SFTP:Invoices also appear in Customer Invoices in TransferHowever they don’t appear in Transferred Customer Invoices Analysis screen. This makes me think the process is no

This post is related to : Subsidies / Discount for customer orders | IFS Community Some of our customers receive subsidies from organizations.If the subsidy covers, for example, 20% of the order amount (tax are not included), we need to invoice 20% of the item's price (tax not included) to the funding organization.  We are trying to proceed as follow : Creating the Customer Order for the right customer. Creating invoices :  First invoice wich is a regular for the customer himself Second Invoice is an instance invoice for the other entity We are having deficulties on how we should affect the right price to the right invoice.After saving the instant invoice we a “More Information” option on the header.We have referenced the original invoice (Ref Invoice No with Ref Invoice Series ID)And we have defined a deduction group hoping that the group will automaticly calculate the invoice amount We have defined a deduction group and rule    The instant invoice is still with no amount. Any idea h

Our Spanish company will soon be obligated  to report the SII Tax report to the government. We are doing the base data set up in the application. However we need to know if the XML file that will be generated will be covering the legal requirements of the Spanish government.We're on Apps10 UPD 15. Can anyone answer if our current environment have the current XML standard for the SII reporting? 

Hi All,Need your assistance on the below query.When performing the Group Consolidation, getting the below error.Wrong requirement for Account xxxx. Please Check the Code Part DemandsWhen we checked the GL Account, the code part Interco has been set as Mandatory.  We could change this to Can and process, however, this needs to be set as Mandatory according to the business scenario. Can anyone let me know how we could fix this issue and at which point the the code part needs to be defined. Best RegardsRazan   

We have a problem,  in cloud 23r2. When a person who are included in a invoice posting authorize group wants to change invoice recipient in invoice row. We receive an error message saying “you are not authorized to do modify or change authorizations. “ If the person changes invoice recipient to him/her self and after that changes to the right / new receiver it works perfectly. Is this a bug or something we missed in basic data set up? 

Dear all,Seeking your valuable inputsI cannot view the GL account wise customer ledger open items balances in the report. Since the GL account is not visible in the print preview.I have tried all the report parameters (selected the GL accounts) ,created a new layout, viewed the summary  but no luckGL accounts will be visible like this only. Unable to see the customer wise GL A/C valuesViewed from totals per code part values . But report does not view the GLPlease adviseRegardsNaadira

Hello,Some of our customers receive subsidies from organizations.If the subsidy covers, for example, 20% of the order amount, we need to invoice 20% of the item's price to the funding organization. How can we manage this in IFS?Is it necessary to create two orders for the same item—one with an 80% discount for the organization and another with a 20% discount for the customer?If two orders are created, how can we communicate to the customer that the 20% discount is linked to a subsidy provided by the organization? Thank’s for your help in advanced 

Hi,We are planning on importing most of the manual vouchers to Aurena/IFS10 with the external voucher function. Is it possible to import also the header info? I’m looking for the possibility to get the title (marked yellow in the picture) for the manual voucher to be visible in the GL Vouchers Analysis. 

We have an error on the posting lines of a work task transaction that we can not solve.We closed a accounting project, and after a while we had to reopen it due to a guarantee claim. We opened it, created a new work order and task. We created a Purchase order, We registerd the arrival and the supplier invoice.After that the transaction state is “Overtaken” but the posting lines that should be in Status=Valid are in Status =”Error”The error is “The value XXXX used for the code part Cost Cent is either missing, is a budget/planning code part value or has invalid time interval.” But when we reopened the accounting project we modified the dates on the porject and also on the activity. We have run the task “Check and update Accounting”, We have run the task “RErun Erroneus Work Task Postings”  and the “Transfer Work Task Reposting Transactions”  but the error does not disapear.Do you have any suggestion for us?Lucía

In the supplier payment proposal there is an option to do a supplier offset if there is a credit. This will take out the credit note out from the payment proposal and the payment advice / remittance will only show the amount that will be paid. (which is correct)Is there any way to show the credit note number and amount that was offset against the invoice in the footnote of the payment advice or is this a customisation ? 

I have been tryong to edit a Report using Report Designer, but whatever I do, when I go to print, the change is not visible.The users want to add a small gap between Invoie No and Date on a Customer Ledger Open Item report. I exported the Schema, Layout and Style Sheet to my local PC from the Report DefiitionI opened the report and found the relevant fields an moved them about to create the gap.I saved the report and could see that only the the xsl file had been updated.I re-imported that xsl file back into the Report DefinitionBut when I run the report, nothing has changed. The 2 fields still run into each otherWhat am I missing?I suspect I am missing a step, but what I have done SEEMS correct.Anyone got any idea what I am missing?ThanksRoger

Is there any way to identify the preliminary customer invoice no for specific Invoice no after Invoice posted from Backend or Front End based on the final invoice no.

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 Custom field, I get the above errorDoes anyone know what the issue is?We are using Apps9 Upd 17Any ideas? Is this a bug with IFS or have I missed something basic?ThanksRoger

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 095201 Man. Supplier Invoice with negative amounts (Debit Note) ($ -200.00) 15 095201 Man. supplier Invoice ($ -100.00) 15 095201 Man. Supp

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