{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Summary","ShopWidget","SavedItems","OrderHistory","SavedCarts","ShareCart","ActiveCart","Checkout","CEWeb","Miscellaneous","DataConversions","MyAccount","Note-Questions","Defs","ToDo","temp"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Status as of 1/9/14"]
["Task","Status","Avante","UI","AV Rework","UI Rework","Ongoing QA"]
[]
["ShopWidget","In Progress",{"$f":"ShopWidget!D8","v":0},{"$f":"ShopWidget!F8","v":0},{"$f":"ShopWidget!G8","v":0},{"$f":"ShopWidget!H8","v":0},{"$f":"ShopWidget!I8","v":0},"no macchi; database cleanup; ui bug fixes; "]
["Saved Items","In Progress",{"$f":"SavedItems!D8","v":0},{"$f":"SavedItems!F8","v":0},{"$f":"SavedItems!G8","v":0},{"$f":"SavedItems!H8","v":0},{"$f":"SavedItems!I8","v":0}]
["Order History","In Progress",{"$f":"OrderHistory!D8","v":0},{"$f":"OrderHistory!F8","v":0},{"$f":"OrderHistory!G8","v":0},{"$f":"OrderHistory!H8","v":0},{"$f":"OrderHistory!I8","v":0}]
["Saved Carts","In Progress",{"$f":"SavedCarts!D8","v":0},{"$f":"SavedCarts!F8","v":0},{"$f":"SavedCarts!G8","v":0},{"$f":"SavedCarts!H8","v":0},{"$f":"SavedCarts!I8","v":0}]
["Share Cart","In Progress",{"$f":"ShareCart!D8","v":0},{"$f":"ShareCart!F8","v":0},{"$f":"ShareCart!G8","v":0},{"$f":"ShareCart!H8","v":0},{"$f":"ShareCart!I8","v":0}]
["Active Cart","In Progress",{"$f":"ActiveCart!D8","v":0},{"$f":"ActiveCart!F8","v":0},{"$f":"ActiveCart!G8","v":0},{"$f":"ActiveCart!H8","v":0},{"$f":"ActiveCart!I8","v":0}]
["Checkout","In Progress",{"$f":"Checkout!D8","v":0},{"$f":"Checkout!F8","v":0},{"$f":"Checkout!G8","v":0},{"$f":"Checkout!H8","v":0},{"$f":"Checkout!I8","v":0}]
["CEWeb"]
["Miscellaneous"]
["Data Conversions","TBDesigned",{"$f":"DataConversions!G7","v":0},{"$f":"DataConversions!J7","v":0},{"$f":"DataConversions!L7","v":0},{"$f":"DataConversions!M7","v":0},{"$f":"DataConversions!N7","v":0}]
["My Account","TBDesigned",{"$f":"MyAccount!#REF!","v":{"$error":"#REF!"}},{"$f":"MyAccount!#REF!","v":{"$error":"#REF!"}},{"$f":"MyAccount!#REF!","v":{"$error":"#REF!"}},{"$f":"MyAccount!#REF!","v":{"$error":"#REF!"}},{"$f":"MyAccount!#REF!","v":{"$error":"#REF!"}}]
["Twitter Feed on page",null,0,1,0,0,0,"\"The Experience\" not in first launch. Numbers are for twitter feed on page."]
["Pre Login Func",null,0,0,0,0,0,"This functionality should be in the numbers of the pertinent sections"]
["Mktg/Fat Content",null,4,8,3,3,3,"These numbers are COMPLETE guesses. This line is to represent the \"front page\" information from the existing site."]
["CE Web Integration","TBDesigned",{"$f":"CEWeb!G11","v":0},{"$f":"CEWeb!J11","v":0},{"$f":"CEWeb!L11","v":0},{"$f":"CEWeb!M11","v":0},{"$f":"CEWeb!N11","v":0}]
["Predictive Ordering","TBDesigned",3,2,2,2,2,"incomplete design"]
["Shared Item",null,0,0,0,0,0,"This is complete however, handling FAX customers is still a problem. Needs to be discussed."]
["Notifications",null,4,4,2,2,2,"A system needs to be designed on what to tell customers about and how to let them customize what they are told about.  For example, when their order ships, when someone empties their cart."]
[]
["#Days",null,{"$f":"SUM(C4:C22)","v":{"$error":"#REF!"}},{"$f":"SUM(D4:D22)","v":{"$error":"#REF!"}},{"$f":"SUM(E4:E22)","v":{"$error":"#REF!"}},{"$f":"SUM(F4:F22)","v":{"$error":"#REF!"}},{"$f":"SUM(G4:G22)","v":{"$error":"#REF!"}}]
[null,null,2.4,1.6,2.4,1.6,"Various"]
["#Weeks",null,{"$f":"(((C23/C24)+0.49)/5)","v":{"$error":"#REF!"}},{"$f":"(((D23/D24)+0.49)/5)","v":{"$error":"#REF!"}},{"$f":"(((E23/E24)+0.49)/5)","v":{"$error":"#REF!"}},{"$f":"(((F23/F24)+0.49)/5)","v":{"$error":"#REF!"}},"Ongonig"]
["Complete Date",null,{"$f":"TODAY()+(C25*7)","v":{"$error":"#REF!"}},{"$f":"TODAY()+(D25*7)","v":{"$error":"#REF!"}},{"$f":"C26+(E25*7)","v":{"$error":"#REF!"}},{"$f":"D26+(F25*7)","v":{"$error":"#REF!"}},"Pre-live"]
[]
["Dates as of Prev Week",null,"2014-01-21","2014-02-22","2014-02-27","2014-04-09"]

{"sheet":"ShopWidget","index":1,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[0,6,0,7]]}
["Task Nbr","Task Description","Avante",null,"UI",null,"Rework",null,"QA",null,"Status/Notes"]
[null,null,"Hours","Rem","Hours","Rem","Avante","UI"]
[null,{"$f":"Summary!A1","v":"Status as of 1/9/14"}]
["ShopWidget","Total Hours",{"$f":"SUM(C5:C65536)","v":0},{"$f":"SUM(D5:D65536)","v":0},{"$f":"SUM(E5:E65536)","v":0},{"$f":"SUM(F5:F65536)","v":0}]

{"sheet":"SavedItems","index":2,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[0,6,0,7]]}
["Task Nbr","Task Description","Avante",null,"UI",null,"Rework",null,"QA",null,"Status/Notes"]
[null,null,"Hours","Rem","Hours","Rem","Avante","UI"]
[null,{"$f":"Summary!A1","v":"Status as of 1/9/14"}]
["SavedItems","Total Hours",{"$f":"SUM(C5:C65536)","v":0},{"$f":"SUM(D5:D65536)","v":0},{"$f":"SUM(E5:E65536)","v":0},{"$f":"SUM(F5:F65536)","v":0}]

{"sheet":"OrderHistory","index":3,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[0,6,0,7]]}
["Task Nbr","Task Description","Avante",null,"UI",null,"Rework",null,"QA",null,"Status/Notes"]
[null,null,"Hours","Rem","Hours","Rem","Avante","UI"]
[null,{"$f":"Summary!A1","v":"Status as of 1/9/14"}]
["OrderHistory","Total Hours",{"$f":"SUM(C5:C65536)","v":0},{"$f":"SUM(D5:D65536)","v":0},{"$f":"SUM(E5:E65536)","v":0},{"$f":"SUM(F5:F65536)","v":0}]

{"sheet":"SavedCarts","index":4,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[0,6,0,7]]}
["Task Nbr","Task Description","Avante",null,"UI",null,"Rework",null,"QA",null,"Status/Notes"]
[null,null,"Hours","Rem","Hours","Rem","Avante","UI"]
[null,{"$f":"Summary!A1","v":"Status as of 1/9/14"}]
["SavedCarts","Total Hours",{"$f":"SUM(C5:C65536)","v":0},{"$f":"SUM(D5:D65536)","v":0},{"$f":"SUM(E5:E65536)","v":0},{"$f":"SUM(F5:F65536)","v":0}]

{"sheet":"ShareCart","index":5,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[0,6,0,7]]}
["Task Nbr","Task Description","Avante",null,"UI",null,"Rework",null,"QA",null,"Status/Notes"]
[null,null,"Hours","Rem","Hours","Rem","Avante","UI"]
[null,{"$f":"Summary!A1","v":"Status as of 1/9/14"}]
["ShareCart","Total Hours",{"$f":"SUM(C5:C65536)","v":0},{"$f":"SUM(D5:D65536)","v":0},{"$f":"SUM(E5:E65536)","v":0},{"$f":"SUM(F5:F65536)","v":0}]

{"sheet":"ActiveCart","index":6,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[0,6,0,7]]}
["Task Nbr","Task Description","Avante",null,"UI",null,"Rework",null,"QA",null,"Status/Notes"]
[null,null,"Hours","Rem","Hours","Rem","Avante","UI"]
[null,{"$f":"Summary!A1","v":"Status as of 1/9/14"}]
["ActiveCart","Total Hours",{"$f":"SUM(C5:C65536)","v":0},{"$f":"SUM(D5:D65536)","v":0},{"$f":"SUM(E5:E65536)","v":0},{"$f":"SUM(F5:F65536)","v":0}]

{"sheet":"Checkout","index":7,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[0,6,0,7]]}
["Task Nbr","Task Description","Avante",null,"UI",null,"Rework",null,"QA",null,"Status/Notes"]
[null,null,"Hours","Rem","Hours","Rem","Avante","UI"]
[null,{"$f":"Summary!A1","v":"Status as of 1/9/14"}]
["Checkout","Total Hours",{"$f":"SUM(C5:C65536)","v":0},{"$f":"SUM(D5:D65536)","v":0},{"$f":"SUM(E5:E65536)","v":0},{"$f":"SUM(F5:F65536)","v":0}]

{"sheet":"CEWeb","index":8,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[0,6,0,7]]}
["Task Nbr","Task Description","Avante",null,"UI",null,"Rework",null,"QA",null,"Status/Notes"]
[null,null,"Hours","Rem","Hours","Rem","Avante","UI"]
[null,{"$f":"Summary!A1","v":"Status as of 1/9/14"}]
["CEWeb","Total Hours",{"$f":"SUM(C5:C65536)","v":0},{"$f":"SUM(D5:D65536)","v":0},{"$f":"SUM(E5:E65536)","v":0},{"$f":"SUM(F5:F65536)","v":0}]

{"sheet":"Miscellaneous","index":9,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[0,6,0,7]]}
["Task Nbr","Task Description","Avante",null,"UI",null,"Rework",null,"QA",null,"Status/Notes"]
[null,null,"Hours","Rem","Hours","Rem","Avante","UI"]
[null,{"$f":"Summary!A1","v":"Status as of 1/9/14"}]
["Miscellaneous","Total Hours",{"$f":"SUM(C5:C65536)","v":0},{"$f":"SUM(D5:D65536)","v":0},{"$f":"SUM(E5:E65536)","v":0},{"$f":"SUM(F5:F65536)","v":0}]

{"sheet":"DataConversions","index":10,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[0,6,0,7]]}
["Task Nbr","Task Description","Avante",null,"UI",null,"Rework",null,"QA",null,"Status/Notes"]
[null,null,"Hours","Rem","Hours","Rem","Avante","UI"]
[null,{"$f":"Summary!A1","v":"Status as of 1/9/14"}]
["DataConversions","Total Hours",{"$f":"SUM(C5:C65536)","v":0},{"$f":"SUM(D5:D65536)","v":0},{"$f":"SUM(E5:E65536)","v":0},{"$f":"SUM(F5:F65536)","v":0}]

{"sheet":"MyAccount","index":11,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[0,6,0,7]]}
["Task Nbr","Task Description","Avante",null,"UI",null,"Rework",null,"QA",null,"Status/Notes"]
[null,null,"Hours","Rem","Hours","Rem","Avante","UI"]
[null,{"$f":"Summary!A1","v":"Status as of 1/9/14"}]
["MyAccount","Total Hours",{"$f":"SUM(C5:C65536)","v":0},{"$f":"SUM(D5:D65536)","v":0},{"$f":"SUM(E5:E65536)","v":0},{"$f":"SUM(F5:F65536)","v":0}]

{"sheet":"Note-Questions","index":12,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Results","Originally we had a line item for Results on the Summary page.  Having reviewed the Shop/Results area with"]
[null,"Ed we combined all incomplete functions into one page called ShopWidget.   Need to review with JP to be"]
[null,"sure there is no missing functionality."]
[]
[]
["Miscellaneous","***Investigate what Avante Reports/Processes are using configurator files to extract data."]
[null,"I am looking for a list of processes that will require changes when the BAGS/SHEETING/FURN, etc"]
[null,"product lines are combined into a single MOD product line.  This means that criteria numbers"]
[null,"may change:"]
[null," - Search IIPROCESS/BP/LDLIB/AVBP looking for CFQNA<13,x> extractions"]
[null," - Search IIPROCESS/BP/LDLIB/AVBP looking for CFORDER<13,x> extractions"]
[null," - Search IIPROCESS/BP/LDLIB/AVBP looking for CFBLDHDR<10,x> extractions"]
[]
["Miscellaneous","***Investigate/writeup design to only allow NS Made/Buy quotes to be entered via QUO4000.  Is there an"]
[null,"easy way to disable the other selections BAGS/SHEETING/TUBING/FURN from the screens?  Or should"]
[null,"we bypass the screens entirely and only allow NS as an item number in this screen?"]
[]
["Miscellaneous","***Investigate how 'shipping notifications' could be sent to customers notifying them that their shipment"]
[null,"has been made:"]
[null," - Timing - should this be done when updating Avante?  What if shipment hasn’t left building yet?"]
[null," - What email address to use?"]
[null," - What if customer doesn't accept emails?"]
[null," - Should notifications be sent for all shipments?  CPU's?"]
[]
["Miscellaneous","Investigate what changes will be needed for the new FOB CODE \"CPU\".  I believe CPU (customer pickup)"]
[null,"should follow the rules for COL/3PB in that they have no freight implications.  Be sure to check the "]
[null,"freight quote/freight$ calculation programs to make sure that CPU will not go through this logic."]
[null,"Investigate what should happen with CPU credit card orders -- should they be handled like PPD?"]

{"sheet":"Defs","index":13,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Avante Programmers: Wayne, Joe, Janice @ 80%",2.4]
["UI Programmers: Ed, Sal @ 80%",1.6]
["Technical Designers: John, Judy @ 75% ; Jim, Cathy @ 25%",2]
["QA/Test: Susan, Steve, Jim, Owen, Cathy, CE, Mktg"]

{"sheet":"ToDo","index":14,"n_rows":499,"n_cols":17,"rows_kept":499,"cut":false,"hidden":false,"merged":[]}
["Tab","Task Nbr","Dt Added","Status","Designer","Programming Task Description","Pty","DB Pgmr","DB Hours","DB Rem","UI Pgmr","UI Hours","UI Rem","Wiki Programing Document Spec Name","Dt Assigned","St Date"]
["Key to Reporting","0-0"," ","1"," ","Status'"," "," "," "," "," "," "," "," "," "," "," "]
[null,"0-1",null,"0",null,"0 = Awaiting Info - can't design yet"]
[null,"0-2",null,"1",null,"1 = Ready to Design"]
[null,"0-3",null,"2",null,"2 = Ready for Program"]
[null,"0-4",null,"3",null,"3 = In QA"]
[null,"0-5",null,"4",null,"4 = Done"]
[null,"0-6",null,"5",null,"5 = Investigation"]
[null,"0-7",null,"80",null,"80 = Bug Fixes"]
[null,"0-8",null,"99",null,"99 = Reserved for Future Use"]
["ShopWidget","1-0",null,"4",null,"Avante - Changes for Rolls, Rolls Cradle packed, Rolls Boxed",null,null,{"$f":"SUM(I12:I14)","v":0},{"$f":"SUM(J12:J14)","v":0},null,{"$f":"SUM(L12:L14)","v":0},{"$f":"SUM(M12:M14)","v":0},null,null,null,"Show just \"Rolls\" in packaging section so we can show the user Rolls Boxed and Rolls Cradlepacked in results as exact matches."]
[null,"1-1","2013-11-25","4","Judy","Modify Packaging Group Description",null,"Joe",null,0]
[null,"1-2","2013-11-25","4","Judy","Modify Packaging Default Value",null,"Joe",null,0]
[null,"1-3",null,"99",null,"Reserved for Future Use"]
["SavedItems","2-0",null,"1",null,"New customer part number logic",null,null,{"$f":"SUM(I16:I39)","v":35},{"$f":"SUM(J16:J39)","v":5},null,{"$f":"SUM(L16:L39)","v":16},{"$f":"SUM(M16:M39)","v":0},null,null,null,"including cart logic hover over our part# to see customer part#. Assigning customer part numbers from Saved Items Popup and calling that popup from the Labeling step of checkout, then refreshing labeling screen when they are done with that popup."]
[null,"2-1","2013-11-25","99",null,"Reserved for Future Use"]
[null,"2-2","2013-11-25","3","John","UI - Update Checkout Label View",null,null,null,null,"Francisco"]
[null,"2-3","2013-11-25","3","John","UI - Update Saved Items View",null,null,null,null,"Sal",1,null,null,null,null,"Interfacing that if the customer has a customer item number then bring ack that info"]
[null,"2-4","2013-11-25","3","John","UI - code retrieval of customer items from Database",null,null,null,null,"Sal",1,null,null,null,null,"save item popup - display existing customer item number for stock or MOD"]
[null,"2-5","2013-11-25","3","John","UI - code save of customer items to Database",null,null,null,null,"Sal",1,null,null,null,null,"saves item"]
[null,"2-6","2013-11-25","3","John","DB - RPC to return customer items to web",null,"Joe"]
[null,"2-7","2013-11-25","3","John","DB - RPC to save customer items to database",null,"John",3,null,null,null,null,null,null,null,"needs to update cross ref and check to see if iems are getting written correcty"]
[null,"2-8","2013-11-25","3","Cathy","Conversion - convert  items ",null,"Cathy",4,1,null,null,null,"Programming Specs - Customer Part Numbers",null,null,"new format for customer item numbers (custom and combine 3 description lines to 2"]
[null,"2-9","2013-11-25","99",null,"Reserved for Future Use"]
[null,"2-10","2013-11-25","3","Cathy","Avante - Modify the Customer Item Number Upload - Part I",null,"Joe",null,null,null,null,null,"Programming Specs - Customer Part Numbers","2013-12-26",null,"change to write the new CUSTPARTXREF.USR record"]
[null,"2-11","2013-11-25","3","John","Duplicate Customer Names",null,null,null,null,"Sal",null,null,null,null,null,"We concatenated the city and state to the name for display"]
[null,"2-12","2013-11-25","3","Cathy","Avante - Modify Existing Programs to Use CUSTPARTXRF.USR - Part II",null,"Joe",null,null,null,null,null,"Programming Specs - Customer Part Numbers","2013-12-26",null,"Format for custpart.usr will now have key for custom items to be co*cust*MODnnnn"]
[null,"2-13","2013-11-25","3","Cathy","Avante - Program to create CUSTPARTXRF.USR - Part I",null,"Joe",null,null,null,null,null,"Programming Specs - Customer Part Numbers","2013-12-26",null,"Create CUSTPARTXRF.USR for existing items"]
[null,"2-14","2013-11-25","3","Cathy","Avante - Customer Item Number Maintenance - Part I",null,"Joe",null,null,null,null,null,"Programming Specs - Customer Part Numbers","2013-12-26",null,"change to write the new CUSTPARTXREF.USR record"]
[null,"2-15","2013-11-25","1","Cathy","Avante - Customer Item Number Maintenance - Part II",null,"Cathy",2,2,null,null,null,"Programming Specs - Customer Part Numbers","2013-12-26",null,"Modify for the MOD item from Cpartnumber key change"]
[null,"2-16","2013-11-25","1","Cathy","Avante - Customer Item Number Upload - Part II",null,"Cathy",2,2,null,null,null,"Programming Specs - Customer Part Numbers","2013-12-26",null,"Modify for the MOD item from Cpartnumber key change"]
[null,"2-17",null,"2","Judy","DB - Create routine WEB.CREATE.CUSTOMER",null,"Wayne",10,null,null,null,null,"Programming Specs - Create/Modify Drop Ship Customer","2014-01-31",null,"Assign customer number and write to CUSTMST with billto defaults, no address and set inactive flag or update the existing customer"]
[null,"2-18",null,"2","Judy","DB - Modify Existing RPC$SHOPPINGCART_CREATEORDER",null,"Wayne",8,null,null,null,null,"Programming Specs - Create/Modify Drop Ship Customer","2014-01-31",null,"remove the logic and call the routine - logic must be moved out of stockcreate and into main program & called before stock/MOD orders are created"]
[null,"2-19",null,"2","Judy","DB - New RPC Called RPC$CUSTOMER_CREATE",null,"Wayne",4,null,null,null,null,"Programming Specs - Create/Modify Drop Ship Customer","2014-01-31",null,"web will call this program when it needs a customer created and will return all information back to the site"]
[null,"2-20",null,"1","John","UI - Call RPC$CUSTOMER_CREATE when adding saved item locations",null,null,null,null,"John",3]
[null,"2-21",null,"5","Judy","Avante - Investigate Inactive Flag Handling on Selects and Validations",null,"Judy"]
[null,"2-22",null,"1","John","UI - Address Checkout, catch user selected blank customer. Show form.",null,null,null,null,"John",10,null,null,null,null,"The user will be allowed to selected a customer that does not have enough data on it. We need to trap that and display entry form to allow user to fill out the rest of the info for that customer."]
[null,"2-23",null,"2","Judy","DB - Change cust selection when coming from Address Screen",null,"Wayne",2,null,null,null,null,"Programming Specs - Create/Modify Drop Ship Customer","2014-02-03",null,"Change CUSTOMER_GETBYFILTER to add ZIP = \"\" when coming from the Checkout Address Screen (FLAG will be a \"1\")"]
[null,"2-24",null,"99",null,"Reserved for Future Use"]
["SavedItems","3-0",null,"3",null,"Change the saved items record key",null,null,{"$f":"SUM(I41:I55)","v":0},{"$f":"SUM(J41:J55)","v":0},null,{"$f":"SUM(L41:L55)","v":0},{"$f":"SUM(M41:M55)","v":0},null,null,null,"From Contact to Bill-to Number --- Changing the location that the saved MOD items are stored, and changing file structure and programs to use the new structure. Including \"finding\" an existing MOD item from the Shop widget to pull up existing MOD items based on configuration."]
[null,"3-1","2013-11-25","3","John","DB - Create file to hold Mod Item Specification by Bill-to",null,"Joe"]
[null,"3-2","2013-11-25","3","John","DB - Modify File Structure for Contact Item information",null,"Joe"]
[null,"3-3","2013-11-25","3","John","DB - RPC$MODITEM_CREATE",null,"Joe",null,null,null,null,null,null,null,null,"Update saving of MOD items"]
[null,"3-4","2013-11-25","3","John","DB - RPC$CONTACTITEM_DELETE",null,"Joe",null,null,null,null,null,null,null,null,"Delete Billto Level data as well?"]
[null,"3-5","2013-11-25","3","John","DB - RPC$CONTACTITEM_GETBYFILTER",null,"Joe",null,null,null,null,null,null,null,null,"Pull info from billto level & Contact level"]
[null,"3-6","2013-11-25","3","John","DB - RPC$CONTACTITEM_GETBYID",null,"Joe",null,null,null,null,null,null,null,null,"Pull Info from billto level & Contact Level"]
[null,"3-7","2013-11-25","3","John","DB - RPC$CONTACTITEM_SAVE ",null,"Joe"]
[null,"3-8","2013-11-25","3","John","DB - RPC$ITEMTAG_GETBYFILTER",null,"Joe"]
[null,"3-9","2013-11-25","3","John","DB - RPC$ITEMTAG_GETBYFILTER2",null,"Joe"]
[null,"3-10","2013-11-25","3","John","DB - RPC$ITEMTAG_SELECT",null,"Joe"]
[null,"3-11","2013-11-25","3","John","DB - RPC$QUOTEITEM_GETBYSAVEDITEM",null,"Joe"]
[null,"3-12","2013-11-25","3","John","DB - RPC$SHAREDITEM_GETBYFILTER",null,"Joe"]
[null,"3-13","2013-11-25","3","John","DB - RPC$SHAREDITEM_SAVE",null,"Joe"]
[null,"3-14","2013-11-25","3","John","DB - RPC$SHIPMENTBUNDLING_GETBYFILTER",null,"Joe"]
[null,"3-15",null,"99",null,"Reserved for Future Use"]
["MyAccount","4-0",null,"2",null,"Process at Login - Deleting Expired Carts",null,null,{"$f":"SUM(I57:I59)","v":3},{"$f":"SUM(J57:J59)","v":0},null,{"$f":"SUM(L57:L59)","v":0},{"$f":"SUM(M57:M59)","v":0},null,null,null,"Purging \"old\" carts upon login based on time since last activity date. What defines \"old\" is a system wide setting."]
[null,"4-1",null,"2","John","DB - Write Last Activity Date to SHOPPINGCART.USR",null,"Joe",1.5,null,null,null,null,"https://laddawn1.atlassian.net/wiki/display/web/Functional+Spec.+-+Write+Cart+Last+Activity+Date","2014-01-15"]
[null,"4-2",null,"2","John","DB - Delete old carts upon user validation based on xxx days old",null,"Joe",1.5,null,null,null,null,"https://laddawn1.atlassian.net/wiki/pages/viewpage.action?pageId=27754595","2014-01-15",null,"Can carts be deleted by anyone other than the user that created them?"]
[null,"4-3",null,"99",null,"Reserved for Future Use"]
["Checkout","5-0",null,"3",null,"Duplicate P/O display in Checkout",null,null,{"$f":"SUM(I61:I63)","v":0},{"$f":"SUM(J61:J63)","v":0},null,{"$f":"SUM(L61:L63)","v":0},{"$f":"SUM(M61:M63)","v":0},null,null,null,"A popup showing the other orders this PO number is used on. Called from Payment screen of checkout."]
[null,"5-1",null,"3","John","Create Pop-up for Duplicate PO numbers",null,null,null,null,"Sal"]
[null,"5-2",null,"3","John","Handle user response to pop-up",null,null,null,null,"Francisco"]
[null,"5-3",null,"99",null,"Reserved for Future Use"]
["Checkout","6-0",null,"1",null,"Order Creation",null,null,{"$f":"SUM(I65:I81)","v":24.5},{"$f":"SUM(J65:J81)","v":0},null,{"$f":"SUM(L65:L81)","v":0},{"$f":"SUM(M65:M81)","v":0},null,null,null,"Separating bundles to Avante orders and create a master order.  Includes number assignment scheme."]
[null,"6-1",null,"3","Judy","Determine How To Create Orders from Bundles"]
[null,"6-2",null,"3","Judy","Create orders from Bundles",null,"Wayne"]
[null,"6-3",null,"3","Judy","Order Creation - Ship With Logic (ship with comment)",null,"Wayne",null,null,null,null,null,null,"2013-12-30"]
[null,"6-4",null,"3","Judy","Order Creation - Setting FOB Code for Customer Pickup",null,"Wayne",null,null,null,null,null,null,"2013-12-02","2013-12-02"]
[null,"6-5",null,"3","Judy","‘Must Ship Today Flag’ ",null,"Wayne",null,null,null,null,null,null,"2013-12-02","2013-12-02","setting on order based on time of day and bundle ship date"]
[null,"6-6",null,"3","Judy","Order source when ce enters order",null,"Wayne"]
[null,"6-7",null,"3","Judy","Creating a new Shipto Customer",null,"Wayne"]
[null,"6-8",null,"3","Judy","Write cart name to SOHDR.USR",null,"Wayne"]
[null,"6-9",null,5,"Judy","Move MOD  ‘ashad' and order shipping preference comments",null,null,null,null,null,null,null,null,null,null,"‘ashad’ comments and order shipping preference comments forward to new order"]
[null,"6-10",null,"3","Judy","Add Pallet Type as a w/o comment for MOD Orders",null,"Wayne",null,null,null,null,null,null,"2013-12-30",null,"Pallet Type (from shipping preferences) must be added as a w/o comment for MOD Orders"]
[null,"6-11","2013-12-19","2","Judy","Add 'Backordered' or 'Ship Complete' comment to order w/backorder",null,"Wayne",4,null,null,null,null,"Create Order from Checkout","2013-12-30",null,"For ship and b/o bundles, put 'Backorder' comment on the backordered order and nothing on main order.  For default bundle shipping everything in 3 days (because of b/o), put a 'ship complete' comment on the order."]
[null,"6-12","2013-12-30","2","Judy","Write Shipping Instruction Comments to Sales Order",null,"Wayne",4,null,null,null,null,"Create Order from Checkout"]
[null,"6-13","2014-01-03","1","Judy","Write w/o comment for 'no wooden slats' on Export Pallet jobs ",null,"Judy",4,null,null,null,null,null,null,null,"comment automatically goes on work orders for export pallet jobs to NOT use untreated wooden slats"]
[null,"6-14",null,"2","Judy","Write MOD Item# to SOHDR.USR when converting a quote",null,"Wayne",0.5]
[null,"6-15",null,"1","Judy","Write cc'd contacts to sales order",null,"Judy",4]
[null,"6-16",null,"1","Judy","Write upcharges to each order as revenue charge codes",null,"Judy",8,null,null,null,null,null,null,null,"Call WEB.CALC.UPCHARGES and write each upcharge to order using revenue charge codes"]
[null,"6-17",null,"99",null,"Reserved for Future Use"]
["Checkout","7-0",null,"1",null,"Checkout - Labeling",null,null,{"$f":"SUM(I83:I95)","v":10},{"$f":"SUM(J83:J95)","v":0},null,{"$f":"SUM(L83:L95)","v":6},{"$f":"SUM(M83:M95)","v":0},null,null,null,"Completion of the Labeling step of checkout process."]
[null,"7-1",null,"3","John","Validations",null,null,null,null,"Francisco",null,null,null,null,null,"customer part number required, third party, Brandit customer setup"]
[null,"7-2",null,1,"Judy","DB - Update Labeling to SHOPPINGCART.USR",null,"Judy",6,null,null,null,null,null,null,null,"when user hits save and continue we want to record what they said"]
[null,"7-3",null,"3","John","Interface with Bartender to Generate Label Images",null,null,null,null,"Francisco"]
[null,"7-4",null,"3","John","Set Up Paging to Step from Label to Label.",null,null,null,null,"Francisco"]
[null,"7-5",null,"1","John","Interface with Saved Items Popup.",null,null,null,null,"John",4,null,null,null,null,"pull up saved items popup with the correct tagging"]
[null,"7-6",null,"3","John","Refresh Label Image as Needed.",null,null,null,null,"Francisco"]
[null,"7-7",null,"2","John","DB - Retrieve Customer Part Number Information.",null,"John",4,null,null,null,null,null,null,null,"pull customer part number and description onto the label"]
[null,"7-8",null,"3","John","Return Brandit Information as Customer Object Properties",null,null,null,null,"Francisco"]
[null,"7-9",null,"3","John","Show Correct Options for Label Format ",null,null,null,null,"Francisco",null,null,null,null,null,"label type on top, check box options below, actual part numbers"]
[null,"7-10",null,1,"CHRIS","Creation of New Label Templates"]
[null,"7-11",null,"3","John","Handle Adding Label Comment",null,null,null,null,"Francisco"]
[null,"7-12",null,"1","John","UI - Retrieve Customer Part Number Information",null,null,null,null,"John",2]
[null,"7-13",null,"99",null,"Reserved for Future Use"]
["Checkout","8-0",null,"1",null,"Checkout - Addresses",null,null,{"$f":"SUM(I97:I103)","v":10},{"$f":"SUM(J97:J103)","v":0},null,{"$f":"SUM(L97:L103)","v":16},{"$f":"SUM(M97:M103)","v":0},null,null,null,"First step of the checkout process. Where the user selects or adds the ship to address."]
[null,"8-1",null,"3","Judy","Check Create Order F2 validations",null,null,null,null,null,null,null,null,null,null,"only diff is that zip code is entered, then city/state is defaulted from ZIPCODE.USR"]
[null,"8-2",null,"3","Judy","Update SHOPPINGCART.USR",null,"Wayne",null,0]
[null,"8-3",null,"3","John","Verify that ship-to zip matches cart zip (in case of zip code change)",null,null,null,null,"Francisco"]
[null,"8-4",null,"1","Judy","Handle changing of Ship-to",null,"Judy",4,null,null,null,null,null,null,null,"changing of customer number - after getting to summary page  - could have some FOB, VIA, or shipping preferences  - if shipto.nbr # customer in cart thendull out everything except the payment screen info"]
[null,"8-5",null,"1","John","UI - Handle \"TAGGED SHIPTO\"",null,null,null,null,"John",16,null,null,null,null,"selecting customer that was just \"tagged\" but is not a valid customer - has no address"]
[null,"8-6",null,"1","Judy","DB - Handle \"TAGGED SHIPTO\"",null,"Judy",6,null,null,null,null,null,null,null,"selecting customer that was just \"tagged\" but is not a valid customer - has no address"]
[null,"8-7",null,"99",null,"Reserved for Future Use"]
["Checkout","9-0",null,"1",null,"Checkout - Payment",null,null,{"$f":"SUM(I105:I108)","v":0},{"$f":"SUM(J105:J108)","v":0},null,{"$f":"SUM(L105:L108)","v":5},{"$f":"SUM(M105:M108)","v":0},null,null,null,"Checkout Payment step. Display / Validate / save."]
[null,"9-1",null,"3","Judy","Check Create Order F2 validations ",null,null,null,null,null,null,null,null,null,null,"**done-only diff is CC Name s/b reqd & Exp Date shouldn't default - UI??"]
[null,"9-2",null,"3","John","Make sure all validations from existing website are in new website  (UI?)"]
[null,"9-3",null,1,"John","Redesign Payment View to new specifications",null,null,null,null,"John",5]
[null,"9-4",null,"99",null,"Reserved for Future Use"]
["Checkout","10-0",null,"1",null,"Checkout - Giving",null,null,{"$f":"SUM(I110:I114)","v":6},{"$f":"SUM(J110:J114)","v":0},null,{"$f":"SUM(L110:L114)","v":2},{"$f":"SUM(M110:M114)","v":0},null,null,null,"Checkout Giving Page"]
[null,"10-1",null,3,"Judy","Check Create Order F2 validations - ",null,null,null,null,null,null,null,null,null,null,"*** NO GIVING SCREEN ON AVANTE SO NOT NEEDED - "]
[null,"10-2",null,"3","Judy","Update SHOPPINGCART.USR",null,"Wayne",null,0]
[null,"10-3",null,"1","John","UI - hook up response to the order",null,null,null,null,"John",2]
[null,"10-4",null,"1","John","DB - hook up response to the order",null,"John",6]
[null,"10-5",null,"99",null,"Reserved for Future Use"]
["Checkout","11-0",null,"1",null,"Checkout - Bundling View",null,null,{"$f":"SUM(I116:I136)","v":78},{"$f":"SUM(J116:J136)","v":0},null,{"$f":"SUM(L116:L136)","v":30},{"$f":"SUM(M116:M136)","v":0},null,null,null,"Complete Bundling page of checkout."]
[null,"11-1",null,"3","Judy","Bundling Validation - Ship Via",null,"Wayne",null,0]
[null,"11-2",null,"3","Judy","Bundling Validation - Freight Terms",null,"Wayne",null,0]
[null,"11-3",null,"3","Judy","Bundling Validation - Ship Date",null,"Wayne",null,0]
[null,"11-4",null,"3","Judy","Update Bundling to SHOPPINGCART.USR",null,"Janice",null,null,null,null,null,"checkout 'save' updating",null,"2013-12-11","Update all bundling info to SHOPPINGCART.USR"]
[null,"11-5",null,"3","Judy","Avante-Comments Maint Screen (Ship Instr)",null,"Janice",null,null,null,null,null,"checkout shipping instructions",null,"2013-12-11","Create new web sub-screen from SYS9012"]
[null,"11-6",null,"3","Judy","DB-WEB.COMMENTS.READ (Ship Instr)",null,"Janice",null,null,null,null,null,"checkout shipping instructions",null,"2013-12-11","Global prgm to read/return all data from COMMENTS.USR"]
[null,"11-7",null,"3","Judy","DB-RPC$COMMENTS_GETBYFILTER (Ship Instr",null,"Janice",null,null,null,null,null,"checkout shipping instructions",null,"2013-12-11","Pass all shipping instruction comments from select list by section to UI"]
[null,"11-8",null,"3","Judy","DB-RPC$COMMENTS_GETBYID (Ship Instr",null,"Janice",null,null,null,null,null,"checkout shipping instructions",null,"2013-12-11","Pass single shipping instruction comment to UI"]
[null,"11-9",null,"3","Judy","DB-Save & Continue Updating",null,"Janice",null,null,null,null,null,"checkout shipping instructions",null,"2013-12-11","Update shipping instructions to SHOPPINGCART.USR"]
[null,"11-10",null,"1","John","preserve (ship via, fob, ship inst) when merging and splitting bundles",null,"John",32,null,null,null,null,null,null,null,"Work needed to preserve (ship via, fob, ship inst) when merging and splitting bundles - if they split we preserve the same comments - run through defaults if freght terms change - if merging retain preference from merge \"to\" bundle"]
[null,"11-11","2013-12-24","2","Judy","DB-Shipping Instructions Enabling/Default Values & Comment Scrn Chng",null,"Janice",8,null,null,null,null,"checkout shipping instructions",null,null,"Send Enabled/Disabled & Default Value for each comment in Shipping Instruct & Add Revenue Chg Code to Comm Scrn"]
[null,"11-12","2013-12-30","3","John","UI Call Bundling Routines to fill screens from DB",null,null,null,null,"Francisco"]
[null,"11-13",null,"1","John","UI - Handle Collect and 3PB Freight Terms with Popup",null,null,null,null,"John",18,null,null,null,null,"enter third party information"]
[null,"11-14",null,"1","John","UI - Call RPC$COMMENTS_GETDEFAULTS",null,null,null,null,"John",10,null,null,null,null,"Call for every bundle"]
[null,"11-15",null,"2","Judy","DB - Call SOPS4007.5PS to establish LTL.FLAG",null,"Janice",10,null,null,null,null,"checkout shipping instructions (01/28/14)","2014-01-28",null,"Determine whether this bundle will be shipped LTL or Small Pkg using same logic as in Create Pickslips & update the bundle with the LTL.FLAG"]
[null,"11-16",null,"2","Judy","DB - RPC$COMMENTS_GETDEFAULTS",null,"Janice",8,null,null,null,null,"checkout shipping instructions (01/28/14)","2014-01-28",null,"Return comments for give billto , shipto, LTL / sm pkg - "]
[null,"11-17",null,"1","John","UI - Disable access to Comments PopUp based on Flag",null,null,null,null,"John",2,null,null,null,null,"if bundle going small pkg disable link"]
[null,"11-18",null,"1","Judy","Handle Setting Preference from Bundling When Create Order is Run",null,"Judy",4,null,null,null,null,null,null,null,"Set the preference when we save the customer"]
[null,"11-19","2014-01-29","3","Judy","DB - Availability Logic - Allow for Offline Warehouses",null,"Janice",0,null,null,null,null,null,null,null,"*** Janice already had this in the bundling logic - removed hours*** Apply logic that is in current site that re-routes orders to an alternate warehouse if they are offline (in SYSCON OFFLINE.WHS.LAD field 1)"]
[null,"11-20",null,"2","Judy","DB - Write bundle type to shoppingcart.usr",null,"Janice",16,null,null,null,null,"Write bundle type: 1=backorder; 2=ship complete; 3=other","2014-01-29",null,"Write a bundle type to shoppingcart.usr so that order creation program can add a SHIP COMPLETE or BACKORDER comment, if needed"]
[null,"11-21",null,"99",null,"Reserved for Future Use"]
["ActiveCart","12-0",null,"3",null,"Cart - Handle Price expiration of MOD items",null,null,{"$f":"SUM(I138:I143)","v":0},{"$f":"SUM(J138:J143)","v":0},null,{"$f":"SUM(L138:L143)","v":0},{"$f":"SUM(M138:M143)","v":0},null,null,null,"The active cart tab shows the customer what items still have \"active\" pricing, or pricing that will expire soon. This is about showing the customer the correct cues about their pricing on MOD items."]
[null,"12-1",null,"3","John","Create a view for Mod Items",null,null,null,null,"Ed"]
[null,"12-2",null,"3","John","Establish the state of the view and show correct clock icon",null,null,null,null,"Ed"]
[null,"12-3",null,"3","John","Disable Controls for expired items",null,null,null,null,"Ed"]
[null,"12-4",null,"3","John","Creating New Quote from Expired Quote",null,null,null,null,"Ed",null,null,null,null,null,"Create a new quote from expired quote and save new quote to SHOPPINGCART.USR and remove old"]
[null,"12-5",null,"3","Judy","DB - Mod item repricing",null,"Janice"]
[null,"12-7",null,"99",null,"Reserved for Future Use"]
["ActiveCart","13-0",null,"1",null,"Cart - Repricing MOD items in the cart.",null,null,{"$f":"SUM(I145:I147)","v":0},{"$f":"SUM(J145:J147)","v":0},null,{"$f":"SUM(L145:L147)","v":0},{"$f":"SUM(M145:M147)","v":0},null,null,null,"Changing Zip Code, CPU, QTY, Freight Option on the cart will trigger a repricing of the MOD item by calling the pricing routine with the correct flags. A subset of 17-0"]
[null,"13-1",null,"3","John","Call repricing routine and update existing quote ",null,"Janice",null,null,null,null,null,null,null,null,"qty, and freight option changes"]
[null,"13-2",null,"1","John","Show MOD price break pop-up for MOD items",null,"John",0,null,null,null,null,null,null,null,"they can change the price breaks from the cart - repricing line reprices price breaks"]
[null,"13-3",null,"99",null,"Reserved for Future Use"]
["ActiveCart","14-0",null,"1",null,"Cart - Handling Zipcode changes in the Cart.",null,null,{"$f":"SUM(I149:I154)","v":10},{"$f":"SUM(J149:J154)","v":0},null,{"$f":"SUM(L149:L154)","v":3},{"$f":"SUM(M149:M154)","v":0},null,null,null,"The customer is allowed to change the ZIP code for which the cart is built. This change effects availability dates, primary warehouse selection and MOD pricing."]
[null,"14-1",null,"3","John","Update availability dates for stock and mod items",null,null,null,null,"Ed"]
[null,"14-2",null,"3","John","Reprice the quote for MOD items (if expired it gets new quote)",null,null,null,null,"Ed"]
[null,"14-3",null,1,"John","DB - Remove checkout address informaton from SHOPPINGCART.USR",null,"John",5,null,null,null,null,null,null,null,"do we want to clear all or partial"]
[null,"14-4",null,1,"John","DB - Remove checkout bundling informaton from SHOPPINGCART.USR",null,"John",5]
[null,"14-5",null,"2","John","UI - Handling Ship-to Zip / Pick-up Changes",null,null,null,null,"Ed",3]
[null,"14-6",null,"99",null,"Reserved for Future Use"]
["ActiveCart","15-0",null,"1",null,"Cart - CE version of contact’s cart (by operator)",null,null,{"$f":"SUM(I156:I157)","v":8},{"$f":"SUM(J156:J157)","v":0},null,{"$f":"SUM(L156:L157)","v":0},{"$f":"SUM(M156:M157)","v":0},null,null,null,"While the customer contact is on the website, and CE logs in as that customer, we don't want them conflicting on the same active cart.  So CE will need its own version of the cart when logged in as another contact. And different CE users will have to have their own cart."]
[null,"15-1",null,"1",null,"DB - Change Shopping Cart Save and Shopping Cart Item Save",null,"John",8,null,null,null,null,null,null,null,"If there is an operator and no cart name then generate cart name based on a set of rules.   CE-Oper (amber) nn (1-999)"]
[null,"15-2",null,"99",null,"Reserved for Future Use"]
["ActiveCart","16-0",null,"0",null,"Cart - New print plate logic (no checkout until approval)",null,null,{"$f":"SUM(I159:I165)","v":0},{"$f":"SUM(J159:J165)","v":0},null,{"$f":"SUM(L159:L165)","v":32},{"$f":"SUM(M159:M165)","v":0},null,null,null,"If the MOD item in the cart has a print plate assigned that we do not have the image for the customer must upload the image through the site before being allowed to start the checkout process.  This is where they select the PDF on their system and upload it to Laddawn in a status of awaiting approval."]
[null,"16-1",null,1,"John","Detect a printed job and show upload link",null,null,null,null,"John",32]
[null,"16-2",null,"1","Judy","Carts with Plates Must be in their own Cart",null,"Judy",0,null,null,null,null,null,null,null,"Only if new print plate"]
[null,"16-3",null,"1","Judy","Upload Plate to Site From Cart",null,"Judy",0,null,null,null,null,null,null,null,"Allow anyone to upload pdf, assign the plate number and save the pdf"]
[null,"16-4",null,"1","XXXX","Disable Place Order Button on Checkout",null,"Judy",0,null,null,null,null,null,null,null,"One Bundle - date will change - don’t clear checkout information because order could sit for some time  - based on plate flag??"]
[]
[null,"16-7",null,"4","Judy","1/16-NO LONGER NEEDED Customer Supplied Plates",null,"Judy",0,null,null,null,null,null,null,null,"do we need this or not????? 1/16 WEB JAM - NO LONGER NEED THIS LOGIC"]
[null,"16-8",null,"99",null,"Reserved for Future Use"]
["ActiveCart","17-0",null,"1",null,"Cart - Changes to Items in a Cart (add, delete , quantity changes)",null,null,{"$f":"SUM(I167:I169)","v":1},{"$f":"SUM(J167:J169)","v":0},null,{"$f":"SUM(L167:L169)","v":4},{"$f":"SUM(M167:M169)","v":0},null,null,null,"A more inclusive statement of 13-0.  13-0 was referring to only MOD items, this is referring to both stock and MOD."]
[null,"17-1",null,1,"John","DB - Remove checkout bundling informaton from SHOPPINGCART.USR",null,"John",1,null,null,null,null,null,null,null,"add change delete based on what is done - this refers to the program in 14-4"]
[null,"17-2",null,1,"John","Update availability dates for stock and mod items",null,null,null,null,"John",4]
[null,"17-3",null,"99",null,"Reserved for Future Use"]
["ShopWidget","18-0",null,"3",null,"Marketplace - When to show MOD Result",null,null,{"$f":"SUM(I171:I174)","v":0},{"$f":"SUM(J171:J174)","v":0},null,{"$f":"SUM(L171:L174)","v":0},{"$f":"SUM(M171:M174)","v":0},null,null,null,"In some circumstances (CPU, or Mktplace Price higher than Laddawn stock) orders cannot be Marketplace orders.  This is referring to the work needed to ensure that marketplace MOD items are PPD only and a better price or leadtime than the stock item found. Currently all marketplace orders must be PPD."]
[null,"18-1",null,"3","Judy","BP WEB.MODITEM.CHECK - for 'Customer Pickup' if  Ziptop",null,"Janice",null,null,null,null,null,null,null,null,"If 'Customer Pickup' is chosen for Ziptop, do not create a Marketplace MOD Result"]
[null,"18-2","2014-01-27","1","John","No MOD if one exact import stock match & YMAC MOD is more expensive ",null,null,null,null,"John",0,null,null,null,null,"if there’s one exact stock match, that’s an import, and the YMAC MOD result is more expensive "]
[null,"18-3",null,"0","John","Marketplace 'import' quote",null,null,null,null,"John",0,null,null,null,null,"Should we be displaying both a domestic and import quote for marketplace?"]
[null,"18-4",null,"99",null,"Reserved for Future Use"]
["OrderHistory","19-0",null,0,null,"Modify results to handle master orders",null,null,{"$f":"SUM(I176:I178)","v":0},{"$f":"SUM(J176:J178)","v":0},null,{"$f":"SUM(L176:L178)","v":0},{"$f":"SUM(M176:M178)","v":0},null,null,null,"Currently Order History brings up list of avante orders.  This will need some work to be \"master order aware\"."]
[null,"19-1",null,"0","Cathy","Reserved for Future Use",null,"Cathy",0,0]
[null,"19-2",null,"99",null,"Reserved for Future Use"]
[null,"19-3",null,"99",null,"Reserved for Future Use"]
["OrderHistory","20-0",null,0,null,"Complete Summary Popup",null,null,{"$f":"SUM(I180:I182)","v":0},{"$f":"SUM(J180:J182)","v":0},null,{"$f":"SUM(L180:L182)","v":0},{"$f":"SUM(M180:M182)","v":0},null,null,null,"When the user clicks summary in Order History tab, this is what they will see."]
[null,"20-1",null,"0","Cathy","Reserved for Future Use",null,"Cathy",0,0]
[null,"20-2",null,"99",null,"Reserved for Future Use"]
[null,"20-3",null,"99",null,"Reserved for Future Use"]
["OrderHistory","21-0",null,0,null,"Complete Tracking Popup for all Carriers",null,null,{"$f":"SUM(I184:I186)","v":0},{"$f":"SUM(J184:J186)","v":0},null,{"$f":"SUM(L184:L186)","v":0},{"$f":"SUM(M184:M186)","v":0},null,null,null,"Order history tracking popup works for carriers with online tracking tools that do not require a login.  This is about how we handle these issues."]
[null,"21-1",null,"0","Cathy","Reserved for Future Use",null,"Cathy",0,0]
[null,"21-2",null,"99",null,"Reserved for Future Use"]
[null,"21-3",null,"99",null,"Reserved for Future Use"]
["CEWeb","22-0",null,"0",null,"Spinning off multiple requests.",null,null,{"$f":"SUM(I188:I190)","v":0},{"$f":"SUM(J188:J190)","v":0},null,{"$f":"SUM(L188:L190)","v":0},{"$f":"SUM(M188:M190)","v":0},null,null,null,"How are we going to handle multiple requests per call. Especially in regards to handling on hold requests and routings."]
[null,"22-1",null,"99",null,"Upon returning to Avante, Create appropriate requests.",null,null,null,null,null,null,null,null,null,null,"When they get back to Avante they will be looking at the \"WEB\" request.  If there are no transaction requests that need to be created, the WEB request will be saved.  If there are other transactions / requests prevent the save of the Web request."]
[null,"22-2",null,"0",null,"Track what the CE User has done, allow them to asign Comments.",null,null,null,null,null,null,null,null,null,null,"John had an Idea to show them a popup that included a grid of their activities and routing dropdown and a BS Box. Where they choose the activity above and routing below."]
[null,"22-3",null,"99",null,"Reserved for Future Use"]
["ShopWidget","23-0",null,"0",null,"Default and Validate Zip Code Based on Active Cart",null,null,{"$f":"SUM(I192:I195)","v":0},{"$f":"SUM(J192:J195)","v":0},null,{"$f":"SUM(L192:L195)","v":0},{"$f":"SUM(M192:M195)","v":0},null,null,null,"Handling enter and setting focus back to item number box after add button"]
[null,"23-1",null,"3","John","UI - default zipcode from active cart if any",null,null,null,null,"Ed"]
[null,"23-2",null,"3","John","UI - Validate the Zip Code when Adding Items",null,null,null,null,"Ed"]
[null,"23-3",null,"0","John","UI - Changes to the Pop-Up for Zip Code Discrepancies",null,null,null,null,"John",0,null,null,null,null,"Steve to Update Wiki with what is wanted"]
[null,"23-4",null,"99",null,"Reserved for Future Use"]
["CEWeb","24-0",null,"0",null,"Send CE to the Web at the right time.",null,null,{"$f":"SUM(I197:I203)","v":13},{"$f":"SUM(J197:J203)","v":0},null,{"$f":"SUM(L197:L203)","v":4},0,null,null,null,"This means not sending to the web other times."]
[null,"24-1",null,"1","Judy","DB - There will be a WEB request type. This needs to be created.",null,"Judy",1,null,null,null,null,null,null,null,"This is a SYSTBL, in that SYSTBL is the name of the Maintenance Process (Can be multiple) and the Display Process."]
[null,"24-2",null,"1","Judy","DB - Create TXX \"Marker\" record.",null,"Judy",4,null,null,null,null,null,null,null,"We will use the port # and KTXX crawling routine to find the appropriate TXX File. This holds info like Operator, Request #, Contact #, Billto Customer, etc. Key = WEBINFO*INTERNALTIME"]
[null,"24-3",null,"1","John","DB - Create Process to call Website with \"Marker ID\" and Port #",null,"John",8]
[null,"24-4",null,"1","John","UI - If PORT.NBR is passed in Push through authentication",null,null,null,null,"John",4]
[null,"24-5",null,"99",null,"Reserved for Future Use"]
[null,"24-6",null,"99",null,"Reserved for Future Use"]
[null,"24-7",null,"99",null,"Reserved for Future Use"]
["CEWeb","25-0",null,"1",null,"CE & Sales Impersonating a contact.",null,null,{"$f":"SUM(I205:I215)","v":16},{"$f":"SUM(J205:J215)","v":0},null,{"$f":"SUM(L205:L215)","v":6},{"$f":"SUM(M205:M215)","v":0},null,null,null,"How will Laddawn staff impersonate a contact on the website, and what special considerations do we need to take into account. And do CE / CR / Sales have different fields available on the site."]
[null,"25-1","2013-12-30","3","Judy","DB - Write Correct Operator Codes to Quotes",null,"Joe",null,null,null,null,null,"Programming Spec-Add'l Quote Updating","2013-12-31"]
[null,"25-2","2013-12-30","3","Judy","DB - Write Correct Operator Code to Orders",null,"Wayne",null,0,null,null,null,"Programming Spec-Create Order from Checkout","2013-12-31"]
[null,"25-3","2013-12-30","1","John","UI - Carry Port Number Throughout Session",null,null,null,null,"Ed",6,null,"CE Login as Contact"]
[null,"25-4","2014-01-14","1","John","DB - Change Authentication to Check for Port Number",null,"Joe",4,null,null,null,null,"CE Login as Contact"]
[null,"25-5","2014-01-30","1","Judy","Allow ce to override FOB Code to PPD if < $500",null,"Judy",0,null,null,null,null,null,null,null,"CE may override FOB to PPD if order value is close to $500.  Allow them to override in bundling."]
[null,"25-6",null,"1","John","DB - Set Master Buyer Flag to NO if CE - always",null,"John",2]
[null,"25-7",null,"1","Cathy","DB - Set Contact Number Variable to Ncustno if NEPB Customer",null,"Cathy",3,0,null,null,null,null,null,null,"Change the RPC validate contact to see if there is a contact number in the TXX file"]
[null,"25-8",null,"1","Cathy","DB - Change Contact Read to Map Contact Info to NEPB Customer Data",null,"Cathy",3,0,null,null,null,null,null,null,"If NEPB then map SLSCONTACT fields to billto CUSTMST fields."]
[null,"25-9",null,"1","Cathy","DB - Order and Quote Create Programs for NEPB",null,"Cathy",4,0,null,null,null,null,null,null,"Do not update the order and quote files with the contact number if NEPB"]
[null,"25-10","2014-01-31","0","Judy","Quote 'on hold' warning message when checkout on MOD Item",null,"Judy",0,null,null,null,null,null,null,null,"Currently, ce sees a warning message everytime they go into Quote Entry for an existing quote if at least one c/e request attached to this order is on hold.  I confirmed with Meme that this is still needed."]
[null,"25-11",null,"99",null,"Reserved for Future Use"]
["SavedItems","26-0",null,"1",null,"Saved Items / Multiple Quotes / MOD item in Multiple Carts",null,null,{"$f":"SUM(I217:I219)","v":4},{"$f":"SUM(J217:J219)","v":0},null,{"$f":"SUM(L217:L219)","v":6},{"$f":"SUM(M217:M219)","v":0}]
[null,"26-1",null,"1","Judy","DB - Returning if the MOD # and QUOTE are in a Cart",null,"Judy",4,null,null,null,null,null,null,null,"Look for MOD #  or Quote nbr in SHOPPINGCART.USR return list of found carts if found (If we pass a MOD # include it in the select, If we pass in a QUOTE.NBR, that is what we are looking for) Could be a modification to RPC$SHOPPINGCART_GETBYFILTER."]
[null,"26-2",null,"1","John","UI - Show customer popup if Quote is in another Cart",null,null,null,null,"John",6,null,null,null,null,"If Previous task returns carts for the given QUOTE tell the user they can view that quote or get a new price."]
[null,"26-3",null,"99",null,"Reserved for Future Use"]
["SavedItems","27-0",null,"1",null,"MOD item cannot be in the same cart more than once",null,null,{"$f":"SUM(I221:I222)","v":0},{"$f":"SUM(J221:J222)","v":0},null,{"$f":"SUM(L221:L222)","v":6},{"$f":"SUM(M221:M222)","v":0}]
[null,"27-1",null,"1","John","UI - IF MOD item in active Cart disable Add to cart button.",null,null,null,null,"John",6,null,null,null,null,"We need to stop the user from adding the same MOD item the the cart a second time."]
[null,"27-2",null,"99",null,"Reserved for Future Use"]
["CEWeb","28-0",null,"5",null,"CE - Multiple Sessions - making it work",null,null,{"$f":"SUM(I224:I226)","v":0},{"$f":"SUM(J224:J226)","v":0},null,{"$f":"SUM(L224:L226)","v":0},{"$f":"SUM(M224:M226)","v":0},null,null,null,"How will CE work if we cannot use multiple web sessions. Initial investigation is done and works in IE* and above, Chrome, not Firefox"]
[null,"28-1",null,"99",null,"Reserved for Future Use",null,null,null,null,null,null,null,null,null,null,"Ask Franciso if he has knowledge on "]
[null,"28-2",null,"99",null,"Reserved for Future Use"]
[null,"28-3",null,"99",null,"Reserved for Future Use"]
["CEWeb","29-0",null,"0",null,"Godzilla - CE Quote Search",null,null,{"$f":"SUM(I228:I232)","v":0},{"$f":"SUM(J228:J232)","v":0},null,{"$f":"SUM(L228:L232)","v":0},{"$f":"SUM(M228:M232)","v":0},null,null,null,"When the user fills out the Shop Widget we will look for that same item in the shopping carts, recent order history, and saved items."]
[null,"29-1",null,"0",null,"DB - Banner for Similar Items Found",null,null,null,null,null,null,null,null,null,null,"Determine if there is a match in MOD.ITMMST.USR and signal hit by retuning all MOD item numbers in PART.NBR"]
[null,"29-2",null,"0",null,"UI - Banner for Similar Items Found",null,null,null,null,null,null,null,null,null,null,"Display correct banner message"]
[null,"29-3",null,"0",null,"UI - Middle tier support",null,null,null,null,null,null,null,null,null,null,"Determine method to return values from database to front end"]
[null,"29-4",null,"0",null,"DB - Pass to UI list of all customer's quotes matching width/depth/length",null,null,null,null,null,null,null,null,null,null,"Include in list expired quotes that were never saved to saveditems (ie, were only in a cart).  Location will be 'expired item'"]
[null,"29-5",null,"99",null,"Reserved for Future Use"]
["Miscellaneous","30-0",null,"1","Judy","Miscellaneous Avante Items",null,null,{"$f":"SUM(I234:I247)","v":105},{"$f":"SUM(J234:J247)","v":2},null,{"$f":"SUM(L234:L247)","v":4},{"$f":"SUM(M234:M247)","v":0}]
[null,"30-1",null,1,"Judy","Avante - QUO4000 & SOP4000",null,"Judy",8,null,null,null,null,null,null,null,"secure entry to allow only NS items"]
[null,"30-2",null,"2","Judy","Avante - new CPU FOB code",2,"Janice",24,null,null,null,null,"Avante CPU Freight Terms",null,null,"Janice will investigate and make reqd changes to Avante programs for new FOB Code CPU - John or Cathy should check Clippership"]
[null,"30-3",null,1,"Judy","Avante - SOP4000 & QUO4001",null,"Judy",4,null,null,null,null,null,null,null,"assign master order# for sample/NS orders - one for one - master order and an A version."]
[null,"30-4",null,"1","Judy","Avante - Sales Order Entry and Sales Order Display",null,"Judy",16,null,null,null,null,null,null,null,"searching/viewing orders using master order# - launch screen?"]
[null,"30-5",null,1,"Judy","Avante - MOD Configuration Report Changes",null,"Judy",16,null,null,null,null,null,null,null,"report changes due to restructure of configuration"]
[null,"30-6",null,1,"Judy","Avante - Must Ship Today Report",null,"Judy",2,null,null,null,null,null,null,null,"resort by shipment status or must ship today flag"]
[null,"30-7",null,1,"Judy","Avante - Label Item Description for Marketplace",null,"Judy",4,null,null,null,null,null,null,null,"format has changed to be more like other custom items"]
[null,"30-8",null,"1","Judy","Avante - Searches",null,"Judy",3,null,null,null,null,null,null,null,"add 'zip code' prompt to the billto # search in c/e requests - for orgs with multiple bill-to's"]
[null,"30-9",null,"1","Judy","Excel Report - Pallet Info",null,"Judy",8,null,null,null,null,null,null,null,"go-live that lists pallet info that can be entered as preferences"]
[null,"30-10",null,"1","Cathy","Excel Report - Customer Item Info",null,"Cathy",2,2,null,null,null,null,null,null,"go-live that lists customers using their item numbers so preferences can be set"]
[null,"30-11","2014-01-09","1","John","Clippership - new CPU FOB Code",null,null,null,null,"John",4,null,null,null,null,"Check clippership to make sure it can handle new FOB Code 'CPU'"]
[null,"30-12","2014-01-09","1","Judy","DB - Build Label Descriptions",null,"Judy",16,null,null,null,null,null,null,null,"This is what Sal wrote for compliance - needs to be re-written on the back end"]
[null,"30-13",null,"1","Judy","Avante - New Drop Ship Customers - Create with BW Ship Via",null,"Judy",2,null,null,null,null,null,null,null,"Check with Wayne to see if this is done"]
[null,"30-14",null,"99",null,"Reserved for Future Use"]
["ShopWidget","31-0",null,"1",null,"Continue to Test and Bug Fix the Shop Widget",null,null,{"$f":"SUM(I249:I251)","v":0},{"$f":"SUM(J249:J251)","v":0},null,{"$f":"SUM(L249:L251)","v":0},{"$f":"SUM(M249:M251)","v":0},null,null,null,"We suspect there are remaining bugs in this area that have not yet been found.  This is the task of fixing them when they are found."]
[null,"31-1",null,"99",null,"Reserved for Future Use"]
[null,"31-2",null,"99",null,"Reserved for Future Use"]
[null,"31-3",null,"99",null,"Reserved for Future Use"]
["ShopWidget","32-0",null,"1",null,"Validations - Group Validations",null,null,{"$f":"SUM(I253:I255)","v":0},{"$f":"SUM(J253:J255)","v":0},null,{"$f":"SUM(L253:L255)","v":25},{"$f":"SUM(M253:M255)","v":0},null,null,null,"Group validations in the shop widget as explained on the next line."]
[null,"32-1",null,"1","John","Display required Fields in Message box.",null,null,null,null,"John",1,null,null,null,null,"Calling required field validation by group.  On find and on close of a group. IF the user never goes to a field, field validation never fires so group validation is needed."]
[null,"32-2",null,"1","John","Display Marker flags by missing data.",null,null,null,null,"John",24,null,null,null,null,"design has red markers next to missing data"]
[null,"32-3",null,"99",null,"Reserved for Future Use"]
["ShopWidget","33-0",null,"0",null,"Changing Quotes",null,null,{"$f":"SUM(I257:I260)","v":0},{"$f":"SUM(J257:J260)","v":0},null,{"$f":"SUM(L257:L260)","v":0},{"$f":"SUM(M257:M260)","v":0},null,null,null,"Retrieving a saved item with its quote intact, having the website tracking whether or not it has revised a quote already in this session, and having the pricing routines return prices based on the correct information."]
[null,"33-1",null,"0","John","Change Find button to Ask Modify or Create New Quote",null,null,null,null,"John",0,null,null,null,null,"Pulling up a saved item and making changes.  Exp vs unexp/unconverted; reprice/new price; increment config and overlay saved items"]
[null,"33-2",null,"0","John","Build PopUp to Ask Question",null,null,null,null,"John",0]
[null,"33-3",null,"0","John","Preserve CONFIG.REV While Making Changes",null,null,null,null,"John",0]
[null,"33-4",null,"99",null,"Reserved for Future Use"]
["ShopWidget","34-0",null,"1",null,"Extended Descriptions",null,null,{"$f":"SUM(I262:I264)","v":0},{"$f":"SUM(J262:J264)","v":0},null,{"$f":"SUM(L262:L264)","v":1},{"$f":"SUM(M262:M264)","v":0},null,null,null,"The plan is to have a routine build the extended description and specification based on the answers the user supplied during the configuration stage.  Maketing has not yet supplied the values to link to the given questions for this system to be implemented."]
[null,"34-1",null,"1","OWEN","Marketing notes for extended descriptions",null,null,null,null,null,null,null,null,null,null,"Need Marketing Approval for the format and the approach."]
[null,"34-2",null,"1","John","DB - Call Building of Extended Description for MOD items",null,null,null,null,"John",1]
[null,"34-3",null,"99",null,"Reserved for Future Use"]
["ShopWidget","35-0",null,"0",null,"Atlanta Production",null,null,{"$f":"SUM(I266:I269)","v":12},{"$f":"SUM(J266:J269)","v":0},null,{"$f":"SUM(L266:L269)","v":0},{"$f":"SUM(M266:M269)","v":0},null,null,null,"Rules for assigning Atlanta as the production facility on a MOD Order - David providing rules"]
[null,"35-1",null,"1","Judy","DB - Modify manufacturing facility assignment process",null,"Judy",8]
[null,"35-2",null,"0","Judy","DB - Modify bottomseal/sideweld pass/fail rules to add Atlanta",null,"Judy",0]
[null,"35-3",null,"1","Judy","Avante - Modify Avante programs to add Atlanta as a production facility",null,"Judy",4]
[null,"35-4",null,"99",null,"Reserved for Future Use"]
["ShopWidget","36-0",null,"4",null,"Level 3 defaults",null,null,{"$f":"SUM(I271:I272)","v":0},{"$f":"SUM(J271:J272)","v":0},null,{"$f":"SUM(L271:L272)","v":0},{"$f":"SUM(M271:M272)","v":0},null,null,null,"Values that are passed in to the search results routine are considered even when that category is disabled.  We want to ignore disabled fields to get the correct information back in results."]
[null,"36-1",null,"4","Judy","Widget Level 3 Defaults",null,"Joe",null,null,null,null,null,null,null,null,"null out defaults if level 3 disabled"]
[null,"36-2",null,"99",null,"Reserved for Future Use"]
["SavedCarts","37-0",null,"1",null,"Results",null,null,{"$f":"SUM(I274:I276)","v":4},{"$f":"SUM(J274:J276)","v":0},null,{"$f":"SUM(L274:L276)","v":6},{"$f":"SUM(M274:M276)","v":0}]
[null,"37-1",null,"1","John","Share count on results page",null,null,null,null,"John",6,null,null,null,null,"the count of how many user has shared the cart."]
[null,"37-2",null,"1","John","DB - Record the Share Event",null,"John",4,null,null,null,null,null,null,null,"When the user hits share when sharing a cart we need to record in the database what was sent so we can display it from saved carts."]
[null,"37-3",null,"99",null,"Reserved for Future Use"]
["SavedCarts","38-0",null,"0",null,"Handling Working on Someone Else's Cart",null,null,{"$f":"SUM(I278:I280)","v":0},{"$f":"SUM(J278:J280)","v":0},null,{"$f":"SUM(L278:L280)","v":0},{"$f":"SUM(M278:M280)","v":0},null,null,null,"Saved Carts allows you to find and \"activate\" someone else's cart.  We need to figure out how that is going to work as far as who owns the order that gets created, and what notifications need to happen, and how."]
[null,"38-1",null,"0","John","UI Changes",null,null,null,null,"John",0,null,null,null,null,"Changes to the UI / Avante based on preferences"]
[null,"38-2",null,"0","Judy","Avante DB Changes",null,"Judy",null,0]
[null,"38-3",null,"99",null,"Reserved for Future Use"]
["ShopWidget","39-0",null,"0",null,"MOD Result - Random Repeat",null,null,{"$f":"SUM(I282:I285)","v":0},{"$f":"SUM(J282:J285)","v":0},null,{"$f":"SUM(L282:L285)","v":0},0,null,null,null,"Random Repeat MOD Result"]
[null,"39-1","2014-01-27","0","Judy","Add'l printing charge if Width > 28\"",null,null,null,null,null,null,null,null,null,null,"Tom will provide design.  Add add'l 12% upcharge in same program that calculates printing upcharge"]
[null,"39-2",null,"99",null,"Reserved for Future Use"]
[null,"39-3",null,"99",null,"Reserved for Future Use"]
[null,"39-4",null,"99",null,"Reserved for Future Use"]
["ShareCart","40-0",null,"1",null,"Redisplay Shared Cart from Saved Carts",null,null,{"$f":"SUM(I287:I289)","v":8},{"$f":"SUM(J287:J289)","v":0},null,{"$f":"SUM(L287:L289)","v":20},{"$f":"SUM(M287:M289)","v":0},null,null,null,"We need to display the information that was shared by our customers to their colleagues and customers."]
[null,"40-1",null,"1","John","UI - Create the PopUp to Display Shared Carts",null,null,null,null,"John",20]
[null,"40-2",null,"1","John","DB - Return Shared Cart Information",null,"John",8]
[null,"40-3",null,"99",null,"Reserved for Future Use"]
["ActiveCart","41-0",null,"1",null,"MOD Item Descriptions",null,null,{"$f":"SUM(I291:I293)","v":8},{"$f":"SUM(J291:J293)","v":0},null,{"$f":"SUM(L291:L293)","v":0},{"$f":"SUM(M291:M293)","v":0},null,null,null,"We need to establish how we are going to return descriptions in the different areas of the site for MOD items since they aren't really stored anywhere."]
[null,"41-1",null,"1","John","DB - Imbed the Print Plate Upload Link",null,"John",6]
[null,"41-2",null,"1","John","DB - Return Built Descriptions to Web",null,"John",2]
[null,"41-3",null,"99",null,"Reserved for Future Use"]
["ActiveCart","42-0",null,"2",null,"Freight Dropdown",null,null,{"$f":"SUM(I295:I297)","v":0},{"$f":"SUM(J295:J297)","v":0},null,{"$f":"SUM(L295:L297)","v":0},{"$f":"SUM(M295:M297)","v":0},null,null,null,"We have to respond to the user changing this field from the cart."]
[null,"42-1",null,"3",null,"Reprice the Mod item and Update Quote when Freight Selected",null,null,null,null,"Ed",null,null,null,null,null,"included / not incuded drop down in the cart"]
[null,"42-2",null,"3",null,"Change Drop Down to on CPU Selection",null,null,null,null,"Ed",null,null,null,null,null,"when they choose cpu box to dropdown goes away and logic is based on freight not included"]
[null,"42-3",null,"99",null,"Reserved for Future Use"]
["ActiveCart","43-0",null,"1",null,"Total Items",null,null,{"$f":"SUM(I299:I301)","v":2},{"$f":"SUM(J299:J301)","v":0},null,{"$f":"SUM(L299:L301)","v":0},{"$f":"SUM(M299:M301)","v":0},null,null,null,"Currently the item count on the cart tab does not include MOD items, we need to fix this."]
[null,"43-1",null,"1","John","DB - Change Cart Value Program to Include MOD items",null,"John",2]
[null,"43-2",null,"99",null,"Reserved for Future Use"]
[null,"43-3",null,"99",null,"Reserved for Future Use"]
["Share Cart","44-0",null,"1",null,"Sharing MOD Quote",null,null,{"$f":"SUM(I303:I305)","v":4},{"$f":"SUM(J303:J305)","v":0},null,{"$f":"SUM(L303:L305)","v":0},{"$f":"SUM(M303:M305)","v":0},null,null,null,"Currently the item count on the cart tab does not include MOD items, we need to fix this."]
[null,"44-1",null,"1","Judy","DB - Write cc'd contacts to Quote when sharing cart or saved MOD item",null,"Judy",4,null,null,null,null,null,null,null,"When a MOD item is shared (via cart or saved item or results), write all cc'd contacts to the QUHDR.USR"]
[null,"44-2",null,"99",null,"Reserved for Future Use"]
[null,"44-3",null,"99",null,"Reserved for Future Use"]
["ActiveCart","45-0",null,"3",null,"Quick Add",null,null,{"$f":"SUM(I307:I309)","v":0},{"$f":"SUM(J307:J309)","v":0},null,{"$f":"SUM(L307:L309)","v":0},{"$f":"SUM(M307:M309)","v":0},null,null,null,"Handling enter and setting focus back to item number box after add button"]
[null,"45-1",null,"3","John","Using Quick Add - Set Focus Back to to Item Number",null,null,null,null,"Ed"]
[null,"45-2",null,"99",null,"Reserved for Future Use"]
[null,"45-3",null,"99",null,"Reserved for Future Use"]
["ShopWidget","47-0",null,"1",null,"Results - show message when can't make MOD item",null,null,{"$f":"SUM(I311:I313)","v":2},{"$f":"SUM(J311:J313)","v":0},null,{"$f":"SUM(L311:L313)","v":0},{"$f":"SUM(M311:M313)","v":0},null,null,null,"Establishing when we can make a MOD item is working correctly, but we may need to rewrite the wording."]
[null,"47-1",null,"1","John","DB - Return Correct Wording for Banner Message",null,"John",2]
[null,"47-2",null,"99",null,"Reserved for Future Use"]
[null,"47-3",null,"99",null,"Reserved for Future Use"]
["ShopWidget","48-0",null,"1",null,"Detecting WHS discrepancy for CPU MOD items.",null,null,{"$f":"SUM(I315:I320)","v":2},{"$f":"SUM(J315:J320)","v":0},null,{"$f":"SUM(L315:L320)","v":23},{"$f":"SUM(M315:M320)","v":0},null,null,null,"We need to display a message telling the customer this item may not be made at their nearest warehouse when it is a CPU search, This means we need to detect when that is the case."]
[null,"48-1",null,"1","Judy","DB - Need to return Mfg Whs to the UI",null,"Judy",2,null,null,null,null,null,null,null,"Changes to SHOPPINGCARTITEM.READ and MODPRODUCTITEM.READ to read PRICING.ARRAY and set it into DATAFIELDS as NAME MFG.WHS.no NAMED.PARAM is needed."]
[null,"48-2",null,"1","John","UI Widget - Display Discrepancey Whs Mgs in Banner",null,null,null,null,"John",8,null,null,null,null,"compare mfg warehouse to pickup warehouse and display msg on MOD item if different.  This must be done on Shop Widget and Cart"]
[null,"48-3",null,"1","John","UI Widget - Disable Accordingly Until they Make the Correct Zip Change",null,null,null,null,"John",4,null,null,null,null,"Do not allow them to add this item to a cart until they change it to Ship To or change the CPU Whs."]
[null,"48-4",null,"1","John","UI Cart - Display Discrepancy Whs message on item in cart",null,null,null,null,"John",5]
[null,"48-5",null,"1","John","UI Cart - Disable Checkout button if any Whs Discrepancy exists in cart.",null,null,null,null,"John",6]
[null,"48-6",null,"99",null,"Reserved for Future Use"]
["ShopWidget","49-0",null,1,null,"Enter YMAC Rules for ALL categories",null,null,{"$f":"SUM(I322:I323)","v":0},{"$f":"SUM(J322:J323)","v":0},null,{"$f":"SUM(L322:L323)","v":0},{"$f":"SUM(M322:M323)","v":0},null,null,null,"YMAC searches is based on rules that are entered into Avante (SYS9026), I need to enter the basis of these rules to start."]
[null,"49-1",null,"1","JIM","Reserved for Future Use"]
[null,"49-2",null,"99",null,"Reserved for Future Use"]
["ShopWidget","50-0",null,"1",null,"Banner Search - Search by Customer Part# or MOD Item Nbr",null,null,{"$f":"SUM(I325:I327)","v":28},{"$f":"SUM(J325:J327)","v":0},null,{"$f":"SUM(L325:L327)","v":0},{"$f":"SUM(M325:M327)","v":0},null,null,null,"Add ability - This is in addition to the stock item# search already in place"]
[null,"50-1","2013-12-11","1","Judy","DB - Update RPC$SEARCHFIELD_GETDEFAULTVALUES",null,"Judy",20,null,null,null,null,null,null,null,"Populate the Widget with the correct values"]
[null,"50-2",null,"1","John","DB - Update RPC$PRODUCT ITEM_GETBYPARTNBR",null,"John",8,null,null,null,null,null,null,null,"Check for customer item first, then check stock then Mod"]
[null,"50-3",null,"99",null,"Reserved for Future Use"]
["OrderHistory","52-0",null,"0",null,"Remake Orders - Re-Order Page",null,null,{"$f":"SUM(I329:I331)","v":0},{"$f":"SUM(J329:J331)","v":0},null,{"$f":"SUM(L329:L331)","v":0},{"$f":"SUM(M329:M331)","v":0},null,null,null,"Remake order logic needs to be added for CE only"]
[null,"52-1",null,"99",null,"Reserved for Future Use",null,null,null,null,null,null,null,null,null,null,"John wants to discuss"]
[null,"52-2",null,"99",null,"Reserved for Future Use"]
[null,"52-3",null,"99",null,"Reserved for Future Use"]
["ActiveCart","53-0",null,"0",null,"Stock & MOD Price Overrides (Misc$)",null,null,{"$f":"SUM(I333:I335)","v":0},{"$f":"SUM(J333:J335)","v":0},null,{"$f":"SUM(L333:L335)","v":0},{"$f":"SUM(M333:M335)","v":0},null,null,null,"Detecting the user as someone that can override prices, giving them an interface to change the prices in the cart, and save those \"overrides\""]
[null,"53-1",null,"99",null,"Reserved for Future Use"]
[null,"53-2",null,"99",null,"Reserved for Future Use"]
[null,"53-3",null,"99",null,"Reserved for Future Use"]
["Checkout","54-0",null,"1",null,"Checkout - Summary",null,null,{"$f":"SUM(I337:I343)","v":16},{"$f":"SUM(J337:J343)","v":0},null,{"$f":"SUM(L337:L343)","v":38.5},{"$f":"SUM(M337:M343)","v":0},null,null,null,"The summary page for checkout is a work in progress.  "]
[null,"54-1",null,"1","John","UI - Complete Bundling Stage",null,null,null,null,"John",6]
[null,"54-2",null,"1","John","UI - CC Box DropDown - Auto Complete",null,null,null,null,"John",20,null,null,null,null,"Only allow people in sales org contacts - give message for email addresses outside the sales org"]
[null,"54-3",null,"1","John","UI - Change to say \"Copy Order Summary To\"",null,null,null,null,"John",0.5]
[null,"54-4",null,"1","John","DB - Default CC to Sales Org Contact",null,"John",16]
[null,"54-5",null,"1","John","UI - Warning PopUp for Freeform CC",null,null,null,null,"John",4,null,null,null,null,"warn when this person is not in the sales organization"]
[null,"54-6",null,"1","John","UI - Call Create Order and Show PopUp",null,null,null,null,"John",8,null,null,null,null,"Choosing continue needs to skip giving page if CE or less then 100.00"]
[null,"54-7",null,"99",null,"Reserved for Future Use"]
["Checkout","56-0",null,"1",null,"Add Order Total Panel",null,null,{"$f":"SUM(I345:I349)","v":12},{"$f":"SUM(J345:J349)","v":0},null,{"$f":"SUM(L345:L349)","v":0},{"$f":"SUM(M345:M349)","v":0},null,null,null,"The order total panel is the section on the checkout pages where the user sees the order total and any order charges we are charging."]
[null,"56-1",null,"3","Judy","DB - FCT.CART.MODVALUE",null,"Wayne",4,null,null,null,null,"Programming Specs-Calculate Cart Value","2014-01-27",null,"Calculate MOD Item Total (Stock Item total program is already complete)"]
[null,"56-2",null,"2","Judy","DB - RPC$SHOPPINGCART_GETORDERVALUE",null,"Wayne",6,null,null,null,null,"Programming Specs-Calculate Cart Value","2014-01-27",null,"Call all the totals programs and retrun the data to the UI - (Sum Stock Items, MOD Items, Order Upcharge) - WRAPPER PROGRAM"]
[null,"56-3",null,"3","Judy","DB - RPC$UTILITY_GETSESSIONINFO",null,"Wayne",2,null,null,null,null,"Programming Specs-Calculate Cart Value","2014-01-27",null,"Process that will return session info to the UI. For now, the only thing in this program is the web discount%"]
[null,"56-4",null,"99",null,"Reserved for Future Use"]
[null,"56-5",null,"99",null,"Reserved for Future Use"]
["Checkout","57-0",null,"0",null,"Labeling",null,null,{"$f":"SUM(I351:I354)","v":0},{"$f":"SUM(J351:J354)","v":0},null,{"$f":"SUM(L351:L354)","v":0},{"$f":"SUM(M351:M354)","v":0},null,null,null,"Writing the labeling step of the checkout process. Including interfacing with Bartender."]
[null,"57-1",null,"0",null,"Handle Third Party Labels"]
[null,"57-2",null,"99",null,"Reserved for Future Use"]
[null,"57-3",null,"99",null,"Reserved for Future Use"]
[null,"57-4",null,"99",null,"Reserved for Future Use"]
["Checkout","58-0",null,"1",null,"Master User Setup",null,null,{"$f":"SUM(I356:I358)","v":0},{"$f":"SUM(J356:J358)","v":0},null,{"$f":"SUM(L356:L358)","v":5},{"$f":"SUM(M356:M358)","v":0},null,null,null,"Allowing the user to choose what bill to they want to work under, and changing filtering and notifications to that end."]
[null,"58-1",null,"1",null,"UI -Message to Master User",null,null,null,null,"John",3,null,null,null,null,"Tell master user that they can work under different billtos"]
[null,"58-2",null,"1",null,"UI - Enable suppression of Message",null,null,null,null,"John",2,null,null,null,null,"Add property to contact to hold flag to suppress this message"]
[null,"58-3",null,"99",null,"Reserved for Future Use"]
["Checkout","60-0",null,"3",null,"Checkout Labeling - Build Label Image",null,null,{"$f":"SUM(I360:I362)","v":0},{"$f":"SUM(J360:J362)","v":0},null,{"$f":"SUM(L360:L362)","v":0},{"$f":"SUM(M360:M362)","v":0}]
[null,"60-1",null,"3","John","Bar Tender Label",null,null,null,null,"Francisco"]
[null,"60-2",null,"99",null,"Reserved for Future Use"]
[null,"60-3",null,"99",null,"Reserved for Future Use"]
["Miscellaneous","61-0",null,"2",null,"Cross Browser Support",null,null,{"$f":"SUM(I364:I368)","v":0},{"$f":"SUM(J364:J368)","v":0},null,{"$f":"SUM(L364:L368)","v":96},{"$f":"SUM(M364:M368)","v":0},null,null,null,"Testing on Multiple Platforms / Issues with IE8"]
[null,"61-1",null,"2","John","IE 9",null,null,null,null,"Francisco",24]
[null,"61-2",null,"2","John","IE 10",null,null,null,null,"Francisco",24]
[null,"61-3",null,"2","John","IE 11",null,null,null,null,"Francisco",24]
[null,"61-4",null,"2","John","Crome",null,null,null,null,"Francisco",24]
[null,"61-5",null,"99",null,"Reserved for Future Use"]
["Miscellaneous","64-0",null,"0",null,"Quote and Ack Forms",null,null,{"$f":"SUM(I370:I377)","v":32},{"$f":"SUM(J370:J377)","v":0},null,{"$f":"SUM(L370:L377)","v":120},{"$f":"SUM(M370:M377)","v":0},null,null,null,"No change to form layout.  Continue to use for NS quote/orders & sample orders."]
[null,"64-1",null,"0",null,"Link From Web to Avante for Faxed Ackn"]
[null,"64-2",null,"0",null,"Link From Avante to Web to re-send Order Ack"]
[null,"64-3",null,"0",null,"Add checkout Shipping Upcharges",null,null,null,null,null,null,null,null,null,null,"Determine if we should show details or no detail - below subtotal"]
[null,"64-4",null,"0",null,"Master Order Numbers On Optio Forms",null,null,null,null,null,null,null,null,null,null,"Place Master Order on Necessary forms"]
[null,"64-5","2013-10-08","5",null,"Possible layout change for bundling details"]
[null,"64-6",null,"0",null,"Windows Program to Create Output"]
[null,"64-7",null,"99",null,"Reserved for Future Use",null,null,null,null,null,null,null,null,null,null,"hours estimate"]
[null,"64-8",null,"99",null,"Reserved for Future Use",null,"John",32,null,"John",120]
["Miscellaneous","65-0",null,"1",null,"Web Discount",null,null,{"$f":"SUM(I379:I382)","v":10},{"$f":"SUM(J379:J382)","v":0},null,{"$f":"SUM(L379:L382)","v":2},{"$f":"SUM(M379:M382)","v":0},null,null,null,"Carry around the web discount from SYSCON and allow CE overide - always default CE to Zero"]
[null,"65-1",null,"1","John","UI - Place CheckBox on Summary Page for CE Only",null,null,null,null,"John",2,null,null,null,null,"Give CE the oportunity to set discount"]
[null,"65-2",null,"1","Judy","DB - Return the Current Web Discount % at Login",null,"Judy",4]
[null,"65-3",null,"1","Judy","DB - On Order Creation Set Correct Web Discount",null,"Judy",6,null,null,null,null,null,null,null,"On both convert quote and sales orders"]
[null,"65-4",null,"99",null,"Reserved for Future Use"]
["Miscellaneous","66-0",null,"0",null,"Order Creation - Credit Hold - for Master Orders",null,null,{"$f":"SUM(I384:I386)","v":4},{"$f":"SUM(J384:J386)","v":0},null,{"$f":"SUM(L384:L386)","v":0},{"$f":"SUM(M384:M386)","v":0},null,null,null,"Put entire master order on hold (all sub-orders) - Stock will not be allocated when put on hold"]
[null,"66-1",null,"0","Judy","Avante - Change Order Authorization",null,null,null,null,null,null,null,null,null,null,"Allow release for all items for master order or individual"]
[null,"66-2",null,"1","Judy","DB - Set Credit Hold Flag on All Sub Orders",null,"Judy",4,null,null,null,null,null,null,null,"Order changes on plance or remove the indviual order on hopld"]
[null,"66-3",null,"99",null,"Reserved for Future Use"]
["Miscellaneous","68-0",null,"0",null,"Shipping Instruction Upcharges",null,null,{"$f":"SUM(I388:I390)","v":24},{"$f":"SUM(J388:J390)","v":0},null,{"$f":"SUM(L388:L390)","v":0},{"$f":"SUM(M388:M390)","v":0},null,null,null,"Capturing and passing along the correct upcharges on an order."]
[null,"68-1",null,"2","Judy","DB - WEB.CALC.UPCHARGES to calculate all upcharges",null,"Janice",16,null,null,null,null,"Programming Specs - Checkout Shipping Instructions","2014-02-03",null,"Calculate all shipping instruction upcharges for every bundle.  Pass out to Cart Total pgm the total upcharge$$ for all bundles.  Pass out detailed upcharges to order creation.  Not called by UI."]
[null,"68-2",null,"0","Judy","PHASE II?? DB - Trigger Email to Purchasing for Export Pallet Request",null,"Judy",8,null,null,null,null,null,null,null,"put order on hold and send email to purchasig if special export plallets needed - 1/24 - WE SAID WAIT UNTIL PHASE II"]
[null,"68-3",null,"99",null,"Reserved for Future Use"]
["Miscellaneous","70-0",null,"0",null,"Invoice Form - Shipping Upcharges",null,null,{"$f":"SUM(I392:I395)","v":8},{"$f":"SUM(J392:J395)","v":0},null,{"$f":"SUM(L392:L395)","v":0},{"$f":"SUM(M392:M395)","v":0},null,null,null,"Folded into the upcharges above."]
[null,"70-1",null,0,"Judy","Avante - Invoice Form: add upcharges below subtotal",null,"Judy",8,null,null,null,null,null,null,null,"Inside delivery, tailgate, liftgate and export pallets"]
[null,"70-2",null,"99",null,"Reserved for Future Use"]
[null,"70-3",null,"99",null,"Reserved for Future Use"]
[null,"70-4",null,"99",null,"Reserved for Future Use"]
["Miscellaneous","72-0",null,"1",null,"Shipping Notifications",null,null,{"$f":"SUM(I397:I400)","v":16},{"$f":"SUM(J397:J400)","v":0},null,{"$f":"SUM(L397:L400)","v":0},{"$f":"SUM(M397:M400)","v":0},null,null,null,"Notifications for Customer Pickups & based on customer preference (call me when shipped)"]
[null,"72-1","2013-12-30","1","Judy","Avante - Program to Send Email for Shipment or Cancelation",null,"Judy",8,null,null,null,null,null,null,null,"Based on Customer Preference, Who Gets It - text on email has to match shipping method"]
[null,"72-2",null,"1","Judy","Avante - Call Program from nightly invoicing job",null,"Judy",4,null,null,null,null,null,null,null,"They don't want cancellation emails, so don't send notification until end of day (possibly when invoices are sent?) ce-set preference but everyone gets it??? Except EDI/XML who get EDI shipping notifications (based on CUSTMST flag). Send notification for MOD too."]
[null,"72-3",null,"1","Judy","*** no longer needed - Avante - Call program from Cancel Shiipment ",null,"Judy",4,null,null,null,null,null,null,null,"Don't have to do this if we aren't sending notification until invoicing."]
[null,"72-4",null,"99",null,"Reserved for Future Use"]
["Miscellaneous","75-0",null,"0",null,"CE Discrepancies Drawer",null,null,{"$f":"SUM(I402:I409)","v":50},{"$f":"SUM(J402:J409)","v":0},null,{"$f":"SUM(L402:L409)","v":49},{"$f":"SUM(M402:M409)","v":0},null,null,null,"flagging in cart, different order acknowledgement, put order(s) on hold, auto-release for onhold orders"]
[null,"75-1",null,"0","John","UI - Create Drawer",null,null,null,null,"John",14]
[null,"75-2",null,"0","John","UI - Store Responses",null,null,null,null,"John",3]
[null,"75-3",null,"0","John","UI - Customer Link on the Web to Release",null,null,null,null,"John",32]
[null,"75-4",null,"0","Judy","DB - Program to Close Requests and Update Based on Customer Response",null,"Judy",16,null,null,null,null,null,null,null,"Customer or CE can release - write all information to CE Request - auto trail of who closed it"]
[null,"75-5",null,"0","Judy","DB - Place Order on Hold and Send Ack or Email",null,"Judy",8,null,null,null,null,null,null,null,"Set new request type - one per individual order - this may be included in spinning off CE equests  1/23/14-only put order(s) on hold where there is price discrepancy-don't put MOD order on hold if stock discrepancy and vice versa."]
[null,"75-6",null,"0","Judy","DB - Release Program Based on User Preference",null,"Judy",24,null,null,null,null,null,null,null,"How Long to hold the order and perform appropriate actions - release, take off hold, cancel - send email when we cancel an order for a price discrepancy"]
[null,"75-7",null,"1","Judy","DB - Write No Overrun to Quote in RPC$SHOPPINGCARTITEM_SAVE",null,"Judy",2,null,null,null,null,null,null,null,"When the 'No Overrun' flag is changed in the c/e drawer, write the 1/0 to QUHDR.USR<5> immediately.  This is needed for bundling screen to calculate the MOD Item Weight to determine the LTL.FLAG"]
[null,"75-8",null,"99",null,"Reserved for Future Use"]
["Miscellaneous","76-0",null,"0",null,"Preference-related logic for defaults",null,null,{"$f":"SUM(I411:I413)","v":0},{"$f":"SUM(J411:J413)","v":0},null,{"$f":"SUM(L411:L413)","v":0},{"$f":"SUM(M411:M413)","v":0},null,null,null,"ie, cradlepacked, no verbal p/o, no verbal order, - any comment used today that result in a different default or validation -"]
[null,"76-1",null,"99",null,"Reserved for Future Use"]
[null,"76-2",null,"99",null,"Reserved for Future Use"]
[null,"76-3",null,"99",null,"Reserved for Future Use"]
["Miscellaneous","77-0",null,"0",null,"Lock Logic - Carts, Quote Changes, etc - ",null,null,{"$f":"SUM(I415:I418)","v":0},{"$f":"SUM(J415:J418)","v":0},null,{"$f":"SUM(L415:L418)","v":0},{"$f":"SUM(M415:M418)","v":0},null,null,null,"Locking items for changes to prevent other users from modifyin at the same time."]
[null,"77-1",null,1,null,"Locking Records - Carts, Quote Changes, etc"]
[null,"77-2",null,"99",null,"Reserved for Future Use"]
[null,"77-3",null,"99",null,"Reserved for Future Use"]
[null,"77-4",null,"99",null,"Reserved for Future Use",null,null,null,null,null,null,null,null,null,null,"how will we stop multiple people from working on same cart/quote?"]
["DataConversions","78-0",null,"0",null,"Conversion Programs",null,null,{"$f":"SUM(I420:I428)","v":77},{"$f":"SUM(J420:J428)","v":4},null,{"$f":"SUM(L420:L428)","v":0},{"$f":"SUM(M420:M428)","v":0},null,null,null,"How will we migrate our data from the current setup to the future information structure of the new site."]
[null,"78-1",null,0,null,"Customer comments that will become preferences"]
[null,"78-2",null,"1","Judy","Load master order# data for existing orders (after purging old data)",null,"Judy",4,null,null,null,null,null,null,null,"create the master order file, do we want to include bundling - not changing order number and we are not saving bundling"]
[null,"78-3",null,"1","Judy","Creating MOD items from Ashads",null,"Judy",40,null,null,null,null,null,null,null,"Create MODITMMST.USR all item data and QUOTE numbers as well as CUSTPART.USR CUSTPARTXRF.USR at the bill-to level, changing key to custpart - start with bp WEB.CON VERT.CONFIG - update quote and sales order with MOD item - use work file by customer for matching mod items"]
[null,"78-4",null,"1","Judy","Merge/Purge Duplicate Ship-to Customers",null,"Judy",24,null,null,null,null,null,null,null,"We have a number of duplicate ship-to customers - need to remove duplicates in Avante"]
[null,"78-5","2013-12-30","2","Judy","Update ITMMST w/newest material data from Cliff's Spreadsheet",null,"Wayne",4,4,null,null,null,null,null,null,"Cliff has added materials to misc items - update spreadsheet & SYSTBL with new material options (ie, Steel)"]
[null,"78-6","2013-12-30","1","Judy","Clean-up Ship Via for Ship-to and Drop Ship Customers",null,"Judy",1,null,null,null,null,null,null,null,"Set all to BW - DO NOT TOUCH BILL TO RECORDS"]
[null,"78-7",null,"1","Judy","Reformat Marketplace Descriptions in SODET",null,"Judy",4,null,null,null,null,null,null,null,"Judy changed the desriptions"]
[null,"78-8","2014-01-23","0",null,"Do we need conversion pgm for existing carts when we go LIVE"]
[null,"78-9",null,"99",null,"Reserved for Future Use"]
["Miscellaneous","79-0",null,"0",null,"Performance Optimization / Server Response Issues",null,null,{"$f":"SUM(I430:I434)","v":0},{"$f":"SUM(J430:J434)","v":0},null,{"$f":"SUM(L430:L434)","v":0},{"$f":"SUM(M430:M434)","v":0},null,null,null,"Streamlining the functions supporting the site so that it seems as fast as possible without sacrificing integrity."]
[null,"79-1",null,"5",null,"ShopWidget"]
[null,"79-2",null,"5",null,"Server Response Time"]
[null,"79-3",null,"99",null,"Reserved for Future Use"]
[null,"79-4",null,"99",null,"Reserved for Future Use"]
[null,"79-5",null,"99",null,"Reserved for Future Use"]
["Miscellaneous","80-0",null,"0",null,"Picking Slip",null,null,{"$f":"SUM(I436:I439)","v":12},{"$f":"SUM(J436:J439)","v":4},null,{"$f":"SUM(L436:L439)","v":0},{"$f":"SUM(M436:M439)","v":0},null,null,null,"Modify 'date heading' on warehouse picking slip (Arrive On, Ship On, Ship On or Before)"]
[null,"80-1","2013-12-20","1","Judy","Date Box Heading to Ship On, Arrive On, or Ship On or Before",null,null,8]
[null,"80-2",null,"1","Cathy","Change for CustpartXREF.USR",null,"Cathy",4,4,null,null,null,null,null,null,"change logic for new customer item xref file"]
[null,"80-3",null,"99",null,"Reserved for Future Use"]
[null,"80-4",null,"99",null,"Reserved for Future Use"]
["ShopWidget","81-0","2013-12-30","1",null,"Stock Selections for Centerfold Sheeting & LLD",null,null,{"$f":"SUM(I441:I444)","v":3},{"$f":"SUM(J441:J444)","v":0},null,{"$f":"SUM(L441:L444)","v":0},0,null,null,null,"Folded width is entered, RPC needs to take width x 2 for selection"]
[null,"81-1",null,"1","John","Update RPC$WEBPRODUCTITEM_GETBYFILTER For Cfold",null,"John",3,null,null,null,null,null,null,null,"RPC$WEBPRODUCTITEM_GETBYFILTER must double the entered width for folded product categories."]
[null,"81-2","2014-01-13","3","Judy","Update RPC$WEBPRODUCTITEM_GETBYFILTER For LLD",null,"Wayne",null,0,null,null,null,"Programming Spec-Web Search Results","2014-01-13",null,"Add a stock selection for Std Hexene Blend or Octene when Material = LLD"]
[null,"81-3",null,"99",null,"Reserved for Future Use"]
[null,"81-4",null,"99",null,"Reserved for Future Use"]
["ShopWidget","82-0","2014-01-03","0",null,"New Shop Widget Product Categories",null,null,{"$f":"SUM(I446:I449)","v":8},{"$f":"SUM(J446:J449)","v":0},null,{"$f":"SUM(L446:L449)","v":0},{"$f":"SUM(M446:M449)","v":0},null,null,null,"Add Black Conductive Bags under Poly Bags and Blk Cond Tubing under Tubing & Sleeves"]
[null,"82-1","2014-01-03","3","Judy","Add Black Conductive Tubing and Bag Categories",null,"Judy",null,null,null,null,null,null,null,null,"Add to SYS9026 and disable level 2 and level 3 entry.  Check stock select after Cliff adds catalog codes to ITMMST"]
[null,"82-2","2014-01-06","1","Judy","Add Amber Zip Tops to Shop Widget Category",null,"Judy",4,null,null,null,null,null,null,null,"Awaiting info from Cliff on stock Amber Ziptops"]
[null,"82-3","2014-01-30","0","Judy","Add Tamper-Evident Ziptops Category (awaiting info from Owen)",null,"Judy",4,null,null,null,null,null,null,null,"Awaiting info from marketing on specifics of tamper-evident ziptops"]
[null,"82-4",null,"99",null,"Reserved for Future Use"]
["ShopWidget","83-0","2014-01-10","0",null,"Check for MOD Item match before showing MOD Result",null,null,{"$f":"SUM(I451:I453)","v":4},{"$f":"SUM(J451:J453)","v":0},null,{"$f":"SUM(L451:L453)","v":0},0,null,null,null,"When returning a MOD Result, check to see if there is an exact match for this item in the billto's MOD.ITMMST.USR file.  If so, display result with the MOD Item# so that it can't be duplicated.  What do we use for packout? Default or packout of first exact match we find?  What if packout is changed in results ... look to see if that's a different MOD Item?"]
[null,"83-1",null,"1","Judy","DB - Program to Retrieve MOD Exact Match",null,"Judy",4]
[null,"83-2",null,"99",null,"Reserved for Future Use"]
[null,"83-3",null,"99",null,"Reserved for Future Use"]
["Miscellaneous","84-0","2014-01-20","0",null,"Send Customer Back to Site Based on Email Link",null,null,{"$f":"SUM(I455:I457)","v":0},{"$f":"SUM(J455:J457)","v":0},null,{"$f":"SUM(L455:L457)","v":0},{"$f":"SUM(M455:M457)","v":0},null,null,null,"This is used to direct the customer to a specific page (??) based on a link in an email"]
[null,"84-1",null,"5","John","UI - Direct Customer to Page to Accept the Order",null,null,null,null,"John"]
[null,"84-2",null,"99",null,"Reserved for Future Use"]
[null,"84-3",null,"99",null,"Reserved for Future Use"]
["Active Cart","85-0",null,"1",null,"Adding MOD Items to Active Cart",null,null,{"$f":"SUM(I459:I461)","v":0},{"$f":"SUM(J459:J461)","v":0},null,{"$f":"SUM(L459:L461)","v":0},{"$f":"SUM(M459:M461)","v":0}]
[null,"85-1",null,"1","John","UI - Don't allow add to cart if quote is already in another cart",null,null,null,null,"John",null,null,null,null,null,"Prevent user from pulling a MOD saved item through the widget and adding into a cart if the quote is already in a cart (any cart)."]
[null,"85-2",null,"99",null,"Reserved for Future Use"]
[null,"85-3",null,"99",null,"Reserved for Future Use"]
["Saved Items","86-0",null,"2",null,"Rework Saved Items Tab",null,null,{"$f":"SUM(I463:I465)","v":0},{"$f":"SUM(J463:J465)","v":0},null,{"$f":"SUM(L463:L465)","v":24},{"$f":"SUM(M463:M465)","v":0}]
[null,"86-1",null,"2","John","UI - Rework to get Saved Items Tab Fully Functional",null,null,null,null,"Sal",24]
[null,"86-2",null,"99",null,"Reserved for Future Use"]
[null,"86-3",null,"99",null,"Reserved for Future Use"]
["ShopWidget","87-0",null,"0",null,"Random Repeat - Plate Sorting/Selection",null,null,{"$f":"SUM(I467:I469)","v":0},{"$f":"SUM(J467:J469)","v":0},null,{"$f":"SUM(L467:L469)","v":0},{"$f":"SUM(M467:M469)","v":0}]
[null,"87-1","2014-02-03","0",null,"Sort custom plates alphabetically/'New\" option moved",null,"Judy",null,null,null,null,null,null,null,null,"See Steve's new design - sort custom plates alphabetically.  'New' plate is no longer in the list … what changes are needed?"]
[null,"87-2",null,"99",null,"Reserved for Future Use"]
[null,"87-3",null,"99",null,"Reserved for Future Use"]
["QA Reporting","800-0",null,null,null,"Assigned Bug Fixes",null,null,{"$f":"SUM(I471:I478)","v":0},{"$f":"SUM(J471:J478)","v":0},null,{"$f":"SUM(L471:L478)","v":0},{"$f":"SUM(M471:M478)","v":0}]
[null,"800-1","2014-01-08","80",null,"Ed - Fixing Bugs",null,null,null,null,"Ed",null,null,"QA Reporting and Tracking","2014-01-08"]
[null,"800-2","2014-01-08","80",null,"Francisco - Fixing Bugs",null,null,null,null,"Francisco",null,null,"QA Reporting and Tracking","2014-01-08"]
[null,"800-3","2014-01-08","80",null,"Janice - Fixing Bug",null,"Janice",null,null,null,null,null,"QA Reporting and Tracking","2014-01-08"]
[null,"800-4","2014-01-08","80",null,"Joe - Fixing Bug",null,"Joe",null,null,null,null,null,"QA Reporting and Tracking","2014-01-08"]
[null,"800-5","2014-01-08","80",null,"Sal - Fixing Bug",null,null,null,null,"Sal",null,null,"QA Reporting and Tracking","2014-01-08"]
[null,"800-6","2014-01-08","80",null,"Wayne - Fixing Bug",null,"Wayne",null,0,null,null,null,"QA Reporting and Tracking","2014-01-08"]
[null,"800-7",null,"99",null,"Reserved for Future Use"]
[null,"800-8",null,"99",null,"Reserved for Future Use"]
["Investigate","1999-0",null,"0",null,"Items Requiring Further Investigation"]
[null,"1999-1",null,5,null,"Customer Item Number Pricing",null,null,null,null,null,null,null,null,null,null,"Can we save individual prices for certain parts number for a given customer (ideally would be able point to an Override price list for certain items)"]
[null,"1999-2",null,5,null,"Inventory Allocations",null,null,null,null,null,null,null,null,null,null,"Ramifications of allocating inventory when an order goes on credit hold (decided we didn't need to do this ….)"]
[null,"1999-3",null,5,null,"Order Number Size Change (8 or 9) 7+Suffix",null,null,null,null,null,null,null,null,null,null,"What needs to change on Avante when order# goes to 8 char (7+suffix) and w/o goes to 9 char"]
[null,"1999-4",null,5,null,"Automating CIA and COD in Ccard processing",null,null,null,null,null,null,null,null,null,null,"Automating CIA and COD as part of credit card process (per Dawn - if we happen to be in that area …)"]
[null,"1999-5",null,5,null,"UI work (smooth out screen jumping)"]
[null,"1999-6",null,"5",null,"Product Description Standardization",null,null,null,null,null,null,null,null,null,null,"What should be displayed / printed on Web and Labels"]
[null,"1999-7",null,"5",null,"Work Order Numbers",null,null,null,null,null,null,null,null,null,null,"Dawn was concerned that if multiple mod items on same order work order numbers would be for example 5000000A 5000000B etc"]
[null,"1999-8","2013-12-19","5",null,"Releasing B/O Pickslips only when inventory is available",null,null,null,null,null,null,null,null,null,null,"Look into a pre-process that sets a release flag on the backordered order. Create Pickslips would check for release flag as part of SODEL select."]
[null,"1999-9","2013-12-30","5","Judy","Revert AVBP EPCS0018.1 back to std version if possible",null,null,null,null,null,null,null,null,null,null,"AVBP missing logic from tasks 100955, 101093, and 101022. Have to set USERDATA variable for this to work with standard program.  If we can't revert, must add missing logic."]
[null,"1999-10",null,"99",null,"Reserved for Future Use"]
[null,"1999-11",null,"99",null,"Reserved for Future Use"]
["Phase II","2000-0",null,"0",null,"Contract Pricing Structure"]
[null,"2000-1",null,"0",null,"Program RPC"]
[null,"2000-2",null,"0",null,"Set up contract pricing input and access in Avante",null,null,null,null,null,null,null,null,null,null,"For Stock and Mod Items (ONLY INTENDED FOR MOD ITEMS - CURRENTLY STAPLES AND ULINE)"]
[null,"2000-3",null,"0",null,"NS Items on the Web"]
[null,"2000-4",null,"0",null,"Samples on the Web"]
[null,"2000-5",null,"99",null,"Reserved for Future Use"]
[null,"2000-6",null,"99",null,"Reserved for Future Use"]
[null,"2000-7",null,"99",null,"Reserved for Future Use"]
[null,"2000-8",null,"0",null,"One Plate for Multiple Quotes"]

{"sheet":"temp","index":15,"n_rows":3,"n_cols":19,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Sal","Task Nbr","Status","Designer","Programming Task Description","Pty","Hours","Rem","Wiki Programing Document Spec Name","Dt Assigned","St Date","F12","T","F","M","T1","W","Week Totals","Prior Totals"]
["UI Pgmr",null,9,null,"Unassigned Work",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,9,null,"DO NOT DELETE, TEMPLATE ROW FOR FORMULAS",null,null,0,null,null,null,null,null,null,null,null,null,0]