Finance (Financials)

 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).

One of our clients is required to include tariffs for the part cost setup. From the manufacturing side, currently, this is configured as follows: (In IFS Cloud 22R2)A new cost bucket is created to accommodate the tariff requirement. A new cost element is defined for Tariffs, and the defined cost bucket is connected After creating the supplier for the purchase part, delivery overhead details are added on the Delivery Overheads tab. Then, the part cost is calculated, and using the cost roll-up, the cost of the part, now including the tariff, is updated to Cost set 1.Next, a purchase order with this part (which has a tariff as a delivery overhead) is created, and once the goods are received, the postings below are created.Purchase Order Amount - $175 (The part with tariff overhead is connected)M1 (Debit)

I managed to create a customer invoice in IFS Cloud with a combination of tax liability TAX and EXEMPT. Is there a way to prevent this?I have created a customer order for delivery of goods to another European country. VAT rate is 0% since the VAT liability is shifted to the customer. A second line is added to the customer order to provide installation services. The services are handled by a local supplier and must therefore be charged with local VAT rate. After registering delivery of both goods (EXEMPT) and service (TAX), I created a customer invoice that contains both lines. I expected that 2 invoices would be created by the system.

In Work Task, the lines from Time Reports tab are missing in the Sales tab.

Is there a difference in handling purchase order price adjustment in posting proposal company compared to a non-posting proposal company in cloud? 

Hello all, has anyone experienced an integration of the SAP Concur expense report platform with IFS cloud?Have you done it internally or used a third party integrator?Looking forward hearing from you.