Finance (Financials)

Hello,  We would like to have our advanced invoice on net amount in order to match with this accounting scheme Supplier acount credit: Gross amout (120)Advance invoice account debit: Net amount (100)VAT account on advanced invoice  debit: (20) Is it possible on IFS ? Best regards 

Hello,I have the following situation:-IFS10 UPD16-The company uses Weighted Average -They buy an inventory part, that goes in Project Inventory, at $411 (PO Price).-When the part is issued to a Work Order connected to the project, the cost is $170 (based on WA). After the part is used, even if qty=0, I still have an amount left in project inventory of $241 ($411-$170 ).How do I get rid of this difference? Thanks,Cora 

Hi,Question on detail function in external file templates.Following is an extract of MT940 file and I would like to know is there any mechanism which  I can use to input the value “000” after the the WXY value Original :86:WXY2108763823648GHY Changed value :86:WX0002108763823648GHY

Hello there, we are in IFS Cloud. We are using the "Bad Debt Management" screen to "Transfer Bad Debt". The voucher created behind the scenes is;Dr PP15 Bad Debt ExpenseCr IP2 Trade ARHowever, we are looking for a bad debt provision function in IFS. The voucher we are expecting is:Dr Bad Debt ExpenseCr Allowance For Uncollectible Accounts (Asset Acct)Once confirm the uncollectible payment from the Customer:Dr Allowance For Uncollectible Accounts (Asset Acct)Cr Trade ARIs there a bad debt provision function in IFS that will trigger the JE as above? Thank you!

Hi, we found a new functionality on 22R2 like Site Cluster. We can create a new “organisation tree” but do you have information about how this configuration can be use in IFS ? Regards, Christophe

Dear IFS members, I hope this message finds you well.Is there a field or option in use tax that allow the calculated tax to be deducted from the supplier invoice amount since the supplier is agreeable to bear the tax, therefore reduce the amount due to the supplier? Any thought?Thank you  

Hi,Today, our fiscal year goes from July to June. From begin of 2024, we must change it to January to December.Does anybody have idea how to do this?One problem, we have already transactions posted January 2024 to June 2024.IFS Cloud 23.1.5Thanks,Gianni Neves

When i do a mixed payment on an advance customer invoice, i have the following error message:This AD 40000007 has on open amount of 90000 EUR.Thanks in advance for your help 

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 for an amount of 80 which match against this) What i suggested is to >Offset Remaining AD with AC >Then raise new C

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: Customer Invoice Posting Information: Kindly request to provide an explanation for the reason for this behavior and any possible remedies to be done to load the invoice properly. Thank you!

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