Finance (Financials)

Is there any Basic Data Template available for Financials. Kindly let me know.  

Hi,Does any one has experience with handling JPK (SAF-T)/VAT Reporting for a Foreign Company Registered for Tax in Poland?For example, a company in Norway is registered for Tax in Poland (May be due to triangular trade). And Norwegian Company need to report JPK in Poland.The issue is that the Tax Templates Field Control available for Poland is Country Specific and there those cannot be enable for another country (with standard solution)

Dear community, I have a quick question on the amortisation/prepayment process in IFS. Take this scenario, we pay a supplier for something in period 1 for $1,00,000 and then we wanted a recurring journal to amortise the costs over 5 years, we have been told that this requires the accounting periods to be open or something similar to be able to do this? Does anyone know how you might set up recurring journals or similar, or can you point me in the right direction of any documentation that might help? Thanks, David

Dear colleagues,IFS Applications 8 Installation.We are a UK Fast Moving Food Manufacturing Company who export and import raw materials/finished products.  We are in the final stages of Brexit readiness and have hit a stumbling block with regard to Purchase Charges (import/duty fees).A number of the inventory parts for which we require charges to be recognised at the time of receipt of the inventory are standard costed parts.Please can you advise whether there is anyway the charge can be receipted to a goods received not invoiced account at the time the inventory is received for a standard costed part?If needs be we can set up a separate GL account where the charge can go to if it can not be distributed as part of the inventory part (due to the inventory part being standard costed) however we would still like to be able to recognise a liability for the charge at the point of receiving the inventory, so using either posting control M189/M187 or a new

We would prefer to have same customer only setup once and then to be used by all companies we have on IFS. Problem is the Order tab, where salesperson and currency can not be differentiated by company. Anyone having experience of using same single customer or do you enter same customer several times?

Dear all, At the creation of a Project invoice ( Project management → Invoicing → Create Project Invoice)We see that the wrong customer No was used.What's the best practice to correct this? Tryed to go the the transaction and then RMB → Set customerInformation message: Some of the rows you marked are invoiced or tranferred. No change will be done.Al rows have a Tranasaction Source M C P RHas anyone an idea?Regards Raymond

Hi,Can someone tell me how I can change the currency rates for the part cost.At this moment the part cost is calculated based on the current rate but I want to calculate it on a standard rate which is fixed for one year. Thank you. 

Does anyone know what drives what appears in the Receipt Reference field on an External Supplier Invoice Line info screen»  In our inter-company examples, it doesn’t appear to be any of the Receipt References entered when the POs were booked in. Thanks!  

Hi,We are having an issue when printing customer invoices.Here are the steps:Go to customer invoice screen. RMB Header → Reprint Modified Select Invoice Original and click ok. ​​​For ouput: select send email and enter address. Click OK.When this is completed, it send the invoice to the email address that you entered. The subject of that email is “PDF file for invoice report for result key xxxxxx is ready.” with a pdf attachement of the invoice. It also fires off PDF_REPORT_CREATED and sends a copy of the invoice to the customer contact. Is there a way to stop PDF_REPORT_CREATED from firing? We just installed UPD9, I think this may be related to that. I don’t believe this was happening before. Thanks for your help,Mike  

In Apps 10 - How can I define the ageing buckets in Customer Credit Analysis adn show these as the headers (rather than bucket 1, 2, 3 etc)

IFS 9 Update 14When attempting to create a project forecast, error message is displayed about currency errors.An initial forecast was created in November but, the next attempt at end of Dec. failed with this msg.  Project Management > Budgeting and Forecasting > Analysis > Project Currency Errors   contains:  

Morning,We are using IFS Apps 8 and trying to understand how and where the Tax code on the Project Invoice Lines is pulled from within the system. We are looking to setup new Tax code for use within projects, however the old/original tax code continues to be pulled in when project invoices are created from Invoicing Plans.We can’t see anything at Project level likewise we have checked the customer setup (inc Addresses) with no joy.Any guidance would be appreciatedThanks

How to handle the following warning when you set account to “currency balance” = yes when this account already has postings:“Account xxx already has balances in internal/general ledger. Manual adjustement might be necessary in order to get the currency balances to correspond to the accounting /parallel currency balances. Do you want to continue?” How to make the required “manual adjustements” in order th have this account properly revaluated ? 

hi,Case description:- user group = only one user group is linked to voucher type 0 wich is the voucher type for arrivals registration. We called this user group OR.- closing period for the user group OR the 28th of the month M- user Xx is connected to user group OR => the user Xx is trying to register PO arrivals the 29th of the month M while the period is already closed for the user group OR Question : how the standard should work ? Actually, we got an error message when we run the purchase transaction transfer because the period for the user group OR is closedBUT if I run the purchase transaction transfer with IFSAPP user for exemple (or an onther user with more rights…), and if this user is connected to user group AC and I add user group AC in voucher type 0, then the PO arrivals is transfered with an applied date (accounting date) on 28th of the month M What I except is if I close the u

We rarely use retention in sales contracts, but have recently done so, and in a recent claim via AFP, found that the system had calculated retention on lines that had already been 100% claimed.  Overall the number works, but for the individual lines, it is not correct.  I cant send that data to the customer.Can anyone explain this process to me?  please? 

IN APPS 7 we had a set up that an invoice couldn’t be registered if the PO was raised in a different entity.  However in APPS10 we can currently log an invoice with a PO from different entity and only get an error when trying to finally post How can we set up that IFS will warn/reject invoice before being registered?

In Apps8 environment trying to run a report for an annual audit to show all financial transactions from Oct to Dec 2020. The report path is Operational Reporting > Order Report > General Ledger Report With Counter Account. Running the report is very slow, and November could not be run successfully even after waiting 3 hours with the process running in the backgrounds. There is another way to run an excel based download of all journals through the “GL Voucher Analysis” function. This returned 102,237 records which took about 4 hours to extract to excel, but  that excel file only has 100,000 rows of data implying some are missing due to output channels maximum no of row limitation. Can you advise the best , most efficient way to get these reports run for auditing?

Dear reader,With Posting Type M100 and Control type C58 you can set codeparts to ‘mandatory preposting for Purchase Requisitions (PR). This is useful for manually entered Purchase Requisitions. However it is not wanted on PR’s on for instance Shop Orders (Ship WIP to Supplier).Unfortunately with this setting also the PR at Ship WIP to Supplier must be preposted first before you can proceed.Is there a way to avoid this? I have thought of excluding ‘system-defined’ Requisitioners (the PR for ship WIP to supplier is created with system-defined requisitioner SO). But of course other ideas are welcome.thx!regards,Martin BroekmanFinance Consultant at Eqeep (Netherlands)

Is there a reason why we would not b able to see a customer in the Customer Credit Analysis report? Have populated this screen and we have a customer who doesn’t appear, is there something that needs added to their set up?

Can I create Income Statement Based on Code part in Business Reporter. Client requirement is to create code part D as a profit center so they want P&L based on profit center for a month. Not sure how to set the logic.  

Hi, What’s the use of Internal Code Part Function? any example? Thanks!

Dear IFS Community. I am interested to know if it is possible to Calculate Fixed Asset depreciation based on usage. I.e. if we have a fixed asset that is an engine worth 500,000 can we depreciate it based on the amount of hours it has run. For example its life is 5000 hours so for each 100 hours it runs can we depreciate the fixed asset, rather than to a calendar as the usage is not linear in line with dates, Thanks, David. 

We have a situation where customers make payments for invoices, but as invoice amounts are the same they are incorrectly allocated.What is the correct functionality to use to modify allocated payments? The credit control team have been using customer payment roll back, but they are unable to do this when the bank reconciliation has marked the payment as ‘matched’.Any guidance appreciated, the workaround of putting on a 0 value payment we are using isn't the greatest.   

Is there anyway I can get the complete list of Standard Financial Reports (AR/AP/GL/Cash)  and some samples if possible?  

We are setting up an integration with Vertex O Cloud and they are using Company Code as they key to determine what environment it is coming from (TEST, PROD).   Since we copy our Prod Database to our Test environment we have the same company codes on our orders.     How are other people setting up their test environments to work with vertex?