Finance (Financials)

4280 Topics

HIMK01Do Gooder (Partner)

Attribute added as modification gives error when try to get the entity set

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?

11 months ago

HousseinySidekick (Customer)

asked in Finance (Financials)

SQL query error when trying to reuse calculated field

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

11 months ago

CorBarbaLDo Gooder (Partner)

asked in Finance (Financials)

Entity Posting Control

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?

11 months ago

larasibDo Gooder (Partner)

asked in Finance (Financials)

Procurement Clause Types - Not Showing on Documents

For documents generated by IFS, you can assign certain Phrases per Document Type and that works very well. Now, there is also a new module 'procurement clause types' in which you can assign clauses per supplier, project, part, activity, ... So, I suspect that with this functionality, instead of determining a few clauses per document type, you can do this more specifically for all documents relating to a particular supplier/project/part, for example. Steps to take are:Create a procurement clause type. Create phrases linked to this clause type. Create clause connection rules, to determine when the clause should appear on a document.After trying all these steps, I don’t seem to manage to view the clause on the documents.Are there certain extra steps to undertake/settings to change for this module to work?

11 months ago

MishaelAklekerSidekick (Partner)

asked in Finance (Financials)

Authorization of Supplier Credit Invoices

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!

11 months ago

AsadanSidekick (Customer)

asked in Finance (Financials)

E- invoice with different tax code creating posting lines with wrong tax code

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

11 months ago

AsadanSidekick (Customer)

asked in Finance (Financials)

Not allowed to mix postings with and without line reference

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

11 months ago

NPGIFSJOMAIISidekick (Customer)

asked in Finance (Financials)

External supplier invoice load logic

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

11 months ago

Máté KubicsekSidekick (Customer)

asked in Finance (Financials)

How to add message to tax code / how to change it

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.

11 months ago

VALRHONDAVEEDo Gooder (Customer)

asked in Finance (Financials)

Multi-Company Voucher Entry Error in IFS10

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.

11 months ago

ilkertumkayaDo Gooder

asked in Finance (Financials)

Financial data map

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

11 months ago

Zuha SamsudeenHero (Partner)

asked in Finance (Financials)

Project cannot be completed until all active acquisition values referring to this project has been moved in IFS|Fixed Asset

We have a number of projects that we keep getting an error stating 'Project cannot be completed until all active acquisition values referring to this project has been moved in IFS|Fixed Asset.'The process to follow to get the error is:Go to Financials|Project Accounting|Project, then search for one of the projects, RMB and select Rollback Sub Project Completion. Complete the necessary fields on the window and click ok, this is when we then get the error.In Object Transactions Analysis window those objects/FA records are with object transaction value type as "Acquisition" and status as "Ready". Please guide to resolve the error above Best regardsZuha

11 months ago

HousseinySidekick (Customer)

asked in Finance (Financials)

How to retrieve SQL columns having API in SQL query

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

11 months ago

Peshala GamageHero (Employee)

asked in Finance (Financials)

Can we add fields to search?

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

11 months ago

IniVismiMDo Gooder (Partner)

asked in Finance (Financials)

Business Reporter-Sum of closing balance of previous month and Current month closing balance

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

11 months ago

Mohashin SohelDo Gooder

asked in Finance (Financials)

Custome Invoices With errors

We perform sales discount activities through Rebate. Our two rebate invoices for the month of December-2022 have Zero value. For this reason , the two invoices are not being complete. Shows printed status in invoice status and also shows in customer invoices with errors window. Even giving a warning at the time of month end process.

11 months ago

TTRACYSidekick (Customer)

asked in Finance (Financials)

Change CTX to CCD in payment file

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?

11 months ago

RajKSidekick (Partner)

asked in Finance (Financials)

M voucher with simulation (reversal) enabled not available in approve voucher screen

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

11 months ago

TecAlageSDo Gooder (Partner)

asked in Finance (Financials)

Project Accounting: Stop Reversal of Revenue Recongination Voucher

Hi Team,Good Day!!Can you any one guide is there any provision is available in IFS to stop reversal entries of revenue recognition entries in next month when use project type ‘Period Capitalization/ Revenue Recognition’

11 months ago

clilouiseDo Gooder (Customer)

asked in Finance (Financials)

Posting Control M1 error

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.

11 months ago

PVermeulenDo Gooder (Partner)

asked in Finance (Financials)

non-supplier payment using SEPA or ISO20022

Hi,Implementation in France, customer wants to create a non-supplier payment to be included in SEPA or ISO2022 payment proposal.In “external payment recipient” it is not possible to sect either one of the payment methods, only the Polish ones as well as BACS. In APP10, the option ISO20022 is included as well. What about the cloud ?Customer is using 22R2 SU6. Please advise. What alternative can be recommended if option SEPA and ISO20022 is not included in non-supplier payment in version 22R2 Thx, Patrick

11 months ago

TecAlageSDo Gooder (Partner)

asked in Finance (Financials)

Tax Liability Date

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?

11 months ago

fmakumiDo Gooder (Customer)

asked in Finance (Financials)

Overide Slicer in Business Reporter

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.

11 months ago

Mourad KallaliDo Gooder (Employee)

asked in Finance (Financials)

Use of BPA for station breakdown structure (Sales)

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.

11 months ago

HananeSidekick

asked in Finance (Financials)

control Approval process

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

11 months ago

Page 49 / 172

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded