Your largest customer wants another discount. A fast-selling product needs four months of stock. One branch shows a loss once head-office costs are allocated.
Do you approve the discount, buy the stock or close the branch?
Most UAE finance teams can produce a profit figure for each. Fewer can say whether it is right, because that depends on how the ERP was set up.
With 30 years in the UAE technology market and a decade of SAP experience, Pinnacle’s view is simple: design profitability reporting around the decisions management must make, then set up the ERP so its numbers can carry those decisions.
What is ERP profitability analysis?
ERP profitability analysis uses the transactions already in your ERP to measure revenue, cost and contribution by customer, product, branch or business unit, so management can decide on pricing, customer terms, stock and investment.
Which profit are you measuring?
“Is this customer profitable?” depends on what you include. A useful model separates five layers:| Profitability layer | What it measures | Decision it supports |
|---|---|---|
| Gross margin | Net revenue less recognised cost of goods sold | Are selling prices covering product costs? |
| Customer or channel contribution | Gross margin less attributable fulfilment and service costs | Are the commercial terms viable? |
| Branch or business-unit contribution | Contribution after directly attributable operating costs | Is the operation contributing towards shared costs? |
| Allocated operating result | Result after an agreed share of central overheads | How does the business perform on a fully allocated basis? |
| Capital-adjusted management view | Contribution alongside working capital and an explicit capital charge | Is the return adequate for the cash committed? |
Two customers, the same sales: which one earns more?
Two customers of a UAE distributor. Figures are illustrative annual amounts in AED, exclude VAT (receivables included) and are not Pinnacle customer results.
| Measure | Customer A | Customer B |
|---|---|---|
| Net revenue after discounts, rebates and returns | 2,000,000 | 2,000,000 |
| Cost of goods sold | 1,600,000 | 1,600,000 |
| Gross margin (20% for both) | 400,000 | 400,000 |
| Attributable delivery, handling and account-service costs | 140,000 | 50,000 |
| Contribution before shared overheads | 260,000 | 350,000 |
| Average collection period | 95 days | 40 days |
| Average receivables (revenue × days ÷ 365) | 520,548 | 219,178 |
| Capital charge on receivables at an assumed 6% | 31,233 | 13,151 |
| Contribution after capital charge | 228,767 | 336,849 |
On a gross-margin report the two look identical. After service costs, Customer B contributes AED 90,000 more. Customer A also pays 55 days later, tying up about AED 301,000 more in receivables; at an assumed 6% cost of capital the gap widens to about AED 108,000. The charge is a management estimate on its own line, so do not also count financing costs already in the accounts.
The case is for renegotiating, not dropping Customer A: a minimum order value, a charge for urgent deliveries, rebates linked to prompt payment, or shorter credit terms.
How does this change the three decisions?
- The discount: compare it with contribution after service and credit costs, not gross margin. A 2% discount for Customer A is AED 40,000, about 17% of its AED 228,767 contribution. Grant it only for terms that recover the cost, such as larger orders or faster payment.
- The stock: Product A, the fast seller, earns AED 240,000 on AED 800,000 of average stock (AED 0.30 per dirham); Product B earns AED 180,000 on AED 300,000 (AED 0.60). For four more months of A, ask what extra contribution that stock would earn, not what today’s stock earns, and set it against cash, storage and obsolescence risk.
- The branch: a branch can contribute positively and still show a loss after head-office allocation. Closing it removes the contribution, but most allocated cost stays. Compare the costs that would disappear with the contribution lost.
Figures are illustrative. Together these answer the title: fund the growth that earns an adequate contribution on the cash it commits.
Which six setup decisions decide whether you can trust the numbers?
Each answer depends on the ERP producing numbers such as the AED 140,000 service-cost line. Six choices made during implementation decide that.1. How costs are tagged at posting
SAP Business One supports up to five cost accounting dimensions, such as branch, department and product line, with distribution rules that split amounts by percentage or fixed amount. Agree the dimensions before go-live: history stays on the old basis unless it is corrected.2. Which cost the system uses to calculate margin
Gross profit on each sales document row is the selling price less a base price: item cost, last purchase price, last evaluated price or a price list. The choice changes the gross profit shown, not the cost of goods sold posted. When supplier prices rise or a non-dollar currency strengthens against the dirham, a sale from older stock overstates the margin a repeat sale would earn, so label the basis and check prices against replacement cost.3. When landed costs reach the item
Duty, freight, clearing and port charges belong in the cost of imported goods. The landed costs function allocates each charge by quantity, weight, volume, cash value before or after customs, or equally; spreading freight by value under-costs bulky items. Costs posted after goods are sold do not change the margin on invoices already issued, so set a posting deadline.4. How rebates and late credits are accrued
Rebates and year-end claims often settle months after the sale. Retrospective rebates need a defined process in SAP Business One: tracking fields, a monthly accrual journal or an add-on. Without one, the rebate lands when paid and the customer looks more profitable than it is for most of the year.5. Where freight and service costs are posted
Freight and handling usually arrive as a monthly invoice posted to a general expense account, with no customer attached. To build cost-to-serve, record freight on the sales document, capture delivery drops by customer or tag service costs to a customer-group dimension.6. Fixed rules or cost drivers for shared costs
Fixed-percentage rules suit rent but not costs that move with activity: a fixed 20% of warehouse cost stays at 20% whether a branch’s volume doubles or halves. Update those rules each period from drivers such as order lines or pallet-days, or calculate them in a reporting layer.What does SAP Business One do as standard, and what must be designed?
| Requirement | Standard in SAP Business One | What the implementation must define |
|---|---|---|
| Profit by branch or department | Up to five dimensions, cost centres, distribution rules | Dimensions agreed before go-live |
| Gross profit by sale | Gross profit per document row against a base price | A deliberate, labelled base-price choice |
| Import landed cost | Landed costs with six allocation methods | Allocation basis per charge, posting deadline |
| Retrospective rebates | Discounts at the time of sale | Tracking fields, accrual routine or add-on |
| Customer cost-to-serve | Gross profit by customer from sales documents | Freight and service costs captured per customer |
| Activity-based allocation | Fixed percentage or amount rules | Periodic driver updates or a reporting layer |
When is SAP S/4HANA Cloud the better fit?
As a group adds entities, currencies and manufacturing, more of this moves into the system. SAP S/4HANA Cloud Public Edition includes Margin Analysis in the same universal journal as the general ledger, so booked figures reconcile by design:
- Market segments: customer, product and sales organisation travel with sales postings.
- COGS by component: manufacturers can split cost of goods sold into material, labour and overhead.
- Top-down distribution: aggregate costs such as freight can be spread to customers and products in proportion to revenue.
Where should you start?
Take the decision that matters most this year and one closed accounting period, and build the contribution view for that decision only. Reconcile it to the ledger, then check the six setup decisions against your configuration. Once trusted, review it monthly and name an owner for each response. For industry detail, see Pinnacle’s ERP for trading and distribution, retail IT solutions and SAP Business One for manufacturing.
How can Pinnacle help?
Pinnacle Computer Systems is a Dubai-based SAP Gold Partner with 2,000+ clients and offices in Dubai and Abu Dhabi. It implements SAP Business One for companies with 10 to 75 employees and SAP S/4HANA Cloud Public Edition for growing multi-entity or multi-currency businesses, starting with process and gap analysis, the right point to agree dimensions and cost capture. It also offers business intelligence and analytics. Talk to Pinnacle’s SAP team about the profitability decisions your current reporting cannot support. Request a free demo, call +971-4-335 0053 or email sales@pinnacledxb.com.FREQUENTLY ASKED QUESTIONS
1. Can an ERP show net profit by customer?
Not on its own. It can show customer contribution, and profit after allocated overheads if rules are set up, but neither equals statutory net profit.
2. Does SAP Business One show profit by customer?
Gross margin by customer is standard. Contribution after freight, service costs and rebates needs those costs captured against the customer.
3. Should we drop every loss-making customer or product?
No. Check whether the loss comes from avoidable costs, allocations or temporary conditions, and test repricing first: a dropped customer leaves its overheads behind.
