Solved

How can we retrieve content via SQL query of the NOTES (not document text) for any entity that could have NOTES such as Customer, Customer Order, Shipment, Invoice, Supplier, etc.? Searched PL/SQL for API's and the database for tables/views but could not find viable candidates except for one API (basi1app.CUSTOMER_ORDER_API, that has several “get” options i.e. .Get_note_text(CO.ORDER_NO) or Get_Note_ID (CO.Order_no) .  Was unable to find a similar API for CUSTOMER NOTES, or other entities.   

Hi, How du I open a Oracle User Account that has been expired? IFS10 

Is there anyway in IFS to determine the parts and value of WIP at subcontractors?  Our finance group is being asked by auditors to substantiate the value in our GL account for subcontract WIP.

Parking an order prevents any shop floor reporting on the entire order. We need to process an order up to a point before parking it. Example, order is currently at op 10. Ops 10, 20 and 30 need to be processed, but we want to prevent op 40 from being processed. Is there any functionality to prevent a shop order from processing at a specific operation?  Thanks    

Hello IFS community,I have a code that sends an email to an user. From the IFS event, I know that I can create an event that sends an email and even create the link to the page in IFS using the rowkey by clicking “ADD URL” using the action type E_MAIL. See Screenshot 1 for more details about my question.  Screenshot 1- Code used to send the email - Screenshot 2 How could I add to the code (Screenshot 2) the way to generate the URL where the user can click on it from the email received and bring it to IFS, like it will work if I created the event using the IFS event action type E-MAIL (Screenshot1)?Thanks,JL 

We want to create a report on customer support orders and service orders to monitor who changed priority. We see every change in the trans log: new priority, SA & time but not from which priority the change was done.How can we know what was the original priority when the order was logged ? 

how to grant access to be able to edit the supplier electronic payment address?  

Hi community,with several of our customers we have agreed not to invoice freight for example. But our freight department want’s to have revenues to compare to cost.Usually we have one price for the whole customer order, even if having several lines.Now we are looking for a solution to summarize all lines and charges into one amount for the reports Customer order confirmation and invoice.One idea would be in layout / report designer to show only the first line using the total amount.Are there any other ideas how to resolve this?Thank you for your feedback!Regards Martina

Hi,I’m trying to create a manual voucher because I want to cancel an Approved voucher using a manual voucher. But when I try to use same accounts in Approved voucher, I’m getting this error.How can I grant permission for an account for manual booking as well.Is it possible to change Account and is it okay to do that kind of change?Please advise me.Thank you in Advance.

Hi All,One of the customers has an issue with the Pick_Customer_Order_API. Pick_Reservations__ procedureas it does not seem to roll back in full if it encounters errors during the execution.They encounter the error like below time to timeORA-20113: CustomerOrder.LOCKED2And sometimes, this may cause the issue of not fully picking the customer order.The customer does not care about the locking issue but they want to know why the IFS procedure (Pick_Customer_Order_API. Pick_Reservations__) does not roll back fully when any issues come as above.  They experienced this while using with third-party integration tool.Is there a way to handle the locked record issue in integration with full rollbacking functionality as the customer expected?Best Regards-Kelum

I can attach file in Customer Invoice. But other user get error message 'No attachment type enabled' when click button ‘Attachments’. I have add to them same permission set as me. Is there other settings need I do?We use IFS 8.Thanks in advance!

Hi ALl,Suddenly we are unable to generate position access , Access result is just blank . Having below error when trying to generate position access.  Any idea Please Thanks 

Does IFS apps 10 have the out of the box functionality to provide an all encompassing enterprise resource capacity / workforce planning solution, project management solution and reporting solution without the need to use supplementary software tools???I am currently using MS Project to build work breakdown structures that I can convert into a workforce / resource capacity plan and schedule and this is integrated with a SharePoint tasks application that I can push into PowerBi to create reports and what if scenario planning. I am aware that it is possible to integrate MS Project with our existing IFS apps9 and we are potentially upgrading to apps10 in the near future but my question is more to the point of if is it possible to eliminate any potential duplication of effort in regard to data processing and potentially use IFS solely as a an all encompassing enterprise resource capacity / workforce planning solution, project management solution and reporting solution as the single source o

Hello I would usually run the report below which is a 12 month income statement.     However there is a an account that doesn’t show, account 8060, which is a new account that was created to replace account 8055.  There has been activity in account 8060 so it should be a part of the income statement.    Would anyone have an idea of why the account is not showing in the report and how to fix?  Any assistance would be much appreciated.  

Is there a guide to supplier setup within IFS to help facilitate 1099s? I see in the Supplier Setup where a TAX ID can be entered, but am wondering if there is a way to indicate that they are eligible to receive a 1099? In other ERPs used in the past there was a box you checked to indicate the supplier should receive a 1099, then at year-end a report could be run for all 1099 eligible suppliers with the total spend for that year making the creation of the 1099s much easier.  

We’ve setup Astea in English for all our users, internationally.In Employees Security, you need to select Regional settings for Mobile Universal. Were can I find wat is the difference between the selections ? Specific for those settings:1003 Belgium/Dutch 1004 Belgium/French 1012 France/French 1036 Nederlands/Dutch 

I am seeking answers to belowWhat is the source of the translations in the PSO software(especially French Canadian)? Is there any additional software used?  Any additional info on PSO 6.8 language translations that can share with the customer.Thank you and Best regards,Darshana

Hi, we have the requirement to use ISO code XI for intrastat trade reported, coming from Northern Ireland. Is this code been implemented as ISO code in IFS? Also the code for UK (ex Northern Ireland ) XU, can be used instead of GB. From what we understand only Northern Ireland (XI) is to be part of the Intrastat reporting with other EU members, so the code is needed. Any fix for this to install?Guidance on the Use of GB and XI codes (Annex B) (europa.eu)

When we move from a Java Print Agent to a .NET Print Agent, how will the performance compare? Will we want a larger server to run the .NET Print Agent? Are there recommended specs?

Hi All,I have to compare the distance  between task geocode(lat,long) and place(lat,long). Based on the distance( let’s say 300mtr) I need to enable one user_def field. Can anyone help me on this. Is there any out of box feature available? Can anyone help me on this? Thanks & RegardsRajat

Issue: CRM Companion 10 Java errorSteps:+ Use an Android (11) device and login to the app+ Following error can be seen upon clicking on Connect (before the login screen)Exception of type‘Java.Lang.RuntimeException’ was thrown.Note: Issue not visible in Android 10 for the same TAS Did anyone come across such error if so, have you figured out why?

Is it possible to automatically stop the clock in a Customer Support Order when you open a second Customer Support Order in the same browser ?We often have the situation that a helpdesk agent solving an incident in a customer support order is interrupted by an urgent (emergency) call. Than he opens a second customer support module in the browser to handle that urgent call. If he didn’t manually pauze the clock in the first order, then the time registration in the first order will not be correct. 

Facing the error while changing the due date of the customer invoice. We already Excluded invoice from reminder proposal.Still facing below issue  

Good dayPlease see the above pictures for the resource duplication. During team setup, the team member’s Resource ID was changed. The user was not deleted in either FSM or PSO when the Resource ID was changed. Now the user shows up in PSO with both the old and the new Resource ID. Tasks does not get scheduled to the old Resource ID, but they both show in the Resource planner and the PSO Schedule board. Is there a way to prevent this duplication, or will it be a manual process of removing the old resource from the Team in FSM, as well as removing the old resource from PSO and the resource planner?  

We do not use States/Provinces when importing sites, it is also not defined as a mandatory field. The site import site went through in 2 steps: first with GIS validation on, which results in some sites with an address validation error and second step, the errored sites with GIS services off. But when importing the site contacts, we got errors on some sites in Italy and Swiss: The “state Lombardia is not in country IT. Please use lookup. -(API Error)” It was only on some sites, not on all sites imported in this countries.Why this error on a non mandatory field ? And why on some sites and not on all sites in the same country ? We imported sites in several countries in Europ.The only way to continue was to create the requested states for Italy and Swiss.my next question is where can I find the correct way to import the sites ? I found out that I had to use the same syntax the error showed.