Landed costs

The module creates a shipment file: a truck, a container. You add the purchase orders that arrived together, even from different suppliers, then the costs.

The costs: a label, a type — freight, customs duties and taxes, insurance, forwarder, other —, an amount excluding tax and, if you wish, the matching supplier invoice. This link is there to find the document: no accounting entry is changed.

The spread, cost by cost:

The calculation is done to the cent. Rounding cents go to the lines whose share has the largest remainder: the amount spread always equals the amount of the cost. A negative cost, a credit note for example, is spread the same way. A cost that cannot be spread — a product without a weight for a spread by weight, a zero basis — blocks the application, and the products concerned are named.

Before or after receiving

Before receiving. The landed cost (net purchase price + costs per unit) is written on the lines of the receptions still in draft. When the reception is validated, Dolibarr itself computes the WAP with this cost, using its own formula. The module does not rewrite that calculation.

After receiving, when the carrier’s invoice arrives later. The WAP is corrected product by product, on the part still in stock only: the share of the costs applied is current stock / stock right after receiving. The part already gone is not revalued, and past margins do not change.

What is possible depends on how your purchases enter stock:

In the last case, the module finds no received quantity and cannot apply anything.

The log and undo

Every changed value is recorded with the old and the new value, the quantity, the stock and the amount. The application can be undone, all or nothing, as long as nothing has moved: reception still in draft, line cost, WAP and cost price unchanged. If a single product has changed, nothing is undone and the reason is shown product by product.

The menu is under ProductsWarehousesLanded costs.

A shipment file fits on one page. In the screenshot, the file “Conteneur Le Havre — semaine 41” groups two orders from two suppliers, 5,000 and 15,000 excluding tax, and three costs: 4,000 of sea freight by weight, 1,200 of customs duties by value, 300 of forwarder fees equally.

The “Répartition” (Allocation) table gives, for each line, the quantity, the quantity already in stock, the net purchase price, the unit weight, the allocated costs, the costs per unit and the landed unit cost: 77.35710 for the drill and 59.21430 for the drill bit set, both bought at 50. The allocated costs add up to 5,500.00 again. The file is “Appliqué avant réception” (Applied before receiving); the log shows, line by line, the reception cost before and after.

On the purchase order, the “Frais d’approche” (Landed costs) tab lists the shipment files that contain the order, with their status. The + button creates a new file with this order already added.

Only the products actually processed are changed. A product on several lines takes the average of its landed costs, weighted by quantity.

• Two dedicated permissions: “Read shipment files” and “Create, edit and apply shipment files”. Without the second one, files can still be viewed but no button is displayed, and a forced write is refused.
• Anti-CSRF token checked on every action that writes, including the setup page, which is restricted to administrators.
• Confirmation before applying, undoing or deleting a file. Before applying, the window reports the order lines that are not fully received or in a reception.
• Transactions: an application or an undo that fails along the way writes nothing.
• Applied file locked: neither orders nor costs can be changed until the application is undone.
• Purchase order tab subject to the same access checks as Dolibarr’s purchase order card.
• Multi-company: files, orders, invoices and stock limited to the authorised entities.

The dolixapproche folder, complete and readable source code, under GPL v3 or later: the module descriptor, the screens (list, shipment file card, purchase order tab, setup page), the calculation and application classes, the SQL scripts for the tables and the icons.

No maximum version is set in the module.

• Four tables are added: llx_dolixapproche_dossier (the files), llx_dolixapproche_order (the attached orders), llx_dolixapproche_frais (the costs) and llx_dolixapproche_journal (every changed value, with the old one).
• What the module writes outside its own tables, and only when you apply or undo: the cost of draft reception lines, the products’ WAP and, if the option is ticked, their cost price. No invoice and no accounting entry is touched.
• One setting is stored: DOLIXAPPROCHE_UPDATE_COST_PRICE.
• No outgoing connection: nothing is sent anywhere.
• When disabled, the menu and the tab disappear. Costs, WAPs and cost prices already applied stay as they are: undo the application before disabling if you want to go back. The four tables, with the log, and the setting are not deleted.