Finance (Financials)

Dear experts,if I print an advance invoice and choose a text id (her 002) then I get the following error message.Does anybody know the reason? Tab General: Error message:PR 1465 ORA-20105: Report.REPRUNERR: Error [Oracle Error 01400: cannot insert NULL into ("IFSAPP"."INSTANT_INVOICE_DETAIL_RPT"."ROW_NO")] in report method [INSTANT_INVOICE_RPI.Instant_Invoice]

Dear experts,I would like to ask if somebody tried PDF conversion in IFS Business Reporter. I’ve enabled this possibility but result is not perfect. Report has 8 columns and PDF is created that first 5 columns are on page 1-9 and last 3 columns are on page 10-18 (you can see attached screenshot).Is there any settings/possibility to merge all columns to fit one page? Or to use landscape orientation?Cheers,Pavel

Hi, We have 9 sites running in one database on IFS 10 upd 14.The jobs to transfer transactions are running in one queue with only one process.  On some days these transfer jobs takes very long time to finish, around 4-5 hours for one of the larger sites.Is it safe to run this queue with 2 processes? This would mean that same job  with function Mpccom_Accounting_API.Transfer_To_Finance would be run at the same time for different sites?

Hello,Could you please explain how to process a customer/supplier mixed payment in the IFS functionalities (Apps 10)? I want the steps to recreate in the internal environment.Your support in this matter is greatly appreciated.Thank you!

When we are going to rollback the payment getting below error message  So here wanted to know how to resolve this parallel currency error. original payment voucher entry with highlighted line which is causing issue while rollback 

Dear IFS experts,I hope I can find answer here. I have created a report based on data source “Tax Ledger Transactions”. Right now the report is designed that there are mandatory filters for company, year and accounting period. End user wants to extend it to have not mandatory filter for invoice date where you can filter between exact days.I have created two report book/parameters InvoiceDateFrom & InvoiceDateTo with the same item FACT_TAX_LEDGER_ITEM.INVOICE_DATE.And in design row/filter criteria I expected to add two filtersFACT_TAX_LEDGER_ITEM.INVOICE_DATE >= &InvoiceDateFromFACT_TAX_LEDGER_ITEM.INVOICE_DATE <= &InvoiceDateToThis is unfortunately not possible because when I add first parameter InvoiceDateFrom I am not able to add InvoiceDateTo. The possibility to add is greyed. (You can see picture with visual explanation)Thank you for your feedback.Pavel 

We would like to start integrations between our bank and IFS. One of the questions our bank asked was, whether IFS support BAI files and if so, how could they drop a file to Restek and have IFS process it automatically?So my questions are as follows:1) Does IFS Support BAI Files for ACH Automation?2) If yes, is there a file type already within IFS in the External Files Assistant that would work or would we need to create a new External File Type? 3) What is the most secure way for a bank to push a file to our managed cloud instance (e.g. FTP)?

Hi…,My customer order continued 02 lines  -  01st line is in state of “Invoiced/Closed” -  02nd Line is in state of “Partially Delivered” - Therefore, the state of Customer order is “Partially Delivered”​​​​​​​** I like to know whether there is any method to cancel the 02nd line with the state of “Partially Delivered” and change the status of the Customer order to “Invoice/Closed” in IFS 08th version Thanks,Ishani     

Hi ExpertsI have created a project with 2 Sub Projects. Project Group selected is Periodical and Revenue Recognition is Project Completion  i have completed and Closed the Sub Project. Run Periodic Capitalization when i am trying to Complete the Sub Project through Financial Project Window, when i just Select the Sub Project from List getting Error Message that “All activity below selected sub project must be in status closed or cancelled”.Only 1 Activity belongs to selected Sub Project which is already in Closed state.Following the same Process on IFSAPP10 working fine but getting Error on IFS Cloud 21R1. Really appreciate Support guys thanks 

We have developed a Crystal report to output Supplier Statements which will update supplier on invoices that are open/status/value/due date. We have details of e-mail addresses in IFS that we would ike these to go, and a standard e-mail template to attach. However, when we run the report, the program sends all supplier statements as a multi-oage PDF to the first contact address on the list. Is there a way that these can been broken down so that when running the reports, each supplier receives only their statement?

We are starting to look into integration between IFS and our bank. One of the questions I have is I see IFS has a BAI file format (Apps 10) but is there a way to INGEST a file from the bank automatically?  Today we upload files and looking to automate aspects such as ACH payments. I was looking through routing rules/routing addresses out of the box and nothing jumped out at me then I read something about others doing this: 1. You have to define message codes based on your bank file2. Define external payment parameters within IFS based on bank file3. Bank would upload the document to the desired location, that file then would need to be placed in the application server IN folder. 4. The file will be loaded, and matching/payments will be performed based on the parameters setup. Setting up something like the Auto Cash file or something, I would assume we would need to do something with routing rules or routing addresses as well but maybe not. Any help would be greatly appreciated. 

Hi Community! We have one customer available in different entities however the invoice Type differs per entity. Is there a way to localize this setting?  Thanks!Giuliana  

Hi Community , While booking a manual supplier invoice I am getting this error May I know the appropriate resolution for this? The time taken for this error to show is more than 10 minutes. And this issue not with all the suppliers but some suppliers Thank you in advance.

How can we setup customer off-set automatic by some criteria / roles

 Hi What is the purpose of “payment type group per institute? Thanhs  

Has anyone had issues when Final Posting an invoice via Posting Proposal screen and ‘use as voucher date’ setting is ‘Use Preliminary Voucher Date’ - it says it has posted with the preliminary voucher date, but when you check the actual voucher it has used today’s date? This doesn’t seem to be an issue with the same setting applied via the ‘Final Posting Proposals overview screen. (On Apps 9, UPD 17)

Hi Community!I have created a planning dimension value list for GL Accounts and connected to the planning unit created as per the attached screenshot. But when I try to add the balances it displays all the  gl accounts in the system but not only the accounts that I have added to the planning dimension value list.Please advice the reason for this?Thanks! 

Hello, I had an interrogation regarding the Customer Offset Proposals on IFS Cloud (21R1 and 22R1).I am actually working on the payments received from unidentified customers. To do so and on the screen “Customer Offset Items”, I have some issues when I “Select Multiple Invoices/Prepayments” as you can see below.   Actually and once on the screen  “Select Multiple Invoices / Prepayments”, the screen is freezed and I can’t do anything except reading. Anyone has been in this situation ? All support or suggestions are very welcomed and appreciated.Thank you in advance comunity. Khalil

Hi Community!Is there already any development on place for managing rights in IFS?Finance related if we want a user has 2 roles for a specific entity, he/she will get both roles in all the entities assigned. Is there any possibility to handle rights based on entity and not on user? Thanks!Giuliana  

Hello,  I have a scenario where in the same customer order I can have one salesperson and one different commissioner (external commissioner). Is it possible to indicate both? How can I do it? I need both to be indicated in order to generate performance reports and pay the commissions. Thanks in advance

Our Finance can print a payment Check using IEE without problem, but the option to print a check is not on the menu in Aurena.We have APPS10 update 12 I believe...

A company wants to achieve Segregation of Duties at Group Consolidation, and wants to make sure that the user who enters an adjustment journal entry cannot approve his own entry [a different user needs to approve it].Note that it is generally the same set of users in the Finance department who enters and approves the entries, therefore, defining some users as those able to report and other users as approvers in Consolidation Security will not work.Other than doing a configuration [eg: have an event to trigger an error if same user who enters the entry attempts to approve it], is there any other method used by anyone?

Trying to book manual supplier invoice we get this error message: Field [AUTH_ID] is mandatory for Payment Plan and requires a valueWe had booked many manual invoices for this supplier, without issues.The difference is: this time there are more lines than one.Did anyone face this issue? We cannot find any Payment Plan..Thank you for your help!Regards Martina 

MRN lines can be changed after authorised by the approves until it is issued. How can we restrict that?

In the Account screen we have designated certain fields as Mandatory (Division, Department, Site).  When a purchase order is created is there a way for the purchase order to require these same fields before being approved?  It’s a hassle now because the issue doesn’t present itself until we try to final post the invoice.