Finance (Financials)

This will include the questions related to Financials.

  • 4,335 Topics
  • 11,929 Replies

4335 Topics

A
Do Gooder (Partner)
AbdessamadDo Gooder (Partner)
asked in Finance (Financials)

VAT on advanced invoice

Hello,Is it possible to have VAT on advanced invoice ?In the standard flow we see that the VAT is reversed at the payment.We want to have the VAT to be declared at the booking of the advanced invoice.Is it possible and how on IFS ? Best regards.

4
Ralph Gericke
Hero (Employee)
6 months ago
L
Do Gooder (Customer)
larissawillettDo Gooder (Customer)
asked in Finance (Financials)

Accounts Payable Aging Detail List for Audit

Hello, one of the items we need to provide to our external auditors every year is a detailed listing of our Accounts Payable aging.  Basically, a listing at the invoice level of the invoices that make up our AP.  I cannot find any report or query in IFS that would give me an accurate list.  Does anyone know of anything?  We have created a report with this information, but there is no logic and it is a point in time snapshot. Therefore, the problem is that we keep AP open at year end and post invoices into year-end after new invoice for the new fiscal year have started to flow in as well as payment runs in the new year.  We need something with logic like the AP Summary level report out of IFS that would help give accurate details a week or two into the next month.Let me know if anyone has suggestions!

9
Ralph Gericke
Hero (Employee)
6 months ago
Máté Kubicsek
Sidekick (Customer)
Máté KubicsekSidekick (Customer)
asked in Finance (Financials)

Problem with instant invoice

H IFS community I have an issue. We created an instant customer invoice, however the invoice is stuck in Printed status, we need it in PostedAuth status as it won´t show on Customer Ledger Open Items report. Please, does anybody know where the problem might be? Kind regards

1
F
Superhero (Partner)
6 months ago
T
Sidekick (Employee)
TolinnSidekick (Employee)
asked in Finance (Financials)

ISO20022 credit transfer file not accepted by the Danske bank

Hello Community members, One of IFS UK customer’s has an issue, when they’re sending the ISO20022 credit transfer file from Cloud to bank via SFTP integration. Danske bank is rejecting the file with following information: RR07 - RemittanceInformationInvalid - Remittance information structure does not comply with rules for payment type - Payment types Standard & Internal do not allow message to beneficiaryWe’re using the standard ISO core Transformer on the Routing Address  What could be the reason of this error occuring? 

1
Link
Superhero (Customer)
6 months ago
P
Sidekick (Partner)
pratik.b.shahSidekick (Partner)
asked in Finance (Financials)

Limitation in Creating Manual Supplier Invoice with respect to amount

Hi TeamGreetingsWhile creating a manual supplier invoice for India Company in IFS 9 (localization is enabled), we are not able to add lines when amount goes above 99,999.99 in gross amount column.Refer to below screenshot to understand the issues in brief:Screen shot 1:Line 1 - Interstate 0% - When net amount is added up to 99,999.99, gross amount is reflecting for it. (also, we are able to do match receipts for it) Line 2 - Interstate 18% - IMPORT - When manual tax base amount is added up to 5,55,555, again its tax amount is reflecting in gross amount column as 99,999.90 Screen shot 2:Line 1 - Interstate 0% - When net amount is added over 99,999.99, gross amount is not reflecting for it. (Here we are not able to match receipts) as net amount does not get loaded.Line 2 - Interstate 18% - IMPORT - When manual tax base amount is added, again its tax amount is not reflecting in gross amount column                                     Kindly help us resolve this issue.

2
P
Sidekick (Partner)
5 months ago
D
Sidekick (Customer)
DW_SydneySidekick (Customer)
asked in Finance (Financials)

Best Practice Advice - Long Term Outsourcing Contract

Hi We are a Apps 10 user and outsource our IT desktop support to a third party. The third party sends a monthly invoice that can vary by $ amount due to the service supplied or the equipment provided.To complicate the matter more, the equipment needs to go on to the Object Balance register and the service is expensed.. They may be on the same invoice.  The $ and equipment can be estimated, but the amount of service provided or equipment delivered is not known at the start of the month.Our Head of  IT is becoming exasperated by creating a Purchase Order each month to cater the varying $ amounts and services delivered.My question to the community is what is the best way to manage such a contract in IFS (Apps10)?I was thinking of breaking down his budget, in a Purchase Order No-Part Order Lines, and he can incrementally receipt each line over the year.  The other idea was treating the contract as a sub-contract.  But they both come with relative downsides.Thank you and have a great weeken

3
F
Superhero (Partner)
6 months ago
J
Sidekick (Customer)
JStackSidekick (Customer)
asked in Finance (Financials)

Posting Analysis Transferred but no Voucher Generated

Good Morning,  We are reviewing our Distribution and Manufacturing Postings Analysis Screen and noticed that we have a transaction that is transferred (Status Code 3) but no voucher was generated.  It looks like the posting controls are setup correctly as we have no errors (M1 - Inventory & M5 - Receipt Without Purchase Order) showing on this transaction.  This is a first time occurrence from the Distribution side for us because we usually clear errors and they push through as desired. Any help on this would be great as this is going to affect Month End Close. We are currently on Apps 10 Update 20 in IFS. Thanks

9
C
Hero (Customer)
6 months ago
R
Sidekick (Customer)
ROXTOBBRISidekick (Customer)
asked in Finance (Financials)

Rollback customer payment in different period

Hi, I have a user with a customer payment that was made in September.The user that wants to rollback the payment in October. I don’t know if this is by design or a bug. But since period 9 is closed we can’t post it there. But the application won’t allow us to post in period 10 either (“It’s not allowed to change voucher date when rollbacking the payment if the original period is open for user group”) and refers to period 9 as open even tho it’s closed. Any idea about this?     

3
F
Superhero (Partner)
6 months ago
X
Sidekick (Partner)
XitLakshMSidekick (Partner)
asked in Finance (Financials)

Cash Transactions are not visible in Automatic Transactions matchig screen.

Hi Experts,  Cash transactions prior to a specific date are not visible in automatic transaction matching screen. Those transactions are already matched. But those transactions should be visible once the ‘exclude matched’ check box unticked. I checked in back-end. Transactions are available in back end. This issue was in Apps9 and Recently customer moved to IFS cloud. The same issue exists as it is in cloud also. ** This issue exists for all cash accounts they are using.  Can someone help to resolve this issue? Thanks, in advanced! 

3
M
Sidekick (Customer)
6 months ago
T
Sidekick (Employee)
thkolkSidekick (Employee)
asked in Finance (Financials)

What is the recommended approach for currency revaluation when there is no Gain or Loss on currency revaluation

In some companies there are instances where when currency revaluation is executed there are no foregin currecy tranactions and therefor there will not be any gain or loss to post. In those situations if we try to create a currency revaluation and post an error will occur as “No Gain/Loss to post. But it is possible that foreign currency transactions may occur in the future. when this happens, Is the recommended approach not to create a currency revaluation record for that month?  

2
T
Sidekick (Employee)
6 months ago
L
Sidekick (Customer)
LisaTSidekick (Customer)
asked in Finance (Financials)

mixed currency on customer account

Hi,Can anybody please advise if there are any issues with a customer account being setup with multiple currencies?Example: we have a customer who was initially setup in USD but then decided they wanted to pay in GBP.   They are now placing orders again but they are in USD.Is it possible to setup multiple currencies in their account or is simply a case of relying on the orders being placed in the correct currency on the system by our commercial team?I work in accounts so want to eliminate any potential problems this will cause regarding raising invoices and payments being received.Thank you,Lisa 

1
F
Superhero (Partner)
6 months ago
T
Sidekick (Partner)
ThejSidekick (Partner)
asked in Finance (Financials)

FA object information

Hi experts, There should be information of the asset. e.g. useful life, method of depreciation, date of acquisition.... so, when we are revising the useful life,  we need to amend/update it in IFS.  Can anyone show me how to change useful life and salvage value in the middle of the assets life time without affecting previous depreciation values?Best regards,Theja 

7
T
Sidekick (Partner)
6 months ago
T
Sidekick (Partner)
ThejSidekick (Partner)
asked in Finance (Financials)

Cash Box

Dear experts,Does anyone know the usage of below field?  Best regards,Theja

1
F
Superhero (Partner)
6 months ago
N
Do Gooder
NatDo Gooder
asked in Finance (Financials)

Customer offset - Error Message

I get the error ‘the payment amount and the deduction amount should have the same sign’ on two items which should match off to each other on IFS. These were migrated from a previous system. Is there any way I can allocate these together?  

1
F
Superhero (Partner)
6 months ago
C
Do Gooder (Customer)
CBICRUSUDo Gooder (Customer)
asked in Finance (Financials)

GL transactions for Work Orders

Hello, I saw some posts, for IFS 9, were it was discussed how you can enter external costs directly in Report in work order > Postings tab. We work in IFS 10 and I cannot see a tab Postings in the Report In Work Order screen. Does it need to be activated it, in some way?How can I enter external costs directly in Work Order or Work Task? I was also looking at Voucher Entry and even there I do not have fields for Work Order/Work Task. Thanks,Cora

2
C
Do Gooder (Customer)
6 months ago
S
Sidekick (Customer)
SMcLeesSidekick (Customer)
asked in Finance (Financials)

One time Supplier data

Is there a screen that will show all the Supplier data that has been entered as One Time suppliers?Almost a Supplier Basic Data screen for one time suppliers?

1
F
Superhero (Partner)
6 months ago
S
Do Gooder (Employee)
Suchithra FernandoDo Gooder (Employee)
asked in Finance (Financials)

Error when importing external file template STDFRBNKSTAT

Version : 23.1.4External file template STDFRBNKSTAT is used to import standard external CFONB file (file template issued by French banking society)External File Template​​​​A dedicated external file template STATFRANCE has been created by copying standard template STDFRBNKSTATBanking file import has been done based on STDFRBNKSTAT templateExternal File TransactionsHowever lines starting with 04 have not been importedError statement ‘Unpack error’ : “Format de valeur ou symbole décimal non valide dans le fichier chargé.” Meaning format not appropriate Possible root cause:  Standard banking file incorporate alphanumeric values in amounts (eg E on below screenshot).These values are used to determine signs and others information. Below matrix to interprete these values I need some assistance to resolve this issue. 

0
S
Do Gooder (Employee)
6 months ago
K
Do Gooder (Customer)
KerstinDo Gooder (Customer)
asked in Finance (Financials)

Guidance in how to use Accounts for Automatic Matching

Hi all experts,We have understood that it should be possible to use "Accounts for Automatic Matching" if we have to find a difference between Accounts Payable and General Ledger.  Is here anybody who can give us some guidance in how to use this functionality?

0
K
Do Gooder (Customer)
6 months ago
R
Hero (Customer)
ronhuHero (Customer)
asked in Finance (Financials)

Instant Customer Invoice Error - No Data Found

Community, how to handle below error? it is a correction invoice of an instant customer invoice. I am trying to print this correction invoice. 

2
P
Hero (Employee)
6 months ago
R
Sidekick (Partner)
Rasmus RaulSidekick (Partner)
asked in Finance (Financials)

Intrastat invoiced charge priced included

Hi,In Apps 9 we have added bugfix “BUG 161681” to intrasat. When we create an intrastat report we generate an export file. In that export file we only get invoiced price and not added invoiced charge price. Is there a way to get IFS to include invoiced charge price to the total invoice priced? See secnario below:Generate intrastat report Generate fil  Data from intrastat. Quantity 2000* price 2,811555 = 5623. Charge price 0,250725*quantity=511,5.  Output data. Invoiced price = 5623. But would like it to be 5623+501,5 =6124,5   How can we add invoiced charge price to invoiced price in output data?   

0
R
Sidekick (Partner)
6 months ago
R
Sidekick (Customer)
ROXTOBBRISidekick (Customer)
asked in Finance (Financials)

Prepayment type code Mixed Payment in Cloud

Hi! We’re doing tests for upcoming upgrade to Cloud. In out Polish company we use prepayment based invoices. When doing a CUPOA in Mixed Payment in Apps 10 Aurena, we can define Prepayment type code and then in Posting Control PP8 with control type IC9 - Prepayment Type connect that to accounts. However, in Cloud we can’t find the column Prepayment type code. Anyone that has an idea on how to resolve this? Best regards, Tobias 

2
R
Sidekick (Customer)
6 months ago
Lauri
Sidekick (Customer)
LauriSidekick (Customer)
asked in Finance (Financials)

Revenue Recognition Forecast: Transfer to Business Plan: why project costs are not transferred

Hello IFS Community,I have recently encountered an issue with the Revenue Recognition Forecast Transfer to Business Planning in IFS Cloud. It seems that when this transfer is executed, only project revenue and project accounts receivable amounts are being transferred to Business Planning transactions, while project costs and accounts payable do not get transferred.Our expectation was that costs and possibly accounts payable would have been part of the transfer, and so I am asking is there a specific configuration or setting that I might be missing that prevents project costs and accounts payable from being included in the transfer?I would appreciate any insights or guidance on how to address this issue, as it has the potential help our financial planning and reporting processes significantly.Best regards,Lauri

0
Lauri
Sidekick (Customer)
6 months ago
M
Do Gooder
MohsenDo Gooder
asked in Finance (Financials)

GL Balance Analysis - Debit Currency Amount and Credit Balance Simultaneously

Hi thereI have an issue with GL Balance Analysis , when I have a account with currency balance like cash account in some cases I have both debit currency amount and credit Balance in GL Balance Analysis at one time.In real world it is impossible to own 1,000 USD and owe 2,000 in accounting currency at one time.Is there any setting , option or explain for this situation?Thanks

3
A
Hero (Partner)
6 months ago
A
Do Gooder (Partner)
AbdessamadDo Gooder (Partner)
asked in Finance (Financials)

Advanced invoice net amount

Hello,  We would like to have our advanced invoice on net amount in order to match with this accounting scheme Supplier acount credit: Gross amout (120)Advance invoice account debit: Net amount (100)VAT account on advanced invoice  debit: (20) Is it possible on IFS ? Best regards 

2
A
Do Gooder (Partner)
6 months ago
M
Do Gooder (Employee)
Mourad KallaliDo Gooder (Employee)
asked in Finance (Financials)

ORA 20110: Upload bank statement

Hi Community, When I try to upload the bank statement to IFS Cloud using scheduled task, and when I check the background job I have this error message :  How can I solve it ? Many thanks

0
M
Do Gooder (Employee)
6 months ago

Badges

Show all badges
Terms & ConditionsCookie settings