Finance (Financials)

Topic was raised on behalf of Case ID  G2324889 The items receive on the FOC (free of charge)  basis in shipments need to be set off from the GL 1361010 - Trade Advances - Import (PP37)- Pre paid Import Advances. For the first time we receive such through a shipment arrived in March. Therefore please advise on how this transaction should be accounted in IFS. 

Hi everyone! I would like to know how are you implementing the cash box functionality in your companies.Currently, our cashier is recording the petty cash received from employees.But we also have other petty cash at site that is not going thru our cashier. Can we ask those employees to record their petty cash in the Cash Box screen? Then once finance received those supporting documents, we can process the same?This will eliminate the finance function to record those petty cash that those employees already encoded in Excel. What can be the complications in this process? like control, mis-management, etc.Or are there any other alternative process that you can recommend? Many thanks in advance!Jaybee

We have an Internal Ledger setup for German GAAP reporting purposes and are using the system defined Audit Sources for the IL.The output from these views/reports is currently in English.Does anyone in the community know how to have the output be in German?The Account Descriptions in the IL have been translated to German yet the output takes the English description.ThanksA 

Hi, We are getting errors when the scheduled task Transfer Maintenance Time Transactions executes such as: “Period 2019 - 10 is not open for user group XX in Company XXX” In addition, in Maintenance Postings Analysis the following errors are being reported: “Code string combination "29950/TNB/700/REACTIVE/-/-/-/-/-/-/-/" is not included in any one of the al”   Our finance department are not happy that transactions are trying to post into historical periods which should be closed as part of month end processing. They can manually fix these by changing the applied date i believe, however they don’t want to keep doing this as it is an overhead and still not comfortable.  Is there a solution out there which others are using to prevent errors like this and impact to the finance dept?  We are using IFS Apps 8. Regards Shaun

Hi All,Any support on this error? 

Good afternoon, My company is shortly upgrading to IFS Cloud. We are wanting to evaluate what options we have, for implementing a Supplier Invoice Portal, that natively interacts with IFS. We are a multinational company, with operations across the globe.  I have been made aware of Pagero has a solution that supports native interaction with IFS, however I’m wanting to evaluate other options. Is anyone aware of any other providers, with software that natively interacts with IFS Cloud Thanks Chris

We are in a process of migration for a customer, upgrading from app8 to app10 (managed cloud). The customer only uses the Finance module in IFS.The customer wants us to migrate Open Partially Paid PREL Supplier Invoices in foreign currency. We use external files.The customer has integrations with Medius (invoice flow) and Vivaldi (purchase order and customer order).The Final posting (J-voucher) is made against the net amount in files that come from Medius or Vivaldi. Thus, we cannot adjust the remaining amount to become the gross amount on the migrated invoice for the partially paid invoice, we will have to make the payment separately. At least that's how we did it in a test run. If we adjust the remaining amount to the net amount, the invoice will not be able to be finally posted with the net amounts in the transactions arriving from Medius and Vivaldi.The VAT is entered in the I-Voucher. The customer does not use posting proposal in IFS. There is no validation of VAT calculation in t

I am testing the Jinsui interface in Aurena and I´ve created the file for export. In the file there are 2 columns - CHECK_ID and PAYEE_ID that I cannot find out where the information is fetched from in the system.Is there anyone that has a document with the the mapping of all external file columns to its fields in the application?

Account Valid until date and code part demands are entered correctly but still facing the issue.Maintenance Posting analysis. Thank you  

I am trying to give a user access to set up new employees in the system.  He can create the employee record, but when he tries to fine the Person ID, he can't see it in the search window and if he just types it in and tries to save the record he gets the error "Insufficient access rights. You cannot modify Pers Protected data for the person."  The person record he is trying to use is newly created and is not set up as a protected person.  There must be some access setting I am missing.

Hi, I’m trying to transfer my work tasks to the finance module.  The transactions are in a status ‘Overtaken’ and the transaction status is either ‘Not Applicable’ or ‘Valid’.  I’ve ran all the transfer work tasks jobs but I’m not seeing any transactions in Finance and the status is not update in the work task posting analysis.  Can anyone let me know what I need to do? I can’t close the month end as the ‘Validate transactions in progress’ are showing an error - transactions waiting to be transferred from Maintenance.  Which screen in IFS tells me which transactions are stopping the month end close? Thanks.

Hello everyoneI get this error when I load External supplier invoice for one supplier (IFS CLOUD 21R1): ORA-06533. Subscript beyond count.Do you know how I could fix that?Thanks in advance, Laura

Hi,Appreciate your response to below two queries (relating to Budget Management functionality in Aurena). Budget Process & Budget TemplateIt seems the windows ‘budget processes’ and ‘budget template’ is no longer available in Aurena. Have these windows moved from Aurena, or have they been renamed?If the budget process is no longer available (in Aurena), what is the only available way to create a budget? Is it only using ‘import file’ option?Budget user rolesThis window is not available in Aurena. If so, what is are the alternatives available to control different budget-related user roles?Thank You!Sugandi

This is the ACH output file sent to the bank.  1234567891123456789212345678931234567894123456789512345678961234567897123456789812345678991234Sample Batch Header:5220Company Name                        1999999999PPDPayroll   YYMMDDYYMMDD   1042000010000001   And below are the fields of the ACH file     FIELD POSITION SIZE CONTENTS DESCRIPTION 1 01-01 1 5 Record Type Code / NACHA MANDATORY FIELD           2 02-04 3   Service Class Code / NACHA MANDATORY FIELD                             200 - Mixed Debits and Credits                        220 - Credits Only                                        225 - Debits Only           3 05-20 16   Company Name – Name of the company by which it is known to & readily recognized by the Receiver of the entry, left justify,

Please let me know which client file contains this error message popup when execute RMB option "Instant Update General Ledger" from Voucher Entry window.  

Hello - I want to set a user to have a different default load voucher type for external vouchers other than the default that is set in external voucher basic data.  I know it is out there but I can not find the screen.ThanksFor example, M voucher type is the default but I want PR to be the default for a specific user. 

Hi,Does anyone know how system works with automatic matching when PO lines are having different tax codes. should it get the correct tax code from PO to posting lines ?  I have tested few times but it only get the first line tax code from invoice. I used the copy unmatched PO receipts.. to get exact invoice lines, same as PO lines.When this is the case, invoice does not get auto authorized due missing tax correspondence with invoice line tax codes and posting line tax codes.ThanksGayan 

We have sold our company and now we want to remove it from the IFS Applications or set an end date. How can we do that? 

Hello,We have an scheduled job that goes every night to create customer invoices. Recently, warnings have started to appeared when the job are running. The warning text we get from the background job is Order: xxxxx ORA-20110:CustomerOrder:NILLED_ORDER_Invoiced orders may not be changed.What we can see it apperas to create the Customer invoice anyways sometimes and sometimes the customer invoice don’t get created. How and what can we do to avoid these warnings?   

Dear can any one can help me out unable to generate trail balance.Field value is manditory

Can a customer be linked to a supplier PO or invoice line?  We have a new process starting and are looking to pay a supplier on behalf of customer, then deduct that payment from what they have to pay us (or conversely what we should pay them). Basically we will have transactions on a customer account, and we have to deduct specific supplier invoice, to calculate final balance.  Can’t just link supplier to customer, as x supplier might be related to more than 1 customer, so can a specific supplier invoice or PO line be linked to customer account to help calculate this?

Hi I have tried to setup the Payment method rule but id didnt work.My Intension was to use another Payment method in case the invoice comes in another currency than default.For exampleThe default currency for this supplier is CHF in the payment tab i have setup two different payment Methods with the payment adress I have also setup a rule ID The rule ID says any amount in EUR shall use the payment Method SEPA  How Does the system now recognizes the Currency, whenever i Create now a payment proposal in EUR the Invoice gets not recognized i must add the invoice manually. Does anyone know the exact conzept of this Payment Method rule or how it basically works?

Hi,I cannot find payment output file path (directory) in Cloud 21R2 unlike Aurena or IEE. Can someone please confirm, is this an enhancement of Cloud or otherwise some permission issue in my user account that I do not see that option? Please advise. Thank YouRegardsNimesh

When you define a Backup File Directory location on the External File Template\Input Tab\File Name-Path Options?  Or where an ‘backup oracle directory’ is defined - either in the application or elsewhere?  We have always a error:ORA-29280: invalid directory path errorORA-06512: à "SYS.UTL_FILE", line 270ORA-06512: à "SYS.UTL_FILE", line 1243ORA-06512: à "IFSAPP.EXT_FILE_SERVER_UTIL_API", line 474ORA-06512: à "IFSAPP.EXT_FILE_SERVER_UTIL_API", line 483ORA-06512: à "IFSAPP.EXTERNAL_FILE_UTILITY_API", line 5102ORA-06512: à "IFSAPP.EXTERNAL_FILE_UTILITY_API", line 5153ORA-06512: à "IFSAPP.EXTERNAL_FILE_UTILITY_API", line 5706ORA-06512: à "IFSAPP.EXTERNAL_FILE_UTILITY_API", line 5725ORA-06512: à line 1ORA-06512: à "IFSAPP.TRANSACTION_SYS", line 1752ORA-06512: à "IFSAPP.TRANSACTION_SYS", line 306 ORA-06512: à "SYS.UTL_FILE", line 270ORA-06512: à "SYS.UTL_FILE", line 1243ORA-06512: à "IFSAPP.EXT_FILE_SERVER_UTIL_API", line 474ORA-06512: à "IFSAPP.EXT_FILE_SERVER_UTIL_API", line 483ORA-06512:

When using the bank statement upload, is it possible to have automatic allocation to a supplier/customer account. If we have 100+ transactions on a daily bank statement with a specific identifier, can IFS read that and upload the payment to account - to remove the need for us to process a mixed payment for each entry