Solved

Hi!As I said in the title, I need to know which table contains a specific column. Would the following query work for that? What should I put in the from-clause? SELECT      COLUMN_NAME AS 'ColumnName', TABLE_NAME AS  'TableName'FROM        WHERE       COLUMN_NAME LIKE '%storage_instructions%'ORDER BY    TableName            ,ColumnName;

 Hi Experts,I can not create a Sales Quotation due to the below error. But, customer record has the tax code already available. Please help.    

I created a simple lobby with a single element that takes the count of a data source that filters Purchase orders by STATE = ‘Complete’ (Status, Shown as STATE within the Columns for some reason)Within the element designer i have “Use data source condition” ticked and when viewing the lobby from EE the link works. When viewing in Aurena i cannot click the link. Is there a reason for this? I Even on the Application owner account with full permissions it won’t work. The Element / Lobby are  both set to Aurena . 

Hi In request management module, while raising a new service request, there is a field location, how is it different from location region? 

Can we override this message which popup after the custom menu action 

Good Afternoon,Can anyone advise how the name appearing on the CONTACT field can be updated. This field automatically populates when the Work Order is saved during the prepare stage. The contact name also appears on the Work Record Sheet Signature . Many thanks for your help 

Hi everyone,  i try to publish a new custom field,  and i have this error   Someone knows how to Fix This Bug ?.Thanks for the Help.Regards 

Hi,for some of our users in different environments, users get wrong visualization of Schedule Board. See some examples below.   Example 3  Example 5 Any idea how to fix the issue? Thanks in advance for your feedback,~Juni

Hi IFS Community,i don’t understand this error. Can someone help me? 

We have set a tax code in customer set up as N but when raising an instant invoice for the customer another code pulls through. How to determine the default tax code when creating instant invoices?

Hi Team,In FSM, do we have any functionality which can assist in calculating the Travel distance (in KMs) for the distance travelled by Technician between the statuses ENROUTE to ARRIVED (assuming the GPS is captured at status changes)

Hi! FSM 6 u17.Webclient version 6.17.8126.18421 I’m trying to get the RSS lobby element to work in the webclient.It is working well in the smart client, but will not display anything in the web client, other than the header and the “root” of the link provided in the bottom of the element (provided in element designer eg https://www.example.com/feed/rss, shown in webclient https://www.example.com/) The “box” renders, but no information is presented in the element.We’re fetching the feed from our internal environment, and it’s properly formatted rss.Is there a known bug related to the rss-lobby element for the webclient, or is it not supported?web-client:  smart client: 

Hello, Does anyone know whether it Is possible to click on a lobby element for it to open another lobby element?  If so, does anyone have any information on how this can be achieved. Thank you. John

Hi,For a service order, you have a material demand You don’t have inventory,So you want to create a purchase requisition from the supplier to your own warehouse (you don’t want that the supplier ship the parts to the customer site).Could you explain how to do that ?If you click on external and then see the address displayed on “material delivery address”, you can see the warehouse addressThen Go on PR, set create PR and But when you save the material demand and see the PR, the delivery address used is the customer site and the delivery address of the warehouse.Could you explain how to do this process ?Thanks and Regardsanthony  

Have a parked customer payment that is causing an issue How can this be cancelled?

HI, In the previous V14 version, from the purchase requisition screen, when you open the communication center (email icon) to send an email to the supplier, you have an icon to open the inbox message (like outlook.)It was very useful, because you could send directly to your own inbox message an email to the supplier and receive the response directly in your inbox message.In V15.4 webBO, the icon is not displayed.Is it a way to have it again ? Thanks and Regardsanthony

Hi All,I’m new to delivery installations and applying IFS patching.So I thought to get your opinion before I go with a new one.Would it be possible to know the things I need to consider before applying a delivery/release? Currently, I’m considering the below before proceeding with the installation.Disk space Stop/pause the antivirus application Check invalid objects read the installation documentation thoroughly Start with DEV or Test firstKindly let me know what else I need to consider for a smooth delivery.I really appreciate your valuable suggestions/opinions and advice.Thank you in Advance.

We are trying to assign certificate and competencies to individual person but the windows shows no person , but there are many person in system , why this is so ? 

We are having issue releasing a CRO Repair to Shop Order  The following error keeps popping up  However, The Manufacturing Structure Alternate has been setup for the part.   Does anyone know what we might be missing? Thanks,Jelilat

Hi gang - where in Astea can I define the period orders are loaded on mobile? Somebody is very much behind on his work, and suddenly the orders were noe longer on his mobile...

Hi ALL,We we use the filers of dispatch console than also while allocating it shows all the users present in the system. How can we restrict number of resources when we try to allocate ?Below the screenshot. 

Hi community,I have a technical question regarding Beneficiary Name tag (<CdtTrfTxInf> <Cdtr> <Nm>). In BACS payments, the Beneficiary Name field is 18 characters. However, supplier name is longer than this. Has anyone managed to reduce IFS supplier name to 18 characters?Please see Beneficiary Name field in below link. Commercial Banking Online Support Centre (lloydsbank.com)ThanksFurkan

Is there a setting to automatically allocate a addres ID when creating a new address at customers/suppliers in Aurena?We now have to define it manually (which seems ok during the configuration), but once we are live this seems pointless to manually have to set a address ID.

Is it possible to set up a user so they can only receive Non Inventory Sales Parts and No Part PO’s

Only EN language is available on DEV environment in buildplace inspite of many languages is enabled.