Updates

RFWarehouse for Stone Edge Updates

v18.01 - 20 Mar 2019

  • GetSKUForScan now supports the Barcode field.
  • Added support for UPC, EAN, ASIN, ISBN, Text5, SupplierSKU, ManufacturersBarcode, and AliasSKUs as alternate barcodes.
  • PortaPrint 3.0.

v17.97 - 11 Mar 2019

  • Changes to RUSFullReport.

v17.94 - 22 Feb 2019

  • Update Unverified report.
  • PutAwayReport should include CDPutAway2 time.

v17.85 - 1 Feb 2019

  • Add total line to Receive log printout.

v17.82 - 24 Jan 2019

  • Make RUSReport compatible with lookbackDays.
  • Cycle Count Audit line changed to CDPutAway from SortPutAway.

v17.77 - 9 Jan 2019

  • CDPutAway2 program created.
  • MP2: Bug fixes.

v17.72 - 19 Nov 2018

  • Startup and Dimensions: If we are writing to all databases, then when looking up a SKU, check all databases.
  • MP2: Many updates and changes, e.g. Fetch alternate barcodes when looking up the order.

v17.25 - 10 Aug 2018

  • MP2: Save lastbox whether user is pickverify or not.

v17.24 - 10 Aug 2018

  • Restock updates.

v17.23 - 10 Aug 2018

  • MP2: Update LastBox when they use OOS. Other changes.

v17.18 - 3 Aug 2018

  • ScanPrint: Allow a "printer file suffix" to be specified on the command line.
  • RFRestock: Combine redundant CycleCountTransactions entries.

v17.15 - 20 Jul 2018

  • Working on RFRestock program.
  • Added DISCON to Price Tag Audit.
  • PriceTagAudit to ignore saleprice = 0.00.

v17.04 - 24 May 2018

  • Added PriceTagAudit to suite.

v17.02 - 21 May 2018

  • Sign: If requiring a complete pick, that is sufficient, don't need to check for PickEndTime or VerifyEndTime.
  • MP/MP2: When aborting, write PickEndTime for finished orders.

v16.96 - 27 Apr 2018

  • Add option to require complete pick to verify or sign.

v16.95 - 26 Apr 2018

  • MP2: Update qty on screen before requiring box scan.
  • MP2: Change suspend screen UI.

v16.91 - 23 Apr 2018

  • MP2: Use "high beep" for good box scan.
  • Pick Report: Truncate "skus picked" to one decimal point.

v16.90 - 23 Apr 2018

  • MP2: "Put in Box" prompt extend whitespace to end of screen.
  • MP2: Update pick report and employeePickedOrders report to use new data tables.
  • MP2: Built a new "order lookup" to use new tables. Also, save box number in multipick and show it in order lookup.

v16.87 - 14 Apr 2018

  • MP2: Better handling of resume and auto-resume. Change UX a little if qty is 10 or greater.
  • MP2: Don't do box prompt unless it's the last piece for the order.
  • MP2: Show unfinished orders at the end.

v16.85 - 10 Apr 2018

  • MP2: Show prior and following orders if it's the same SKU.
  • Excel Count: Added functionality to read from SEOM database.

v16.82 - 29 Mar 2018

  • Create MultiPick2.
  • MP2: Combine line items for same SKU on same order.
  • MP2: Keep track of quantity "skipped" in RFOrderPickDetails.
  • Fix bug in MultiPick inserting into RFOrderPickDetails.
  • Store pick sessions in RFOrderPickSessions and RFOrderPickDetails tables.

v16.78 - 8 Mar 2018

  • MultiPick. Cleaned up the box confirmation prompt screen.
  • Barcode Labeler V3.2u smaller font, more characters.

v16.77 - 5 Mar 2018

  • Fixed bug when confirming box scan in Multipick.

v16.66 - 6 Feb 2018

  • Added command line /qty1 to Excel Count.

v16.63 - 29 Jan 2018

  • ScanPrint: Add command line option to not ask for quantity (assume 1).

v16.60 - 23 Jan 2018

  • ScanPrint: Support employee last name and supplier sku.
  • Support employee last name in label printer templates.
v16.58 - 18 Jan 2018

  • Pick/MultiPick: Added option to default to Loc4 if there is quantity there.

v16.57 - 18 Jan 2018

  • ScanPrint: Add customizations via command line: program title, printer, epl/zpl template and preamble.
  • Change some whitespace to tabs. Refactoring some barcode printer code.

v16.55 - 12 Jan 2018

  • Do FIFO refactoring, refined FIFO costs for increments.

v16.54 - 10 Jan 2018

  • Verify: Added Text1 popup message.
  • Added config option for "verify pop up message from Text1" feature (not implemented yet).

v16.37 - 9 Nov 2017

  • Add product name to checkout report.

v16.35 - 8 Nov 2017

  • Checkout to verify OUT before IN, other bug fixes.
  • CDPutAway: Save statistics and add to putAwayReport.
  • Barcode Maker File, clarified instruction prompt.

v16.31 - 17 Oct 2017

  • RFCheck bugs fixed
  • Clarify wording in SortPutAway for 77

v16.28 - 12 Oct 2017

  • Web console: Add a PAB content report and a Checked out report.
  • Added RFCheckout program to SE suite, for checking equipment out of tool room.

v16.27 - 29 Sep 2017

  • Added a "ClearError" call before some SetErrorLine calls.
  • Fix to handle non-standard GS1-128 barcodes.

v16.24 - 27 Sep 2017

  • CycleCount: Allow locations longer than 13 characters when typed

v16.21 - 21 Sep 2017

  • Web Console: Disable "Submit" button on PO receipt to prevent double submit

v16.12 - 29 Aug 2017

  • AutoReceive: Option to print a summary log

v16.24 - 27 Sep 2017

  • CycleCount: Allow locations longer than 13 characters when typed

v16.21 - 21 Sep 2017

  • Web Console: Disable "Submit" button on PO receipt to prevent double submit

v16.12 - 29 Aug 2017

  • AutoReceive: Option to print a summary log

v16.11 - 29 Aug 2017

  • Verify: Write to the Packing table (optional)
  • RFReceive: Option to print a summary report at the end of a receive session
  • Added option to parse GS1-128 barcodes and just use GTIN

v16.07 - 16 Aug 2017

  • Barcode Maker File: Visual improvements to font
  • Barcode Labeler: Visual improvements to font

v15.91 - Jul 2017

  • Lookup/CycleCount: Account for PABQty in dependent-quantity mode

v15.90 - Jul 2017

  • BUGFIX: Fix an error in the query which updates the FIFO table

v15.72 - Jun 2017

  • CDPutAway: BUGFIX: Was possibly updating CDQty field incorrectly

v15.70 - May 2017

  • Web Console: Much longer timeout on submitting a PO receipt to handle long POs

v15.62 - May 2017

  • RFAssemble: Log activity better (to prepare for productivity reports in the future)

v15.61 - May 2017

  • Verify: BUGFIX: Was crashing when there was no printer to show

v15.46 - May 2017

  • New program: AutoReceive
  • Support adding records to FIFO table

v15.28 - Apr 2017

  • Web Console: Added a productivity report and a detail report for KitBuilder
  • Verify: Show label printer if printing labels
  • QLnPrint: Adjust horizontal spacing

v15.26 - Apr 2017

  • Pick/MultiPick/PickList: Can use location PPPPP to skip picking (like YYYYY and ZZZZZ)
  • ScanPrint: BUGFIX: Handle correctly when SKU not found

v15.16 - Apr 2017

  • Verify: Added ability to re-print a box barcode from the web mgmt console.
  • PortaPrint: Remember settings
  • PortaPrint: Truncate description at different lengths depending on label width

v15.15 - Mar 2017

  • Added new program ScanPrint

v15.10 - Mar 2017

  • Verify: When printing Amazon box-content barcodes, add ability to use ASIN, EAN, ISBN.

v15.07 - Mar 2017

  • Pick/MultiPick: Add option to automatically use first loction (in appropriate inventory mode)
  • Reserved UnShipped: Add (optional) lookbackDays setting
  • Barcode Printing: Add a new field called "ASIN_OR_UPC_OR_SKU"

v15.05 - Mar 2017

  • Verify: BUGFIX: Don't try to print content barcodes if there is no printer chosen

v15.04 - Mar 2017

  • Web Console: Show better errors if receiving fails with "Can't update QOH"

v15.03 - Mar 2017

  • Verify: BUGFIX: If printing 2D barcodes, print one after the last box

v15.02 - Mar 2017

  • ExcelCount: New program to count SKUs

v14.82 - Jan 2017

  • CycleCount: Added an option to prohibit any change for an item with Reserved Unshipped quantity

v14.78 - Jan 2017

  • KitPicker: New program to pick kits
  • CycleCount: Display an asterisk for discontinued items

v14.70 - Dec 2016

  • Pick/MultiPick/Verify: BUGFIX: Pick info was getting deleted in certain circumstances

v14.65 - Dec 2016

  • Verify: Added the ability to print 2D FBA box-content barcodes

v14.64 - Dec 2016

  • Web Console: Added a date filter to "SKU location and quantity changes" report

v14.59 - Nov 2016

  • Receive/CycleCount/Lookup: Use CDQty even if not tracking quantities

v14.53 - Nov 2016

  • InventoryCount: BUGFIX: Open order count was wrong in some cases

v14.40 - Oct 2016

  • Web Console: Added total time column and totals row to pick and pack reports
  • BinAssign2: Fix for scanner coming on when it wasn't supposed to

v14.10 - Sep 2016

  • Picklists: Center order barcode in box on PDF
  • Picklists: Added some white space to packing list barcodes

v13.97 - Aug 2016

  • PriceTagPrint: New program to print price tags

v13.92 - Aug 2016

  • SKUBinCount: New program
  • BinAssign2: New program

v13.78 - Jul 2016

  • Pick: Allow entry of L1, L2, L3 or L4 in place of scanning location
  • RFTransfer: New program

v13.71 - Jul 2016

  • Picklists: Ignore items with YYYYY or ZZZZZ in primary location

v13.61 - Jul 2016

  • Weigh/Dimensions: Use up to 4 scales

v13.59 - Jun 2016

  • RFCOOAssign: New program to assign country of origin

v13.56 - Jun 2016

  • RFPickList: New program to pick picklists

v13.52 - May 2016

  • Web Console: BUGFIX: Receive submission was getting a collation error in some cases

v13.47 - May 2016

  • Web Console: BUGFIX: SKU Change Log: SKU filter was slow in some cases

v13.43 - May 2016

  • QLnPrint: Cosmetic adjustments

v13.29 - May 2016

  • Web Console: Allow printing labels and log as part of receiving

v13.26 - Apr 2016

  • Picklists: Number of days to look back is adjustable. (Was erroneously going 8 years back.)

v13.23 - Apr 2016

  • WebMgmt: Cycle report "never counted" was showing ID instead of LocalSKU.
  • CycleCount/Lookup: Setting which excludes certain order statuses from RUS can now support multiple statuses, comma-separated.
  • Receive: When printing labels, truncate the name at 35 characters.

v13.16 - Mar 2016

  • SortPutAway: Don't allow PutAwayBin quantity to go negative.

v13.15 - Feb 2016

  • Receive/SortPutAway: Backordered quantity calculation was taking too long.

v13.14 - Feb 2016

  • Receive/SortPutAway: Backordered quantity calculation was incorrect.
  • Weigh: Added an option to prompt for quantity update during weigh process.

v13.13 - Feb 2016

  • New feature: PutAwayBin, which can be easily incremented by scanning items on a computer and a tethered scanner.

v13.12 - Feb 2016

  • SortPutAway and BoxPutAway were not showing the correct backorder qty if UPC was scanned instead of SKU.
  • Scale: Some Dymo M25 scales weren't working because of a different USB device ID.

v13.09 - Feb 2016

  • SortPutAway: Show Backordered and RUS quantity.

v13.08 - Jan 2016

  • WebMgmt: In new "Unverified report", ignore items that have location "ZZZZZ" or "YYYYY"

v13.07 - Jan 2016

  • WebMgmt: Inventory Accuracy report: Add ability to filter by category, supplier, and for the top 20% (by price)

v13.06 - Dec 2016

  • WebMgmt: Added an "Inventory Accuracy" report.
  • WebMgmt: Added a report for orders picked but not verified on a given day.
  • CycleCount/Lookup: Added an option to exclude from RUS orders with a certain OrderStatus.

v13.03 - Nov 2016

  • CycleCount: Show an error if data is not saved correctly.

v13.01 - Nov 2016

  • Pick/MP: Added an option to completely hide kit components from pick process.

v12.95 - Sep 2015

  • Better logging of database errors.

v12.94 - Sep 2015

  • Pick/MP: Log SKU in SerialNumbers table.
  • WebMgmt: SKU Change Log: Added filters for employee, type, and location. Show 100 rows instead of just 20.
  • RFDimensions: Added scale reading capabilities.

v12.89 - Sep 2015

  • StartUp and Dimensions: Support a new option in settings.xml (below) which causes changes to be written to all DSNs.

v12.88 - Sep 2015

  • Weigh: Support up to 4 scales.

v12.81 - Aug 2015

  • WebManagement: PutAwayReport: Added total time and time per session.

v12.80 - Aug 2015

  • SortPutAway: Added box tracking capabilities

v12.78 - Aug 2015

  • Weigh: Added ability to read from Dymo scales

v12.62 - Jul 2015

  • Verify: Option to treat kits like assemblies.
  • WebManagement: Mark picklist as picked wasn't working for multi-item orders.

v12.61 - Jul 2015

  • WebManagement: Added OOS Report

v12.60 - Jul 2015

  • BinLookup: Show quantities

v12.56 - Jun 2015

  • Pick: Fixed wrong beep.

v12.55 - Jun 2015

  • Receive: Added support for ZPL printing (need to have template.zpl)

v12.52 - Jun 2015

  • WebManagement: Can generate picklists with multi-item orders. (Can't pick them with the scanners.)
  • Verify: Added box tracking by item.

v12.51 - Jun 2015

  • WebManagement: Added an "RUS Full report" to see all orders and SKUs that are RUS.

v12.49 - Jun 2015

  • Pick: Add a beep and a message if we're asking them to pick the same item twice.

v12.48 - May 2015

  • Receive: Added error tones.

v12.47 - May 2015

  • WebManagement: Added "select all" shipping methods.
  • Picklists: Don't let the picklist name get too long.

v12.45 - May 2015

  • WebManagement: Show Supplier SKU in receiving.

v12.44 - May 2015

  • WebManagement: Fix "Shipped outside of Barcoders" report to work with Access.
  • Fix Scanner Status page to work with Access.

v12.43 - May 2015

  • Assemble: New program to assemble assemblies.

v12.39 - May 2015

  • Picklists: Allow selecting multiple shipping methods. Allow printing a route sheet. Allow auto-picking a whole picklist. Hide orders if the items have a ShipDate.

v12.38 - May 2015

  • SortPutAway: Added confirmation step when changing first location.
  • QLnPrint: Allows selection from multiple printers and writes user specific printer file to Log directory.

v12.34 - May 2015

  • Added QLn320 Print program
  • WebManagement: Picklists were not showing print button.

v12.30 - Apr 2015

  • WebManagement: When receiving, handle SKUs with null QOH.

v12.28 - Apr 2015

  • Added to Receive the ability to scan each item.

v12.27 - Apr 2015

  • Lookup/CycleCount: Show company even in quantities-untracked mode.

v12.25 - Apr 2015

  • If there are multiple companies, display active company code

v12.24 - Apr 2015

  • BinAssign: Show store (if multiple)

v12.23 - Apr 2015

  • KitBuilder: Add UPC to screen.

v12.21 - Apr 2015

  • WebManagement: Create a report for orders shipped without Barcoders.

v12.16 - Mar 2015

  • KitBuilder: Change this to actually build kits, instead of assemblies.

v12.04 - Feb 2015

  • Verify: Exit options are now continue (77), abort (999), and save (VR). Abort clears VerifyStartTime and doesn't write VerifyEndTime.

v11.93 - Jan 2015

  • MultiPick: Made the "OffLimits Locations" feature more generic and configurable.
  • CycleCount and BinAssign: Security level required now configurable.

v11.88 - Jan 2015

  • Pick/MP: Log NB, BB, and CD and show it on the pick report.

v11.86 - Jan 2015

  • WebMangement: ActivityLog: Show location for SortPutAway. Improved display of SortPutAway location changes.
  • CDPutAway: UPC/SKU scan should be case insensitive.
  • Receiving: When comparing SupplierSKU, ignore non-breaking spaces on SKUs.

v11.73 - Nov 2014

  • POPutAway: Adjustments to make compatible with Access.

v11.63 - Nov 2014

  • Pick/MultiPick: Were erring out when used with Access on already-picked orders.

v11.59 - Nov 2014

  • Web console: Make the picklist operations Access-compatible.

v11.56 - Nov 2014

  • CycleCount/BinAssign: Enforce the option to have only one item per location
  • Receive: Allow custom template when printing barcodes.

v11.54 - Oct 2014

  • Sign: Decrementing QOH of box SKU is now optional.
  • SortPutAway: Show Location2.

v11.52 - Oct 2014

  • InventoryCount: Added Cost and Location to the InventoryCount report.
  • InventoryCount: Play error beep if SKU is not found.

v11.46 - Oct 2014

  • Pick/MultiPick: Write OOS to CycleCountTransactions in addition to C:\Logs\OutOfStockItems.txt

v11.42 - Oct 2014

  • Verify: Don't write VerifyEndTime unless at least one item was verified.

v11.41 - Oct 2014

  • SortPutAway: Allow changing all locations during put-away.

v11.39 - Oct 2014

  • Receive: Added support for barcode printing.
  • Pick/MultiPick: Added ability to suppress beep after good item is scanned to speed up picking.

v11.37 - Sep 2014

  • SortPutAway: Show location of last item when scanning items in.
  • Pick/MultiPick: Added option to show next location.

v11.35 - Sep 2014

  • Web console: Reorganized the index on the left-hand side.

v11.34 - Sep 2014

  • Pick/MultiPick: Added option to display pick quantities as "0 of 2"

v11.31 - Sep 2014

  • Pick/MultiPick: Were limiting the location to 13 characters.
  • All programs: Better handling of scan-ahead.

v11.30 - Sep 2014

  • Web Console: Added the ability to delete a receiving session.
  • Web Console: SortPutAway productivity report wasn't displaying correctly.
  • SortPutAway: Option for "scan mode", scanning each item during put-away.
  • SortPutAway: Option for enforce one item per primary location.
  • Receive: Option to warn if a certain integer column is not set to 1.

v11.20 - Aug 2014

  • SortPutAway: Added ability to hit q and type quantity in input loop.

v11.19 - Aug 2014

  • Added a scanner status page to the web management console to see what programs are running

v11.17 - Aug 2014

  • Receive: Added an option to warn user if one of the Integer? fields is 0.
  • Dimensions: New program to set length, width, height, and weight for a SKU.

v10.94 - May 2014

  • CycleCount: Make sure description takes up two full lines

v10.85 - May 2014

  • Improved compatibility with MS Access

v10.79 - May 2014

  • Access compatibility: Handle floating point quantity columns

v10.71 - May 2014

  • WebManagement: Change order of columns in receiving so SKU is closer to quantity numbers

v10.59 - Apr 2014

  • Pick: Show order number in all modes

v10.58 - Apr 2014

  • Pick: Show order number in bottom right (in quantities-untracked mode)

v10.55 - Apr 2014

  • WebManagement: Show serial numbers if they are recorded

v10.40 - Mar 2014

  • Allow deleting a receiving session

v10.37 - Mar 2014

  • Speed enhancement to InventoryCount

v10.36 - Mar 2014

  • Check cancelled status before approved status
  • Trigger available (upon request) to copy QtyPicked to custom Integer 1

v10.35 - Mar 2014

  • BinAssign shows last assignment

v10.33 - Feb 2014

  • Pick/MultiPick: Save employee when picking starts

v10.32 - Feb 2014

  • Allow reference numbers less than five characters

v10.30 - Feb 2014

  • Setting to log all QOH changes to RFInventoryAdjustments.
  • Fail quantity changes in CycleCount if quantity was changed by another process.

v10.27 - Feb 2014

  • WebManagement: Added out of stock statistics to pick report

v10.26 - Feb 2014

  • MultiPick allows up to 100 orders.

v10.24 - Jan 2014

  • Clean up the display in Pick/MultiPick.

v10.23 - Jan 2014

  • CycleCount: (Quantity-tracked mode) Show locations even if quantity is 0.

v10.22 - Jan 2014

  • CycleCount: (Quantity-tracked dependent mode) Don't allow L1Qty modifications.

v10.21 - Jan 2014

  • WebManagement: Fixed RUSReport to work with SQL Server 2008

v10.20 - Jan 2014

  • WebManagement: RUSReport shows much more detail behind calculations

v10.19 - Jan 2014

  • WebManagement: Can manage SKU locations and quantities from web console.
  • RFWeigh: Fixed display bug
  • (Quantity-tracked mode) Trigger available to synchronize L1Qty with StoneEdge POS.

v10.18 - Dec 2013

  • InventoryCount: Since 10.0, "UPC Not Found" was showing when it wasn't supposed to.
  • BinAssign: Fix display problems when changing destination.
  • WebManagement: Use "Exp" (expected) instead of "Ord" (ordered) in receiving screen.

v10.17 - Dec 2013

  • CycleCount: (Quantity-tracked mode) Allow scanning to input locations when transferring qty.

v10.16 - Dec 2013

  • WebManagement: Add reports for which orders were picked, packed, or signed by a given employee

v10.15 - Dec 2013

  • Allow scanners to scan input longer than the space shown on the screen.

v10.14 - Dec 2013

  • Compatible with databases that have QOH as a smallint
  • PortaPrint: Can choose between multiple StoneEdge databases

v10.12 - Nov 2013

  • Lookup: Fix some display bugs
  • PortaPrintFile Windows program created

v10.11 - Nov 2013

  • CycleCount: (Quantity-tracked mode) Allow level 2 employees to edit CD quantity

v10.1 - Nov 2013

  • Pick/MultiPick: Support sorting by different location

v10.0 - Nov 2013

  • Support dependent and independent quantity tracking modes.
  • MultiPick: Added "Resume" ability.
  • WebManagement: Added SKU Activity report.
  • POPutAway: Fixed crash when opening a PO.

v7.9q

  • Support four locations.

v7.9p

  • Change compilation target from x86 to any CPU

v7.9o

  • Don't restrict input length of EAN/UPC barcodes
  • Don't send milliseconds to SQL Server. Compatible with SQL Server Native Client
  • WebManagement: Increased allowed execution time for reconcile report.
  • RFStartUp program created
  • BinAssign: Fixed bug when 'N' was typed.
  • BinConfim introduced.

v7.9n

  • WebManagement: Receiving: Handle SKUs that have spaces at the beginning or end.
  • MultiPick: Added option to use CartIDs.

v7.9m

  • KitBuilder program created to pick assemblies
  • Pick: Support for assemblies
  • Support for switching between StoneEdge databases
  • Pick: Compare SKUs case-insensitively

v7.9k

  • Option to truncate all EAN13 barcodes.

v7.9j

  • Option to exclude items from RUS with non-null status.

v7.9i

  • WebConsole: Bug in reconcile matching up SKUs.
  • CycleCount/Lookup: "RUS excludes items with non-null DateShipped" now an option.

v7.9h

  • Pick/MultiPick: Option to allow picking unapproved orders.

v7.9g

  • CycleCount/Lookup: RUS excludes items with non-null DateShipped.

Lookup

  • 12/12/12 Version 7.9f Added null checking for QOH and ItemName.
  • 10/24/12 Version 7.9e If BegOrderID = 999 then RUS = 0, also removed Approved = 1 from RUS.
  • 09/06/12 Version 7.9b Bug fix.
  • 03/22/12 Version 7.9a Bug fix.
  • 03/21/12 Version 7.9 Added description to screen.
  • 11/07/11 Version 7.8a Bug fix.
  • 11/04/11 Version 7.8 Bug fix.
  • 09/15/11 Version 7.7c added code to check for dUPC/Barcode null as well.
  • 08/31/11 Version 7.7b Bug fix.
  • 05/23/11 Version 7.7 lengthened SKU display as well.
  • 05/03/11 Version 7.6 lengthened SKU input from 19 to 40 for XXXX.
  • 02/03/11 Version 7.5a add "Started:" to show time started.
  • 01/30/11 Version 7.5 Added "In bin:" by adding RUS and QOH.
  • 11/19/10 Version 7.4 Added code to exclude dropshipped product in RUS calculation.
  • 10/14/10 Version 7.3a Bug fix.
  • 09/06/10 Version 7.3 Modified RUS query to include RFVeried as well as RFPicked items.
  • 07/26/10 Version 7.2 Expanded to 19 characters for SKU.
  • 06/26/10 Version 7.1 Added BegOrderID read from table.
  • 04/28/10 Version 7.0 added query to show RUS Reserved unshipped.
  • 04/06/10 Version 6.1 Bug fix.
  • 02/13/10 Version 6.0 Lists tables and pop-up "Not Found" message.
  • 11/24/09 Version 5.1 Added I 2 of 5 code.
  • 03/29/09 Version 5.0 Added Term ID, Added EAN_8, Added Location2 and Location3.
  • 01/27/09 Added SKU search as well.
  • 01/12/09 Added Location2 to the screen.
  • 12/23/08 Added EAN_13 for xxx.
  • 01/20/05 Version 1a Original Version.
  • 03/27/06 2a SQL Server version

Pick

  • 01/19/2012 Version 7.9 Added order suspension functionality.
  • 10/09/2012 Version 7.8d check for cancelled orders and unapproved orders.
  • 09/20/2012 Version 7.8c Bug fix.
  • 01/31/2012 Version 7.8b Bug fix.
  • 01/23/2012 Version 7.8a Bug fix.
  • 10/05/2011 Version 7.8 Added code to check for null and single quote (') in description (itemname).
  • 06/15/2011 Version 7.7a Bug fix.
  • 05/23/2011 Version 7.7 Allowed two lines for 40 character SKU. Moved DESC down one line.
  • 02/04/2011 Version 7.4 Clarified Checkpick Status and 'Already Picked'.
  • 10/14/2010 Version 7.3c added code to check for PickEndTime not null but length < 2, disabled scanner when "ENTER to continue." is prompted.
  • 07/30/2010 Version 7.3a Force Entry on Serial Number and RB routine.
  • 04/23/2010 Version 7.3 compare scanned barcode to UPC AND SKU for match.
  • 02/11/2010 Version 7.2a Added code to retry if no record in RFOrders but record in RFOrderDetails.
  • 02/10/2010 Version 7.2 Added Replace Barcode RB code.
  • 12/22/2009 Version 7.1 Added code to account for back orders. If OrderDate > PickEndTime then do nothing.
  • 12/10/2009 Version 7.0 Read and Write to RFOrders and RFOrderDetails.
  • 11/24/2009 Version 6.2 Added Code I 2 of 5.
  • 10/09/2009 Version 6.1 Added code to support serial numbers, must add a SerialNumbers table.
  • 03/26/2009 Version 6.0 Added EAN_8 Symbology.
  • Multiple locations converted to 'Location2', 'Location3' columns in Inventory instead of Text1.
    Added TermID on display.
    Added code to look for alternative UPC/SKUs in 'Lists' table.
    Added Ref# to error line.
    Added Dropship or Kit Type 'K' to 'don't include when picking' list.
  • 02/12/2009 Version 5.0b added code to handle Null Location column in Inventory table.
  • 01/17/09 Version 5.0a added LocalSortInteger5 = '1' for number of orders picked.
  • 01/11/09 Version 5.0 Added 2nd bin location logic Text1 field in Inventory table.
  • 01/08/09 Version 4.0f Added write_qtypicked to oos routine.
  • 01/06/09 Version 4.0e Changed Tones.
  • 01/05/09 Version 4.0d Added "YYYYY" as location to skip as per McKane previous spec..
  • 01/04/09 Version 4.0c Added checking for blank PickEndDate as well.
  • 12/28/08 Version 4.0b add OrgQty.
  • 12/25/08 Version 4.0a added Picker Name too.
  • 12/21/08 Version 4.0 Added EAN_13 and checking for already Picked for XXX.
  • 07/08/08 Changed to pull QuantityShipped not QuantityOrdered from Order Details.
  • 07/03/08 Ver F - McKane found bug, corrected Write_pqty(PickItem) to show SKU = psku(PickItem).
  • 07/02/08 Modified to to include Picker and Name that I left out of 6/24/08 modification.
  • 06/24/08 Changed to write both PickStartTime and PickEndTime at end of picking.
  • 06/22/08 Version 3.0d - Bug fix.
  • 05/11/08 Version 3.0a Added Employee Table.
  • 10/26/07 Version 2.4a Added Code 128 barcodes.
  • 02/06/07 Version 1a Original Version.

Verify

  • 02/29/12 Version 7.5 changed the way you can exit with SKUs still to verify, show and return or exit.
  • 11/30/11 Version 7.4a Fix bug.
  • 02/05/11 Version 7.4 Fix bug.
  • 12/25/10 Version 7.3 Added bulk verify functionality.
  • 12/23/10 Version 7.2 Added security. Employee must be level 2 or 3 to Verify, also added SKU to SQL Insert statement for RFOrderDetails when people verfy but not pick.
  • 10/22/10 Version 7.1c Bug fix.
  • 09/01/10 Version 7.1b Bug fix.
  • 03/08/10 Version 7.1a Added code to check against SKU as well.
  • 02/09/10 Version 7.1 Added code for stand alone tables RFOrders and RFOrderDetails, and support for back orders.
  • 11/28/09 Version 5.2 added code to correct for no location in database.
  • 11/24/09 Version 5.1 added Code I 2 of 5.
  • 03/29/09 Version 5.0 Add the code to look for SKUs in List table as well.
  • Added EAN_8, Added 'DropShip' and Kit Type 'K' to 'do not Verify list'.
    Added Term ID label.
    Added Ref# in all error codes.
  • 01/18/09 Version 4.0f changed for same SKU (different prices) on consecutive lines.
  • 01/06/09 Version 4.0e Changed Tones and message to 'Not in order!'.
  • 01/05/09 Version 4.0d added "YYYYY" as location to skip as per Scrapbook.com spec.
  • 01/04/09 Version 4.0c Added checking for blank PickEndDate as well.
  • 12/28/08 Version 4.0b added Go instead of 77.
  • 12/25/08 Version 4.0a added Verifier Name too.
  • 12/21/08 Version 4 Modified to include EAN_13 and check Verify status.
  • 09/09/08 Modified Get_RefNo_Items to exclude item when dQTY = 0.
  • 06/24/08 Modified to write start and end time at successful end of Verify cycle.
  • 05/18/08 Uniform looking form. Added 'Total Pieces' label.
  • 05/13/08 Added Remaining SKUs Version 1.0b.

Sign

  • 12/27/11 Version 7.5 Added Box SKU functionality for XXXX.
  • 11/04/11 Version 7.4a added option explicit.
  • 02/09/11 Version 7.4 Moved to 7.4 to agree with RFPick and RFVerify.
  • 02/05/11 Version 7.3 Added code so you can't sign unless it's been picked or verified.
  • 12/23/10 Version 7.2 Added security. Must be 2 or 3 to sign.
  • 03/08/10 Version 7.1a Bug fix.
  • 02/09/10 Version 7.1 code to write to RFOrders and RFOrderDetails.

MultiPick

  • 10/09/12 Version 7.9a Check for cancelled and unapproved orders.
  • 11/22/11 Version 7.9 added SortOrder = "77" just before "PickHere:", bug fix.
  • 11/04/11 Version 7.8a Bug fix.
  • 10/05/11 Version 7.8 Added code to check for null and single quote (') in description (itemname).
  • 06/15/11 Version 7.7a Bug fix.
  • 05/04/11 Version 7.7 For xxx moved Desc down one line.
  • 02/24/11 Version 7.6 Added code to show box when scanning Ref No..
  • 01/27/11 Version 7.5 Added '55' to sort pick list in reverse.
  • 10/14/10 Version 7.4b Disabled scanner when "ENTER to continue." is prompted.
  • 10/05/10 Version 7.4a Bug fix.
  • 09/23/10 Version 7.4 Show last box at bottom. Added code for XXX to only allow level 2 or 3 to pick if shelf is 04 and above. Format C-01-XX-03.
  • 07/30/10 Version 7.3a Force Entry on RF and Serial Number.
  • 04/23/10 Version 7.3 compare scanned barcode to UPC and SKU.
  • 03/08/10 Version 7.2b Bug fix.
  • 02/11/10 Version 7.2a Bug fix.
  • 02/09/10 Version 7.1 to account for back ordered items OrderDate > Pickdate.
  • 02/08/10 Version 7.0 changed to write to own tables RFOrders and RFOrderDetails also added lists table functionality.
  • 02/07/10 Version 5.3 Added code to not pick if Item type = K (kit) or if a drop ship.
  • 01/12/10 Version 5.2 Added to account for more than 4 boxes on display.
  • 11/24/09 Version 5.1 Added Code I 2 0f 5.
  • 11/03/09 Version 5.0 Added code for "rb" Revise Barcode, only works if barcode in Inventory table is empty, barcode NOT from LISTS table and EmpSecurity > 1.
  • 10/10/09 Version 4.1 Added code to track Serial Number.
  • 04/14/09 Version 4.0b Added code to leave out two-second message if one box. Added TermID and check the Lists table.
  • 03/09/09 Bug fix.
  • 01/17/09 Version 4.0a added LocalSortInteger5 = TotalBoxes.
  • 01/11/09 Version 4.0 added second warehouse location.
  • 01/09/09 Version 3.0b added both box routines to 'bb' 'nb' routines.
  • 01/08/09 Version 3.0a added write_qtypicked to oos routine.
  • 01/06/09 Version 3.0 Two-second message box.
  • 01/06/09 Version 2.0e Bug fix.
  • 01/05/09 Version 2.0d Bug fix.
  • 01/05/09 Version 2.0c added "YYYYY" as location to skip as per Scrapbook.com.
  • 01/04/09 Version 2.0b Bug fix.
  • 12/21/08 Version 2.0 Added EAN_13 and check for already picked.

Cycle Count

  • 12/12/12 Version 7.9f Added Null checking for QOH and ItemName.
  • 10/24/12 Version 7.9e If BegOrderID = '999' then RUS = 0, also removed Approved = 1 from RUS.
  • 09/06/12 Verison 7.9d Bug fix.
  • 05/12/12 Version 7.9c Bug fix.
  • 05/12/12 Version 7.9b Bug fix.
  • 03/22/12 Version 7.9a Bug fix.
  • 03/21/12 Version 7.9 Added Description to display to match RFLookup.
  • 01/09/12 Version 7.8c Bug fix.
  • 11/07/11 Version 7.8b Bug fix.
  • 11/04/11 Version 7.8a Bug fix.
  • 11/01/11 Version 7.8 Added code to write to "Last Counted" column in SEOM Inventory table.
  • 10/05/11 Version 7.7a Bug fix.
  • 05/23/11 Version 7.7 Change to allow 40 character SKU on input and display.
  • 02/02/11 Version 7.4 Added 'InBIN'.
  • 11/19/10 Version 7.3 Added code to exclude dropshipped items from RUS calculation.
  • 10/14/10 Version 7.2a Added code to disable scanner on "ENTER to continue statements".
  • 09/06/10 Version 7.2 Modified RUS query to include RFVerified as well as RFPicked.
  • 06/26/10 Version 7.1 Added BegOrderID read from table.
  • 05/25/10 Version 7.0 Added RUS data.
  • 03/02/10 Version 3.0 Added Pop-up window stating 'SKU/UPC' not found.
  • 01/20/10 Version 2.2 Bug fix.
  • 11/24/09 Version 2.1 added Code I 2 of 5.
  • 08/18/09 Version 2.0c Modified to check Lists Table and allow scanning of UPC or SKU.
  • 04/14/09 Version 2.0b Modified to loop around if UPC not found
  • Also added Location2 and Location3 and two security levels 2 can.
    Change location, 3 can change QOH as well.
    Added Term ID label.
  • 02/12/09 Version 2.0a code to not error if Inventory. Location is blank.
  • 12/22/08 Version 2.0 added EAN_13.

Receive

  • 04/12/12 Version 4.1 Fix bug.
  • 03/09/12 Version 4.0a Fix bug.
  • 03/09/12 Version 4.0 Added Check_ListsTable, cleaned up Get_EmpNumber.
  • 04/26/11 Version 3.2a Bug fix.
  • 03/17/11 Version 3.2 Bumped length of receive SKU field to 40 characters for XXX.
  • 02/13/11 Version 3.1 Added code to enter barcode if not in inventory table.
  • 08/05/10 Version 3.0a add code to account for null fields when reading SKUdata.
  • 05/05/10 Version 3.0 Added Back Ordered QTY per SKU.
  • 03/17/10 Version 2.4 Added clearer error messages for invalid POs or PO Items.
  • 02/13/10 Version 2.3a Added trapping code for Lots received > 10,000 (employee scanned barcode by mistake) and display location of item being received at bottom of screen.
  • 02/07/10 Version 2.3 Added trapping code for null fields.
  • 01/04/10 Version 2.2 added code for additional field, 'receive' in SQL table as per XXX.
  • 11/24/09 Version 2.1 added I 2 of 5 code.
  • RFReceive program. Created 6/21/09.

Po Put Away

  • 05/03/12 Version 4.1 Check for UPC or SKU on put away.
  • 04/18/12 Version 4.0 Was writing to the Orders table! Change to POHoldingHistory table, also now only selecting items where PutAwayDate is null.
  • 04/03/12 Version 3.3 QOH was missing in get data routine.
  • 03/22/12 Version 3.2 Added QOH same a Sort Put Away.
  • 09/21/11 Version 3.1 Bug fix.
  • 04/28/11 Version 3.0 Added 'bo' to skip an item that was Back Order Filled.
  • 04/26/11 Version 2.0a Bug fix.
  • 02/13/11 Version 2.0 added code to input location if null or "NONE".
  • 05/03/10 Version 1.1 added Back Order QTY.
  • 04/27/10 Version 1.0 for customer.

Sort Put Away

  • 04/03/12 Version 2.3 Added code to sort QOH as well.
  • 03/21/12 Version 2.2 Added QOH as per XXX request.
  • 10/05/11 Version 2.1 Added code to check for null and single quote (') in description (itemname).
  • 09/15/11 Version 2.0b Bug fix.
  • 09/15/11 Version 2.0a Bug fix.
  • 04/09/11 Version 2.0 added audit trail record.
  • 03/17/11 Version 1.0 for XXX.

Inventory Count

  • 05/29/12 Version 3.0 Added Quick Count features.
  • 10/05/11 Version 2.1 Added code to check for null and single quote (') in description.
  • 04/06/11 Version 2.0 Added code to check and delete contents of RFInventory Table.
  • 02/28/11 Version 1.2b Bug fix.
  • 02/04/11 Version 1.2a Made OutOrders query more accurate.
  • 02/01/11 Version 1.2 Added 'Last scanned' and 'TotalCount' to UPCCount display as per XXX.
  • 01/31/11 Version 1.1 Added Check List Table routine.
  • 01/27/11 Version 1.0 Generic for all Stone Edge customers, calculate if any RUS outstanding.
  • 06/16/10 Version 1.0 Added tones for bad and good BIN.
  • 05/12/10 Version 2.0 Find SKUs assigned to BIN but NOT scanned.
  • 04/28/10 Version 1.2 Swapped comparison perspective Count - QOH and added another UCASE for avoid issues with SKUs in upper/lower case.
  • 04/09/10 Version 1.1 Bug fix.
  • 04/06/10 Version 1.0 RFBINCount for xxx.
  • 11/24/09 Version 2.2 added I 2of5 barcode and code to make sure dUPC and Location not the same.
  • 11/20/09 Version 2.1 added insert audit data into CycleCountTransaction table.
  • 10/22/09 Version 2.0b added TermID.
  • 02/12/09 Version 2.0a code to not error if Inventory.Location is blank.
  • 12/22/08 Version 2.0 added EAN_13.

Bin Assign

  • 06/08/12 Version 4.0 Added ability to change from Location to Location2 and Location3.
  • 05/12/12 Version 3.5 Added eType = 'BINAssign' to audit trail.
  • 05/10/11 Version 3.4 Bug fix.
  • 12/30/11 Version 3.3 Bug fix.
  • 11/04/11 Version 3.2 Added Check_ListsTable.
  • 05/03/11 Version 3.1 change input for SKU from 19 to 40.
  • 03/30/11 Version 3.0 added QOH.
  • 07/28/10 Version 2.3 Bug fix.
  • 11/24/09 Version 2.2 added I 2of5 barcode and code to make sure dUPC and Location not the same.
  • 11/20/09 Version 2.1 added insert audit data into CycleCountTransaction table.
  • 10/22/09 Version 2.0b added TermID.
  • 02/12/09 Version 2.0a code to not error if Inventory.Location is blank.
  • 12/22/08 Version 2.0 added EAN_13 for XXX.

Bin Lookup

  • 03/19/12 Version V3.0 Added an '*' in front if SKU discontinued.
  • 11/04/11 Version V2.1 Bug fix.
  • 01/27/11 Moved 'SKU:' down to line 2 so as not to overload line 2 for XXXX.
  • 11/28/09 Added I 2of5.

Wireless Order Fulfillment Systems

  • Employees can now perform "Order Lookup" without logging in.
  • Inventory Count views now supports export to CSV file.
  • Added BoxID to "Order Lookup" Sign information displayed.
  • View SKU location and quantity changes.
  • Cycle Count report that shows "SKUs never counted" and "SKUs least recently counted".
  • Receive and review Purchase Order capabilities.
  • RUS report that shows orders included in RUS count for a specific SKU.
  • Added "hours" to Pick and Verify reports so statistics can be normalized.
  • Script for creating SQL tables and columns quickly and easily.

Let Barcoders.com provide you with a free price quote and help you increase
your productivity, bottom line, and client satisfaction.
Contact us at info@barcoders.com.