HYD --:--

Work / Case 03, ZYOD (ERP)

Price Variation in SO and PO

Connected cost sheets and pricing across Style Curation, Sales Orders, and Purchase Orders so the same number is not typed three times.

Edit a price and watch the margin
SO-1234/Cost sheet 1 01/04/24, 12:04 AMCreated by: Sam
WWDR0001_05 Western - Dresses Avail: 1000 SO Qty: 100
INR
Defaults from Style Curation
NameDescriptionWidth (Inch)AvgPrice /
1. Bill of materialsTotal : ₹112
1.1 FabricFabric Total : ₹100
1.2 TrimTrims Total : ₹12
2. CMTTotal : ₹99
3. ProcessTotal : ₹100
4. AdditionalTotal : ₹52
TypePrice (INR)

Fabric100.00

Trim12.00

CMT99.00

Process100.00

Additional52.00

(A) : Sub-Total (Base Costs)363.00

Factory Margin Rs

(B) : Sub-Total (Operational Costs)418.00

Target Margin% 104.50

Total Price : (A) + (B) + (Target Margin)522.50

SO Rate

New Margin29%122.00

Role
Product designer, requirements through costing and pricing UI
Context
Part of the same ERP tooling work as the TNA mobile cards and the jobwork completion form, for a fashion-manufacturing company in Gurugram, this time connecting Style Curation, Sales Orders, and Purchase Orders around a single cost and price truth.
Scope
Costing table, costing summary, and the SO and PO sync from Style Curation
Timeline
Add real timeline (kickoff to rollout)
3

systems synced: Style Curation, Sales Orders, Purchase Orders

2

modules connected to one pricing source: SO and PO

Add metricreduction in manual cost-sheet updates
Add metricreduction in pricing and margin calculation errors
01 The Stakes / Problem

The same three facts, retyped in three modules.

A style had a cost. Sales needed it to price an order. Procurement needed it to set an optimal buy price. Three modules that didn't talk, so people retyped it, and margin math followed the drift.

One cost, typed three timesTry “Sync from Style Curation”
CatalogStyle Curation₹410Holds the default cost
The dealSales Order₹412, retypedCost sheet rebuilt by hand
The buyPurchase Order₹405, retypedOptimal price typed again
3versions of the truthEvery copy a chance to driftNo shared record
Illustrative values.
What was actually brokenPick a gap
The gapThe same SKU, priced three times

Entered by hand at every stage. Never quite the same number.

What answered itDefault cost and optimal price fetch from Style Curation on create
Image placeholder: Original manual cost-sheet and pricing workflow, for contrast
02 Who Was Stuck

Two jobs, one source.

Look through each rolePick a role
Needs

“Defaults that arrive on their own, editable costs, margins, and groups, and SO rate and margin visible while editing”

Owns
Cost sheets and margins on the sales order
Before
Typed cost and price per SKU; lost pricing visibility mid-flow
Cost sheetReads first
1Default costs2Groups
3Margin4SO price
Optimal price

Auto-lock every field and deals can't flex. Leave everything manual and it's Excel rebuilt inside the ERP.

03 Your Thinking

Decide what always syncs, and what always stays a judgment call.

I wrote the rules before the table: defaults fetch from Style Curation when an SO or PO is created; the cost sheet is editable from the SO in Draft or Confirm; optimal price variations from the PO. Then the line between them.

03/Sync rules

Catalog truth, or this deal's call?

Drag or tap a field

Five numbers on a cost sheet. Pick one, then decide: sync it, or leave it editable?

A product boundary, not a UI preference. Auto-sync without an override trains people to work around the system. Override without a source of truth trains them to keep a side spreadsheet. And a synced module that accepts a broken sheet just moves the error downstream faster.

04 The Solution

Four pieces, one pricing source.

Style 5047 · cost sheetEdit any number

Defaults fetched from Style Curation

Base
Operational
Cost₹400
SO price₹480

Try editing a cost, dragging the margin, or clearing a field.

Illustrative prototype with sample numbers.
Edit a price, or add a group
Defaults from Style Curation
NameDescriptionWidth (Inch)AvgPrice /
1. Bill of materialsTotal : ₹112
1.1 FabricFabric Total : ₹100
1.2 TrimTrims Total : ₹12
2. CMTTotal : ₹99
3. ProcessTotal : ₹100
4. AdditionalTotal : ₹52
“What's actually in this cost sheet?”

Costing table

  • Numbered, nested sections, so a cost item can be found
  • Spreadsheet-style inline edit, sectional totals always on screen
  • “+ Add new group” for needs the default structure doesn't cover
Change a margin or the SO rate
TypePrice (INR)

Fabric100.00

Trim12.00

CMT99.00

Process100.00

Additional52.00

(A) : Sub-Total (Base Costs)363.00

Factory Margin Rs

(B) : Sub-Total (Operational Costs)418.00

Target Margin% 104.50

Total Price : (A) + (B) + (Target Margin)522.50

SO Rate

New Margin29%122.00

“Is this deal still profitable?”

Costing summary

  • Base and Operational subtotals, the way the factory actually costs a style
  • Live price and margin as values change
  • MOQ, brand, and supplier on hand for the procurement handoff
Clear the details, then fetch the defaults
SO-1234/Cost sheet 1 01/04/24, 12:04 AMCreated by: Sam
WWDR0001_05 Western - Dresses Avail: 1000 SO Qty: 100
Defaults from Style Curation
NameDescriptionWidth (Inch)AvgPrice /
1. Bill of materialsTotal : ₹112
1.1 FabricFabric Total : ₹100
1.2 TrimTrims Total : ₹12
2. CMTTotal : ₹99
3. ProcessTotal : ₹100
4. AdditionalTotal : ₹52
“Where does the pricing data come from?”

Cost sheet inside the Sales Order

  • Default sheet fetches from Style Curation
  • Costs, margins, groups, and SKU detail edited on the order itself
Image placeholderOptimal price entry inside the Purchase Order module
“How does procurement adjust from there?”

Optimal price inside the Purchase Order

  • Default optimal prices fetch for the relevant SKUs; procurement can change them
  • A focused decision, not a copy of the sales view
05 The Detailed Impact

The same number, once.

  1. 01
    No blank sheets: Style Curation feeds SO and PO on create.
  2. 02
    Same starting cost: sales and procurement each edit only the part that's theirs.
  3. 03
    Less re-entry: the catalog number only has to be right once.
  4. 04
    Harder to ship bad math: validation blocks incomplete sheets.
Add metricreduction in manual cost-sheet updates
Add metricreduction in pricing and margin calculation errors

Those four are the qualitative outcomes I can point to. I don't have hard percentages behind them yet, so I'm not inventing any.

06 Limitations & What's Next

What this project didn't solve.

Add anything that didn't fully get solved, e.g. hard numbers behind the qualitative impact claims, how conflicting manual overrides between SO and PO got resolved, timeline from kickoff to rollout.