Finance (Financials)

This will include the questions related to Financials.

  • 4,285 Topics
  • 11,807 Replies

4285 Topics

J
Hero (Employee)
Janith BandaraHero (Employee)
asked in Finance (Financials)

Currency Rate Error

When performing "RMB: Execute Calculation" in Currency Revaluations Window, a Currency Rates error occurs.Error message: currency rate for USD is missing or has invalid time interval in currency type 1

2
Shanuka Lashan
Superhero (Employee)
1 year ago
N
Sidekick (Partner)
nimesh
asked in Finance (Financials)

What is the 'Retroactive Date'?

Hi,We acquired an object on 27/10/2022. We then changed the acquisition value by $10.00 on 27/11/2022.While doing so, we noticed “Retroactive Date” has become the same date of acquisition.Can someone please explain what is the purpose/effect of the ‘Retroactive Date’ on this object and  how it also affects on depreciations? Thank you!

2
N
Sidekick (Partner)
1 year ago
C
Sidekick (Customer)
craryitSidekick (Customer)
asked in Finance (Financials)

GL Balance Analysis - Budget -> Planning

Hello, We went from 9 to 10 recently. One of our users used to see a budget amount, difference, diff.(%) on the GL Balance Analysis screen. As far as I can tell, the name has now changed to planning. The problem we are having is that it’s completely blank though. Any ideas on what’s going on?   

2
MikeArbon
Hero (Customer)
1 year ago
I
Do Gooder (Partner)
IniVismiMDo Gooder (Partner)
asked in Finance (Financials)

Error-Currency Rate Type

Hi Community,I'm getting the below error in all the windows when I try to record a transaction. “The currency rate for parallel currency is not valid in the currency type 3 in the company xxxx”Currency rate type is setup in Normal and parallel currency as below. 

2
Dhananga Jayatilake
Hero (Employee)
1 year ago
S
Sidekick (Customer)
SMcLeesSidekick (Customer)
asked in Finance (Financials)

Saving a file to a secure folder

When creating a payment file, IFS currently outputs to a folder that our externals BACs program will upload and process. We are trying to secure this by making the folder location read only so that the file cannot be manipulated between IFS and BACs program.  However, when trying to create the file in IFS we now encounter an error because of the read only status of folder. Is there a way that IFs can send a file to a read only folder that we cannot manipulate?

2
S
Sidekick (Customer)
1 year ago
S
Hero (Employee)
Samuel JokinenHero (Employee)
asked in Finance (Financials)

Business planning - Currency rate type error

I have watched the IFS Business planning videos in academy and when trying to execute the planning rule for AR balances I get an error ‘’ The currency code GBP is not valid in the currency rate type 1 in company...’’I have checked that the GBP currency is valid in the currency type 1, and I have also updated the currency rates. Also, the same currency rates and type 1 is used for the business plan that I’m using. See attachments for more info.

2
S
Hero (Employee)
1 year ago
M
Sidekick (Partner)
MelTanyaSSidekick (Partner)
asked in Finance (Financials)

Sales charge type added on customer order

Hello,  I created a sales charge type and group (type is linked to group) and tried to add this charge type on customer order (in the “charge” section) but the list of all charge types I created does not appear. The site of the charge type is the same on which customer order is created.Does anyone know if there are some basic data, or toggle to check to make it work?  Thanks

2
M
Sidekick (Partner)
1 year ago
B
Sidekick (Partner)
BRSASidekick (Partner)
asked in Finance (Financials)

Cost Center as logical Code Part in Define Code String

HiThere is an option in the Define Code string view to select Cost Center as logical Code Part.Can somebody explain the advantage and posibilities of using this functionality ?   

2
T
Superhero (Employee)
1 year ago
C
Sidekick (Partner)
Christophe BUSSISidekick (Partner)
asked in Finance (Financials)

SEPA XML File download

Hi, on 21R2 (Managed Cloud) we generate an supplier payment order, IFS generate a SEPA XML File that we need to send to bank. How or where to donwload the XML file  ?Regards, Christophe

2
Link
Superhero (Customer)
1 year ago
M
Sidekick (Customer)
mlcscottonnSidekick (Customer)
asked in Finance (Financials)

Payment Addresses ISO20022

We recently had an issue when uploading the xml file to our bank that is generated through the BACS run, where some one had accidentally added too many numbers to the account number.Looking at the payment address on the supplier record I can see the creditor account and clearing system member id field is not limited to 8 & 6 characters, is there a way of doing this or will it be a matter of creating an custom event to stop the user inputting more than 8 & 6 characters for these fields? 

2
Link
Superhero (Customer)
1 year ago
M
Sidekick (Partner)
MonaLSidekick (Partner)
asked in Finance (Financials)

Lease Accounting

Hi There Can I get some help/Guidance with the below error on Voucher entry screen:  “Cannot find FA year and FA period for event date 10-JAN-23. Please check the Depreciation Calendar.”  The FA DEP Calendar exists in IFS 

2
M
Sidekick (Partner)
1 year ago
M
Do Gooder (Customer)
MOUDARSECHEDo Gooder (Customer)
asked in Finance (Financials)

projection GLBalanceAnalysisHandling error

Hello, We are having a problem with a projection GLBalanceAnalysisHandling here is the error message can someone help me, I checked the rights and everything seems to be working fine,the error wtih postam : {    "error": {        "code": "DATABASE_ERROR",        "message": "Database error occurred. Contact administrator.",        "details": [            {                "code": 903,                "message": "ORA-00903: invalid table name"            }        ]    }}

2
K
Do Gooder (Customer)
4 months ago
Sadeepa Gamlath
Do Gooder (Partner)
Sadeepa GamlathDo Gooder (Partner)
asked in Finance (Financials)

Tax implications related to drop shipments (IPD)

Hi Everyone,I have a customer who use direct deliveries to ship goods to the end customer and there are tax implications related to drop shipments.Customer has two different legal entities in Netherland (NL) and Canada (CA). External customer place the order in NL legal entity and customer order created in same site.User creates one customer order in NL site as follows,Issue: As per the taxation rules, we can only tax for the CO line 01 thus it is inventory movement between EU or same country. Line # 2 and 3 should be exempt from the tax.  But in IFS tax rules triggered based on the Supply Country on header level.  Expected tax resultsIs there a way to trigger the tax codes based on the IPD delivery site or based on the CO line level? Below functionalities tested and could not get the expected resultsIPD setup in customer master Tax classThanks, Sadeepa

2
Sadeepa Gamlath
Do Gooder (Partner)
1 year ago
S
Do Gooder (Customer)
sestojansDo Gooder (Customer)
asked in Finance (Financials)

Find correct operational report

HiOne of our new permission sets is lacking an operational report needed to reprint an invoice.  Once we click ok in Step 2, we get the error message “You are not allowed to execute the Report”, but I don’t know which report we are missing. Is there a way to ascertain which report I need to add to the permission set to make it work? Step 1: Click “Reprint Modified” Step 2: Click OK Result:  

2
K
Hero (Partner)
1 year ago
H
Do Gooder (Customer)
hketDo Gooder (Customer)
asked in Finance (Financials)

Error while printing final invoice for customer order with paid advance invoice

Hello, I have made an advance invoice for customer order and the advance is paid. When I try to make the final invoice for the order, I get this error message.We are running IFS APP 10 UPD 8. I read from another case “Error message during printing an instant invoice”, which also had something to do with advance invoice, that there might be a bug in UPD8 (151458). Is this a totally different case? Any solution? 

2
H
Do Gooder (Customer)
1 year ago
G
Do Gooder (Customer)
gcraig22Do Gooder (Customer)
asked in Finance (Financials)

AR Adjustments

I need instructions on how to do AR adjustments without going through mixed payments. I have invoices that were short paid or just bad invoices that need to be adjusted off, but not necessarily bad debt. Billing errors, etc.  

2
T
Superhero (Employee)
1 year ago
M
Sidekick (Partner)
MonaLSidekick (Partner)
asked in Finance (Financials)

Lease accounting

Hi ThereCompliments of the season!can lease accounting in IFS APPS10 be used on the following conditions.• A lease contract over a period of example 10 years with an annual payment and not monthly payments • A lease contract of example 5 years with the lease installment paid in advance in the beginning of the contract." Thank YouMona

2
M
Sidekick (Partner)
1 year ago
J
Do Gooder (Customer)
joehrleinDo Gooder (Customer)
asked in Finance (Financials)

Customer Credit Management - DSO

What date range is used for the DSO calculation in Customer Credit Management? This feature seems useful to us but we need to know the basis for the number. We did find the formula in the help file, but it doesn’t specify any date range.

2
J
Do Gooder (Customer)
1 year ago
R
Do Gooder (Customer)
reimccabeDo Gooder (Customer)
asked in Finance (Financials)

Undoing write-off supplier invoice

Hello, we have a situation where our AP group entered some write-off supplier invoices in error.  Their practice is to enter manual invoices that net to 0 and they are in state PaidPosted in closed accounting periods.  They would now like to undo those invoices and enter new ones for payment.  I am aware of supplier payment rollbacks, but I’m assuming that method wouldn’t work with a 0 value invoice since no payment was generated.  Is it possible to undo these invoices and enable the receipts to be matched normally?  Also, is there a better method of doing write-offs?   Thanks.

2
R
Do Gooder (Customer)
1 year ago
N
Sidekick (Partner)
NecQianqWSidekick (Partner)
posted in Finance (Financials)

When part(Inventory Valuation Method = Weighted Average) procure both from PO and PJ, the value is calculate incorrect.

When buy 1 part from PJ as 120 yen.And then buy 2 pieces as 100 yen for one, transfer two to PJ.The Project Analysis window shows debit balance as 333 yen and inventory is 0.Which is incorrect because the true value is 320(120+100*2).Also this is not correct in accounting.(diff 13)Please consider improving the funtion.

2
N
Sidekick (Partner)
1 year ago
J
Do Gooder (Employee)
Janani MunasingheDo Gooder (Employee)
asked in Finance (Financials)

Cash Customer Repayment Check for Credit Card Refunds

How can I CASH a Credit Card Refund that shows up in Customer Repayment Check?  There is no RMB to Cash the payment.  The payment is currently in a Printed Status.   There is no help how to do this for Credit Card Refunds.

2
Shehan Almeida
Superhero (Employee)
1 year ago
R
Do Gooder (Partner)
RLGroenerDo Gooder (Partner)
asked in Finance (Financials)

2 voucher related to same voucher source

Hello All, Can some explain the funciton of the field Mpccom_Accounting_id in the view: GEN_LED_VOUCHER_ROW_UNION_QRY. I have a situation where 2 different voucher_number which have the same voucher_type (MPR)have the same value in the Mpccom_Accounting_idOn voucher is created in Oktober 2022 and the otherone in November 2022.Is it normal that there duplicates in the field Mpccom_Accounting_id when vocuher number are different?How can that happen?How to solve that?Regards,Raymond

2
R
Do Gooder (Partner)
1 year ago
A
Sidekick
AlanSSidekick
asked in Finance (Financials)

BACS to CHAPS Apps 10

In June 2021 our UK plant switched from the BACS system to CHAPS.Prior to the switch the UK would upload details of their supplier payment runs to the bank via a file upload.Since the switch they have not been able to do so - no file being created to upload to the bankWe were advised that there was no difference between the two systems and that the setup currently in place for Payment Format BACS and Payment Method BACS OUT should remain in place for suppliers being paid through BACS and that processing would continue as normal.  This is not the case as this has become a manual effort in terms of sending the payment information to the bank.If anyone in the community has come across a similar situation when using these two systems any information that you can provide in terms of adding/changing Payment  Formats and Payment Methods would be much appreciated. Thanks AS .

2
A
Sidekick
1 year ago
K
Do Gooder (Partner)
KushanJayasingheDo Gooder (Partner)
asked in Finance (Financials)

How can we set up company and finance set up as per the below business scenario?

One of our customers have different branches in different cities. And those branches will be sending out financial data separately to the entity. Then the final entity will be preparing financial statements. How can this business case can be facilitated in IFS?

2
K
Do Gooder (Partner)
1 year ago
EricGrimbert
Do Gooder (Partner)
EricGrimbertDo Gooder (Partner)
asked in Finance (Financials)

Posting Proposal

Hi Community, Do you know is there a set up to be able to activate in modify mode the following 3 fields ?Authorized Check Box On Hold Checl Box On Hold Reason IDFisrt of all the company set up is as follow Starting the procedure from Posting Proposals windowRMB, posting proposalRMB Installment plan and discount. These 3 fields are by default in Read Only mode ?When starting the procedure from the Man Supplier Invoice windows   

2
EricGrimbert
Do Gooder (Partner)
1 year ago

Badges

Show all badges
Terms & ConditionsCookie settings