Managing sales orders in a dual-currency environment is not a configuration problem — it is a design problem. Most generic order management systems assume a single currency and require workarounds for everything else. This template builds the multi-currency logic directly into the structure.
The Document and the Order
Each entry begins with Doc type — Ped (Pedido/Order), Fac A, Fac B, Nc (Nota de Crédito), Nd (Nota de Débito) — and a document number (Nro). This distinction matters operationally: an order and its resulting invoice are different documents with different fiscal statuses, and collapsing them into the same entry creates reconciliation problems. The template treats them as separate records that share the same structure.
Cliente and Item identify the commercial relationship. Fecha alta establishes the entry date. Cantidad is the quantity. These fields are standard, but they set up the currency logic that follows.
The Currency Calculation Chain
Tipo $ selects whether the transaction is priced in Argentine pesos ($) or USD. Precio $ carries the peso price; Precio usd carries the dollar equivalent. Tc usd is the exchange rate at transaction time.
Precio final calculates the effective price in pesos: (Precio $ + Precio usd) × Tc usd. This formula handles the common scenario where a quoted price has a USD component that needs conversion to the local base currency at the current rate.
Total s/iva multiplies Precio final by Cantidad — the subtotal before tax. Coef (iva) carries the applicable IVA coefficient, typically 0.21 for the standard 21% rate. The Iva field calculates the tax amount, and Total fac. sums subtotal plus tax to produce the invoiced total.
That chain — price in two currencies, exchange rate applied, quantity multiplied, tax calculated, total produced — runs entirely through calculated fields. The seller enters six values; the rest updates automatically.
Operational Fields
Cobrado (collected) is a boolean that marks whether the invoice has been paid. Vendedor identifies the salesperson. Together they give the view that matters for settlement review: unpaid invoices by seller, filtered by document type, sorted by date.
In a market where exchange rate movements can materially change the peso cost of a dollar-denominated transaction from the order date to the payment date, having Tc usd as an editable field rather than a fixed rate gives accurate economics at both points.