Finance (Financials)

We are having an issue on Cloud 24R2 querying GL Voucher Rows Analysis. If we use Edge, and input certain criteria (ie often ‘Year and Period’ or ‘Year and Project’), we are given an error when we click Search: GLVoucherRowsAnalysis/List (server error)Database error occurred. Contact administrator.Error details: [{"code":1422,"message":"ORA-01422: exact fetch returns more than requested number of rows"}]Server stack trace error(s):  Failed to execute the generated database statement  ORA-01422: exact fetch returns more than requested number of rowsORA-06512: at "IFSAPP.GEN_LED_VOUCHER_ROW_API", line 6217  ORA-01422: exact fetch returns more than reques

Anyone seen this Mixed Payment error? The payment amount and the matched amount have different signs in the lump sum transaction number.    The lump sum transaction number column is blank for all lines in this mixed payment. All of the payments are the same sign as the Inv/Prepayment that are being applied/matched.

Hi,I´m using external file template ExtFAObjectImport FA data migration. There are missing some columns in record type H which are available in database - for example LOCATION_ID and TAG_NUMBER (available in FA_OBJECT_TAB, not available in external file column definition). Is there any way, how to add these columns?  Thanks a lot.Pavel

Is there a way to block certain users from authorizing over tolerance in supplier invoice matching, when using supplier invoice work flow?  

I am Accounts Payable Supervisor, we are processing a 100 expenses sheets weekly to reimburse our employees. It will take my AP team member around 6 hours one day a week.We are using IFS-Clouds. Is there a way to automate the process? Realy, appreciate any feedback, I have some idea already, however like to hear if anyone automated the process.One of my idea, is to create a internal file to upload to General ledger. I did not test yet, I am in the process to do so. Meanwhile , just looking for other options.  

We are looking to start using HSBC for bankingHow can we update/amend our payment files to the HSBC Standard BACs 18 template? 

We need to import payments from a payment broker through the External File interface. But the file amounts are created with the thousand separator dot (.). We have tried to remove the dot using formulas in the External File Template Details section but with no result. On all rows with high amounts the status turns to “Unpack error” and the error message is “ character to number conversion error”.We would very much prefer to load these files without having to manipulate them before they are imported.Please advice!

Hi, I can’t find any documentation related to IFS App 10/IFS Cloud or IFS in general on what are the standard VAT codes and VAT codes setup.I’m new to IFS, used to be using SAP ERP where it was much clearer to me. Do you have any ideas? Thanks!

Hello,I'm trying to configure the VAT declaration for a company in Mexico.Can anyone tell me which Template ID is used for this purpose? Thank you very much!

Hi,We have had an issue reported where the GL account had a $0 balance however, when the currency revaluation process was run at end of month, the account posted a very large revaluation loss. Has anyone here had something similar? Many thanks​​​​​​

Hi Does anyone know if you need to enable the parallel currency option if you are implementing the consolidation module in IFS, I am assuming not but want to double check before I go any further. Thanks in advance.

Is anyone experiencing/know the reason/have a solution for above error when selecting a large number of records to Approve for Cost Accounting, please? Finance user is querying for a month’s worth of transactions (1679 currently); selects all, selects Approval for Cost Accounting/Approve for Cost Accounting“Error...” pops up (company URL xx’d) ProjectTransactions/List (server error)Database error occurred. Contact administrator.Error details: [{"code":6502,"message":"ORA-06502: PL/SQL: numeric or value error"}]Request Id: e89543f5-19ba-40bf-b3fc-103873e62a36Url:main/ifsapplications/projection/v1/ProjectTransactionsHandling.svc/Up

The issue was found in the 23.1.2 cloud  version  When M45, control type C47 is entered and saved, and then once gone to details the error comes when trying to enter a new record and selecting work center.Same with M55,control type C47  PostingControlDetails/Form (server error)Error while serializing contents. This error happens when the server cannot serialize the data to be sent to the client.A common cause is that one attribute's length exceeds the defined maxlength in the projection.To find more info, open Log Window or Debug Console, refresh and then check Network Tab in DevTools. In the response there can be more detailed information about the exception.Error details: N/A Has anyone encountered this issue before? and is there a workaround for this?

Hi I have a problem with currency bank account. The accounting currency balance is very wrong, and the currency balance is correct.Something has happen couple of years ago. I tired to do it on mixed payment but it does not allow 0 value on currency amount column.How to correct the accounting balance value? brtarja

HiHow to do the currency revaluation for bank account in Poland on year end? regards, Tarja

Is there any setting or warning we can add to IFS that will either stop the Final Invoice Posting if an Attachment is missing or a warning if no Attachment is there?

New Customer, currently going live in January 2023We are on 22R1SU5, and we frequently get many server errors when navigating pages - sometimes these go away when hitting refresh / reload, but occasionally these persist.  A user this morning was going into “Supplier Invoices for Final Posting Analysis” and was repeatedly getting the server error: Error while serializing contents.This error happens when the server cannot serialize the data to be sent to the client.A common cause is that one attribute's length exceeds the defined maxlength in the projection.To find more info, open Log Window or Debug Console, refresh and then check Network Tab in DevTools. In the response there can be more detailed information about the exception.        Url: https://XXX.ifs.cloud/main/ifsapplications/projection/v1/SupplierInvoicesForFinalPostingAnalysis.svc/ManSuppInvoiceSet?$filter=(Company%20eq%20%271000%27)&$select=Ide

Hello,What’s the best way to make a GL account inactive in IFS Cloud? The account must of course be retained as it has historical data and transactions but no new postings to it should be allowed (no manual voucher postings, not allowed to be use in prepostings and no postings to it via posting control)I set the valid period on it to expire but I can still add the account into a posting control.

Dear community, Each month we raise a voucher to manually accrue depreciation on some of our assets.  As the depreciation accounts are ledger accounts we process the journal as a Q voucher.  Unfortunately, we are not able to create an interim (reversal) from a Q voucher.Are you aware of any way to get around this so we don’t have to manually post a second journal to reverse the Q? Any ideas?  Thanks, David. 

Hi, We have recently gone live on IFS and we have a Sales team taking orders over the weekend. Where customers are outside of their terms, it is blocking the sales order from being released. I don’t want to increase credit limits, but will the Allowed Overdue Days enable the order to be released? Nobody in Finance works at the weekend so the orders can’t be released for production. Thank you  

Hello,  We used the the cancel matching functionnality of a  customer mixed payment. It created a CUPOA with the company at the company at the credit account, not the customer Then we tried to use this CUPOA to be matched with another customer invoice. We couldn’t find this CUPOA in the offset proposal. You will find attached to this message the postings generated and a screen where we can’t find our CUPOA in a manual offset proposal What to do to resolve this problem ? Any ideas ? Best regards.

Dear All,I am facing an issue while receiving customer collections through Mixed Payment. However, I am unable to identify the exact problem.Could you please look into this and provide a solution?  

Hi,I am creating a positive pay check file using ‘External File Assistant’ as below. When the file is downloaded in Online mode it works as expected, but in batch process an empty new line is added to the beginning of the file. Does anyone have an idea to get this line removed. Thank you in Advance!

Is there any possibility create FA object from a PO (using purchase group connect to an object group enabling FA creation) if the ownership of the part is company owned?If the ownership is company rental asset, this is possible.

We are on version 10 of IFS.  We need assistance of how to set-up the following payment term: 1) 45 days from ship date2) End of month of calculated date in step 13) Plus one day of calculated date in step 2 Example: Ship date 2/14/2025, plus 45 days equals 3/31/2025. EOM puts it at 3/31/2025, plus one day equals 4/1/2025Example: Ship date 2/15/2025, plus 45 days equals 4/1/2025. EOM puts it at 4/30/2025, plus one day equals 5/1/2025. Does anyone have information on how to set-up this up?