Scanco Warehouse Frequently Asked Questions (FAQs)
  1. Knowledge Base
  2. Scanco Warehouse
  3. Scanco Warehouse Frequently Asked Questions (FAQs)

Warehouse 100: Barcode Import Running Slow

Problem

Import program is running very slow.

In Sage Version 5 and below the import was called "Unattended Bar Code Transaction Import"

In Sage Version 6 and above the import is called "EZ Import"

Solution

The hard option that requires Dashboard editor changes: Give them a 'view' called "Top Level History" that only pulls the BC_HeaderHistory table into the grid.

The issue you are having appears to be because your Barcode history table records are too large for Sage's ODBC driver to parse through, and should be purged.

This should be a regular maintenance process at Period End.

 

Sage Version 5 Steps:
Barcode history files can be purged from Sage via:
  • Barcode, Setup, Barcode Options:  Set # days to retain history.
  • Barcode, Period End, Purge Bar Code History – check the top checkbox and press Proceed.

 

Sage Version 6 Steps:
Barcode history files can be purged from Sage via:
  • Barcode, Setup, Barcode Options:  Set # days to retain history.
  • Barcode, Period End, Purge EZ Import History – press Proceed.



This will delete all history records of what was scanned except for the last 90 days (default setting which you can change).

Assuming Sage is backed up nightly, you already have a backup of the barcode history files.  If you'd like to verify the data is backed up, the following areas are where the files are for your barcode history:

\MAS90\MAS_***\bc***\bc_headerhistory.m4t
\MAS90\MAS_***\bc***\bc_detailhistory.m4t
\MAS90\MAS_***\bc***\bc_distributionhistory.m4t

 

*** = Company code