Finance (Financials)

Hi,After upgrading from 22r2 to 23r2.3 we got an issue with outbound customer invoicesApplication service update: 23.2.3Framework service update: 23.2.3IFS Cloud Web version: 23.2.3.20240131160230.0IFS OData provider version: 23.2.3.20240130110039.0In the menu “Customer Invoices with Errors” the “Send Error Messages” says:ORA-20105: Archive.KEYERR: Report with key does not exist.We tried to follow the instructions from this 3 year old topic and set the default Life time for report CUSTOMER_ORDER_IVC_REP to 1826 days, but it did not work. And if i try to “Process Invoice” manually it works.Has anybody had this prob

Cost set 5 is not updated from any priselists - please advice if you have any ideas.I am running on IFSAPPS 10 UPD 17, logged on as application owner IFSAPP.The parts I have tried are all purchased many times and there is an inventory quantity.First ScenarioOn Supplier for Purchase Part I have entered against the main supplier a new prise in a future date.Then I run Product Costing > All Levels Part Cost Calculation although my part has only one level.The part does not appear at all in Cost set five, the window Planned Purchase Costs.Second ScenarioI enter a Supplier Agreement with a period that starts in the future.Then I add my part to the Parts table with a price different from the current.Then I set the agreement to Active.Then I run Product Costing > All Levels Part Cost Calculation although my part has only one level.The part does not appear at all in Cost set five, the window Planned Pur

A part with two transactions appears as shown below:If we go by time created, the timeline is correct, but if we go by transaction ID, it is not.And the display by transaction id will cause the balance in quantity on hand development to be -1 instead of zero.The on-hand development screen orders the display in descending order of transaction ID so in reality, INTSHIP for the above part should have had a transaction ID higher than the OOREC.Transaction ID column is generated by an ORACLE sequence.We tried to recreate a similar scenario in the in a recently refreshed development instance and observed that for an INTSHIP to happen, material line reservation had to be done prior and that material line was not available for reservation unless the OOREC received that part into inventory.So, in this situation, the OO

I have a scenario like below and need to recreate in build place.Common costs are reported as follows.Rent 100,000Wages 250,000# of calls for Cost/profit center 1 = 200# of calls for Cost/profit center 2 = 350I need to allocate (pro-rate) above rent and wages for each cost center based on number of calls .I used the Periodical allocation guideline but could not recreate . Can I get advice on what is the best way to approach this?

Hi there,  Just wondering if anyone has built a database task or chain that runs daily that checks if the current date is the accounting period end date? If it is, I want to calculate an average currency rate.   

Hi,How do we get more information on this Error? As we feel the users are included in the NF user group and the voucher series are working for other users posting, but for some reason when they try to authorise an invoice it doesn’t allow them to.

I had some manual cash flow items that I have now removed and some repetitive cash flow items whewre I have amended the value (VAT and Salaries) however they are still showing on the cash flow report when I run it. Is there something I am missing in terms of further changes I need to make elsewhere in IFS? Thanks 

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?  

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 

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

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 cre

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 a

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 amoun

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 pro