Skip to main content

Finance (Financials)

This will include the questions related to Financials.

  • 5,431 Topics
  • 14,340 Replies
5431 Topics
Dharshankumaar Mahendran
Superhero (Partner)
Dharshankumaar MahendranSuperhero (Partner)
asked in Finance (Financials)
Concern over Cash Flow Forecast behaviour

Hi All,According to the help documentation, Create Cash Flow forecast is defined as The activity used to create a forecast of future cash flows from the cash flow information collected from the specified companies based on a selected analysis ID.But when we create a cash flow forecast, details show only the past data and not any for the future.Highly appreciate if someone can tell me how this functionality works?  

652
Lauri
Sidekick (Customer)
C
Do Gooder (Customer)
ChotaDo Gooder (Customer)
asked in Finance (Financials)
Reminder set-up

Hi CommunityIs it possible to change the customer reminder set-up?Or is it necessary to use Customization?We would like to change the head wordingSee the attached file yellow circle 

451
Ieva Rituma
Superhero (Employee)
D
Sidekick (Employee)
DannySidekick (Employee)
asked in Finance (Financials)
Posting Control - Correction to Voucher?

Is it possible to correct postings where the posting control was incorrectly assigned to the wrong account?The vouchers have been created. PRJC4  was going to the wrong account code in our scenario

811
H
Hero (Partner)
C
Do Gooder (Partner)
CorBarbaLDo Gooder (Partner)
asked in Finance (Financials)
Open CUPIA and customer offset

HiI have a client who just went to IFS 10.  They have an customer order that was created in IFS 9.  There was an advance invoice created and one advance payment made to the order.  The final advance payment was posted, they did not clear the CUPIA at that time and it did not apply to the transaction.  Instead they just posted the cash side of the entry using the Deferral cash account and that removed the balance in the GL.  This left the CUPIA still open. They are now in IFS  10 and are trying to close the CUPIA.  They have done a rollback that parked the payment.  They tried to do a customer offset and received the following error. The CUPIA is still open and now the final invoice has an open balance of the 7,155.They have gone back into IFS 9 and did the same steps that were done in IFS 10 and they were able to create the offset. Any thoughts or suggestions on what can be done? 

2033
Ieva Rituma
Superhero (Employee)
FGodehardt
Sidekick (Customer)
FGodehardtSidekick (Customer)
asked in Finance (Financials)
Closure of open position after bad debt?

Dear IFS-Community,I got a 100% bad debt and declared it as well with the bad debt management.As you can see the bad debt is existing and IFS also says that there´s a “adjustment of value”I checked the posting control too and it works fine. My problem is, that I still have an open position / open item on the customer analysis:The 952€ are still an open item and are included in the customer´s balanceAnd furthermore the bad debt value is included in the balance to pay from the customer and also it´s present in my reportings.Is there any function I forgot to use so that the open position disappears correctly?Thank you very much in advance.Best regards,Frederic

912
FGodehardt
Sidekick (Customer)
B
Do Gooder (Customer)
BabsDo Gooder (Customer)
asked in Finance (Financials)
VOUCHER_TYPE DESC

Hello all,Can anyone help me with the table/field name where I can find the descriptions to the voucher_types captured on gen_led_voucher_row_tab table.  Thanks.

1073
AkilaR
Hero (Partner)
M
Sidekick (Partner)
MelTanyaSSidekick (Partner)
asked in Finance (Financials)
Transfer cost accounting - error "no transaction"

Hello to the community I have a question regarding time registration bookings; i have project transactions which have valid postings and are approved (time bookings done from 01/04 to 05/04)   I then run the “transfer cost accounting” task today but get the following error message  : I am wondering if the dates are an issue here, can i run the action in the current month or do you have any other clue on the possible reasons for that ? Thank you 

2174
M
Sidekick (Partner)
T
Sidekick (Partner)
ThejSidekick (Partner)
asked in Finance (Financials)
Adjustments in period 13

Hi Experts,I am trying to create a M voucher using YE user group to enter adjustments to period 13 in Apps 10. However, I encountered below error.  @Adam Bereda @Shehan Almeida I referred your previous community post. However  couldn’t pass the entry to period 13 due to above error. Please  help. Thanks in advance,Theja

1194
A
Hero (Customer)
F
Do Gooder (Partner)
FPOCDo Gooder (Partner)
asked in Finance (Financials)
× Activity Sequence No must have a value for Project

I have the following error message when i forgot to select activity sequence n° if I do a manual voucher on project : “Activity Sequence No must have a value for Project 1092”. This control is very important. This control is now not active, and now i am able to select a project without Activity sequence when i do a manual voucher on project. Do you know where is the parameter in order to activate this control and this error message? Below the error message i have in my test environnement  

6994
M
Sidekick (Partner)
J
Do Gooder (Customer)
Jocelyn LeanoDo Gooder (Customer)
asked in Finance (Financials)
Incorrect Accounting

Hello IFS Community,I have an error that says incorrect accounting, when I RMB on the line and go to Rental Transactions. It is blank. Does anyone know how to fix this?  

715
J
Hero (Employee)
B
Do Gooder (Customer)
beckk1173Do Gooder (Customer)
asked in Finance (Financials)
Zero balance accounts in Ledger

I am running a GL Balance Analysis in EE and am looking to include all accounts, even ones with zero balances that did not have any activity during the month. What can be done to include the accounts with no activity? Right now I am only able to see accounts with balances and ones that had transactions done during the month. 

1496
D
Sidekick (Customer)
audreyS
Sidekick (Partner)
audreySSidekick (Partner)
asked in Finance (Financials)
PCA Procedures for WBS project

Hello,I'm having a problem. I want to use the PCA module but I'm using a WBS project and I'm getting a blocking message Can you tell me if there's a setting to be made to stop getting this message or if I have to do something else without using the PCA module?Thank you for your help   

441
audreyS
Sidekick (Partner)
C
Sidekick (Partner)
CamB
asked in Finance (Financials)
Final year end: Gap between Currency amount and accountabilty

Hi, We are facing an issue with final year end process:When we proceed the final year end process, there is some transactions with amounts in GL in the accounting currency (EUR), the currencies amounts (in original currencies) and the parallel currency (EUR too).When we generate the final voucher YE - for closure and opening of the new period, it doesn’t take into account the amounts in currencies (original currencies) for some accounts only.For example:  Accountability in EURO Currency amount Parallel Curr (Euro) GL sum amounts 0 61 K 0 Gral Bal sum amounts 0 0 0 YE sum amounts 0 53 K 0  We analysed and saw that some accounts they are not fecthed in the YE voucher so there is no amounts in currency amount for them.In BG -> there is no discrepancies, because the accounts not fetched in the YE process have zero amounts in currencies. It sum up zero.in GL analysis, we can see the gap between the all period (sum of all currencies amounts : 61K ) and the YE v

30311
C
Sidekick (Partner)
A
Do Gooder (Employee)
aknaDo Gooder (Employee)
asked in Finance (Financials)
How to set up WIRE payment?

Unable to set up WIRE payments from payment methods. As there is no payment method called ACH_WIRE.Can anyone guide me?

410
A
Do Gooder (Employee)
N
Do Gooder (Customer)
nstacktkDo Gooder (Customer)
asked in Finance (Financials)
Customer Analysis - Invalid Table Name for Specific User

When a specific user tries to load customers on the customer analysis screen, they receive the error “Invalid Table Name. Failed executing query (ORA-00903: invalid table name)”.This issue only affects this user who has all the permissions that seem necessary and on a test database can access this fine.When I look at the query being ran that throws the error, for the user the table name “ledger_item_cu_det_qry_cfv” is missing. For any other user this table name is present in the query and they can load customers on this screen. Any ideas?

3953
P
Do Gooder (Partner)
S
Sidekick (Customer)
SMcLeesSidekick (Customer)
asked in Finance (Financials)
Customer invoice 4 decimals place v 2 Decimal places

We use 4 decimal places when creating customer invoices, so local settings are set to 4 places, however this is causing an issue when customer obviously pays to 2 decimal places. Is it possible to create and produce the invoice using 4 decimal places but only post to customer account as the 2 decimal place rounded figure?

750
S
Sidekick (Customer)
L
Sidekick (Partner)
Lakna KSidekick (Partner)
asked in Finance (Financials)
Overhead allocation based on number of orders

Can I get an overview / any document of basic data involved in the process of allocating  overhead cost based on the number of orders

190
L
Sidekick (Partner)
A
Sidekick (Customer)
andrei.borromeoSidekick (Customer)
asked in Finance (Financials)
Drop ship orders

Hello everyone. I am hoping someone can advise on how we can deal with the situation below. Parent received an order for $100 . Billing will be done solely by parent utilizing advanced invoices as determined by a billing schedule per the order agreement. Subsidiary will work on the order and deliver to the customer on behalf of parent. Of the $100, the parent will recognize $20 in revenue with no costs, and the subsidiary will recognize $80 in revenue with planned cost of $40. Over the life of the project in the subsidiary, it recognizes revenue based on POC. The parent will recognize revenue based on the subsidiary’s POC. When the subsidiary finishes the project and delivers the item to the customer, it will then invoice the parent for $80. Revenue is recognized each month via revenue recognition.In terms of setting this up, my thought is:Parent creates customer order for $100. A manual POC project is created with planned revenue of $20 and no planned costs. Subsidiary creates a custo

1520
A
Sidekick (Customer)
S
Sidekick (Customer)
SMcLeesSidekick (Customer)
asked in Finance (Financials)
Payment Methods - Customer repayment

Trying to test Customer Repayment process for some credit balances that occur with some of our customers.I have a payment method set up that I use for the Direct Debit order, and I would like the posting to be the same for repayments (bank, GL Code etc).  How can I attach a new (or the current one already set up) payment method to Customer Repayments?

380
S
Sidekick (Customer)
S
Do Gooder (Partner)
Sundara.AlagesanDo Gooder (Partner)
asked in Finance (Financials)
Unable to Create Partial Credit Invoice against Project

Hi Team,  Can anyone tell me if there is a way to create a partial credit invoice? against Project Invoice? Now I am unable to create a correction invoice since the invoice was created via AFP. The only option is available to create an entire credit invoice but even in preliminary status we are unable to modify the price or value.

551
A
Do Gooder (Partner)
A
Sidekick (Customer)
andrei.borromeoSidekick (Customer)
asked in Finance (Financials)
Manual POC

Hello.  I wanted to ask if anyone has ever heard of or implements “manual POC” . We have run into a situation and have heard that “manual POC” may be something that could help. Unfortunately I haven’t been able to get more information on this, so I was hoping someone has an idea about it.

1253
A
Sidekick (Customer)
O
Do Gooder (Customer)
OROPAVELNDo Gooder (Customer)
asked in Finance (Financials)
bank statements camt.053 vs mt940

Hi all, we are currently on 23R2 and I was watching this IFS tutorial about bank statement reconciliation.in this tutorial is visible how you import camt053 and automatically match and create mixed payment. We are not using camt.053 but mt940 (or transformed version to xml). Is there any tutorial which show how to import xml (or mt940)? and automatically reconciliate bank statements? Thank you for help.Pavel

4322
Link
Superhero (Customer)
R
Sidekick (Customer)
rvanden5Sidekick (Customer)
asked in Finance (Financials)
ExtCustPayment of External File Transaction Error

I am trying to upload remittance advice data from a text file.  I have created an external file template off the ExtCustPayment file type.  When I use the External File Assistant to upload the file, I get an error about Payment Method (Way_Id) cannot be null.  It is not null and I can see it has data in the External File Transactions Detail page.Payment Method Mandatory Error, but has dataI am not sure if it is just a bad value (thought I did get the value from the dropdown list on the External Payments dropdown for payment type) or if it is not recognizing that there is data in the field.We are using IFS10.In case it is needed, here is the File Template build I am using:External File TemplateI have tried to simplify it down to just the bare bones.Thanks, Ron

5447
L
Sidekick (Partner)
M
Sidekick (Partner)
MelTanyaSSidekick (Partner)
asked in Finance (Financials)
External payment parameters for customer payment

Hello to the community,  NB : I have 2 templates for customer payments, one where the account number is a default value on template +  default value on message code set as well and when I use this one, payment is uploaded successfully. I copied this template and created a new one where there is no default value on account number so I can fill it in the imported document and I get the same error message everytime saying the system did not find the short name for the payment institute named SOGE.  I think there might be something missing in the external payment parameter regarding the payment institute but I can’t figure out what exactly. Here are some screenshots of my external payment parameter :   Here is the template i use with some default value set for message code.   I don’t clearly understand how message code and externa payment parameters work in general so if you have any idea on the problem, please share your thoughts and experience. Thanks Tanya

1961
L
Sidekick (Partner)
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.

5092
P
Sidekick (Partner)

Badges

Show all badges
Terms & ConditionsCookie settings