@johnw66 Yes this did work, thank you for the assistant, since i am using the Customer Order View can add a navigation to the Distro Order Screen from here not a big deal if it cant be done. thank you again for all of your help hope you have a good weekend
Thank you
Thank you I will try shortly we lost power I will let you know if it works, thank you for the help
I tried that way and it navigates to the DO screen however it pulls all DO’s even ones in closed status
I do have a column for Order No, how ever if i use Order No in the Element section then the Matrix would be unreadable if there are alot of old DO’s. so having it list by site and status makes it easier to navigate.
@Tomas Ruderfelt Thank you but unfortunately they don't want to use Availability control on parts, i would like the lobby element to not see locations so my warehouse knows exactly how many DO’s they can fill and push out to other sites. thank you
@johnw66 When i updated using your suggestion now it doesn't show any available DO’s to fill, how ever i do know i have some to fill that the Avail Qty is in a correct location, any suggestions as to why this is (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 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 NOT IN ('E380748', 'EST') and ORDER_ID = 'NO' and LOCATION_NO NOT IN ('GMDT-REPAIR-IN', 'TES-RSTK-GFP', 'ESTW-RSTK-CFP','RESTOCK%')
Paul, When i try to use two columns for Site Description and DO Status, i get the same error message as before, if i uncheck the Use Data Source it will work however it pulls all DO’s for the site instead of what is aging, is there a way to put it in the data source to pull from the DO or do i need to alter my columns some how. or am i asking to much LOL, below is how my columns are written right nowSite Description is written as &AO.site_api.get_description(&AO.Distribution_Order_API.Get_Demand_Site(order_no)) DO Status is written as &AO.Distribution_Order_API.Get_ObjState(order_no)
Thank you again always something simple that stumps me LOL
ok one more question on this, is there a way to get it to navigate from history to the actual distro order screen, below is the address i am using and the screen shot of the error i am getting, i feel like i had this at one point but now its not working thank you again ifsapf:tbwOverviewDistributionOrders
Thank you, i didnt think about that, still learning as i go LOL. Thank you again that did do the trick
Thank you that did work, i did have to add one section below so that it pulled the newest State as well other wise it would pull 3 records for one day if it moved that many times in one day, for your reference below is what i did. Thank you again for your help in this ANDobjversion = (select max(objversion) from &AO.distribution_order_history hwhere distribution_order_history.order_no = h.order_no) ANDstate = (select max(state) from &AO.distribution_order_history hwhere distribution_order_history.order_no = h.order_no)
I Get this error message.
How would I do this in the data source developer, I am new to this thank you for your help
John, i have attempted to use the history, the problem i have with using the history is it doesnt just pull the oldest line it pulls all history lines, so if i put this into a matrix or a counter instead of having 4 aging distro orders i end up have 30, any suggestions would be greatly appreciated. thank you again
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.