Finance (Financials)

HiI got an error with the below  line in red when execute. Any clues please. select X.*,IFSAPP.SUB_PROJECT_API.Get_Description(x.PROJECT_ID, x.SUB_PROJECT_ID) Sub_Proj_Des,x.budget_base_curr/120 ITD_BUD,x.actual - ITD_BUD as  "Deviation",IFSAPP.ACTIVITY_API.Get_Description(X.ACTIVITY_SEQ) activity_des,IFSAPP.Project_Forecast_Item_API.Get_Project_Cost_Element_Desc(x.FORECAST_ID, x.PROJECT_COST_ELEMENT) cost_elm_desfromproject_forecast_item_all Xwhere project_id = '20062' and forecast_version_id = 'M1003' RegardsHousseiny 

HI I have a client who wants code part: Entity, to automatically post in the GL column when an order is invoiced, a PO is paid, when inventory has been received for Intercompany customers/suppliers. We have a pre-posting on the customer order and purchase order, so that a person will entry the Entity in pre-posting. The client does not want to do this. They want it to automatically populate when the intercompany customer or supplier is used.  Client solution: The one below is not working. They have a posting control IP2, with Code part Entity with IC2 type.  Inside the details, the intercompany group have detail specifications on customer group using AC4: country code.  Has anyone come across this situation?

Hello, Thank you for taking the time to read! I am helping a customer who is raises Supplier Credit Invoices. When they do this, they would like some sort of authorization on this to kick on the posting proposal. I have tried various combinations including putting maximum amounts of 0 and amending the priorities etc, but the rule is not kicking in.  Would there be any way to apply a rule to the credit invoices raised? Any guidance would be appreciated :) Thanks!  

Hi! We have e-invoice with PO having different tax codes. We have checked the check box “Affect line Postings” on External Supplier invoices line to see if posting lines are created per tax codes. As you can see in picture from Posting Proposal, the posting lines for tax code 1 and 0 were ok but the line with tax code L10 has got tax code 1.  The purchase order lines looks correct. Does anyone know how we can do so the tax code from PO lines should follow when posting lines is created automatically? We are using App9 and PO matching on header level. PO lines

Hi, We get following message when we try to add one extra line for other posting type than M18, in this case, we are trying to add charge  for PO without charge line but we get same error when we add currency differences post. Does anyone know why we get this massage?  We have App 9 and using PO matchning in head level.  Best regards,Asadan

Hello,We are receiveing standard IFS XML-invoices as external supplier invoices. Is there any documentation of the logic how an external invoice fil is created in IFS Cloud? We often get the question why is not this bank account included in the creation, why is this supplier not found in the creation. Why is this authorizer not found?Sometimes the value is supposed to come from the XML file, somtimes it is supposed to be retrieved from IFS. Can I find this logic somewhere? Kind regards,Johan

Hi IFS community, We would like to add a small message to the tax code so it would appear on the customer invoice which we create via Instant Invoice tab.How is it done? Please see the picture below to see what I am talking about. Thank you in advance. 

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,