Finance (Financials)

We cannot find the reason for the unbalancing .This voucher has not yet been created in the system.We tried technically to find what values are getting fetched to this voucher 2024000032 in the database .There is a difference of 314694.5 between debit and credit values It seems that there is no method of  getting a  breakdown of this 314694.5 to see what is causing this difference.Kindly need your input on how to find it .                               

Hi,We're currently experiencing an issue where certain suppliers are not showing up in the payment proposals, despite meeting all the expected criteria. Here's what we've checked so far: First possible pay date: 04/18/2019 Plan pay date: 04/18/2025 Invoice status: PostedAuth Currency: Correct Payment method: Correct No debit balances on the accounts Supplier bank details: Verified and correct Invoices are due or overdue No advance payments have been posted Based on all of this, the invoices should be included in the payment proposals, but they're not. Are there any other settings or criteria we might be missing that could prevent the invoices from being picked up?Thanks!

Hi Friends, I am getting the below error while executing currency revalution. Can anyone help me on this?Note: Client do not want to exten the project validity  

I have watched the IFS Business planning videos in academy and when trying to execute the planning rule for AR balances I get an error ‘’ The currency code GBP is not valid in the currency rate type 1 in company...’’I have checked that the GBP currency is valid in the currency type 1, and I have also updated the currency rates. Also, the same currency rates and type 1 is used for the business plan that I’m using. See attachments for more info.

Hello, When ‘Acknowledge Customer BoE Transfer’ is used, I do not get any Proposal Id in the drop down. What am I missing or doing wrong?I have several Customer Bills of Exchange in Created and Settled and I have several Customer BoE Transfer proposal in Created, Transferred and Accepted, but none of the Proposals are fetched.Kindly guide.thanks and regards

HiIs it possible to schedule the Update of payment status on Acknowledge Supplier Payments by using a Database Task?I am not able to find a suitable task for it. Best Regards Brian 

Hi, Does any has a documentation on how End Customer functionality works?  - in terms Finance and Supply Chain.

Hi,We need to generate excel file output via ‘Supplier Payment Proposal’ and I made the setup in ‘Payment method per institute’ window as below. However, still it is generating file as below. Any suggestion to get this sort.   

Hi All,Could you please can you advise the implications of ticking or un-ticking the Transaction Level check box. Please can you advise the impact if you have had the Transaction level check box ticked for several years, but then un-tick it. Will it affect existing Purchase Orders and Invoices? 

Hi All, I have recently created some cost buckets for inventory parts relating to different product families. However when testing, I’ve found that one of the cost buckets still has parts in it that relate to the wrong product family. This is doubling up the cost when calculating the standard cost. I cannot see anywhere how I can remove the part from the cost bucket. I can’t delete the cost bucket and start over, either.  Has anyone experienced this before or does anyone have any suggestions please?Thank you, John 

Hello,We are trying to implement standard costing in IFS Cloud.We have created different cost templates for our different product families, each with their own sets of Cost Buckets and Cost Elements. It is set up this way because the different products absorb different amounts of overhead.The different overhead Cost Elements have been set up as percentages of 110 – Estimated Material Cost, in line with our costing model.Cost Elements with absorption ratesCost BucketsCost Templates When viewing the product under Part Cost, the Cost Bucket Detail tab does not include the overhead cost buckets, so it does not calculate a high enough cost:Part Cost Cost ReportWhen changing the part’s Cost Template within the Part Cost screen, it also does not work. It only pulls through costs from the Estimated Material Cost bucket. Is anyone able to assist please?Thank youJohn

Hello,  Is it possible to have a project with a financial origin and still do capitalization and revenue recognition for this project ? Best regards.

 Hello,On the Go-live the Sales Contract is partially Invoiced with AFP.  For the migration of open AFP Invoices - can I use a standard STDCIN1 or STDCIN2 migration template? Or is there any better tool dedicated to migrate those kind of invoices? Also - can I only migrate the Open AFP invoices? Or is it better to re-generate all the AFP invoices issued before Go-live, to have the proper progress set on Sales contract Items (proper value of certified work and proper queue of AFP invoices?I’d appreciate any information.Kind RegardsBeata

Hi All, I have the below SQL statement which when I run in the SQL query tool, it works.But when I save in Quick reports, it returns an error. What is the correct format in quick reports? SELECT    p.project_id AS "Project ID",    p.name as "Project Name",     TO_CHAR((select SUM(a.Amount_Balance) * -1              from ACCOUNTING_BALANCE_AUTH a             where p.Project_Id = a.Code_F              and a.Account IN ('3011', '3014')             and a.year_period_key <= NVL('&Year_Period', '204012')), '999,999,999,999') AS "Revenue to Date (RTD)",     TO_CHAR(SUM(b.Net_Amount), '999,999,999,999') AS "Invoiced to Date (ITD)",     TO_CHAR((select SUM(a.Amount_Balance) * -1              from ACCOUNTING_BALANCE_AUTH a             where p.Project_Id = a.Code_F              and a.Account IN ('3011', '3014')              and a.year_period_key <= NVL('&Year_Period', '204012')) - SUM(b.Net_Amount), '999,999,999,999') as "(Under)/Over Claimed",     TO_CHAR(SUM(b.invoice_amount), '99

Hi All,This issue is relating to IFS application year-end process. Our customer informed us IFS Application automatically generated an imbalanced year-end voucher when transferring retained earnings from period 13 to the period 0 through GP8 posting. Please refer below step by step test plan where this imbalance voucher automatically created by the IFS application.Step by step test plan.01. Proceed with the IFS applications year-end procedure.02. Clear Revenue/Cost Balances: Clear Profit or Loss down to Retained Earnings.03. Preliminary Year End: Transfer Preliminary Balances.04. Run the ‘Final Year End’In this 4th step, Year End Balance Transfer voucher automatically created (Voucher type -YEM) with currency imbalanced as 1. Please see the screenshot below.ObservationWe analyzed the automatically created year-end imbalanced voucher and noted the difference came from the system automatically calculated retained earning adjustment. Could you experts please suggest ways of which we can r

Hi,Is it possible to have the option to generate or not the XML file when creating a supplier payment order?Thanks 

Hello,I'm looking for advice on how to exclude a specific list of suppliers from a payment proposal.The requirement is to exclude a list of 26 suppliers from all payment proposals, while allowing the rest to be paid. Is there a way to set up parameters or automated tasks that can accomplish exactly this—either during the creation of payment proposals or through another method?I’d prefer not to create separate supplier groups if possible, as some suppliers are already part of existing groups. This is more about excluding certain suppliers, rather than selecting which ones to include.Additionally, I’d like to avoid putting a central payment block on the supplier accounts, as we need to keep the option open to pay them in the future if necessary.I've tried separating the suppliers with commas, semicolons, dots, and dashes, but none of these approaches have worked. Currently, our workaround is to create a payment proposal with all suppliers included and manually exclude the invoices for th

Hey all,In App 10, HMRC submission window was helpful to recognize all the submissions, responses and errors from a single location. what is the Cloud page or option we can use for same ?

We are trying to rebuild a current integration that was done by a prior partner. The current integration creates a customer order, and preposts it with code parts D, E, F. Code part D is the Project, which downstream ensures that the Project is present on the AR Trade posting of customer invoices. In our new integration, we can successfully prepost code parts E and F, but when trying to prepost D, we get an error that an external project must have an activity sequence, which is a field we cannot enter into header preposting. How can I get the project preposting on the customer order header? Current Integration:New Integration attempt: 

Dear ExpertsI never had this customer offset proposal working correctly for me. Most of the time the Proposal doesnt find any invoices despite there are available invoices. for example make the following selection for this customer. when i check the customer analysis I see at least 2 invoices and one cupoa which could be matched. what is exactly the logic of this customer offset proposal? what is the limitation`? i honestly cannot figure it out. best regardsSophal

Hi,When creating M voucher from external file and then creating Interim voucher (R) we get following error.“Field [TAX_CODE] is mandatory for Source Tax Item Accrul and requires a value.”When we create M voucher manually with exactly same contents (not from external file) it works without error.  Could it be a bug? We have IFS Cloud R231.

Hello, I’ve found similar topics to this problem, but the resolutions are not working for me.  We are trying to upload a file of customer payments to a Mixed Payment and have it match to customers.I’m using the File Type ExtCustPayment. After uploading, I receive the message: There is no record type 2_DETAIL in the file External File Template: External File Template Control Test file:  I’ve imported as csv and txt and got the same result. Any help would be appreciated. Let me know if there is something else you need to see. Jeff

Is there a way to keep the filters on from GL Balance Analysis when drilling into the Voucher Information.  When I click on the Voucher Information from the Header or Detail Search, the Voucher Information page shows everything. We have IFS Aurena client version:  10.14.127.0. In IEE, the filter from GL Balance Analysis persists when drilling into the Voucher Information.  

Hello there,We are using IFS Cloud. I am trying to use GL Automatic Posting Rules to post certain revenues (original GL coding will come in via manual customer invoice; voucher F) into other accounts based on a certain percentage.  I have set up the "original code string" tab as below. I have allowed the project code part to be "%" to allow any value. When setting up on "Automatic Posting Rows" tab, the below error message popped up. The project code part is not the budget/planning code part and it is in the valid time interval. In this scenario, my intention is to retain the same project code part value from the original posting. The project code part value may vary in the original posting, which makes it impossible for me to set it to a specific value.Can you please help? I would greatly appreciate any insights or guidance you could provide on this. Thank you! 

​@Thommy ​@Nethmini Kosvinna  On this original post Book Invoices on Finished Work Task No  it’s described the following: “This issue is fixed in app10 UPD 16. In UPD 14 & 15 you will not see finished work tasks in the LOV ( of the posting proposal window) , but you can manually add the WT number without any error . In UPD 16, it is not even possible to add a finished work task manually, it will pop up an error message when you try to save the record.”Has this logic been changed in IFS Cloud? (We are currently running 24R1 SU6)In the screenshot below our Finance Lead created a posting from a manual supplier invoice towards a Finished Work Task without the expected error message. We have several companies in the same environment, and some of them would like an error message for this scenario, and others likes that the system allows this.Are there any planned changes for this functionality in 25R1 & 25R2?