Finance (Financials)

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? 

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

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.

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 

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

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  

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?  

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. 

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   

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

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

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?

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?

Can I get an overview / any document of basic data involved in the process of allocating  overhead cost based on the number of 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

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?

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.

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.

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

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

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

 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.

Hi, ive done my tax return in IFS 10, its come out as a refund. I have created the tax clearance voucher and authorised the non-supplier payment. My problem is i cannot find the non-supplier payment in supplier payment proposals to be able to process the refund through the bank.How do i process this non-supplier payment? 

Community, We customer invoices sent between sister companies, they are all sitting in the same IFS DB. IFS is on host.  But recently we realized customer invoices sent from our Germany office cannot reach to Canada office. How to check this issue? where suppose to be the message flow to start investigation? Thank you.

Hello, Is it possible to explain the use of this screen  below ? Best regards