Finance (Financials)

4764 Topics

KellyW_AUSDo Gooder (Customer)

Hi This may be a simple one for some, but we don’t have a large knowledge base at our company for IFS system.We are a bit behind on version 8.Is there a way in the system where we can set it up so an Invoice is automatically emailed to a customer once the invoice is generated?All help is appreciated 😊

2322

2 years ago

Rashen WickramarathneSidekick (Employee)

asked in Finance (Financials)

Group Consolidation: Duplicate eliminations when matching within the same Account

This is created with reference to LCS case ID - G2298282When creating intercompany eliminations within group consolidation, if the Intercompany elimination rule specifies the same account to “Account From and Account To and Matching Account From and Matching Account To “then the eliminations posting rows are erroneously duplicated.As a workaround, if the elimination rule is not used, transactions will net off to the same account. But this will not create the difference to a separate account as when using intercompany elimination rule. Also, it will restrict the visibility of these intercompany balances in Intercompany Period Balance Analysis.Looking for a suggestion how this requirement of using the same account in inter company elimination is used by other customers.

1591

2 years ago

WiaPasanDSidekick (Partner)

asked in Finance (Financials)

What are the procedures to generate following reports in IFS Aurena Apps 10?

Hello! Could you please tell me the process of generating the following reports? (I am new to IFS Financials)1). Laser Check Printing Report2). Pro Forma Invoice Report (Not the Customer Order Pro Forma Invoice)3). Invoice Report Your kind support is highly appreciated!

560

2 years ago

DHCRADPASidekick (Customer)

asked in Finance (Financials)

Report to Other Customer and Offset

It looks like I cannot see the highlighted option in our APPS10 instance. Any special security settings required?

310

2 years ago

KaneDKSidekick (Customer)

asked in Finance (Financials)

Taxable Amount doubling?

We have some customers in CA that have a GST tax of 5%.We just did an invoice for 1080 CAD, but tax amount shows at 108 CAD (10% and not 5% as the tax code GST shows). Error was noticed on the Proforma Invoice, where it was showing: “Taxable Amount” = 1080 CAD and “Tax Amount” 108 CAD.To check it it was just a drop in system, we did complete the final invoice, but that now shows “Taxable Amount” 2160 CAD and “Tax Amount” 108 CAD (which is 5% of 2160, but order is only for 1080 CAD?). But “Sub Total” on the invoice shows correctly 1080 CAD, but “Tax” is back to 108 (10%)? Even on the Customer Order screen, we can see in the bottom of the page that Tax amount is calculated to 10% and not the 5% the tax code says: Anyone have any idea where this is going wrong or if we did something incorrect on the order and/or invoice? Thanks,Michael

894

2 years ago

joostartsDo Gooder (Customer)

asked in Finance (Financials)

SEPA payment per invoice

We use SEPA payment format. When we pay f.e. 3 invoices, these are paid in one amount to supplier. We want these invoices to be paid separately (so in 3 separate lines on the bank statement). Tried this with “batch booking” untagged, but payment is still done in one amount. How to setup so that payment is done in 3 lines?

660

2 years ago

spojstrawDo Gooder (Customer)

asked in Finance (Financials)

How to search for RMA's that are ReturnCompleted but not yet Credited

How can we setup a search in the RMA area that will show the RMA’s that are in the ReturnCompleted status but have not had the Credit issued yet?

562

2 years ago

old_lady_FSDo Gooder (Customer)

asked in Finance (Financials)

Financial Statement separation within one GL company

As a global company, we are trying to eliminate as many separate GL companies as possible but maintain the ability to separate out Financial Statements for Tax Reporting. Any suggested solutions on how to have two separate (views or actual) Financial Statement reporting options on one GL Company?

513

2 years ago

mbarnesDo Gooder (Customer)

asked in Finance (Financials)

Lobby Data Source issue

I am trying to create server columns in with case statements to bucket invoice aging with count.here is the sample of the code: count (case when aging = 1 then 1 end) "current", count (case when aging = 30 then 1 end) "30 Days", count (case when aging = 31 then 1 end) "31-60 Days", count (case when aging = 61 then 1 end) "61-90 Days", count (case when aging = 91 then 1 end) "90+ Days"After I enter the first two in the column section of the data source I get the following error when entering the third and trying to save.---------------------------Validation Error - IFS Applications---------------------------The names of columns 'COUNT(case when aging = 30 then 1 end)' and 'COUNT(case when aging = 31 then 1 end)' must be unique within the first 30 alphanumeric characters.---------------------------[OK] ---------------------------Any ideas how to get around this?

1237

2 years ago

RLGroenerDo Gooder (Partner)

asked in Finance (Financials)

How to level a CUPOA in USD with and invoice in EUR

Hello All,Can some tell me how you can match a CUPOA in USD with an invoice in EUR?The company currency is EUR:Customer invoice in EURPayment on account in USDFor a customer we got the following situation We want to match the invoice with the payment on Account. An offset is no option because of different currecncy.Is ther an other way? Regards,Raymond

1174

2 years ago

lisa.gilesABSidekick (Customer)

asked in Finance (Financials)

Privileges - Payment Proposal Delete

A user is getting this when trying to delete lines in the Supplier Payment Proposal:I cannot find where / how to grant this? I have looked through Presentation Objects and Database Objects but cannot find the specific tick box. I have granted ‘Delete’ options in Payment Proposals but User still cannot carry out the action. Thanks,

270

2 years ago

Luiz RSidekick (Partner)

asked in Finance (Financials)

Credit Instant Invoices

Hello, hope this message finds y’all safe and well.Is it possible to create and connect more than one Credit Instant Invoice for the same Instant Invoice?For example, if the Instant Invoice has 5 lines, and I need to create Credit Instant Invoices for two of the lines in different times. Thanks in advance

1431

2 years ago

XitLakshMSidekick (Partner)

asked in Finance (Financials)

Change Default Grouping Criteria in 'Acknowledge Supplier payment Orders'

Currently default grouping criteria is ‘payment date’ . Can this be defaulted to ‘Payment order ID’?

340

2 years ago

InesSidekick (Partner)

asked in Finance (Financials)

manual tax:not allowed to enter liability taxe date

Hi,I want to create manual supplier invoice with manual date taxe ( the tax liability control date see below have been set): on the invoice I’ve entered the tax and the manual taxe dateI have the error even and the set up is well done , see below Thanks a lot error: setup ok

602

2 years ago

nimesh

asked in Finance (Financials)

Crediting a Project Invoice

Hi,We have a correction invoice created on top of a project invoice but mistakenly released at 0 (Status is PaidPosted since 0 value). Requirement is to reverse the entire project invoice (project invoice is PostedAuth). So now we are unable to create a credit invoice on top of that project invoice since it prompts below error. This error can be recreated in any Apps10 internal Race environment. We are in UPD16.Could you please advise how can I credit the project invoice totally? Thank YouRegardsNimesh

1230

2 years ago

Tharindu NadeeshanSidekick (Employee)

asked in Finance (Financials)

Static Pool Request

Following information requested via case ID G2342017. An auditor asked the Finance department for some information. They in turn asked me, but I'm not sure where to find this data in IFS.The auditors want a "static pool" that shows (in a single file) all the company's invoiced sales, credit memos, adjustments, and payments (or any other activity). I thought initially they would want a dump of what's in Customer Analysis, but they want to see each individual payment and transaction. They mentioned that they'd want to see each transaction on another line - like, the invoice for 1000on the first line, a payment for 9000 on a second line, and then a 100 write-off on the third. Obviously, that's just an example. How can I pull this data for them? Does such a thing exist? Apparently they will be asking for this on a semi-monthly basis. I'm happy to pull this out of Oracle if possible, I just don't know where to find this info in IFS.

321

2 years ago

OlayoonuDo Gooder (Customer)

asked in Finance (Financials)

Importing Journal Entries into IFS 9

Can any one share template or how I can import Journal entries into IFS 9. I have a list of long journal entries I need to pass and it will be nice to have a way to import this into IFS 9 from Ms Excel

6965

2 years ago

RajKSidekick (Partner)

asked in Finance (Financials)

Can we create an excel migration job for uploading bulk invoices into Instant invoice screen?

Hi All, In Apps 9, can we create a migration job for bulk customer instant invoice upload? if possible please explain the process, as i tried with view names but it is not working. ThanksRaj

1050

2 years ago

ronhuHero (Customer)

asked in Finance (Financials)

Invoiced Purchase Order

Community,can anyone can advise what happened to this supplier invoice? why negative amount is showing up in window Invoiced Purchase Order? is that means the previous match is being cancelled? Thank you.

2754

2 years ago

IniNaadiJSidekick (Partner)

asked in Finance (Financials)

Project Invoice- ORA-20105: Invoice.ACCERROR1: Error (The difference in Accounting Currency for the Invoice 2022010001 has exceeded the limit 0) occurred while booking Invoice PJ-CR- 2022010001.

Hi All, I'm getting following error in the project invoice.ORA-20105: Invoice.ACCERROR1: Error (The difference in Accounting Currency for the Invoice 2022010001 has exceeded the limit 0) occurred while booking Invoice PJ-CR- 2022010001.Please refer the screenshots of the company settings for the accounting currency difference. Please advise on this regard ThanksNaadira

2261

2 years ago

NagarjunaDo Gooder (Partner)

asked in Finance (Financials)

External Supplier invoice load error

Hi Team, I am getting the below error while creating supplier invoices through the external supplier invoice assistance.but the same file I uploaded in the non production system its working fine. Please help. Regards,Na

712

2 years ago

LinkSuperhero (Customer)

asked in Finance (Financials)

Import salaries in IFS

Hi all,we want to import salaries to IFS. In our csv file the “currency credit amount” is negative. But after the import to IFS it is positive. Is that the standard way in IFS?And which external file template do you recommend for importing salaries?

1085

2 years ago

Sahani WimalaratnaDo Gooder (Employee)

asked in Finance (Financials)

Newly defined wage code parameter is not appearing in the Payslip

Hi,The customer has defined a new wage code parameter however, this is not appearing in the payslip. These are the steps followed by the customer:• Define wage code parameter • Defined new wade code class and added the posing control P12 which is connected to the account code.• Defined Wage code ID, RMB – Formulas and connected to wage code Parameter• Added wage code parameter to the Deductions Wage code. Are there additional steps required for the newly defined wage code to appear in the payslip. If so, can you kindly provide these? Many thanks!

590

2 years ago

SeWDo Gooder (Customer)

asked in Finance (Financials)

Set up start value in number series, project number series

Dear Community, we would like to set up the Finacial Project Numberseries like that:First Number HRL0000001, next number HRL0000002 etc.This is the set up in IFS It is not possible to start with leading 0000000, IFS is formatting it to 0. So if we create the first project with that number series it comes with HRL1 instead of HRL0000001. Of course we could set up series with HRL1000001, that would work. Question is it somehow possible to set up like requested with leading 0 values HRL0000001?Thanks!regardsSebastian

520

2 years ago

CBKLeasureDo Gooder (Partner)

asked in Finance (Financials)

Currency Revaluation - Income Statement

I have a client that would like to perfom the currency revaluation on their Income Statement accounts using an average rate for the month. They plan to only enter rates once per month at the end of each month. I created a new currency rate type (calling it average) that I was going to use for these accounts. However, It appears that only Assets and Liability accounts can be revalued in the Accounting Currency (see below for message when entering a Cost account) I have explained that IFS captures the rate as of the transaction date so the revaluation of the income statement accounts would not be needed if rates are entered daily, but they prefer to use the method they currently use, which is converting the Income Statement using the average rate for the month. Has anyone run into this issue or have any suggestions?

2551

2 years ago

Page 109 / 191

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded