Finance (Financials)

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 So how do I modify this Lease for the go-forward months?

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. 

Hi team, Is there a standard method for indicating which party will pay the bank charges when creating the supplier payment proposal (each party pays its own commission, the supplier pays the commission or the company pays the charges)?Thanks in advance

Hi Colleagues, Has anyone implemented TT - Transfer using (any) Payment Method/Payment Format available in IFS Standard? I got a requirement to have a Payment Method as “TT”. Any guidance is much appreciated Thank You

Hi,Is there a way to restrict creating Manual Supplier Invoice for specific type of suppliers using standard functionality?ThanksGaya 

The user groups are closed but the period status on the period is grey for both “Close Period” and “Close Period Finally”  There are no vouchers in the GL holding table to post for this year and nothing shows in “Validation Transactions in Progress”. We have rerun “Distribution and Manufacturing Voucher Transfer” and it shows nothing. If I reopen the period above the one I am trying to close it will not allow me to close by means of a right click on period status. It is also greyed out. At a loss. Please advise. Thanks! 

We struggle with invoices that are rounded up or down to nearest NOK .  The rounding creates tax deviation… are the any accounting rules to be set up to handle these small but irritating deviations ?Today we must add a new posting line with tax code 0 .. and the small rounding amount..  How can this be handled easier… 

Can anyone explain how to approve a budget and load the budget version in the IFS cloud? I found that IFS Cloud removed the budget process and replaced it with business planning. I know that in business planning there is an approval process, but I don’t know how to load an approved budget into the budget version. Thank you,