Good Afternoon, I am trying to figure out how to get columns that are available from the page in IFS in the Data Source Designer, can any one help with this, See screen shot belowColumns Needed-System Even Description-Transaction Qty-On Hand QTY After TransactionWhat i have tried &AO.INVENTORY_TRANSACTION_HIST_API.Get_Transaction_QTY(CONTRACT,PART_NO,'*')
Good Afternoon everyone, i am trying to pull the Storage Zone ID’s into a inventory element i have created, is this possible, i am trying below. thank you for any assistance you can provide&AO.Storage_Zone_API.Get_Storage_Zone_Id(Storage_Zone)
I have created a Element List, with SUM SQLs as columns, is their a way i can navigate to the total for one site, when i try now i get a error message saying group by function not allowed, below is screen shot of my list element and data source. Thank you
Ok so i am having a massive brain cramp and know that this will probally be a easy fix. LOL i am trying to create a column that register if something is in bay 1 with a WDR of bay 2, below is what i thought was the answer but i keep getting error messages, Any help would be greatly appreciated CASE WHEN (BAY_NO = 'LM' and WAIV_DEV_REJ_NO = 'G%') THEN '1' ELSE '0' END)
Good Afternoon, I was wondering if their was a way to combine the two CASE When SQL’s i have below into one view so my lobby element would show 3 columns (Records Counted, To Be Counted, New Record) The new Record column i am trying to add is parts Recieved this year, Thank you for any and all help it is greatly appreciated (CASE WHEN LAST_COUNT_DATE >trunc(to_date( '#START_OF_THIS_YEAR#', 'YYYY-MM-DD-HH24:MI:SS' )) THEN 'Records Counted' ELSE 'Records To Be Counted' END) (CASE WHEN RECEIPT_DATE > trunc(to_date( '#START_OF_THIS_YEAR#', 'YYYY-MM-DD-HH24:MI:SS' )) THEN 'New Record' ELSE 'Needs To Be Counted' END)
I am trying to see the total records remaining to count subtracting the records that have been received this year. below is the SQL i am using and i get the same number of records with out excluding the records that were received this yearexample what i am seeing using my current SQL 21 records 6 received this year column should read 15 records but it is still reading 21 records SUM(CASE WHEN RECEIPT_DATE > to_date( '#START_OF_THIS_YEAR#', 'YYYY-MM-DD-HH24:MI:SS' ) and LAST_COUNT_DATE > trunc(to_date( '#START_OF_THIS_YEAR#', 'YYYY-MM-DD-HH24:MI:SS' )) + ( 1 - 1/ ( 60*60*24 ) )THEN '0' ELSE '1' END) Thank you for any help
Good Morning, I am trying to see if there is a way to have the same colors on pie charts, i have the same records being pulled for each pie chart, but on one pie chart the Records To Be counted is Blue and Records Counted is Green, on another it is reversed. is there any way so that they show the same color on all pie charts. or is this something we will just have to live with. lol Thank you in advacne
Good Afternoon, I was wondering if it was possible to be able to pull multiple sites from the lobby filter, i have a inventory elelement and right now i can filter one site at a time, and it loads into my element correctly, was wondering if there was a way to be able to add multiple site codes and have all those load into the elemenet.This is something i am just testing so i dont have to have multiple lobbies for each individual. if its not possible it is not a big deal. Thank you for any time and help you can provide Lobby FIlter i want to have multiple sites onLobby Element Sites would load To Current Element SQL
Good AfternoonI am trying to pull in the DO Coordinator Field into my Shipment Data Set, i was able to pull in the DO State but the Coordinator Field is fighting me. any help would be greatly appreciated. Below is screen shots and my current attempt to get the Coordinator Field&AO.Distribution_Order_API.Get_ DIST_ORDER_COORDINATOR (DIST_ORDER_COORDINATOR)
I am trying to exclude certan W/D/R’s from my data, i think it is to many and was hoping to find a way to make this work. below is my SQL and the error i get when i try to save it in data source designer, the preview shows the correct data but it will not save. Thank you for any help you might have
I am trying to see if i can set up graph for trends for our aging DO’s and it is not working for me, i have the data set for my aging DO’s but want to see the rise and fall by month, currently when i try it, it pulls it by only the obj status date, i am trying to see if i have 30 in jan and then 20 in feb and 40 in march for example. thank you in advance for any help, below is the data set i am working with
I am trying to see if there is a way to have my Element list the Distro Order Status in a specific order, The order i am looking for is Planned , Released , Reserved , Picked , In Transit , Arrived , ReceivedScreen shots below are of what order they are now along with a screen shot of Data Screen
Does any one know how i can adjust the below SQL so that it rounds to the nearest whole number. i am trying to see 10% of records to count a month. Below is current SQL I have tried adding Round in the front but it wouldnt work (CASE WHEN LAST_COUNT_DATE >trunc(to_date( '#START_OF_THIS_YEAR#', 'YYYY-MM-DD-HH24:MI:SS' )) THEN '0' ELSE '1' END) *.10
Good Morning, I am trying to get the Requisition line to populate in my data set, it is a viewable collumn from the Maint Material Requisiion line screen, but does not populate in the column selection. any suggestions
Happy New Year everyone, I am working on building a List Element, and was wondering if it is possible to have it only list one site with totals for everything instead of it listing the same site for all Part Numbers, i am trying to build something for a quick view of inventory records that need to be counted, if i use the matrix element i cant get all the columns i need. below is a screen shot of my current list and my Data Source. thank you for any assistance you can provide
Good Morning, i am trying to see if it is possible to get a column that would tell me my total percent to count for a month, example would be i have 4500 records and need to count 10% for this month the result in the column would give me 450. Below is screen shot of my SQL Data. Thank you for any help
I am trying to see if a Part that i have on a MMR is currently on a PR i tried to use the below column SQL but keep getting a error message that missing expression, did i do this one wrong (CASE WHEN (SELECT COUNT(mmr.PART_NO) FROM &AO.maint_material_req_line mmr WHERE mmr.IS_CLOSED = 0 AND mmr.PART_NO = &AO.purchase_order_api.Get _Part_No(order_no)) >0 THEN 'MMR' ELSE 'NO MMR' END)
I am trying to see the PO number for parts on a Distro Order, i have the below SQL but it is retuning both closed and open PO’s is there a way for it to only show the open PO’s. Thank you(SELECT listagg(order_NO, '^') WITHIN GROUP (ORDER BY 1) FROM (SELECT ORDER_NO FROM &AO.PURCHASE_REQ_LINE_ALL WHERE part_no = DISTRIBUTION_ORDER.PART_NO))
Good Morning, I was wondering if there was a way to view only certin warehouses in a data set for Distribution Orders, with help from this forum i was able to see the warehouse locations in the columns, now i was wondering if i could get it to only pull from specific warehouses. below is my Condition SQL and Column SQL along with screen shots, i greatly appreciate everyones help Condition SQL (OBJSTATE = (select &AO.DISTRIBUTION_ORDER_API.FINITE_STATE_ENCODE__('Planned') from dual) or OBJSTATE = (select &AO.DISTRIBUTION_ORDER_API.FINITE_STATE_ENCODE__('Released') from dual)) and SUPPLY_SITE = 'C0283' and QTY_TO_MOVE <= &AO.Inventory_Part_In_Stock_API.Get_Inventory_Qty_Onhand(SUPPLY_SITE,PART_NO,'*') and &AO.Inventory_Part_In_Stock_API.Get_Inventory_Qty_Onhand(SUPPLY_SITE,PART_NO,'*')>0 Column SQL(SELECT listagg(warehouse, '^') WITHIN GROUP (ORDER BY 1) FROM (SELECT warehouse FROM &AO.inventory_part_in_stock I WHERE i.part_no = DISTRIBUTION_ORDER.PART_NO AND i
Good morning, i am trying to get a column in my data source that shows the warehouse location of the Avail Qty from the Supply Site on a Distribution Order. I was able to pull the Avail Qty from the Supply site just need to find a way if possible to pull the Warehouse the Avail Qty is in. thank you in advance Avail Qty Column SQL&AO.Inventory_Part_In_Stock_API.Get_Inventory_Qty_Onhand(SUPPLY_SITE,PART_NO,'*') Screen Shot of Preview Screen
I am trying to see Distribution Orders that are open and fillable, i need to see the locations that the Available Qty is in. If this is possible is there also a way to exclude certain locations, i am fairly new to SQL’s and IFS lobby’s. Below is my current SQL OBJSTATE = (select &AO.CUSTOMER_ORDER_LINE_API.FINITE_STATE_ENCODE__('Released') from dual) and CONTRACT = 'C0283' and BUY_QTY_DUE > 0 and &AO.Reserve_Customer_Order_API.Get_Available_Qty(NVL(supply_site,contract), NVL(part_no,catalog_no),configuration_id,order_no,line_no,rel_no,line_item_no,supply_code_db,part_ownership_db,owning_customer_no,project_id,condition_code,NULL,'TRUE') >= BUY_QTY_DUE and AUTHORIZE_CODE <> 'E380748' AND AUTHORIZE_CODE <> 'EST' and ORDER_ID = 'NO'
I am trying to be able to navigate from my Matrix element to the Distribution Order Screen, the Data Source that i am using uses the View &AO.Distribution_Order_history, below is my screen shot of my data source and my element any assistance would be greatly appreciated. Data SourceElement
I am trying to see Aging Distribution Orders, currently what i have shows me the object version of the report which if anything changes then it drops off my category, i want to see only the status history change that is over a certin amount of days. any help would be greatly appreciated. Thank you in advance below is how my current SQL is written objstate NOT IN ( 'Closed', 'Cancelled' ) AND ( trunc(TO_DATE(objversion,'yyyymmddhh24miss') ) <= ( SELECT trunc(SYSDATE) - 61 FROM dual ) AND trunc(TO_DATE(objversion,'yyyymmddhh24miss') ) >= ( SELECT trunc(SYSDATE) - 120 FROM dual ) )
Already have an account? Login
No account yet? Create an account
Enter your username or 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.
