Finance (Financials)

We are using IFS application Version 9, I am working on a project of reporting in that I need to fetch the Trial Balance Data directly from the Database. I know that from the application I can run the Trial Balance Report and Export it to Excel which I do not want. I need help to fetch the Trial Balance directly from the DB or any if you know the view which can provide me the TB Data.

Community, I have a question about customer invoice currency. if my customer order is in EUR currency, and my base currency is in USD, can i print the customer invoice in USD?Thank you. 

Good day,For a customer of my I need to implement the ACTUD and QR-code for a company in Portugal.Does anyone know how to get the AT-Validation Code?Must you do the buy using the webservice of the AT? I've also installed the localization of Portugal for APPS9. The customer is using IFSAPP 9Thank in advance for the answersRegards,Raymond

Hi,I am working on ifs cloud for payment  files creation in background , I want to bring back  the value “company”  on  file name.I have tried with the sender , but it doesnt match Thanks for your help    

Is there an Inventory Value Report matching with specific GL Account [which is defined in the posting controls] and Values?  Basically, looking for the inventory details associated with GL Account [Accounts are defined in the posting controls for each type of transactions] for e.g., Inventory Account, Goods In Transit, Goods at Supplier, etc.

Hi,  We have been using an Authorization Assigning Rule to allow charge lines on invoices to be automatically approved up to a certain value. My AP clerk has just informed me that this is no longer happening and the rules are instead pulling through a authorizer who still needs to go in and manually authorize.is there a way to switch this rule so it goes back to automatically authorizing to the value of the rule? Also, we have a tolerance amount of up to £10 or 5% set on the company and small variances below these values are still requiring authorization, is there a setting i am missing somewhere that allows these tolerances to be used? Thanks, Georgina  

Hi Team, I am doing a IFS BR using structures, How can i configure values to structure id and description.When i select the cells and add the Structure repeater it populates for Company in the below case after selecting the company it doesnt show up any values, how do i check the data in this case? Please do let me know if i am missing any settings or configurations. Thank you 

Hi Team, Can anyone help me the steps to create supplier and customer advance payment process  Regards,Nag

I am trying to run a variance report within Shop Order that will show me any direct material variances and show me if we made any errors when closing the shop order.What I want to be able to run is something that will show the entered order amount when order by the customer and its total price versus the price of what we actually put into the material.Right now I can run a report that shows me how much weight I put into the shop order but it does not show any cost. We do all of this manually so at times we make mistakes and I want to be able to catch these quickly and not weeks/months later when it is far to late. 

Good morning, I would be very happy if someone can help me.We need PCA per cost center in a customer project, but not all posted accounts may be included in PCA. Is it possible to implement it this way? Thank you very much for the supportAndrea

Does anyone know, which setting is wrong, when PDFs are not shown in the embedded viewer in the Instant Authorization screen, but open in an external PDF application (e.g. Adobe Acrobat) instead?

Why is it mandatory to provide the city and zip code when using the E-Invoice process. What the reason to have it and where is been used when creating supplier invoice.

Hi, We need to change the date format companywise while selected the option email invoice in customer invoice screen.  Please suggest how can we achieve this.Note: we may have to use 4 -5 different date formats as there are more than 30 companiesIFS version 9 Regards,Vipul

We had this problem begin a couple of months ago and I’m at loss for figuring out why it’s happening and what we need to do to fix it.  We use the External Supplier Invoice Assistant tool to upload some of our invoices:Everything appears to load without errors:We can see that they’re loaded on External Supplier Invoice:

I have a few questions about "Batch Print Customer Invoices" in IFS 10 EE;How do I email just Customer Invoices (the ones that are in Sales-Invoicing-Customer Invoice)  from "Batch Print Customer Invoices"? Under "Advanced" all the options are selected (see my screen cap attached) but do they all have to be selected? What is the difference between "Email" and "Send" in the Print Options? (I only want to email)Also, what do I enter for "Planned Invoice Date Offset" if I only want to send invoices created say within the last to days?Thank you for any replies.

I’m sure this will have come up before though I can’t see any questions.  Since we made the mistake in year 1 of having Apps9 (!), at year end we have always removed any Prelim Supplier Invoices that we knew weren’t going to be finally posted in current year.  Is this something everyone else has to do, or is there some other approach/workaround/trick we are missing/setup we are misunderstanding?Thanks!

Hi,When I am trying to navigate from the lobby to the AP Supplier Invoices Analysis screen, the data is not getting filtered while navigating, all the records are been getting populated in the screen instead where only the data present in the lobby should have been populated.In IEE it is working fine as expected but, for aurena filtering is not happening.I have used this navigation URL:page/ApSupplierInvoicesAnalysis/List?contexts=Company:$Company$&$filter=(LedgerItemSeriesId eq $[LEDGER_ITEM_SERIES_ID] and LedgerItemId eq $[LEDGER_ITEM_ID])   Any suggestions on this. Thanks in Advance.Regards,Vikas G 

Is there any way to tell who created a line on the Mixed Payment Transactions tab?

Hello, INVOICE_ADDRESS_ID of system defined template STDCIN2 has wrong column number, and this is causing error during check external invoice functionality. INVOICE_ADDRESS_ID value from csv file is shown in CORRECTION_REASON_ID and address cannot be validated. Manual correction is required as a work around. The same issue is on IFS10. Thanks  

Hello I am interested in using project tasks - does can anyone advise or best practise for setting these up and how beneficial they are? Kind RegardsPaula

I am seeing several posts regarding the STDSIN1 and STDSIN2 external templates, but am not sure it’s clear which one I should use.  Can we use the STDSIN2 - Standard Supplier Invoice File A template to import a supplier invoice with multiple invoice lines each coded to a different account?If so, can someone please provide some detail about how to accomplish this.thanksShelley 

For BI reporting purposes, I am looking for a way to correctly link the data (costs) from the GL Voucher Rows Analysis to the Part number (as per Customer Order). Unfortunately, it appears that there is no unique identifier to link the GL voucher information to the inventory transaction history, mpccom accounting, customer order, …  I can only do an approximate link, by mapping the GL Voucher Rows Analysis [Voucher number, voucher type, account, code parts, amount] to the mpccom accounting table + [order reference] to the Inventory Transaction History. That way, we can fetch the Part Number from the Inventory Transaction History.This only works when there are not multiple rows on the Customer Order with the same cost (and code parts).  Has anyone found the real unique reference from GL Voucher information to the inventory module? 

In FSM,How charges are collected from end customer (invoicing and payment) ? and further posting process? How Supplier invoices are created/received from supplier and payment made ?  Information about Payment gateway integrations for FSM payments? Storing of credit card information | encryption method | options to pay from customer mobileCan you please give me answers for these? or direct me to the right document/link.

Hello All,In IFS 10 for Brazil localization , there is standard External File  template provided for inbound integration to import Incoming Fiscal Notes.However the fields in external file template is not straight forward and I am finding it difficult to understand it and map it to the data in sample xml file that  we have received. If anyone has worked on it  and share some intel on this, that would be helpful! Thanks & RegardsSupra

Dear all,can you pls. share latest version of Country Strategy Roadmap for IFS Cloud? We would like to understand what country extensions we can expect in further releases of IFS Cloud (we are on 22R2SU2 now).This time we are particularly interested about GST for India.Thank You!