Finance (Financials)

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! 

Q1. Does the ISO20022 payment format work with foreign currency payments? When we initially set the payment file in UK we were advised that it worked only for domestic BACS payments. Can you please advise if the functionality has been extended for foreign currency payments (example SEPA payments)? Q2. If the answer to Q1 is yes, then what versions of IFS support this?

Hi Have a problem that we haven't find a proper solution; I guess there is other with similar issues, maybe someone has solved it? We have enabled “Finally Posted Supplier Invoices Analysis” to the end users, this window is working very well. Currently, they can only see what they have approved. Now the problem; we have a group of users that would like to see each other invoices, as they work in the same department and same authorization. Currently, this is not possible, with above window. We have tried with some other ways, but then the end-user will see all invoices within that company, and that is not the right solution (and not allowed according to our process.)   /Karl Linder

Hi Validation of Accounting Period Transactions in Progress shows Transactions Exist:   How do we identify the transactions in order to resolve? Regards Shaun

Hi all, I wondered if anybody using payroll has successfully gone paperless?  I have been toying with looking at e-mailing payslips to employees but obvsiouly with GDPR (and just general common sense) I would need to encrypt the attachment first.   

I want to set up posting control M62 to use the project ID to determine the appropriate general ledger account number and department to record the expense to.  I can’t use any characteristic from the inventory part because the same part needs to be expensed differently if it’s being charged to an R&D project than when it is charged to a revenue project.  I thought Cost Source would be the answer but that’s not working either.  Does anyone have any suggestions? Thanks. Patrick

We have set the setting in the Misc Part Info Tab; Inventory valuation method – Weighted average, Inventory part cost level – Cost per part, Supplier Invoice Consideration – transaction based, Zero cost – Zero cost forbidden. Whenever Price Revaluation or Currency Revaluation is processing in IFS through AP Invoice, if inventory part’s if Supplier Invoice Consideration is Transaction Based, the revaluation voucher of goods received and goods invoiced is taking the system operation date and not the voucher date of AP Invoice. Therefore, wrong period is fetched in the revaluation entry of the MPL voucher. Could you advise how to correct this.

Hi - i would like to be able to query all CUPOA’s entered in Biz10 that have been entered in Mixed Payments.  Is there a way to return a search for all of these types of prepayments?

Hello! Need help in creating corrective invoice for orders with Order Type “SEO”. System doesn’t allow creation of RMA for Service Orders. Is there any way to change the lines/ prices for customer invoices with status “Invoiced/Closed”?

Hi All,   We are using the project management module in IFS 9 to support a Time and Materials business. From a time and forward supplier invoice standpoint everything is hitting project tansactions correctly. We have some expenses that we want to charge to the customer, like shipping chargers, and the finance team is entering them as manual vouchers and linking them to project activities but this does not create project transactions. My question is, how are other companies handling thee type of expenses that need to be charged to the customer through project invoicing?

We upgraded to App10 in December. After he upgrade we found that some of our reports did not work properly. We have a problem with information extracted from Customer Order lines - Business Reporting seems unable to extract the correct quantity and base price from the Customer Order line.   Has anyone else had these type of issues? 

When trying to generate an ISO20022 payment file, I get a message saying that format specific info for tempate id i smissing. If I go to Payment Institutes/Payment methods per Institute--right click on ISO20022-- Format specific Info per institute it is blank. What should be in this form? If I create new line , the format ID is filled with ISO20022 but in the FIle Template field; I cannot choose anything. Does anypone have a manual for how to set up ISO20022 properly? This is for a german company, but I will do it for scandinavian companies as well

Hi, We have 215 vouchers sat in error that have not passed through to our General Ledger. All of the errors relate to Manual supplier invoices created by numerous users on or after 16th December. The same update error of “The Obj Connect Lu Transform object does not exist” relating to an IP5 posting control. We are not aware of any changes to our system, so are totally baffled as to it’s cause. Has anyone got a clue how to resolve this or had a similar issue ? Regards, Daryl

Hello, We currently receive supplier invoices in the post and also via email, and then our AP department have to manually enter the invoice into IFS and manually attach or scan&attach the PDF invoice.  We are interested in automating this process, and looking for recommendations. We are based in the UK and currently using Apps 8, with plans to upgrade in the next 1-2 years. Please can you provide your experiences and suggestions Regards Shaun

For Germany Tax (VAT) Reporting 2020 there is no need for a new system template to be created by R&D, as the content has not changed in comparison to the previous year - only the version for PERFIDIA has to be changed by the user. As every year, a description (Word document) has been created for PERFIDIA customers and can be found attached to Global Solution 278080. The document describes the Set-up for German VAT Advance Report (Umsatzsteurvoranmeldung) 2020. It is in German and can be made available to customers if needed.      

Hi Folks,   There is an error in Maintenance Posting analysis. Error: Value is missing or has an invalid time interval for posting type TP1 control type C55 code part B in company 1001.   I have checked the prepostings added to Work order and all are added correctly and also they are in Posting control Navigator.   Can you please help here Thank you !!

We found out that since we are working with IFS10 our project costs show a difference between “Actual” and “Used” at the moment it should not. It took us a while but we now dicovered that since the update we get the “invoice to be paid” (belgian, 444000 / 444005 accounts) double in the project costs because in the business event APINVOICE there is a “include project connection” on the M18 and M10 .. where we did not have this before. I can correct this in the database and then we have the costs correct, but i’m wondering if someone experienced the same issue ? And what could be the reason that this got updated like this in IFS10?

Hello, With a global Installation of IFS and many different payment Institutes it is very cumbersome to handle the output file directories for payment files. is there a way to use context subsitution variables to dynamically define the Output file directories per company, database, payment method … How can this be handled in testing Environments to avoid creating Testfiles in the same Directory as productive System?   Johannes

On Apps 8 has anyone experienced a sporadic problem when deleting Customer Offsets on the Financials> Accounts Receivable> Manual Payment> Customer Offset screen ? From time to time we get the message ‘The field [Cash Amount] must have a value’  95% of the time it’s fine ! Any ideas would be gratefully received :-) 

A printed correction invoice document shows all invoice lines before and after the change. Issue: We have invoices with sometimes more then 50 lines. When 1 line is changed, for example for the price,  50 ‘before correction’ lines are printed an 50 ‘after correction’ lines. Our users and customers complain that it is very hard to find the 1 line, which is corrected. Work around available now Use e correction reason code on the line and print the description on the Correction Invoice document. This helps a bit in the quest to find the corrected linePreferred solution: Only print the lines, which are actually changed. So from the example: Only print the original line and the Corrected line are printed Any ideas how we can achieve this ?

We have Created a payment method connected to payment format BGF and defined cash account 70438632. Then we have connected the payment method to supplier. While trying to pay for the supplier through supplier payment proposal > payment order below error is received: Cash Account Validation error when '70438632' is used as the account number in creating supplier payment. Kindly advise how to resolve this?

IFS Apps 10 - Issue: Unable to Pre-post Code Part value for Posting Type PP17 when attempting to save customer check with automatic write-off amount. Setup: Posting Type PP17 setup with AC1 - Fixed Value for Account (Code Part A) Account has Code Part Demand 'Mandatory' for Code Part B Posting Type PP17 setup with AC2 - Pre-Posting for Division (Code Part 😎 Customer setup with Tolerance Amount of $50. Enter Customer Check and match invoice for less than the amount due, but within the automatic write-off tolerance amount set for the Customer. Automatic write-off amount shows on the customer check line info and in the Withdrawls pane. Highlight the customer check line and select Pre-Posting Enter valid pre-posting value Save the record - Error message appears Wrong Code Part demands for posting type PP17 I have a client with this issue in IFS Apps 10 (not sure which UPD level they are on), however, I can not recreate the issue in an IFS Apps 10 UPD1 Race databas

In the online help for Correction invoice it shows that it’s possible to hide lines with negative value by clearing the check box Show credit lines for correction invoice in the invoice line properties View Credit Lines tab. But where is this tab? We can’t find this check box. 

We have an increasing number of products that have a very small value (< £0.01)  A good example might be a transaction against a mapping interface.  Whilst these might be bought in quantities of thousands, we still need to represent the unit costs as they are generally billed on a consumption basis for odd quantities (e.g. 12,345).  We would need to be able to specify both cost and sale prices in this way.I have been looking at whether this is feasible in Apps 9. I have done a bit of testing and have something that looks as though it should work following a bit of configuration - it appears that you must set the clients currency format in the regional setting of the profile.  Other than that I’m not sure what if anything needs to be done. I’m a little concerned that the Currency Codes screen specifies the number of decimals in the amount but only allows 0 or 2.  These values appear to be used in some calculations but I’m not sure where.  Does anyone have any experience of this?  Are

Hi AllIs it possible to set the authorization of Purchase Orders based on account combinations. If so what screen/window do I need access to set this up ThanksGT