Taurus Software
Measures for Distributors
9/10/2015
| File Name | Change Date | Case Number | Description | Affected Field |
| Measures for Distributors.xls | 4/20/2015 | 27589 | Change logo text to "Measures for Distributors" on dashboard sections | Invoiced Sales Analysis.bqy Invoiced Sales Analysis - Job.bqy |
| Measures for Distributors.xls | 6/10/2015 | 27585 | Add rebate amount into query. Show Rebate Amount, Margin Dollars Including Rebates, Margin % Including Rebates in pivots. Add filter for Order Rebate Amount and Rebate Amount | Invoiced Sales Analysis.bqy Invoiced Sales Analysis - Job.bqy |
| Measures for Distributors.xls | 6/12/2015 | 27585 | Add rebate amount into query. Show Rebate Amount in pivots. Add filter for Order Rebate Amount and Rebate Amount | Sales Analysis.bqy Sales Analysis - Job.bqy |
| Measures for Distributors.xls | 6/10/2015 | 27728 | Correct joins between Order Line Items and Product Master in OnPreProcess scripting | Invoiced Sales Analysis - Job.bqy |
| Measures for Distributors.xls | 6/12/2015 | 27729 | Correct joins between Order Line Items and Product Master in OnPreProcess scripting | Sales Analysis - Job.bqy |
| Measures for Distributors.xls | 7/6/2015 | 27585 | Add Ordered Margin Dollars Including Rebates, Ordered Margin % Including Rebates, and Ordered Margin % to all pivots | Sales Analysis.bqy Sales Analysis - Job.bqy |
| Measures for Distributors.xls | 7/6/2015 | 27792 | Change bars in charts to show Ordered values instead of Shipped | Sales Analysis.bqy Sales Analysis - Job.bqy |
| Measures for Distributors.xls | 7/28/2015 | 27815 | Margin dollars and percents don't match SMRS. Correct calculation of both Rebate Amount and Cost of Goods | Invoiced Sales Analysis.bqy Invoiced Sales Analysis - Job.bqy |
| Measures for Distributors.xls | 7/28/2015 | 27816 | Orders were missing when query was run for specific category. Change query so category codes are related to order line items instead of to product master. This accommodates non-stock products which have no category on the Product Master, but which have ca | Invoiced Sales Analysis.bqy Invoiced Sales Analysis - Job.bqy |
| Measures for Distributors.xls | 7/28/2015 | 27818 | Query was picking up line items with zero in the shipped quantity field. These entries are now bypassed by the query | Invoiced Sales Analysis.bqy Invoiced Sales Analysis - Job.bqy |
| Measures for Distributors.xls | 7/29/2015 | 27824 | Margin dollars and percents don't match SMRS. Correct calculation of both Rebate Amount and Cost of Goods | Sales Analysis.bqy Sales Analysis - Job.bqy |
| Measures for Distributors.xls | 7/29/2015 | 27823 | Orders were missing when query was run for specific category. Change query so category codes are related to order line items instead of to product master. This accommodates non-stock products which have no category on the Product Master, but which have ca | Sales Analysis.bqy Sales Analysis - Job.bqy |
| Measures for Distributors.xls | 8/19/2015 | 27827 | Make changes to account for whole order discounts: - Product Dollars is now undiscounted value - Discount Amount now includes regular plus whole order discounts - New field - Net Product Dollars --> Product Dollars - Discount Amount - Change Margin Dollar | Invoiced Sales Analysis.bqy Invoiced Sales Analysis - Job.bqy |
| Measures for Distributors.xls | 9/1/2015 | 27827 | Additional changes to correct variances between Invoiced Sales Analysis and the SMRS sales report: - add filter on both rebate sections to exclude canceled rebate entries - add filter to main query section to exclude canceled order line items - change | Invoiced Sales Analysis.bqy Invoiced Sales Analysis - Job.bqy |