Finance (Financials)

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 

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',

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 a

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 an

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: 

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

​@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. 

Hi, I am trying to post P13 journals, with user group YE and journal type M. But I am getting the following error message: Ledger Account 1510 is only permitted for Vouchers with Function Group Q. How do I add Function Group Q as well as Function Group M within the Voucher Series per Voucher Type? Thanks!

Hi all!Does anyone have instructions on how to set CIS settings in the cloud?Best regardsOskari Bergskaug

Is there a function in IFS that allows losses on completion to be recorded?

I am trying to add a user to the Invoice Posting Authorizers screen, but the user does not come up when I start to type their name. Supposedly the only two prerequisites for this are that the user exists in the Person window - which they do. And there should also be authorization group IDs defined in the Authorization Combination Rules window - which there are. And this user is parts of that authorization group. Why doesn’t their name appear when I try to add them?

Hi,When we create a mixed payment for the Advance Customer Invoice, it will create the payment line with PP36 for which the reference numbers will be CUPIA 1, 2….In this case, how to find out the actual invoice numbers for the payment reference. We are facing issue while writing the code for matching the CUPIA reference numbers with the actual invoice numbers. Can anyone please help.  

We understand that standard functionality does not allow rejection of vouchers at point of approval.The business want to know how other businesses are dealing with this situation and any work arounds.

Hello Community,What is the correct setup in IFS Business Planning to create a calculated Personnel Planning item that uses an Assumption Driver, multiplies it with personnel planning item, and outputs the values to designated account?The objective is to calculate employee social security expenses by multiplying employee salaries with an assumption driver.The salaries are fetched from HCM and stored in multiple planning units. The assumption driver values to calculate social security costs are stored in a single Planning Unit for assumption drivers. Here are the current definitions in detail:Personnel Planning ItemsThe calculated item is defined as follows: Select Salary and multiply it with Assumption Driver, (refer to the screenshot below).