Finance (Financials)

Hi Community,i have a question in IFS Cloud regarding “how to query with multiple criterias in list view tables”. e.g. if i want to get in customer invoice analysis all customer invoicesexcept customer-no 2999999% ANDexcept customer-no. 5% I did not manage to get in basic search the expected result with entering attached query.  My workaround was to enter in advanced query attached search, which shows my the expected result.  If I switch from advance query to basic seach result the query is transferred in the way i e

Hello,Is it possible to automatically block a customer's credit if they reach reminder level 4 with an invoice? Reminder level 4 is the highest level for us.When I look at the reminder templates, I don't see any way of triggering such an automatic block by reaching reminder level 4. I could have imagined that there would be a way to initiate such an action. But perhaps I don't have the necessary authorisations or there is an option elsewhere (company & location).Do you have any ideas on this? or would it be possible via an event? Thanks for your support.Maren  

We have successfully migrated credit card data into the Credit Card Transactions module and created an expense. However, we are facing challenges with the financial process—specifically, understanding the steps to finalize the process and handle bank charges.

I am trying to run cust_age_analysis_rpi.Cust_Detail_Age_Analysis in pl/sql to generate the archive data for it, and then I am going to pull it into an SSRS report. I had done this years ago at another customer and this code worked, but not sure what I am doing wrong now. Getting this error.“end;Error report -ORA-20111: Archive.FND_RECORD_NOT_EXIST: The Archive does not exist.ORA-06512: at "IFSAPP.ERROR_SYS", line 140ORA-06512: at "IFSAPP.ERROR_SYS", line 366ORA-06512: at "IFSAPP.ARCHIVE_API", line 845ORA-06512: at "IFSAPP.ARCHIVE_API", line 849ORA-06512: at "IFSAPP.ARCHIVE_API", line 235ORA-06512: at "IFSAPP.ARCHIVE_API", line 240ORA-06512: at "IFSAPP.ARCHIVE_VARIABLE_API", line 1285ORA-06512: at "IFSAPP.ARCHIVE_VARIABLE_API", line 1294ORA-06512: at "IFSAPP.ARCHIVE_VARIABLE_API", line 1327ORA-06512: at "IFSAPP.ARCHIVE_VARIABLE_API", line 1331ORA-06512: at "IFSAPP.ARCHIVE_VARIABLE_API", line 1745

I matched three invoices in the Supplier Check window and successfully created a Supplier Check. However, when I navigated to the matching details of the Supplier Check, all three invoices were visible, but the Voucher Type and Voucher No fields were not displayed.Could you please clarify why this is happening?Application Service Update: 24.1.4Framework Service Update: 24.1.8Please refer to the attached screenshot for reference.  

Hello again,I’m trying to create a Persistent Custom Field (Boolean) in Preliminary Supplier Invoice screen to identify some feature for a newly created invoice. The process goes smoothly, CF is published without errors, but when trying to create a new record with the checkbox ticked for this CF, system displays the error: In DetailsServer error messages:809f34f0-4b7d-4301-a0a3-6578e0a9262dIfs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: ORA-01410: invalid ROWIDFailed executing statement (ORA-01410: invalid ROWIDORA-06512: at line 16ORA-06512: at "IFSAPP.MAN_SUPP_INVOICE_CFP", line 699ORA-06512: at "IFSAPP.MAN_SUPP_INVOICE_CFP", line 578ORA-06512: at line 10)   at Ifs.F

Hi,I am seeking some general advice and insights regarding our transition from IFSAPP10 to IFS Cloud.Currently, we utilise all 10 of our defined code strings within our accounting rules. While I won't delve into the specifics of each code string, I can confirm that they are all essential for our business requirements (details can be provided if needed).We are concerned that this extensive use of code strings might pose challenges as we migrate to IFS Cloud. Therefore, I have a few questions that could influence our decision to either re-implement or upgrade:Is it possible to repurpose one of the optional code parts we have defined for future use? What impact does using all 10 code strings have on our system, aside from limiting future requirements? Is there a way to use more than 10 code parts (either standard or customized)? Are there any guidelines or recommendations on the number of code parts to define within a string?

Hi CommunityIn the process for Clear Revenue/Cost Balance, IFS is currently configuring with the GP8 Posting Control based on a Fixed Value.We would like to use the “GC3 - Ledger ID” control type for add a 2nd option (One in case of profit, one in case of loss)I can’t figure out how create a new Ledger ID to use it correctly, could you please help me to solve this problem ?If you have another idea to solve this problem it would be perfect.Regards

Hello,  Is it possible to import and external supplier invoice as an advance invoice ?  Best regards

In reviewing the technical documentation for IFSCloud 22R1 for Avalara integration, the Basic Data Setup notes that "the company id you are using in IFS also needs to be registered in Avalara Sales Tax Software".  Can you please clarify where this company id resides in IFS Cloud?  Is it the value highlighted in the screenshot attached?  We have an existing Avalara account which we are trying to migrate into...and we have an existing company ID in our IFS Cloud setup.  They do not agree...I am hoping that there is somewhere ELSE that we can define our company ID.

Hi All,I would like to get assistance regarding making of lease payment. We have created a lease contract which is in Active Status.We also have performed the below. Lease Accounting Periodical Proposal Lease Accounting Payable Proposal However, we would like to know what the are the available methods to make payments to the Active Lease contracts by connecting the Lease contract Type.Motive is to understand how the payment will reflect in the Lease Accounting Balance Analysis/ the changes that would happen in the Amortization schedule after making the lease payment? Best RegardsRazan

Does anyone know if there is a way to block or prevent certain code part combinations?  For example, we have a department that we use strictly for balance sheet transactions and that should never be used with certain general ledger accounts.  IFS currently allows us to post transactions to any combination of our code parts and we would like to set something up to prevent errors.  We did think of using automatic GL posting rules, but there are so many combinations that could be used I don’t think that would be feasible unless there is a way to group something.  Let me know if anyone has any suggestions!

Hello, I would like to double check how the customers should be correctly set up in the delivery tax information screen when the customer sits in a EU country and we are shipping and invoicing goods to them according to the VAT — Directive 2006/112/EC — Article 138(1). Should the tax liability EXEMPT or TAX and where should be the correct tax code be set in taxes or in tax free codes?  Thanks, Philipp  

Hi, I have activated an Additional code parts and  Additional Code Part Values is filled.  I need advice: How I can connect values of Additional Code Part with account in cart of accounts? I need to set this additional segment as blocked/mandatory/can for a revenue account.Thanks in advance for the advice.Jaroslava 

Long story short, we are running 23R2 upgraded from version 8, with Weighted Average. Revaluation events cause SERREN+/SERREN+ to be not balanced. What seems to happen is at the first revaluation event that the system creates new M191 postings instead of all the old M3s. The result is that the accounting does not balance. M1 and M191 balances though. Removing the old M3s seems a bit unorthodox since they also have voucher numbers. Question:Is it safe to remove faulty postings (thereby removing some of the sequence numbers for a transaction)? Is this a known problem already? We have looked at corrected bugs in the upgrade script. However the upgrade script changes the posting control basic data from M3 to M191, but does not update old transactions.

?

Dear All,Kindly requesting your valuable advice,I need to configure exactly below mentioned routing rule in the IFS cloud. Bizapi method is rest but I get errors. Name has no usable addressReceive-e invoice routing addressAll the basic data/message set ups are ok Supplier , company , Assocation no & other parameters ok.  External supplier invoice parameters are ok Only issue is with the routing address.RegardsNaadira

HelloWe have a customer who is allowed 120 days (!) to pay their first SBP instalment, and 30 days thereafter. For example: 30% on receipt of order, paid in 120 days  60% on delivery, paid in 30 days  10% on acceptance, paid in 30 days Can this be built into a payment term (thinking about free delivery months) or would a customisation be required? Many thanks!  

Hi,Has anyone encountered the issue below with Avalara or Vertex integration?The U.S. has several states that calculate sales tax based on the seller’s origin. For origin-sourced sales, tax is applied where the seller is located, while for destination-sourced sales, tax is applied at the location where the buyer takes possession of the sold item.Currently, IFS sends address information to external tax systems (Avalara or Vertex) based on the customer order details and header information. This approach works well when the customer order is created at the same site from which the inventory is shipped—for example, when an order is created at Site A and shipped from that same site.However, issues arise when handling drop shipments within origin-based states. In such cases, IFS does not provide accurate address details to external tax systems. For instance, if Company XYZ has two sites in Illinois located in different counties, and Site A receives a customer o

Hi Community,We are in the process of reviewing our options to comply with upcoming Singapore GST InvoiceNow Requirement. Any of you know have experience in this area?We are currently using IFS Application 10.Thank you. 

Hi All,One of our UK Customer's mentioned that , Citibank have now shared the requirement (see the attachment) that is mandatory from 1 May 2025 to capture purpose codes for CHAPS payments in the UK in line with the ISO 20022 standard. Do anyone of you have any idea about whether we need to do any changes/development for APP 10 IFS Customers ..? or IFS  has issued a new correction to comply with this UK requirement. Appreciate your prompt reply.

Check Recipient is not specified for one or more items included in the payment order. Select Check Recipient for those items in the Payment Order Details window to proceed.

Good morning,I am testing the use of Multi-company allocation and on the CA voucher there is no Currency amount.I can see the Base Amount and the Parallel Currency Amount, but no Currency Amount.Am I missing something?We are working in IFS 10 UPD 16. Thank you,Cora

Dear All,Appreciate your valuable advice on this:I have set up the inter-site process e-invoice in ifs cloud version and but now the final part which is final automatic generation of manual supplier invoice is pending. Giving me this application error message. “ Name has no usable address”Initially in app 10 receive E-invoice routing address was created as bizapi method. Now in cloud I have created as Rest method. Still, it gives errors.The routing rule with the receive and send addressesReceive e-invoice address with the rest method, s

Hi, I'm getting below error when sending verification proposal :Parsing Error : Element '{http://www.govtalk.gov.uk/CM/envelope}GatewayTest' has a value which does not match the fixed value defined in the DTD/Schema. Also what is the connection with the outgoing load file ID and response send to HMRC ?Your advice is highly appreciate. Thanks.