Finance (Financials)

When loading a BAI file into IFS, how does IFS distinguish customer invoices from the remitter name in detail record 6, positions 51 - 80( using BAI 80 )?  These positions, according to the functional specifications, list these positions as either invoice numbers of a 15 character remitter name and on 9 digit invoice number.  How does IFS distinguish and invoice number from a remitter name?  In testing we had remitter names showing up as invoices to match.We are using APPS 9

Hi,I would like to add a fixed discount line to a project invoice.How can that be done?I’ve tried to set a negative sales price in the invoicing plan and in the project cost registration, but i doesn’t show up on the invoice.BR Kresten

Dear All, Is it possible to assign a default general ledger to a Supplier?If so how can that be done? Thanks in Advance,RegardsRaymond

Any ideas how this could happen?Normally we run a print/email and this performs following stepsTakes the Prelim Invoice and creates a Final invoice Final invoice is then emailed to the customer where email address is present It would seem, somehow the email has sent the prelim invoice rather than the final.Any ideas how I can stop this happening?

I need to come up with a repo to show management how many times a supplier invoice has matched to a PO. we have issues where people forget to receipt and would like to be able to measure when a user tries and fails to match on first pass? anybody know of anything I can work from?

Hi All, Does anyone has experience with GL vouchers import for DATEV tool format. This is for German Tax Reporting. Thanks

Hi,We are currently on Apps 8 in the UK and reviewing our options when it comes to scanning of supplier invoices Automatically into IFS including the capture of data on the invoice to improve data entry accuracy and make process more efficient.Has anyone else implemented such a solution and if so, are you able to provide recommendations.Thanks in advanceShaun  

Hi All,Is there a logic in the application that is possible convert a voucher entry including a contra account?For example, Posting Type Account DR/CR Amount IP2 - Debtor 120.01 DR 100 M28 - Sales 600.01 CR 80 IP4 - Tax 391.01 CR 20  To presented as below.  Value DR/CR Ledger Account Contra Account 80 DR 120.01 600.01 20 DR 120.01 391.01  I tried GL Voucher with Contra Account. But the issue is that since it present all voucher rows, the transactions become double booked in that way.Thanks

Hi All,  I am facing this issue here at the time of creating a credit invoice against a Project Invoice and  its showing an error “[NET_CURR_AMOUNT] is mandatory” . Invoice is at PostedAuthorized Stage. Attached is the screenshot. Can anyone help?

Hi,We are using the invoicing plan to create a project invoice.We make some lines in the plan and select them.Then we use the create invoice option in the menu. Now a Preliminary invoice is created and here comes my problem:How can I add new lines to this invoice?We are on IFS 9.BR. Kresten

I am about to build a balance sheet in Report Generator. I would like to create three columns; Opening balance (for period) Closing balance (for period) Closing balance (last year period)How do I create this, choosing which column type? If I choose a “Data column” I am able to choose do a period selection but I don’t know if it is the right way to go. And if it is the right way, how do I create the different periods? Thanks in advance!

I am about to build a balance sheet in Report Generator. I would like to create three columns; Opening balance (for period) Closing balance (for period) Closing balance (last year period)How do I create this, choosing which column type? If I choose a “Data column” I am able to choose do a period selection but I don’t know if it is the right way to go. And if it is the right way, how do I create the different periods? Thanks in advance!  

Higood Day;I have good expertise in oracle financial module; I need your help to study “essential understanding of IFS Applications”  and IFS financial module.could you please guide me to download free materials? 

We have created an event that will email the customer statement of account when a report has been run.I have concerns about the number of messages that will be generated and sent when this is run.Has anyone used a bulk mailer system process these messages? The next question is how to export the individual messages so they  can be transferred to the mailer service.  

I found the below regarding ‘describe input’ via the external file assist.  The ‘next’ button is not enabled when I attempt (even logged in as ifsapp).   Does anyone have details that may help? 

We are rolling out IFS 10 in a German subisdiary and they a highly automated payment flow.As per discussion, I am facing the same challenge. ISO and SEPA adds IFS Payment order reference in the EndToEndID tag but how do we verify that IFS can match that order / or order’s items by using the MT940DE fileformat ?We have tried to replicate their current MT940 returnfile with IFS Payment Order ID  but this is not recognized - yet.What we are looking for is a way to know for sure that the items in the Paymnet Order can be acknowledged/paid by means of loading the MT940 bank statment into External Payments interface. The prepared references seems not to recogninse the EndToEndID tag value. Is there a particular set up requiered in the format message codes ? 

Is there any documentation on best practices for Posting Controls setup? We’re looking to have a better process for setting up posting controls when a new company is setup. Is there an easy way to copy them over from another company in mass? How do others handle this? Adding them on the fly as accounting runs into errors is not working. Surely there is a better/easier way?

When processing a customer Direct Debit run, the posting is going to incorrect GL code meaning we have to journal the value each month. Where can we change this posting so that they are posted to correct GL code?

Hi   What are the limitation in Apps 7.5 when compared to Apps 10 in handling MT940 bank statements in External Payments? I have just checked and saw that only a MT940 format to handle Customer Payments are available in Apps 7.5? Does it mean that it not possible to handle MT940 with all types of transactions - Mixed Payments (Payment Orders, Customer Payments etc)

When trying to set in the company tab invoice - general the “Same No Preliminary and Final Supplier Invoice” checkbox, I got this error message:„There is voucher type J with automatic allotment set. Uncheck the „Same No Preliminary and Final Supplier Invoice“ fieldI was able to find the automatic alloment setting in Function Group Analysis, but this can not be changed.Can anyone help me to fix this?Thank you for your reply! REgrads Martina

Dear All When I try to load a External Xml Payment addFinancials → cash book → Extrenal Interface → External InterfaceRMB Load File Select my Payment institute and Payment methode the result is.  What could be a reason why this message Appears? Kind Regards Raymond

Looking at process for non-PO invoices and the instant authorization approval Is there anyway to have specific suppliers set up with default acknowledger/authorizer or does this have to be entered each time you register an invoice?

When loading customer invoices from a file Apps10 UD8 getting an error below.I have the customer set with a payment method with no payment addressInvoice Type = EXTINV, Invoice Series = EX (no series ID as the invoice number is set in the file)I never had issues in the past so maybe I’m missing a new setting somewherethanks in advance!  

Does anyone know why I am getting the following error message when I try to export my Quick Report to Excel?Excel Plugin Error: ORA-06550: line 1, column 43:PL/SQL: ORA-01031: insufficient privilegesThe Quick Report runs fine in IFS and, once run, I can output the results to excel, but I can not simply  do the report function “Export to Excel”.  The report is written against a materialized view in IFS.  I can see the view in IFS SQL Query Tool and can preform searches on the view.The report is written using the following SQL statement:select * from c_pol_gl_sales_cogs_union_mvI have tried using &AO., IFSINFO., prefixes to view name with no luck.