Finance (Financials)

We are using APPS9. Is anyone using the AP/AR netting functionality?  We want to start using the netting process but we are trying to figure out how to let the supplier know that we have netted one of their AR invoices against their AP check. We would like to identify, the AR invoice that was used in the offset, on the supplier remittance advice without having to do it manually so that the supplier is aware that the netting has taken place. Any suggestions would be greatly appreciated. Thanks Rob  

Hi IFS Community Members,   We are using staged billing profiles in customer order lines. Due to the size and complexity of our projects, there may be more than 20 staged billing lines per profile.   Recently a customer order line was cancelled accidentally while the staged billing profile still had both invoiced, uninvoiced and open staged billing lines. Because the cancelled order line wast the last one in the order the entire customer order changed to cancelled. Instead of creating a completely new customer order, we would like to utilize the exiting customer order and the exiting staged billing profile.   What we’d like to hear is: is there a any way to reopen a cancelled customer order/order line is it possible to prevent customer order cancellation if it has uninvoiced staged billing lines   For reference, we are using IFS 9 and update 14.  

Hi, I have created a report which the ‘GL Balance’ column is set as a repeater and with ‘Year’ being the input, it shows each period correctly. Now I need to show the Year-to-Date value in the each repeating period. I am not sure how to give this logic in the column filter as it is the repeater that determined the bottom period. The customer is using IFS V10 UPD6. Any ideas? Thank you - Pamith

I have not find the correct set up to get customer invoice sent automatic when shipment is closed. I have modify the order type like this: And then set up in the customer misc customer info the email option to invoice Now it seems that system stop the flow totally after shipment flow process and not proceed to invoicing. We are working in IFS10. What set up is missing?

We have a Customer Account Statement which runs at the end of each month to send a PDF customer statement, is there a way to include the account details for last 6 months in this customer account statement.

Our external payroll administration company sends voucher information in SIE format, which is a standard file format in Sweden for accounting transactions.  Is there a possibility in IFS to receive external vouchers in SIE format?  The SIE format is a HTML file and this far we have only found it is possible to import external vouchers from text files. 

Hi, Facing an issue while deleting one of Currency revaluation account which is used in previous month revaluation. If we rolled back all the currency revaluation transactions and then delete the transaction line and then delete any account from currency revaluations accounts screen it will allow to delete but this is not the good solution.  In IFS V10 UPD it throws error can not be deleted as it used in table, we did not have any such issue in IFS 8.   Ideally it should allow you to delete the account from currency revaluation account screen if we don't want certain account to revalued from crentain period then system not stop at all e.g loan account etc.   Regards, Mukesh Gupta 

Hi, Re Voucher entry Window, Whenever user click on add button I want to fill Voucher status automatically  as “Approved”.    What are the ways I can achieve this ?      

This issue happens rarely but when it does it un-explainable. The part list price is in the part record the part list price is also in the part pricing rule that generates however, on the request it doesnt trigger anything the first screenshot shows part pricing triggering successfully. you can see the price rule sequence   The one with the issue isnt pulling it at all    

Hi ,   I have made the set up for external payments upload for Customer payment invoice matching but all the upload is going to parkpayment anf unable to genrate mathing based on the external payment parameters setup. I am trying to upload customer payment on mixed payment. 1. 2. 3.  Mixed Payment file 1_HEAD;;JOD;16-03-2020;;; 2_DETAIL;;;16-03-2020;2548;;20ACT00115 4 I am using IFS V10 UPD3 it workis well in IFS 8    Regards, Mukesh Gupta

Hello, in IFS app 10 Aurena, where is menu node of customer payment & supplier payment in AR & AP model?  I can’t find them in Aurena while they are available in EE. HELP me find that, thank you so much

Hi,   How can we invoice for the price difference to purchase invoice? Does anybody know?

Hi, After migrating from Apps8 to Apps10 we are experiencing some problems with tax amount in project invoice and in GL Voucher. In spesific, we found out that tax will not be updated if the checkbox "Preliminary Update Allowed" in project invoice lines is not checked, which is set automatically and is not editable. In apps8 this was not a problem. Is there any changes in Apps10 we should be aware off? We see that if we create correction transaction in project transaction it automatically set "Preliminary Update Allowed" to unchecked.  We also not noted that if we use the function “Create Correction Transaction” in project transactions and change information on project transaction with Correction Status “Correction”, this is not reflected in Project Posting Analysis and GL Voucher when transactions are booked in GL Voucher. An example is that we correct hours and change the number of hours for project transaction with Correction Status “Correction” and the cost for the

Hi All,    Has anyone have any issues with EFT payment types on the Remittances sent out to the suppliers?  We currently do not have any bank details in the electronic payment addresses .  My assumptions are that  this is causing the issues as IFS assumes all suppliers are related to one bank account (none?).  What is the minimum data required within the EFT payment type to get the remittance split by supplier? 

I wonder if it’s possible to exclude one or more customer number from a scheduled batch job?

Hi, I have used the BGMAX template to upload an external payment to an APP10 enviroment. The ‘Payment Reference’ in the File and the invoice is the same. However it doesn’t match the invoice and is trying to create a Parked Payment because the Customer ID is null. Has anyone worked with BGMAX customer payment file before and had the same problem? if so what were the steps taken to overcome? Thank you! Pamith

I have been asked by my Bank for the SFP number for our IFS system, does anybody know what this is or where I could find it. Many thanks

Hi, I am new to IFS ERP. I would like to know how to analyze a GL account history for a particular account in system ? So far i can see the balances, but how to check transaction history ?  

Why would Copy Voucher in Hold Table RMB option be greyed out when on checking the permission set this has been granted?   Thank you.

I have already added this to IFS Idea wall some time back.   When we do the ‘Search in context in any window in IFS  Application, to find the relevant column we have to go through all the columns from the top to bottom until we find the one we need. Depending on the number of fields available it may take very long time user to find the relevant filed and do the search.   As an example if we want to search GL Voucher row analysis window by the voucher date and to a particular date, we have to RMB and select the ‘Search In context’ and find the date filed form the rest of the other fields.   My suggestion is… If we are already in the given window and if we have selected particular line and a filed, when we select the Search In Context, application can open the search window where the given filed is already filled with the value which was in the selected line.   As an example if we select a

I am creating income statement using SQL. I am also using report generator. The requirement is from my boss to see income statement on given date. The costs which are not known would be taken from budget tables. There are following questions on how to solve this problems. Is there possible modification of report generator logic to run the report on given date ? The budget amount should be used proportionally to current date. For example today is January 13th, so January budget should be multiplied by 13/31. The alternative is to use SQL report which result after period end would be comparable to report generator results. Regards, Marek

We use labor rate dilution for one of our companies.  The process only works when the week ends on a Saturday because I have to run by process for an entire week.  I was wondering if anyone out there uses labor rate dilution and what do you do when the month does not end on a Saturday.  Thanks everyone!

When manually adding a Mfg Clocking in Time Card Day we receive the error "This transaction only supports Machine, Labor, and Subcontracting cost bucket cost types.  For cost bucket  cost bucket cost type is ." Defined cost buckets appear valid.  Failure of a cost bucket and cost type to appear in error text suggests cost bucket is not being linked to the process.  I have reproduced this error with the app owner account to rule out access issues. Labor class and availability for this employee appear fine. Workaround:    No. Business Impact:    Testing and resolution is required for Apps 10 upgrade project to proceed. Environments/Databases:    Apps 10 IFS Test Test Scenarios:    Go to Time Card Day, load employee 006904, find a day with a labor clocking, go to Mfg Clocking tab, RMB > Add Labor Clocking.  Enter a valid Operation ID, such as 83243, and reasonable start/stop time stamps within the labor time window for th

Hello, Does anyone know of set up for Payment Institute / Cash Accounts to restrict it’s use if supplier invoice currency doesn’t match the cash account currency?    It seems in Apps9 it allows me to select a different currency cash account with no warnings / hard stops that it doesn’t match the currency of the invoice in the payment proposal.   I’ve had a payable user not select from a list of values all fields in payment order pop up form, therefore they didn’t notice they picked the wrong one until after the checks were printed.    I know I could create a custom event to perhaps stop this but just wondered if I’m missing something in set up?   Thank you

Hello, We are looking to use the Bank Reconciliation process where we upload from our bank the cashed checks so we can mass “cash” them.   Our daily files could be quite large.    When we test this process and let’s say want to remove the bank statement due to an error, it’s telling us we need to unmatch each check first one at a time!   This would be very time consuming!   I remember testing this in version 7.5 and pretty positive I could just remove the whole thing without performing this function.  Does anyone know of a way to remove the bank statement in version 9 without having to go to each line to unmatch?   I may just be missing something in set up.   Thank you in advance!