The Outside Service Dispatch Entry window is one module I don’t spend too much time in, but when I do, I always find myself scrolling (more like scrambling) through the different windows and screens – trying to get answers for any one of the following questions (if not more).
- Where is it?
- Who has it? What else do they have?
- When can we expect it
- What else do we have out for that job?
- Where did we dispatch that part out to?
- and the list goes on…
So I decided to do a little “retooling” of the dispatch BROWSE window and have it display the information that tends to be asked over and over and over again.
So I now have a browse window that allows me to search dispatches at the order line level (details) as oppose to only the header information. This enables me to now search by part id, work order, back order qty, dates and so on.
Here’s the screenshot of a “stripped down” version of the my modified browse window:
NOW the browse window allows me to filter as needed and drill down to the individual dispatches. I actually have ALL the information I need straight from the browse window (just like a report). On top of all that, because I’m using the browse window, I can export my filtered results to excel for further analysis and reporting.
All this within the VISUAL interface.
So if you find yourself in this position when ask about your dispatched outside services…
- Create a SQL VIEW named zview_DISPATCH_BROWSE using the query in this download.
- Find and open your VMBROWSE.ini file (should be located in you local VISUAL directory).
- Replace the entire [Dispatch] section with the following:
1245679101112131415161718192021222324[Dispatch]version=26title=Service Dispatcheskey1=SERVICE_DISPATCH.IDsort=SERVICE_DISPATCH.IDorder=1searchfirst=1autorefresh=0decode=SERVICE_DISPATCH.MARKED_FOR_PURGE,Boolean,PURCHASE_ORDER.BACK_ORDER,Boolean,PURCHASE_ORDER.EXCH_RATE_FIXED,Boolean,PURCHASE_ORDER.MARKED_FOR_PURGE,Boolean,PURCHASE_ORDER.POSTING_CANDIDATE,Boolean,VENDOR.REPORT_1099_MISC,Boolean,PURCHASE_ORDER.STATUS,Status,VENDOR.MATCH_TYPE,MatchType,VENDOR.TERMS_DISC_TYPE,TermsType,VENDOR.TERMS_NET_TYPE,TermsTypeautobrowse=1colA=SERVICE_DISPATCH.ID,Dispatch ID,1,1.08,5,0,colB=zview_DISPATCH_BROWSE.WORKORDER_BASE_ID,Base ID,2,1.05,5,0,colC=SERVICE_DISPATCH.PURC_ORDER_ID,PO,3,1.12,5,0,colD=VENDOR.NAME,Vendor,4,2.98,5,0,colE=VENDOR.ID,Vendor ID,5,1.10,5,0,colF=zview_DISPATCH_BROWSE.STATUS,PO Status,6,0.90,5,0,colG=zview_DISPATCH_BROWSE.PART_ID,Part ID,7,1.07,5,0,colH=zview_DISPATCH_BROWSE.USER_ORDER_QTY,Qty Ordered,8,1.13,3,0,FORMAT_DecimalcolI=zview_DISPATCH_BROWSE.TOTAL_USR_RECD_QTY,Qty Received,9,1.18,3,0,FORMAT_DecimalcolJ=zview_DISPATCH_BROWSE.LN_BACKORDER_QTY,Backorder Qty,10,1.32,3,0,FORMAT_DecimalcolK=zview_DISPATCH_BROWSE.LN_DESIRED_RECV_DATE,Desired Recv Date,11,1.90,5,0,colL=zview_DISPATCH_BROWSE.LN_PROMISE_DATE,Promise Date,12,1.87,5,0,
If you don’t want to replace the entire section, then just be sure to modify the lines 3 & 8.
- You should be good to go