Finance (Financials)

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 user group for the period M, then the transaction should be applied on period M+1 Remark : in t

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?  

We have an organization position that’s used in a matrix organization structure for two companies which is not used. There are no employees assigned to this position.When trying to delete it, the error ‘The Company Position ":P1" is used by another object/s.’ is displayed and when checking the business logic, I can see that there is a record in business_unit_relation_tab which is preventing the deletion and popping up of the said error.I’m struggling to remove this from the application as I can’t find a window from where to access business_unit_relation_tab record. Is there any documentation on how to delete an unnecessary organization position? Or someone who has done this before? I couldn’t find anything relevant in the F1 Help.TIA

A user created a parked payment which we are now trying to correct and move it to a customers account.  We have not used this feature before and not sure how to do this.  Does anyone have experience with these transactions to provide guidance on how to accomplish this?    We think she somehow created it by unmatching a payment she incorrectly entered.  Mixed payment form right click canceled matching.Essentially we would like it all cancelled so it can be reentered however would settle for it being moved to the customer’s account.Thank you! 

Higood day;i need a supplier report to display the supplier payable , GRN balance , Advanced Balance, Net Balancefor each supplier.is it available in the system or not ?if not  what is the required sql statement ?we are using IFS9.Thanks in advance. 

We would like to recognize purchase price variance on receipt of inventory vs when an invoice is processed.  Is it possible to do this?  Is there an associated posting control that we can setup to help us with this?