Finance (Financials)

We need to import mixed payments and have it matched the invoices including installments. We are looking at using the External Payments and want to see the process, templates, and best way to import payments and match to invoices from the bank file.Appreciate assistance.

Our AP users like to know if there any option for ACH payments that  we can use one invoice per payment. Meaning we don't want to include multiple invoices in one payment.For check payments we know there is an option  "One Invoice/Prepayment per Check".  We are asking if there is a similar option for ACH payments as well.  If so then we like to use that or "One Invoice/Prepayment per Check" is applicable to ACH payments as well ?  The supplier screen shot is attached below. Thanks!Janani.

We are trying to gather information regarding handling credit card refunds. Currently in our apps9 version, all credit card transactions come into IFS as a check. Refunds do not create ‘negative’ checks within IFS. Each day we get a statement of the deposit and charges we get from our banks regarding credit card transactions. We then enter that gross total as a mixed payment that writes to a GL account. We then cash the checks generated for that same day to balance out the deposit mixed payment. However, if there were refunds the total of checks to be cashed that day will be more than what has been deposited and in turn, we create a manual mixed payment for every refund to ensure that the deposit total is the same as the total of the check cashing.Does anyone know of a capability of creating “negative checks” from a refund. If that functionality was possible, it would eliminate the need for creating the individual mixed payments for each refund.  We have tried to create “nega

Hi,TIA, Chris (APPS9)

We are facing a issue where IFS shows and Vertex shows different tax amounts for Customer orders.We user Vertex to calculate tax for US and Canada but recently we noticed that tax values are different when comparing the IFS and Vertex values. When digging down further we notices that CO invoice number that's mapped with vertex for document number stores the same invoice number for every Customer order. Is there any log we can check what was sent by IFS to vertex? If so, where can I find it?  Any advice on what needed to checked? Coz I tried finding documents related to Vertex integration in IFS Application 8 but only found the installation guide.  Best Regards,Ruby

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.