LC and Trade Documents in Odoo 19: The Workflow We Designed for a GCC Chemical Trader

ERP dashboard connecting LC, shipping, logistics, warehouse and trade documentation workflows

Key takeaways

  • In bulk trading, a deal is a chain of documents: proforma, customer PO, LC, supplier PO, bill of lading, certificates, customs declaration and invoice. Most delays start when these live in different inboxes.
  • Banks check every document against the LC terms. Small differences in wording, dates or quantities are enough to delay payment, even after the goods have shipped.
  • For TAM Trading, we designed a two-step LC review (Operations checks technical terms, Finance checks financial terms) and a document matrix that blocks clearance and invoicing until the required documents are uploaded.
  • Odoo 19 covers Incoterms, dropshipping and document attachments as standard [1][2]. An LC review, a document matrix and shipment tracking with vessel and container details need configuration or development.

Overview

TAM Trading ships in four ways: direct from the supplier, through a 3PL warehouse, intercompany from the UAE to KSA, or locally from stock. It prices in several Incoterms and currencies, and each shipment travels with bills of lading, certificates of origin and analysis, MSDS, halal and weight certificates, and insurance.

When we documented TAM’s requirements, LC and bank documents needed manual coordination between departments, and shipment documents moved by email. Shipments could wait at port because a certificate was missing, which leads to demurrage charges.

One transaction with every department working from the same record

This article explains where trade document workflows break, the workflow we designed for TAM, and where Odoo 19’s standard features fit. It describes the agreed design, not results from a live system.

The deal is a chain, not a single task

An import or export deal passes through several teams and outside parties. A customs hold can start with an invoice prepared weeks earlier. An LC discrepancy can go back to a detail agreed at the quotation.

StageOwnerMain documentsWhere it often breaks
1. Proforma and agreementCommercialProforma, agreed IncotermSpecs, Incoterm or payment terms differ from what was quoted
2. Customer PO and paymentCommercial and FinanceCustomer PO, LC or advanceLC terms do not match later documents
3. Supplier orderProcurementSupplier PO, supplier proformaSupplier updates arrive by email or phone
4. Shipment preparationSupplier and LogisticsCommercial invoice, packing list, certificatesSeveral versions of the same document
5. Bank presentationFinanceLC document setWording, date or quantity differs from the LC
6. ShippingLogisticsBill of lading, ETD and ETANo single place to see milestones
7. Customs clearanceLogistics and brokerCustoms declaration, origin documentsInvoice and declaration do not match
8. Receipt, delivery and invoiceOperations and FinanceGoods receipt, delivery note, customer invoiceDelivery is done but payment is held
LC-to-shipment workflow in eight stages, with the owner and documents at each stage

Common causes of trade document delays

Eight common causes of trade delays
  • LC discrepancies. Banks examine documents against the LC terms under the ICC’s UCP 600 rules. A spelling difference, a late date or a missing certificate can be enough for a discrepancy.
  • Documents spread across departments. Commercial holds the proforma, Finance holds the LC, Logistics holds the shipping documents. Nobody has the full file.
  • Several versions of one document. A revised packing list or LC amendment arrives, and the old version keeps circulating.
  • Approvals hidden in email. Nobody can see where a proforma or exception is waiting.
  • Customs errors. A wrong HS code or a mismatch between invoice and declaration holds the cargo.
  • Supplier updates outside the system. ETD changes arrive by WhatsApp and never reach Sales.
  • Nobody owns the deadline. LC expiry and shipment cut-off dates are tracked by hand.
  • Problems noticed late. The delay is found after it has started, not before.

The visible cost is demurrage. The full cost also includes storage, faster transport to recover lost time, rework on documents, time spent updating customers, and cash collected later than planned because the bank is holding payment.

The proforma invoice: the document everything else checks against

In TAM’s design, Operations prepares the proforma invoice, not Sales. It has a fixed content list: product specifications, unit and total price, manufacturer name and address, Incoterm, port of shipment, packaging, and payment terms such as “LC at 75 days from BL date”. The proforma follows the quotation and customer PO checks made earlier in the deal.

Four rules protect it:

  • Approval before sharing. The proforma goes through Procurement and then Finance. Until it is approved, Sales cannot download or email it, and it carries a “Not Approved” watermark.
  • Manufacturer lock. A quotation may mention several origins, but the final manufacturer is fixed at the proforma stage and can only change with re-approval.
  • 7-day validity. An expired proforma cannot be used to open an LC or confirm an order until an authorised user reactivates it, and the reactivation is logged.
  • Quantity split. A large customer PO can be split into several proformas, for partial shipments or to fit LC value limits.

The LC review: two departments, two sets of checks

When the customer sends the LC draft, Sales uploads it and it is linked to the proforma with full version history. Then two reviews follow:

ReviewWhoWhat is checked
TechnicalOperationsProduct description, quantity and price; Incoterm; shipment window; required documents; discrepancy tolerance and insurance
FinancialFinancePayment clauses; bank charges; currency exposure; confirming bank; risk level of the issuing bank

The system highlights any difference between the LC and the proforma across more than 20 key fields. The deal cannot move forward until each difference is resolved. If an amendment is needed, the request goes back through Sales to the customer, and the new draft is reviewed again by both teams. For customers on open account, the equivalent control is the payment gate before procurement.

When the bank confirms the LC, Finance records the advice and the deal status becomes LC Confirmed / Payment Secured. Only then can the supplier PO be created. Advance, partial and open-credit deals follow the same rule, using the payment record instead of the LC.

LC review workflow: proforma approved, LC draft uploaded, Operations and Finance reviews, differences resolved, payment secured and supplier PO unlocked
The LC review in the TAM design, from approved proforma to a secured payment.

Checking the LC draft before it is issued is far cheaper than finding a problem when the documents are presented to the bank. At that point the goods have usually shipped.

The document matrix

Required documents depend on the deal. TAM’s design uses a matrix of country × product × Incoterm × shipment type to decide which documents are mandatory. Sales sees the list at the proforma stage, and SCM sees it when preparing the shipment. If a mandatory document is missing, a red flag appears and delivery scheduling and invoicing are blocked.

An illustrative example of how the matrix works:

DealMandatory documents
Soda ash, CIF, direct from supplier, to OmanBill of lading, commercial invoice, packing list, certificate of origin, certificate of analysis, insurance certificate
Food-grade product, CFR, to KSAAs above, plus health certificate and halal certificate
Local delivery from 3PL stock, UAEDelivery note, weight certificate, tax invoice

Documents collected from the supplier and forwarder include the bill of lading, commercial invoice, packing list, certificates of origin and analysis, health certificate, inspection report and insurance. Each is linked to the shipment, the purchase order and the customer invoice.

Shipment tracking from Planned to Cleared

Each purchase order creates a shipment record with the vessel name, container numbers, ETD, ETA, load and discharge ports, and freight forwarder. The status moves through Planned, Booked, On Board, In Transit, Arrived and Cleared, and updates when ETD, ETA or receipt events happen. When the arrival notice comes in, Logistics updates the ETA, and every role sees it on the sales order.

Free Zone clearance invoice

For goods leaving a Free Zone, TAM needs an invoice for customs only. The design specifies a non-posting customs invoice: it does not affect the ledger or the customer’s balance, and it hides the supplier name and TAM’s internal charges. It is paired with the real tax invoice. How stock moves between the UAE and KSA entities is covered in stock across UAE and KSA.

If documents are holding up your shipments or your payments, we can map your current flow and show what Odoo would handle.

What standard Odoo 19 covers

Incoterms

Odoo 19 includes all 11 standard Incoterms by default: EXW, FCA, FAS, FOB, CFR, CIF, CPT, CIP, DPU, DAP and DDP [1]. The Incoterm decides which freight and duty costs flow into the landed cost per deal.

  1. On an invoice or bill, open the Other Info tab and choose the Incoterm.
  2. Add an Incoterm Location, for example the destination port for CIF.
  3. To fill it in automatically, go to Accounting › Configuration › Settings and set a Default Incoterm in the Customer Invoices section [1].

If your contracts use older terms, add them as extra records.

Direct shipments from the supplier

When the supplier ships straight to the customer, Odoo’s dropshipping covers the basic flow [2]:

  1. In Purchase › Configuration › Settings, turn on Dropshipping.
  2. On the product, set the vendor and enable the Dropship route.
  3. When the sales order is confirmed, Odoo creates a purchase order to the vendor, with a dropship transfer for the delivery.
Odoo 19 dropship sales order with the Purchase smart button
A dropship sales order with the linked purchase order [3].

For a trader using LCs, the dropship route needs one change: the purchase order must not be confirmed until the payment gate is passed. In TAM’s design, that is the LC advice or payment record.

Documents on the record

Odoo lets you attach files to sales orders, purchase orders, transfers and invoices, and the Documents app can organise them in folders. That gives one place to find the files for a deal. Deciding which documents are mandatory, and blocking the next step when one is missing, is the part that needs the document matrix.

What needs configuration or development

RequirementStandard Odoo 19What we specified for TAM
LC review by two teamsNo dedicated LC workflowLinked LC record, version history, two approvals
Field-by-field LC comparisonNot availableHighlighted differences across 20+ fields
Mandatory documents by dealAttachments onlyDocument matrix with blocking rules
Shipment with vessel and containerNot available as standardShipment record with statuses and dates
Customs-only invoiceNot availableNon-posting invoice paired with the tax invoice

Checklist for an LC and document workflow in Odoo

  • Fix the proforma content and who may issue it.
  • Write the LC checks for Operations and for Finance separately.
  • Build the document matrix: country, product, Incoterm and shipment type.
  • Decide what is blocked while a document is missing.
  • Define shipment statuses and who updates ETD and ETA.
  • Set the default Incoterm and make sure every proforma has one.
  • Decide where files are stored and how versions are named.

FAQ

Does Odoo have a standard LC workflow?

Not as a dedicated feature. For TAM, we specified the LC review, version control and the payment gate as part of the design.

Which Incoterms does Odoo 19 support?

All 11 standard Incoterms are available by default, and you can set an Incoterm location and a default Incoterm [1].

Can Odoo handle shipments direct from the supplier?

Yes, through dropshipping. Confirming the sales order creates the purchase order to the supplier [2].

Can Odoo issue an invoice for customs only?

Not as a standard document type. TAM’s design includes a non-posting customs invoice for Free Zone exits.

What causes most LC payment delays?

Differences between the documents presented and the LC terms, such as wording, dates or quantities. Checking the LC draft against the proforma before it is issued avoids many of them.

Keep every deal’s documents in one place

If your team still searches inboxes for the latest LC draft, start by listing the documents in one deal and who owns each. We can map it into Odoo with you. See how we approach Odoo for trading and distribution projects.

References

[1] Odoo, Incoterms, Odoo 19.0 documentation. https://www.odoo.com/documentation/19.0/applications/finance/accounting/customer_invoices/incoterms.html

[2] Odoo, Dropshipping, Odoo 19.0 documentation. https://www.odoo.com/documentation/19.0/applications/inventory_and_mrp/inventory/shipping_receiving/daily_operations/dropshipping.html

[3] Screenshot: Odoo S.A., Odoo 19.0 documentation, Dropshipping, licensed under CC BY-SA 4.0 (https://creativecommons.org/licenses/by-sa/4.0/). https://www.odoo.com/documentation/19.0/applications/inventory_and_mrp/inventory/shipping_receiving/daily_operations/dropshipping.html

  • Kawser Ahmed is the Founder & CEO of Softeko, a global IT consultancy with offices in Dhaka and Dubai. A tech entrepreneur, investor, and AI enthusiast, he has led numerous software and web projects, including the successful ExcelDemy.com. Kawser holds an Odoo 18 Functional Certification and has deep expertise in business process management, finance, SEO, and software development. He's also a Technical Analysis trainer at Dhaka Stock Exchange Ltd., with popular online courses on AmarStock.com and Udemy. A lifelong learner, Kawser explores how business, technology, and global markets work.

    View all posts

Want to write an article for our blog? Read our requirements and guidelines to become a contributor.

Leave a comment

Your email address will not be published. Required fields are marked *

Get Free Consultancy
Odoo Consultant
Get Free Consultancy
Book a meeting with an expert → Shafiuddin Haider, Odoo ERP Consultant
☰
Table of Contents