TL;DR — Quick Summary

Fix errors in orders and quotes in CONTPAQi Comercial: exhausted folios, failed conversions, CFDI 4.0 fiscal data, tax calculations and performance.

Errors Creating or Converting Commercial Documents in CONTPAQi

CONTPAQi Comercial (formerly AdminPAQ) manages the full commercial document lifecycle: quote → purchase order → remission → invoice → payment complement. Each conversion between document types can fail due to incomplete configuration, exhausted folios, missing CFDI 4.0 fiscal data, or database corruption.

This article covers the most common errors when creating, editing, or converting purchase orders and quotes, with root causes and step-by-step solutions.

The Error

The most common errors you will see in CONTPAQi Comercial when working with documents are:

  • “Error al crear documento” — appears when saving a new order or quote.
  • “Error al convertir cotización a pedido” — when using the conversion option.
  • “No se puede facturar el pedido” — when trying to generate the CFDI from the order.
  • Document stuck in “Pendiente” status — cannot be canceled or converted.
  • Incorrect tax calculation — the VAT total does not match expectations.
  • Extreme slowness when opening the document list.

Root Cause

1. Document Series with Exhausted Folio Range

Each document type (quote, order, remission, invoice) has a series with a folio range (e.g., A-0001 to A-9999). When the current folio reaches the final folio, the system cannot create the next document and shows “Error al crear documento”.

Folio sequence corruption occurs when two users create documents simultaneously or when the system is interrupted during folio assignment.

2. Different Required Fields Between Document Types

A quote has optional fields that become mandatory in a purchase order: source warehouse, payment terms, and with CFDI 4.0, complete fiscal data for the recipient. During conversion, if the client lacks a tax regime or fiscal postal code, the conversion fails.

3. Incomplete Fiscal Data for CFDI 4.0

Since January 2022, the SAT requires every electronic invoice to include:

CFDI 4.0 FieldRequired
Recipient RFCYes
Legal name (exact)Yes
Recipient tax regimeYes
Recipient fiscal postal codeYes
CFDI useYes

A purchase order attempting to convert to an invoice without this data cannot be stamped by the PAC.

4. Tax Conflicts in Mixed Documents

When a document includes items with different VAT rates (16%, 0%, Exempt), the system calculates tax per line item. If an item has an incorrect rate in the catalog, the document total will show unexpected VAT.

5. Inventory Reservation Conflict

When creating a purchase order, CONTPAQi reserves stock. If two users create orders for the same item simultaneously and stock only covers one, the second order will show a reservation error or quantity exceeding available stock.

6. Outdated Print Format

After updating CONTPAQi, some print layout fields (Crystal Reports or the integrated designer) may reference columns that no longer exist in the updated database version, causing errors when printing.

Step-by-Step Solution

Step 1 — Fix the Document Series and Folio

  1. Go to Configuración > Documentos in the main menu.
  2. Select the affected document type (Quote, Order, Remission, etc.).
  3. Click on the corresponding series (e.g., series “A”).
  4. Review the “Folio Final” field. If the current folio is near or equal to the final folio, extend the range (e.g., change from 9999 to 99999).
  5. If the sequence is corrupted (current folio is lower than the last created document), manually adjust the “Folio Actual” to the correct number.
  6. Save and retry creating the document.

Caution: Do not duplicate series with the same prefix across different document types. This can cause folio conflicts in reports.

Step 2 — Complete Client Fiscal Data (CFDI 4.0)

  1. Open Catálogos > Clientes.
  2. Find and open the client record.
  3. In the Datos Fiscales tab, verify and enter:
    • RFC (no spaces, uppercase)
    • Legal name (exactly as shown on the SAT tax status certificate)
    • Tax regime (SAT c_RegimenFiscal catalog)
    • Fiscal postal code
    • Default CFDI use
  4. Save and return to the order or quote. Retry the conversion or stamping.

Step 3 — Fix Tax Rates in the Product Catalog

  1. Go to Inventarios > Artículos (or Catálogos > Productos/Servicios).
  2. Open the product record with the incorrect VAT.
  3. Locate the Impuestos or Datos Fiscales tab.
  4. Assign the correct rate:
    • IVA 16% for taxed goods and services.
    • IVA 0% for food, medicine, and other zero-rate items.
    • Exempt for operations explicitly exempt under Mexican VAT law.
  5. Recalculate existing documents if they already have lines with incorrect rates (you may need to reopen or cancel and recreate the document).

Step 4 — Release a Document Blocked in “Pendiente”

  1. Find the document in the list and open it.
  2. Check the lower panel for any partially linked remission or invoice. If found, cancel or complete it first.
  3. Go to Edición > Cambiar Estatus.
  4. Select “Cancelar” if the document is no longer needed, or “Reabrir” if you need to edit it.
  5. If the option is disabled, check user permissions under Configuración > Usuarios > Permisos de Documentos.

Step 5 — Database Maintenance

For performance issues or corrupted folios that cannot be resolved otherwise:

  1. Close all sessions for the company on all workstations.
  2. On the server, open CONTPAQi Comercial as administrator.
  3. Go to Herramientas > Compactar Empresa. Wait for it to complete.
  4. Then run Herramientas > Reindexar. This process may take several minutes depending on database size.
  5. Restart the CONTPAQi server and reconnect clients.

Alternative Solution

If the error persists when converting a quote to an order, you can create the order manually by entering data directly instead of using the automatic conversion:

  1. Keep the original quote open on screen for reference.
  2. Create a new order from Documentos > Pedidos > Nuevo.
  3. Assign the same client and enter the line items manually.
  4. Once saved, cancel or close the original quote.

This avoids conversion dependencies but loses automatic document traceability.

Prevention

  • Monitor folio ranges monthly. Set an internal alert when the current folio exceeds 80% of the assigned range.
  • Update fiscal data when registering new clients. Always request the SAT tax status certificate before issuing the first document.
  • Separate products by VAT rate in the catalog from creation. Correcting taxes on items with historical transactions is complex.
  • Run compaction and reindexing at least once a month, preferably on Friday afternoons.
  • Avoid concurrent access to the same document. Train staff not to open the same order from two workstations simultaneously.
ProblemLikely CauseArticle
Error stamping CFDI from orderExpired CSD or PAC connectionCONTPAQi Error Timbrar Facturas
Error generating payment complementPPD invoice not correctly linkedCONTPAQi Complemento de Pago CFDI 4.0
Stock errors in remissionsInsufficient stock or active reservationCONTPAQi Inventory Control
Price list errorsExpired validity or no list assigned to clientCONTPAQi Price List Errors

Summary

  • Errors creating documents in CONTPAQi Comercial have four main causes: exhausted folios, incomplete fiscal data (CFDI 4.0), incorrect VAT rates on products, and unmaintained database.
  • The quote → order conversion requires the client to have complete RFC, tax regime, postal code, and CFDI use.
  • Documents stuck in “Pendiente” status are released via Edición > Cambiar Estatus.
  • Monthly compaction and reindexing prevents most performance and corruption errors.
  • Each catalog item must have its correct VAT rate; documents calculate tax per line item, not per document header.