Your Lemonade Stand Made $100. Finance Has Questions.

My daughter’s lemonade stand day has officially turned into a three-part ERP series, which is probably a sign that I need hobbies that do not involve Microsoft documentation and inventory costing.

But here we are.

Week one was the big idea: a lemonade stand is basically an ERP system wearing poster board.

Week two was procurement: because someone has to buy the lemons, cups, sugar, ice, and the emergency backup supplies after a parent realizes “we probably have enough” is not a purchasing strategy.

This week, we get to the part every operator loves right up until finance joins the conversation.

Money.

Because at the end of lemonade stand day, the kids count the cash box. They stack up the dollars. They count the quarters. They announce the total with the confidence of a CFO on earnings day.

“We made $100!”

And as a dad, I love that moment.

As an ERP guy, I immediately become the worst person at the party.

Because I have questions.

What did the lemons cost?

What did the cups cost?

How much sugar did we use?

This is where every business eventually has to grow up.

Revenue feels great.

Margin tells the truth.

And in D365 Finance & Operations, that truth is only as good as the setup, costing, dimensions, charges, discounts, and operational discipline feeding the system.

The Cash Box Is Not a P&L

A cash box is wonderfully simple.

You open it.

You count what is inside.

You declare success.

Everyone gets excited.

That works for a lemonade stand because the goal is not perfect financial reporting. The goal is kids learning how to sell, serve customers, handle money, and maybe understand that a table, a sign, and a little confidence can turn lemons into something more interesting than juice.

But a business cannot stop at the cash box.

I have been in plenty of ERP conversations where a company has beautiful sales reporting and very questionable margin visibility. They know what they sold. They know who they sold it to. They may even know what warehouse it shipped from. But when you ask what they actually made on the sale, the room gets quieter than a conference bridge five minutes after go-live.

That is the difference between revenue reporting and profitability insight.

Revenue says, “We sold $100.”

Finance says, “Great. What did we keep?”

That is not finance being difficult. That is finance doing its job.

In F&O, posting the sales invoice is not the end of the story. It is one part of the story. The other parts live in item cost, inventory value, production consumption, purchase prices, charges, discounts, financial dimensions, and posting setup.

Product Cost Is Where the Story Gets Real

The fastest way to make margin reporting useless is to pretend product cost will somehow figure itself out.

It will not.

Product cost is one of those areas that feels boring until the business starts making decisions based on it. Then suddenly everyone wants to know why margins look wrong, why one product line appears more profitable than expected, why a customer account looks fantastic on revenue but terrible on contribution, or why finance is side-eyeing operations during the monthly close meeting.

At the lemonade stand, cost sounds simple.

Lemons. Sugar. Cups. Ice.

But even there, the details matter.

If your daughter’s recipe says six lemons per pitcher but the actual production process involves twelve lemons because “it tastes better,” your cost model is already fiction. Cute fiction, sure. Probably delicious fiction. But fiction.

That is exactly what happens in F&O when the system has one version of reality and the shop floor, warehouse, buyer, or sales team has another.

The BOM says one thing.

The formula says another.

The operator consumes something else.

The buyer pays a different price.

The sales team discounts the order.

Finance closes inventory and wonders why the margin report looks like it was assembled during a fire drill.

This is where costing methods, item model groups, inventory valuation, purchase prices, standard costs, production costing, and cost rollups stop being configuration trivia and start becoming business truth.

A company using standard cost needs discipline around cost activation and variance analysis. A company using FIFO, weighted average, or moving average needs to understand how purchase price fluctuations, receipts, issues, and inventory close affect financial results. A manufacturer needs to care deeply about whether the BOM or formula reflects how the product is actually made.

Because F&O is not going to raise its hand and say, “Hey, I think your recipe is aspirational.”

Sales teams love flexibility. Finance loves control. Operations loves consistency. ERP consultants love when everyone pretends these priorities are already aligned before the pricing workshop starts.

In D365 F&O, pricing can involve trade agreements, sales price groups, discounts, customer-specific pricing, item-specific pricing, manual line discounts, multiline discounts, total discounts, rebates, charges, and, depending on the roadmap, more advanced pricing capabilities.

That is not just configuration.

That is commercial strategy.

The danger is not discounting. Discounts can be perfectly valid. The danger is discounting without governance, visibility, or an understanding of margin impact.

Charges Are the Costs Everyone Forgets Until Finance Finds Them

This is one of my favorite places where margin gets quietly mugged in an alley.

Charges.

Freight. Handling. Packaging. Fuel surcharge. Delivery fees. Credit card fees. Tariffs. Broker fees. Special handling. Small order fees. Expedited shipping. Setup fees. Disposal fees. Environmental fees. All the little costs that seem too small to obsess over until they start showing up everywhere.

The lemonade stand has them too.

Cups are not lemonade, but you need them to sell lemonade.

Ice is not lemonade, but warm lemonade is a customer experience problem.

Poster board is not lemonade, but signage drives traffic.

Gas for the last-minute supply run is not lemonade, but someone had to make that panic drive to the store.

Napkins are not lemonade, but sticky customers are bad for the brand.

In real businesses, these costs get ignored because they are not always part of the obvious product story.

That is how companies end up with margin reports that look better than reality. The product cost may be right. The sales price may be right. But if freight, packaging, handling, or other charges are floating outside the margin conversation, the business is lying to itself by omission.

D365 F&O has ways to handle charges through miscellaneous charges and auto charges, depending on the scenario. The key is not simply whether charges can be configured. The key is whether the business has decided how those charges should behave.

Inventory Valuation Is Not Just a Finance Problem

Inventory valuation is one of those areas people love to hand to finance until something goes wrong.

Then suddenly everyone is involved.

And the ERP team gets asked why inventory is “wrong,” which is always a fun word because it can mean approximately 47 different things.

In the lemonade stand world, inventory valuation is easy to ignore.

You bought supplies. You used some. You sold lemonade. Maybe some lemons are left over. Maybe some were wasted. Maybe the ice melted. Maybe the kids drank half the product because quality control became suspiciously thirsty.

In a business, those details matter.

Dad joke to close this one out:

Why did finance audit the lemonade stand?

Because the kids said they had sweet margins, but finance found a lot of hidden pulp.

DynamicsDad