Finance (Financials)

When entering a Multi-Company Voucher in IFS10, I get the following error:  This is a new process for us, so not certain what the issue is.  

Hi All, I am looking for table maps that are showing how financial recording is performed and kept in IFS. In other words, how can I find ledger and all financial data?In a similar way, is there a simple way of reaching to sales data as well. Thank you in advance. İlker  

Hi,    I am working on a SQL query related to  view PROJECT_FORECAST_ITEM_COST. When opening the project forecast, there is a SQL column address as “&AO.SUB_PROJECT_API.Get_Description(PROJECT_ID,SUB_PROJECT_ID)”. How do I include this column in my SQL query with PROJECT_FORECAST_ITEM_COST table?I would like to understand how API works in general as well when it comes to SQL queries.  Many thanksHousseiny

Hi Team, One of our customers had raised the following question through a case, please make sure the customer gets all the answers for the requested question.“In the window "IL Voucher Rows Analysis", the search function does not include fields Company or Ledger ID. Is it possible to add these fields as search conditions?” Best Regards,Peshala

Hi All,Can anyone support me on how  to get sum of last month closing balance and current month closing balance to one column in Business Reporter.Thank You 

We are working on setting up ACH payments with our bank, but they require that the CTX in the payment file be replaced with CCD.  Any ideas were I can do that? 

Dear Members,I have a question regarding reversal voucher, created a new manual voucher with simulation enabled for auto reversal but with status "Awaiting Approval” but when the user who has the rights to approve the vouchers, could not find them in approve vouchers window. He has to go to voucher entry screen to approve them. Is it limitation for simulation vouchers which will not appear on voucher approval screen?ThanksRaj

I have errors in “Distribution and Manufacturing Postings Analysis” linked to the posting control M1: “Value is missing for posting type M1 combined control type PCAG code part B in company 204.”Here is our setup for M1: Here is our setup for any of the 12xx accounts in the M1 control posting: And here is the setup for the 5550 account:

Hi Team,Can any one tell what is usage of Tax Liability Date in Tax Transactions screen. Whether it is used for  only identify the liability date or else any other purpose. If I change the Liability Date  for supplier invoice from Voucher Date to Invoice will that create any impact, because generally invoice date will be prior to the voucher date. For e.g. Voucher date 02/04/2023 but invoice date 31/03/2023 then our tax liability raise before we book the invoice in IFS.Hope you are getting my question? 

If user wants Q1 below to be populated when only Q2 option is selected on the slicer, how can this be achieved?Thank you in advance.

Hi all,Is there option to set up a BPA for station breakdown structure for sales parts as per below :The costing distribution of the material must be changeable for a sales order line. Distribution cannot be used as the basis for recording cost distribution on a sales order line. IFS does not offer this option. Therefore, the "default" distribution must be offered to the operators on the sales order line by another means, so that they can adjust, for the needs of this line, the default distribution: to do this, access to the analytical structure by a right click is available. After that an automatic allocation rule is created on this key, which is the identical image of the allocation entered by the user. Thank you.

Hello , I created an approval template to apply on customers , but anyone can detach it or delete it .How to prevent this from happening ?  Thank you in advance ,Hanane

Dear colleagues,  I have created a cash box following the next steps:Make a cash box ‘direct cash payment’, amount -500; manual post to account 6490, print cash receipt. Approve cash box and then realized I put the wrong amount and I select the line and click ‘cancel cash receipt.’Line status changed to ‘canceled’, but ending balance remain unchanged - I think this might be an error. Once you approve the cash box and the transaction is updated to GL, we can cancel only the transaction, but I think IFS is settled to show the actual balance with the last transaction, even if the transaction is cancelled.In this case the transaction should not be cancelled once the Cash box it’s approved and the Actual Balance should change.Could you please help me with some advice? You can find attach the cash box analysis with the error.

Hi all,Does anyone know how to exclude one specific warehouse in IFS in the accounting process of stock valuation ?My client has several warehouses in the system but for one of them is not sure about the ownership of the stocks, so they would like to remove it during the stock valuation process.If any ideas, I'll take them. ps : we are talking about apps10 (IEE)Thanks

Depreciation Distribution code part is not transfer value to GL code part. Can anyone pls suggest any solution for this issueDoes anyone share this depreciation logic document?  

Hi all,I am wandering if there is any possibility to Run Final invoice posting of several company at the same time.My client as centralised is accountancy service, and some of the accountant manage multiple companies.Thus I have set up multiple batch to run the final posting every night for each company, but in would be nice during the month closure to be able to trigger them all at once manually.  

Hi Team,I have created depreciation method selected method type as ‘Customized’.Specified Deprecation FactorWhen I execute ‘Create Depreciation Proposal’ no data is flowing in the proposal. In Depreciation proposal log I am getting following error. 

What impact does the language field have on a scheduled task? We have batch create customer invoice jobs for various companies.  Most have a default language of English, but we have one that is French(Canada).  The Language field is required, 

What is the difference between using ‘Acquisition value adjustment per book’ on the FA Object and changing the acquisition value through ‘change object value’ screen ?

Hello everyone, I am using IFS Cloud 22R2. We are using posting proposals.When i create a manual supplier invoice, and select the PO Reference list, all the PO are fetched even the ones that were completely matched/closed.Also, when i select a specific supplier, the POs that are displayed are not filtered with the supplier.Is it a bug or did it occur previously ? How to clean the POs that are already matched ?Thanks, Tarek.

Hi IFS Community,My issue is in APPS10 environment manual supplier invoices which are assigned to a cost center(although receipting is matched) invoices are still requires authorization in posting proposals. This issue only occurs when the MSI has cost center allocated. All the invoices that is related to this specific cost center requires manual handling. 

Hi all!!!I would like to apply a formatting to the the global context.Does anybody knows how to do that????Thus if I have a Price discrepancy the posting line would be in Red Thanks for helping!!!

Hiwe have an issue with customer offset approval - our user gets this error: voucher type (B) is not related to function group () For example this customer offset went succesfully via all approval process as you can see below:  However when our Credit control goes and try to approve this - they get the error message:  We have IFS APP 9.  Hopefully someone will be able to help.  Thank you Kind Regards Kate

HiCan the community help with the below error message?We have an output path defined for our EFT upload file process the file being created when using the RMB to Create Payment Order.This was originally setup for one company and we have no issues with the process/output.We are now required to send EFT payments out of a new company and are using the same Payment Methods per Institute (Output File Directory Output File Directory History) setup as the original company.However when we go to Create Payment Order this message appears indicating that the Output File Directories should be verified. Where should this verification take place in order to allow the creation of the Payment Order and upload file?Any information would be much appreciated.ThanksAlanS

Installing the MICR font for printing checks in the USA.When exporting the XML data from IFS to my pc and then open the check in Report Designer, the font seems OK, so issue is with the installation in the IFS database. The font is in the attached zipped file (GnuMICR.ttf). I have used the option to drag the font onto the Report Fonts page in IFS and the GnuMICR font appears in the list as described, but it is not applied when printing a check.