Finance (Financials)

Following information requested via case ID G2342017. An auditor asked the Finance department for some information. They in turn asked me, but I'm not sure where to find this data in IFS.The auditors want a "static pool" that shows (in a single file) all the company's invoiced sales, credit memos, adjustments, and payments (or any other activity). I thought initially they would want a dump of what's in Customer Analysis, but they want to see each individual payment and transaction. They mentioned that they'd want to see each transaction on another line - like, the invoice for 1000on the first line, a payment for 9000 on a second line, and then a 100 write-off on the third. Obviously, that's just an example. How can I pull this data for them? Does such a thing exist? Apparently they will be asking for this on a semi-monthly basis. I'm happy to pull this out of Oracle if possible, I just don't know where to find this info in IFS. 

Can any one share template or how I can import Journal entries into IFS 9. I have a list of long journal entries I need to pass and it will be nice to have a way to import this into IFS 9 from Ms Excel

Hi All, In Apps 9, can we create a migration job for bulk customer instant invoice upload? if possible please explain the process, as i tried with view names but it is not working. ThanksRaj

Community,can anyone can advise what happened to this supplier invoice? why negative amount is showing up in window Invoiced Purchase Order? is that means the previous match is being cancelled?  Thank you.

Hi All, I'm getting following error in the project invoice.ORA-20105: Invoice.ACCERROR1: Error (The difference in Accounting Currency for the Invoice 2022010001 has exceeded the limit 0) occurred while booking Invoice PJ-CR- 2022010001.Please refer the  screenshots of the company settings for the accounting currency difference. Please advise on this regard ThanksNaadira

Hi Team, I am getting the below error while creating supplier invoices through the external supplier invoice assistance.but the same file I uploaded in the non production system its working fine. Please help. Regards,Na 

Hi all,we want to import salaries to IFS. In our csv file the “currency credit amount” is negative. But after the import to IFS it is positive. Is that the standard way in IFS?And which external file template do you recommend for importing salaries? 

Hi,The customer has defined a new wage code parameter however, this is not appearing in the payslip. These are the steps followed by the customer:• Define wage code parameter • Defined new wade code class and added the posing control P12 which is connected to the account code.• Defined Wage code ID, RMB – Formulas and connected to wage code Parameter• Added wage code parameter to the Deductions Wage code. Are there additional steps required for the newly defined wage code to appear in the payslip. If so, can you kindly provide these? Many thanks!

Dear Community, we would like to set up the Finacial Project Numberseries like that:First Number HRL0000001, next number HRL0000002 etc.This is the set up in IFS  It is not possible to start with leading 0000000, IFS is formatting it to 0. So if we create the first project with that number series it comes with HRL1 instead of HRL0000001. Of course we could set up series with HRL1000001, that would work. Question is it somehow possible to set up like requested with leading 0 values HRL0000001?Thanks!regardsSebastian

I have a client that would like to perfom the currency revaluation on their Income Statement accounts using an average rate for the month.  They plan to only enter rates once per month at the end of each month.  I created a new currency rate type (calling it average) that I was going to use for these accounts.  However, It appears that only Assets and Liability accounts can be revalued in the Accounting Currency (see below for message when entering a Cost account)  I have explained that IFS captures the rate as of the transaction date so the revaluation of the income statement accounts would not be needed if rates are entered daily, but they prefer to use the method they currently use, which is converting the Income Statement using the average rate for the month. Has anyone run into this issue or have any suggestions

Dear community,my colleague created a new company with the assistant. He got the following error message because he didn’t had the permission to see the company creation logs. How can we see these logs?  

Dear Experts,Kindly let me know the steps to resolve the errors in the ‘Create Company Log Details window’ while creating a new company?  

Community, would you please share with me the Cost Rollup Procedure and Working Instructions? We are implementing multi-site BOM, and the cost need to be rolled up to the final product site. Thank you.

Hi Team, Is there any provision in IFS10, to perform batch cancellation of Mixed Payments?As we know, we have provision in Mixed Payment window where we can RMB->Cancel for cancelling an individual Mixed Payment.But, lets say I want to cancel 50 Mixed Payments at once do we have any feature in IFS10 where we can perform batch cancellation of Mixed Payments? Thanks in Advance. Best Regards,Rakesh

Dear All, I'm getting this error message when we run the scheduled database job for the work orders. Value is missing or has an invalid time interval for posting type T3 control type C54 code part A in company ***.       ORA-20105: PostingCtrlPublic.POSTERRMSG    I checked the posting control settings. All the  settings are done. Work order status is finished but the css posting states as CSS not posted.Even if I run the background job again still I get the error message. Kindly please someone help me.    

I’m come across an error on a payment for employee SMD212 (who’s left) so I’ve entered all the applicable details on payroll and employee payroll information and tried to calculate payroll but I’m getting the following error message. Can anyone please advise? 

Hi ExpertsI tried to setup an Balance sheet and Income statement with the existing accounting structure in IFS  I can only setup the Business Report for a specific company and cannot choose it for several companies. This is because in the Node defintion i can only choose one company Does anyone has an example for a Balance Sheet using the accounting structure for several companies? Otherwise i need to create a BR for every single company.

Hi,One of our customer prefers to get 2 additional code parts. Have any of you done this type of customization,Best RegardsNarmada 

I’m trying to setup basic data for Supplier Invoice > Invoice Workflow Basic Data.  The Authorization Role is giving me trouble.  If I try to populate this screen, I get nothing.  The + is not active so I can’t add new records.  Several of the other basic data elements require you to select a role, but of course that LOV is empty.  The help says there are no prerequisites for Authorization Role.  How can I get Roles setup?  We are on Apps 10 UPD 15

Is it possible to set up a default cash account per supplier? This function should be usefull in the view “Supplier payment proposal”, so the proposal will get the specific cash account from the default cash account on the Supplier. The manual solution is now that i change the Cash Account in the view “Supplier Payment Proposal Details”.  

Hi,In a customer environment, the File Type and Template fields are disabled for Audit Source: INT_BALANCE_CARRIED_FORWARD_AV. How do we enable it and pick a specified external file template to sort the records when creating the structure of the generated XML?Furthermore, could you please provide more examples on where such external file templates are used?Thanks! 

We are currently on APP9 UPD 16 and in the process of migrating to Cloud.  In the meantime, we are trying to eliminate the need for a Crystal Report Server as our servers need to be update and would like to convert the 8 or so Crystal reports to Report Designer using IFS Developer Studio.  The one I’m working on is a Derco AR Aging which would be part of the PAYLED Module.  I have created the Model .report but it appears there is much more code required to be added and fixed on the .RDF side.  The Report does show up in the Financials-Accounts Receivable-Reports-Info Services Reports.  Report is granted a Query role we use but none of the actions in the RMB are active.  I was reviewing the Customer Ledger Open Items/CUST_OPEN_ITEM_REP which is where I found much more code required for setting up the Order Report Template.  It appears in the RDF that the template may be created on the fly within the code?  One suggestion I found in the Community is to refer to Financials-Payment Basi

Community, Do you have experience in using below triggers, if you do, can you share it with me?  Cost Elements for Overhead Triggers141-Purchase Del OH Trigger501-Material Overhead Trigger502-General Overhead Trigger601-Sales Overhead Trigger Thank you.

Hi Friends,I have one issue regarding GL Account wrong mapping actually the correct account is 3100 but someone mapped wrong account 3110.now we have 3 customer invoices already posted with account 3110. Kindly help to transfer the balance from account 3110 to 3100.  

Appreciate if anyone can advice how to use  "On hold" option  in customer installment plan and discount windowCustomer invoice> RMB> Customer installment plan and discounts