Configure Data Caching in Warehouse Insight

Skip to main content

Configure Data Caching in Warehouse Insight

You are here:

The Device Cache option’s main purpose is to prevent making calls to Business Central when scanning an item or bin barcode. Two additional caching options improve application loading performance (see the Frequency options and Fetch Size field sections). Without caching, each scan results in a call to Business Central to decode the item or bin and return the relevant data (e.g., to execute the barcode rules on the barcode and retrieve the item information). With caching on, these actions are handled on the device, without a web services call to Business Central, significantly improving performance.

To configure device caching:

  1. Navigate to Warehouse Insight Device Configurations in Business Central.
  2. Select the required configuration card.
  3. Select Related / Cache Settings and set Cache Data to Yes (auto generates the default cache options).
  4. Select Cache Settings and modify the caching options as needed (Optional):
    • Items: Used when decoding an item, lot, or serial number barcode scan.
    • Item Cross References: Used when decoding an item, lot, or serial number barcode scan.
    • Item References: Used when decoding an item, lot, or serial number barcode scan.
    • Item Identifiers: Used when decoding an item, lot, or serial number barcode scan.
    • Item Ledger Entries: Used when decoding an item, lot, or serial number barcode scan.
    • Item Units of Measure: Used when decoding an item, lot, or serial number barcode scan.
    • Barcode Rules: Used when decoding an item, lot, or serial number barcode scan.
    • Bins: Used when a bin is scanned.
    • Applications: Refers to Warehouse Insight Applications and allows the device to store copies of each applications locally to avoid re-fetching the application from Business Central each time it is opened.
    • Item Pictures: Refers to the picture associated with an item, and make image FactBoxes and image display on scanning much faster.
  1. Set the frequency of each option as needed (see Frequency options below).
  2. Set the Fetch Size field (the default for most entries is 3000 records; see Fetch Size field below for more information).
  3. View the cache entries:
    1. Select Configure / Data  and enable Show Cache Details Menu (you can view the cache entries from the main menu page using Cache Details).
  4. Delete the cache entries as needed (entire cache or specific tables).

Any new or modified records in Business Central are added to the device cache based on the configuration specified. For example, if Item Ledger Entries are added or modified, the corresponding cache on the device is updated based on the configured frequency; whereas Item changes might only be reflected once the application is restarted since the Item entry is typically set to “On Startup”.

Frequency options

The Cache Settings options have the following frequency options:

Frequency Description
Never The Warehouse Insight application never caches the data. Whenever the application needs this data, it makes a web services call to Business Central.
On Startup The Warehouse Insight application caches the data when it is launched. At 1-minute intervals, the application continues to fetch the data in batches, defined by the Fetch Size, until completely cached.
Periodically The Warehouse Insight application begins to cache the data when started, like the On Startup option, and continues to check Business Central for new data after all data is loaded. These checks occur at the interval defined in the Interval (minutes) field.

 Fetch Size field

The Fetch Size field on each entry determines how many records should be loaded from Business Central and sent to the device in each web services call. The default for most entries is 3000 records. If the Item table, had 9200 entries it would take 4 calls to Business Central to fully populate the Item cache (3000 + 3000 + 3000 + 200).

Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Need help?

Leave A Comment

Table of Contents
Go to Top