TL;DR — Quick Summary

Fix Aspel SAE inventory management errors: negative stock, incorrect Kardex, multi-warehouse transfers, cost methods, and COI accounting synchronization.

Aspel SAE inventory management is one of the most complex modules in the system, and errors here can block sales, distort financial statements, and create headaches at tax time. This guide covers the most common inventory errors — negative stock, Kardex inconsistencies, multi-warehouse transfer failures, cost method misconfigurations, and COI synchronization gaps — and explains how to resolve each one.

The Error

Inventory problems in Aspel SAE appear in several forms:

  • Explicit error message: Error al realizar movimiento de inventario. El artículo [CODE] no cuenta con existencias suficientes en el almacén [NAME].
  • Negative stock quantities: The stock report shows negative values (e.g., -5.00) even though product physically exists in the warehouse.
  • Inconsistent Kardex: The Kardex report shows movements that don’t correspond to real invoices or remittances.
  • COI mismatch: The inventory valuation report in SAE doesn’t match the inventory account balance in Aspel COI.
  • Physical count entry error: When entering a physical inventory count, the system fails to update stock correctly or shows unexplained differences.
  • Multi-warehouse transfer gap: The system deducts from the origin warehouse but doesn’t credit the destination, leaving units “lost.”

Root Cause

Inventory errors in Aspel SAE have several common causes:

1. Sales without prior remittance: In workflows requiring Remittance → Invoice, if an invoice is posted directly without a remittance (or the remittance is cancelled but not the invoice), stock is deducted twice or without a corresponding receipt.

2. Cost method misconfiguration: If an item was created with Weighted Average and then switched to FIFO without running a period close first, historical costs become corrupted.

3. Unauthorized manual movements: Inventory adjustments made directly in the database (outside SAE) break the Kardex integrity.

4. Incomplete period closes: If a fiscal period is closed in COI but not in SAE, subsequent inventory movements accumulate without being sent to accounting.

5. Multi-warehouse permissions: A user without permission over the destination warehouse can initiate a transfer that completes only partially.

6. Fragmented database: On older installations with many transactions, Aspel SAE’s database may have corrupted indexes affecting stock calculations.

Step-by-Step Solution

Step 1 — Verify Real Stock with the Kardex

Before making any correction, get the full transaction picture:

  1. Go to Inventarios > Reportes > Kardex.
  2. Select the problematic item and the affected warehouse.
  3. Set a wide date range (the full current fiscal year).
  4. Export to Excel for detailed analysis.
  5. Locate the first movement where the running balance becomes incorrect. That is the origin of the problem.

Tip: Look for movements with type “AJ” (adjustment) or “TR” (transfer) without a visible counterpart. Those are candidates for correction.

Step 2 — Reconcile Physical Inventory vs System

  1. Conduct a physical count of the item across all affected warehouses.
  2. Generate Inventarios > Existencias por Almacén as of today.
  3. Compare the columns. If there is a discrepancy:
    • Go to Inventarios > Movimientos > Ajuste de Inventario.
    • Select the warehouse and item.
    • Enter the adjustment quantity (positive to increase, negative to decrease).
    • In the “Reason” field, write a clear description: Stock adjustment — physical count [date].
    • Confirm the unit cost the adjustment will use (should be the item’s current cost).

Step 3 — Fix the Cost Method

If the issue is incorrect costs (inventory value is wrong even though quantities are right):

  1. Go to Configuración > Parámetros del Sistema > Inventarios.
  2. Verify the Valuation Method: Weighted Average, FIFO, or LIFO.
  3. Consult with your accountant which method applies for the fiscal year.
  4. If you need to change the method: first run an Inventory Period Close from Inventarios > Cierre de Inventario. This freezes current balances before the change.
  5. Update the method in Parameters and verify that any items with individual methods are aligned.

Step 4 — Fix Multi-Warehouse Transfer Errors

  1. Find the problematic transfer in Inventarios > Consultas > Movimientos por Tipo > Traspasos.
  2. Note the transfer number and date.
  3. Check whether the origin warehouse was debited: review the origin Kardex on that date.
  4. Check whether the destination warehouse was credited: review the destination Kardex.
  5. If only the outbound movement exists but not the inbound:
    • Cancel the transfer from Inventarios > Movimientos > Traspasos > [Select] > Cancelar.
    • Recreate the transfer after confirming the origin warehouse has sufficient stock.

Step 5 — Sync with Aspel COI

  1. In SAE, go to Utilerías > Enlace Contable > Configuración de Cuentas.
  2. Verify each movement type (receipts, issues, adjustments, transfers) is mapped to the correct COI account.
  3. Run Utilerías > Generar Pólizas de Inventario for the period with the discrepancy.
  4. In Aspel COI, verify the journal entries arrived: Diario Mayor > Consulta de Pólizas.
  5. Compare the inventory account balance in COI with the Valuación de Inventario report in SAE. They must match.

Alternative Solution

If the above steps don’t resolve cost discrepancies, use the Kardex rebuild tool:

  1. Take a complete database backup before proceeding.
  2. In SAE, go to Utilerías > Reconstrucción de Archivos.
  3. Select “Kardex de Inventarios” and the date range to rebuild.
  4. The system will recalculate all movements from the start of the period, automatically correcting cost inconsistencies.
  5. Verify the item’s Kardex after the rebuild to confirm balances are correct.

Warning: Kardex reconstruction is irreversible without a backup. Always run with the system in single-user mode (close all open sessions).

Prevention

To avoid future inventory errors in Aspel SAE:

  • Monthly period close: Run the inventory period close at the end of each month before the accounting close in COI.
  • Remittance → Invoice workflow: Configure SAE to require a remittance before invoicing for transactions that involve warehouse outflows.
  • Per-warehouse permissions: Assign warehouse permissions by user in Configuración > Usuarios > Permisos de Almacén.
  • Quarterly physical counts: Schedule physical counts at least once per quarter and reconcile in SAE immediately.
  • Daily backups: Configure automatic database backups for SAE. In the event of a serious error, a backup is the only recovery path.

Inventory valuation report mismatch: If the valuation report shows incorrect values even though quantities are right, check if the item’s cost method was changed mid-year. Items with a history under one method and new records under another may show hybrid costs.

Sales not updating inventory: If a posted invoice doesn’t reduce stock, verify the item has “Maneja Inventario” enabled in its configuration. Service-type items never affect inventory even when included in invoices.

Physical count entry error: If the system errors during physical count entry, check for an unclosed physical inventory from the previous period. Only one physical inventory count can be active at a time in SAE.

Summary

  • The Kardex is the primary diagnostic tool — always start there before making corrections.
  • Inventory adjustments must be documented with a clear reason and date for audit traceability.
  • The cost method (FIFO, LIFO, Weighted Average) should be defined once at the start of the fiscal year and not changed without a period close.
  • Incomplete multi-warehouse transfers are cancelled and recreated, never patched with manual adjustments.
  • COI synchronization requires correct account mapping and period-by-period journal generation.
  • Always back up before running Kardex reconstruction or changing the cost method.