Finance (Financials)

Does anyone have a SQL statement for the Customer Payment Check for the Laser Check.   We have a Crystal report that is only considering Supplier Payments.   I can get the check to print out on the IFS Standard Report so trying to figure out why the Crystal report is not printing the Customer Repayment Check.  The IFS Standard report looks like it uses tables Supplier_Checks, Suppplier_Check_Items, Supplier_Check_ItemHere is our Crystal Report SQL Statement. SELECT "SUPPLIER_CHECK_TRANSACTIONS_"."PAYMENT_AMOUNT", "SUPPLIER_CHECK_TRANSACTIONS_"."DISC_AMOUNT", "SUPPLIER_CHECK_TRANSACTIONS_"."FULL_AMOUNT", "SUPPLIER_CHECK_TRANSACTIONS_"."CHECK_AMOUNT", "LEDGER_ITEM_SU_QRY_"."VOUCHER_NO", "SUPPLIER_CHECK_TRANSACTIONS_"."SUPPLIER_NAME", "ADDRESS_DEFINITION_V2_"."ADDRESS", "SUPPLIER_CHECK_TRANSACTIONS_"."PAY_DATE", "SUPPLIER_CHECK_TRANSACTIONS_"."CURRENCY", "LASER_PRINT_CHECK_REP_"."CHECK_NO", "LASER_PRINT_CHECK_REP_"."RESULT_KEY", "SUPPLIER_INFO_ADDRESS_PAY_LOV_"."DEF_ADDRESS" FROM   ((("IF

Hi Team,I want to convert a Manual Supplier Invoice into pdf format. But unlike, Customer Invoice there is no Print option available for printing it. Request you to please guide me regarding this. Best Regards,Rakesh

My client needs to create objects for already depreciated assets and show in the GL which has zero value. How can do this? 

Dearsthe auditors want us to close 2021 and transfer the balances to 2022i already closed all accounting periods;what is the next steps. 

Hi community,We have requirement where some invoices are due on a specific date of the year. Eg- 31.05.2022. Is there a way to to set a specific date in the Payment Terms.Thanks

Hi The customer wants to distinguish the imported supplier invoices by the person who scanned the invoice. Now i was looking for a field in IFS on the external supplier invoice and i came accross the following Field (Our Reference) Now i checked the mapping and used the BuyercontacPerson Name This is how the xml TAG looks like now When i check now the external supplier invoice i dont see the value in our reference field (see first printscreen). Any Idea what the correct TAG is named or is there any other field i can use in order to import some free information onto the external supplier invoice? Best RegardsSophal

I want to write test cases as per requirement related to tolerance limit which is set in company screen.can you please help me to suggest how to check basic data setup for the same.  

We have noticed that the Notify me functionality creates A LOT of background jobs. Since some of the background jobs takes minutes to execute it causes delays of other background jobs - to the extent that nightly jobs are running one day too late.  Workaround for now: Remove all background jobs regarding Notify me and disable the events with a description starting with Notify Me.  However, if we want to start using the Notify Me app we can’t use it in the current state.  Observations: Notify Me - Register Supplier Invoice notifications. - sometimes takes 5 minutesNotify Me - Refresh Markdowns for Supplier Invoice. - sometimes takes 10 minutes We don’t have a lot of invoices but still these background jobs cause hours of delays in the Default background queue.  Request 1: Will IFS tune the performance of the mentioned background jobs? With the current performance I can’t understand how any customer can use it. Request 2: Please advise, is it possible to have the notify me events running

Hi,few sales invoices/credit notes raised for US customers went to the tax transaction wrong way round (postings to GL are correct) and required manual adjustment before VAT submission. Cannot work out the reason. It happened to few invoices under different customers (but it does not apply to all invoices under one customer). I’ve tried to find any sort of pattern (by customer, by type of the invoice etc.), but failed. Did someone have similar issue? 

HiThe customer asked me what the Tax ID Type is good for? I cannot find the logic behind this Field. Some time i can enter a Tax ID Number without the Tax ID Type and somethimes i must enter the tax id type. What is the field good for and whats the impact on the system? Best RegardsSophal

Hi,In cloud21r2 I am creating serial objects based on a customer order for a sales part with Create SM object checked.In addition to the customer order line I am adding a charge line for freight connected to the customer order line. But when I deliver the object and the serial object is created, the acquisition cost is only the sale price on the customer order line and does not include the charge.Does anyone know if charges can be added to objects cost?Thanks

Hi Team,I have few  doubts about tax liability I have created Customer the tax liability it tooks default  EXEMPT The same order i am trying to create RMA but here the tax liability taking as a TAXHelp me to understand this 

Hello Teams,I have got an error message which I don’t understand, can any one tell me what it is about and help me how to solv it?kind regards,Esayas

We disposed an object today and selected the wrong reason.  Writeoff instead of Theft was selected.  Is there any way to update this or undo the disposal so we can do it again with a more appropriate reason. 

Hi everyone, We are getting the following error of Voucher is not balanced.  The supplier invoice is balanced at “balance” but not at “currency balance”:  Reading multiple topics, the possible solution is IP28 but this posting is not triggered. And yes, we have the option activated at company level: And IP28 properly configured at posting control level:  Does anyone knows how I can solve these problems? They are bit annoying and we could not use this functionality because it seems that it does not work or we are doing something wrong. Kind regards.

The general IFS functionality in Automatic authorization of supplier invoices is that the system compares the invoice value and receipt value when deciding to automatically authorize or not (this is specifically for non inventory purchases and may be true for inventory parts as well).  as an example if the PO value is 100, receipt value is 110  and the invoice value is also 110, the system automatically authorize the invoice without any need for manual authorization. if a tolerance is defined as 3%, the invoice will be authorized automatically as long as the invoice value is between 106.7 and 113.3 (+/- 3% from 110). This means system disregards the PO value and only considers the receipt value.The customer I’m working for requires that if the invoice amount is higher than the PO amount, the system to not to automatically authorize and require to be manually authorized. so basically to compare invoice value and PO value rather than the  receipt value. is there any setting in the system

Hi, I would like to import a budget version from a file (like Excel) to IFS. I noticed the functionality ‘Import From File’ in the menu Budget Versions. But what is the correct file template for IFS to import the file correctly? I tried some Excel files with different formats, but IFS does not import the data correctly.   

Community, Is there one screen that I can use to see the supplier invoice date/receipt date and the payment date?  The screen AP Analysis shows the date entered however not the date the payment is made and the arrival date looks like the date AP entered the invoice into IFS.  I would like to be able to see this without going to many different screens. Thank you.

Hi,The payment advice email is sent to the supplier when the payment order is created. This is not accurate as the payment will sometimes sit in the bank not approved for a week (this may take a week to approve).  The payment advise should be better generated at the stage (acknowledge supplier payment order) because this step is confirmed when the payment has left the bank.Example: We use payment advise ‘At Create Order’ Is there a way to do this in IFS 8 other than just checking the automatic acknowledgement when the order is created? Any suggestions about customizations? please advise.Thank YouNimesh

Hi Team,Which Posting Control should I use to handle Charges like Freight, Custom Duty etc used in Purchase Order window “Charges” tab.I have a specific account for the above charges.But I have no idea which posting control should I use to connect the same account.Request you to please guide me on this.Thanks in Advance.Best Regards,Rakesh Rout

HiWe have a client legacy asset operations system that uses projects, work orders, operations transactions and work breakdown structures under projects.  The operations transactions are basically executed work orders eg drawdown of inventory or time to perform a task.  Each operations  transaction occurs against a work order. Each work order is linked to some part of the WBS which belongs to a particular project. The system then translates the transactions into financial transactions and sends these to the GL system.  The financial transactions are cross referenced to the WBS and the work order. The legacy GL is to be replaced by IFS cloud. The operations system needs to interface to IFS. Can we replicate projects, wbs  accounts, financial transactions in IFS so that we match the legacy operations system?  We were hoping to use the projects/sub projects/ activity code and put the WBS codes used in the operations system into the activity code. Can this activity code then be linked to th

Hello, Does anyone know if i can create more than one PO under the same workorder using IFS? If so, how can i do this please? Thanks

I was looking at the IFS Credit Card Interface Guide and I saw on step 3 Administrative Tasks that it talks about scheduling the Key Renewal.  Is this something we should be doing?Is there any reasons we should not be running?Does it cause any issues with the Paypal Credit Card Interface etc.?How often do you recommend?3    Administrative Tasks 3.1    Scheduling the Key renewal  It is recommended to change the key periodically to improve the security. IFS Credit Card installation comes with preconfigured Key renewal features. However, you need to modify the task details for it to come to full effect. Pleas follow the following instructions.Go the Database Tasks (Solution Manager/Configurations/Database Tasks/ Database Tasks) and right click on the Change DES3Key Task. 

Hi everyone,I’m creating this post on behalf of Ieva based on a case reported to support Services. Please help Ieva on the below mentioned question or the request.“Question: Please share the validations for Supplier Payment Details that IFS performs when a BACS payment is done.We'd like to check all the validations from the technical perspective that take place when a file is generated after the payment proposal but only relating to the supplier payment details.This is required because customer is using an XML file now to do the BACS payments (due to changes in the bank) but the same checks do not seem to be performed. They can be introduced with the preparation of the file - but I cannot see what the technical checks in relation to the supplier payment details are. Test plan:1) Go to Payment formats per Company2) Enable BACS payment format3) Add a payment method BACS and link it to payment format BACS4) Go to Payment Institutes - RMB and select "Payment Methods per Institute" and add

Environment - IFSAPP10 Regional Test CMB Internal IFS EnvironmentI have used the below employee with the below message setup. Next, I have selected a customer invoice of this customer and selected Resend Invoice. Media Code selected as ‘Connect’ A record is created in Search Connectivity Outbox Messages. However, an Application Message is not created in the OUT Folder.Is this a bug or the standard behavior? Is there any way we can change the setups to create the application message?