Solved

Hello ,I would like to extract all the rows of my query result in the SQL query tool, but it only allows me to extract 10000 rows.Can anyone help me with that? .(I’m on IFSAPP10) Thank you 

Hello Experts,Could you please assist me with a concern related to the FSM mobile app?A customer has reported that some users need to reactivate their mobile device, and I have attached a screenshot for reference. I have been advised to delete the mobile record from the PERSON_MOBILE table as a workaround. However, I would like to understand when and how this is happening, and if there is an alternative solution to allow the affected users to access the app without deleting the record from the PERSON_MOBILE table. Would appreciate any assistance you can provide.Thank you and Best Regards,Aathi

I am getting syntax error when trying to join SQL query with IAL table. Any clues??  select order_no, order_date from( select *from ifsinfo.icfr_pro_116bwhere project_id = '20012') X join IFSAPP.purchase_order Y on X.order_no = Y.order_no  ThanksHousseiny

Question from my team (I could not immediately find anything): is it possible to do a mass-deletion of Contacts? They would like to delete all contacts that are Inactive (several thousand)

Hello Community,Currently, the production planning department has a very interesting question.They want to know (and of course see in IFS) how long a shop order will block a certain physical production area.Example: Shop Order 12 occupies all of room B and one-fourth of the production space in room A. The scheduling of the production area is of course also related to other shop orders and can therefore not be assigned to the article in a fixed manner.In other words, another resource that can be assigned to the Shop order and is focused on the shop order start and end dates would be required.My first thoughts were on the work centers. These, however, are less flexible because they are assigned to a operation in routing.The concept to (mis)use machine utilization for this, given that we don't use machine hours, also originated in the department. Do you have any implementation suggestions? Or is there a module we are without? Thanks for your inputs! Best, Lidija

​Hello everyone,I get an error message when I try to load migration job (detail) or to execute job with my personal user in Cloud:How can I assign this privilege to a user?I cannot find it in the list:Thanks for a feedback.BR,Jan​

Hi, all,In my test pass of upgrading IFS9 to IFS10, I found the IFS connect for our EDI message stopped working, it just did not pick up the xml files as in IFS9.   The original setting in the FTP Reader, Routing Rule and Routing Address looked normal, but after putting the uploading xml file in the FTP site, nothing happened (In IFS9, the uploading files will disappear within minutes).  And there were no any messags under Application Messages, either error or successful.   Could anyone shred some insight to me ?thanks in advance,David

How is the duration of a downtime clocking calculated? Is this determined by the calendar on the Work Center, the Manufacturing Calendar on the Site, or something else? Is the available/theoretical capacity of the Work Center Resource accounted for?

We do a lot of manual dispatching, and the dispatcher will typically sort the Unallocated orders in the DC by ZIP or ETA (or other criteria). If they find 10 orders with the same ZIP they want to dispatch they drag and drop this on the SAs timeline. If they are not quick enough to select the next order, the DC will resort the Unallocated table, and the dispatchers have to scroll down again from the top (it takes 3-5 seconds before this happens). Any idea if we can change the time it takes before this happens or something?

I have the exact same Excel Migration Job over BUS_OBJ_REPRESENTATIVE in our DEV and TEST environments and they do not perform the same.   The migration job in DEV will perform a modification as expected and return the “Updated” result.The migration job in TEST will not perform the requested update and returns a result of “Business Object Representative already exists”.   of course it exits, I want to update the “Representative Type” associated with the record.We have check all permissions and have no idea what would be causing the difference in functionality.Any help is greatly appreciated. Sincerely,Vince

Community, after shop order splitting, the production line no is missing in the splitted shop order. screenshot see below, is this a bug?original shop order qty 3, you can see production line 10split into total 3 ordersyou can see the production line no is missing for split orders 

Users are getting an error message on Astea mobile login page. “error is reported by network login process”The page cannot be displayed because an internal server error has occurred. 

Hi,in work task with workorder connected to projectis it possible to have invent order by default instead of project order ?because my stock is not on project.Regards

Whenever I start the Visual studio in a Remote machine the below error is getting popped up due to which the layout is getting zoomed out and the size of the fields increases, basically the RESX is getting affected for this.Also I can see that this extra line of code is getting added Please mention how to resolve this.

Hi I am extracting data to PowerBI.I want to extract cost of sales and revenue for all customer order shipments.I want to combine shipment & order line data with GL voucher data (account, sales group) We are on Apps 9.I can’t figure out the links to do this.I want to start from closed/completed shipment lines.  COST OF SALES:SHIPMENT_ORDER_LINE_OVW → links to → SHIPMENT, CUSTOMER_ORDER_LINE & CUSTOMER_ORDER using shipment_id, order_no, line_no, rel_no & line_item_no. Easy!INVENTORY_TRANSACTION_HIST2 → links to → MPCCOM_ACCOUNTING → links to → vouchers & voucher rows on accounting_id. Easy!But what is the link from shipment lines to inv trans hist? INVENTORY_TRANSACTION_HIST2 has fields SOURCE_REF1,2,3,4 & 5.1,2,3&4 are clearly Customer Order, Line, Rel, Lini Item (for SOURCE_REF_TYPE = Customer Order)What is SOURCE_REF5… Help says its delivery reference… so I think it is the key to link back to shipment line…. but cant find where it links to.                    

A window with Notes field ​​​​​The problem in these Notes fields is that, when it contains quite a lot of text, it’s hard to get a good overview of the text. The way forward for the moment is to use a different tool to write the text and then copy it to the field. The same goes for reading, the text needs to be copied into a different tool. This way of working can't be the intention as there is a function for Notes in the framework.​​​​​​A Window with “Notepad’ functionIs it possible to get this “Notepad” function for some other windows as well?   

Hello, I need some help regarding AP/AR Netting with my customer.The companies within the group are buying and selling each other goods. Let’s suppose the company A has an AP Balance with company B (1500€) and an AR Balance with company B (4200€).At the end of the month, the AP Balance is offset in a intercompany offset account (Credit) and the AR Balance offset as well in the same account (Debit).So, the intercompany offset account balance is the difference (so -2700€)The netting functionality allows me to offset the same amount in AP and AR (here 1500€), but i would like to post the difference.Is it possible to execute such process in IFS ? Which posting controls are involved ?Also, is it possible to have a different account for each one of the sister companies ? Thanks, Tarek

We recently upgraded from v14.5 where the users had the ability to use BCC for additional email addresses.  In v15.4 we have not been able to figure out if this is an option that can be enabled as it is not currently there.  Does this functionality still exist in v15?v14.5 v15.4 

I have one company (not the source one) which does not appear in the Target companies list. How can I include all existing companies in this window?

Hi, I have configure a simple GL auto posting rule to distribute a cost account from cost centre A to B with voucher type M, I.However it is not working neither 2 function type.  Could anyone shed some light what would affect the automatic feature ?

Hi Team,I tried to hide above field (individually or with other connected fields to the item class) using page designer for apps. It seems that I cannot hide fields in this assistant (report in assistant, you get when completing a work in mobile client)Is there a way to hide these fields without code changes pls ?Regards,RoshanP.S:1.Report in assitant2.Page designer 

So I have a tiny flow. It has been deployed once. I'm trying to get the workflow removed totally. However when trying the Delete option on the workflow:It fails as there is an active version_1.I don't see an option to de-activate this version_1 and hence release the complete set of version and deletion of the workflow (eventSalesContractError2 in this case) to be removed totally.There is no projection, nor an event connected to it.What am I missing that I can't remove/delete the workflow?

Hi All, In PSO when an absence is booked in IFS Cloud it feeds through to PSO as Unavailable. Is there a way of expanding this to show the reason for the absence or is the only option we have is Unavailable? Thanks   

I have a situation where a Company X will sell and deliver goods to Customer Y.  We’ve setup a remote WHSE in Company X, Site A as a remote WHSE and linked it to Customer Y.  When I deliver my customer order, I need to deliver the goods to the Customer Y remote WHSE and see the inventory in the remote WHSE perpetual’s inventory in IFS Cloud.  Is this possible?  Seems to me like a straightforward VMI model, but I am not sure how to deliver to a customer’s remote WHSE in IFS Cloud.  And for those who might be wondering, the inventory that needs to show in Customer Y remote WHSE should be of ownership Customer Owned (This is not consignment, it is VMI, with Company X being the Vendor). Thanks.

Community,I think I have enabled all projections in permission set about Engineering Part & Part Handling, but I still get this error when running Create New Part in below window. May I know where I missed?i can create new engineering part, but if i do from Create New Part button, i got below error.when I select Create New Part button, i got below error.