Finance (Financials)

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.

Hi, We have non inventory sales part invoice in ‘Printed’ status and when I checked customer invoice posting analysis it is showing me an error for non inventory sales part “Value is missing or has an invalid time interval for posting type M30 control type C49 code part B in company ABCD”  How can  I resolve this error ? Please help.

HI All  I got a problem when setting up a SEPA Credit transfer file with from a German company using Nordea in Finland. Is there anyone that can help me understanding what the errors are and were to correct.  

Hi All,  I got this error when uploading a CAMT file, anyones that nows anything about that? Error text Error (ID: fceb37fb-f043-4782-8073-41473a357799) while invoking opertion: XMLREADER_NEXT:Cannot move to next XML event at [1:39]: Unexpected character '1' (code 49) in prolog; expected '<' at [row,col {unknown-source}]: [1,39] Caused by: ifs.fnd.base.ParseException: XMLREADER_NEXT:Cannot move to next XML event at [1:39]: Unexpected character '1' (code 49) in prolog; expected '<' at [row,col {unknown-source}]: [1,39] Caused by: com.ctc.wstx.exc.WstxUnexpectedCharException: Unexpected character '1' (code 49) in prolog; expected '<' at [row,col {unknown-source}]: [1,39] 

Dear All,When i try to read an extrernal CAMT 053 file I first get a information message see below. After that i get the message: I've defined the following things in IFSBIC Payment Formats message codes  Payment methodes Extrernal Payment parametersI'm using a MIxedpaymentIs there a limit on the lines of a bank file and where can i find some more detail about why the unpack doesn't work?

I have created some saved searches and saved them within a new folder.  How can I share these so that other users can access?

Can any one help me to Implement or How to User TCS Statutory Complance in IFS system.

Can anyone let me know the steps which need to follow under IFS budgeting process.?Please help .

In Aurena, the BACS file is dropped on the default download location for the users browser, unlike EE where can file path can be specified. This isn’t secure or consistent. Anyone found a solution to this either in the application or using any external software to move the file maybe with a script? Thankyou.

We are trying to deploy e-invoice to generate supplier invoices for the French  Chorus-Pro service and have come across limitations of the e-invoice format. Does anyone have experience of extending the output XML file format to include additional information?

The currency rate for a certain day was entered incorrectly.  The rates for USD and EUR were reversed.  I have several customer invoices that I need to correct.  What is the best way to do this?  I went into the customer invoice and entered the correct rate in currency rate correction.  Then I tried to create a correction invoice, but nothing happened.  The background job has a warning that says the Invoice ID does not exist in Company 14.  I’m not sure why it isn’t working, because I’ve done this before.

Using the Ehancments Spreadsheet I’m seeing something that came out in Apps 9 UPD12 that I would like to know more about.  It’s in the Financials area.Where can I get the News PPTs for that update so I can review?

Hello Everyone, We currently generate one invoice per customer order and email the customer a PDF of the invoice during the invoicing process.  Some of our customers have requested we send them just one PDF containing multiple individual invoices.   The customers want a separate invoice number for each order which we believe rules out using collective invoices.  Finance would like to have IFS basically print each invoice into a PDF and merge each new printed invoice into the same PDF so when a customer opens the PDF they’ll see multiple invoices within the same file. Thank you,William Klotz

Hi everyone,I’m trying to figure out if IFS has localizations for such countries as Argentina, South Africa (RSA), Egypt.  And if it does how far it goes. In other words, if we go with IFS, do we still need to use local solutions to cover all the accounting & taxation requirements OR we can rely on IFS financial module and get rid of all the local financial software? Thank you

A new VAT regulation will be implemented in Sweden in the beginning of 2021. The VAT regulation imply that VAT reverse charge will be applied when sale of certain parts/products decrease a value of 100 KSEK. If the value of the same part/product is below 100 KSEK the ordinary VAT rules will be applied. The VAT regulation will impact both sales and purchases.Does anyone have a setup in IFS to handle multiple VAT-codes in the same supplier invoice and is applying automatching against purchase order (Note: not on part line)?   Does anyone have a setup for customer invoicing where the VAT-code used is dependent on the value of the invoiced parts/products? Also, if multiple VAT-codes can be used in the same customer invoice applying the above rule?Thanks.

Hi, I can’t seem to get the Customer Offset Proposal functionality to work as I was hoping. It will happily match one-to-one (eg Customer Payment on Account for £200 to one invoice for £200), but not one-to-many (Customer Payment on Account for £350, one invoice for £200 and a second invoice for £150). Is there a specific setting I need to choose when creating the Offset Proposal, or is there a setting on the Customer that I am missing…..or something else? Or does the functionality just not work as I had imagined/hoped? Thanks,Chris

Hi, What is the approach to be followed when migrating transactional data to IFS from a Legacy System?When migrating these data should those posted in IFS to create GL vouchers that will ultimately calculate the GL Balances as at Cut-Over date.Or just migrate GL Balances separately and transactional data without posting to GLFor example, the customer need to have last 3 years(2018-2020) Invoices in IFS when Implementing IFS. Can we migrate invoices just in PaidPosted state without posting them? What will be impact to Analysis windows?

Hi,I created an external file type copying ExtSupInv and when I upload a file, it gets deleted from the file location.How do I stop this from happening?I am using APP10 UPD 5Thank youPamith

I had a request come my way and hoping for some guidance.  We have a new Controller here and he is wanting to utilize a corporate account reconciliation process.  This would involve exporting data daily from IFS in a certain format (see below).  I’m sure this is doable, but don’t know best way to do so.  First look seems like the External File functionality in Accounting might be a place to start.  Wondering if anyone has set this type of transfer up before and if I am on the right track. Thanks in advance!  We are on Apps8 sp1+ To integrate  we’ll need a trial balance and ledger transaction file published to a FTP directory daily.  Text files Pipe delimiter “|” No column headings Static filename (so data overwrites and doesn’t create new files) Trial Balance- 13 months rolling periods including current month (include all accounts- even without activity and zero balance)BU Name|Year|Month|Account|Account Description|Opening Balance|Net Activity|Total Debits|Total Credits|Ending Balance

Does anyone know where the setup is for the RMB/Send Email option in a Supplier Invoice/Posting Proposal (Apps9), please?  I’d like to be able to change the text/add more fields if possible.Thanks 

Hi, does anyone has experience in a similar requirement as described in the example hereafter :Belgian Company, country code = ‘BE’ created with a Belgian VAT number. Due to Brexit, this customer has to register for tax in United Kingdom.   So, besides Belgian VAT number, there also will be an UK VAT number, active as from Jan 1st, 2021.Accounting is in EUR.  Customer invoices sent to United Kingdom customers can be in EUR and GBP. VAT reporting for Belgium is in EUR, that is OK.VAT reporting for United Kingdom must be in GBP. Following questions are raised:Is it possible to have a tax reporting done in another currency than the accounting currency ?  Does anyone have experience with that ? To allow the Belgian company to use the S089 tax template, is it smart to copy this tax template (i.e to S089_BE) ?   At time of copying the template, the country linked to this template will change to BE, but is this smart to do, meaning there any delimitations ? Is functionality available to submi

Hi,Can we Implement the Below Mention Scenario in default IFS 10 Systemwe want to apply Tax on net Value and Tax for E.g :-Net Value :- ______________________________ = 100000GST Tax - 18% :- (100000 x 18%) ___________ = 18000TCS - 0.075% :- (100000+18000 x 0.075%) = 80.5 (I want to apply this type of calculation)Gross Value :- _____________________________ = 118088.5 can Sum one help me to find out how to implement the above scenario in the systemI have tray through Tax Code and Tax structure but I didn't get the right solution because the TCS Value Calculate on Net Value(Not including GST Tax Amount)

USD is the only currency used.  Why would I not see this error during proposal or pay order creation?   What does this mean in a one currency configuration?

Invoice Authorizer Workflow, Does it come with standard build??  In my current project this component is missing and ifs system team is saying this is under E-invoice adapter component. Is it so???

Hi,We have few ‘ARR-NONINV’ transaction type i.e., non-inventory purchase transactions from the last few months that are being held at Accounting Status Code 2 (Created) and not moving forward to Code 3 (Transferred). Hence these transactions at Status 2 are not hitting GL. Our Finance team confirm they haven’t modified any Posting Controls recently.  Can anyone share your thoughts or idea on what is going wrong? Any solution provided is helpful!  Thank You