This will include the questions related to Financials.
- 3,286 Topics
- 9,305 Replies
Quick Report Export to Excel Function Insufficient Privileges
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.
Bank Reconciliation process - automatic Transaction Matching
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!
Accounting Periods - Final Close
We went live back in August and want to tidy our accounting periods up. We have them going back to 1900. For a number of years the periods are closed but the year is open. How do we carry out the RMB > Final Period Close on the Accounting Periods screen, The periods are all closed and there are no outstanding transactions/errors etc., reported when running RMB > Validate Transactions in Progress, but still the Final Period Close is greyed out. Also, is there a way to carry out a number of year ends.Would it be a case of using Cursor and API calls to perform the same task as running through the process in IFS.
Cancel and Create Supplier Invoice
HelloWhen you try to Cancel and Create an existing Manual Supplier Invoice which is in PostedAuth status there’s a message that appears informing the user that they are not authorized to cancel the invoice.It seems that in statuses other than PostAuth that the Cancel and Create functionality is available.Can anyone confirm that this is the case?ThanksAlan
Open Item Accounting - General Ledger IFS
Good afternoon, Does IFS support open-item managed GL ledgers? I have lots of users booking entries against balance sheet accounts, and we require to go through a lengthy month-end process to reconcile netting debits/credits (whether these be auto reversing journals or other types), in order to understand what makes up balances on our balance sheet. This is a lengthy and manual exercise, often involving thousands of lines in excel.It’s common for accounting software to enable open-item management of GL ledgers, allowing users to either: ‘close’ debits/credits against each other that net to zero ‘close’ debits/credits against each other that dont net to zero but are within a tolerable threshold - writing off misc FX/variances to P&L accounts. automatically ‘close’ debits/credits against each other, if they pertain to auto reversing entries.Using the above functionality, allows balance sheet accounts to be maintained real-time, enabling management to get visibility of balance sheet
Material cost and pricing
Hello All, I am currently looking for a way in IFS to quickly understand the impact of material cost changes, and pricing actions that should take place. Currently, we change our material pricing quarterly. There is significant interdependence between our material cost and the pricing of our product. It seems that within IFS, we are looking in the rear view mirror, as we do not know the impact of the changes to material cost until we have made them. At times we are finding that our cost to manufacture the product exceeds the price we are selling to our customers for. I’ve reviewed a few areas in IFS, but I have not found a module that allows you to evaluate the cost impact of a material price change. Any guidance would be greatly appreciated!
Does anyone know how to genereate a file with SAF-T format in IFS apps 9? Does anyone have an instruction for set up to share? (SAF-T Financial is a standard format used in the exchange of accounting data. SAF-T, or Standard Audit File-Tax, is the result of a joint development collaboration between the business community, the accounting sector and the Norwegian Tax Administration, based on a recommendation by the OECD) Thanks in advance, KR Christina
Supplier Payment Rollback - Partial Payment
Booking Control Supplier Partial Rollback: In the case of "Supplier Payment Rollback - Partial Payment", we already have the problem in IFS7.5 that the lump-sum partial payment is not posted back to the supplier, but to the company ID. The fault is the booking control PP9, because this is not can be set equal (according to supplier group) posting control IP1. Please advise on how this can be corrected.
IFS Apps 10 - Issue: Unable to Pre-post Code Part value for Posting Type PP17 when attempting to save customer check with automatic write-off amount.
IFS Apps 10 - Issue: Unable to Pre-post Code Part value for Posting Type PP17 when attempting to save customer check with automatic write-off amount. Setup: [list] [*]Posting Type PP17 setup with AC1 - Fixed Value for Account (Code Part A) [*]Account has Code Part Demand 'Mandatory' for Code Part B [*]Posting Type PP17 setup with AC2 - Pre-Posting for Division (Code Part B) [*]Customer setup with Tolerance Amount of $50. [*]Enter Customer Check and match invoice for less than the amount due, but within the automatic write-off tolerance amount set for the Customer. [*]Automatic write-off amount shows on the customer check line info and in the Withdrawls pane. [*]Highlight the customer check line and select Pre-Posting [*]Enter valid pre-posting value [*]Save the record - Error message appears Wrong Code Part demands for posting type PP17 [/list] I have a client with this issue in IFS Apps 10 (not sure which UPD level they are on), however, I can not recreate the issue in an IFS Ap
Hello everyone, I am a new user of IFS 10 and have few questions regarding the process of supplier invoices and possibilities of automation/time saving. At the current situation, we use "external supplier invoices" to register invoice recipient and make sure there are no "load errors" in the invoice, then we go over to "Final Posting Proposal" to fill out the post accounts, project, product number etc.. Are there any possibility to shorten this process and amount of "mouse clicks" here? For example, I have used other ERP systems before where there was only one page with the whole overview og the invoice. Meaning that you could de the tasks in "external Supplier invoices" and finals posting proposal" in one page. Would like to know if this is possible, or if there are any other ideas/shortcuts you think of that could be useful to shorten this process. Thank you!
How can i write off a customer over payment
We have multiple 1p over payments that we would like to write off. Normally we refund overpayments, but the admin is just too much. Would I use the customer offset screen? Also I can write off invoices as a whole, but not part payments. Am using the customer offset screen - any tips?
Emailing Customer Statement Of Account
We are running Apps10 UPD8 Our Finance department would like to start emailing Customer Statement Of Account reports directly from IFS. We are testing the setup in our test environment. We already use report rules to email other reports out of IFS, so I know IFS can send emails.Where we are atSetup the AR Customer Contact information under the Payment tab in Customer. Output Media is E-Mail. When we run the report - I can see it in Report Archive with Notes = “Output Media: E-Mail, Language: en” The Printed checkbox is not selected (correct) But - the email is not being sent.Based on the documentation, it sounds like it should just email, but I’m not sure if I need to setup something else.If this should work - any suggestions on where to look to figure out why the email is not being sent? Or do I need to setup a Report Rule to actually send the email? Thanks
External Supplier Invoice Template STDSIN1 or STDSIN2/Duplicate Invoice No error
Does anyone have either/both of these templates they could share, please? If there is a completed example that works that would also be appreciated too. We have an issue (Apps 9) where we are trying to import a multi-line supplier invoice (one invoice no, multiple lines/postings/tax codes) but the invoice fails to load. When we import an invoice with one record, it imports without error. When we try multiple lines we get the following error Any suggestions/ideas would be much appreciated. Linda
FA will not be updated error
We have an issue when trying to report an add investment through a PO. The fixed asset reference is provided. However, results in an error in the Accounting tab of the purchase transaction history “No further acquisition possible for object (Object ID). FA will not be updated” the PO is in the closed status. As a result, the period cannot be closed and transactions remain in the ‘distribution and manufacturing transactions’. Please advise on how this can be corrected.
Hi , I have made the set up for external payments upload for Customer payment invoice matching but all the upload is going to parkpayment anf unable to genrate mathing based on the external payment parameters setup. I am trying to upload customer payment on mixed payment. 1. 2. 3. Mixed Payment file 1_HEAD;;JOD;16-03-2020;;; 2_DETAIL;;;16-03-2020;2548;;20ACT00115 4 I am using IFS V10 UPD3 it workis well in IFS 8 Regards, Mukesh Gupta
Automatic matching for intercompany supplier invoice
Hello,I'm having issues with regards of automatic matching when doing intercompany invoices in IFS.If the check box "Create when checked" is not ticked in the external supplier invoice parameters, I have to create the invoice manually when the invoice is loaded and the invoice is automatically matched with the PO as expected (through posting proposal).As my customer is willing to automate all the steps, I'd like to do the process where the invoice is "created when checked", to avoid manual creation. The invoice is indeed created with no errors but it seems like the system doesn't find the receipt. Thus, the automatic matching is not automatically completed, whereas the PO was indeed fully receipted.My posting proposal status is "cost invoice" and in the invoice lines I can see the PO reference and not the PO receipt (which I can see when the invoice is created manually from the screen: External supplier invoice load information, after being checked automatically).Please note that I man
Already have an account? Login
Login to the community
No account yet? Create an account
Login as an IFS Employee
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.