Finance (Financials)

Hello,Is there an IFS data dictionary available for the source tables which tells us the data type, data definition, required fields, etc.?When writing a query (SQL Query/Query Builder), it would be really helpful to have something to reference.Thank you!

Hi All, Is there any possibility to raise an advance instant invoice without creating IP17 and IP19 posting controls? Thank you. Kind regards,Nisha 

It is not possible to add payment address details in customer payment tab for any payment method connect with format DDEUR. Is there a configuration missing?  

Many customers have rental agreements for their facilities. The landlords will then invoice the tenants on a regular basis. For customers in the retail industry with 100+ shops on rented locations this means 1000+ invoices per year. There are no PO’s for these invoices, only a rental contract.Is there a function in IFS to match supplier invoices with a “rental contract”? 

Hi All,Could you please can you advise the implications of ticking or un-ticking the Transaction Level check box. Kindly advice the functionality behind this issue.  

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

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 

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