Finance (Financials)

I am receiving the error message Values ORA-01403: no data found in multiple databases when trying to upload an External voucher.  Can anyone interprete this error message?

Hello everyone, I write with the following issue. For following Customer order, an AD invoice got printed. A payment came in from the customer and in the mixed payment transactions the payment got matched with following AD invoice. AD and CUPIA are fully used.The system did not automatically create a CUPOA to match with the CD invoice at point of delivery.It looks like the CD is still open after months, but actually no extra money is required from the customer. How can I solve this? Thanks in advance.

Hello,Can any one share Power BI Edition required for  IFS Cloud. Do we need Power BI Pro or some thing elsePlease suggestBest RegardsPankaj  

Hi,Thinking about changing our Inventory Valuation Method to L I F O (Last In First Out). Anything to watch out for? We don’t have inventory qty apart from the Dev system. Project related manufacturing.Any advice or problems encountered. Regards, Sean

Dear  All,I’m reaching out to your expert advice on  the below matter .This issue is relating to obligatory  e-invoicing in Poland (Related with  Polish localisation.)Customer is currently using IFS Apps 10 UPD 17 (prod) (Test environment is in upd 21 and customer had not updated prod  to UPD21)If they upgrade to satisfy the legal requirement ,  do they have to buy additional software (pagero or any other 3rd party tool ) to complete the e- invoicing capability ?Or once they  upgrade  IFS, are they completely compliant and they  can do this new requirement just with the upgraded IFS?Thanks in advance Kind regardsUdanee 

Hello! I need help.Payment Order was created which triggered the payment file to transmit to bank. We then discovered that partial file was accepted, so instead of voiding the checks through “Supplier Check” function, the invoices that were unacknowledged from the Payment Order were cancelled and deleted. Now going back to attempt to void the check I am seeing the error message below. Any thoughts on what I may need to to in order to void out checks now that the payment order is deleted?     

Dear experts, We use multi-company allocation to recharge costs to a customer for a specific period. However, we’ve observed that it’s possible to create instant invoices for the same period multiple times, which should not be allowed.Please see the allocations for period 07 below.How do you suggest we address or prevent this issue?   

Hi All,I am testing the Group Consolidation Process. And Against the Balance Version i have Mapped Two different exchange rates One for Income Statement Accounts and One for Balance Sheet Account. And the trial Balance in SEK is Converted in EUR. Income Statement accounts would be converted at different exchange rate and Balance Sheet Account would be converted at different exchange rate. And this difference should be accounted using GCP3 and 4. But i don't see these entries getting triggered even though conversion is happening in right way.So wanted to know in what condition GCP3 and 4 are triggered. Is there any additional setup needed to trigger this entry? and at what stage of consolidation process this will trigger?

It is my understanding that in the Object Series window, I should be able to RMB on the Series ID to get to the object number series.I do not have a RMB option for the object number series and IT says I have full access. Am I looking in the right window? Thanks  

Hi Guys,Have any of you been able to upload an invoice as XML with a tax code where the non-deductible portion is not 100, without using the overwriting value at company level?I receive the following error: ‘Tax amount adjustment for tax code cannot be greater than the maximum overwriting level on tax’. From my side, both the tax and non-deductible portions appear to be correct in both invoice and tax line.Would it be possible to share a working XML file, or provide any guidance on the validations applied by IFS?Tax calculation method: Tax Amount and Non-deductible Tax Amount

We have suppliers who send invoices in different currencies, and depending on which currency  - they want the payment to different accounts. Can we set up a rule : if EUR use payment address 1 if SEK use payment address 2 ?  or some other solution ,,,

There is one customer order line (which is generated by a Work order) and when I tried to click RMB ‘PROCESS Invoice’ in The Customer invoices with error the process runs but the line stays in the status PRINTED only. There is no error in the error description. I enabled the dubug consolse and below is a part of that debug which does not help me to identify the problem. Please let me know what the problem is. 40^11886478^CALLSTACK^DEBUG^^__anonymous_block at line 10 OUTGOING_INVOICE_API.POST_INVOICE__ at line 1499 OUTGOING_INVOICE_API.POST_INVOICE__.CORE at line 1481 OUTGOING_INVOICE_API.POST_INVOICE_ at line 809 OUTGOING_INVOICE_API.POST_INVOICE_.CORE at line 804 INVOICE_API.POST_INVOICE_ at line 37355 INVOICE_API.POST_INVOICE_.CORE at line 37350 INVOICE_API.POST_INVOICE___ at line 22636 INVOICE_API.POST_INVOICE___.CORE at line 22584 INVOICE_API.CREATE_VOUCHER_UNPOSTED_INV_ at line 37987 INVOICE_API.CREATE_VOUCHER_UNPOSTED_INV_.CORE at line 37902 INVOICE_API.CREATE_VOUCHER__ at line 3

We perform sales discount activities through Rebate. Our two rebate invoices for the month of December-2022 have Zero value. For this reason , the two invoices are not being complete. Shows printed status in invoice status and also shows in customer invoices with errors window. Even giving a warning at the time of month end process.  

Interested to understand how other Group organisations handle this scenario.Company A - Parent company of a group, with multiple subsidiaries world-wide. Company A will purchase overhead service items (e.g. software licences) via a Purchase Order, for the whole group. Cost then needs to be reallocated from Company A to companies B, C, D, E, F G etc. Currently using APPS10, migration to Cloud underway. Was unsure whether to post this in the SC or Finance sub-forum, so apologies if it’s not in the right place! 

Hi IFS Community, hope you can help!I have been able to run a Cash Flow Exposure report out of IFS, the PDF looks great and is summarized per row by Cash Flow Source e.g. inflows/ outflows → which include sub categorizes of those inflow/outflows e.g. customer orders or purchase orders.This is great and is a good, high level report. I assume it is produced from the resulting ‘Update Cashflow Analysis Snapshot’.However my question to you helpful people is → Is there any way to view the detail behind the high level ‘Cash Flow Exposure’ report ? i.e. can I see the data that was collected as part of the ‘Update Cashflow Analysis Snapshot’ ?Best regards,James 

A new version of Perfidia v4.50.217 has been released. The actual version can be downloaded here:https://www.perfidia.de/downloads/psa/psasetup.exePerfidia Forum can also be accessed with GuestAccess (Gastzugang)https://www.perfidia.de/Perfidia?action=forum

The Austrian government has mandated a change in the XML structure for the EU Sales List (S056 ZM Reporting) to comply with updated legal reporting standards. This adjustment affects only the XML output and specifically targets two elements within the file structure: DREIECK and SOLEI. The enumerated value for these elements must now be set as "J" instead of the previously used "1". This change is applicable for 24.2.8 - 24R2 SU825.1.2 - 25R1 SU225.2E.0 - 25R2 EAAPP10UPD29

I want to find the user who has created the manual suppier invoice.  Is there any way to find it through the sql query

The following changes in the output of the German Intra Community Sales Report (ZM) will be applicable: CSV Header Update (Version) VAT ID Output Clean-up (Zusammenfassung Länderkennzeichen und USt-ID New Country Code (Nordirland 'XI')  The changes are applicable for the following IFS Cloud/Applications Versions: 24.2.9 - 24R2 SU925.1.3 - 25R1 SU325.2E.0 - 25R2 EAAPP10UPD29 Encoding changes from ISO-8859-15 to UTF was already covered in IFS Applications 8 and is default in IFS Applications 9 and IFS Cloud.

Hello,I’m trying to create an IFS Business Planning structure with multiple entities.We have numerous companies, each with different reporting currencies.I would like to create a planning unit for each company. (e.g., plan in local currency for each company, and consolidated to reporting currency USD)How do I best structure this? 1) Do I create a planning unit in each company? or2) Do I create planning units in one company and link them to the Business Plan? (But can’t import General ledger from each company)Any help is appreciated.Thank you!

Dear All, IFS version:  IFS Cloud. I have an issue with Supplier payment. The payment has been done to the supplier and it is been reconciled with Bank statement. The invoice stands Paid Posted. After about 10 days the bank informs us that the supplier payment has been failed due to their bank account closure. Upon reaching out to the supplier we were advised to pay to a different bank accuount. Now I would like to know the process of cancelling the previous payment so that my invoices status would put back to Posted Auth and repay the supplier to correct bank account. We have corrected the bank details at suppier level, now we want to proceed with repayment. Appreciate your valuble time and suggestion. Kindly note that the payment order has multiple supplier payments, we do not want to cancel the entire payment order in Mixed payment.  

Hi,We observed that the debit values when creating an invoice differ from those when creating a credit invoice.Debit Invoice example - Credit Invoice example (Note - The Credit Invoice is created through the ‘Invoice Plan Detail’ window) -Below is the Excel Output of the Invoice Plan Detail - Line No and Unit PriceCould you please clarify why debit invoices display values consistently up to two decimal places, whereas the decimal values in credit invoices vary?

Hi Experts, I’m looking for guidelines on whether we can define period allocation fields when loading an external invoice, the standard template doesn’t have a dedicated field to do this, which I assume the expectation is to do the period allocation only after the invoice is there in IFS.

Hi All We got the CIS verification working when we were testing the connection in our Cloud upgrade however since going live we have not managed to connect to the HMRC live database to do the verification. I have followed all the documents i can and i have been told that the incorrect site is listed in the routing rules so i have also updated that to the live database but i am still getting an error wen trying to do a test transfer. The error references the handshake being cancelled from HMRC and i can only guess we are missing a certificate or something of that form.  has anyone got this working and have some tips. 

Dears, I need Support on “Acknowledge Supplier Payment Orders”  screen: -- The Postings are triggering multiple BANK entries with the same total amount of the Payment Order-- And putting the balance in FX loss.-- The voucher type is U voucher.-- EVEN USING SAME Company currency with rate 1 - same issue I checked posting controls are correct ..(if we use N voucher then is correct).PLEASE SUPPORT TO USE THIS SCREEN AND HAVE A CORRECT ACCOUNTING IMPACT.thank you