ERP for Trading & Distribution: Landed Cost, Stock & Credit

ERP for trading and distribution needs to do a few things exceptionally well: buy in one currency and sell in another, calculate the true landed cost of every item, keep inventory accurate across warehouses, control customer credit, and apply the right price to the right customer every time. Margins in trading are often thin, so small errors in cost, price or stock compound quickly.

Traders and distributors usually outgrow basic accounting software when they add a second warehouse, start importing in volume, or extend credit to more customers than the finance team can track manually. This guide covers what a trading ERP should handle and what to watch for during implementation.

Multi-currency purchasing and sales

Importers commonly buy in one currency, sell in another and report in a third. The ERP should handle this natively, not through manual journal entries.

• Transaction currency per document: purchase orders, supplier invoices, sales orders and customer invoices each carry their own currency.
• Exchange rates maintained daily or imported automatically, with the option to use an agreed rate on a specific transaction.
• Realized gains and losses calculated when a foreign-currency invoice is paid at a different rate from the invoice date.
• Unrealized revaluation of open foreign-currency balances at period end, if your accounting policy requires it.
• Bank accounts in multiple currencies, with reconciliation in the account's own currency.

Confirm with your accountant how exchange differences should be posted before configuration. Getting this wrong creates reconciliation problems that surface months later.

Landed cost: knowing what an item really cost

The supplier's invoice price is only part of the cost of an imported item. Freight, insurance, customs duty, clearing charges, port handling and inland transport all belong in inventory cost. If they are expensed instead, gross margin by product is overstated and pricing decisions are made on bad data.

A trading ERP should let you attach landed cost charges to a shipment or goods receipt and allocate them across the items received. The allocation basis matters:

Timing is the practical challenge. Freight and clearing invoices often arrive after the goods are received and some have already been sold. Agree a process: either estimate landed costs at receipt and true them up later, or hold the receipt costing open until all charges arrive. Your ERP should support whichever you choose, and the choice should be documented in the requirements checklist.

Inventory across warehouses

Distributors live and die by inventory accuracy. Key capabilities:

• Multiple warehouses and bin locations, with stock visible per location.
• Batch and serial tracking where products have expiry dates, warranties or regulatory traceability.
• Expiry management with first-expiry-first-out picking for perishables, pharmaceuticals and chemicals.
• Units of measure: buying by the pallet or carton and selling by the piece, with correct conversions.
• Inter-warehouse transfers with goods-in-transit visibility.
• Barcode scanning for receiving, picking, packing and counting.
• Reorder rules by item and warehouse, based on minimum and maximum levels or demand history.

Choose your inventory valuation method (weighted average or FIFO are most common for traders) with your accountant, since it affects margin reporting and is hard to change later. Make cycle counting part of the weekly routine rather than relying on an annual stock take.

Credit control

Many distributors carry significant receivables, and a few slow-paying customers can strain cash flow. Credit control in the ERP should be enforced, not just reported:

• A credit limit and payment terms per customer.
• Automatic blocking or approval routing when a new order would exceed the limit, or when invoices are overdue beyond a set number of days.
• Aging reports by customer, salesperson and region.
• Payment reminders sent automatically on a schedule.
• Visibility of open orders and outstanding balance for the salesperson before they commit to a customer.

Credit holds work best when the rules are clear and the override process is fast. If releasing a hold takes a day, sales teams will find ways around the system. A simple approval workflow, with the finance manager notified on mobile, keeps control without stalling orders. This is a good candidate for workflow automation.

Pricing and discounts

Pricing in distribution gets complicated quickly: customer-specific price lists, volume breaks, promotional prices with date ranges, discounts by product group, and price lists in different currencies. The ERP should hold these as rules rather than relying on salespeople to remember them.

Practical pricing capabilities to test:

1. Price lists per customer group, currency and date range.
2. Quantity breaks and tiered pricing.
3. Discount limits per user role, with approval above the limit.
4. Margin visibility on the sales order, based on landed cost.
5. Bulk price updates when supplier costs change.

Showing margin on the order screen, calculated from true landed cost, is one of the most useful things a trading ERP can do. It changes how salespeople negotiate.

Purchasing and supplier management

On the buying side, a trading ERP should track the full import cycle: purchase order, supplier proforma, advance payment if required, shipment details (container, bill of lading, expected arrival), goods receipt, and final supplier invoice. Buyers need to see what is on order and in transit, by item and expected date, because that stock is effectively available to promise to customers.

Useful supplier-side capabilities include supplier price lists in the supplier's currency, minimum order quantities and pack sizes, lead times per supplier and item, and partial receipts against a single order. Purchase suggestions based on reorder levels, open sales orders and stock in transit help buyers order the right quantities without building lists by hand.

Reporting that traders actually use

A handful of reports drive most decisions in a distribution business:

• Gross margin by product, customer, salesperson and region, based on landed cost.
• Stock aging and slow-moving items by warehouse.
• Stock in transit and expected arrivals.
• Receivables aging and customers on credit hold.
• Sales against target, by period.

Define these early. If a report cannot be produced from the data the system captures, the gap shows up in requirements, not after go-live.

Sales channels and integrations

Distributors increasingly sell through several channels: field sales, a B2B ordering portal, e-commerce, marketplaces, and EDI with large retail customers. Each channel should create orders in the ERP directly, against the same stock and pricing rules. Common integration points include e-commerce platforms, shipping carriers, payment gateways, CRM, and customs or e-invoicing systems where local regulations require them. Plan these with a clear owner through system integration rather than adding point-to-point connections one at a time.

Choosing a platform

Most mid-market ERPs handle trading well at a basic level; the differences show in landed cost handling, multi-warehouse depth, pricing flexibility and reporting. ERPNext, Odoo and Zoho Inventory with Zoho Books are common choices for growing distributors, each with different trade-offs. The trading ERPNext migration case study describes one migration path. When migrating, bring across open balances, live item masters and open orders rather than years of history, as covered in the ERP migration checklist.

Next steps

If you cannot say with confidence what a product cost to land or which customers are over their credit limit right now, it is time to look at your process and systems together. I help traders and distributors map their order-to-cash and procure-to-pay flows and implement ERP that fits them. Contact me to discuss your situation, or read about my ERP consulting services.

Frequently Asked Questions

What is landed cost and why does it matter?

Landed cost is the full cost of getting an item into your warehouse: purchase price plus freight, insurance, duty, clearing and handling. If those charges are expensed instead of added to inventory, product margins look better than they are and pricing decisions are based on incomplete cost.

How should landed costs be allocated across items?

It depends on the charge. Duty and insurance usually follow value, freight often follows weight or volume, and handling may follow quantity. A good trading ERP lets you choose the basis per charge and apply it to a shipment or goods receipt.

Can an ERP stop sales to customers over their credit limit?

Yes. Most ERPs can block or route for approval any order that would exceed a customer's credit limit or when invoices are overdue. The key is a fast override process, so legitimate orders are not delayed and sales teams do not work around the system.

Which inventory valuation method should a distributor use?

Weighted average and FIFO are the most common. The right choice depends on your products, accounting policies and local requirements. Decide with your accountant before go-live, because changing the valuation method later is disruptive.