Finance (Financials)

This will include the questions related to Financials.

  • 4,295 Topics
  • 11,825 Replies

4295 Topics

Shehan Chandrasekara
Sidekick (Employee)
Shehan ChandrasekaraSidekick (Employee)
asked in Finance (Financials)

IFS Cloud 21R2 Error in customer invoice postings when having a negative line

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:

1
O
Sidekick (Customer)
11 months ago
C
Do Gooder
Craig_IFS8_to_CloudDo Gooder
asked in Finance (Financials)

Customer Order / Invoice - VAT Calculation in SQL for Order Amount Summary

Does anyone know what the SQL is that is being used to build the “Order Amounts” Totals Section on the “Customer Order” page, please? I’ve looked at the Entity that from the Debug Window but it is CUSTOMER_ORDER and this SQL:SELECT * FROM IFSAPP.CUSTOMER_ORDERdoesn’t show any summaries.I assume it’s done in a view but that view doesn’t seem to be identified in the Debug Window as a separate View. Thanks, Craig.

1
G
Sidekick (Customer)
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
ORFJAN
Sidekick (Customer)
ORFJANSidekick (Customer)
asked in Finance (Financials)

Pillar Two Tax

Dear all,based on OECD timeline, new international tax system called Pillar 2 should be applied in 2023. This should affect multinational groups with consolidated revenue over €750m.I just wanted to double check here, whether IFS is giving any attention to this and if we can expect any support in IFS application for this?Thanks Janhttps://www.oecd.org/tax/beps/tax-challenges-arising-from-the-digitalisation-of-the-economy-global-anti-base-erosion-model-rules-pillar-two.htm​

1
L
Do Gooder (Employee)
1 year ago
Aus S
Sidekick (Customer)
Aus SSidekick (Customer)
asked in Finance (Financials)

Inventory Write Off

Hi Community,I need to write off some inventory which are physically not available. One option is to go Issue Inventory and that stock will go out.Is there any other way we can write off with a journal entry relating to the stock value?ThanksSu

10
F
Superhero (Partner)
1 year ago
R
Do Gooder (Employee)
runiseDo Gooder (Employee)
asked in Finance (Financials)

GL Balance Analysis - Voucher Information

Hello, Need your expert advice on GL balance Analysis on Cloud. I am trying to search amounts as per the parameters in this image When I click on Voucher Information, it opens a new window, but the window does not have any data (reference below image) However, when I try to search the same parameters in GL voucher row analysis, it has GL rows Is there a reason, the earlier window shows empty window? Or am I missing something? ThanksBest regardsRutuja

3
K
Do Gooder (Employee)
8 months 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
hrdilshan
Sidekick (Employee)
hrdilshanSidekick (Employee)
asked in Finance (Financials)

The Accounting Period is used by rows in another object (Period Definition)

Hi Friends,anyone know how to solved this issue? 

4
hrdilshan
Sidekick (Employee)
1 year ago
T
Sidekick (Customer)
TTRACYSidekick (Customer)
asked in Finance (Financials)

Projection settings

I am trying to get someone set up to be able to print Year Acquisition Report.  I have given full grants to YearsAcquisitionReportHandling, but it is giving the dreaded You are not allowed to execute this report.I can execute with my full admin access but have been unable to get this to work for a user without full Admin. 

4
EntNadeeL
Hero (Partner)
7 months ago
C
Do Gooder (Partner)
CBKLeasureDo Gooder (Partner)
asked in Finance (Financials)

Automatic transaction matching bank rec

I am working in 21.2.0.  I completed automatic transaction matching for the bank reconciliation but I am unable to see the transactions that were matched.  There is no placed to rollback these matchings either.  All of the documentation in the Community look like it’s from IEE and there is a RMB that allows unmatching but I cannot find this in the Cloud version we are on.Thanks for any assistance.

4
C
Do Gooder (Partner)
1 year ago
B
Hero (Partner)
bytsophanHero (Partner)
asked in Finance (Financials)

reopend shop order by IFS

Hi ExpertsI have the experience with a customer where the shop orders keeps on getting reopend by the system and closed again. i searched by the shop order number and i see Transactions starting from the 2.2.2022. on the 5.12.2022 i see it got open and closed again with some revaluation. I really dont know how to start with the analysing or dont even know whats the cause for this. 

8
PamithK
Sidekick (Partner)
1 year ago
S
Do Gooder (Customer)
stephanie.bertoliniDo Gooder (Customer)
asked in Finance (Financials)

Customer Invoice Not Available In Offset

We have a situation in our IFS Apps 10 Update 8 IEE environment where our credit department has a debit invoice in a customer account that originally had a payment applied to it, but they rolled back that payment. They then created a credit invoice for the same amount of the invoice and they wanted to do a customer offset to apply the balances. However, the debit invoice is now not showing in the list of invoices that shows as your trying to add it into the transactions tab of the offset. I’ve looked at the following in an attempt to troubleshoot: The invoice is not already pulled into any other NotApproved offsets  The offset had the appropriate Series ID on the line that I was trying to pull the invoice into. I even tried with no Series ID.  The rollbacks appear to have been fully completed, and the invoice is showing an open balance again. Any ideas of what else could be causing this invoice to not be pulled into a customer offset?Thank You!

5
S
Do Gooder (Customer)
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
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
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
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
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
L
Do Gooder (Customer)
lnilssonDo Gooder (Customer)
asked in Finance (Financials)

Bug in R22:1 SU 10: Error message "Insufficient privileges" when trying to switch authorizer for a supplier invoice in Posting Proposal window?

Hi,We have recently taken SU 10, and we now encounter an error message "Insufficient privileges" when trying to switch authorizer for a supplier invoice in Posting Proposal window.Anyone else who has this problem? Did anyone find a workaround?Best Regards, Lilian 

1
L
Do Gooder (Customer)
1 year ago
T
Sidekick (Partner)
ThejSidekick (Partner)
asked in Finance (Financials)

Purchase Transactions Transferring errors

Hi Experts,The below error is throwing when transfer the purchase transactions to finance module.Can anyone of you help me to resolve this error? Thanks in advance,Darshi

1
Y
Superhero (Employee)
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 (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
E
Do Gooder
Emila75Do Gooder
asked in Finance (Financials)

External Bank file- Bank recon automatic

Could someone show me how the bank file looks like with all the data that is being imported for auto bank recon?Do you have any step by step instructions how to set up basic data for Bank recon. with screen shots?We have never used that option in IFS. Please help  and Thank you Emilia

1
F
Superhero (Partner)
1 year ago
E
Do Gooder
Emila75Do Gooder
asked in Finance (Financials)

Manual Transaction Matching- Bank Reconciliation

How do I do Manual Transaction MAthng?The company never used Bank Reconciliation  and we don’t have a Bank set up/linked to IFS.We would love to do that soon, but first how do I reconcile just  by using Manual Transaction function.I have cash transactions in there showing since 2019 but I only want to reconcile 2022. So i just take my bank statement and click boxes?  How do I get rid of all previous years’s data?Also what do I enter as Reconciliation date? Do i enter month end for the period i want to reconcile - what is the function of that date? Please Help???  thank you 

3
Neill M
Do Gooder (Employee)
1 year ago
Tharanga Ishara
Do Gooder (Employee)
Tharanga IsharaDo Gooder (Employee)
asked in Finance (Financials)

'RltdRmtInf' missing in the Core ISO20022 Supplier payment file

Issue:Our customer needs to show the info related to 'RltdRmtInf' in the Core ISO20022 Supplier payment file. But as per the standard XSL this XML tag is not supported.In the standard SWIFT definition, its available but not in the Core ISO20022 Supplier payment file unfortunately. How to proceed further without handling it as a CRIM item ?                <RltdRmtInf>                    <RmtLctnMtd>EMAL</RmtLctnMtd>                    <RmtLctnElctrncAdr>accountspayable@XXX.com</RmtLctnElctrncAdr>                </RltdRmtInf>Its an optional XML tag as per info available in SWIFT.com Question:Is there a way to get this fixed from R&D  ?   

0
Tharanga Ishara
Do Gooder (Employee)
1 year ago
T
Do Gooder (Employee)
Tharindu PitawalaDo Gooder (Employee)
asked in Finance (Financials)

Issue in Lease Accounting

we have an existing lease for which we are trying to modify the Terms and Conditions.   The amount of the lease has changed for each month going forward and we are trying to modify the amount.  We first get an error saying we cannot modify it with an existing Amortization Schedule but cannot do anything with the Amortization Schedule since we have posted Proposals against it. Test scenario to Modify Existing LeaseGo to the Terms and Conditions tab RMB online and go to Terms and Conditions Change the Lease Amount Change go forward Amount and the remaining number of Lease Payments. > Click ok  Try to delete the current Schedule ID and get this So how do I modify this Lease for the go-forward months?

1
T
Sidekick (Employee)
6 months ago

Badges

Show all badges
Terms & ConditionsCookie settings