Finance (Financials)

Hi IFS Community, How do you change e-mail address in PO? Thank you in advance.

ENVIRONMENT: IFS Cloud 21R2 AUDIENCE: All RESOLUTION/ANSWER:When creating a customer invoice from a work order where one of the invoice lines is negative, the postings from the customer invoice does not become correct. You get an error message saying that there is a difference in accounting currency even though there is not.  WORKAROUND: The only way to get the invoice to status PostedAuth is to set a very high invoice voucher difference amount on company, which creates a difference posting line.  Solution: The correction for the reported issue will be available with 22R1 SU8 CAUSE: N/AADDITIONAL INFORMATION: N/ASCRIPTS/LOGS: N/A SOURCE: Shehan Chandrasekara VERIFIED:

Is it possible to apply discounts on overdue supplier invoices ?

Hello all, Does anyone have experience setting up a company with multiple tax liabilities within the same country?  We have the scenario below for our facility in Quebec. The federal and provincial tax regimes each have their own registration number and we do not know how to correctly set this up in IFS. Trying to put both Tax ID numbers into the Tax Liability Countries does not work.  

Hi, Is there a way to partially release a customer order?  In particular, where a customer is approaching their credit limit, but we are happy to release partial goods/order lines to take a customer to , but stay within the given credit limit.  

Question for App 9SummaryWhen you have PO charge lines related to a specific PO line (via ‘Connect to Line’ & ‘Connect to Release’), is there any way to inherit some of the code part values from the line?Specific case:We use code part ‘C’ to define the WO number from Service&Maintenance. In this way, every WO related GL entry has the WO value in code part ‘C’ and we can analyze our accxoutn up to WO level. So far so good, but…The WO number is filled automatically on the PO lines created from requisitions in a workorder. When we need to define extra charges on the PO that are related to a specific line, we do this by using the ‘Connect to Line’ and ‘Connect to release’ fields. Unfortunately it seems there is no possibility to automatically inherit the value of code part C of the connected PO line to the charge.  Thanks for any advice on how to solve this issue ! Luc. 

How to exclude a disputed invoice of the reminder module? Can we use the “exception code” ?,  Thanks in advance

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