Finance (Financials)

Hi,We are trying to create a report for identifying the Latest Ship Date of a inventory part. This is to identify the parts that are not sold/shipped for certain time period and making allowance for those.We try to get this from the Inventory Transaction History. But, due to volume of transactions this is very slow. Is there a any other way to identify the Latest Ship Date of a inventory part? may be a view or method call?ThanksGayan

Hi, I can not find a TAX template for Denmark. Has eny of you any ide about this? 

Hi,Is there a way to extract these ‘report generator’ reports to Excel? Any workaround like use of the results key may be? Please advise.Thank YouRegardsNimesh

Hi,We recently figured out that for couple of Fixed Asset Objects Accumulated Depreciation amounts in Parallel Currency are wrong. Appreciate if you could help or guide us how to fix the accumulated depreciation figures only for the Parallel Currency. For e.g. This is one of our FA object. IFS Version: App10 latest update.  

 We went live in with APPS 10 in Sept 2021 and our year end if 31st Dec.We want to close 2021 and transfer balances to 2022, We have followed the process to do preliminary Year end, clear cost/revenue, followed another Preliminary year end. Question 1We can see that the balance are transferred to  2022, when we run GL Bal analysis, but when we go in GL Voucher row analysis we cannot see the opening balances, we were informed that is due to the fact we have not done Final Year end Process.  How can we view opening balances in GL voucher row analysis. We tried to do the Final Year end, but we got error message , (please see below).  Question 2If we do final year end can we re-open the year again and post the final tax journals.As there was no opening balance 2021, we cannot understand the message below.Can you please help and advise. 

When i create a tax proposal and run the preliminary report, the printout shows a tax year of 2022.  I use date for the Period/Date Range. But the print out shows 2022 How can i fix this?  

Hi , Can I add a one of invoices to a mixed payment as an attachment

Hi, Why isn't the invoice showing up in the posting proposal window for  " I'm the next authorizer"  screen for the substitute authorizer?The following basic data has been set up.  Has logged in by the substitute user id: alain

I am creating a new payment proposal for payment method of ‘check’, acknowledging the payment proposal and creating the payment order. I go to the Supplier Payment Orders window and RMB to select create check paymentclick ok in the “Print and Create Check Payment popup windowclick ok in the Check Payment Details popup windowbut as soon as I do, the record is cleared from the Supplier Payment Orders window.The Report Format  & Output window appears and I can preview my check before printing but I can’t cancel….the check is already processed.  Is this intended functionality.   Why can’t I ‘Cancel’?   See attached document

Try to delete a site immediately after been created. Error appears "The Company site xxx is used by 1 rows in another object (Site)." This is impossible since the newly created site is not used for anything. Please try to replicate the example and look into the issue.

HiWhen i Create an event action with the type of email, can I define an image or define a png file as a logo in the body text? 

Hi I tried to create the preliminary year end and i get the following error message I checked the authority class and my user has full access. I also checked the period 2021 and 2022 and all the periodes are still open. Period 0 and 13 exists for both year. I can also create the premliminary year end for 2022 and 2023 but just not for this year any idea how to solve this issue? Best RegardSophal

There is a supplier invoice with several rows that are to be posted to different code combinations with different authorizers.Should it not be possible to authorize your own cost postings in the Posting Proposal window without having to wait for all other invoice recipients to post their costs? 

Hi,I’m trying to cancel and create invoice (we suspect a manual allocation on the posting proposal is causing an entry on or Work Order WIP report) from the Manual Supplier Invoice screen but getting the below message when we try to cancel.“Reported Cost value for 2816 should be a positive value” - This, I know, relates to the WO. Any suggestions on how to fix.  Thanks as always, Matt 

we are using IFS9what is the required steps to  close the revenue/ cost accounts and transfer the balances to the next year.examplethe auditors already reviewed 2020 and i closed the accounting periods from 0 to 12.0 in the opening balance which transferred from the previous year. what is the required steps one by one 

Hello, I have set up WSC company in DEV with CAD currency and USD parallel currency.  Would this cause any problems if we want to consolidate this company into Carrix or C-FRS which uses USD currency?   

Does anyone have a SQL statement for the Customer Payment Check for the Laser Check.   We have a Crystal report that is only considering Supplier Payments.   I can get the check to print out on the IFS Standard Report so trying to figure out why the Crystal report is not printing the Customer Repayment Check.  The IFS Standard report looks like it uses tables Supplier_Checks, Suppplier_Check_Items, Supplier_Check_ItemHere is our Crystal Report SQL Statement. SELECT "SUPPLIER_CHECK_TRANSACTIONS_"."PAYMENT_AMOUNT", "SUPPLIER_CHECK_TRANSACTIONS_"."DISC_AMOUNT", "SUPPLIER_CHECK_TRANSACTIONS_"."FULL_AMOUNT", "SUPPLIER_CHECK_TRANSACTIONS_"."CHECK_AMOUNT", "LEDGER_ITEM_SU_QRY_"."VOUCHER_NO", "SUPPLIER_CHECK_TRANSACTIONS_"."SUPPLIER_NAME", "ADDRESS_DEFINITION_V2_"."ADDRESS", "SUPPLIER_CHECK_TRANSACTIONS_"."PAY_DATE", "SUPPLIER_CHECK_TRANSACTIONS_"."CURRENCY", "LASER_PRINT_CHECK_REP_"."CHECK_NO", "LASER_PRINT_CHECK_REP_"."RESULT_KEY", "SUPPLIER_INFO_ADDRESS_PAY_LOV_"."DEF_ADDRE

Hi Team,I want to convert a Manual Supplier Invoice into pdf format. But unlike, Customer Invoice there is no Print option available for printing it. Request you to please guide me regarding this. Best Regards,Rakesh

My client needs to create objects for already depreciated assets and show in the GL which has zero value. How can do this? 

Dearsthe auditors want us to close 2021 and transfer the balances to 2022i already closed all accounting periods;what is the next steps. 

Hi community,We have requirement where some invoices are due on a specific date of the year. Eg- 31.05.2022. Is there a way to to set a specific date in the Payment Terms.Thanks

Hi The customer wants to distinguish the imported supplier invoices by the person who scanned the invoice. Now i was looking for a field in IFS on the external supplier invoice and i came accross the following Field (Our Reference) Now i checked the mapping and used the BuyercontacPerson Name This is how the xml TAG looks like now When i check now the external supplier invoice i dont see the value in our reference field (see first printscreen). Any Idea what the correct TAG is named or is there any other field i can use in ord

I want to write test cases as per requirement related to tolerance limit which is set in company screen.can you please help me to suggest how to check basic data setup for the same.  

We have noticed that the Notify me functionality creates A LOT of background jobs. Since some of the background jobs takes minutes to execute it causes delays of other background jobs - to the extent that nightly jobs are running one day too late.  Workaround for now: Remove all background jobs regarding Notify me and disable the events with a description starting with Notify Me.  However, if we want to start using the Notify Me app we can’t use it in the current state.  Observations: Notify Me - Register Supplier Invoice notifications. - sometimes takes 5 minutesNotify Me - Refresh Markdowns for Supplier Invoice. - sometimes takes 10 minutes We don’t have a lot of invoices but still these background jobs cause hours of delays in the Default background queue.  Request 1: Will IFS tune the performance of the mentioned background jobs? With the current performance I can’t understand how any cust

Hi,few sales invoices/credit notes raised for US customers went to the tax transaction wrong way round (postings to GL are correct) and required manual adjustment before VAT submission. Cannot work out the reason. It happened to few invoices under different customers (but it does not apply to all invoices under one customer). I’ve tried to find any sort of pattern (by customer, by type of the invoice etc.), but failed. Did someone have similar issue?