Release | Date | Case Number | Description of Change | Affected BQY File | Affected SQL Server Version? | Affected Oracle Version? | |||
6/6/2006 | 7923 | Problem with computed date back_dt. Put into results seciont | Back order by vendor and buyer.bqy | Y | Y | ||||
6/13/2006 | 7972 | Corrected performance problem - reduced to 1 query; corrected selection date criteria - append " 23:59:59" to end date | Price Overrides.bqy | Y | Y | ||||
7/6/2006 | 8010 | Sales by Product ID - SQL Server version - missing "Export this Pivot" options | Sales by Product ID.bqy | Y | N | ||||
7/13/06 - 7/24/06 | NA | Add Taurus copyright & revision information | All SQL Server Queries | Y | N | ||||
7/17/2006 | 8142 | Moved Days In Warehouse calculation from the request line to a computed field in the result set | Orders in the Warehouse.bqy | Y | Y | ||||
7/24/06 - 8/04/06 | NA | Add Taurus copyright & revision information | All Oracle Queries | N | Y | ||||
8/18/2006 | 7350 | Add new query - Aged Open AR.bqy | Aged Open AR.bqy | Y | Y | ||||
9/1/2006 | 7393 | Redesign Aged Orders in the Warehouse.bqy - add details & tracking number; remove database-specific code | Aged Orders in the Warehouse.bqy | Y | Y | ||||
9/1/2006 | Add "Aged Open AR.bqy" query to Menu Dashboard | Ecomedate Menu Dashboard.bqy | Y | Y | |||||
9/28/2006 | 8706 | Change toolbar initilization logic | Avg orders items and dollars by source.bqy | Y | Y | ||||
9/28/2006 | 8704, 8706 | Change toolbar initilization logic; change drop-down initialization | Obsolete Inventory.bqy | Y | Y | ||||
9/28/2006 | 8704 | Change drop-down initialization | Price Overrides.bqy | Y | Y | ||||
9/28/2006 | 8706 | Change toolbar initilization logic | Sales revenue per catalog mailed.bqy | Y | Y | ||||
9/28/2006 | 8706 | Change toolbar initilization logic | Sales revenue per page.bqy | Y | Y | ||||
9/28/2006 | 8704 | Change drop-down initialization | Receiving Staffing Requirements.bqy | Y | Y | ||||
9/28/2006 | 8704 | Change drop-down initialization | Shipping charge analysis.bqy | Y | Y | ||||
9/28/2006 | 8704 | Change drop-down initialization | Vendor expenditures by year and category.b | Y | Y | ||||
9/28/2006 | 8704 | Change drop-down initialization | Vendor performance analysis.bqy | Y | Y | ||||
9/28/2006 | 8704 | Change drop-down initialization | Vendor returns analysis.bqy | Y | Y | ||||
9/28/2006 | 8704 | Change drop-down initialization | Inventory Adjustments.bqy | Y | Y | ||||
9/28/2006 | 8704 | Change drop-down initialization | Inventory Receiving Analysis.bqy | Y | Y | ||||
9/28/2006 | 8704 | Change drop-down initialization | P and H Overrides.bqy | Y | Y | ||||
9/28/2006 | 8704 | Change drop-down initialization | Pick Velocity.bqy | Y | Y | ||||
9/28/2006 | 8704 | Change drop-down initialization | Returns Analysis.bqy | Y | Y | ||||
9/28/2006 | 8704 | Change drop-down initialization | Sales by Product ID.bqy | Y | Y | ||||
9/28/2006 | 8704, 8706 | Change toolbar initilization logic; change drop-down initialization | Sales versus Returns Analysis.bqy | Y | Y | ||||
9/28/2006 | 8704, 8706 | Change toolbar initilization logic; change drop-down initialization | Top X Customers.bqy | Y | Y | ||||
9/28/2006 | 8704, 8706 | Change toolbar initilization logic; change drop-down initialization | Repeat Buyer Analysis.bqy | Y | Y | ||||
9/28/2006 | 8704, 8706 | Change toolbar initilization logic; change drop-down initialization | RFM Analysis.bqy | Y | Y | ||||
9/28/2006 | 8704, 8706 | Change toolbar initilization logic; change drop-down initialization | Forecast to Buy.bqy | Y | Y | ||||
9/28/2006 | 8706 | Change toolbar initilization logic | Aged Open AR.bqy | Y | Y | ||||
10/9/2006 | 7195 | Add Merchandise Performance Analysis query | Merchandise Performance Analysis.bqy | Y | Y | ||||
10/9/2006 | 7196 | Add Price Range Analysis query | Price Range Analysis.bqy | Y | Y | ||||
10/9/2006 | 7197 | Add Spread Performance Analysis.bqy | Spread Performance Analysis.bqy | Y | Y | ||||
10/16/2006 | 8833 | Add customer details to drill-down data | Merchandise Performance Analysis.bqy | Y | Y | ||||
10/16/2006 | 8833 | Add customer details to drill-down data | Spread Performance Analysis.bqy | Y | Y | ||||
10/26/2006 | 8140 | Add dashboards, selection criteria, and pivot tables to Back-Orders | Back Orders.bqy | Y | Y | ||||
10/26/2006 | 8643 | Add wildcard to selection criteria | Forecast to Buy.bqy | Y | Y | ||||
11/3/2006 | 7881 | Add new query - Inventory Value | Inventory Value.bqy | Y | Y | ||||
11/7/2006 | 8642 | Add wildcard to selection criteria | Sales versus Returns Analysis.bqy | Y | Y | ||||
11/7/2006 | 8641 | Add wildcard to selection criteria | Sales by Product ID.bqy | Y | Y | ||||
11/9/2006 | 8418 | Add ability to select by fiscal period | Sales by Product ID.bqy | Y | Y | ||||
11/15/2006 | 9091 | Correct scripting to change REF_PERIOD_TABLE link, depending on Demand or Shipment selection | Sales by Product ID.bqy | Y | Y | ||||
12/30/2006 | Change name of Item Analysis to Item Listing | Item Analysis.bqy | Y | Y | |||||
12/30/2006 | 9961 | Added order item status legacy code and hold til complete legacy code | Back Orders.bqy | Y | Y | ||||
12/30/2006 | 7882 | Create Open RAs query | Open RAs.bqy | Y | Y | ||||
12/30/2006 | 7944 | Create Pending Refunds query | Pending Refunds.bqy | Y | Y | ||||
12/30/2006 | 9325 | Changed Startup script to initialize selection screen list boxes | Price Range Analysis.bqy | Y | Y | ||||
12/30/2006 | 9326 | Changed Startup script to initialize selection screen list boxes | Spread Performance Analysis.bqy | Y | Y | ||||
12/30/2006 | 9327 | Changed Startup script to initialize selection screen list boxes | Merchandise Performance Analysis.bqy | Y | Y | ||||
12/30/2006 | 8649 | New query to report Closed AR transactions | Closed AR History.bqy | Y | Y | ||||
12/30/2006 | 8624 | New query to report Offer / Use PNL | Offer PNL.bqy | Y | Y | ||||
12/30/2006 | Changed Startup script to initialize selection screen list boxes | Sales by Product ID.bqy | Y | Y | |||||
12/30/2006 | Changed Product Number to Item Number | Inventory Value.bqy | Y | Y | |||||
12/30/2006 | 9325 | Changed Startup script to initialize selection screen list boxes | Returns Analysis.bqy | Y | Y | ||||
12/30/2006 | 9325 | Changed Startup script to initialize selection screen list boxes | Sales by Product ID.bqy | Y | Y | ||||
12/30/2006 | 9325 | Changed Startup script to initialize selection screen list boxes | Vendor expenditures by year and category.b | Y | Y | ||||
12/30/2006 | 9325 | Changed Startup script to initialize selection screen list boxes | Vendor performance analysis.bqy | Y | Y | ||||
12/30/2006 | 9325 | Changed Startup script to initialize selection screen list boxes | Vendor returns analysis.bqy | Y | Y | ||||
Jan 07 | 1/31/2007 | Changed date field names to Debit Trans Dt and Credit Trans Dt | Closed AR History.bqy | Y | Y | ||||
Jan 07 | 1/31/2007 | Activated pivot table on dashboard | Open RAs.bqy | Y | Y | ||||
Jan 07 | 1/31/2007 | 7943 | Initial Query | GL Trans.bqy | Y | Y | |||
Jan 07 | 1/31/2007 | 9540 | Updated link for Item Listing.bqy | Ecomedate Menu Dashboard.bqy | Y | Y | |||
Jan 07 | 1/31/2007 | 9541 | Changed company / division select criteria process | Item Listing.bqy | Y | Y | |||
Jan 07 | 1/31/2007 | 8691 | Initial Query | UnShipped Orders by Status.bqy | Y | Y | |||
Jan 07 | 1/31/2007 | Change PNL labels to P&L | Offer PNL.bqy | Y | Y | ||||
Feb 07 | 2/28/2007 | 8646 | Add Customer Number to select criteria | Aged Open AR.bqy | Y | Y | |||
Feb 07 | 2/28/2007 | Added dashboard, report, reference tables | Items changed to discontinued.bqy | Y | Y | ||||
Feb 07 | 2/28/2007 | 10616 | Modified Days to Expire calculation | Open RAs.bqy | Y | Y | |||
Feb 07 | 2/28/2007 | 9791 | modified startup script IncludeProcessAll() feature | Repeat Buyer Analysis.bqy | Y | Y | |||
Feb 07 | 2/28/2007 | 9812 | Added RTN_DT join, modified query script to remove RTN_DT limits on click | Returns Analysis.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 10124 | Activated pivot table on dashboard | Aged Open AR.bqy | Y | N | |||
Mar 07 | 3/31/2007 | 9929, 9958 | Added company / division select criteria to the dashboard, added reference tables | Aged Orders in the Warehouse.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 8616, 8703 | Initial Query | All Orders by Status.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 10136 | Adjusted drop down box size to allow Division title box to show, fixed pivot to allow drill down | Avg orders items and dollars by source.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 9975 | Modifed query script - process query button was not working | Closed AR History.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 10123 | modifed the table properties - dropped dbo. from table name | GL Trans.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 10138, 9965 | Fixed pivot on dashboard to allow for drill down in iviewer environment, added reference tables | Merchandise Performance Analysis.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 9850 | Modified dashboard to allow variable fields to be set on web version | Offer PNL.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 10126 | Activated chart on dashboard, added reference tables | Open Orders by Item.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 10074 | Added company / division select criteria to the dashboard | Open purchase orders.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 10139 | Fixed pivot on dashboard to allow for drill down in iviewer environment | Open purchase orders.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 10140 | Fixed pivot on dashboard to allow for drill down in iviewer environment | Open RAs.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 9930 | Added company / division select criteria to the dashboard | Orders in the Warehouse.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 10127 | Activated chart on dashboard | Orders in the Warehouse.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 10129 | Activated chart on dashboard | P and H Overrides.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 10141 | Fixed pivot on dashboard to allow for drill down in iviewer environment, added reference tables | Pick Velocity.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 9926 | Added company / division select criteria to the dashboard, added reference tables | Price Overrides.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 10130 | Activated chart on dashboard, added reference tables | Price Range Analysis.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 10142 | Fixed pivot on dashboard to allow for drill down in iviewer environment | Receiving Staffing Requirements.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 10143 | Fixed pivot on dashboard to allow for drill down in iviewer environment | Repeat Buyer Analysis.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 10040, 9969 | Added company / division select criteria to the dashboard, fix script to populate reason codes, added reference tables | Returns Analysis.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 9876, 9958 | Activated pivot table on dashboard | Aged Orders in the Warehouse.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 9928 | Modified query to improve run speed, Added co / div to select dashboard | Shipping charge analysis.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 10133 | Activated chart on dashboard | Shipping charge analysis.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 10144 | Fixed pivot on dashboard to allow for drill down in iviewer environment, added reference tables | Spread Performance Analysis.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 10027 | Modified startup script to allow navigation bar in web environment | UnShipped Orders by Status.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 9941 | Added company / division select criteria to the dashboard, added reference tables | Vendor expenditures by year and category.b | Y | Y | |||
Mar 07 | 3/31/2007 | 9942 | Added company / division select criteria to the dashboard | Vendor performance analysis.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 9943 | Added company / division select criteria to the dashboard, added reference tables | Vendor returns analysis.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 9974 | Add reference data to pivot tables | Vendor returns analysis.bqy | Y | Y | |||
Mar 07 | 3/31/2007 | 7194 | Initial Query | Item Demand Analysis | Y | Y | |||
Apr 07 | 4/30/2007 | 8687, 8688, 8689 | Initial Query | Current Snapshot Analysis.bqy | Y | Y | |||
Apr 07 | 4/30/2007 | 10421 | Added company / division to select criteria dashboard | Forecast to Buy.bqy | Y | Y | |||
Apr 07 | 4/30/2007 | 10521, 10661 | Corrected Available Inv and Units on Hand calculations in result set | Forecast to Buy.bqy | Y | Y | |||
Apr 07 | 4/30/2007 | 10415 | Corrected Co / Div limit on company query | Inventory Value.bqy | Y | Y | |||
Apr 07 | 4/30/2007 | 10426 | redesign query to summarize data to improve speed | Offer PNL.bqy | Y | Y | |||
Apr 07 | 4/30/2007 | 10350 | redesign query to improve speed, added order header / customer data for drill down | P and H Overrides.bqy | Y | Y | |||
Apr 07 | 4/30/2007 | 10567 | Redesign to improve speed | Repeat Buyer Analysis.bqy | Y | Y | |||
Apr 07 | 4/30/2007 | 10227 | modified to exclude continuity orders when running for demand orders | Sales by Product Id.bqy | Y | Y | |||
Apr 07 | 4/30/2007 | 10624 | Initial Query | This Year to Last Year Snapshot Analysis.bq | Y | Y | |||
Apr 07 | 4/30/2007 | Update Ecomedate Main Menu for new queries | Ecomedate Menu Dashboard.bqy | Y | Y | ||||
Apr 07 | 4/30/2007 | 10594, 8703 | revised Order Counts Chart to"Count Distinct: order numbers rather than "Count" | UnShipped Orders by Status.bqy | Y | Y | |||
Apr 07 | 4/30/2007 | 10587 | correct data function on charts - created new counting fields based on appropriate piece of order number | UnShipped Orders by Status.bqy | Y | Y | |||
Apr 07 | 4/30/2007 | 9869 | Initial Query | Item Summary Sales.bqy | Y | Y | |||
Apr 07 | 4/30/2007 | 10020 | Fixed start up script to populate vendor list box | Inventory Receiving Analysis.bqy | Y | Y | |||
Apr 07 | 4/30/2007 | 10021 | Fixed start up script to populate offer list box | Offer PNL.bqy | Y | Y | |||
May 07 | 5/31/2007 | 9957 | Added customer reference tables | Aged Open AR.bqy | Y | Y | |||
May 07 | 5/31/2007 | 9931 | Added company / division to select criteria dashboard | Back orders by vendor and buyer.bqy | Y | Y | |||
May 07 | 5/31/2007 | 9944 | Added company / division to select criteria dashboard | Expected Weekly PO Receipts.bqy | Y | Y | |||
May 07 | 5/31/2007 | 9932 | Added company / division to select criteria dashboard | Future orders.bqy | Y | Y | |||
May 07 | 5/31/2007 | 9962 | Added Ref_Itm_Sta_Lgcy_Cd table to query | Future orders.bqy | Y | Y | |||
May 07 | 5/31/2007 | 9946 | Added company / division to select criteria dashboard | Inventory Adjustments.bqy | Y | Y | |||
May 07 | 5/31/2007 | 9937 | Added company / division to select criteria dashboard, added reference tables | Inventory Receiving Analysis.bqy | Y | Y | |||
May 07 | 5/31/2007 | 9963 | Added category, item status reference tables | Inventory Value.bqy | Y | Y | |||
May 07 | 5/31/2007 | 9964 | Added category, item status reference tables | Item Analysis.bqy | Y | Y | |||
May 07 | 5/31/2007 | 6820 | Initial Query | LTV Analysis.bqy | Y | Y | |||
May 07 | 5/31/2007 | 10351 | Initial Query | Net Product Sales Analysis.bqy | Y | Y | |||
May 07 | 5/31/2007 | 9933 | Added company / division to select criteria dashboard, added reference tables | Open orders by item.bqy | Y | Y | |||
May 07 | 5/31/2007 | 9934 | Added company / division to select criteria dashboard | Open RAs.bqy | Y | Y | |||
May 07 | 5/31/2007 | 9935 | Added company / division to select criteria dashboard | Orders at the drop shipper.bqy | Y | Y | |||
May 07 | 5/31/2007 | 9966 | Added Ref_Itm_Sta_Lgcy_Cd & Ref_FOP_Type_Lgcy_Cd tables to the query | Orders at the drop shipper.bqy | Y | Y | |||
May 07 | 5/31/2007 | 9938 | Added company / division to select criteria dashboard | P and H Overrides.bqy | Y | Y | |||
May 07 | 5/31/2007 | 9968 | Added reference tables to query | P and H Overrides.bqy | Y | Y | |||
May 07 | 5/31/2007 | 9949 | Added company / division to select criteria dashboard | Pick Velocity.bqy | Y | Y | |||
May 07 | 5/31/2007 | 9939 | Added company / division to select criteria dashboard | Receiving Staffing Requirements.bqy | Y | Y | |||
May 07 | 5/31/2007 | 10522 | Revised pivots to pull in demand / shipped order counts based on select criteria | Sales by Product ID.bqy | Y | Y | |||
May 07 | 5/31/2007 | 9971 | Added reference tables to query | Sales versus Returns Analysis.bqy | Y | Y | |||
May 07 | 5/31/2007 | 9973 | Added reference tables to query | Top X Customers.bqy | Y | Y | |||
May 07 | 5/31/2007 | 10791 | changed joins on customr comp table | Top X Customers.bqy | Y | Y | |||
May 07 | 5/31/2007 | 9936 | Added company / division to select criteria dashboard | UnShipped Orders by Status.bqy | Y | Y | |||
May 07 | 5/31/2007 | 10891 | set co / div limits to "=" rather than "<>" | Closed AR History.bqy | Y | Y | |||
Jun 07 | 6/18/2007 | 10921 | limit results to primary vendor (vendor preference cd = 01) | Inventory Value.bqy | Y | Y | |||
Jun 07 | 6/22/2007 | 10792 | replaced reference table, add limit for Tel_Nr_Role_Lgcy_Cd and removed from result set, add limit for action_srch_lgcy_cd, revised counter for order level counts | All Orders by Status.bqy | Y | Y | |||
Jun 07 | 6/25/2007 | 11016 | Removed extra pivot, changed Inv Trans Qty to Units Received to be consistent in naming across pivot tables | Vendor expenditures by year and category.b | Y | Y | |||
Jun 07 | 6/26/2007 | 11018 | replace ref_ship_meth_lgcy_cd with sv_macman_ship_methods | Aged Orders in the Warehouse.bqy | Y | Y | |||
Jun 07 | 6/26/2007 | 11010 | removed dbo. From comp_div_master table in both versions, corrected customer formula in oracle version | Back Orders.bqy | Y | Y | |||
Jun 07 | 6/27/2007 | 11029 | change physical table name in Fiscal Dates Query - removed "dbo." | Item Summary Sales.bqy | Y | Y | |||
Jun 07 | 6/27/2007 | 11021 | applied a limit to telephone number type to BUS1 and include nulls to eliminate duplicates | Net Product Sales Analysis.bqy | Y | Y | |||
Jun 07 | 6/28/2007 | 11051 | added gross margin and gross margin % to pivot tables | Open RAs.bqy | Y | Y | |||
Jun 07 | 6/30/2007 | 11122 | Removed limit for itm_cd | Inventory Receiving Analysis.bqy | Y | Y | |||
Jun 07 | 6/30/2007 | Added LTV Analysis.bqy, Net Product Sales.bqy, Items Distincontinued.bqy | Ecomedate Menu Dashboard.bqy | Y | Y | ||||
Jun 07 | 6/30/2007 | 11140 | Corrected rate retention calculation | LTV Analysis.bqy | Y | Y | |||
Jun 07 | 6/30/2007 | 10885 | Add phone / email to drill down options | Top X Customers.bqy | Y | Y | |||
Jun 07 | 6/30/2007 | 11181 | Provide a query summary documentation for each of the analysis in the EAS | ||||||
Jun 07 | 7/19/2007 | 11187 | redirect offer and category export and print command buttons to correct pivot tables | Item Summary Sales.bqy | Y | Y | |||
Aug 07 | 8/22/2007 | 11465 | Added version 9.0 trans code, redesign to populate co/div list boxes from main query | Closed AR History.bqy | Y | Y | |||
Aug 07 | 7/23/2007 | 10469 | New Customer Summary Sales.bqy query | Customer Summary Sales.bqy | Y | Y | |||
Aug 07 | 8/22/2007 | 11471 | Redesign to populate co/div list boxes from main query | Customer Summary Sales.bqy | Y | Y | |||
Aug 07 | 8/22/2007 | 11466 | Activate pivot and command buttons on main dashboard, redesign to populate co/div list boxes from main query | Inventory Adjustments.bqy | Y | Y | |||
Aug 07 | 8/22/2007 | 11467 | Activate pivot and command buttons on main dashboard, redesign to populate co/div list boxes from main query | Inventory Receiving Analysis.bqy | Y | Y | |||
Aug 07 | 8/3/2007 | 11323 | removed .dbo from Period Table properties | Item Demand Analysis | Y | Y | |||
Aug 07 | 8/22/2007 | 11472 | Redesign to populate co/div list boxes from main query | Item Demand Analysis | Y | Y | |||
Aug 07 | 8/23/2007 | 11244 | Change startup script do not include Fiscal Date Query in ProcessAll. Change concantenated computed formula in oracle version to use '||" rather than "+"; Redesign to populate co/div list boxes from main query | Item Summary Sales.bqy | Y | Y | |||
Aug 07 | 8/1/2007 | 11247 | revised field names in promotion_history.xls file to replace " " with "_" | LTV Analysis.bqy | Y | Y | |||
Aug 07 | 8/22/2007 | 11473 | Redesign to populate co/div list boxes from main query | LTV Analysis.bqy | Y | Y | |||
Aug 07 | 7/31/2007 | 9956 | New query for job publishing | Open Orders by Item - job.bqy | Y | Y | |||
Aug 07 | 8/23/2007 | 11487 | added Ref_Itm_Sta_Lgcy_Cd; Redesign to populate co/div list boxes from main query | Open Orders by Item.bqy | Y | Y | |||
Aug 07 | 8/8/2007 | 11367 | modify startup script to run Companies Query on opening the query from main query; | Open purchase orders.bqy | Y | Y | |||
Aug 07 | 8/23/2007 | 11475 | Redesign to populate co/div list
boxes from main query; Change startup script to leave pivot table and command
buttons visible on main dashboard |
P and H Overrides.bqy | Y | Y | |||
Aug 07 | 8/24/2007 | 11476 | Redesign to populate co/div list boxes from main query; Change startup script to leave pivot table and command buttons visible on main dashboard | Pick Velocity.bqy | Y | Y | |||
Aug 07 | 8/13/2007 | 11394 | changed to universal version, modified report to pull in pivot rather than use outliner | Receiving Staffing Requirements.bqy | Y | Y | |||
Aug 07 | 8/24/2007 | 11477 | Redesign to populate co/div list boxes from main query; Change startup script to leave pivot table and command buttons visible on main dashboard | Receiving Staffing Requirements.bqy | Y | Y | |||
Aug 07 | 7/27/2007 | 11261 | Updated csv file to include all order status codes even those not related to processing records. Also included values related to Ecometry version 9. | REF_PROCESS_ACTION_SRCH | Y | Y | |||
Aug 07 | 8/13/2007 | 9955 | New query for job publishing | Returns Analysis - job.bqy | Y | Y | |||
Aug 07 | 8/8/2007 | 11215 | add personal page reference, add FUNCTION to create unique result set list | Returns Analysis.bqy | Y | Y | |||
Aug 07 | 8/23/2007 | 11478 | Activate pivot and command buttons on main dashboard, redesign to populate co/div list boxes from main query | Returns Analysis.bqy | Y | Y | |||
Aug 07 | 8/20/2007 | 9953 | New query for job publishing | Sales by Product Id Demand - Job.bqy | Y | Y | |||
Aug 07 | 8/20/2007 | 9953 | New query for job publishing | Sales by Product Id Demand Fiscal - Job.bq | Y | Y | |||
Aug 07 | 8/20/2007 | 9953 | New query for job publishing | Sales by Product Id Ship - Job.bqy | Y | Y | |||
Aug 07 | 8/20/2007 | 9953 | New query for job publishing | Sales by Product Id Ship Fiscal - Job.bqy | Y | Y | |||
Aug 07 | 7/30/2007 | 9970 | Added reference tables to query | Sales by Product Id.bqy | Y | Y | |||
Aug 07 | 8/23/2007 | 11491 | Redesign to populate co/div list boxes from main query | Sales by Product Id.bqy | Y | Y | |||
Aug 07 | 8/9/2007 | 11378 | redesign to one query | Shipping charge analysis.bqy | Y | Y | |||
Aug 07 | 8/23/2007 | 11479 | Activate pivot and command buttons on main dashboard, redesign to populate co/div list boxes from main query | Shipping charge analysis.bqy | Y | Y | |||
Aug 07 | 8/21/2007 | 9954 | New query for job publishing | UnShipped Orders by Status - Job.bqy | Y | Y | |||
Aug 07 | 8/23/2007 | 11206 | redesign query: consolidate to one union all query, added ref tables; populate co-div list boxes from main query | UnShipped Orders by Status.bqy | Y | Y | |||
Aug 07 | 8/8/2007 | 11016 | deleted extra "pivot" and renamed Inv Tran Qty to Units received, added personal page scripting | Vendor expenditures by year and category.b | Y | Y | |||
Aug 07 | 8/23/2007 | 11480 | Redesign to populate co/div list boxes from main query; Change startup script to leave pivot table and command buttons visible on main dashboard | Vendor expenditures by year and category.b | Y | Y | |||
Aug 07 | 8/8/2007 | 11292 | add personal page scripting | Vendor performance analysis.bqy | Y | Y | |||
Aug 07 | 8/23/2007 | 11481 | Redesign to populate co/div list boxes from main query; Change startup script to leave pivot table and command buttons visible on main dashboard | Vendor performance analysis.bqy | Y | Y | |||
Aug 07 | 8/8/2007 | 11371 | Revise startup script for personal page and to run companies query when opened | Vendor returns analysis.bqy | Y | Y | |||
Aug 07 | 8/23/2007 | 11482 | Redesign to populate co/div list boxes from main query; Change startup script to leave pivot table and command buttons visible on main dashboard | Vendor returns analysis.bqy | Y | Y | |||
Aug 07 | 8/23/2007 | 11497 | activate pivot and command buttons on main dashboard | Open purchase orders.bqy | Y | Y | |||
Aug 07 | 8/24/2007 | 11496 | Redesign to populate co/div list boxes from main query; allow division 00 to display in list box | Item Analysis.bqy | Y | Y | |||
Aug 07 | 8/27/2007 | 11504 | Redesign Orders query to pull inVendor info, added Customer to drill down | Item Demand Analysis | Y | Y | |||
Aug 07 | 8/29/2007 | 11539 | Add Tel_Nbr_Role limit to query | Closed AR History.bqy | Y | Y | |||
Aug 07 | 8/29/2007 | 11545 | Add Tel_Nbr_Role limit to query | Vendor performance analysis.bqy | Y | Y | |||
Aug 07 | 8/29/2007 | 11537 | Add Tel_Nbr_Role limit to query, populate co-div list boxes from main query | Aged Open AR.bqy | Y | Y | |||
Aug 07 | 8/29/2007 | 11538 | Add Tel_Nbr_Role limit to query, populate co-div list boxes from main query | Aged Orders in the Warehouse.bqy | Y | Y | |||
Aug 07 | 8/29/2007 | 11540 | Add Tel_Nbr_Role limit to query, populate co-div list boxes from main query | Merchandise Performance Analysis.bqy | Y | Y | |||
Aug 07 | 8/29/2007 | 11541 | Add Tel_Nbr_Role limit to query, populate co-div list boxes from main query | Pending Refunds.bqy | Y | Y | |||
Aug 07 | 8/29/2007 | 11542 | Add Tel_Nbr_Role limit to query, populate co-div list boxes from main query | Price Range Analysis.bqy | Y | Y | |||
Aug 07 | 8/29/2007 | 11543 | Add Tel_Nbr_Role limit to query, populate co-div list boxes from main query | Repeat Buyer Analysis.bqy | Y | Y | |||
Aug 07 | 8/29/2007 | 11544 | Add Tel_Nbr_Role limit to query, populate co-div list boxes from main query | Spread Performance Analysis.bqy | Y | Y | |||
Sep 07 | 9/11/2007 | 11154 | Add open po and on hand inventory as well as exchange/return data, added reference tables | Item Summary Sales.bqy | Y | Y | |||
Sep 07 | 9/14/2007 | 11671 | Add timestamp to end date query limit | Vendor expenditures by year and category.b | Y | Y | |||
Sep 07 | 9/14/2007 | 11675 | Add timestamp to end date query limit, populate co-div list box from main query | Price Overrides.bqy | Y | Y | |||
Sep 07 | 9/24/2007 | 11763 | removed dbo. from physical table name, populate co-div list boxes from main query | All Orders by Status.bqy | Y | Y | |||
Sep 07 | 9/24/2007 | 11764 | removed dbo. from physical table name | Merchandise Performance Analysis.bqy | Y | Y | |||
Sep 07 | 9/24/2007 | 11765 | removed dbo. from physical table name | Price Range Analysis.bqy | Y | Y | |||
Sep 07 | 9/24/2007 | 11766 | removed dbo. from physical table name | Sales by Product ID.bqy | N | Y | |||
Sep 07 | 9/24/2007 | 11767 | removed dbo. from physical table name | Spread Performance Analysis.bqy | Y | Y | |||
Sep 07 | 9/24/2007 | 11768 | removed dbo. from physical table name, change to derivable query | Top X Customers.bqy | Y | Y | |||
Sep 07 | 9/24/2007 | 11769 | removed dbo. from physical table name | Vendor performance analysis.bqy | Y | Y | |||
Sep 07 | 9/24/2007 | 11770 | removed dbo. from physical table name | Vendor returns analysis.bqy | Y | Y | |||
Sep 07 | 9/26/2007 | 11788 | Change currency fields to 4 decimal positions | Inventory Adjustments.bqy | Y | Y | |||
Sep 07 | 9/26/2007 | 11789 | Change currency fields to 4 decimal positions, populate co-list boxes from main query, change fonts to Arial | Inventory Value.bqy | Y | Y | |||
Sep 07 | 9/26/2007 | 11790 | Change currency fields to 4 decimal positions | Open purchase orders.bqy | Y | Y | |||
Sep 07 | 9/27/2007 | 9863 | Initial Query | Demand vs Shipped Sales.bqy | Y | Y | |||
Mar 08 | 10/11/2007 | 11858 | Added Offer Code List box, populate co-div list boxes from main query | Forecast to Buy | Y | Y | |||
Mar 08 | 10/12/2007 | 9863 | Added State Pivot | Demand vs Shipped Sales.bqy | Y | Y | |||
Mar 08 | 10/17/2007 | 11966 | add company list box to select dashboard, redesign to a derivable query | Obsolete Inventory.bqy | Y | Y | |||
Mar 08 | 10/25/2007 | 12089 | Modify script to display navigation bar in web environment | Current Snapshot Analysis.bqy | Y | Y | |||
Mar 08 | 11/1/2007 | 11987 | pull co/div fields from comp/div rather than order header | Item Demand Analysis.bqy | Y | Y | |||
Mar 08 | 11/1/2007 | 12125 | modified join on ref_ord_sub_sta_lgcy_cd to right join | Top X Customers.bqy | Y | Y | |||
Mar 08 | 11/5/2007 | 11854 | change limits on Amount Type
Code in order detail query to include nulls, add a limit on each of the
Shipped Financial Transaction tables. Only include records where Transaction Code is 11,12,13,14,15,16,17, or 18 |
Net Product Sales Analysis.bqy | Y | Y | |||
Mar 08 | 11/8/2007 | 12135 | Redesigned query for new Returns table | Returns Analysis NEW.bqy | Y | Y | |||
Mar 08 | 11/8/2007 | 12136 | Redesigned query for new Returns table | Open RAs NEW.bqy | Y | Y | |||
Mar 08 | 11/8/2007 | 12137 | Redesigned query for new Returns table | Vendor returns analysis NEW.bqy | Y | Y | |||
Mar 08 | 11/8/2007 | 12138 | Redesigned query for new Returns table | Sales versus Returns Analysis NEW.bqy | Y | Y | |||
Mar 08 | 11/8/2007 | 12141 | Redesigned query for new Returns table, populate co-div list box from main query | Net Product Sales Analysis NEW.bqy | Y | Y | |||
Mar 08 | 11/8/2007 | 12146 | Redesigned query for new Returns table | Returns Analysis - job NEW.bqy | Y | Y | |||
Mar 08 | 11/12/2007 | 12144 | Redesigned query for new Returns table | Item Summary Sales New.bqy | Y | Y | |||
Mar 08 | 11/14/2007 | 12139 | Redesigned query for new Returns table | Merchandise Performance Analysis NEW.bqy | Y | Y | |||
Mar 08 | 11/14/2007 | 12140 | Redesigned query for new Returns table | Spread Performance Analysis NEW.bqy | Y | Y | |||
Mar 08 | 11/15/2007 | 12142 | Redesigned query for new Returns table | Demand vs Shipped Sales NEW.bqy | Y | Y | |||
Mar 08 | 11/15/2007 | 12145 | Redesigned query for new Returns table | LTV Analysis NEW.bqy | Y | Y | |||
Mar 08 | 11/20/2007 | 12264 | Added limit to eliminate canceled orders, populate co-div list boxes from main query | Orders in the Warehouse.bqy | Y | Y | |||
Mar 08 | 11/20/2007 | 12269 | Removed extraneous query section (used in testing) | Expected Weekly PO Receipts.bqy | Y | Y | |||
Mar 08 | 11/28/2007 | 12143 | Redesign to combine backorder and order detail queries, new return table layout | Item Demand Analysis NEW.bqy | Y | Y | |||
Mar 08 | 11/28/2007 | 12143 | Redesign to combine backorder and order detail queries | Item Demand Analysis.bqy | Y | Y | |||
Mar 08 | 11/28/2007 | 12287 | Modify startup script | Inventory Receiving Analysis.bqy | Y | Y | |||
Mar 08 | 11/30/2007 | 11556 | Apply limit to manifest status codes to select shipped | Shipping charge analysis.bqy | Y | Y | |||
Mar 08 | 11/30/2007 | 11556 | Initial Query | Shipping Charge Summary.bqy | Y | Y | |||
Mar 08 | 12/10/2007 | 12400 | Moved Days In Warehouse calculation from the request line to a computed field in the result set | Orders at the drop shipper.bqy | Y | Y | |||
Mar 08 | 12/20/2007 | 12465 | Add a query limits dashboard to display select criteria for scheduled job | Returns Analysis - job.bqy | Y | Y | |||
Mar 08 | 12/20/2007 | 12471 | Add a query limits dashboard to display select criteria for scheduled job | Returns Analysis - job NEW.bqy | Y | Y | |||
Mar 08 | 12/21/2007 | 12470 | Add a query limits dashboard to display select criteria for scheduled job | UnShipped Orders by Status - Job.bqy | Y | Y | |||
Mar 08 | 12/27/2007 | 12464 | Add a query limits dashboard to display select criteria for scheduled job | Open Orders by Item - job.bqy | Y | Y | |||
Mar 08 | 12/27/2007 | 12466 | Add a query limits dashboard to display select criteria for scheduled job | Sales by Product Id Demand - Job.bqy | Y | Y | |||
Mar 08 | 12/27/2007 | 12467 | Add a query limits dashboard to display select criteria for scheduled job | Sales by Product Id Ship - Job.bqy | Y | Y | |||
Mar 08 | 12/27/2007 | 12468 | Add a query limits dashboard to display select criteria for scheduled job | Sales by Product Id Ship Fiscal - Job.bqy | Y | Y | |||
Mar 08 | 12/27/2007 | 12469 | Add a query limits dashboard to display select criteria for scheduled job | Sales by Product Id Demand Fiscal - Job.bq | Y | Y | |||
Mar 08 | 1/20/2008 | 12621 | Display selected co/div limits on dashboards and reports | Open RAs NEW.bqy | Y | Y | |||
Mar 08 | 1/20/2008 | 12624 | Display selected co/div limits on dashboards and reports | Inventory Adjustments.bqy | Y | Y | |||
Mar 08 | 1/21/2008 | 12609 | Modify Aging calculation to sort in order of days, add query limit dashboard | Aged Open AR.bqy | Y | Y | |||
Mar 08 | 1/21/2008 | 12610 | Display selected co/div limits on dashboards and reports | Closed AR History.bqy | Y | Y | |||
Mar 08 | 1/22/2008 | 12701 | Correct GM% calculation on Item Pivot table | Net Product Sales Analysis NEW.bqy | Y | Y | |||
Mar 08 | 1/23/2008 | 12703 | Change Returns_Style_Header.Style_Description to .Description; Change Open RA Ind to <> Y | Net Product Sales Analysis NEW.bqy | Y | Y | |||
Mar 08 | 1/23/2008 | 12710 | Add Include in ProcessAll() logic to startup script | Item Demand Analysis.bqy | Y | Y | |||
Mar 08 | 1/23/2008 | 12711 | Modify query script to run fiscal date query when fiscal date range is selected, change Open RA ind limit to <> Y | Demand vs Shipped Sales NEW.bqy | Y | Y | |||
Mar 08 | 1/23/2008 | 12712 | Add Include in ProcessAll() logic to startup script | Item Summary Sales.bqy | Y | Y | |||
Mar 08 | 1/23/2008 | 12713 | Change Open RA Ind to <> Y | LTV Analysis NEW.bqy | Y | Y | |||
Mar 08 | 1/23/2008 | 12714 | Add Include in ProcessAll() logic to startup script | Merchandise Performance Analysis NEW.bqy | Y | Y | |||
Mar 08 | 1/23/2008 | 12725 | Add Include in ProcessAll() logic to startup script, Change Open RA Ind to <> Y | Spread Performance Analysis NEW.bqy | Y | Y | |||
Mar 08 | 1/23/2008 | 12726 | Change Open RA Ind to <> Y | Vendor returns analysis NEW.bqy | Y | Y | |||
Mar 08 | 1/23/2008 | 12727 | Add Include in ProcessAll() logic to startup script | Customer Summary Sales.bqy | Y | Y | |||
Mar 08 | 1/23/2008 | 12728 | Add Include in ProcessAll() logic to startup script | Sales by Product ID.bqy | Y | Y | |||
Mar 08 | 1/24/2008 | 12723 | Change Open RA Ind to <> Y | Returns Analysis - job NEW.bqy | Y | Y | |||
Mar 08 | 1/24/2008 | 12724 | Change Open RA Ind to <> Y | Sales versus Returns Analysis New.bqy | Y | Y | |||
Mar 08 | 1/28/2008 | 12612 | Add co/div desc to results, populate co/div list boxes from main query, add selected limits on dashboards and reports | Avg orders items and dollars by source.bqy | Y | Y | |||
Mar 08 | 1/28/2008 | 12615 | Display selected co/div limits on dashboards and reports | Item Summary Sales New.bqy | Y | Y | |||
Mar 08 | 1/29/2008 | 12613 | Display selected co/div limits on dashboards and reports, add co/div desc to result set for drill down | Item Analysis.bqy | Y | Y | |||
Mar 08 | 1/29/2008 | 12616 | Change pivot layout to landscape; change item status criteria to a list box | Net Product Sales Analysis NEW.bqy | Y | Y | |||
Mar 08 | 1/30/2008 | 12618 | Display selected co/div limits on dashboards and reports | All Orders by Status.bqy | Y | Y | |||
Mar 08 | 1/30/2008 | 12619 | Display selected co/div limits on dashboards and reports | P and H Overrides.bqy | Y | Y | |||
Mar 08 | 1/30/2008 | 12620 | Display selected co/div limits on dashboards and reports | Price Overrides.bqy | Y | Y | |||
Mar 08 | 1/30/2008 | 12622 | Display selected co/div limits on dashboards and reports | Pending Refunds.bqy | Y | Y | |||
Mar 08 | 1/30/2008 | 12623 | Display selected co/div limits on dashboards and reports | Returns Analysis NEW.bqy | Y | Y | |||
Mar 08 | 1/31/2008 | 12625 | Display selected co/div limits on dashboards and reports | Inventory Receiving Analysis.bqy | Y | Y | |||
Mar 08 | 1/31/2008 | 12626 | Display selected co/div limits on dashboards and reports | Obsolete Inventory.bqy | Y | Y | |||
Mar 08 | 1/31/2008 | 12628 | Display selected co/div limits on dashboards and reports | Back Orders.bqy | Y | Y | |||
Mar 08 | 1/31/2008 | 12631 | Display selected co/div limits on dashboards and reports | Open purchase orders.bqy | Y | Y | |||
Mar 08 | 1/31/2008 | 12632 | Display selected co/div limits on dashboards and reports | Orders at the drop shipper.bqy | Y | Y | |||
Mar 08 | 2/14/2008 | 12630 | Display selected co/div limits on dashboards and reports, Add Report | Forecast to Buy.bqy | Y | Y | |||
Mar 08 | 2/13/2008 | 12629 | Display selected co/div limits on dashboards and reports, Add Report | Back orders by vendor and buyer.bqy | Y | Y | |||
Mar 08 | 2/26/2008 | 12855 | Remove ship method reference table from query section | Sales by Prod ID.bqy | Y | Y | |||
Mar 08 | 2/26/2008 | 12949 | Remove ship method reference table from query section | Sales by Prod ID Demand - Job.bqy | Y | Y | |||
Mar 08 | 2/26/2008 | 12950 | Remove ship method reference table from query section | Sales by Prod ID Demand Fiscal- Job.bqy | Y | Y | |||
Mar 08 | 2/26/2008 | 12951 | Remove ship method reference table from query section | Sales by Prod ID Ship - Job.bqy | Y | Y | |||
Mar 08 | 2/26/2008 | 12952 | Remove ship method reference table from query section | Sales by Prod ID Ship Fiscal- Job.bqy | Y | Y | |||
Mar 08 | 2/26/2008 | 12955 | Apply a limit to exclude kit components | Item Demand Analysis NEW.bqy | Y | Y | |||
Mar 08 | 2/27/2008 | 12973 | renamed main dashboard to Selection Criteria Dashboard | Item Demand Analysis NEW.bqy | Y | Y | |||
Mar 08 | 2/26/2008 | 12960 | renamed main dashboard to Selection Criteria Dashboard | Price Range Analysis.bqy | Y | Y | |||
Mar 08 | 2/27/2008 | 12627 | Added line item counts to pivot tables | Aged Orders in the Warehouse.bqy | Y | Y | |||
Mar 08 | 2/29/2008 | 13205 | Changed union to union ALL in the appedn query. Changed Vend Pref Cd limit to include NULL. Corrected script for populating co and div list boxes. | Item Demand Analysis.bqy | Y | Y | |||
Mar 08 | 2/29/2008 | 13206 | Changed union to union ALL in the appedn query. Changed Vend Pref Cd limit to include NULL. Corrected script for populating co and div list boxes. Changed Open RA Ind limit to include NULL. | Item Demand Analysis NEW.bqy | Y | Y | |||
Mar 08 | 2/29/2008 | 13204 | Changed Open RA Ind limit to include <> Y | Item Demand Analysis NEW.bqy | Y | Y | |||
Mar 08 | 2/29/2008 | 12614 | Modified starup script to populate list boxes from main dashboard, add limits to report | Items changed to discontinued.bqy | Y | Y | |||
Mar 08 | 3/5/2008 | 13024 | Sort Proc Results by Source to eliminate duplicates | Offer PNL.bqy | Y | Y | |||
Mar 08 | 3/17/2008 | 13123 | Company/division list boxes didn't populate correctly. | Avg orders items and dollars by source.bqy | Y | Y | |||
Mar 08 | 3/18/2008 | 13140 | Datamodel options for limits & joins; doc startup script changes for company/divison "00" | Aged Open AR.bqy | Y | Y | |||
Mar 08 | 3/18/2008 | 13140 | Datamodel options for limits; doc startup script changes for company/divison "00" | Aged Orders in the Warehouse.bqy | Y | Y | |||
Mar 08 | 3/18/2008 | 13023 | company/division parameters not being passed to SQL - correct "Process Query" script | All Orders by Status.bqy | Y | Y | |||
Mar 08 | 3/18/2008 | 13140 | Datamodel options for limits; doc startup script changes for company/divison "00" | All Orders by Status.bqy | Y | Y | |||
Mar 08 | 3/18/2008 | 13140 | Datamodel options for limits; doc startup script changes for company/divison "00" | Back orders by vendor and buyer.bqy | Y | Y | |||
Mar 08 | 3/18/2008 | 13140 | doc startup script changes for company/divison "00" | Closed AR History.bqy | Y | Y | |||
Mar 08 | 3/18/2008 | 13140 | Datamodel options for limits; doc startup script changes for company/divison "00" | Customer Summary Sales.bqy | Y | Y | |||
Mar 08 | 3/18/2008 | 13140 | Datamodel options for limits; doc startup script changes for company/divison "00" | Demand vs Shipped Sales NEW.bqy | Y | Y | |||
Mar 08 | 3/18/2008 | 13141 | Change limits on Vendor Preference Code and Open RA Ind to "Include Nulls" | Demand vs Shipped Sales NEW.bqy | Y | Y | |||
Mar 08 | 3/18/2008 | 13140 | Datamodel options for limits; doc startup script changes for company/divison "00" | Demand vs Shipped Sales.bqy | Y | Y | |||
Mar 08 | 3/18/2008 | 13141 | Change limits on Vendor Preference Code and Open RA Ind to "Include Nulls" | Demand vs Shipped Sales.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13140 | Datamodel options for limits; doc startup script changes for company/divison "00" | Expected Weekly PO Receipts.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13140 | Datamodel options for limits; doc startup script changes for company/divison "00" | Forecast to Buy.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13140 | Datamodel options for limits; doc startup script changes for company/divison "00" | Inventory Adjustments.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13140 | Datamodel options for limits; doc startup script changes for company/divison "00" | Inventory Receiving Analysis.bqy | Y | Y | |||
Mar 08 | 3/18/2008 | 13091 | change layout of report sections. Use "File" / "Page Setup" instead of custom dimensions | Inventory Receiving Analysis.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13146 | connection wasn't being established in Doc Startup script - missing "}" after check for browser | Inventory Value.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13140 | Datamodel options for limits; doc startup script changes for company/divison "00" | Inventory Value.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13140 | Datamodel options for limits | Item Demand Analysis NEW.bqy | Y | Y | |||
Mar 08 | 3/18/2008 | 12973 | Changed dashboard section name and propagated through scripts | Item Demand Analysis.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13140 | Datamodel options for limits; doc startup script changes for company/divison "00" | Item Demand Analysis.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13140 | Datamodel options for limits; doc startup script changes for company/divison "00" | Items changed to discontinued.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13148 | Change doc startup for populating lists; remove "IncludeInProcessAll" from startup; add underscores to column headers in Promotion History xls; change Open RA Ind limit to "Include Nulls" | LTV Analysis NEW.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13148 | Change doc startup for populating lists; remove "IncludeInProcessAll" from startup; add underscores to column headers in Promotion History xls | LTV Analysis.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13149 | Change Open RA Ind to "Include nulls" | Merchandise Performance Analysis NEW.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13140 | Datamodel options for Joins - Use auto join path; doc startup script changes for company/divison "00" | Merchandise Performance Analysis NEW.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13140 | Datamodel options for Joins - Use auto join path; doc startup script changes for company/divison "00" | Merchandise Performance Analysis.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13151 | Add Ref_Itm_Sta_Lgcy_Cd table and use it for limits; change Open AR Ind limit to "Include nulls"; correct doc startup script that loads company/division listboxes | Net Product Sales Analysis NEW.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13151 | Add Ref_Itm_Sta_Lgcy_Cd table and use it for limits; add code in Doc Startup to populate Item Status list box | Net Product Sales Analysis.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13162 | Remove Stock Balance Returns from query - Order Header Status = SR | Net Product Sales Analysis NEW.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13162 | Remove Stock Balance Returns from query - Order Header Status = SR | Net Product Sales Analysis.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13154 | Change limits to apply to Inventory Query section | Obsolete Inventory.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13140 | Datamodel options for Joins - Use auto join path; doc startup script changes for company/divison "00" | Open Orders by Item.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13140 | Set Datamodel / Limits option to "Show all values" | Open Orders by Item - job.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13155 | Only activate main dashboard if not in Personal Page or Embedded Browser | Open Orders by Item - job.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Open purchase orders.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Orders at the drop shipper.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Orders in the Warehouse.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13159 | Correct computed item for Warehouse -- was resulting in "00" | Orders in the Warehouse.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | P and H Overrides.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Pending Refunds.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Pick Velocity.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Price Overrides.bqy | Y | Y | |||
Mar 08 | 3/19/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Price Range Analysis.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Receiving Staffing Requirements.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Repeat Buyer Analysis.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Returns Analysis.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Returns Analysis NEW.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Sales by Product ID.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13162 | Remove Stock Balance Returns from query - Order Header Status = SR | Sales by Product ID.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13163 | Only activate main dashboard if not in Personal Page or Embedded Browser | Sales by Product ID.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13140 | Set Datamodel / Limits option to "Show all values" | Sales by Product ID Demand - Job.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13162 | Remove Stock Balance Returns from query - Order Header Status = SR | Sales by Product ID Demand - Job.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13140 | Set Datamodel / Limits option to "Show all values" | Sales by Product ID Demand Fiscal - Job.bq | Y | Y | |||
Mar 08 | 3/20/2008 | 13162 | Remove Stock Balance Returns from query - Order Header Status = SR | Sales by Product ID Demand Fiscal - Job.bq | Y | Y | |||
Mar 08 | 3/20/2008 | 13140 | Set Datamodel / Limits option to "Show all values" | Sales by Product ID Ship - Job.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13162 | Remove Stock Balance Returns from query - Order Header Status = SR | Sales by Product ID Ship - Job.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13140 | Set Datamodel / Limits option to "Show all values" | Sales by Product ID Ship Fiscal - Job.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13162 | Remove Stock Balance Returns from query - Order Header Status = SR | Sales by Product ID Ship Fiscal - Job.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Sales versus Returns Analysis New.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13164 | Change limits on Open AR Ind to "Include Nulls" | Sales versus Returns Analysis New.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Shipping charge analysis.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Spread Performance Analysis.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Spread Performance Analysis NEW.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13166 | Change Open RA Ind limit to "Include Nulls" | Spread Performance Analysis NEW.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Top X Customers.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13167 | use Comp_Div_Master in Detail Data Query for Company/Division listbox population | Top X Customers.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Unshipped Order by Status.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13140 | Set Datamodel / Limits option to "Show all values" | Unshipped Order by Status - Job.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Vendor expenditures by year and category.b | Y | Y | |||
Mar 08 | 3/20/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Vendor performance analysis.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Vendor returns analysis.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13140 | Set Datamodel / Limits option to "Show all values"; correct doc startup script that loads company / division listboxes | Vendor returns analysis NEW.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13168 | Change Open RA Ind limit to "Include Nulls" | Vendor returns analysis NEW.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13169 | Add Comp_Div_Master table to query and use it for variable limits | Returns Analysis - job NEW.bqy | Y | Y | |||
Mar 08 | 3/20/2008 | 13157 | Restrict results to only entries where the extended price variance <> 0 | Price Overrides.bqy | Y | Y | |||
Mar 08 | 3/21/2008 | 13174 | Create computed item without time portion of entry date and use it in pivot | Price Overrides.bqy | Y | Y | |||
Mar 08 | 4/1/2008 | 13144 | Obsolete Inventory query incorrectly includes non-usable inventory | Obsolete Inventory.bqy | Y | Y | |||
Mar 08 | 4/3/2008 | 13280 | Change Open RA Ind limit to "Include Nulls" | Returns Analysis NEW.bqy | Y | Y | |||
Mar 08 | 4/3/2008 | 13277 | Correct field name mis-spelling in OnPostProcess script | Returns Analysis - job NEW.bqy | Y | Y | |||
Mar 08 | 4/8/2008 | 13035 | Correct joins between Order Header and Comp Div Master. Was selecting data from divisions not specified in criteria. Add Company and Division as drill-down fields. | Sales versus Returns Analysis NEW.bqy | Y | Y | |||
Mar 08 | 4/8/2008 | 13314 | Change style description - populate with item description for items that are not part of a style | Sales versus Returns Analysis NEW.bqy | Y | Y | |||
Jan 09 | 6/23/2008 | 13925 | Now driving off of Back Orders
rather than Processing which is consistent with the "Back
Orders.bqy" query and with Ecometry. Remove computed items from request line, select individual fields from Customers, and put Customer computed item in results set. Created universal version. |
Back orders by vendor and buyer.bqy | Y | Y | |||
Jan 09 | 7/28/2008 | 13035 | Fixed the selection criteria to exclude records with no returns. Did so by adding column max fields against the cum rtn qty fields for the item, style, and category levels. Then we replaced the cum fields with the column max fields for the selection criteria to exclude records with no returns. Reorganized the item, style, and category level tables and pivots to all be within one general section. | Sales Versus Returns Analysis NEW.bqy | Y | Y | |||
Jan 09 | 8/1/2008 | 14420 | Fixed the company and division selection criteria. The order_header co_cd and div_cd were both being both joined to comp_div_master's co_cd. Fixed it by joining both fields in order_header to their corresponding fields in comp_div_master. | Sales versus Returns Analysis New.bqy | Y | Y | |||
Jan 09 | 7/23/2008 | 14275 | Force database connection to each query section in Process Query script to ensure it is pulling current data. Change append queries to "Union All" from "Union". | Current Snapshot Analysis.bqy | Y | Y | |||
Jan 09 | 7/31/2008 | 14384 | Added "PB" records (Closed, Invoice Approved) to be included in the results by default, but added radio buttons to allow the user to choose Open - Invoice Not Approved ("P"), Closed - Invoice Approved ("PB"), or Both ("P", "PB") inventory trans status values. Added SV_MACITM_PO_DETAILS to the data model. Joined from there to Vendor Items. Made joins from PO Details to Vendor Items left joins to include auto purchase items that lack an assigned vendor items record. | Inventory Receiving Analysis.bqy (Oracle & SQLServer versions) | Y | Y | |||
Jan 09 | 7/25/2008 | 14279 | Modified report to pull warehouse locations from the correct source. Removed SV_MACITM_ITEM_MAST_WH and added SV_MACITM_ITEM_POS_LOC (Assigned Warehouse Locations Cross-References). Limited results to "WLOC" entries. | Item Analysis.bqy | Y | Y | |||
Jan 09 | 7/25/2008 | 14279 | Modified report to pull warehouse locations from the correct source. Removed SV_MACITM_ITEM_MAST_WH and added SV_MACITM_ITEM_POS_LOC (Assigned Warehouse Locations Cross-References). Limited results to "WLOC" entries. | Receiving Staffing Requirements.bqy | Y | Y | |||
Jan 09 | 8/12/2008 | 14430 | Added co_div_days_late column and sort. Changed the joins on the ref tables to left joins to ensure no records are excluded simply because their corresponding codes are missing from the reference tables. Removed 'process all' from start up scripts and removed closed ar query results from the processing order. | Closed AR History.bqy | Y | Y | |||
Jan 09 | 9/11/2008 | 14178 | Excluding Hold for Quote orders (Order Header status = PQ) from the results | Demand vs Shipped Sales.bqy and Demand vs Shipped Sales NEW.bqy | Y | Y | |||
Jan 09 | 9/10/2008 | 14177 | Excluding Hold for Quote orders (Order Header status = PQ) from the results | Net Product Sales Analysis.bqy and Net Product Sales Analysis NEW.bqy | Y | Y | |||
Jan 09 | 9/12/2008 | 14339 | Excluding Hold for Quote orders (Order Header status = PQ) from the results | Item Demand Analysis.bqy and Item Demand Analysis NEW.bqy | Y | Y | |||
Jan 09 | 9/12/2008 | 14340 | Excluding Hold for Quote orders (Order Header status = PQ) from the results | Item Summary Sales.bqy and Item Summary Sales NEW.bqy | Y | Y | |||
Jan 09 | 9/12/2008 | 14341 | Excluding Hold for Quote orders (Order Header status = PQ) from the results | Merchandise Performance Analysis.bqy and Merchandise Performance Analysis NEW.bqy | Y | Y | |||
Jan 09 | 9/12/2008 | 14342 | Excluding Hold for Quote orders (Order Header status = PQ) from the results | Price Range Analysis.bqy | Y | Y | |||
Jan 09 | 9/12/2008 | 14344 | Excluding Hold for Quote orders (Order Header status = PQ) from the results | Top X Customers.bqy | Y | Y | |||
Jan 09 | 9/12/2008 | 14343 | Excluding Hold for Quote orders (Order Header status = PQ) from the results | Spread Peformance Analysis.bqy and Spread Peformance Analysis New.bqy | Y | Y | |||
Jan 09 | 9/12/2008 | 14176 | Excluding Hold for Quote orders (Order Header status = PQ) from the results | Sales by Product ID.bqy (Oracle & SQLServ | Y | Y | |||
Jan 09 | 9/12/2008 | 14354 | Excluding Voided POS orders (Order Header status = VD) from the results | Sales by Product ID.bqy (Oracle & SQLServ | Y | Y | |||
Jan 09 | 9/26/2008 | 14841 | Fixed sort by drop down boxes on
two dashboards (By Category & By Type) |
Sales by Product ID.bqy (Oracle & SQLServer) | Y | Y | |||
Jan 09 | 9/12/2008 | 14355 | Excluding Voided POS orders (Order Header status = VD) from the results | Net Product Sales Analysis NEW.bqy and Net Product Sales Analysis.bqy | Y | Y | |||
Jan 09 | 9/30/2008 | 14859 | Fixed sort by drop down box on 'By Sec Ctr' dashboard | Net Product Sales Analysis NEW.bqy and Net Product Sales Analysis.bqy | Y | Y | |||
Jan 09 | 9/19/2008 | 14789 | Fixed logic for 'include only returns' checkbox filter criteria (already fixed in 'NEW' version via case 13035). | Sales Versus Returns Analysis.bqy | Y | Y | |||
Jan 09 | 9/19/2008 | 13955 | Exclude price adjustments (Returns status = M or P) from the returns data | Sales Versus Returns Analysis.bqy AND Sales Versus Returns Analysis NEW.bqy | Y | Y | |||
Jan 09 | 9/19/2008 | 14800 | Fixed errors related to sort by drop down boxes | Sales Versus Returns Analysis.bqy and Sales Versus Returns Analysis NEW.bqy | Y | Y | |||
Jan 09 | 9/30/2008 | 13854 | Corrected dashboard titles | Item Summary Sales.bqy and Item Summary Sales NEW.bqy | Y | Y | |||
Jan 09 | 9/12/2008 | 14165 | Excluding Hold for Quote orders (Order Header status = PQ) from the results | Sales by Product ID Demand - Job.bqy (Oracle & SQLServer versions) | Y | Y | |||
Jan 09 | 10/3/2008 | 14886 | Fixed sort by drop down boxes on two dashboards (By Category & By Type) | Sales by Product ID Demand - Job.bqy (Oracle & SQLServer versions) | Y | Y | |||
Jan 09 | 10/3/2008 | 14837 | Excluding Hold for Quote orders (Order Header status = PQ) from the results | Sales by Product ID Demand - Fiscal - Job.bqy (Oracle & SQLServer versions) | Y | Y | |||
Jan 09 | 10/3/2008 | 14889 | Fixed sort by drop down boxes on two dashboards (By Category & By Type) | Sales by Product ID Demand - Fiscal - Job.bqy (Oracle & SQLServer versions) | Y | Y | |||
Jan 09 | 10/3/2008 | 14838 | Excluding Hold for Quote orders (Order Header status = PQ) from the results | Sales by Product ID Ship - Job.bqy (Oracle and SQLServer versions) | Y | Y | |||
Jan 09 | 10/3/2008 | 14898 | Fixed sort by drop down boxes on two dashboards (By Category & By Type) | Sales by Product ID Ship - Job.bqy (Oracle & SQLServer versions) | Y | Y | |||
Jan 09 | 10/3/2008 | 14839 | Excluding Hold for Quote orders (Order Header status = PQ) from the results | Sales by Product ID Ship - Fiscal - Job.bqy (Oracle & SQLServer versions) | Y | Y | |||
Jan 09 | 10/3/2008 | 14897 | Fixed sort by drop down boxes on two dashboards (By Category & By Type) | Sales by Product ID Ship - Fiscal - Job.bqy (Oracle & SQLServer version) | Y | Y | |||
Jan 09 | 10/7/2008 | 13968 | Exclude price adjustments (Returns status = M or P) from the results | Returns Analysis.bqy and Returns Analysis NEW.bqy | Y | Y | |||
Jan 09 | 10/7/2008 | 14906 | Fixed sort by drop down list error (Times Rtnd - Descending uses an invalid fact name) | Returns Analysis NEW.bqy | Y | Y | |||
Jan 09 | 10/7/2008 | 13969 | Exclude price adjustments (Returns status = M or P) from the results | Returns Analysis - Job.bqy and Returns Analysis - Job NEW.bqy | Y | Y | |||
Jan 09 | 10/7/2008 | 12090 | Fixed script so that the document section drop down list displays when viewing the report WITHOUT the client add-in. | This Year to Last Year Snapshot Analysis.bqy | Y | Y | |||
Jan 09 | 10/7/2008 | 14295 | Changed the append queries from "Union" to "Union All" (to improve processing time) and added forced connection logic to each query section in the "Process Query" script. | This Year to Last Year Snapshot Analysis.bqy | Y | Y | |||
Jan 09 | 10/8/2008 | 11291 | Replaced REF_SHIP_METH_LGCY_CD with SV_MACMAN_SHIP_METHODS to get the correct ship method descriptions. | Pick Velocity.bqy | Y | Y | |||
Jan 09 | 10/8/2008 | 14923 | Fixed sort-by drop down list error caused by incorrect fact name used in the script for the 'Warehouse Location' in the Pick Velocity Pivot2 section. | Pick Velocity.bqy | Y | Y | |||
Jan 09 | 10/14/2008 | 13383 | Checked the 'include nulls' checkbox for the Vend Pref Cd in the Limit line to avoid excluding records just because an item didn't have a matching vendor-items record. | Inventory Value.bqy (Oracle and SQLServer versions) | Y | Y | |||
Jan 09 | 10/14/2008 | 14076 | In the append query section, set the non-pertinent numeric fields from null to 0 so that the fields can be totalled correctly in the pivot tables. The fields were the Demand and Return: Qty, Amt, and COGSs. | Spread Peformance Analysis.bqy and Spread Peformance Analysis New.bqy | Y | Y | |||
Jan 09 | 10/17/2008 | 10023 | Changed the script for the RFM
(recency, freq, monetary) drop downs so that they are all populated upon
opening the report to make it more user friendly. |
RFM Analysis.bqy | Y | Y | |||
Jan 09 | 10/17/2008 | 14179 | Excluded stock balance (order header status = SR) and voided POS orders (order header status = VD). Corrected logic for the ship units, ship amount, and ship cost fields. | Demand vs Shipped Sales.bqy and Demand vs Shipped Sales NEW.bqy | Y | Y | |||
Jan 09 | 10/17/2008 | 13147 | Added/fixed Quick ship code
limit. Removed SHIPPED TAX FIN AMT and
SHIPPED PH FIN AMT tables, fields, and limits because that data is at a
different level of granularity from the rest of the tables and thus it can produce
incorrect results . Excluded stock
balance (order header status = SR) and voided POS orders (order header status
= VD). |
Item Summary Sales.bqy and Item Summary Sales NEW.bqy | Y | Y | |||
Jan 09 | 10/17/2008 | 14812 | Fixed link to 'Sales by Offer' when you are on the 'Sales by Style' dashboard. | Item Summary Sales NEW.bqy | Y | Y | |||
Jan 09 | 10/20/2008 | 14573 | Modified report to pull warehouse locations from the correct source. Removed SV_MACITM_ITEM_MAST_WH and added SV_MACITM_ITEM_POS_LOC (Assigned Warehouse Locations Cross-References). Limited results to "WLOC" entries. | Expected Weekly PO Receipts.bqy (Oracle & SQLServer versions) | Y | Y | |||
Jan 09 | 10/21/2008 | 14808 | Corrected section names in the script related to sort-by drop down box on Top X Dashboard | Item Demand Analysis.bqy and Item Demand Analysis NEW.bqy | Y | Y | |||
Jan 09 | 10/21/2008 | 14815 | Corrected section names in the script related to fiscal date selection criteria on the main Item Demand Selection Criteria Dashboard | Item Demand Analysis.bqy and Item Demand Analysis NEW.bqy | Y | Y | |||
Jan 09 | 10/21/2008 | 14816 | Corrected section name in the script related to fiscal date selection criteria on the main Selection Criteria Dashboard | Price Range Analysis.bqy | Y | Y | |||
Jan 09 | 10/23/2008 | 15012 | Set the Revision version on the dashboards with code in the OnStartUp script to make it easier to update in the future. Corrected logic in postProcess script to remove error when processing. Cleared limit values upon opening report. Added 'start' and 'end' prefix to variable date limits so the user is clear about which dates they are specifying when entering the selection criteria. Excluding Voided POS orders (Order Header status = VD) from the results. | Sales by Product ID Demand Fiscal - job.bqy (Oracle & SQLServer versions) | Y | Y | |||
Jan 09 | 10/23/2008 | 15013 | Set the Revision version on the
dashboards with code in the OnStartUp script to make it easier to update in
the future. Corrected logic in
postProcess script to remove error when processing. Cleared limit values upon
opening report. Added 'start' and 'end' prefix to variable date limits so the
user is clear about which dates they are specifying when entering the
selection criteria. Excluding Voided
POS orders (Order Header status = VD) from the results. |
Sales by Product ID Ship Fiscal - job.bqy (Oracle & SQLServer versions) | Y | Y | |||
Jan 09 | 10/23/2008 | 14612 | Changed data source for the report and pivot sections to come from the table section (which includes the unique limit). Set the Revision version on the dashboards with code in the OnStartUp script to make it easier to update in the future. | Expected Weekly PO Receipts.bqy (Oracle & SQLServer versions) | Y | Y | |||
Jan 09 | 10/27/2008 | 14338 | Fixed the item status selection criteria on the dashboard so that the limits are applied to the results. Set the Revision version on the dashboards with code in the OnStartUp script to make it easier to update in the future. | Item Summary Sales.bqy and Item Summary Sales NEW.bqy | Y | Y | |||
Jan 09 | 10/27/2008 | 14978 | Removed SHIPPED TAX FIN AMT and SHIPPED PH FIN AMT tables, fields, and limits because that data is at a different level of granularity from the rest of the tables and thus it can produce incorrect results. Set the Revision version on the dashboards with code in the OnStartUp script to make it easier to update in the future. Fixed the item status selection criteria on the dashboard so that the limits are applied to the results. | Net Product Sales Analysis.bqy and Net Product Sales Analysis NEW.bqy | Y | Y | |||
Jan 09 | 10/29/2008 | 14334 | Excluded "DP" (Drop ship) PO details. Excluded records that are not 'real receipts'. This is done by adding a computed item in Results to identify 'Real Receipts', adding a table and filtering it where Real Receipts = 'Y', then pointing the pivots against that table section.) Set the Revision version on the dashboards with code in the OnStartUp script to make it easier to update in the future. | Vendor Performance Analysis.bqy | Y | Y | |||
Jan 09 | 10/29/2008 | 14611 | Corrected filter criteria by date. (The date limit had accidentally been set to be ignored in the Returns append portion of the Order Details Query, so I set it to NOT be ignored.) | Net Product Sales Analysis NEW.bqy | Y | Y | |||
Jan 09 | 10/29/2008 | 14981 | Set the Revision version on the
dashboards with code in the OnStartUp script to make it easier to update in
the future. Removed the 'rtn auth ind' limit and added the limit: 'open RA ind' = 'Y' to select only OPEN RAs. |
Open Ras.bqy | Y | Y | |||
Jan 09 | 11/4/2008 | 14979 | Set the Revision version on the dashboards with code in the OnStartUp script to make it easier to update in the future. Combined Oracle and SQL Server versions of report into a single version by moving customer label from the query section to results section. Adding the following action search legacy codes which were missing from one or both of the query sections: AA (credit hold), CG (CC Declined, Expedite Order), and CY (Orders that have passed on-line authorization). | Open Orders by Item.bqy and Open Orders by Item - Job.bqy | Y | Y | |||
Jan 09 | 11/4/2008 | 14078 | Added cust_edp_id from derivable query to Orders Query results line to ensure start and end dates selection parameters filter the final results of the report. Set the Revision version on the dashboards with code in the OnStartUp script to make it easier to update in the future. | Repeat Buyer Analysis.bqy | Y | Y | |||
Jan 09 | 11/5/2008 | 14571 | Saved the file with no data in
the Closed AR results section to avoid confusion since it is used solely as a
derivable query and thus the report processing will not populate the results
with data. Set the Revision version on the dashboards with code in the OnStartUp script to make it easier to update in the future. |
Closed AR History.bqy | Y | Y | |||
Jan 09 | 11/14/2008 | 13780 | Excluded dollar coupon items (item status = TC) and gift certificate items (item status = TG) to avoid 'double counting' when the customer redeems the coupon or gift certificate. Set the Revision version on the dashboards with code in the OnStartUp script to make it easier to update in the future. Combined Oracle and SQL Server versions of report into a single version by moving computed items (customer (label), Sec Ctr, and full order no) from the query section to results section. | Sales by Product ID.bqy and Sales by Product ID Demand - Job.bqy and Sales by Product ID Ship - Job.bqy | Y | Y | |||
Jan 09 | 11/14/2008 | 13780 | Exclude dollar coupon and gift certificate items (item status <> 'TC','TG'). Combined Oracle and SQL Server versions of report into a single version by moving computed items (customer (label), Sec Ctr, and full order no) from the query section to results section. | Sales by Product ID Demand Fiscal - Job.bqy and Sales by Product ID Ship Fiscal - Job.bqy | Y | Y | |||
Jan 09 | 11/25/2008 | 14811 | Split the report into database versions because the process script adds a concatenation computed item to the query section. Also added a note at the bottom of the selection criteria dashboard explaining the meaning of the Orders field depending upon the user choosing to view demand versus shipped sales. | Item Summary Sales.bqy and Item Summary Sales NEW.bqy (Oracle & SQLServer versions) | Y | Y | |||
Jan 09 | 12/1/2008 | 15263 | Corrected database suffix to 'U' (for universal) on the revision date displayed at the bottom of the dashboards. Set the Revision version on the dashboards with code in the OnStartUp script to make it easier to update in the future. | Sales Revenue per catalog mailed.bqy | Y | Y | |||
Jan 09 | 12/1/2008 | 15264 | Corrected database suffix to 'U' (for universal) on the revision date displayed at the bottom of the dashboards. Set the Revision version on the dashboards with code in the OnStartUp script to make it easier to update in the future. | Sales Revenue per page.bqy | Y | Y | |||
Jan 09 | 12/8/2008 | 14436 | To ensure correct results, fixed
the limit for the returns query to use the itm_cd from the item_mast_2 table
for the returns query (instead of from the item_mast table for the order
details query). Set the Revision version on the dashboards with code in the OnStartUp script to make it easier to update in the future. |
Merchandise Performance Analysis.bqy and Merchandise Performance Analysis NEW.bqy | Y | Y | |||
Jan 09 | 12/8/2008 | 15306 | To ensure correct results, the following changes were made. Changed limits on the 2 Action Search Code limits to "Include Nulls". Added new parameter to fncGetStatus, passing Ord_Sta_Lgcy_Cd from "Overall Status" computed item. Then, checked this field if both Action Search values are null/blank. Included new status group variable in the function named "st_shipped" with the value "PC" as the one matching status code for "Shipped" status. | All Orders by Status.bqy | Y | Y | |||
Jan 09 | 12/8/2008 | 15209 | Added Inv_query2 to the Returns portion of the Query in order to calculate the units on hand when there are returns for the selected date range but no sales. | Item Summary Sales.bqy and Item Summary Sales NEW.bqy (Oracle & SQLServer versions) | Y | Y | |||
Jan 09 | 12/12/2008 | 15306 | To ensure correct results, the
following changes were made. Removed
the limits on the results section.
Removed "P7", "PN", "PS",
"PX", and "DS" from Hdr_Action_Srch_Lgcy_Cd limit. Created new computed item
"OrderLine" which is Order #, Ship-To #, Ship #, and Line #, all
concatenated. Add line # to sort in
results section. Created computed item
"DupeLineFlag", comparing OrderLine to Prior(OrderLine). Created computed item "Status
Priority" and sort on it. Value is: if there is a
Lvl_Action_Srch_Lgcy_Cd then 1, if there is a Hdr_Action_Srch_Lgcy_Cd then 2,
else 3. Created table section with all
fields from results section. Added
limit to table section for "DupeLineFlag" = "N". Changed all pivots, charts, and reports to
run off of table section instead of results section. |
All Orders by Status.bqy | Y | Y | |||
Jan 09 | 12/15/2008 | 15327 | Changed joins between the Customers table and the Customer Status and Customer Action table so that they are left joins (to ensure we get all appropriate Customers records). Moved the customer label and Sec Ctr field from the query section to results section, but cannot combine the Oracle and SQL Server versions of the report because of logic associated with the process button for shipments that must concatenate fields in the query section. Set the Revision version on the dashboards with code in the OnStartUp script to make it easier to update in the future. Changed the item status limit to go against the Item Master table to ensure the item status selection criteria on the dashboard limits the results. | Customer Summary Sales.bqy | Y | Y | |||
Jan 09 | 12/19/2008 | 15433 | Moved the telephone number type/role limit from the results section to the query section to prevent duplicate records for customers with multiple telephone numbers. | Aged Open AR.bqy | Y | Y | |||
Jan 09 | 12/19/2008 | 15432 | Incorrect table join to comp_div_master. Removed joins from comp_div_master to order_header. Join was added from comp_div_master and sv_macord_open_ar. | Aged Open AR.bqy | Y | Y | |||
Jan 09 | 12/19/2008 | 15389 | To ensure correct results, removed the unique field and table section with the unique limit. Set the Ref Itm No Cd limit to include nulls. | Expected Weekly PO Receipts.bqy (Oracle & SQLServer versions) | Y | Y | |||
Jan 09 | 12/19/2008 | 15391 | Removed extra table join from Receiving Staffing Requirements by Week. | Receiving Staff Requirements.bqy | Y | Y | |||
Jan 09 | 12/19/2008 | 15493 | Drilldowns not working correctly. Changed properties on each pivot dashboard to make active. | Sales versus returns analysis NEW.bqy | Y | Y | |||
Jan 09 | 12/19/2008 | 15524 | Limit/export section doesn't work under Firefox and Chrome. Fixed the issue. | Repeat Buyer Analysis.bqy | Y | Y | |||
Jan 09 | 12/24/2008 | 15412 | Corrected database suffix on dashboard revision dates to be U for universal. Set the Revision version on the dashboards with code in the OnStartUp script to make it easier to update in the future. | Offer PNL.bqy | Y | Y | |||
Jan 09 | 1/13/2009 | 15511 | Changed joins between order_header and customer_comp to simple joins. Excluded stock balance (order header status = SR) and voided POS orders (order header status = VD). Changed detail data query to use top x results. | Top X Customers.bqy | Y | Y | |||
Jan 09 | 1/20/2009 | 10870 | Add new query which track orders at the drop shipper | Drop-ship exception analysis.bqy | Y | Y | |||
Jan 09 | 1/21/2009 | 15563 | Rearranged text boxes on
dashboard so that part of the Taurus telephone number is not hidden. Moved the warehouse location in the pivot tables from the Facts to the Row Labels to prevent the pivot from attempting to total the warehouse location values. |
Pick Velocity | Y | Y | |||
Jan 09 | 1/22/2009 | 15572 | Changed font back to Arial to make it consistent with other reports. | Sales versus returns analysis NEW | Y | Y | |||
Jan 09 | 15558 |