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.

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.

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

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.