Inventory Quantity Resync

Overview

The Inventory Quantity Resync routine corrects inventory quantity discrepancies that occasionally occur due to rounding differences, interrupted transactions, or data inconsistencies.

This routine compares inventory quantities across different tables and generates adjustment entries to bring them back into sync.

Typical discrepancies include:

• Qty. Base on Hand ≠ Remaining Qty. Base on Hand
• Qty. Base on Hand ≠ Qty. Base on Bin Content

When to Run Inventory Quantity Resync

Run the Inventory Quantity Resync routine when:

• Items appear in the xDIF Quantities view.
• Inventory quantities do not reconcile.
• Users report incorrect on-hand quantities.
• Inventory quantities become inconsistent after data corrections or integrations.

Review Items with Quantity Differences

Navigate to:

Items → xDIF Quantities

This view displays items with inconsistent quantity values.

Before running the resync routine, you may review the related Item Ledger Entries to determine whether a specific transaction caused the discrepancy.

If only a few transactions are affected, correcting the underlying issue may be preferable. If many records are involved, the Inventory Quantity Resync routine is usually the faster solution.

Calculate Inventory Resync

1. Navigate to Inventory Resync.
2. Open the Quantity Resync view.
3. Click Calculate Inventory Resync.

You may:

• Specify a single Item to analyze, or
• Leave the Item field blank to analyze all items with quantity discrepancies.

How the Routine Works

GoldFinch performs two separate comparisons.

Quantity Comparison

Compares:

• Qty. Base on Hand
• Remaining Qty. Base on Hand

Adjustment entries are created as needed by:

• Item
• Warehouse
• Lot Number
• Serial Number

Bin Quantity Comparison

Compares:

• Qty. Base on Hand
• Qty. Base on Bin Content

Adjustment entries are generated using the same grouping criteria.

GL Ledger Assignment

When Multi-Ledger Accounting is enabled, GoldFinch determines the GL Ledger based on your inventory valuation setup.

If inventory valuation is segregated by:

• Item — the GL Ledger assigned to the Item is used.
• Warehouse — the GL Ledger assigned to the Warehouse is used.

Unit Cost Calculation

Inventory Resync adjustment entries use the following cost calculation:

1. Average Base Cost
2. If Average Base Cost is zero, Last Invoiced Cost

If Multi-Currency is enabled, GoldFinch converts the Unit Cost using the exchange rate between:

• The Item Currency, and
• The Currency of the Inventory Resync entry.

Posting Inventory Resync

After reviewing the calculated adjustments:

1. Select the entries to post.
2. Click Post Inventory Resync.

GoldFinch creates the necessary Item Ledger Entries to synchronize inventory quantities.

Verify the Results

After posting:

1. Return to Items → xDIF Quantities.
2. Confirm that no items remain in the list.

An empty xDIF Quantities view indicates that the inventory quantity discrepancies have been successfully resolved.

Best Practices

• Investigate recurring quantity discrepancies before repeatedly running Inventory Quantity Resync.
• Perform Inventory Quantity Resync before month-end inventory reconciliation if quantity differences exist.
• Review calculated adjustment entries before posting, especially in multi-warehouse or lot-controlled environments.
• If quantity discrepancies persist, contact GoldFinch Support to investigate the underlying cause rather than relying on repeated resynchronization.