Solved

we are currently importing data from our former ERP system into IFS Cloud 23R1SU6 and we notice that for instance the TEMPORARY_PART_COST_DETAIL table is just growingDoes anyone know how supposed temporary table is cleaned? is there some cleanup batch to schedule?thank you in advance 

I need the output of the check_amount to show 2 decimal places. Ex. 550.20. The export file seems to drop the last zero. What function should I use to format this properly?Thanks   

Hi All, I want to know the steps required for refilling the Remote Warehouse using Refill Source as Purchase Requisition so that PR gets automatically created.Screenshots will be really helpful. Thank you in advance. Best Regards,Rakesh

Hi - we have customer that wants to have POs on all PMs/UMs. I am having difficulty adding blanket POs to PMs - it only seems to work on Sales Orders.And of course the customer wants a different PO on Contract invoices and PM/service invoices.Anything I am missing in setup, or is PO on PMs not possible?

HiWe need to find out how to populate data into the INVENTORY_PART_PERIOD_HIST_TAB. Could you please help us identify the source from which the data is being populated into the INVENTORY_PART_PERIOD_HIST_TAB?Thanks

Hi,We have similar issue with previous post regarding rounding line 100001 for External supplier invoice line. How to setup auto posting for rounding difference line created when we use PO line matching in Posting Proposal | IFS Community We do have external supplier invoice with and without PO and we want to set up posting control so when there is rounding line 100001 on external supplier invoice line, it should always create posting line with account number and code part values. How can we set up this in IFS cloud? For example which posting type and control type etc.  Thanks and regards, 

Hi All,I'm trying to load an external customer invoice with multiple lines with record type A and the invoice are getting created without any errors. But as soon as I load them it goes to a status ‘Partly loaded’. There are no errors. So I'm wondering the reason for this?  

HiI am trying to create an Excel Migration Job that will delete User’s Sites. I would like to use the method USER_ALLOWED_SITE_API.Remove_User_Allowed_Site. It requires only COMPANY and USERID and removes all Sites associated with the given COMPANY for the given USERID. I would like it in Excel so that we can load the specific Users and Companies we need to target.If I run this PL/SQL, it completes successfully…beginUSER_ALLOWED_SITE_API.Remove_User_Allowed_Site('USERID','COMPANY');end;I have tried various configs in the Excel Migration job and it either errors, says it has processed it (but hasn’t) or churns for a while and returns a blank.Any pointers?

Has anyone attempted to add a zip file to a BOP or CO?  Is it even possible?  We often have large files with bids, quotes, assembly docs, etc and thought it would be easier to attach it as a zip file.  Zip files are not categorized as documents. .pdf, .xml and etc are documents. Each type of attachment requires a different file path to be created. For example a jpeg would need to be attached under media attachments, and wouldn't be able to import as an document attachment. We do import zip files when migrating profiles, permissions, lobbies and etc.. but the areas we're working in are mapped for zip... has anybody come up with a method to map a zip file to the BOP or CO?

Sometimes our SAs take photos at customer sites, and we would like to include these on the service orders we send to the customers - very handy to document chargable work. I have tested with Customizer, but it does not look like we can a add this on the report. Or am I missing something? Would it be possible to get as a customization?

We’ve got some Service Request S records stuck open. The Tasks are complete but it looks like the complete stage was missing when they were created. There is no resolution open available on the S record in order to resolve them manually either. Any ideas on what we could do? Cancelling would send a confusing email to the user which we are keen to avoid.

Hello,   In Apps9, is it possible to stop checking in some documents over a certain file size?   Does it need to create a macro?   Many Thanks,   Anne-Sophie

can we add a custom field like service department in forms in assystnet and write expression in Service Department while editing the Service, to assign the requests to that specific department which was selected in Form while creating requests

Hi There, I’m trying to create a custom event when the wanted_delivery_date attribute is changed. I’ve set the following event detailsLogical Unit: CustomerOrderTable: CUSTOMER_ORDER_TABFire When: Objects Are ChangedOnly when these attributes are changed: WANTED_DELIVERY_DATEFire before or after object is changed: AfterAttributes: Wanted_Delivery_Date New Value & Old Value, Order_ID Old Value. The actions is then this bit of code… declare    p_order_no                                      varchar2(1000);    p_old_wanted_delivery_date          DATE;    p_new_wanted_delivery_date        DATE;begin    p_order_no                                := '&OLD:ORDER_NO';    p_old_wanted_delivery_date    := '&OLD:WANTED_DELIVERY_DATE';    p_new_wanted_delivery_date  := '&NEW:WANTED_DELIVERY_DATE';     IFSAPP.S3_WNTD_DEL_DT_CHNG_API.WANTED_DEL_DATE_CHANGE(p_order_no,p_old_wanted_delivery_date,p_new_wanted_delivery_date);end; When trying that code in the back end it works fine, howeve

Hello, is there a list of Document Default Values? Meaning DB Column, what it means and its possible values.

Hi All, After creating the LOV, what settings are necessary to apply it to the screen? When using an existing LOV, the screen displays correctly, but with the one I created, the following error appeared.LOV:ERROR: Best regrards,Feng

Not sure if it is even possible, but I created a new Group in Page Designer on our Expense Sheet Details page, and I would like for it to only be visible when the custom field inside it has a value.  I tried the following, but it does not work.  Is my syntax off; is this functionality not possible?  Any insight would be greatly appreciated!  

Hi All, Can anyone share Data Migration Manager> Template Project file for 23R2 and if you have 24R1 as well?

Hi, There is a user-client who can access to IFS and do some jobs that are privileged to him, just because of he doesn’t have Employee File record he cannot access to projects which he is privileged too. we tried to create a role and assigned him on project module, but this didn’t work. To add him as Team member he has to have Employee File record otherwise he cannot access to project.Is there a way to make him access to projects without creating Employee File record?Think there is a consultant who you will grant access to projects, he is not the company’s employee. Kinds.

When I click to open a document from the attachments, I get the information message "application server DOCUMENT_TICKET_TEMP_PATH: //IFSPRODIFSDoc/\.No Document file operation cannot be performed" and I cannot open the file.

Good morning.  I would like to know what determines who is able to Approve/Authorise Expense Sheets?  Is it the Position Structure, Position/Supervisor Access Setup?  Wrt Travel Requests, there is a Travel Request Configuration available, but not for Expense Sheets.  Many thanks.  Anya.

Hello community.I’m looking for help to identify the parameter(s) in FSM6.25 that determine the number of open bill schedules.  In our current configuration, we are generating 1 for annual, 4 for quarterly and 12 for monthly which creates certain challenges when it comes to maintenance and reporting activities.  In actuality, we really on need the next bill schedule to be generated.  Any suggestions?Thanks,Richard

I am new to IFS and I am trying to understand the process of attaching a specific approval template to an attachment area that will trigger the approval process when a document is first attached or an existing attached document is edited.  Can anyone help? 

In our product set up, we use PSO in tandem with IFS Cloud WO Management. PSO continuously schedules and optimized work-tasks, and broadcast plans back to Cloud.What I’m trying to understand is how/when data is being exchanges between PSO and Cloud. I can see in PSO when data is being broadcasted, but I have not yet found where in Cloud I can see how this plan is being processed.Can anybody put me on the right track?

Hi, We are having repeat problems when creating receipts for Inventory Parts over the month end period. Often raw materials arrive over the weekend, and sometimes the last day of the month is a Saturday or Sunday, but they are not booked until Monday. When trying to backdate the receipt, it says it cannot be done because of the Inventory Statistics period being incorrect. Prior to Transferring Inventory Transactions, I tried going into the Inventory Transaction Details to change the applied date and had the message: “The new date must be equal to or greater than the start date of the latest period in the inventory value statistics” There has to be a way to allow this to happen. Can anyone help please? Thank you, John