Product Release Notes

82571

EDI Receiving states there are missing vendor parts - Modified logic to use string list instead of entity/linq

82855

Issue with progress bar when sending updates from the queue - Resolved progress bar error

65697

Enhancement request to show what happened to a suspended sale – created suspended sales report

67406

Enhancement – auto add back ordered Items to orders - Added new setting to auto add Back Order Items to new orders

80414

Pricing and cost corrections/Cost

37960

Enhancement Request for Format 6 to utilize vendor part kits - Updated EDI format 6 to check if item is a vendor part kit

37919

Enhancement request - Filter by manufacturer needs to show products – report campaign items show all items for active campaigns

79055

Transfer amounts at Store not matching the Transfer amount at Corporate - Added popup when an item is already on the adjustment that asks user if they want to add the new qty to existing value or to replace the value

38628

POS flags flip at the store when sent down from corporate – updated webservice and POS schema to address the issue

78615

Cash Discounting on Pricing Labels - Updated Director, FasTraxLabelPrinter, and POS with option to print Cash and non-Cash prices

78512

Add vendor parts as option in the barcode / shelf label report – added vendor part to the drop down list

39109

Maintain Sort order on Invoice Worksheets - Updated logic to maintain sort order and selected item.

84654

Scheduled Order "Refresh QOH Before Processing" checkbox not updating. - Updated logic to make the option default off.

82883

Loyalty Discount Results Report Issue - Updated report.

82492

Add a search function to search by gift card number on Current Gift Cards tab - Added search option.

80797

Have EDI status change to sent if it is marked sent at the store - Update logic to update EDI send status at corp when sent at the store.

80680

Loyalty save reverts search - Updated logic to save the search.

71518

EPA Reports - Updated footer to include type and store info.

84481

Gift Card Enhancements to show all cards - Updated logic

80555

Push Zebra formats down to all the stores - Update logic when creating a new format in corp mode, adds to queue to send to stores.

75174

Round down to 99 - Added new option to round up or down to .99 based on .50

76512

New Discount Type to Discount Subtotal - Added new discount type "Buy x Get y $ off".

77527

Created new report for used loyalty coupons.

37700

Uplift Report Capability w/ transaction details - Added PLU number to details report.

37878

Option to default receiving items to UPC instead of Vendor Part - Added no setting that will default to the UPC field, and remove the verify part number popup.

68371

Additional records or verification of scheduled queue - Created new report that Compares Corp verses Store prices and cost for each item.

82853

Flag Manuf Loyalty as MP setting is no longer saving when you run the report - Updated to default the setting.

37625

Changing Pricebook Zone at Corp does not update Store - Updated logic to send pricing records

38820

Add order PLU for vendor part kits - Added new setting to enable the user to enter a PLU associated with a vendor part kit. As well as adding the field to the vendor part kit screen.

78740

Resolved issue where sales history module was not showing

73572

Resolved issue where Inventory Evaluation report was not showing items with 0 quantity on hand

78933

Resolved issue where mass changing discount altria type resulted in an error

71490

Resolved issue where Invoice Summary Report was not calculating surcharge and misc. fees correctly

79296

Resolved issue of System Discount report reaching limitation of number of stores that can be selected

38207

Created new report to compare pricing between corporate and store

74391

Resolved issue with UPC History Tool timing out

79819

Adding setting to remove 0 qty items from EDI orders

80066

Resolved issue of Summary Data report requesting filter string and reg Z

37917

Merging Customers in Enhanced Loyalty – updated logic so customer’s sales history is merged

68897

Column error when running Enhanced Loyalty Report - Increased field data type from int16 to int64

73572

Not showing 0 qty items in inventory evaluation report – updated logic on the report

69730

Lotto games are sending through queue, but not showing up at store level - Updated logic to resolve issue.

74945

Mass updates discount filter showing same price on each price zone - Updated mass updates to resolve issue

74482

Updated logic to add invoices to the queue if there is an error when attempting to connect to store webservice

71501

Updated logic to correct issue of POS Flags flipping when sending down from corporate

71501

Updated logic for custom filter on cycle counts

74306

Updated logic to prevent the user from creating a PLU with a space in it.

71926

Updated logic to add adjustment notes to show on the report

71915

Error when switching between parent and child in director. Added a wait cursor while loading info.

69994

Updated e-journal report to show receipt footer

75156

Resolved time zone issue when adding sales restrictions to queue

68378

Updated logic to check corp if invoice number already exists when starting an invoice

61396

loyalty phone number needed when updating customer in Director - Updated logic to resolve issue.
- Added EDI order format 29 for Oregon Liqour (OLCC)
- Added ability to filter by class and sub class in inventory evaluation report
- Added ability to start online transfer when in store mode
- Added logic to update last cost in addition to avg on adjustments
- Resolved issue w/ GL export for WH invoices when invoice only has a single return item
- Minor fixes and improvements

71331

Add Filter by discount to Item Summary report

69965/70031

Resolved issue with user group permission (groups needing permission to delete invoices will need to be updated/saved)

70306

updated formatting to resolve issue with system discount date sort

69641

Resolved issue with department sales report not sorting correctly

71441

Updated logic to resolve issue of favorite reports not "opening" when you click "open"

70800

Updated logic to resolve issue of deleting a discount when not in corp mode

71625

Added logic to validate setting to update min/max from corp when it is set to no, so it does not send from corporate queue

71303

Update logic to resolve issue of employee still showing at store level when marked inactive

67005

"Added the ability to be able to enter two or more codes on PM scan data; Updated scan data report to use "NameInRetailReport" field"

37663

"Add ability to filter Archived Buydowns by Buydown Groups"

68864

"Add new permission for the ability to run the retail scan data reports"

37709

"Updated all the item sales reports to repeat group header on each page"

37845

"Updated 12-week cigarette report to show rollup values when selected"

37892

"Updated dataset to use average cost on the inventory evaluation and inventory cost reports"

37927

"Added the ability in mass updates to sort by discount name"

38000

"Updated logic that was preventing deleting from queue when using "Delete All" and the "Delete Mine" option"

38068

"Updated House Accounts Reports to get tax exempt sales from the Reg_Sale table"

69125

"Resolved some formatting issues for the RJR scan data report"

37539

"Updated the Mass Change Tool in Pricing Exceptions to fix error when adding a store to multiple pricing exceptions at once."

37562

"Resolved issue when generating orders was skipping some of the selected manufacturers when filtered"

37627

"Updated logic so excise tax for return items on invoices will also be negative."

69797

"Updated logic for control center URL migration"

37943

"Add option to switch between parent and child items in adjustments"

60810

"Update logic to disable filter type when "Reorder Using A Blank Order Form" is selecte,Resolved EDI reorder format 24 sample file"

65094

"Revamp PLU snapshots to only create snapshots for items when the quantity on hand has changed since the last time snapshots were taken"

66052

"Resolved issue with PM scan data and loyalty coupon amount"

v1.398.96

"Resolved issue w/ more than 9 PB zones and setting pricebookID"

v1.398.95

"Mass Updates - updated UI to retain filter by selection when changing the PB zone,Item Details - added Zone name to Change History popu,Buydowns - corrected an issue that reset to the top of the buydown list after a buydown was saved"

v1.398.94

"Pricebook Zones - corrected Pricebook ID field to pad current IDs with zeros to help with sortin,Receiving - added logic to handle NC Excise tax rules "

v1.398.93

"Pricebook Zones - added Pricebook ID to pricebook zones to allow custom sorting of zone,Discounts - added support for Discount Set,Mass Updates - changed Mass Updates screen to keep filters after changes are made"

v1.398.92

"Altria Scan Data - added capabilities to add more Loyalty UPCs for Skoal, Copenhagen, L&M, and ON! brands"

v1.398.91

"Spot Checks - updated Spot Check report to use item costs from adjustlog if there is one recorded"

v1.398.90

"Altria Scan Data - added capabilities to add more Loyalty UPCs for PM brand"

v1.398.89

"Ticket #384613 - Windows Handheld removing items in invoice - Updated logic to prevent double appending the store number to invoice number,Scheduled changes - corrected an issue where scheduling a cost change would instead change the cost immediately"

v1.398.88

"Orders - corrected an issue where the system wasn't saving changes to column order on the Order Workshee,Buydowns - corrected an issue that prevented filtering by buydown groups in some instances"

v1.398.87

"EDI invoices - Added option to get invoice # from file when using format 7"

v1.398.86

"Scheduled Cost Changes - corrected an issue that caused scheduled cost changes to affect the cost immediatel,Orders - corrected an issue that allowed the "Generate Order" button to be clicked multiple times, creating duplicate orders"

v1.398.85

"Added return count, return value, no sale count to performance dashboard gri,Resolved issue with excluding returns on buydown sales repor,Resolved issue with scheduling zero priced items report"

v1.398.84

"Made loyalty free item report more effecient"

v1.398.83

"Item Sales Report - Resolved issue with QOH in legacy item sales when rolling up links"

v1.398.82

"Discounts - resolveed an issue that prevented saving of Discount Items from the "Manage Items in Discount" popup"

v1.398.81

"Reports - updated a header on a custom report"

v1.398.80

"Altria loyalty club - Added sanity check when creating loyalty club discount; to prevent discounts from being configured incorrectly,Discounts - Resolved issue when creating new discount showing erroneous message if filter type wasn't all items"

v1.398.78

"Per customer request, Removed logic that subtracted payins from deposit in GL expor,Fixed issue with queue and plu_changes records"

v1.398.77

"G/L Export - Added logic to handle negative after subtracting payin from safe"

v1.398.76

"Added Altria 2022 reporting requirements (checkbox to enable when running report)"

v1.398.75

"Added logic to not allow scheduled reports to run more than once per session"

v1.398.74

"Utility To Compare Prices Between Corporate And All Stores - Added logic to handle 3 decimal places in cost"

v1.398.73

"Reorders - corrected an issue that caused the QoH reorder point on individual items to be ignored in favor of the department level settin,Schedules - corrected an error message when adding schedule settings to the queue"

v1.398.72

"GL Export - Merged in logic to allow transfer holding codes for each store instead of global"

v1.398.71

"Returns Worksheets - added the ability to send returns worksheets settings to the store,Mass Updates - Added a filter for items not eligible for discounts"

v1.398.70

"Mass Updates - corrected an issue that cause the Mass Updates grid to show incorrect pricing in some rare instances"

v1.398.69

"EDI Orders - Added alternate naming setting for Order Format ,Mass Updates - fixed an issue that caused some buttons not to be visible on lower resolution,Favorite Reports - corrected an issue that caused selected departments not to save for some report type,Mass Updtaes - corrected an issue where Mass Updates would display the incorrect prices for items in some instance,Inventory Evaluation Report - Resolved page break issu,Item Sales Report - Resolved issue that caused this report to show incorrect quantities on hand in some instances"

v1.398.68

"Returns Worksheets - Added sellable status to EDI file for FasTrax Warehouse"

v1.398.67

"Mass Updates - added the ability to filter by Alias"

v1.398.66

"Utility To Compare Prices Between Corporate And All Stores - Updated utility to handle price exceptions"

v1.398.65

"New Utility - Added utility to compare corp and stores pricing and display in grid or file"

v1.398.64

"Phillip Morris USA (PM USA) Loyalty Plus Offers - Resolved queue dupe check issue"

v1.398.63

"Phillip Morris USA (PM USA) Loyalty Plus Offers - Added schema changes for queue"

v1.398.62

"L&M Loyalty CodeFixed issue with L & M code not correctly populating in some instance,Phillip Morris USA (PM USA) Loyalty Plus Offers - Fixed issue with queue logic"

v1.398.61

"Scan Data Report - Updated logic to write 0 line if price is 0 because of coupon"

v1.398.59

"Item Sales Report - corrected an issue where the "exclude returns" option did not function when filtering by vendor"

v1.398.58

"ITem Sales Report - corrected an issue where this report would not group by Subgroup when that option was selecte,Item Sales Report - resolved an error message that prevented this report from running when filtered by Margi,Item Sales Report - resolved an error message that prevented this report from running when filtered by day of the week"

v1.398.57

"Item Sales Report - Added an option to the Item Sales to exclude returns"

v1.398.56

"System Discounts - Added support for Loyalty Plus discounts from Altria"

v1.398.55

"System Discounts Report - Added option when running system discounts report to not scrub return data"

v1.398.54

"Rabbit MQ - corrected an issue with certain types of queue records sending through RabbitMQ"

v1.398.53

"Scan Data - corrected an issue with the L&M loyalty code implementation"

v1.398.52

"Scan Data - added support for L&M loyalty code to Altria Scan Data report"

v1.398.51

"Queue - Resolved an issue that was causing permissions to send individually for all users in a group rather than sending group permission,Inventory Eval Report - Resolved an issue with this report not taking into account items can belong to more than one buydown"

v1.398.50

"Employees - corrected an issue where some permissions were not saving correctly on new employees"

v1.398.49

"Queue - Corrected an issue when sending large updates through the queue that prevented the records from properly flagging a sent"

v1.398.48

"Experimental Reporting - corrected an issue with the quantity on hand being incorrect when experimental reporting is enable,Item Sales Report - Corrected an issue that caused quantity on hand to show blank in some instances"

v1.398.47

"Receiving - Added a new setting to Auto Queue cost changes when applying invoice,EDI Orders - Added an option to EDI Order Format 5 to create the file with only the PO number as the filename"

v1.398.46

"GL Export - corrected an issue that caused PayIns to subtract from the Safe deposit repeatedly in some cases"

v1.398.44

"Updated item details logic when applying from template to log template changes and better prompt user of actions being taken"

v1.398.43

" Corrected issues found during testing"

v1.398.42

"PM Scan Data - added a setting to flip the multipack flag for Manufacturer Loyalty Discount,Queue - corrected an issue that prevented large numbers of employee permissions from sending to store,Orders - corrected an issue that prevented an order from sending through EDI if a Vendor Part Kit was on the orde,Suspended Sales Report - (Enhancement) Report for all suspended sales - Added Suspended Sales to Sales Reports"

v1.398.41

"Vendor Part Kit - corrected an issue that would allow a user to create a new kit with no item,Invoices - added an option to automatically append date to an invoice number for use when vendors are reusing invoice number,System Discounts - Added filter by name feature to discounts user control."

v1.398.40

"PM Scan Data - Added ability to add PM scan data loyalty codes to multiple stores,Fuel Sales Report - Added Filter by Sale Type to Fuel Sales Report,Commission Report - added a "Details" option to this repor,Item Sales Report - corrected an issue that caused a duplicate error when filtering by vendor in some case,Negative Cashier Report - Added an option to run a summary version of this repor,Employee Scheduler - corrected an issue that caused time to be displayed in 24h format in some area,Invoices - Added an option to group printed invoices by departmen,System Discounts - updated discounts to prevent multiple discounts from having the same nam,Director Permissions - added new permission to allow/disallow deletion of time clock entries"

v1.398.39

"GL Export - Updated GL Export logic to handle Pay-Ins correctly"

v1.398.38

"EPA Report - Added Allowable Variance Formula To EPA Repor,Buydown Sales Report - Added Option To Exclude Returns"

v1.398.37

"Department Sales Report - Updated department sales group by department to show details"

v1.398.36

"EDI settings - corrected an issue that prevented EDI settings from sending to store,Cycle Counts - updated Cylce Count Reports to show store number even if there is no other data presen,Undo Changes Utility - fixed sort order to show/undo changes from newest to oldest"

v1.398.35

"Reports - Dept Sales Report - Added ability to filter by department when grouping by department group"

v1.398.34

"Discounts - corrected an issue that prevented a discount from being properly deleted from a store after the store was removed from the discount"

v1.398.33

"Vendor Part Kits - corrected an issue that caused costs not to update correctly in some instances"

v1.398.32

"Item Sales Report - Updated reports to use SUM of QOH,Added access to legacy item & dept sales reports when experimental reporting is enabled."

v1.398.31

"E-Journal Report - Added the last 4 digits of the credit card to the e-journal report."

v1.398.30

"Vendor Part Kits - Updated logic to resolve calculation issues."

v1.398.29

"Item Sales report - Update QOH logic to only populate 1 record per upc/store"

v1.398.28

"Scan Data Report - Updated negative coupon amount on returns to show correctly on RJR scan data report."

v1.398.27

"Scan Data Report - Added a popup for the user to select filter when listboxes are not visible for departments.,EDI - Added option for PO EDI format 10 to only have the PO number in the title,Orders - Updated logic to include the Added Date,EDI REturns - Update logic when return to disregard the Do Not Order status,ADs - Updated logic to fix issue with Ads campaigns printing incorrectly,Tax Rates - Added checkbox to indicate if the tax is tiered,Reports - Updated logic to resolve issue with filtering by "Report Group 3",Price Exceptions - Updated logic to resolve issue."

v1.398.26

"Pricebook Zones - Updated changelog text when saving for selected zones."

v1.398.25

"Scan Data Report - Updated logic to format with 2 decimals when writing to RJR scan data file."

v1.398.24

"Retail Scan Data Report - Added ability to set codes per store for new UST loyalty program,Sales Tax Report - Updated sorting to sort correctly on additional pages,Invoice Report - Updated logic to only display for selected stores."

v1.398.23

"Reorders - Resolved union issue with item find utility."

v1.398.22

"Scan Data Report - Resolved issue with divisors in report,Reorders - Updated the dataset to fix issue with item find utility,EDI Returns - Updated logic when sending EDI to check for negative quantity before checking if the item is Do Not Order."

v1.398.21

"Discounts - Updated logic when queue item setting is false."

v1.398.20

"Scan Data Reports - Updated the ITG and RJR report dividing the coupon amount by the quantity,Sales Reports Using SQLKata - Added option to run (Department Sales Report and Item Sales Report) reports using summary formats,Daily Reconciliation Report - Updated reports to correct error with starting till,Register Z Report - Corrected the store coupon amounts on reports."

v1.398.19

"Discounts - Fixed issue with discount item using template reference PLU when setting to send discount items is enabled and applying template."

v1.398.18

"Queue - Added setting to queue discount items."

v1.398.17

"Queue - Added sanity check when adding discounts to queue."

v1.398.16

"Orders - Fixed issue with CheckOrderForDoNotOrderItems loop."

v1.398.15

"Sales Tax Report - Added logic to handle standalone mode."

v1.398.14

"Dashboard Performance Report - Updated to display report correctly."

v1.398.13

"Updated parameters in invoice detail report."

v1.398.12

"Added debug log when printing invoice report."

v1.398.11

"GP Accounting Export - Added schema changes to make sure columns are displayed correctly,Item Sales Report - Updated script logic for the report to make sure all items show when filtering by Vendor,Orders - Added logic to highlight description of items in yellow if the system recommends >0,Discounts - Added logic to queue discount when updating item or trigger items,Pricebook Zones - Added logic to refresh price/cost after opening all zones popup."

v1.398.10

"Orders - Added logic when sending orders or converting working orders to check each item's active status,Mass Updates - Added logic to item details to discounts popup."

v1.398.9

"Item Sales Summary Report - Fixed query pulling incorrect data,GL Balances Tool - Added option to validate data when exporting and notify user of errors,Mass Updates - Updated logic when making price/cost changes in corporate mode."

v1.398.8

"Orders - Updated filters and logic flow"

v1.398.7

"Item Sales Report - Updated report parameters."

v1.398.6

"House Account - Fixed query when pulling taxes for house account invoices and e-journal report."

v1.398.5

"Mass Updates - Updated logic to round to 2 decimal places when necessary."

v1.398.4

"Updated inventory eval and item sales report queries to not use function when filtering,Cycle Counts - Added logic to adjust costs when opening the cycle count."

v1.398.3

"HLA EDI - New enumeration ("Store-Acct Num") added for "Format 5" to retrieve files having "Account Number" in the filename,Users - Updated logic when updating user group handheld permissions to apply to user immediately, updated permissions,Scan Data Report - Added space between header address and value for MSA report,Scheduler - Updated to handle stores/employees past midnight,Scan Data Report - Updated report to use the different tree options to filter report,Stores - Added ability to send accounting codes through the queue,Negative Item Report - Added cost option to report,Copy Invoice Rev Qty - Added invoice date to copy invoice functionality,System Discount - Updated logic when looking for priority numbers,Daily Reconciliation Report - Updated report to give correct values,Working Orders - Updated logic for copying schedules,Loyalty - Added ability to add special characters and notes to customers,Orders - Updated reports for orders to show more details for item description column,Item Movement - Added new permission and new tab in Inventory to unapply movements,Sales Tax Report - Updated logic for report to query the store for tax name and rates,Loyalty Coupons - Added default field settings to prevent coupons from not being pulled correctly on sale,Customer Activity Report - Updated logic to resolve issue,Vendors - Added ability to merge Vendors in User Support Utilities,Reports - Updated logic to allow switching between Director and reports,Pricebook - Updated caption to setting pricebook color scheme,Orders - Added logic to check for do not order flag before sending EDI and converting from working order to order,Summary Reports- Refactored QOH to not get data unless needed,Queue Report - Cleaned up logic to run in corporate mode,Merged release version with previous patch version. "

v1.398.2

"Queue - Update queue logic,Retail Scan Data - Added ON! Loyalty UPC field to report,Updated item details screen, moved the link info to show the vendor part grid in small screens"

v1.398.1

"Dashboard Report - Addressed to be more user friendly when running,Item Templates - Updated logic to allow item templates to queue correctly with discounts and buydowns,Database - Added Summary Data Tables to schema changes,Vendors - Updated logic to make sure the store info is completely added to database so store updates in queue can be sent down to stores,Dept Sales Report - Updated logic to allow for grouping by department,Summary Data Reports - Updated logic to allow multi select,Invoice Detail Report - Updated report to pull data correctly when searching by vendor or invoice number,System Discounts - Updated logic to resolve issue with user priortiy,Scan Data Report - Updated logic to remove returns that have a price of 0,Item Sales Report - Updated reports to show QOH as a decimal value,Director - Updated logic to allow switching back to director in taskbar,Queue - Update the queue PLU changes to use chunks,Loyalty Reports - Update logic to resolve issue with mismatching reports,Enhanced Loyalty - Updated log for campaign losing points to show the negative amount that was moved. Also changed logic to add points to the receiving campaign before deducting the points from losing campaign,Vendor Part Kits - Updated logic to resolve duplications when adding items,Uplift Reports - Updated report to resolve issue with store numbers,House Accounts - Updated the dataset to get the sum of the tax exempt sales,Queue - Updated the batch queue records process,Daily Reconciliation - Update logic when deleting daily recon to also delete at corp. As well as update ability for recon admin to delete completed daily recon,Item Sales Report - Updated parameters sent to report,Logins - Updated dataset that populates the login screen name options to filter out users that have no Director permissions."

v1.397.42

"Queue - Addressed issues Queue optimization, cleaned up the UI."

v1.397.41

"Fuel Sales By Day Report - Added fuel sales by day report to allow balancing between FTX and Fuel Smart."

v1.397.40

"Reports - Added option to use Dymo printer helper,Queue - Addressed issues for Queue optimization."

v1.397.39

"Queue- Added option to use MSMQ to send data to stores,CrossTab Sales Report - Expanded the column wide to show values,EDI - Updated logic to prevent POs over 90 days old,Buydowns - Changed the precision of Part Of Carton to show 6 decimal places,Invoices - Updated logic when using Copy Rev Qty function to make the surcharge negative,EDI - Added error message for format 5 when the vendor part exceeds 6 characters,Scan Data Report - Updated header for MSA report,Pending Transfers - Updated logic to select the current store as the To store and disabling it when in store mode.,Non-Sellers Report - Create new excel format report,EDI - Added the Order RowID to the end of the file name to be unique for Capital Candy files,Vendors - Updated logic to make sure items are pulled correctly from vendors and alternate vendors,Summary Reports - Added QOH to reports for filtering,Invoices - Updated logic with copying invoices to calculate sucharge amount correctly,Cycle Count Reports - Updated child costs so the calculation between Hybrid Report and Worksheet will be the same,Loyalty Module - Updated logic to resolve problems with coupons printing regardless of whitelist filter and suppressing redundant message for campaign selection,Scheduled Report - Updated logic to make sure correct date ranges are used for reports,Item Sales Report - Update report to resolve issue with sub groups,Items - Updated logic to not allow items marked "Do Not Order" to not be ordered,Kit Items - Updated kit items screen to not update to queue when pressing the "X" close button,Purchase Analysis Report - Updated report to run correctly,Vendors - Updated logic to make sure the store info is completely added to database so store updates in queue can be sent down to stores,Loyalty Customers - Updated logic to allow multi-select deletion and keeps customer selection after updating,Department Sales Report - Updated logic to allow filtering when grouping by department,Summary Data Reports - Updated logic to allow multi selection."

v1.26 9/19/2010 Zack McAnally

"wired up backorder items added table BackorderItems (use CreateTable_BackorderItems.sql) Procs affected: upBackOrderItems_GetAll,upBackOrderItems_GetAllByStore upBackOrderItems_GetAllByVendor upBackOrderItems_GetAllByVendorStore upBackOrderItems_Inser,upBackOrderItems_Delete upBackOrderItems_DeleteAll upRcvData_GetDetails_ByVendorPart_WithP,modified adjustments report to optionally include invoices & cycle counts Procs affected: upReports_InvAdjustments_NoFilte,upReports_InvAdjustments_ByDept upReports_InvAdjustments_ByCategory upReports_InvAdjustments_ByMajorCat upReports_InvAdjustments_ByManuf,upReports_InvAdjustments_ByProdGroup upReports_InvAdjustments_ByReportGroup1 upReports_InvAdjustments_ByReportGroup2,upReports_InvAdjustments_ByReportGroup3 upReports_InvAdjustments_ByReportGroup4 upReports_InvAdjustments_BySubGrou,added Reorder Schedule added table ReorderSchedule (use CreateTable_ReorderSchedule.sql) Procs affected: upReorderSchedule_Delet,upReorderSchedule_GetAll upReorderSchedule_GetByRunDay upReorderSchedule_Insert upReorderSchedule_UpdateLastRa,modified queue so that if an update is not sent, user can stop processin,added logic in buydowns so that the datagrid returns to last known row after update,changed all time pickers to show up/down indicator instead of calendar dropdow,added active flag and store selected flag to CorpStores table (use AlterTable_CorpStores.sql,link pop-up still shows it (for reporting) but other drop downs do not and in-active stores cannot have things added to queue for them,Store selected flag remembers which stores where selected when you exit/re-open the program. Also added fields for default excel file pat,And default excel tab name for custom excel reports Procs affected: upCorpStores_GetActive upCorpStores_GetAll upCorpStores_GetAll_WithCor,upCorpStores_GetAllInZone upCorpStores_GetSingle upCorpStores_Insert upCorpStores_Update upCorpStores_Upsert upCorpStores_UpdateSelecte,upCorpStores_UpdateExcelInfo upCorpStores_GetSingleWithExcelInfo upCorpStores_GetUniqueExcelFilePath,added confirmation when turning a working order into an actual order,modified consistent item ordering to only look at positive invoices Procs affected: upKeyItems_GetQtyInvoiced "

v1.27 9/21/2010 Zack McAnally

"created custom recap report added table tmpRecapReport (use CreateTable_tmpRecapReport.sql,fixed divide by 0 error in cost change report Procs affected: upRcvData_GetCostChanges "

v1.28 9/27/2010 Zack McAnally

"modified item details to insert/update class field Procs affected: upPLU_Update"

v1.29 9/29/2010 Zack McAnally

"re-implemented key-lok code so that the program requires the USB key-fob to be in plac,modified support utilies to import corporate database with pricebook zone Procs affected: upPRC_DATA_InsertWithPBZoneandCost,added support for UDL file. program looks for FasTraxSQL.udl in application path and sets connection string accordingl,modified EDI reorder so that when previewing a file, it shows the qty. This will help determine if the invoice is negative (credit) or not"

v1.30 10/5/2010 Zack McAnally

"added Update Cost field to receiving worksheet grid so that cost can optionally be updated "

v1.31 10/13/2010 Zack McAnally

"fixed bug in reorder to use the vendor part qty when calculating qty to order in all instances,fixed bug in receiving in store mode so that if an invoice is resaved old invoice qty's are backed out before new ones are applied,changed cashier display name textbox to only allow up to 15 character,added prompt when converting working order into actual order to notify that the store had not sent their changes in if the status of the working order is not Received From Stor,when the working order is converted into actual orde,modified recap report dataset to support payins Procs affected: upReports_RecapReport_GetPayIns (use UpdateProcs.sql,modified Buydowns (update to PRC_ADJ table) to take into account pricebook zones (use AlterPrcAdj.sql) Procs affected:"

v1.32 10/14/2010 Zack McAnally

"fixed bug in cycle counts report (not rolled up) where the variance was based on expected qty not orig qty,fixed bug in specialty pricing where it was possible to send an empty prc_data dataset in addition to the regular dataset causing an error (no XML file) when you tried to send from the queue "

v1.33 10/15/2010 Zack McAnally

"changed reorder by days of inventory so that if the current qty on hand is less than 0,it will not take it into account when creating the order regardless of what the checkbox says"

v1.34 10/18/2010 Zack McAnally

"changed mass updates to allow direct grid updating of description,,retail and cost Procs affected: upPLU_UpdateFromDirectGrid (Use UpdateProcs.sql),added ability to show reorder calculations (added ShowReorderCalculations to SETTINGS module in INI file) "

v1.36 10/22/2010 Zack McAnally

"added logic for processing Hackney EDI files locally,added gift cards logic including: new ini setting ShowGiftCards (bit) in [SETTINGS] section (default to false,new UDL file for gift cards (TenderProcessor) DB (FasTraxGiftCards.udl) v1.35 10/21/210 Zack McAnall,in the receiving worksheet, hid the apply to store immediately checkbox if not in corp mod,added original PLU qty field to Rcv_Data to correct issue with resaving invoices (Use AlterRcv_Data.sql),Procs affected: (Use UpdateProcs.sql) upRcvData_UpdateOriginalPLUQty upRcvData_GetOriginalPLUQty,modified the reorder algorithm for weeks of inventory to work of the least common denominator and not use rollup decimal "

v1.37 11/3/2010 Zack McAnally

"fixed bug in reorder grid where the join statement exluded the vendor id Procs Affected: upPOrdData_GetDetailsByRowI,added ability to view cycle count before the count has ended Procs Affected: upCycleCountHeader_GetAll upCycleCountHeader_GetAllbyDat,upCycleCountHeader_GetAllbyDateAndStore upCycleCountHeader_GetAllByStor,added new chron inventory movement report (created table tmpInventoryMovementReport) Procs Affected: uptmpInventoryMovement_Inser,uptmpInventoryMovement_GetAllByReportID upReports_ChronMovement_Invoices upReports_ChronMovement_Sales upReports_ChronMovement_Adjustment,upReports_ChronMovement_AdjustmentTo upReports_ChronMovement_AdjustmentFrom upReports_ChronMovement_BreakDow,upReports_ItemAudit_GetCycleCounts upReports_ItemAudit_GetInventoryReconcile,added PDA integration into inventory worksheet "

v1.38 11/5/2010 Zack McAnally

"added ability to init database from support utils Procs affected: upInitDatabase,finished wiring up sending store updates to empty database Procs affected: upDirectorLogins_GetAll upDirectorLogins_GetSingl,added ability to print inventory variance report before inventory is reconcile,fixed bug in printing previous invoices where it ignored preview flag (auto-print),added ability to run cycle count report and only show variance items,added ability to run inventory report and only show variance items,changed buydowns so that when adding a buydown,the same record is added to the PRC_ADJ_ARCHIVE (alter tabled PRC_ADJ_ARCHIVE - added buydownGUID column - use AlterPrcAdjArchive.sql,Procs affected: upBuydownsArchive_Upsert,added ReportTaxRate column to CorpStores and StoreNumber to tmpSalesTaxReport tables to show the tax rate on the Sales Tax Report (use AlterCorpStores.sql - and AltertmpSalesTaxReport.sql,Procs affected: upCorpStores_GetAll_WithCorp,upCorpStores_GetAll upCorpStores_GetSingle upCorpStores_GetActive upCorpStores_Update upCorpStores_Upsert upCorpStores_Inser,upReports_SalesTax_Insert upReports_SalesTax_GetAl,added ability to view/delete orphaned buydowns @ store from corp (change to FTCorpwebservice program,fixed bug in transfer/adjustments where total cost was not being multiplied out (change to FTCorpwebservice program,changed PDA inventory to look at open BO inventory list (change to FTCorpWebservice program),Procs Affected: upPDA_Inventory_GetOpenBOInventoryList "

v1.39 11/16/2010 Zack McAnally

"began new cycle count batch program (use CreateCycleCountBatchDetails, CreateCycleCountBatchHeader to create tables),Procs affected: upCycleCountBatchHeader_GetAll upCycleCountBatchHeader_GetAllByDate upCycleCountBatchHeader_GetAllByDateAndStore,upCycleCountBatchHeader_GetFinished upCycleCountBatchHeader_GetFinishedByDate upCycleCountBatchHeader_GetFinishedByDateAndStor,upCycleCountBatchDetails_GetByGUID upCycleCountBatchDetails_UpdateQtySold upCycleCountBatchDetails_UpdateFloorCoun,upCycleCountBatchDetails_UpdateBackRoomCount upCycleCountBatchDetails_GetUncountedByGUID upCycleCountBatchDetails_SetToZer,upCycleCountBatchHeader_FlagAsFinished upCycleCountBatchHeader_Insert upCycleCountBatchDetails_Insert upCycleCountBatchDetails_LookupIte,upCycleCountBatchDetails_UpdateSnapshot upCycleCountBatchDetails_AppendFloorCount upCycleCountBatchDetails_AppendBackRoomCoun,upCycleCountBatchDetails_UpdateFloorCountFul,grid in mass updates remembers position after deleting "

v1.40 11/22/2010 Zack McAnally

"continued to evolve cycle count batch program (use AlterBatchTables for schema updates,Procs affected: upCycleCountBatchDetails_UpdateBackRoomCount upCycleCountBatchDetails_UpdateFloorCountFul,upCycleCountBatchDetails_UpdateFloorCount upCycleCountBatchDetails_LookupItem upCycleCountBatchDetails_Inser,upCycleCountBatchDetails_GetCounts_All upCycleCountBatchDetails_GetCounts_Uncounted upCycleCountBatchDetails_GetCounts_Varianc,upCycleCountBatchHeader_GetByGUID upCycleCountBatch_DeleteByGUID upCycleCountBatchHeader_GetUnfinished,upCycleCountBatchDetails_UpdateBackRoomCountFull,added option to hide QOH on order reports "

v1.41 11/27/2010 Zack McAnally

"added ability to send inventory defs to store Procs affected: upInv_Def_Delete_ByNam,added DebugLog table/view (Use CreateTableDebugLog.sql) Procs affected: upDebugLog_Insert upDebugLog_GetAllByStor,upDebugLog_GetSessionsByDateRange upDebugLog_DetailsBySessio,added support for exporter to send batch cycle counts to corp Procs affected: upCycleCountBatchHeader_GetForCor,upCycleCountBatchHeader_UpdateFromCorp,fixed bug in Ejournal Report where Reg Num was not taken into consideration (user AlterTmpEjournalDetails.sql),Procs Affected: upReports_Ejournal_InsertDetails upReports_Ejournal_GetReceiptsByReceiptRang,renamed Cycle Count stuff to Spot Checks and Cycle Count Batch stuff to Cycle Counts,modified Cycle Counts so that you can filter on all, finished or open Procs Affected: upCycleCountBatchHeader_GetOpenByDat,upCycleCountBatchHeader_GetOpenByDateAndStore "

v1.42 12/01/2010 Zack McAnally

"added highlight logic to the list of stores updates on the dash so that stores that have not sent updates in the last 3 hours will be highlighted and note,changed all negative seperated inventory eval reports so that there is a page break before the negative,change sort on item sales report Prcs affected: upReports_ItemSales_NoFilter upReports_ItemSales_BySubGroup upReports_ItemSales_ByReportGroup,upReports_ItemSales_ByReportGroup3 upReports_ItemSales_ByReportGroup2 upReports_ItemSales_ByReportGroup1 upReports_ItemSales_ByProdGrou,upReports_ItemSales_ByPLU upReports_ItemSales_ByManuf upReports_ItemSales_ByMajorCat upReports_ItemSales_ByDeptGroup upReports_ItemSales_ByDep,upReports_ItemSales_ByCategory,added total label (qty & dollar) to the transfer/adjustment screen,made maximum length of the department fields match POS constraint,made maximum length of the PLU fields match POS constraint,added datepicker to EDI receiving screen instead of using NOW for invoice date,added support for Renfro in EDI receiving (file based),added support for receiving batch cycle counts from store Prcs affected: upCycleCountBatchHeader_GetForCor,upCycleCountBatchHeader_UpdateFromCorp upCycleCountBatchDetails_GetForCorp upCycleCountBatchDetails_UpdateFromCor,upCycleCountBatchHeader_Upsert upCycleCountBatchDetails_InsertForCor,modified PDA receiving so the applied flag is flipped when an invoice is saved Procs affected: upPDA_Receiving_AddRcvDef,added "Counted" filter to Cycle Count Batch worksheet Procs affected: upCycleCountBatchDetails_GetCountedByGUI,fixed bug in Reg Z Report where system discounts were not being shown (run AltertmpRegZReportMain.sql,Prcs affected: upReports_RegZ_GetSysDiscounts uptmpRegZReportMain_Insert uptmpRegZReportMain_InsertForDateRange uptmpRegZReportMain_GetAll "

v1.43 12/06/2010 Zack McAnally

"added option to see rollup view in the cycle count program Procs affected: upCycleCountBatchDetails_GetByGUIDAndUP,fixed bug where links are not being cleared when a UPC is deleted Procs affected: upInvInfo_DeleteLink,added option to clear POS receipt info in the init portion of the support utilities progra,moved all inventory based programs under inventory and added definition tab and remove cycle count tab "

v1.44 12/08/2010 Zack McAnally

"created shelf label report for SJTS format (2" x 1" with box around retail,fixed bug in eJournal report where if 2 registers in the selected date range had the same receipt number their data could get meshed together,added option for sending message to store when PRC_DATA changes are made (SendMessageToStoreWhenUpdated=1 in [Settings] section of FasTraxDirectorSettings.INI)"

v1.45 12/10/2010 Zack McAnally

"added ability to edit inventory definition,added ability to run inv eval report by UPC Procs affected: upReports_InvSnapShot_ByUPC upReports_InvEval_ByUP,fixed bug in Item Analysis where invoices where being flagged as "Other" Procs affected: upAdjustLog_GetTop30ByStoreAndUP,added QOH to item sales report Procs affected: upInv_Qty_GetSumByUPCAndStoreList "

v1.46 12/17/2010 Zack McAnally

"fixed bug in specialty pricing where standard prices do not get Zone I,added variance dollars to cycle count grid,changed cycle count logic to use QOH instead of sales "

v1.47 12/20/2010 Zack McAnally

"changed cycle count logic back to using sale,fixed bug in tree report where MC, Manuf and Prod Group were off because we moved the columns in grid around,changed inv eval report so it can be filtered for items whose QOH <> 0 (replaced > 0 option) "

v1.48 12/21/2010 Zack McAnally

"made columns in cycle count worksheet read-onl,made printing of cycle count worksheet disabled for open counts outside of worksheet "

v1.49 12/27/2010 Zack McAnally

"cycle count worksheet now highlights breakdowns in yello,added activity popup (double click grid row) in cycle count worksheet "

v1.50 12/29/2010 Zack McAnally

"modified Cycle Count to take 2 snapshots (1 for QOH and 1 for scan) Schema affected: alter table CycleCountBatchDetail,add SnapShotTaken bit default(0) alter table CycleCountBatchDetails add ScanTimeStamp datetime alter table CycleCountBatchDetail,add QtySoldSinceSnapshot int default(0) Procs affected: upCycleCountBatchDetails_LookupItem,,upCycleCountBatchDetails_UpdateSnapshot,,upCycleCountBatchDetails_UpdateBackRoomCountFull,upCycleCountBatchDetails_UpdateFloorCountFull,,upCycleCountBatchDetails_UpdateBackRoomCountAndSnapshotTimeStamp,upCycleCountBatchDetails_UpdateFloorCountAndSnapshotTimeStamp,,upCycleCountBatchDetails_UpdateQtySold,upCycleCountBatchDetails_GetByGUID,upCycleCountBatchDetails_GetByGUIDAndUPC,upCycleCountBatchDetails_GetCountedByGUI,upCycleCountBatchDetails_GetUncountedByGUID upCycleCountBatchDetails_GetVarianceByGUID "

v1.51 12/31/2010 Zack McAnally

"changed Inv Evaluation report to allow more filter options for QOH Procs affected: upReports_InvEval_NoFilter upReports_InvEval_ByUP,upReports_InvEval_BySubGroup upReports_InvEval_ByReportGroup1 upReports_InvEval_ByReportGroup2 upReports_InvEval_ByReportGroup,upReports_InvEval_ByReportGroup4 upReports_InvEval_ByProdGroup upReports_InvEval_ByManuf upReports_InvEval_ByMajorCa,upReports_InvEval_ByDeptGroup upReports_InvEval_ByDept upReports_InvEval_ByCategory upReports_InvSnapShot_ByCategor,upReports_InvSnapShot_ByDept upReports_InvSnapShot_ByDeptGroup upReports_InvSnapshot_ByMajorCat upReports_InvSnapShot_ByManu,upReports_InvSnapShot_ByProdGroup upReports_InvSnapshot_ByReportGroup1 upReports_InvSnapshot_ByReportGroup,upReports_InvSnapshot_ByReportGroup3 upReports_InvSnapshot_ByReportGroup4 upReports_InvSnapShot_BySubGroup upReports_InvSnapShot_ByUP,upReports_InvSnapshot_NoFilter,modified Reg Z Report query to take system discounts out of dept sales Procs affected: upReports_RegZ_GetDeptDetail,changed reg z count query to sort by date time desc instead of z counter desc Procs affected: upRegZCnt_GetTop25ZsByStoreAndReg "

v1.52 1/5/2011 Zack McAnally

"changed PLU reports in mass updates to have 8 point font,added ability from item analysis to switch to purchase unit/subunit links "

v1.53 1/6/2011 Zack McAnally

"changed mass updates to enter coupon barcode instead of coupon name when adding coupon,changed dash to only show active store,fixed bugs in Z report regarding discounts and return amounts Procs affected: upReports_RegZ_GetReturnsValue upReports_RegZ_GetReturnsCount upReports_RegZ_GetDeptDetail,changed mass updates grid to support pricebook zones Procs affected: upPLU_GetForGrid_All upPLU_GetForGrid_ByCos,upPLU_GetForGrid_ByCost_GreatherThan upPLU_GetForGrid_ByCost_LessThan upPLU_GetForGrid_ByDeptGroup upPLU_GetForGrid_ByDeptNu,upPLU_GetForGrid_ByDescription upPLU_GetForGrid_ByDescription_Contains upPLU_GetForGrid_ByDescription_EndsWith,upPLU_GetForGrid_ByDescription_Equals upPLU_GetForGrid_ByMajorCat_Category_Manuf upPLU_GetForGrid_ByMajorCat_Category_Manuf_ProdGrou,upPLU_GetForGrid_ByMajorCat_Category_Manuf_ProdGroup_SubGroup upPLU_GetForGrid_ByMajorCategory upPLU_GetForGrid_ByPric,upPLU_GetForGrid_ByPrice_GreaterThan upPLU_GetForGrid_ByPrice_LessThan upPLU_GetForGrid_ByUPC upPLU_GetForGrid_ByUPC_Contain,upPLU_GetForGrid_ByUPC_EndsWith upPLU_GetForGrid_ByUPC_Equals upPLU_GetForGrid_ByUPCInList upPLU_GetForGrid_Category upPLU_GetForGrid_Clas,upPLU_GetForGrid_CouponName upPLU_GetForGrid_Location upPLU_GetForGrid_Manuf upPLU_GetForGrid_ProdGroup upPLU_GetForGrid_ReportGroup,upPLU_GetForGrid_ReportGroup2 upPLU_GetForGrid_ReportGroup3 upPLU_GetForGrid_ReportGroup4 upPLU_GetForGrid_SubGroup upCorpStores_GetAllInZoneAndActive"

v1.54 1/10/2011 Zack McAnally

"modified weekly sales report to show buydowns in cost Procs affected: upReports_SummarySales_All,modified item sales report to show qty on hand and reduced siz,changed vendor parts to use prc_data for cost Procs affected: upMultVend_GetAll upMultVend_FilterByDescription upMultVend_FilterByUP,upMultVend_FilterByVendorPart upMultVend_getByPartandVendor upMultVend_GetByRowID upMultVend_getByUPC upMultVend_getByUPCandVendo,upMultVend_getByVendor upCycleCountBatchDetails_GetVarianceByGUI,fixed bug in purchase analysis report where it would not preview,changed cycle count batch variance report to use same variance logic as filter "

v1.55 1/13/2011 Zack McAnally

"fixed bug in selecting items for vendor part kits "

v1.56 1/16/2011 Zack McAnally

"added feature when changing pricebook zones, prompt to send PRC_DATA dow,fixed bug in item details where the zone was being ignored,added option to print all Zs in date range instead of having to select each on,added logic so that all plu/prc_data changes are sent to all stores/all stores in zone regardless of what is checked"

v1.57 1/18/2011 Zack McAnally

"fixed bug in all Zs in reg z report where the date was not begin passed properl,added check for duplicate buydown name when adding buydowns Procs Affected: upBuydowns_GetAll_ByName"

v1.58 1/19/2011 Zack McAnally

"hid pricebook zone maintenance from non-admins,fixed read-only issue with mass updates grid,fixed bug in Receiving Worksheet where items with diff part but same UPC where not working Procs affected: upPRC_DATA_UpdateRetail_StandardWithZone "

v1.59 1/20/2011 Zack McAnally

"fixed bug in updating vendor parts where unit desc was not saving Procs affected: upMultVend_Updat,added ability to set grid colors on each zone (use AlterPricebookZones.sql to update schema),Procs affected: upPricebookZones_GetDetailsByID upPricebookZones_GetAll upPricebookZones_Insert upPricebookZones_Update"

v1.60 1/21/2011 Zack McAnally

"Fixed bug in variance count in Cycle Counts worksheet Procs affected: upCycleCountBatchDetails_GetCounts_Variance"

v1.61 1/21/2011 Zack McAnally

"added ablility to round to 5/9 when making standard massupdate price change "

v1.62 1/24/2011 Zack McAnally

"created inventory projection repor,added system discounts to store updates in mass update,fixed bug in mass updates change preview (no cost) Procs affected: upPRC_DATA_UpdateRetail_StandardWithZon,added InvoicesDefault_AutoApply to INI file to default in value for auto-sending invoices to store,added InvoicesDefault_CostChange to INI file to default in value for applying cost update,added LastStore to INI file to default in last used store to new invoice dropdow,added LastVendorID to INI file to default in last used vendor id to new invoice dropdown,fixed bug in eJournal report regarding buydown returns being incorrectly displayed Procs affected: upReports_Ejournal_GetSalesDetailsReceipt,created new front end for barcode reports Procs affected: upReports_Barcodes_ByCategory upReports_Barcodes_ByDept upReports_Barcodes_ByMajorCa,upReports_Barcodes_ByManuf upReports_Barcodes_ByProdGroup upReports_Barcodes_ByReportGroup1 upReports_Barcodes_ByReportGroup,upReports_Barcodes_ByReportGroup3 upReports_Barcodes_ByReportGroup4 upReports_Barcodes_BySubgGroup upReports_Barcodes_ByPriceChang,changed top sellers report to allow running by top 10,25,50 or 100 "

v1.63 1/25/2011 Zack McAnally

"resized inventory eval grouped report (8pt font, portrait),changed transfers so if an unknown item is entered, it tells you,changed adjustments so if an unknown item is entered, it tells you,changed dept sales report dept # field format to not show thousands ",,changed reg z multiple report sections to not be "keep together" so that there are no forced page breaks,changed item analysis so cycle counts and spot checks showed correctly Procs affected: upAdjustLog_GetTop30ByStoreAndUPC,added cycle count batch to adjustments report and renamed old cycle counts to spot check,added cycle count batch to item movement and chron movement reports Procs affected: upReports_ItemAudit_GetCycleCountsBatc,changed item details QOH to only show sum of selected stores in corp mod,changed item detail QOH to integer instead of double; no use to show decimal place,changed item details so cost & retail textbox backcolors are the zone's colors,removed set uncounted to expected button from cycle count worksheet (no longer needed),added inputbox password (FASTRAX) to set uncounted to actual button in cycle count worksheet,added find by UPC/Description functionality to cycle count workshee,changed cycle count reports to 8pt fonts,added ability to manually start cycle count in store mod,added logic for mass updates to remember it's filter when refreshing zones "

v1.63 1/28/2011 Zack McAnally

"added zone logic to buydowns (use alter table PRC_ADJ add PriceBookZones varchar(250) in AlterPrcADJ.sql,Procs affected: upBuydowns_Upsert upBuydowns_Update upBuydowns_Insert upBuydowns_GetAll_ByGUIDAndZone"

v1.64 1/29/2011 Zack McAnally

"changed receiving worksheet so when adding a row the apply cost change checkbox will default in correctly "

v1.65 1/31/2011 Zack McAnally

"added settings module so user can update their own settings (PW, ini info, etc,fixed bug in specialty pricing where all zones where being deleted and only active zone was being added back in"

v1.66 1/31/2011 Zack McAnally

"increased size of status column in item analysis to handle cycle counts "

v1.67 2/01/2011 Zack McAnally

"added total variance dollars to cycle count worksheet Procs affected: upCycleCountBatchDetails_GetCounts_VarianceDollars,removed the price in the buydown grids temporarily to avoid confusuio,added LastCost to PRC_DATA dataset to be sent to stores (updated web service also,fixed logic on PLU updates from item details to send down correct cost on non-selected zone,changed cycle count rollup report to only show variance items when checked,changed store webservice to default in 0 for PRC_DATA Prcs affected: upPRC_DATA_Insert_Store,changed adjustments current QOH field to integer format instead of decimal,changed transfers current QOH field to integer format instead of decima,changed eJournal report to display safe drop,created cycle count hybrid report which shows both individual totals as well as rollup totals grouped together,fixed bug where date range Z report was not correctly adding department quantities Procs affected: uptmpRegZReportDept_Upser,added check when creating an invoice manually to detect same vendor id/invoice num combo to prevent dup,added ability to refresh store QOH from inventory -> utilitie,changed UPC search in cycle count worksheet to allow expansion of UPCs,added ability to see scan order of items in cycle counts (created table CycleCountBatchScanOrder,Procs affected: upCycleCountBatchScanOrder_Insert upCycleCountBatchScanOrder_GetByGUID upCycleCountBatchScanOrder_GetByGUIDAndIte,added scan order report to cycle count worksheet and scan order secion to cycle count item popup,modified reg z multiple report to not "keep together" the tender section,created new inventory adjustment summary report "

v1.68 2/09/2011 Zack McAnally

"resized media detail report so totals were not cut off,changed adjustments so the grid moves to bottom when adding item,changed transfers so the grid moves to bottom when adding item,added logic to item details to notify users that they were trying to edit a specialty priced item when they were "

v1.69 2/09/2011 Zack McAnally

"changed store updating,buydowns to be zone specific Procs affected: upBuydowns_GetAllByZone upBuydownItems_GetAllByZon,changed item sales report to use PRC_DATA cost Procs affected: all upReports_ItemSales,changed logic in item details so that if there is more than one vendor part tied to an item and the vendor dropdown list is changed,it will lookup the part based on vendor ID "

v1.70 2/14/2011 Zack McAnally

"changed buydown grid load logic so retail and adjusted retail are based on the first pricebook zone associated with that buydown instead of zone 0 Procs affected: upBuydowns_GetAll_ByGUI,added popup form for selecting each item individually when printing shelf tags,refactored adjustment movement report to show old QOH & fix breakdown bug upReports_ChronMovement_Sales upReports_ChronMovement_BreakDow,upReports_ChronMovement_AdjustmentFrom upReports_ChronMovement_AdjustmentTo upReports_ChronMovement_Adjustment,upReports_ChronMovement_Invoices upReports_ChronMovement_CycleCounts upReports_ChronMovement_SpotChecks upAdjustLog_Insert,changed working orders logic so employee ID is no longer overwritten Procs affected: upPOrdDef_Working_Upser,added EMPLOYEE_ID field to RCV_DEF (use AlterRcvDef.sql) Procs affected: upRcvDef_Insert upRcvDef_InsertForCorp upRcvDef_Upser,added more details for logging EMPLOYEE_ID in cost/retail change,fixed bug in vendor part report where pricebook zone was not being passed in,changed logic so pay ins/payouts show correctly in eJournal repor,added tax exempt sales to recap report Procs affected: upReports_RecapReport_GetTotalTaxes"

v1.71 2/18/2011 Zack McAnally

"changed inventory eval report to page break by store appropriatel,added variance column to previous cycle counts scree,added group by date option to sales tax report (use AltertmpSalesTaxReport.sql) Procs affected: upReports_SalesTax_GetAll_Grouped upReports_SalesTax_Insert"

v1.72 2/22/2011 Zack McAnally

"added check of employee/cashier password to ensure they are numeri,added ability to delete multiple rows from adjustments,added ability to delete multiple rows from transfers,added "Select A Store" to transfers store list to avoid using default entry by acciden,fixed mysterious queue bug where send all would not function after a single send was performed in the same session,created new logic for buydown sales report procs affected: upReports_BuydownSales upBuydownItems_GetAllByZoneAndPLU"

v1.72 2/22/2011 Zack McAnally

"fixed bug when running top sellers report spanning multiple zones Procs affected: upReports_ItemSales_NoFilter upReports_ItemSales_BySubGrou,upReports_ItemSales_ByReportGroup1 upReports_ItemSales_ByReportGroup2 upReports_ItemSales_ByReportGroup3 upReports_ItemSales_ByReportGroup,upReports_ItemSales_ByProdGroup upReports_ItemSales_ByPLU upReports_ItemSales_ByManuf upReports_ItemSales_ByMajorCat,upReports_ItemSales_ByDeptGroup upReports_ItemSales_ByDept upReports_ItemSales_ByCategor,fixed bug where item details would not refresh zone info when switching in from mass updates "

v1.73 2/28/2011 Zack McAnally

"added new scorecard module to dashboard (use CreatetmpScoreCard.sql and CreatetmpScoreCardInventory.sql) "

v1.74 3/02/2011 Zack McAnally

"modified scorecard to cleanup background colors (too dark) "

v1.75 3/07/2011 Zack McAnally

"changed Item Sales report to use QOH for each store individually instead of as a chain when grouping by stor,added ability to change items in item analysis scree,fixed issues with Item Audit report (chron) Procs affected: upReports_ChronMovement_Invoices upReports_ChronMovement_Adjustments,upReports_ChronMovement_AdjustmentFrom upReports_ChronMovement_AdjustmentT,changed adjustment report to 8pt fon,added ability to mass send lottery games to stores (store updates in mass updates) "

v1.76 3/09/2011 Zack McAnally

"changed invoice worksheet to default to previewing instead of printing,added ability to sort invoice detail report by description, upc or vendor part,fixed grouping issue in sales tax report Procs affected: upReports_SalesTax_GetAll_Grouped,added ability to filter cycle count history by definition Procs affected: upCycleCountBatchHeader_GetAllByDe,upCycleCountBatchHeader_GetAllByDateAndDef upCycleCountBatchHeader_GetAllByDateAndStoreAndDe,changed cycle count hybrid report to take into account cost variance instead of just qty variance when only showing variance items on the report (will help show any cost diffs),added ability to mass send inventory defs to stores (store updates in mass updates) Procs affected: upInv_Def_GetAll upInv_Def_Update_ByName,added tender filter to media detail report Procs affected: upReports_MediaDetail_ByTenderTyp,added summary option to media detail repor,fixed tender bug in summary sales report Procs affected: upReports_SummarySales_Tender,resized negative cashier report to 8pt fon,added receipt date to negative cashier repor,added negative cashier summary repor,changed eJournal and Negative cashier report to both sort by TIMESTAMP when showing item detail,Procs affected : upReports_Ejournal_GetSalesDetailsReceipt upReports_NegCashier_GetReceiptDetails "

v1.77 3/15/2011 Zack McAnally

"fixed bug in getting the cancel sale value for reg z report Procs affected: upReports_RegZ_GetCancelValu,fixed bug in getting cahier details for reg z report (duplicates as filter was not specifiying store #) Procs affected: upReports_RegZ_GetCashierDetail,fixed logic when looking up vendor part kits for receiving to not join against plu table,added cycle counts grid to item analysis popup Procs affected: upCycleCountBatchDetails_GetForItemAnalysis,added spot checks grid to item analysis popup Procs affected: upCycleCountDetails_GetForItemAnalysis,added inventory definition tree report to show what trees are a part of the selected definitio,Procs affected: upReports_InvDefTrees_ByCategory upReports_InvDefTrees_ByDept upReports_InvDefTrees_ByDeptGrou,upReports_InvDefTrees_ByMajorCat upReports_InvDefTrees_ByManuf upReports_InvDefTrees_ByProductGroup upReports_InvDefTrees_ByReportGroup,upReports_InvDefTrees_ByReportGroup2 upReports_InvDefTrees_ByReportGroup3 upReports_InvDefTrees_ByReportGroup4 upReports_InvDefTrees_BySubGroup"

v1.78 3/18/2011 Zack McAnally

"added drilldown option to dept sales report (checkbox) that will show item sales then individual sale,added validation check for linking in item details Procs affected: upInvInfo_GetByParentUPC upInvInfo_GetBySubunitUP,added option to allow/disallow zero costs in item details,mass updates,adjustments,transfers,invoices (AllowZeroCost in SETTINGS secion of INI file,added filtering options to inventory movement report to only show movement of the selected type,added option to group inventory adjustments summary report (will group by whatever filter is used),changed receiving logic to allow multiple vendor parts tied to the same item Procs Affected: upRcvData_UpsertFromWorksheet "

v1.79 3/22/2011 Zack McAnally

"added option to to trickle down cost updates to subunit items in massupdates/item details (UpdateSubunitCost in SETTINGS section of INI file,fixed bug where deptlist parameter was too small Procs affected: upReports_InvAdjustments_ByDept upReorder_CreateOrder_ListItems_ByDep,upReports_Barcodes_ByDept upReports_InvDefTrees_ByDept upReports_InvEval_ByDept upReports_InvSnapShot_ByDept upReports_ItemSales_ByDep,upReports_Movement_ByDept upReports_NonSellers_GetItems_Dept upReports_PurchaseAnalysis_ByDept upReports_SummarySales_DeptList,fixed QOH issue in movement report Procs affected: upReports_ChronMovement_CycleCounts upReports_ChronMovement_SpotChecks"

v1.80 3/22/2011 Zack McAnally

"added option to run top sellers report by profit,added date/time picker to item analysis popup Procs affected: upPLU_Snapshot_ByPLU_Store_Date upAdjustLog_GetByStoreAndUPCAndDat,upRcvData_GetByUPCAndStoreAndDate upReports_ItemAnalysis_ByPLUAndDateAndStore upCycleCountBatchDetails_GetForItemAnalysis "

v1.81 3/28/2011 Zack McAnally

"added notes field to cycle counts (use AddCountNotes.sql) Procs affected: upCycleCountBatchHeader_GetAll,upCycleCountBatchHeader_GetAllByDate upCycleCountBatchHeader_GetAllByDateAndDef upCycleCountBatchHeader_GetAllByDateAndStor,upCycleCountBatchHeader_GetAllByDateAndStoreAndDef upCycleCountBatchHeader_GetAllByDef upCycleCountBatchHeader_GetByGUID,upCycleCountBatchHeader_GetFinished upCycleCountBatchHeader_GetFinishedByDate upCycleCountBatchHeader_GetFinishedByDateAndStor,upCycleCountBatchHeader_GetForCorp upCycleCountBatchHeader_GetOpenByDate upCycleCountBatchHeader_GetOpenByDateAndStore,upCycleCountBatchHeader_GetUnfinished upCycleCountBatchHeader_Insert upCycleCountBatchHeader_Upsert upCycleCountBatchHeader_FlagAsFinishe,upCycleCountBatchHeader_UpdateNotes "

v1.82 4/01/2011 Zack McAnally

"added BreakdownQty and BreakdownQtySinceSnapshot fields to cycle counts (use AddBreakdown.sql),Procs affected: upCycleCountBatchDetails_UpdateQtySold upCycleCountBatchDetails_GetByGUID upCycleCountBatchDetails_GetForCor,upCycleCountBatchDetails_GetByGUIDAndUPC upCycleCountBatchDetails_GetCountedByGUID upCycleCountBatchDetails_GetUncountedByGUI,upCycleCountBatchDetails_GetVarianceByGUID upCycleCountBatchDetails_Insert upCycleCountBatchDetails_InsertForCorp"

v1.83 4/9/2011 Zack McAnally

"fixed filter bug in cycle count header filter (the def filter was ignored when filtering off finished count),Procs affected: upCycleCountBatchHeader_GetFinishedByDateAndStoreAndDef upCycleCountBatchHeader_GetFinishedByDateAndDe,changed barcode report to allow multiple filters before printing,added cancels to inventory movement report Procs affected: upReports_ChronMovement_Sales,fixed bug in adjustlog where cycle count entries without a variance where logged with the incorrect old QO,added Scanned column to cycle counts (use AddScanned.sql) Procs affected: upCycleCountBatchDetails_UpdateScanned,upCycleCountBatchDetails_GetByGUID upCycleCountBatchDetails_GetByGUIDAndUPC upCycleCountBatchDetails_GetCountedByGUI,upCycleCountBatchDetails_GetUncountedByGUID upCycleCountBatchDetails_GetVarianceByGUID upCycleCountBatchDetails_InsertForCor,added AppliedDate column to invoices (use AddAppliedDate.sql) Procs affected: upRcvDef_UpdateApplied upRcvDef_GetAll upRcvDef_GetByRowI,upRcvDef_GetByDate upRcvDef_GetByStore upRcvDef_GetByStoreDate upRcvDef_GetByStoreVendor upRcvDef_GetByStoreVendorDate,upRcvDef_GetByStoreVendorInvoiceNum upRcvDef_GetByVendor upRcvDef_GetByVendorDate"

v1.84 4/18/2011 Zack McAnally

"modified lottery recon to allow cashier to input starting numbers before shift starts (use UpdateLotteryReconDetails.sql And UpdateLotteryReconHeader.sql,Procs affected: upLotteryReconDetails_GetForCorp upLotteryReconDetails_UpdateFromCor,upLotteryReconDetails_Insert upLotteryReconDetails_GetByReconGUID upLotteryReconDetails_GetByReconGUID_ForGri,upLotteryReconDetails_UpdateStartCount upLotteryReconHeader_GetUnfinished upLotteryReconHeader_GetForCorp upLotteryReconHeader_Updat,added store name to sales tax report,added store name to dept sales group by store repor,added option to print barcode instead of PLU on shelf tag report (requires FRE3OF9X.ttf font,added filter options to negative cashier repor,added LoginName to ItemAnalysis adjustments grid Procs affected: upAdjustLog_GetByStoreAndUPCAndDate upAdjustLog_GetTop30ByStoreAndUP,changed cycle count popup to show seconds in all time fields "

v1.85 5/6/2011 Zack McAnally

"begin rebuilding the recommended transfers scree,changed logic in cycle counts to recalc scan time of linked items on breakdowns to make sure both parent and child had the same time "

v1.86 5/11/2011 Zack McAnally

"fixed bug in inventory movement report where QOH was not being cycled after first item,removed debug msgbox in sending PO orders that fit a certain criteri,fixed bug in itemsales/deptsales group by store where the storename was causing the report to be slow Procs affected: upReports_ItemSales_,added "Type" column to manuf sales report. Pack/Carton is result based on INV_INFO record"

v1.87 5/15/2011 Zack McAnally

"added houseaccountparticipant and loyaltyparticipant to House Accounts setup,And cleaned up some old code there Procs affected: up_CustomersUpdate upCustomers_Upsert "

v1.88 5/17/2011 Zack McAnally

"added refresh button to dash for performance snapsho,removed dept and tax tabs from house accounts screen as they are not implemented in PO,added option to limit sales in item analysis popup Procs Affected: upReports_ItemAnalysis_ByPLUAndDateAndStore,upReports_ItemAnalysis_ByPLUAndDateAndStore_NoLimi,added cashier name to sales grid in item analysis popup "

v1.89 5/18/2011 Zack McAnally

"added option to apply lottery adjustments/invoices to inventory (use AlterLotteryReconHeader.sql to add new column,Procs affected: upLotteryReconHeader_GetAll upLotteryReconHeader_GetAllByDateRange upLotteryReconHeader_GetAllByDateRangeAndStor,upLotteryReconHeader_GetHeaderInfo upLotteryActivations_GetDetailsByReconGUID upLotteryReconHeader_UpdateAdjustedFla,upLotteryReconDetails_GetByReconGUID_ForGrid_Variance,added Price Ea column to Manufacturer Sales Report "

v1.90 5/24/2011 Zack McAnally

"added online lottery (lotto) to lottery recon (use CreateLotteryReconOnline.sql) Procs affected: upLotteryReconOnline_GetByReconGUI,upLotteryReconOnline_Insert upRegZCnt_GetForCorp,added ZReconciled and ZLotteryReconciled columns to the RegZCnt table (use AlterRegZCnt.sql then UpdateRegZCnt.sql,Procs affected: upReconcile_GetZList_Unreconciled upRegZCnt_UpdateLotReconcile upRegZCnt_GetLotReconcile upRegZCnt_UpdateZReconcile"

v1.91 5/25/2011 Zack McAnally

"added variance item count and variance dollars to previous lottery recon screen Procs affected: upLotteryReconDetails_GetVarianceCountByReconGUI,upLotteryReconDetails_GetVarianceDollarsByReconGUI,added cashier info to inventory movement report (sales/cancels/voids only) Procs affected: upReports_ChronMovement_Sale,added PLU filter to negative cashier report Procs affected: upReports_NegCashier_GetCancels_ByPL,upReports_NegCashier_GetReturns_ByPLU upReports_NegCashier_GetVoids_ByPLU "

v1.92 5/30/2011 Zack McAnally

"fixed bug where reference number was not being saved on transfer,resized ejournal report to 8pt font to help with spacing issue,added sanity check for large date range (> 24 hours) on ejournal report,added sanity check for large date range (> 24 hours) on negative cashier report,added delete column to PLU dataset to send to stores when corp deletes PLUs (item details & mass updates) "

v1.93 6/14/2011 Zack McAnally

"changed the default filter in item movement to UPC Numbe,changed item movement report form to expand the UPC code,added Z list to date range Z repor,added Z list to all Zs in date range Z repor,fixed bug in reg z report where it could possibly show false cancel sale count if the buydown ID was 30 Procs affected: upReports_RegZ_GetCancelCoun,fixed bug in item details where pricename was not always being saved correctly,changed item details so you can manage the pricename there now,fixed bug in item details where if an item had a specialty price in one zone, but not another the specialty price could get cleare,added backroom count and floor count columns to the cycle count hybrid repor,added ScanLocation and ScanType columns to CycleCountBatchScanOrder table (use AlterCycleCountScanOrder.sql,added ScanLocation and ScanType to the cycle count scan order report Procs affected: upCycleCountBatchScanOrder_Insert,upCycleCountBatchScanOrder_GetByGUIDAndItem upCycleCountBatchScanOrder_GetByGUID upCycleCountBatchScanOrder_GetByGUIDForPrevItem,upCycleCountBatchScanOrder_GetByGUIDForPrevItemsByEmployee,added ScanLocation and ScanType to the cycle count popup details for,added filter to the cycle count popup for the storenumber in corporate mode so you can accurately see activiti,changed house accounts setup so that the balance field can be changed"

v1.94 6/16/2011 Zack McAnally

"modified the lottery recon reports to show the online (lotto) info,moved extended description in item details to popup screen Procs affected: upPLU_UpdateExtendedDesc upPLU_GetExtendedDes,added buydown label to item details screen and re-arranged screen Procs affected: upBuydowns_GetAllByUPC "

v1.95 6/21/2011 Zack McAnally

"refactored suggested transfers to allowed saving to resume later (use CreatetmpSuggestedXFers.sql,Procs affected: upSuggestedTransfers_Insert upSuggestedTransfers_Delete upSuggestedTransfers_GetAll upSuggestedTransfers_GetByNam,changed filtering method on suggested transfers to allow more options "

v1.96 6/30/2011 Zack McAnally

"add prompt in item details when cost > retail,added name to plu changes pop up and change sort order to descending Procs affected: upPLU_Changes_GetAll_ByPL,added option in support utilities to import UPC file for WV liquor (option G,created indexes to speed up item analysis (use ItemAnalysisRecommend.sql,changed query for buydown sales report to filter on server side instead of report side Procs affected: upReports_BuydownSales_ByManu,changed query for buydown screen to sort by name Procs affected: upBuydowns_GetAll,created Transfers Report that shows all transfers for a specified filter,fixed bug in specialty pricing where discount price by was being multiplied by 100 on initial load,changed speciality pricing label so only the pct or dollar label show up when using mix/match"

v1.97 7/8/2011 Zack McAnally

"modified filter for Transfers report to exclude store x Procs affected: upReports_InvAdjustments_NoFilter_ExcludeXFerStor,upReports_InvAdjustments_ByCategory_ExcludeXFerStore upReports_InvAdjustments_ByDept_ExcludeXFerStor,upReports_InvAdjustments_ByMajorCat_ExcludeXFerStore upReports_InvAdjustments_ByManuf_ExcludeXFerStor,upReports_InvAdjustments_ByProdGroup_ExcludeXFerStore upReports_InvAdjustments_ByReportGroup1_ExcludeXFerStore,upReports_InvAdjustments_ByReportGroup2_ExcludeXFerStore upReports_InvAdjustments_ByReportGroup3_ExcludeXFerStor,upReports_InvAdjustments_ByReportGroup4_ExcludeXFerStore upReports_InvAdjustments_BySubGroup_ExcludeXFerStore"

v1.98 7/12/2011 Zack McAnally

"Added ability to lookup item by vendor part in popup screens (item analysis, etc) Procs affected: upPLU_GetForGrid_ByVendorPar,added logic to log initial add of an item as price change so it shows up in PLU_Changes history "

v1.99 7/21/2011 Zack McAnally

"added back in group by x to item sales report "

v1.100 7/25/2011 Zack McAnally

"changed group by dept in item sales so that it sorts by department numbe,added user utility to refresh invoice header totals in case they get out of sync with invoice detail,changed inv_eval to use prcdata cost/retail in certain instances Procs affected: upReports_InvEval_ByCategory upReports_InvEval_ByDept,upReports_InvEval_ByDeptGroup upReports_InvEval_ByMajorCat upReports_InvEval_ByManuf upReports_InvEval_ByProdGrou,upReports_InvEval_ByReportGroup1 upReports_InvEval_ByReportGroup2 upReports_InvEval_ByReportGroup3 upReports_InvEval_ByReportGroup,upReports_InvEval_BySubGroup upReports_InvEval_ByUPC upReports_InvEval_NoFilter upReports_InvSnapShot_ByCategory upReports_InvSnapShot_ByDep,upReports_InvSnapShot_ByDeptGroup upReports_InvSnapshot_ByMajorCat upReports_InvSnapShot_ByManuf upReports_InvSnapShot_ByProdGrou,upReports_InvSnapshot_ByReportGroup1 upReports_InvSnapshot_ByReportGroup2 upReports_InvSnapshot_ByReportGroup3,upReports_InvSnapshot_ByReportGroup4 upReports_InvSnapShot_BySubGroup upReports_InvSnapShot_ByUPC upReports_InvSnapshot_NoFilter"

v1.101 7/26/2011 Zack McAnally

"modified Negative Cashier Report to group/sort by receipt number so transactions will be by date range instead of type then date range,fixed bug where not all buttons in item details and mass updates were not disabled when login was set to rea,changed timeclock UI and reports to support accounting format Procs affected: upTime_Clk_GetAll_ByDate upTime_Clk_GetAll_ByDateAndEmployee upTime_Clk_GetAll_ByStoreAndDat,fixed bug in void count/void value where if non-tax flag was applied,voids had a mode_flag of 4097 instead of 2 Procs affected: upReports_RegZ_GetVoidsCount upReports_RegZ_GetVoidsValue upReports_NegCashier_GetVoids upReports_NegCashier_GetVoids_ByPL,changed item details so that when saving it creates a PLU record for each store regardless of zone in case some non pricing attribute changed (description, discount, etc,began implementing EDI with Coremark "

v1.102 8/2/2011 Zack McAnally

"began implementing the new Help System,began implementing EDI with RC Taylo,added ability to mass print register Z's for multiple stores by date range or all Z's in range "

v1.103 8/8/2011 Zack McAnally

"added option to delete all old data first when sending store updates (updated WebService,added Tenders to store updates,added House Accounts to store update,changed PricebookZones in PRC_ADJ length to 250 (use AlterPricebookZones.sql,added ability to send CoreMark orders via EDI "

v1.104 8/10/2011 Zack McAnally

"changed lottery reconciliation to include store # in invoice header that is auto-created,changed Hardecs EDI to subtract 1 from store number when getting the store number from fil,added ability to put lottery games in a zone (use AlterLotteryGamesZones.sql,added ability to flag lottery games as active (use AlterLotteryGamesActive.sql) "

v1.105 8/15/2011 Zack McAnally

"added lottery reconcilation summary report (use CreatetmpLotteryReconSummaryDetails.sq,And CreatetmpLotteryReconSummaryOnline.sql) to create tables Procs affected: uptmpLotteryReconSummaryDetails_Delet,uptmpLotteryReconSummaryDetails_Insert uptmpLotteryReconSummaryDetails_Update uptmpLotteryReconSummaryOnline_Delet,uptmpLotteryReconSummaryOnline_Insert uptmpLotteryReconSummaryOnline_Update "

v1.106 8/23/2011 Zack McAnally

"implemented EDI reorders with RC Taylo,modified lottery recon details to upsert instead of insert Procs affect: upLotteryReconDetails_Inser,change recon filter to work off recon date instead of z date Procs affected: upLotteryReconHeader_GetAllByDateRange upLotteryReconHeader_GetAllByDateRangeAndStor,changed top sellers report to show dept name if plu desc is null (open departments) Procs affected: upReports_ItemSales_ByCategory,upReports_ItemSales_ByDept upReports_ItemSales_ByDeptGroup upReports_ItemSales_ByMajorCat upReports_ItemSales_ByManu,upReports_ItemSales_ByPLU upReports_ItemSales_ByProdGroup upReports_ItemSales_ByReportGroup1 upReports_ItemSales_ByReportGroup,upReports_ItemSales_ByReportGroup3 upReports_ItemSales_ByReportGroup4 upReports_ItemSales_BySubGroup upReports_ItemSales_NoFilte,added ability to apply cost changes only to a received invoice "

v1.107 8/29/2011 Zack McAnally

"Added Bin numbers to lottery recon (set at store level) Procs affected: upLotteryReconDetails_GetByReconGUID_ForGrid,upLotteryReconDetails_GetByReconGUID_ForGrid_BinSort upLotteryReconDetails_GetByReconGUID_ForGrid_Variance,upLotteryReconDetails_GetByReconGUID_ForGrid_Variances_BinSort "

v1.108 9/6/2011 Zack McAnally

"reset store drop-down list to "Select A Store" on transfers screen after applying "

v1.109 9/12/2011 Zack McAnally

"added option to reset store when creating new invoic,fixed bug when calculating adjusted cost in certain instances on item sales report Procs affected: upReports_ItemSales_NoFilte,upReports_ItemSales_BySubGroup upReports_ItemSales_ByReportGroup1 upReports_ItemSales_ByReportGroup2 upReports_ItemSales_ByReportGroup,upReports_ItemSales_ByReportGroup4 upReports_ItemSales_ByCategory upReports_ItemSales_ByDept upReports_ItemSales_ByDeptGrou,upReports_ItemSales_ByMajorCat upReports_ItemSales_ByManuf upReports_ItemSales_ByPLU upReports_ItemSales_ByProdGroup,changed QOH textbox in itemdetails to a link that pops up showing the QOH breakdown based on selected store,added inactive checkbox to item details screen,added option to flag items as inactive in mass updates (utilities tab in mass updates),added inactive tab to priceboo,added inactive item wizard that will help identify what items are inactive (inactive items tab in pricebook),added inactive PLU logic to filters (inactive items won't show up in mass updates,,any type of inventory, reorder) Procs affected: upInactivePLU_GetForGrid_All upInactivePLU_GetForGrid_ByDescription_Contains,upInactivePLU_GetForGrid_ByUPC upPLU_UpdateActive upPLU_GetPLUDetails_SinglePLU upPLU_GetPLUDetails_SinglePLU_Corp upPLU_GetForGrid_,upRcvData_GetAll_ByUPC upReports_ItemAudit_GetCycleCountsBatch_NoStore upReports_ItemAudit_GetCycleCounts_NoStor,upReports_ItemAudit_GetInventoryReconcile_NoStore upReports_ItemAudit_GetSales_NoStore upInv_Def_GetItemsByName_* upReorder_CreateOrder_ListItems_,added logic to disallow a negative qty in the transfers scree,changed the vendor part cost textbox to readonly to avoid confusion since the part_cost is pulled from the item and doesn't actually have on,changed consistent ordering requirements to support pure qty instead of just percentage based (Use AlterKeyItemsDef.sq,And UpdateKeyItemsDefDefaultValues.sql) Procs affected: upKeyItemsDef_Insert upKeyItemsDef_GetByType upKeyItemsDef_GetByDefGUID upKeyItemsDef_GetAl,changed order schedule to match new consistent ordering requirements options (use AlterReorderScheduleForKeyItems.sql,Procs affected: upReorderSchedule_GetAll upReorderSchedule_GetByRunDay upReorderSchedule_Inser,added setting to ini file & settings screen to set default filter for Find Item form (Description, UPC Number or Vendor Part,added setting to ini file & settings screen to toggle the sanity check for large date ranges on some reports "

v1.110 10/03/2011 Zack McAnally

"reset store drop-down list to "Select A Store" on adjustments screen after applyin,changed mass printing by Z's in reg z report to sort by store #, then reg # then z #,added option to group media detail report by register # (both summary & detail,changed password prompt in cyclecounts to be masked and be based of the current user's password when setting uncounted to actual,fixed bug in venfor parts query involving pik-a-pak items not showing correctly Procs affected: upMultVend_getByVendor,upMultVend_FilterByDescription upMultVend_FilterByUPC upMultVend_FilterByVendorPart upMultVend_GetAl,upMultVend_getByPartandVendor upMultVend_GetByRowID upMultVend_getByUPC upMultVend_getByUPCandVendor,fixed bug in eJournal report where no sales were not showing correctly,changed format of tenders in eJournal report to only show 2 decimal places,changed negative cashier report to show dept name on open dept entries Procs affected: upReports_NegCashier_GetReceiptDetail,changed negative cashier report to not show the cashier name in summary if there was no negative receipts Procs affected: uptmpNegCashierReportMain_Delete,added the summary values to the header & summary report for negative cashier (use AltertmpNegCashierReportMain.sql) Procs affected: uptmpNegCashierReportMain_Updat,added store number to receipt details of negative cashier report,added option to hide items with a zero qty in inventory adjustments report,added counted by field to each cycle count report to show all the people who counted it Procs affected: upCycleCountDetails_GetCountedBy,added definition field to each cycle count repor,added definition field to scan order repor,added definition used to the caption of the cycle count workshee,resized inventory movement report to be 8p,added support for POS accounts (new tab in maintenance) Procs affected: upAccount_Delete,upAccount_DeleteByNum upAccount_GetAll upAccount_GetByID upAccount_Update upAccount_Upsert,rearranged reg z report so if running by date range or for multiple Z's, the list of Z's included is on the last pag,added time clock report to list reports so you can allow users to run w/o giving them access to maintenance tab Procs affected: upTime_Clk_GetAll_ByDateAndMultipleEmployees"

v1.111 10/13/2011 Zack McAnally

"fixed bug in item sales report when the report was not grouped, it still attempted to pass in the group parameter"

v1.112 10/17/2011 Zack McAnally

"added logic to import files for Steve Douglas install (Type H in Support Utils) "

v1.113 10/24/2011 Zack McAnally

"fixed bugs where in some maintenance screens an error was thrown if you clicked an empty grid (no details to show),added ALT PLU to PLU list tree report in mass updates Procs affected: upPLU_GetForGrid_*,fixed bug when adding POS flag the random weight flag was getting set to NULL "

v1.114 11/3/2011 Zack McAnally

"began EDI support for Gatewa,changed Renfro EDI to support multiple invoices in the same EDI file,added ability to update order schedules Procs affected: upReorderSchedule_Update,began implementing modifications for Adjustments/Transfer changes (use CreateAdjustmentDetails.sql & CreateAdjustmentHeader.sql) Procs affected: upAdjustmentDetails_* upAdjustmentHeader_* "

v1.115 12/12/2011 Zack McAnally

"finished implementing modifications for Adjustments/Transfer changes "

v1.116 12/13/2011 Zack McAnally

"added check for items at store before applying invoice (requires new webservice at store,added ability to "ping" stores from Dash in case store's VPN connection is sleepin,added ability to save/apply templates in EDI setup,added option to disable queue history (show completed button - use settings to modify),modified transfer/adjust details grid to show extended cos,modified transfer/adjust details grid to move grid to bottom of screen,added ability to mass update buydown fields (amount & dates) Procs affected: upBuydowns_UpdateAmount upBuydowns_UpdateAmountAndDates upBuydowns_UpdateDate,added store name and number to negative cashier report,change formatting of cashier numbers in neg cashier report to remove comm,added invoice history from vendor part screen for selected vendor part Procs affected: upRcvData_GetTop10ByVendorPar,upRcvData_GetTop10ByVendorPartAndStore upRcvData_GetByVendorPartAndDate upRcvData_GetByVendorPartAndStoreAndDat,added abiliy to switch to UPC details from vendor part screen (link in vendor part details) "

v1.117 12/13/2011 Zack McAnally

"fixed bug in adjustment header where notes were not always being shown,modified transfer/adjustment entry to allow vendor part numbers to be entered (it searches for UPC first, then vendor part,modified transfer/adjustment details to allow editin,modified transfer/adjustment to disable everything but print once applied "

v1.118 12/19/2011 Zack McAnally

"modified inventory movement report to show xfer store Procs affected: upReports_ChronMovement_AdjustmentFro,upReports_ChronMovement_Adjustments upReports_ChronMovement_AdjustmentTo upReports_ChronMovement_SpotCheck,upReports_ChronMovement_CycleCounts upReports_ChronMovement_Invoices,fixed bug in inventory movement report where total cost was not being calculated correctly,added total to gift card balance repor,extended store list label & changed Can Grow propterty to true in all INV EVAL reports to keep long ones from cutting of,added report to suggested transfers screen based off dataset (crosstab style,began implementing mass update by pricebook zone (new tab in mass updates) "

v1.119 12/20/2011 Zack McAnally

"added ability to crate a negative item inventory definition (requires new webservice at store) Procs affected: upInv_Def_GetItemsByName_Negative"

v1.120 2/8/2012 Zack McAnally

"modified mass updates -> coupons to take into account points Procs affected: upPLU_UpdateCoupon"

v1.121 2/13/2012 Zack McAnally

"added support for EDI with Sledd (local files) "

v1.122 2/14/2012 Zack McAnally

"modified EDI support with Sledd to correctly archive file "

v1.123 2/20/2012 Zack McAnally

"fixed bug in Gateway EDI where the screen was not properly hiding when showing items to be added "

v1.124 2/21/2012 Zack McAnally

"added option in INI settings to disable editing applied invoice (DisableEditingAppliedInvoices,changed the set uncounted to expected qty in cycle counts to Admin only logins,changed the negative cashier report to show the number of items voided/returns instead of number of receipt,changed the negative cashier report to show the value of the voided items themselves rather than the receipt total,added <= 0 filter to inventory evaluation report (less than or equal to zero) Procs affected: upReports_InvSnapshot_* upReports_InvEval_*,added store number field to eJournal repor,added ability to set base zone when adding new pricebook zon,replaced the AVG COST field in the item sales reports with DISCOUN,created new cycle count batch worksheet report for aid in counts w/o a handhel,added option to group orders/working orders by department when printin,modified Register Z report to show grid with all Zs included at the bottom instead of string list of Z,fixed bug in reorder where the cost was not getting multiplied by the vendor part qty in certain circumstances,fixed bug in Ejournal report where the register number was not getting set for no sales in certain circumstance,added ability to import flat file from Douglas (Format I,added ability to import sales data directly from access database instead of just XML files,fixed bug in crosstab by day of week report where the day could be off due to leap yea,fixed bug where the XFer to was not displaying correctly in certain cicrumstances in chron movement report Procs affected: upReports_ChronMovement_AdjustmentT,added option to hide zero entries in summary version of inventory adjustments report,created an option to run timeclock report from Reports -> List Reports so that it can be ran at store level easier "

v1.125 2/26/2012 Zack McAnally

"added ability to sort inventory evaluation report by description or UPC number,changed sales in dash to take out discounts Procs affected: uptmpPerformance_GetSalesToPopulat,changes sales in dash to only show active store,fixed bug in dept sales drilldown where the cost was not being summed correctly on drilldown in certain scenario,fixed bug in invoice detail report where the retail each was not taking pbook zone into account in certain scenarios Proces affected: upReports_InvoiceDetai,added support for sending Sledd orders via FTP,added notification prompt in store mode after invoice has been applied,enabled ability to delete from inactive items screen"

v1.126 2/27/2012 Zack McAnally

"modified Gateway EDI to get cost each from total cost column instead of cost each column for discount,added support for Sledd EDI receiving via FTP "

v1.127 2/29/2012 Zack McAnally

"changed reorder EDI with Sledd to use a different login than EDI receiving with Sledd "

v1.128 2/29/2012 Zack McAnally

"added combined total to register Z report to show netsales + depts not added to sale,added option to group department sales report by department group Procs affected: upReports_ItemSales_,added option to group item sales report by department group "

v1.129 3/1/2012 Zack McAnally

"added option to filter customer activity report by only house accounts Procs affected: up_Customers_GetHouseAccounts,altered customer activy filter logic to use spacing between dash to avoid issue with customers with dash in ID,altered Sledd EDI logic you use a combination of storenumber and ponumber for the EDI file name "

v1.130 3/15/2012 Zack McAnally

"changed adjustlog entries when you back out invoice at store level to show negatives,disabled save button after saving invoice on invoice worksheet "

v1.131 3/26/2012 Zack McAnally

"added ability to make cycle counts batch blind in both pda,And director (use AddCycleCountBlind.sql and AddCycleCountBlind_DirectorLogins.sql,Procs affected: up_Employee_Upsert up_Employee_Update up_Employee_Insert upEmployee_GetAll upEmployee_GetAll_Active upEmployee_Inser,upEmployee_SingleEmployee upEmployee_SingleEmployee_ByNum upEmployee_Update upEmployee_Upsert upDirectorLogins_GetAll upDirectorLogins_GetSingle,upDirectorLogins_GetSingle_Nopassword upDirectorLogins_Insert upDirectorLogins_Update upDirectorLogins_Upsert "

v1.132 4/02/2012 Zack McAnally

"added ability to group inv eval report by Department Group/Department "

v1.133 4/04/2012 Zack McAnally

"added support for new daily reconciliation (use AlterRegReconcileAddNewTypes.sql,AlterTenderAddReconBucket.sql, CreateDailyReconcile.sql,,CreateDailyReconcileDetails.sql,,UpdateTenderSetDefaultBuckets.sql) Procs affected: upDailyReconcile_* upDailyreconcileDetails_* upRegReconcile_*"

v1.134 4/05/2012 Zack McAnally

"changed dash to take discounts out of net sales Procs affected: uptmpPerformance_GetSalesToPopulat,added store number to invoice summary report Procs affected: upReports_InvoiceSummary_ByVendo,added ability to sort item sales report by either description or UPC numbe,added totals to the lottery reconciliation summary repor,fixed bug in buydowns where the time was not being sent to the XML queue file in certain situation,added department name to negative cashier report open departments "

v1.135 4/09/2012 Zack McAnally

"modified Coremark EDI to use shortened format for account number when no PO is presen,added promo discounts to discounts in dept sales repor,added ability to run manuf sales report by all trees,added ability to show pre/post receipts in negative cashier report "

v1.136 4/17/2012 Zack McAnally

"modified coupon setup to use new forma,modified mass updates, coupons to support new format,modified store mode inventory where it will not prompt to backout qty if unapplied,changed label in receiving worksheet from Cost Each to Part Cost to avoid confusio,fixed bug in Reorder where cost each was being multiplied incorrectly in certain circumstances,modified receiving worksheet to reflag corp exported to 0 when applied Procs affected: upRcvDef_UpdateCorpExported "

v1.137 5/7/2012 Zack McAnally

"added vendor part info to item analysis screen,added ability to double click in lookup field in item analysis and it will populate with UPC prefix "

v1.138 5/14/2012 Zack McAnally

"modified warehouse integration to have it's own EDI path "

v1.139 5/16/2012 Zack McAnally

"added QOH to lottery reports,added store number to Moutain EDI preview list"

v1.140 5/18/2012 Zack McAnally

"EDI receiving now remembers the last vendor used,Warehouse EDI archives file after processing,removed test "BUTTON" from message preview,removed msgbox after sending good message "

v1.141 5/23/2012 Zack McAnally

"added auto sending of EDI when scheduling orders (use AddAutoSendEDIToReorderSchedule.sql) Procs affected: upReorderSchedule_*"

v1.142 5/25/2012 Zack McAnally

"exposed Expand8DigitCode from INI file in settings popup "

v1.143 5/29/2012 Zack McAnally

"added option to get cost from DEPT for open dept sales in department sales report "

v1.144 6/6/2012 Zack McAnally

"added ability to send reassigned PLUs to stores using message attachement "

v1.145 6/11/2012 Zack McAnally

"created comparison sales report (use Create_tmpComparisonSalesReport.sql) Procs affected: upReports_ComparisonSales_,added QOH label in receiving worksheet to show current QOH of received ite,modified mass update price changes so that when changing multiple zones, each individual zone is evaluated and changed accordingly "

v1.146 6/20/2012 Zack McAnally

"changed lottery activations to force a vendo,changed queue to allow scheduling of multiple item,added setting to disable clearing of QOH (store mode only),changed item analysis is store mode to only show current store and get QOH locally instead of using webservice (same result, just quicker) "

v1.147 6/28/2012 Zack McAnally

"added cost to mass update by pricebook zones,fixed bug where duplicates where possible in reassign PLU logic "

v1.148 7/6/2012 Zack McAnally

"modified the Kebob feed to include pricebook zone "

v1.149 7/10/2012 Zack McAnally

"modified non-sellers report to add last sales date,days in inventory,date adde,And qty sold based on threshold Procs affected: upSales_LastSaleDate_ByPLUAndStore upSales_FirstInvoiceDate_ByPLUAndStore upSales_FirstAdjustlog_ByPLUAndStore,changed the stores for updating/reporting list to be saved to the INI file instead of the DB so multi-users don't worry about stepping on toes - added the option of rolling up subunit links into the purchase unit in the item sales repor,added the option of showing cost changes in the item sales report (before it always defaulted to true) "

v1.150 7/11/2012 Zack McAnally

"modified non-sellers report to take into account purchase/subunit sale,modified non-sellers report to show status label as it processes "

v1.151 7/11/2012 Zack McAnally

"added support for vendor return worksheets,modified Daily Recon report to show modified format with new fields "

v1.152 7/19/2012 Zack McAnally

"modified adjustments made from lottery worksheet so that they go into adjustment header/details format instead of just to queu,modified invoices created from lottery worksheet so that the invoice date is the recon date instead of the current dat,added net online sales to lottery recon reports (online sales - online cancels) "

v1.153 8/11/2012 Zack McAnally

"modified daily recon report to show manager entered deposit amounts as actual deposit amounts instead of cashier entered amounts "

v1.154 8/16/2012 Zack McAnally

"modified time clock so when in store mode changes are flagged to be resent,modified time clock so when in corp mode changes are sent to store,modified time clock to support ManualEntry field,fixed bug where EDI invoice number was not being pulled in certain circumstances for Warehouse FTP invoices "

v1.155 8/17/2012 Zack McAnally

"added support for Powers EDI (uses active mode FTP,required ChilKat.dll) - modified sales tax report to show total sale,modified sales tax by day report to show total sales "

v1.156 9/10/2012 Zack McAnally

"added ability to lockout departments for house account,added out of stock report to show items that have 0 QOH that have sold in selected date rang,modified adjustments so cost/retail is based on selected store zone instead of default zon,modified transfers so cost/retail is based on from store zone instead of default zon,modified previous adjustments grid so you can doubleclick a row to view/edit,modified previous transfers grid so you can doubleclick a row to view/edit,modified previous invoices grid so you can doubleclick a row to view/edi,modified previous order grid so you can doubleclick a row to view/edit,modified previous working orders grid so you can doubleclick a row to view/edi,modified previous cycle count grid so you can doubleclick a row to view workshee,added option in customer activity report to show all sales VS only show charge,added ability to import Big Smoke pricing file "

v1.157 9/26/2012 Zack McAnally

"added Reconciliation Bucket to tender file that is sent via store update,added ability to mass change pricebook zones for buydown,added option in queue to show/hide scheduled updates,moved EDI setup button to base of Vendor maintenance,modified EDI setup so that the EDI Data 1 & 2 labels show what is expected (FTP Site, Folder, etc) and are hidden if the EDI type doesn't need the,exposed PRINT_BARCODE field in Item Details as "Print Label" checkbox (barcode report will optionally filter off it,modified the barcode/shelf tag report to optionally hide items not flagged to "Print Label,fixed bug in barcode/shelf tag report where dataset was allowing same item twice if multiple filters were used,fixed bug in barcode/shelf tag report where the report could not be ran twice successively without refreshing the screen,modified Powers EDI to include the account type (EDIData2) as a prefix in the filename,modified the invoice header (RCV_DEF) to include a InvoiceNotes fiel,added support for InvoiceNotes in invoices (Create & Worksheet,added support for InvoiceNotes in Invoice Detail repor,fixed bug when converting vendor return worksheets to invoices where the line total cost was using the item cost fiel,modified vendor return worksheets to include some notes when converting to invoice,modified receiving to support receiving the same item on multiple lines (new webservice required,modified Gateway EDI to support returns of "broken cases,added "Reviewed" flag to cycle counts to allow Corp to flag them after they've checked the,modified cycle count worksheet to support "Reviewed" fla,implemented first phase of scheduled reports (Cost Change and Manual Time Clock entrie,new scheduler.exe required,modified Time Clock maintenance to show manual entry field,added manual entry to time clock reports "

v1.158 10/3/2012 Zack McAnally

"created worksheet version of the cost change report that allows price changes to made from within it "

v1.159 10/9/2012 Zack McAnally

"modified messages to accept attachments (PDF only right now) and it will store them in DB and launch default viewer "

v1.160 10/12/2012 Zack McAnally

"fixed bug in timeclock report; Accounting format was showing incorrectly after recent changes"

v1.161 10/18/2012 Zack McAnally

"modified pricebook zone maintenance so it add/deletes vendor parts now,added status label when adding pricebook zone to give user feedback as it's a long running process,added vendor filter to purchase analysis repor,added option to group by store in purchase analysis report,changed purchase analysis primary font size to 8pt "

v1.162 12/3/2012 Zack McAnally

"added support for McDowell supply ED,added option to run eJournal report by check numbe,added option to run eJournal report by sale amount,added support utility to update subunit link,fixed bug in Mass Updates where mass updated cost changes weren't tricking down to subunits when updating multiple zones,fixed bug in Mass Updates where mass updated cost changes weren't updating vendor parts in all situation,changed ALL screen sizes to support maximizing and resized to fully support 1024x768 "

v1.163 12/10/2012 Zack McAnally

"fixed bug in screen resizing in item details "

v1.164 12/28/2012 Zack McAnally

"moved queue from being XML file based to it's own database. All queue entries are now stored there (requires FasTraxQueue database,modified account setup to allow setting of cost+ discounts,fixed bug in sending down accounts where the DOB was not getting set "

v1.165 1/10/2013 Zack McAnally

"modified store picker for reports/changes to allow selection by zone,modified worksheet vendor returns to get,modified worksheet vendor returns to get cost based on store zone "

v1.166 1/11/2013 Zack McAnally

"added department sales to scheduled report,added register z to scheduled report,added ability to send any report via messages from the report preview "

v1.167 1/14/2013 Zack McAnally

"begin implementing Dash Report "

v1.167 1/15/2013 Zack McAnally

"enabled minimize button on main container form "

v1.168 1/15/2013 Zack McAnally

"finished implementing Dash Repor,wired up zone copy functions from Mass Updates to allow copying of selected items between zones (now supports add/subtract $ and add/subtract %)"

v1.169 2/7/2013 Zack McAnally

"modified Gateway EDI to support same item on invoice more than once "

v1.170 2/8/2013 Zack McAnally

"modified mass updates to show cost to 3 decimals,modified receiving grid to show cost to 3 decimals,modified receiving report to show cost to 3 decimals,modified cost change worksheet to show cost to 3 decimal,modified cost change worksheet to allow the changing of part cost and item cost in addition to retail "

v1.171 2/11/2013 Zack McAnally

"added InvoiceSurcharge field to receving header and receiving report,modified Mass Updates to show vendor part # and part cost for selected vendo,created custom executive summary report that shows sales, labor hours and shrink by week "

v1.172 3/11/2013 Zack McAnally

"added option to run item sales grouped report in summary mod,added option to run item sales grouped by store report in summary mode,added ability to edit vendor part cost from item details "

v1.173 3/13/2013 Zack McAnally

"fixed bug in mass updates where in certain instances vendor part cost was not being multiplied by # units when updating costs "

v1.174 3/19/2013 Zack McAnally

"added ability to refresh QOH in vendor return worksheet (connects and pulls from store,began Harrison EDI "

v1.175 3/22/2013 Zack McAnally

"finished Harrison reorder ED,added ability to run buydown report with details "

v1.176 4/4/2013 Zack McAnally

"fixed bug when adding coupon to items via mass updates,fixed bug in undo changes from mass updates were the cost was not always rolling back "

v1.177 5/1/2013 Zack McAnally

"added option to show invoice data and custom 4 lines to the transfer repor,added price list export to the scheduled reports and mass updates "

v1.178 5/13/2013 Zack McAnally

"modified receiving's original cost to use vendor part cost instead of prc_data cost to fix issue with the cost change report"

v1.179 5/15/2013 Zack McAnally

"added option to print header lines on invoice report (change in settings) "

v1.180 5/18/2013 Zack McAnally

"fixed bug in printing header lines on invoice report (too many characters were allowed)"

v1.181 5/22/2013 Zack McAnally

"changed receiving to prompt when entering a UPC that has a vendor part "

v1.182 5/24/2013 Zack McAnally

"fixed bug where cost changes applied from receiving were still being written to old queue XML files instead of new database "

v1.183 5/29/2013 Zack McAnally

"modified cost change worksheet to show vendor / vendor part "

v1.184 5/31/2013 Zack McAnally

"modifed so that tender buckets are being sent when seding down tenders (DB schema update 3) "

v1.185 6/15/2013 Zack McAnally

"added option to run eJournal report in "receipt" mode, which shows a pseudo receipt for chargebacks "

v1.186 7/11/2013 Zack McAnally

"added ability to receive Powers invoices from local files instead of just FTP "

v1.187 8/7/2013 Zack McAnally

"added ability to import Richmond Masters data file"

v1.188 8/9/2013 Zack McAnally

"added ability to import Richmond Masters change log data file"

v1.189 8/20/2013 Zack McAnally

"added Richmond Masters EDI to reorder / receiving "

v1.190 9/06/2013 Zack McAnally

"added option to only send single vendor's parts down when using mass updates -> store updatin,added checkbox to cost change worksheet to select items for printing"

v1.191 9/15/2013 Zack McAnally

"fixed bug in EDI with Gateway regarding PLU_QTY on returned item,added ability to add items via compare items in user support utils,added ability to compare pricebook zones in mass updates "

v1.192 9/20/2013 Zack McAnally

"added print option for compare pricebook zones utility "

v1.193 9/23/2013 Zack McAnally

"added EDI for FTP FinTech (just like Powers, except dynamic FTP folder)"

v1.194 10/2/2013 Zack McAnally

"fixed bug in formula for AvgRetail on Tope Sellers Repor,fixed bug where class was not saving in item details screen "

v1.195 10/3/2013 Zack McAnally

"added EDI support for WV ABC"

v1.196 10/4/2013 Zack McAnally

"added support for importing Low Bob item file in support utils "

v1.197 10/7/2013 Zack McAnally

"added ability to input total cost instead of cost each when inputing invoice items on invoice worksheet screen "

v1.198 10/8/2013 Zack McAnally

"modified Manuf Sales Report to take into account buydowns for price each,modified EDI for FinTech to use Sledd format instead of Powers "

v1.199 10/11/2013 Zack McAnally

"modified invoice summary report to validate vendors selected,modified invoice summary report to not filter by vendor if all vendors are selected "

v1.200 10/11/2013 Zack McAnally

""

v1.201 10/11/2013 Zack McAnally

"fixed bug where xfer/adjustments permissions were not correctly set "

v1.245

"began work on new style system discount,Added override reorder type to departmen,added support for open priced item (prc_data pricetype 5,added non sellers multi store Report,added option to filter inv eval report by bad margins (cost > retail) "

v1.246

"modified PM report to add control lin,Added ability to increase qty on order by % "

v1.247

"added option to show old cost in invoice detail repor,added logic to check corporate for other stores QOH when in store mode and QOH label is clicked"

v1.248

"added EDI support for FTP - Capito,modified buydowns and PM retail report to allow selecting of which buydowns to include in retail scan data repor,modified employees to allow entry of payrollid and payrollcompany for export feed "

v1.249

"added import utility for multiple zone support,moved reorder logging to it's own folder and each order gets a unique file "

v1.250

"fixed bug in reg z report where tax information wouldn't show if the total tax amount was less than zero"

v1.251

"fixed bug where cash was always showing in media detail report,added active sledd FTP EDI option "

v1.252

"added Snus items to the PM scan report filte,began work on alternate vendor part stuff for reorde,fixed bug in Working orders where it wasn't taking the vendor part into account when adding items to the order (only UPC #,fixed bug where the QOH shown in the adjustlog was incorrect causing an issue with the adjustlog repor,fixed bug in negative cashier report where if a receipt contained 2 types of negative items, it would show the items twic,fixed bug in suggested transfers where the current high sale store wasn't always being flagged,added kit support for EDI receiving via Sled,fixed bug in mass updates where specialty priced items were being incorrectly updated when doing an update directly in the grid "

v1.253

"added support for alternate vendors on orders"

v1.254

"Modified daily recon to support food stamps and starting till "

v1.255

"added fields for food stamps reconciliation "

v1.256

"modified promos in retail scan data report"

v1.257

"hard coded buydowns to start at midnight and stop at 11:59 P,added dropdown list to allow user to specify rounding in replenishment order,added support for aliases in receiving and finditem form "

v1.259

"fixed negative cashier report bug where returns don't show properly "

v1.260

"added support for pct discount value/qty in daily reconciliation,added support for cycle count variance in daily reconciliation,fixed bug when mass applying cost change to vendor parts where part qty was not being multiplied for secondary zones,fixed bug in item details where read only user could manipulate vendor parts,added support for scanned manufacturer coupons in ejournal repor,added support for scanned manufacturer coupons in negative cashier repor,fixed bug in negative cashier report where cancels were not being shown if they were the only detail type chosen,fixed bug in negative cashier report where detials would duplicate if more than one negative type was on the receipt "

v1.261

"cleaned up find item code"

v1.262

"fixed bug in inventory evaluation report where in some scenarios incorrect PB zone was being used in the details vie,fixed bug when adding remote sales using POS v2 "

v1.263

"added custom EOD shift report for JR "

v1.264

"added support for manual order vendor parts flag in reorder logi,added support for do not order flag in order details and working order details,added ability to merge working orders"

v1.265

"added payins/payouts to accounting feed "

v1.266

"added support for renfro EDI via FTP,added option to group dept sales report by store detail,added sums to QOH column in all item sales reports "

v1.267

"modified buydown report to run off GUID to ensure accuracy (instad of buydown name,added kit support to JML EDI,fixed bug when receiving by vendor part and UPC on the same invoice "

v1.268

"added support for carton counts by manufacture,fixed bug in negative cashier report where filter could contain too many items and not return all results"

v1.269

"added ability to import just a retail price file,added support for lottery variance in daily reconciliation report "

v1.270

"fixed bug in dashboards where YTD and MTD dates were sometimes using wrong dates,added ability to mass change cigar costs/retail based on another zones cos,fixed bug when printing 13 digit barcodes via Dymo,fixed bug where reg z customer count was including safe drop,fixed bug in RM accounting feed where NULLS were not always being handled "

v1.271

"merged old system discounts in with new system discounts so only one director is actively worked on no,added commissions module (campaigns and reports,added transfer analysis link from item details to show QOH/Sales info of all stores for a single ite,added slow sellers report option to non sellers report,made columns in order screens moveable,moved tax exempt sales to proper line in sales tax reports "

v1.272

"added locking mechanism to prevent cycle count worksheets from being opened more than once,added reconciled flag to each cycle count item to prevent duplicate saving,added ability to edit/send POS settings from corporate,added cyclecountGUID to adjustlog entries in cycle counts "

v1.273

"added ability to merge orders "

v1.274

"cleaned up mass update preview screen logic "

v1.275

"added ability to apply cigar mass changes to queue "

v1.276

"added department check when showing item details and tells user if item's department doesn't exist instead of saying item not found "

v1.277

"added support for capitol EDI receiving to get store number based on account number from file name "

v1.278

"fixed typo in physcial inventory tab "

v1.279

"fixed bug in item sales grouped by department report where margins in grouping 3 where sometimes displayed incorrectly,fixed bug in employee maintenance where pos.receiving setting was not being persiste,fixed bug when adding POS panels to corp DB no chain ID was being set "

v1.280

"added supply line label type to Zebra label printing"

v1.281

"added ability to send campaigns/campaign items down via mass updates -> store updatin,changed PM report to use WinSCP to FTP file"

v1.282

"added support for DoNotPopDrawerForZeroDollarSales POS Settings entr,fixed bug when adding pik-a-pack specialty pricing the default standard price was persisting in certain scenario,added ability to send vendor part kits down via mass updates -> store updatin,removed unused options from POS Flag maintenance,fixed bug when adding vendor then resaving could cause overwritten data in certain scenarios "

v1.283

"fixed bug when added more than 250 chars to buydown stores,changed retail scan data report logic to not multiply store multi pack discounts out"

v1.303

"corrected issue support utils import skipping some parent units "

v1.304

"optimized schema change "

v1.305

"added list of multi scanned items to cycle count,corrected issue where multi scanned items could cause issue in cycle counts"

v1.306

"added sending of campaign items to queue via mass updates when mass adding "

v1.307

"corrected EDI issue with Coremark receiving and kit items "

v1.308

"added support for average costs in receiving "

v1.309

"added support for employee changes for new scheduling application "

v1.310

"added queue support for employee changes for new scheduling application "

v1.311

"added queue support for average cost "

v1.312

"added new label type (CLTS 3 Line Combo) for Zebra printer,changed RJR scan data report to support new PID fields,changed RJR scan data report to get item type from product code field "

v1.313

"corrected avg cost connection strings and updating empty dataset,added support for PM points campaign,modified PM report to get item type from product code fiel,modified PM report to support loyalty campaign,modified PM report to corrected issue with system discount reporting,added support for running PM system discount loyalty campaign along with another system discount "

v1.314

"corrected issue with avg cost and manual update when no record exist "

v1.315

"corrected an error with average cost,added an exception to ManuallyChangeAvgCostPopup "

v1.316

"added BusinessWorks Export to Report,Accounting Export "

v1.317

"changed buydown by invoice report to only reflect buydowns within the selected date range "

v1.318

"added ability to assign values to system discount items so that cartons and packs can coexist in same discount,added system discounts report (summary and detailed,corrected issue where Z report costs could be different from other reports costs (both date range and individual,modified CLTS Zebra barcode labels to show UPC number below barcod,corrected issue when saving vendor part kits for multiple zone,added summarized daily reconciliation report,added ability to print audited daily recon repor,added ability to print cycle count coverage report,added report showing when users dismissed safe drop dialog,corrected issue where time clock did not take time into account when filtering,sales grids are now hidden in store's dash if logged in user does not have sales report permission,added report showing orphaned vendor parts,added report showing items w/o vendor part,corrected issue where items with 0 cost cannot be applied when updating costs from receiving workshee,corrected issue where performance snapshot may not display all discounts,corrected issue where performance snapshot customer count could display inaccurate "

v1.319

"corrected issue where not all taxes were showing in the ejournal repor,corrected issue where ejournal report did not show all food stamps tendere,corrected issue when receiving EDI via Capito,changed cycle counts to get correct cost"

v1.320

"changed system discounts to be store specifi,added campaign report (summary and detailed,corrected issue where cancelled sales show as negative in certain scenarios in negative cashier report,added validation to force numeric entry when setting employee password,corrected issue where store mode dash was not taking all discounts into account when showing previous sale,modified daily recon report to show audit data from audit screen,store mode dash now hides sales numbers if logged in user doesn't have salesreport permissio,when removing a store from price exception, queue records are now created to push back original pric,modified retail scan data report to include new loyalty fields,added ability to update invoice surcharge after invoice is applied "

v1.321

"added support for EDI receiving via AMCON (now drills down to account subfolders) "

v1.322

"corrected issue with FTP'ing RJR scan data repor,added tables for custom filter,corrected issue where ejournal report did not take all taxes into account "

v1.323

"added custom filter to mass update,added ability to run PM report based on new pdetail fields for loyalty/system discounts"

v1.324

"optimized ToDo items "

v1.325

"added option to include buydowns in inv eval repor,changed Zebra format for supply line label forma,optimized creation of ToDo list items when sent to store"

v1.326

"began framework for favorite reports "

v1.327

"corrected issue when saving employees "

v1.328

"corrected issue with inline cost/price updates in mass updates no longer being available in certain scenarios "

v1.329

"added number of receipts with a void to negative cashier report "

v1.330

"added quick search popup on all vendor selection screens "

v1.331

"corrected issue with deleting Average Cost records from the queu,added schedule option to system discounts so they will only fire on specified days/time,corrected error that prevented deleting employees"

v1.332

"corrected various typos / visual errors "

v1.333

"added initial support for enhanced loyalty "

v1.334

"corrected buydown sales by invoice date range issu,added ability to quickly add stores to buydowns/vendors/discounts from store maint screen "

v1.335

"changed top sellers report logic to help with timeout issues,added support for EDI via Amcon"

v1.336

"added support for RJR loyalt,added suport for panel sets so corporate could have panels for various stores types"

v1.337

"corrected issue in mass updates right click filterin,added option in mass updates to only send vendor parts for filtered item,cleaned up UI in custom ad hoc filter screen,corrected issue in mass updates custom filter were only up to 79 items were show,added ability to run reorder report grouped by departmen,added ability to schedule price changes from mass update,added ability to resend inavtive items down to store,corrected issue in enhanced loyalty campaign summary report where campaign name was incorrect in certain scenario,modified non sellers report to use pb zones if single store is selecte,corrected issue when printing Dymo labels from invoice where the qty field was not being used "

v1.338

"corrected issue when deleting item from item details aliases was using incorrect connection string"

v1.339

"began community page,building favorites label on all reports to "Add To Favorites" "

v1.340

"added RJR promo suppor,corrected isseue with transfer report issue where it could not be run twic,cleaned up RJR promo UI "

v1.341

"added support for FTP - HS Wholesale EDI "

v1.342

"added PLU inventory snapshot repor,corrected issue when drilling down into dept sales report where buydowns where not including in adjusted cost "

v1.343

"added custAccount for store number to PO Report,made RJR FTP port dynami,corrected YY issue in EDI for HS wholesal,continued work on FTX Community "

v1.344

"accounting updates for QB "

v1.345

"exposed option of enabling/disabling receiving without a vendor part,added ability to zero out the loyalty points for a campaig,corrected issue where item details charts where not in month order if there was a year overlap,corrected issue when adding mix/match items error was thrown in certain scenarios"

v1.346

"changed Dymo labels to print alias instead of UPC when an alias is present"

v1.347

"added ability to lock in tree views from item details "

v1.348

"changed item details to remember tree view preferences between lock checks,corrected issue in working order print where if there was no EDI information the report was blan,optimized discount schedule to only write selected stores to Queue,updated reports to realign columns so exporting to Excel would all line u,item details chart has been put into correct order "

v1.349

"changed PM report logic so that it does not flag MFG DEAL 3 if it was not a loyalty sale "

v1.350

"added support for reorder ED,FTP - Imperial - changed custom summary sales report to include vapor and beverages "

v1.351

"changed custom daily sales report to include tender 40,corrected issue when printing working order grouped by department without EDI data, the report was blan,corrected issue where average cost setting was not displayed in settings scree,optimized average cost popup screens and messages "

v1.352

"added support for enhanced loyalty tender multiplier,added support for enhanced loyalty balance points ratios "

v1.353

"modified EDI FTP Amcon to support different FTP credentials for order & receiving "

v1.354 - modified EDI FTP

"HS Wholesale to have dynamic file extension and sort by vendor part"

v1.355

"modified PM scan data for enhanced loyalty"

v1.356

"corrected issue where previous orders required an EDI record to print "

v1.357

"modified the transfer report with ability to filter based on the transfer type. "

v1.358

"corrected issue with Dashboard department sales "

v1.359

"optimized Store Dashboard, Hourly Sales Report, and Register Z report for customer count resul,modified Reconciliation Report "Customer count" verbage to indicate count is number of transaction,updated text fields to "Read-only" when editing invoices and Director is set to not allow deleting/editing applied invoices. "

v1.360

"created FTP-Alison for ED,optimized Top Sellers report creation "

v1.361

"corrected issue in department sales report for proper return reporting "

v1.362

"added support for importing QB pricebook file with links & vendor parts "

v1.363