Release |
Date |
Case Number |
Description of Change |
Affected BQY File |
Affected SQL Server Version? |
Affected Oracle Version? |
May 11 |
6/4/2010 |
18821 |
Correct the logic that groups
Order levels that have a status of "In the Warehouse" |
All Orders by Status.bqy |
Y |
Y |
May 11 |
6/4/2010 |
18822 |
Changed the column header of the
2nd fact column from "Order Level Count" to "Pct of Order
Levels" |
All Orders by Status.bqy |
Y |
Y |
May 11 |
8/17/2010 |
19306 |
Modified query to use the base
table name on SV_MACITM_VENDOR_ITEMS instead of the numbered version |
Back orders.bqy |
Y |
Y |
May 11 |
12/17/2010 |
15692 |
Added Adjustment Reason Code
filter to the selection criteria dashboard |
Inventory Adjustments.bqy |
Y |
Y |
May 11 |
12/17/2010 |
19885 |
Added Adjustment Reason description to pivots/reports |
Inventory Adjustments.bqy |
Y |
Y |
May 11 |
12/17/2010 |
20031 |
Moved the Vendor Preference
Limit from the query to the results section and added Include Nulls |
Inventory Adjustments.bqy |
Y |
Y |
May 11 |
12/17/2010 |
20043 |
Updated all fields in the query
request lines to use business names (metadata) instead of table column names |
Inventory Adjustments.bqy |
Y |
Y |
May 11 |
12/17/2010 |
20053 |
Added ability to sort reports at
the group level based on the field in the group and by Item number at the
detail level. Adjustments by Reason / User reports sorted by Transaction
Date. |
Inventory Adjustments.bqy |
Y |
Y |
May 11 |
1/4/2011 |
15673 |
Corrected a logic bug that was
preventing dashboard filter values from being applied to query limits.
Standardized the formatting of dollar, date and amount fields |
Aged Open AR.bqy |
Y |
Y |
May 11 |
1/4/2011 |
18563 |
Add a filter to the main
dashboard that allows entry of customer numbers |
Aged Open AR.bqy |
Y |
Y |
May 11 |
1/4/2011 |
19551 |
Corrected a logic bug that was
preventing the correct age range title from being calculated for the age
group |
Aged Open AR.bqy |
Y |
Y |
May 11 |
1/4/2011 |
19552 |
Updated limit on AR_STAT to be
consistent with Ecometry's values of Open and Partially Open |
Aged Open AR.bqy |
Y |
Y |
May 11 |
1/4/2011 |
19751 |
Updated the formula that
determines the age of the receivable to use the due date if present,
otherwise use the transaction date. |
Aged Open AR.bqy |
Y |
Y |
May 11 |
1/4/2011 |
19911 |
Add a filter to the main
dashboard that allows entry of transaction type |
Aged Open AR.bqy |
Y |
Y |
May 11 |
1/4/2011 |
20064 |
Updated all fields in the query
request lines to use business names (metadata) instead of table column names |
Aged Open AR.bqy |
Y |
Y |
May 11 |
1/4/2011 |
16243 |
Added limit to query to exclude
price adjustments (codes M, P) |
Item Summary Sales NEW.bqy |
Y |
Y |
May 11 |
1/4/2011 |
16268 |
Added vendor data into query |
Item Summary Sales NEW.bqy |
Y |
Y |
May 11 |
1/4/2011 |
17178 |
Modified the OPEN RA limit to
include null values |
Item Summary Sales NEW.bqy |
Y |
Y |
May 11 |
1/4/2011 |
18199 |
Updated all fields in the query
request lines to use business names (metadata) instead of table column names |
Item Summary Sales NEW.bqy |
Y |
Y |
May 11 |
1/28/2011 |
20176 |
Add new query
to EAS |
Top X Sales Analysis.bqy |
Y |
Y |
May 11 |
2/17/2011 |
16889 |
Updated the names of the Pivot
tables and their related dashboards to match eachother. Added a new Dashboard
for Pivot by Pay Method and navigation command buttons to access it from the
other dashboards |
Aged Orders in the Warehouse.bqy |
Y |
Y |
May 11 |
2/17/2011 |
18016 |
Updated the Ship method bar
chart so that each Pay Method / Ship Method bar group is a different color |
Aged Orders in the Warehouse.bqy |
Y |
Y |
May 11 |
2/17/2011 |
18046 |
Updated left side labels in the
Pivots by Ship Method and Age to show the correct default labels |
Aged Orders in the Warehouse.bqy |
Y |
Y |
May 11 |
2/17/2011 |
18406 |
Updated the Age Category ranges
to be < 2 Days, 2 – 3 Days, 4 – 5 Days, 5 – 7 Days, and > 7 Days |
Aged Orders in the Warehouse.bqy |
Y |
Y |
May 11 |
2/17/2011 |
18702 |
Updated formula that calculates
warehouse value in Combined Results to properly extract and build the correct
two digits |
Aged Orders in the Warehouse.bqy |
Y |
Y |
May 11 |
2/24/2011 |
13781 |
Update the Query Summary
Documentation to further explain why Cost of goods are overstated when kit
components are included and provide an example |
Sales by Product ID Query
Summary Document |
Y |
Y |
May 11 |
2/24/2011 |
16145 |
Remove Continuity Line Code from
limit from Ship versions of JOB to make it consistent with ad-hoc version of
query |
Sales by Product ID Ship
Job.bqy, Sales by Product ID Ship Fiscal Job.bqy |
Y |
Y |
May 11 |
2/24/2011 |
16335 |
Update Query Summary
Documentation to further explain where reported numbers match Ecometry values |
Sales by Product ID Query
Summary Document |
Y |
Y |
May 11 |
2/24/2011 |
19894 |
Enhance criteria selection on
item number to enter multiple item number values separated by commas |
Sales by Product ID.bqy |
Y |
Y |
May 11 |
2/24/2011 |
20590 |
Change coding script on Export
This Pivot command buttons so they work in a web environment |
Sales by Product ID.bqy |
Y |
Y |
May 11 |
2/28/2011 |
11515 |
Add new query
to EAS |
Cancellation Analysis.bqy |
Y |
Y |
May 11 |
2/28/2011 |
20609 |
Modified query to make
pivot tables active in web environment |
Cancellation Analysis.bqy |
Y |
Y |
May 11 |
2/28/2011 |
20610 |
Modify query to retain database
logon information across multiple clicks of the Process Query command button. |
Cancellation Analysis.bqy |
Y |
Y |
May 11 |
3/14/2011 |
16240 |
Added limit to query to exclude
price adjustments (codes M, P) |
Net Product Sales Analysis
NEW.bqy |
Y |
Y |
May 11 |
3/14/2011 |
19930 |
Add product
category descriptions to query. Added the Major
Category description as a default left-side label to the Sales by Category
pivot. |
Net Product Sales Analysis
NEW.bqy |
Y |
Y |
May 11 |
3/14/2011 |
20320 |
Add capability to specify
customer numbers on the selection criteria dashboard and limit query results
to those specified. |
Net Product Sales Analysis
NEW.bqy |
Y |
Y |
May 11 |
3/14/2011 |
20664 |
Modify query to sort contents of
item status list box main dashboard. Populate list box with values from Item
Type Codes instead of Item Master so they are present when metadata is
missing |
Net Product Sales Analysis
NEW.bqy |
Y |
Y |
May 11 |
4/6/2011 |
18043 |
Modified query to make
pivot tables active in web environment |
Inventory Position Analysis.bqy |
Y |
Y |
May 11 |
4/6/2011 |
19940 |
Add vendor number, vendor
name,vendor item number to the item query section |
Inventory Position Analysis.bqy |
Y |
Y |
May 11 |
4/7/2011 |
16241 |
Added limit to query to exclude
price adjustments (codes M, P) |
Item Demand Analysis NEW.bqy |
Y |
Y |
May 11 |
4/7/2011 |
19929 |
Updated query to add vendor
number to dashboard selection criteria and add vendor item number to query so
users can drill down to it. Updated query to use business names (metadata)
instead of table column names. |
Item Demand Analysis NEW.bqy |
Y |
Y |
May 11 |
4/7/2011 |
20181 |
Modified query to have Top X
radio buttons to point to the Item Demand Analysis Selection Criteria
Dashboard instead of the Performance Activity dashboard. |
Item Demand Analysis NEW.bqy |
Y |
Y |
May 11 |
4/7/2011 |
20197 |
Modified query to display the
correct names for the Major, Minor, Sub Major and Sub Minor category
descriptions |
Item Demand Analysis NEW.bqy |
Y |
Y |
May 11 |
4/7/2011 |
20198 |
Updated Top X Items command
button to navigate to the Vendor Dashboard and changed the name of the vendor
dashboard to Analysis by Vendor |
Item Demand Analysis NEW.bqy |
Y |
Y |
May 11 |
4/7/2011 |
20199 |
Changed the sort dropdown on the
Vendor Dashboard to sort by vendor and not item number |
Item Demand Analysis NEW.bqy |
Y |
Y |
May 11 |
4/7/2011 |
20821 |
Fix Selection Criteria command
button on the Offer Dashboard to branch to the main dashboard when clicked. |
Item Demand Analysis NEW.bqy |
Y |
Y |
|
|
|
|
|
|
|