Microsoft Fabric analytics for CGS BlueCherry ERP

Every style, color and size.
One version of the numbers.

Get2Insight moves your data from CGS BlueCherry ERP into Microsoft Fabric and models it the way an apparel business works. Inventory, production, orders, cut and sold, and receivables come together in one Power BI report.

Request a demo See the reports

Built on CGS BlueCherry ERP Microsoft Fabric Power BI

BlueCherry Analytics: Home

Report home page with cards for inventory valuation, open order book and year-to-date shipments, and links to inventory, production, sales, finance and data quality reports

Illustrative sample data

Five report areasInventory, production, sales, finance and data quality

20+ report pagesLinked from one home page with a global division filter

Item-level detailStyle, color, label, dimension and size, with UPC and GTIN

Built-in quality checksMaster data gaps are flagged in the pipeline and the report

Why it matters

Answers that cross every module

BlueCherry ERP from CGS runs your business day to day. The hard questions cut across inventory, production, orders and receivables, and they often end in exports and spreadsheets. We bring it all into one model.

One version of the numbers

Inventory value, available to sell and gross profit are calculated once, in one model, so every team reads from the same figures.

The language of apparel

Reports use the terms your teams know: style, season, division, label, prepack, contractor, order book, cut and sold.

From totals to the order line

Start with a division or season, then drill to a style, sales order, purchase order or container. Paste a list of styles or UPCs to filter at once.

Inside the report

Built for how apparel companies run

A look at some of the pages. All screens show fictional sample data. Select any image to enlarge it.

Inventory & style master

Stock and value at every level

See quantity and extended cost by location, division, season and gender, then go down to the individual item.

Current inventory, or inventory as of any date
Valuation trends over time and by division
Inventory changes over any period
Style, UPC and carton master books

Inventory On Hand

Illustrative sample data

Cut and sold

Know what you can still sell

Available to Sell (ATS) is worked out the same way on every style, from receipts through to open orders.

Quantity on hand (QOH) = stock adjustments + returns + receipts + irregular receipts − invoices − consumption

Available QOH = QOH − pick

ATS = available QOH + WIP − open orders

Summary by division, with detail by style and color
Oversold styles stand out in red

Cut and Sold

Illustrative sample data

Open order fulfillment

See which orders will ship on time

Each open order line is matched to supply: on-hand stock first, then open production by due date. Every item gets a clear status.

Sufficient QtyCovered by stock or WIP due by the cancel date

Late GoodsRelies on WIP due after the cancel date

ShortSupply runs out before demand is covered

Open Order Fulfillment

Illustrative sample data

Production

Follow production from issue to arrival

The Production Book tracks every production order by stage, from issued and booked through to in transit.

Quantities by stage, country, ship-to, season and category
Search by production order, style, shipment or container
Contractor, due date and production value on each line

Production Book

Illustrative sample data

Sales

The whole order book in one place

Filter by order status, date, sales order or customer purchase order, and see quantity, gross sales and gross profit on the same line.

Open, picked, shipped and cancelled orders together
Invoice and order details, sales summary and trends
Gross profit on shipped, open and picked orders

Order Book

Illustrative sample data

Sales Trend

Sales trends by customer

Net invoice amount and units over time, from year down to day, with a breakdown by customer.

Aged Trial Balance

Receivables you can act on

Aged trial balance by customer and document, with the AR ledger behind it for invoices, cash and chargebacks.

How it works

From BlueCherry to Power BI

A Microsoft Fabric pipeline does the work from start to finish, and reports run against Fabric rather than your live ERP database.

Source

CGS BlueCherry ERP

Master data and transactions are read from the BlueCherry SQL Server database.

Move

Fabric pipeline

Copy and script steps load the data, set item keys and apply standard-cost valuation.

Model

Fabric Warehouse

Clean dimension and fact tables, with quality checks that run before each refresh.

Report

Power BI

The semantic model refreshes last, and the report shows when the data was last updated.

What's in the model

Style master
Colors & labels
Sizes & prepacks
UPC & GTIN
Seasons & divisions
Customers & customer styles
Locations
Inventory transactions
Production orders
Contractors
BOM & cost sheets
Containers & shipments
Sales orders
Order allocations
AR ledger
Royalties

Data quality

Catch master data problems early

Reports are only as good as what's behind them. The Data Governance page shows your teams exactly what needs fixing in BlueCherry, so problems are corrected at the source.

Styles with zero cost
Styles with no season, brand, gender or category
Negative inventory
Location mismatches
Inventory items missing from the style master

Why Get2Insight

Decades of expertiseOur team brings 30+ years of collective experience in data and analytics.
Fully certified teamEvery data specialist on our team is Microsoft Certified.
Built around your businessWe shape the model and reports around your divisions, seasons and processes.

See it with your BlueCherry questions

Tell us what's hardest to answer today, and we'll show you how it looks in Microsoft Fabric and Power BI.

Request a demo

Report images show fictional sample data; all company names, brands, styles and figures are invented. BlueCherry is a product of CGS (Computer Generated Solutions). Microsoft Fabric and Power BI are trademarks of Microsoft.