Finance (Financials)

A new employee (AKA Me) created a credit invoice for a customer but accidently wiped out the Account number, so the invoice is in printed status but cannot post. We have tried everything we can think of but we cannot get this invoice corrected and out of Customer Invoices with Errors. Any suggestions are greatly appreciated.  

Hi, We are trying to set up CAMT in IFS, maybe anyone has some instruction or advise how the set up on customer part should look like? Thanks in advance!Ruta

I’m working on our segregation of duties set up and would like to limit who can see the payment information for suppliers (routing # & account #).  This looks like I would control it by controlling the View Payment_address.  When I add that to a functional area, I get way too many users show up as having access.  However, there doesn’t seem to be a report like the Object Security Report that will show me what permission sets are giving the users this access. 1 - Is there a report that will show what permission sets have access to a view?2 - Where do I find the View PAYMENT_ADDRESS so I can remove it from the permission set? Thanks in advance. 

Hello, I’m starting a roll-out in USA and I would like to know if there is something specific for USA to keep in mind ? It can be Finance related or any other module.I already found the US 1099 reporting in this community :) Thanks in advance for any input.Regards.Marijo

Why automatic authorization has been disabled when invoice lines were manually changed compared to purchase order values?Test steps:A purchase order is created for 10 items with the unit price set as 15 USD per item, creating a total value of 150 USD. The supplier invoice is for 1 item for 15 USD. The register arrival is done for 2 items for 15 USD each. When we use the "Match Invoices with New PO Receipts" the quantity has to be changed from 2 items to 1 item and this change is the reason leading to the manual authorization approval. (Automatic Invoice Posting Authorizers have been enabled through the routing rule) The system does not allow automatic authorization when the Invoice lines and posting lines have been changed compared to the purchase order values. Looking for any workaround for this scenario.

Hi,I have added a new text attribute called CLender to an entity in Cust layer and added it to an existing view by overtaking it because the projection entity set referred entity is fetching data through that view. When I query the view in plsql developer I can see the new attribute is added in the view.When I try to get the entity set via the URL,  I get the following ORA error.  I’m new to working in the customization layer. It would be great if someone can help me to resolve this issue. Am I missing any step here? 

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: Is the M1 posting control set up ok? I was trying to reconcile the fact that some accounts do not need the department and product while one account does need it. We tried with “can” for department and product for all the accounts 12xx in the M1 posting control but it did not help.  Any comments are welcome. 

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