Please help with more update on the query
@Yasas Kasthuriarachchi
I have a Quick Report that Groups By dollar columns, then does a UNION to total those $$$ columns. It has a join column from another table (btl.amount), keying on primary keys/columns. The challenge I’m running into is that, on the UNION SQL, I’m joining to a table to get that single $$$ column’s total (SUM(btl.amount)). Since the join is not at the detail level of each main table’s rows, it’s overstating the SUM() total $$$. (kind of hard to explain). SELECT t.reporting_date "Reporting Date", t.district_code "BU Code", t.district_desc "BU Desc", t.contract "Site", to_char( SUM(t.Daily_Order_Entry), '99,999,999.99') "Daily Order Entry", to_char( SUM(t.MTD_Order_Entry), '99,999,999.99') "MTD Order Entry", to_char( SUM(t.Daily_Billings), '99,999,999.99') "Daily Billings", to_char( SUM(t.MTD_Billings), '99,999,999.99') "MTD Billings", to_char( MAX(btl.amount), '99,999,999.99') "Forecast", to_char( SUM(t.Past_Open_Orders), '99,999,999.99') "Past Open Orders", to_char( SUM(t.C
System will not allow to change the ‘POUpdated’ Change Orders as it depicts the Final stage of the PO-CO process, one can change the CO in ‘Planned’ state to ‘Cancelled’ state.
Kindly let me know if the below comment helps:)Can we change the UoM on an existing part? | IFS Community
You can create a new Quick Report where you can join the view of No-Part Requisition lines and Part Requisition lines if the supplier is same, Hope it helps
Hi Jens Thanks so much for your reply. I can create the Migration job by the steps. Is this a bug of APP10? Thanks & Regards Peak Yes this seems to be a bug
Sure, We have worked on such requests please share some insights with version of IFS version you’re using?
You can make the pre-posting setup posting control set and set the code part as purchase group (mandatory) through posting control navigator
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
