Finance (Financials)

when  a user try to send a lot of invoices via EDI at a time (eg-120 invoices) in “print customer invoices window” get a server error that the buffer is too small, but if  send them one customer at a time(in batches) they all send with no issues. Is there a way that the user can send  all the invoices at once without batch sending. Error message16:33:25 ERROR - PL/SQL: (Server Error) numeric or value error: character stringbuffer too small Database error occurred. Contact administrator. undefined 16:33:25 ERROR - Command error: (PL/SQL) - numeric or value error: character stringbuffer too small, details: undefined undefined

May I know the difference between GL Balance Analysis and GL Balance Analysis Basic? When I check both windows, the functionality looks the same.

HI, In Poland there are depreciations which can’t deducted from corporate taxation.Depreciation needs to be divided into Taxable and Not Taxable. Is it possible to create depreciation method which split the depreciation into two lines? Or is there other solution for that? On posting control there is set up Tax on FAP5. 

HI How should the payment methods and payment address ID be used when setting up supplier payment information? We have the situation that same supplier ID sometimes send the invoice in USD and sometimes in EUR and the payment should go to two different accounts. We have the same payment method for both USD and EUR payments (ISO20022). On the supplier you can set multiple electronic payment address id’s for same payment method. How should IFS know when to use the different ones in the payment order in the end? How is mapping between Address ID and currency to pay?  

Hi - I am working with the Accounts Payable team and am looking for the Preliminary Supplier Invoice entry screen that exists in Applications 9, it is this presentation object: frmManSuppInvPreliminary and it is found here, Financials\Supplier Invoice\Preliminary Supplier Invoice Does anyone know where this is in IFS Cloud 23R1 ?

Hi All,I have a requirement of Setting up a tax code for Malaysian company with bellow conditions. Appreciate advice on thisOn certain services supplied by foreign suppliers, a Malaysian company has to pay 6% imported services tax charge arises that is borne by the company itself and this tax amount is not charged by the supplier. Therefore does not include within the supplier liability.This charge cannot be reclaimed or offset against other amounts, and is treated as an additional expense. Thanks in Advance,

Hi all,   I have some doubts,self billing invoice types is used to create the invoice at the point of receiving goods?  duplicate invoices can be created using the manual supplier invoice? Thanks in advance, Louis 

Dear all,  Is there a way to create a netting between a customer and a supplier not linked by the association number ?  Thanks in advance,Louis

we have an existing lease for which we are trying to modify the Terms and Conditions.   The amount of the lease has changed for each month going forward and we are trying to modify the amount.  We first get an error saying we cannot modify it with an existing Amortization Schedule but cannot do anything with the Amortization Schedule since we have posted Proposals against it. Test scenario to Modify Existing LeaseGo to the Terms and Conditions tab RMB online and go to Terms and Conditions Change the Lease Amount Change go forward Amount and the remaining number of Lease Payments. > Click ok  Try to delete the current Schedule ID and get this

Any clue why it comes up like that, after this change (i.e. the enumeration related to Grouping)?  Note: The rest of the enumerations (unchanged) of concern are -  

We have a request from a client to produce tax reporting for a distribution site in another country. The site is not a legal entity.E.g. UK company (legal entity) has a distribution centre in the Netherlands which will be used to serve the local customers in NL. The distribution centre will be a tax establishment with an NL VAT number. The requirement is to capture the transaction for tax purposes in NL. What will be the best solution in IFS perspective, since the tax establishment is not a legal entity, where we can run tax reports?

Hi  I am trying to create a Swiss QR Code in IFS9, to do this I will use the standard one added in IFS10. However the one I can create in IFS10 looks a lot different then the examples you can generate online. Does anyone have experience with using the IFS QR Code - getting it to scan correctly? In the picture, the top one is from IFS. 

Which table or combination of tables would provide us with the best view to see the margin made on the sale of each individual serial?So far I cannot see a connection from the  INVENTORY_TRANSACTION_HIST2to CUSTOMER_ORDER_INV_JOINtoGEN_LED_VOUCHER_ROW_UNION_QRY That stays at a serial level.

Trying to remove the start of a column on a report but the beginning is variable length so I want to remove up to the first space found and I tried this vldtstr:strMid(tns:INVOICE_NO_PP_ID,vldstr:strScan(tns:INVOICE_NO_PP_ID,' ')+1,20) but i get an error - GENREPORTIO:Could not generate report:”TRANS_CONF_ERROR:Failed transforming report data: ‘Syntax error in ‘format:formatDateTime($date_2754,’MM/dd/yyyy’,’vldtstr:strMid(tns:INVOICE_NO_PP_ID,vldstr:strScan(tns:INVOICE_NO_PP_ID,' ')+1,20)’)’.”  Of course there is nothing in the column about formatDateTime so not sure where that came from - looked for missing apostrophe but nothing. I also used this in a column by itself and it works fine - vldstr:strScan(tns:INVOICE_NO_PP_ID,' ')+1 to return the position of the space. 

Hi,Is there a generic Tax Template to generate a simple csv or text file at the Print Definitive step in Tax Proposal?Thanks

Dear Friends,How Can I make the “reconciliation fields” tab mandatory on while opening a new customer card/for all, and how can I create a quick report for  customers showing missing fields for that tab. Thanks. Like Quote

I’m trying to create cash account, but system raised this error message“Not a valid IBAN account number.” please advise

Hi All.We use Apps 10 EE and are based in Australia (not that this should make a difference but apparently it does).We are trying to connect our ADP database, that we use for payroll,  with IFS.  The recommendation was to use a SFTP connection (by ADP). The project has ground to a halt and we are in the middle of a standoff  because IFS cannot provide public PGP key and ADP requires public PGP key to make the connection.This solution (ADP (ifs.com))  does not work, we are told,  because we are not based in the USA, which I find a little bit incredulous.  If anyone in the IFS community has anyone encountered this situation before and can provide guidance, it would be very much appreciated?

Hi, On Apps 10 UPD16  the system defined event CUSTOMER_PMT_RECEIVED is firing for customers when we have an unallocated payment on their account. When they have this payment, but prior to it being allocated, the sum of payment + outstanding orders > credit limit - so the corresponding action will fire. When the payment is allocated shortly after they are below the limit, but it has still fired. Has anyone else experienced this issue / found a way around it. 

Has anyone had experience of setting up/using  the ‘old’ Account Consolidation module?‘Consolidated Accounts’We’re in the process of configuring it and getting issues when attempting to transfer the Subsidiary  Company Balances across to the Parent Company. I.e. there is no RMB to do it!I can’t see anything in the on-line documentation but I wonder whether there is a ‘gotcha’ on the set-up? 

Hi, our client have request to distribute netting off of down payment of customer order proportionally with delivered amount (partial delivery).For example:Total Invoice:                1000Down Payment (40%):              400Invoice 1st Delivery (50%):     500Invoice 2nd Delivery (50%):     500Since customer order delivered twice (50% and 50%), down payment need to be netted off proportionally 50% for first invoice (50% * 400 = 200), and 50% for second invoice (50% * 400 = 200).At IFS Standard, since down payment amount (400) less than first invoice (500), all down payment amount will be netted off for first payment.Anyone ever has the same request? Should we make customization to fulfill this requirement?Many Thanks.. Heri Santosa

Hello,In which database table can i found the data “Customer Type” : Regards,Pierrick

Hi all,I have one question,When i do the capitalization of my cost and revenue, i don’t have the same amount when i look at my real cost in monitoring of the project and the real cost capitalised.So i don’t Know what is wrong?So can anyone help me for this? For your information, my project is not finalised.Thanks for your answer. 

Hi,Please can you help me with the Object Hold From Depreciation?We have a number of Objects set on Hold From Date, but no Until Date.  What is the best way to get these Objects off Hold and restart the depreciation from the current period?  We don’t want the depreciation to recalculate from when the Object was originally set to Hold.Will appreciate your help.Regards, Ivan  

Hi Team, We have Client which has its Branch/entities across globe and having one entity in India as well. the main head office/group company is in France.Do you foresee any requirement to have a dedicated Code Part for Local COA (Chart of accounts) for Indian Entity in addition to Code A which is for Group COA when we have global mapping to be done. Though this is more on Client business but any has any related expertise to guide on what can be good practice.