Finance (Financials)

Hello,Has anyone run into the problem where the month-end General Ledger inventory balances do not equal the balances in the perpetual inventory?Thanks.

Hi all,For customer masterdata it's possible to fill in an expire date on the order tab. When entering a Customer Order you will get an error message that the customer is expired. However when entering a Sales Quotation for the same customer no error message appears .Is there a possibility for a expire date for the quotation as well?thx !Regards,Martin Broekman 

HiI do not want to use RMB and voucher information .I want to search the advance search and write a command and join tables and fields between a few days (for example 1/17/2022 to 3/12/2022 for the date of the document) 

We are in the process of implementing ACH in IFS Apps 10 and we have everything working and have sample output of the ACH file.  Reviewing the specs from our bank, we need to make some slight modifications to the output.  Where in IFS can these changes be made?  I’ve searched all over and can’t find where to make these types of changes.Thanks in advance!

Hi, I have to set up the parameters for CAMT053 for banks. I’m not sure which type of message code I need to use:The XML file from the bank contains 3 ISO transactions types (Domain/Family and SubFamily) plus a specific BAI code. Extract from the XML file:I firts set up the Family code (ie; ICDT in this example) but it was not recognized when I upload the bank statement in the External Payment. It doesnt’ seems to be useful, as only the specific BAI code has been fetched.Do I have to delete the Family code and enter the BAI Code instead?Example from another file after I set up the BAI codes in the external payment parameters:Does IFS automatically recognized the Do

We adopted the the advanced invoice process for our CIA customers.However >50% of the time,  the original order is modified:Quantity changesFreight Changes or add freight costPricing changes It seems the only way to deal with this is to credit the advanced incoices, net them, and create a new advanced invoice.  SO...we wait as long as possible to create the advanced invoice (after we finalize the amt),  but we often get payments before the advanced invoice is created and pt them on account.  Either it is a lot of work.  Are there any creative ways to revise advanced invoices ?  Or other ideas on how to deal with this ?

Hi there!My client using IFS10. We performed the Year End Process and we faced an issue. Indeed, we got a gap in our result and this gap is exctacly equal to our “simulation voucher”. For reminder, “simulation voucher” are used to get automatic reverse voucher. So then, those voucher have to be part of the result of the year end and I don’t understand why the system exclude those vouchers?Could you please assist?

Dear Community, Could you please explain why the below error appears when deleting a site in IFS Cloud?  I was trying to delete extended site info.  

We have setup the application defined event to trigger Emails for Invoices to Authorize. But when users receive them in the mailbox details are concatenated and seems messy. Is there a way to rearrange the “ &MESSAGE_TEXT “ to show one invoice per line? 

Hello - I am on IFS10, update 13.  I am trying to mark an instant invoice as an advance invoice.  I have accessed the advance invoice reference box via the RMB on the general tab of the instant invoice.  What is this screen supposed to do?  It is asking for an invoice series ID, invoice no and amortized amount.  I can select series ID AD with the list of values.  The other two fields do not have anything in the list of values.  I do have an invoice number series set for series ID AD.  It seems like I missed some setup data somewhere.  I would appreciate an information on setup and creation of the advance invoice.Thanks for your time.

 Hi, I don’t known what is the interest in using  currency balance when you have  a base currency in EUR for example? NB: the code part j for this  is mandatory when you create a company.Is  it  not interesting just  for parallele currency? Thanks a lot       

Is there a report that can be used to compare supplier invoice due date versus the actual pay date (to measure invoices paid late)?

Hi all, We are enfacing an issue with pre-postings. I don’t understand why the pre-posting values that we had added to the PO were not carried forward to the Good Receipts and Goods Issues screen?This is applied for Inventory Parts.We would like to know whether this is due to our setup issues, or if this was caused by a system bug.  Thanks for help!Regards

in our system there is error in distribution and manufacturing posting analysis.the posting control is M1 and there is no project in the error transaction.the error message is “Wrong requirements for account 11308003. Please check code part demands.”the account 11308003 project code part is Can and the account was defined in the project cost/revenue element as dir-5 please advise 

Hi All, Can someone please advise how the OPEN_DOM_AMOUNT currency rate is calculated within the report - CUST_AGE_ANALYSIS_REP? Thanks and Best RegardsMadusha

how does the line item matching on the posting proposals work?  We are working on brining in supplier invoices via EDI and would like to take advantage of line item matching.  How are price/quantity differences handled?the attached screen shot shows a supplier invoice where the price on the PO is different from the price on the invoice.  Can this be automated?

Topic was raised on behalf of LCS case G2325223  BTL91 file format will no longer be accepted from 1st September 2022.  It is being replaced with the new standard PAIN file format - PAIN.001.001.09.  Please provide support for the new PAIN file format in IFS

Hello, I wonder if anyone has set up Intangible assets amortisation in Aurena.We have a client who is collecting projects costs against an intangible asset, which needs to be a ledger account to enable project capitalisation via posting control GP3.We need to amortise this intangible asset over sales of the finished product so are considering setting up in Fixed Assets as an acquisition account.Is there a better way to achieve this?Kind regardsGlenda

REP_INSTANCE PARAMETER and requirew a value.please find attached error.

Hi all,Is there a way of outputting a SEPA payment to CSV formatted .txt file in IFS? This is setup for Bacs payment currently. If anyone has the process of how this can be done/or confirm how to it would be much appreciated. 

Hi Everyone,  I have an issue on Aurena (21R1) concerning the customer offset proposal. I want to do a partial matching concerning an invoice and a payment on account (CUPOA) For example my invoice = 1000 and my payment = 500  When i try to use the path menu “customer offset  proposals” then “new proposal” even if i used “manual” (i can’t mentionned an allowed difference) or the other (i can mentionned an allowed difference but i can’t validate my offset → I have the pop-up but i can’t finalize it)   I saw on the community that we have to tick the box “allow write-off for partial payment” in company path menu :   Even if this setting nothing ha

Dear Team, Is there a way to automate the posting proposal authorization? Best regards,Thakshila

We are having trouble with the background job that posts the journals. The error received shows:‘User group XXX is not connected to voucher type  with function group L for accounting year 2022 in Company XXX’What is strange, is the fact there is a SPACE after the ‘voucher type’. I would normally expect to have a missing entry in the user group for that specific voucher type. However, as there is no voucher type showing i dont know what is missing!Any ideas 

Community, we have an issue, not sure how to handle. one purchase order line, qty 1, price 7000 for example, but supplier come in invoice twice, first time 3000, the second time 4000. now the invoice matching is done for the first supplier invoice, when the second supplier invoice 4000 come in, there is no record showing to match with. Need to manually enter the 4000 cost bookings?kindly advise how to handle this kind of scenario? 

Is the report generator available in Aurena?We are trying to access and rebuild some reports using Aurena but we cannot even find the report generator.