Finance (Financials)

We have a problem exporting a Financial report to excel from Report Archive.We found a limitation on the Row template. If we have more than 821 rows we get the error message above.It doesn’t matter which row we remove, we only get the error if we exceed 821. We get the error in APPS9 and APPS10. I used Debug and it seems like the rows are being built into a string but when it exceeds 4000 chr in length it errors.Can this parameter be increased?Thank you,

Hi,Is there a way to upload invoices in ‘PostedAuth’ status. I used external file template ID ‘STDSIN2’ & its create the invoices in status.  Best RegardsNarmada 

How to use the Mixed Payment window to offset an existing Parked  Payment?

Dear community.I want to create a customer credit invoice for my Component Repair Order. When I do this via the Customer Order invoice i get this error..ORA-20110: CustomerOrderInvItem.SERVICECREDITERR: Creating a credit/correction invoice is not allowed. Service crediting/corrections should be handled from the service itself. Does anyone know how i can create a credit/correction invoice?Thanks.David. 

Is there a way of raising a non-stock customer invoice in one company and automatically registering as a supplier invoice in another co - e.g. for Management Charges?

Both Customer and Supplier have tabbed screens ‘Invoice’ for LU IdentityInvoiceInfo.If I want a permission set to view the Customer > Invoice as read-only, but Supplier > Invoice as read/write, is that possible?I have tested different options but not found the right one within the permission set detail (have been editing the ‘Database Objects’ but they seem to be linked for Customer/Supplier eg both must be read only or both must be read/write.Any solution?Thanks

Hi All,Do we have any option, when we create difference Items if  we can connect to the orignal Invoice.So Customer is creating  Direct Debiting Order and when file received from bank for failed debit transactions, is there any option to repoen the invoice instead of creating customer difference items. Regards,Praveen

Hi,  Is anyone aware of a screen in Aurena where users can download multiple supplier invoices in one go? 

Hi, You can add a note on a supplier invoice in the menu Supplier Invoices Analysis (right mouse button > Notes). I want to display the note text (‘test’ in the screenshot below) in Business Reporter, therefore I need to create a new field (Relations for Facts) with a sql statement. But I do not know the correct sql statement. Is there someone who can help me?   

When creating a project invoice using an invoicing plan, the system is assigning the employee ID (as code part) to the posting related to revenue account.My understanding is that this is linked to PRJI1 (for taxable invoice) / PRJI2 (for non taxable invoice) posting controls and how code part Employee is setup (control type used, etc.). Currently, the Employee code part is associated to control type PRJC2 (Employee), i.e. is using the list of employees. This is fine for invoices using employee related project transactions. And if we use project transactions coming from Non personal project cost registration, then * is assigned as Employee ID and the system will then assign (on the invoice) a default value for the Employee code part.Since Invoicing Plan is to invoice scheduled fixed amount invoice and, at least in our case, is not linked to a particular employee, I’m wondering: is there a way for IFS to assign * as Employee ID (similar to Non Personal Project Cost Regis

We received this error message “Case can only be modified by Trackers”.    What causes this error?   We received this error message in Finance and Shop Orders.   

Hello to all the Accounting members, we are tying to configure IFS to automatically reverse a GL voucher entry after the first of the month.  This is the classic accrual type of GL entry whereby we make a GL voucher transaction entry in one month and auto reverse it the next month after the actual charges post to the balance sheet.  When creating a manual voucher entry, we do not see anywhere we can set a reversal.  We are on IFS APPS9, UPD16.  How can this be achieved in IFS?  There has to be a way as this is Accounting 101.Thanks!Mark

Hi, Can someone explain the correct meaning of ‘Apply Last Step as Authorizer’ check box in the Authorizer Assigning Rule window?  

where can i search for a u voucher? we have posted u voucher in the ledger but its not appearing in the purchase ledger control account. Help please 

Hi, We have a customer in Mexico and want to update UUID through Web Service. To update UUID in Manual Customer Invoice, did IFS Provide Standard Web Service to update UUID.  Regards, Kishore Nenwani

Hi All,I’m looking for an External customer invoice template where the multiple tax lines will be automatically created. My customer is searching for a template similar to template STDCIN2. In my customer, multiple taxes have been defined in Customer/Address/Delivery Tax information. I’m not defining any tax information in the file except VAT_CURR_AMOUNT. So my expectation is the multiple tax lines will fetch to the external invoice based on the customer information.I have checked the same for supplier side through STDSIN2 and it worked correctly by taking the multiple taxes defined in supplier /Address tab.Is there someone that can help me out.Thank youBest Regards,

What are the different activities involved in India Localization (GST)

Hi,Can anyone share the excel template for External File Template- STDSIN2?? both for app-9 and app-10 or any of the versions.

Hi,Is it possible to have a multi company cash flow report? Thanks!

Hello, Hope y’all are good and safeWhen I check the box in "Company>Distribution>Checkbox: Publish price difference on arrival", does that affect the budget? What is the practical use of this?The issue is in the cost allocation at the time of the P.O's receipt, since between the period of registration of the supplier invoice and receipt, the amount can’t be found. The amount is no longer registered in the committed costs and does not appear in the current. Thanks in advance

Our Accounting periods has been set to follow 4/4/5 calendar, the depreciation calendar also follows the same. When we created a depreciation proposal, we could see that depreciation is calculated using calendar month rather than the 4/4/5 period. How can we get the system to calculate depreciation using 4/4/5 calendar. ? 

Hi,Our organisation is looking for an IFS Consultant to perform a review and health check of our IFS implementation.  Is anyone able to recommend an individual or firm that we can approach for a quote please?We’ve been using IFS for a number of years but would like an expert to give us some feedback on best practice etc. and also assist us with set up of functionality available that we're not currently making use of e.g. consolidation.Many thanksPaula

Hi Guys,I am using IFS 7.5.I would like to trigger Email with Customer Statement of Account attachment to every customer on the fist day of each month.I need your guidance on this.How to setup 1 Report Scheduler that can generate PDF with only 1 customer data per PDF file? Currently I need to setup multiple schedulers and key in Customer ID one by one as per picture below.How setup event to trigger Email with SOA attachment to every customer separately? Even if the above Report Scheduler able to generate PDF with single customer data, the event action is not able to recognize which PDF file is for which customer.Someone advised t

Hi All, We have recently gone live within IFS 10 and are looking to understand how to best utilise the Customer Analysis screen.  Within this screen there is an AR Contact field which allows me to Zoom to the below screen:  However, when adding an AR Contact I’m unsure on how to link to the specific customers in order for the Contact details to display within the Customer Analysis screen. Please can you help? Thanks

Dear All,  When I try to activate an object it gives me the question “Acquisition value is zero. Do you want to activate the object?”. Normal cycle is followed from PO to invoicing and why does this question arise?