Finance (Financials)

Hello,Can anyone help with the screens within IFS Apps that contain the following financial data:chart of accounts, company listing and ledger listingAlternatively, the table/view names within the database that these data (chart of accounts, company listing and ledger listing) can be extracted from.Thank you.

Is there a way to get time setting aligned with local time zone at company level ? We have companies operating in Asia and Europe countries. We have set the default time zone of the DB server as SG Time.  When the users of Europe company are working during late time of the day, application picks next date for the manual supplier invoices, manual customer invoices, voucher entries and ect.

When closing an accounting period we receive the Validation Transactions warning that there are External Supplier Invoices waiting to be created. But after thorough investigations we have come to the conclusion that all external incoming invoice messages are in the status Created, and so are all invoices in the External Supplier Invoices window. There are no failed external files.For the previous period there was no such warning message and if we close the following period there is no warning message either.We can only draw the conclusion that the warning message is wrong. But what triggers it?Any ideas?We are in the process of upgrading to IFS APPS 10 UPD 17. The issue is in our database for verifying the upgrade.

Hi Community, My customer had done  steps similar to belowCreate CO for amount worth USD 100 Create Advance invoice  USD 100 , in postedauth  Create CUPOA for an amount of  80  in Customer offset , CUPOA and AD  offset each other . remaining balance in AD is USD 20 In fourth step it created CUPIA automatically to match against CD invoice created @ final steps Create AC( advance credit ) for the remaining balance 20 Create CD by reserving / delivering the CO , so the final CD is created for an amount of 100 in a state partly paid posted. ( CUPIA created at step 4/5 offset eachother automatically) So they need to finally credit USD 20 from the last CD invoice they had raisedNow in the System we can see below invoices exist> partlypaid AD with remaing USD 20 ( 100- paid 80)>postedauth AC with amount of 20>partly paid CD with reaming amount of 20 (CUPIA created fo

HiI have a customer that uses the job ”Match Invoices with new PO Receipts”. Before that job is run they have another job “delete matched lines” that deletes matched lines to be able to match the entire invoice. Often they get an invoice for the entire order but the order can be delivered on different days. For some reason the matched lines can get authorized automatically even if the invoice is unbalanced since not every line is delivered, eg one single line can be authorized. I haven´t seen this setup before, does anyone else has experience on line authorization? Is it a setting in standard IFS or is there something in the ”Match Invoices with new PO Receipts” job that makes the lines authorized? Our main issue here is that we need to change the “Delete matched lines” job to also delete authorized lines but we can´t see where the authorizations happens :) Thoughts and ideas are appricated!

Hi,Is it possible to create customer order charges from incoming customer order? We are trying to receive customer order and charge from an external system, but the charges we did not find how receive. Thanks,Gianni Neves

HI I have a client who is doing Q vouchers to correct entries.  The problem is that they are not being shown in the project financials.  Is there a problem with Q vouchers and project financials?

I am trying to remove the ‘Create Corrective Invoice’ from the RMB menu in the the RMA screen.I have deactivated everywhere that i can find Corrective Invoice but users still have the option to create when they RMB in the header of RMA

Difference in period 08 and 09 was caused by the account 13101 which was dedicated for Equity Elimination Exchange Differences ( I have attached document from period 08 and same applicable for period 09)Up to period 07, there are only two entries available from account 13101 under on consolidation node group "GRP-SE83 - GRP-SE93 - IGT Holding III Sweden AB" and after 2023-08, it is 3 entries. This additional entry is the exact difference as well 

Hello,  We do not activate the prelimanry posting at the company level although the IP5 is triggered. Is there another setup to check ?  Best regards.

Hello, I am loading an external file containing Customer Invoice information, and am using the STDCIN2 file template to load the invoices. I have included both ‘CURR_AMOUNT’ and ‘NET_CURR_AMOUNT’ fields in the template. After loading the Invoice file and attempting to check, the system displays the error message “Invoice Amount in Accounting Currency does not match Posting Amounts for Item No 1.” Although, both line and posting amounts are similar. Please refer to the below screenshots. The Error:(Please note that the Customer ID above is masked intentionally) Customer Invoice Line Information:

Hi Experts;when I Print a Customer Invoice for a customer order, the status does not Change to “PostedAuth” (Status Changes to “Printed” now)I check “Customer invoice with errors” and see blow error: “ORA-20105: Invoice.ACCERROR1: Error (20105: Invoice.DOMBALANCE: The difference in Accounting Currency for the Invoice XXXXXXXX has exceeded the limit 2) occurred while booking Invoice CD XXXXXXX” how can I Fix that Error and why this error has happened? ( there are anothe invoice for the same customer order but those do not have any problem)thanks.

Hi Experts,  Cash transactions prior to a specific date are not visible in automatic transaction matching screen. Those transactions are already matched. But those transactions should be visible once the ‘exclude matched’ check box unticked. I checked in back-end. Transactions are available in back end. This issue was in Apps9 and Recently customer moved to IFS cloud. The same issue exists as it is in cloud also. ** This issue exists for all cash accounts they are using.  Can someone help to resolve this issue? Thanks, in advanced! 

I have about 600 suppliers that the company has not used in a while and would like to make them inactive. Is it possible to do so without going through every single supplier and doing it manually.  Also I would like to automate the process so that after a set time of not being used they go inactive. If anyone can point me in the right direction it would be greatly appreciated. 

In Sweden we have a small number of suppliers that invoice us and have short payment term (some government fees, bank charges etc), for which we are eligible to pay, even though we might feel that the fee is incorrectly calculated (we then have to raise a case with the entity after the fact to have it changed). The pay term can be quite short (10 or 20 days).These invoices sometimes are not approved and authorized in time to be paid on the due date, with significant late payment fees as a result.Is it possible to set up a supplier (for example a government agency like Transportstyrelsen) so that invoices to that supplier will be included in a payment proposal even though it is not finally authorized?

Hi All,I would like to get help for the below requirement.When trying to dispose a subsidiary company in APPS 10, getting the below error.“Ownership Percentage must be between 0 and 100”I would like to get the steps to perform the disposal of a Subsidiary in APPS 10 and also the reason for the above error.Consolidation Method: Equity Majority Thanx in Advance. Best RegardsRazan 

Good Morning,  We are reviewing our Distribution and Manufacturing Postings Analysis Screen and noticed that we have a transaction that is transferred (Status Code 3) but no voucher was generated.  It looks like the posting controls are setup correctly as we have no errors (M1 - Inventory & M5 - Receipt Without Purchase Order) showing on this transaction.  This is a first time occurrence from the Distribution side for us because we usually clear errors and they push through as desired. Any help on this would be great as this is going to affect Month End Close. We are currently on Apps 10 Update 20 in IFS. Thanks

We are running IFS Apps 9, and we are having an error in Background Jobs for only two Sites when running Transfer Inventory Transactions. The Transactions are in status of 2 - Completed. However the error message shown in the details of the Background Job is similar to one that you have shared an answer to in IFS Community.Error Details:ORA-06512: at "DIXI1APP.MPCCOM_ACCOUNTING_API", line 9545ORA-06512: at "DIXI1APP.MPCCOM_ACCOUNTING_API", line 9671ORA-06512: at "DIXI1APP.MPCCOM_ACCOUNTING_API", line 6431ORA-06512: at "DIXI1APP.MPCCOM_ACCOUNTING_API", line 6437ORA-06512: at line 1ORA-06512: at "DIXI1APP.TRANSACTION_SYS", line 1441ORA-06512: at "DIXI1APP.TRANSACTION_SYS", line 679ORA-06512: at "DIXI1APP.TRANSACTION_SYS", line 1226It is the exact same error on both Background Jobs for both Sites.I was wondering if you could help us narrow down the cause and or possible resolutions?Any advic

Hi We are a Apps 10 user and outsource our IT desktop support to a third party. The third party sends a monthly invoice that can vary by $ amount due to the service supplied or the equipment provided.To complicate the matter more, the equipment needs to go on to the Object Balance register and the service is expensed.. They may be on the same invoice.  The $ and equipment can be estimated, but the amount of service provided or equipment delivered is not known at the start of the month.Our Head of  IT is becoming exasperated by creating a Purchase Order each month to cater the varying $ amounts and services delivered.My question to the community is what is the best way to manage such a contract in IFS (Apps10)?I was thinking of breaking down his budget, in a Purchase Order No-Part Order Lines, and he can incrementally receipt each line over the year.  The other idea was treating the contract as a sub-contract.  But they both com

In my previous company we used Handling units. During Physical inventory we used to ”create empty HU” in the count report for adding parts. The result was: findings were included in the count report.Now I am in Apps 10 Upd 11, without HU.Does anyone know another option than “Count per inventory part” to add a “Findling” during Physical Inventory?Thank you for your feedback!Regards Martina

When generating customer invoices from customer orders, by self-billing or otherwise, they are taking a while. The same issue occurs when the invoices are being printed. They take a while to be printed. Has one experienced this and or have a fix for this?

Can anyone provide insight on how they would use the Tax Clearance Voucher to include postings to a Collection Allowance account? I was thinking about using an automatic posting rule to split off the discount after doing the tax clearing.What is a Collection Allowance?In the U.S., when Sales/Use Tax for certain states is remit to the state on a timely basis, a discount can be taken. This discount is called a Collection Allowance.  Looking forward to hearing from the community.Thank you in advance.Liz

Hello, one of the items we need to provide to our external auditors every year is a detailed listing of our Accounts Payable aging.  Basically, a listing at the invoice level of the invoices that make up our AP.  I cannot find any report or query in IFS that would give me an accurate list.  Does anyone know of anything?  We have created a report with this information, but there is no logic and it is a point in time snapshot. Therefore, the problem is that we keep AP open at year end and post invoices into year-end after new invoice for the new fiscal year have started to flow in as well as payment runs in the new year.  We need something with logic like the AP Summary level report out of IFS that would help give accurate details a week or two into the next month.Let me know if anyone has suggestions!

Hi, I have a user with a customer payment that was made in September.The user that wants to rollback the payment in October. I don’t know if this is by design or a bug. But since period 9 is closed we can’t post it there. But the application won’t allow us to post in period 10 either (“It’s not allowed to change voucher date when rollbacking the payment if the original period is open for user group”) and refers to period 9 as open even tho it’s closed. Any idea about this?     

I want to set up a separate email event action to email remittance advices to supplier, on a company level. i.e. 1 default event action & a second email event action when it is a payment made by company ABC. Can this be done via the Event Action or does something need to be set up in Report Rules?