Finance (Financials)

This will include the questions related to Financials.

  • 3,013 Topics
  • 8,651 Replies

3013 Topics

T
Do Gooder
TodCDo Gooder
asked in Finance (Financials)

Customer Credit Limit/Blocking

Hello,We are using IFS Applications 10.We wish for the Credit Block functionality (via "Credit Limit" value on Customer:Credit Info tab) to consider only our Customer AR Balance (Unpaid Invoices) and not the sum of Customer's AR Balance + Total Value of Open Orders (i.e., Backlog Orders) when performing credit checks during Customer Order processing.Is this possible?   Thanks for the help!

0
T
Do Gooder
2 hours ago
R
Do Gooder (Customer)
RELAPOROSHINDo Gooder (Customer)
asked in Finance (Financials)

Block Orders Without Commissions Applied

In IFS, is there a way to block orders from being released if they do not have commissions applied to them?  Thank you for your help! 

1
Ieva Rituma
Superhero (Employee)
3 hours ago
S
Do Gooder (Employee)
suwklkDo Gooder (Employee)
asked in Finance (Financials)

We cannot change to a different Payment Method in the Payment Order screen when the Default Payment Method is defined in Manual Supplier Invoices

 Hi All,Core Environment – 22R1We encountered the below error while changing the payment method to a different payment method other than the default, in the Payment Order screen.Create a Manual Supplier Invoice and insert the default payment method in installment plan & discount. Run a new supplier payment proposal fetching all payment methods. Acknowledge the Proposal & Create the Payment Order. When creating the Payment Order, select a payment method other than the default which was set in step number 1.  When proceed to finish the option, It gives below error.Error - No Invoice/payment on account is selected into payment order. There are no items in the selected proposal(s) with the specified cash account.

1
12Guide_PaulB
Hero (Partner)
6 hours ago
WyrDavidB
Do Gooder (Partner)
WyrDavidBDo Gooder (Partner)
asked in Finance (Financials)

Invoice Work Flow - Posting Proposal - Data not found

Hi All,We have a customer with an intermittent issue when navigating from the final posting proposals (and posting proposals) overview screens to the actual posting proposal screen.From time to time, the navigating links access the correct page, but no data is returned. we get the same behaviour when using both the link in the headed when a row is selected, and when using the popup window shown (red arrows).There is no pattern, and we are unable to replicate on our machines. We understand only one user is effected. The same user tries to access the same record later in the day (or when screen sharing) and the problem does not occur.We have verified in each case that the data is available on the posting screen.We have also searched directly for the invoice_id using the advanced function on the posting proposal screen and this is returning data.We switched from Edge to Chrome and that appeared to fix the problem - but only for a short time.Clearing browser caches also appears to help, bu

0
WyrDavidB
Do Gooder (Partner)
8 hours ago
R
Do Gooder
Rich PDo Gooder
asked in Finance (Financials)

SEPA XML File

Hi, on Apps 10 when we  generate an supplier payment order using SEPA XML File where does the file go? We have specified a folder destination on the output directory of payment method per institute but we don’t get any file, we do for BACS. How or where to download the XML file? Does anyone else use SEPA and Lloyds bank? We are having issues with Lloyds processing the file….. Regards, Rich

5
R
Do Gooder
3 hours ago
A
Do Gooder (Customer)
AsadanDo Gooder (Customer)
asked in Finance (Financials)

Posting Type SP1 Tolerance Posting

Hi, I have question regarding Posting Type SP1 Tolerance Posting. Which scenario are creating posting line with SP1?  I have tested both Inventory part and Non inventory part within tolerance amount but the difference post has been posted as M-type, not SP1.   *We are using App 9*We have PO matchning on header/ref.level.*We are using Posting Proposal*Allow Tolerance check box is checked. Best regards,

1
T
Hero (Employee)
5 hours ago
hrdilshan
Sidekick (Employee)
hrdilshanSidekick (Employee)
asked in Finance (Financials)

Customer Invoice and Series ID Changed to “CD” but still in the “Preliminary” State

 We sent the Customer Invoice and Series ID Changed to “CD” but still in the “Preliminary” StateHow to Change it to Printed and Posted  

6
hrdilshan
Sidekick (Employee)
3 hours ago
Y
Sidekick (Partner)
yenSidekick (Partner)
asked in Finance (Financials)

Supplier invoice J voucher get reversed by K voucher

I cancelled an supplier invoice with J voucher by an K voucher.  However the K voucher not reflected in any of the Voucher (hold table or GL).  It causing i have distribution error unable to close accounting period.I found nowhere is the K voucher? Can shed some light on this?

1
Y
Sidekick (Partner)
13 hours ago
C
Do Gooder (Customer)
clilouiseDo Gooder (Customer)
asked in Finance (Financials)

Need to modify accounting year and periods

We are using IFSAPP10. A mistake was made when I created the company. The accounting year 2022 should have been defined has from 2021-05-01 to 2022-04-30 but was defined from 2022-05-01 to 2023-04-30.We have yet to make any transactions in this environment. How can I correct this?I have tried to change the year for each accounting period in the year but I get an error message:Where do I change the year opening period?How do I correct this mistake?

15
T
Hero (Employee)
2 hours ago
R
Do Gooder (Customer)
RELAPOROSHINDo Gooder (Customer)
asked in Finance (Financials)

GL Not Updating Automatically

Hello, Our GL is not updating automatically.  When checking the GL Voucher Rows Analysis, I see that we are missing dates. But when a user performs a manual ‘Update GL Voucher’, it then populates the the GL Voucher Rows Analysis with the previous dates that were missing right after the manual update date.  For example, were missing 3/20, 3/21 GL data in GL Voucher Rows Analysis. When performing a manual GL update on 3/22, it will then show the data for 3/20,3/21 in GL Voucher.  How can I have the GL update automatically?  We have a task scheduler that is suppose to update the GL automatically, but it is not doing its job. Why did it stop updating the GL automatically? Is it due to the accounting year not being updated to 2023? Or the USER ID not being updated to recent accounting users?  Thank you for the help!   

12
Ieva Rituma
Superhero (Employee)
1 day ago
Edoardo Fracassi
Do Gooder (Partner)
Edoardo FracassiDo Gooder (Partner)
asked in Finance (Financials)

Italian Proforma Invoice for Professional Supplier

Hello, I need to understand how to manage in IFS the payment of a Proforma Invoice for Professional Supplier.In Italy could be that a Professional send you a Proforma Invoice, which is basically an invoice that includes exactly all the mandatory elements of an ordinary invoice, with the only difference that it has an independent numbering and has no tax value. In order to receive from the Professional the invoice, I need before to pay it, after that he will send the invoice. Of course, at the begging of the flow there is a PO and I have to match it with the standard invoice that I will received from the Professional Supplier only after I pay the Proforma. Do you have any idea how can I manage it? Thank youEdoardo

2
M
Do Gooder (Employee)
1 day ago
R
Hero (Customer)
ronhuHero (Customer)
asked in Finance (Financials)

Missing Customer Invoice

Community, We have 3 customer orders show Invoiced/Closed, but cannot find the invoices anywhere in window Customer Invoice with Errors, as well as Customer Invoice Analysis. I have 2 questions, how to trace in the system to find the leads of the invoices?  if there is no way to find the invoices, how to recreate the customer invoices? basically we don’t want our AR ledger booked twice.Thank you.

9
R
Hero (Customer)
18 hours ago
G
Hero (Partner)
gumabsHero (Partner)
asked in Finance (Financials)

Offset Parked Supplier Payment

Hello community,I have issue with offseting parked payments.I have debit and credit parked payment and try to match using supplier offset proposal with option manual. When i try to select parked payments, says the currency code does not exist.  Version 22R2. Did anyone face this? I cannot see matching option for parked payments on Mixed Payment.Thanks  

2
G
Hero (Partner)
1 day ago
R
Hero (Customer)
ronhuHero (Customer)
asked in Finance (Financials)

Change Cash Account in Payment Order

Community, would like to know if it is possible to change the payment order cash account in below window? they are not acknowledged. Thank you. 

5
T
Hero (Employee)
1 day ago
AntOlivFr
Sidekick (Partner)
AntOlivFrSidekick (Partner)
posted in Finance (Financials)

Enhance Staged Billing to allow reversal

We have a number of customers who utilise staged billing and have found that once invoiced a staged billing line cannot be backed out and changed. This is surprisingly common in many industries and requires some very unusual workarounds and fudges. When an invoice is cancelled we think this should reset the staged billing line so it can be edited.

0
AntOlivFr
Sidekick (Partner)
2 days ago
R
Do Gooder (Customer)
RELAPOROSHINDo Gooder (Customer)
asked in Finance (Financials)

Error that the invoice address is invalid and to check the validity period

 In attempting to create an instant invoice, I am getting an error that the invoice address is invalid and to check the validity period. This occurs upon trying to save the invoice.  Does anyone have any information on this issue? Thank you!   

3
R
Do Gooder (Customer)
2 days ago
L
Do Gooder (Customer)
LKACHDo Gooder (Customer)
asked in Finance (Financials)

Indian Audit Trail (MCA)

Dear All,According to the Indian Ministry of Company Affairs (MCA) notification dated March 24, 2021 (Companies (Accounts) Amendment Rules, 2021), for the financial year beginning on or after April 1, 2021, every company that uses accounting software to maintain its books of account shall use only Accounting Software that has a feature of recording an - Audit Trail of each and every transaction,  Creating an edit log of each change made in books of account along with the date when such changes were made.  Ensuring that the audit trail cannot be disabled. The MCA has later announced that the above amendments will take effect on April 1, 2023, which suggests that accounting software used by businesses will have to comply with the Accounts Rules beginning in the financial year 2023-24. What is the solution in IFS Application regarding Audit Trail features as per MCA Mandate?Which transactions are considered for Audit Trail features?

1
T
Hero (Employee)
2 days ago
C
Do Gooder
cwarwickDo Gooder
asked in Finance (Financials)

All Levels Cost Calculation

Hi, Our SKUs have multiple levels, we have raw ingredients for one level, utilities for another, and then labour. I want to want ‘rollup’ a single sku, i can use the function “all level part cost calculation’, It’s now year end and i want to update utilities for every SKU we have, how do i do this reval calc on mass? Thanks 

1
T
Hero (Employee)
2 days ago
M
Do Gooder (Customer)
mwebersjeDo Gooder (Customer)
asked in Finance (Financials)

Business Reporter Data Select Sources

I do not think I can see all the Information Sources available in Business Reporter. We only see a few with + signs and when we open them I am not sure we are seeing all of the tables within those sources.Is there a list of all the sources available or is there a way to access all the sources? 

4
12Guide_PaulB
Hero (Partner)
2 days ago
Z
Do Gooder
ZOKMBLANCHETDo Gooder
asked in Finance (Financials)

ORA-20110 Inventory Part Cost Level must have value... Error at Aggregate Inventory Transactions per Period

The background job for ‘Aggregate Inventory Transactions per period’ fails with the error message: ‘ORA-20110 Inventory Part Cost Level must have value’.  There is no detail in the background job that tells me which parts are implicated in the error.  Does anyone know how I can determine which parts are causing the error?  The Cost Control for inventory parts on the site is weighted average valuation method with an inventory part cost level = ‘Cost per Condition’.  ThanksMichelle

2
T
Hero (Employee)
2 days ago
R
Sidekick (Partner)
RakeshSidekick (Partner)
asked in Finance (Financials)

Financial Reporting- Dual Trial Balances

Hi Team, Will IFS be able to support and accommodate the dual trail balances for GAAP vs IFRS reporting?If yes, how this can be done. Thank you in advance.Best Regards,Rakesh

2
R
Sidekick (Partner)
3 days ago
K
Do Gooder (Customer)
Karolina WowakDo Gooder (Customer)
asked in Finance (Financials)

External voucher for automatic tax postings with AP1/AP2

Hello.I’m wondering if there is any way to create external voucher and make use of automatic accounting rule AP1/AP2 for Tax Received/Tax Disbursed. When such voucher is created via Voucher Entry manually, it’s enough to insert 2 rows and additional 2 rows for default tax account are created automatically with the usage of AP1/AP2. Whereas external voucher is blocked by imbalance error.Maybe there is some way to insert the rows externally from .csv file to Voucher Entry and modify them there to use the effect of AP1/AP2. I tried Migration Job, but still the rows appear only in View Rows and not in Voucher Postings. Thank you in advance for your tips :)

0
K
Do Gooder (Customer)
3 days ago
A
Do Gooder (Customer)
ADVALLEDo Gooder (Customer)
asked in Finance (Financials)

IFS workflow

The company received a request of local audit firm in regards of current ERP. Do you know how can I get IFS ERP workflow by finance area (split by task and responsible)? I’m a Finance user so in case it won’t be allow to get that data. How could I ask it to IT team? Currently working with IFS v9. Thanks regards.

3
anbouk
Hero (Employee)
3 days ago
R
Sidekick (Customer)
ROXTOBBRISidekick (Customer)
asked in Finance (Financials)

Customer Bills of Exchange multiple invoices

Hi! We use Customer Bills of Exchange in Enterprise Explorer Apps 10. And when doing so we first create a Payment document proposal and in Customer BoE we then use the Create BoE from Payment Doc Id. That works perfectly because we can select multiple invoices at once as shown below.  When trying to do the same in Aurena we encounter some issues. In Aurena we do the same procedure with the payment proposal. But when we want to select multiple invoices it doesn’t work. We can only select one invoice at a time and that makes the process extremely time consuming.  Has anyone else encountered this issue? And even better, does anyone know a solution for this?  Best regards, Tobias

1
T
Hero (Employee)
3 days ago
S
Do Gooder (Customer)
SAXBBSOTDo Gooder (Customer)
asked in Finance (Financials)

Insufficient Privilege: Error when sending Data to external Application

Hi Community, To report tax for one of our companies we use an external Application. The Transfer of the data is done through a Custom Menu from the automatic Tax proposal. We face below error when executing the function with the permission set we set up for Finance Users. Everything works and we do not have the error when executing it with a Permission set dedigated to Company Admin Users.  For the moment we assigned that Permission set to the Finance users. However we want to avoid giving that many permissions to Non Admin users.  We can not figure out what permissions are missing. Anyone any ideas?Thanks in advance   Errpr Detail:Server error messages:eb6d8ccd-1676-4db5-b3e5-58be11cc76d5Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-01031: insufficient privilegesFailed executing query (ORA-01031: insufficient privileges)   at Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffe

2
T
Hero (Employee)
2 days ago

Badges

Show all badges
Terms & ConditionsCookie settings