Finance (Financials)

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 line in ‘GL Voucher Rows analysis’ while selecting the voucher date filed of any given line, the se

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

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 the employee.  Other fields including Labor Results will auto-popul

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! 

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?