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/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.bqy |
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 |
|
Add Merchandise Performance
Analysis query |
Merchandise Performance Analysis.bqy |
Y |
Y |
10/9/2006 |
|
Add Price Range Analysis query |
Price Range Analysis.bqy |
Y |
Y |
10/9/2006 |
|
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 |
|
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.bqy |
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 |
1/31/2007 |
|
Changed date field names to
Debit Trans Dt and Credit Trans Dt |
Closed AR History.bqy |
Y |
Y |
1/31/2007 |
|
Activated pivot table on
dashboard |
Open RAs.bqy |
Y |
Y |
1/31/2007 |
|
Initial Query |
GL Trans.bqy |
Y |
Y |
1/31/2007 |
9540 |
Updated link for Item
Listing.bqy |
Ecomedate Menu Dashboard.bqy |
Y |
Y |
1/31/2007 |
9541 |
Changed company / division
select criteria process |
Item Listing.bqy |
Y |
Y |
1/31/2007 |
8691 |
Initial Query |
Un-Shipped Orders by Status.bqy |
Y |
Y |
1/31/2007 |
|
Change PNL labels to P&L |
Offer PNL.bqy |
Y |
Y |
|
|
|
|
|
|