Sign in

Use your assigned username and password to access Glowbal Inventory Intelligence.

Branded login background enabled with Sri Lanka mark.

Summary Dashboard

DPL, OGF and DC operational inventory

● Shared server v2.5.4 · Location-Specific Physical Reconciliation
Dashboard data is not loadedPress Generate Data to load this page only when you need it.
Import validation errors are available for export.

Dashboard is on demand

Nothing is calculated or displayed until you press Generate Data. This keeps login and page navigation fast on the shared server.

TOTAL LOCATION
Fast View Mode
Screens render a maximum of 100 rows. Full data remains stored and can be exported to Excel.

Stock by Location

Current on-hand after operational Daily Sales.

Attention Required

Operational exceptions that need action.

Inventory Stock is on demand

Nothing is calculated or displayed until you press Generate Data. This keeps login and page navigation fast on the shared server.

Inventory Stock: search, filter, review stock, and use serial-level adjustments only when your permissions allow it.
Inventory Stock · Easy View
Keep Serial View OFF for a clean consolidated stock view. Turn it ON only when you need to find, move, or remove a specific physical serial.

Inventory Stock

Consolidated live stock by DPL, OGF and DC. Serial numbers are hidden.

Filtered On Hand Qty0Reflects current Inventory Stock filters
Filtered Selling Value LKRLKR 0.00On Hand × Selling Price LKR
Matching Stock Lines0Before the 100-row screen limit
Active FilterAll InventoryLocation / division / brand / category / size

Serial Stock Adjustment

For multiple items, select serials directly from the Inventory Stock table above, then move them together or remove them from available stock.

Adjustment History

Latest manual Inventory Stock movements and removals.

Currency Mapping

Field names remain exactly as uploaded.

Sales is on demand

Nothing is calculated or displayed until you press Generate Data. This keeps login and page navigation fast on the shared server.

Daily Sales: choose the file, import it, review the sales list, and export when needed. Technical validation and system-adjustment details are available to Admin only.
Historical Ledger Mode
Sales = −1 from Store per row. Customer Returns = +1 to Store per row. Repeated serials are valid. Negative stock is intentional during backfill and should balance after return history is loaded.
Fast View · 100 Rows
Only the latest 100 Sales and latest 100 Customer Returns are rendered. Full history remains available in Excel export.

Daily Sales Import

Operational sales import. Store is read automatically from the Store header.

Serial, Store and Sales Date are required. Sales Date is the actual sold date. Glowbal reads DD-MM-YYYYYY as day-month-year. The 37-column Daily Sales format is supported, including Net Selling Price and Customer Name. Historical ledger mode: repeated serials are allowed and every Sales row deducts 1 from Store even if the balance becomes negative.
Duplicate Serial Exception
Historical Sales and Customer Returns always allow repeated serial events. This exception now applies only to other duplicate-sensitive operations.
Import Error Handling
BLOCK FILE = any invalid row stops the import. SKIP INVALID = import valid rows and keep rejected rows available for Excel error export.

Serial Stock Lifecycle

Sale deducts 1 unit → Customer Return adds 1 unit → the same serial becomes available again → a later Sale deducts it again. This valid cycle does not require Duplicate Serial Exception.

Sales Auto Adjustments

Daily Sales stock mismatches are corrected automatically so they do not stop the sales import. These corrections are recorded separately from Customer Returns and normal Transfers.

Wrong location: the serial is moved to the Sales Store before the sale. Already unavailable: a temporary stock-in correction is created at the Sales Store before the new sale. Not in inventory: a temporary stock-in correction is created from the sales row, then the sale is posted.
Adjustment IDSerialSales StoreAdjustment Type FromToItem DescriptionSales Date Import DateSource FileReason

Currency Mapping

Field names remain exactly as uploaded.

Sales

Daily Sales reporting view. Use Sales Date in Advanced Filter & Pivot to filter by the actual sold date.

Sale IDSerialStoreItem DescriptionQty Net Selling Price LKRNet Selling Price USD Calculated Sales Value LKRCalculated Sales Value USD Customer NameImport DateSourceSales Date

Customer Returns History

Returned serials are added back into stock using the uploaded Store as the operational return location. Inventory Location is retained only as source/reference data.

Return IDSerialReturn TypeStoreSource Inventory LocationItem DescriptionQtyImport DateSourceReturn Date

Return Auto Adjustments

Customer Return stock/lifecycle mismatches are corrected automatically and recorded separately so they do not stop the return import.

Wrong location: the return is accepted and the serial is corrected to the uploaded Store. If it was already available in the old location, that old stock is removed first to avoid double-counting. Inventory Location remains reference data only.
Adjustment IDSerialStoreAdjustment Type FromToItem DescriptionReturn Date Import DateSource FileReason

Daily Exchange Rate

Maintain the daily conversion rate used by Sales. Enter LKR for 1 USD. Example: 310 means USD = Net LKR ÷ 310.

0 rates
Sales with a master-driven price require an exact rate for the Sales Date.
DateLKR per 1 USDUpdatedUserAction
No exchange rates entered.

Item Ledger is on demand

Nothing is calculated or displayed until you press Generate Data. This keeps login and page navigation fast on the shared server.

Item Ledger: search a serial, barcode, style or item to see its complete movement history and running stock balances.

Item Ledger

Initial Inventory, Sales, Customer Returns, Transfers and stock-affecting adjustments in one movement history.

DateMovementSerialOriginal BarcodeStyle #Item DescriptionFromToOld LocationPhysical LocationOld StockPhysical StockAdjustmentFinal LocationUserBatchQty OutQty InDC BalanceDPL BalanceOGF BalanceUNLOCATED BalanceSource FileReference

Inventory Aging is on demand

Press Generate Data to calculate current-stock aging from Posting Date and Transfer Date.

Inventory Aging

Current live stock only. Sold-out Serials and Gift Voucher Serials are excluded automatically.

Current-stock age by location. Initial stock uses Posting Date; a later transfer into the current location resets age to that Transfer Date.

Current Stock Aging Detail

Age is measured to today from the current-location arrival date.

LocationAge DaysAge BucketAge Start DateDate Basis SerialOriginal BarcodeStyle #Item Description BrandDivisionCategorySub CategoryGenderSizeLine QtyDiscount %Selling Price LKRSelling Value LKR
Generate Aging data to view current stock age.

Checking Area WIP is on demand

Press Generate Data to load categories, current WIP items, movement history and the WMS outbound queue.

Barcode / Serial Scan

Scan once to move an item into Checking. Scan it again in Auto mode to mark it Fixed and queue it for Warehouse/WMS transfer.

Ready for scan.

Checking Categories

Add categories without changing code. Categories remain available for future WIP assignments.

WIP Category Summary

Total current WIP grouped by Category only, regardless of status.

WIP Category Division Category Subcategory Gender Qty Value LKR Value USD
No WIP category summary available.

WIP Summary by Current Status & Category

Current WIP quantity and selling value grouped by Category and Status.

WIP Category Status Division Category Subcategory Gender Qty Value LKR Value USD
No WIP summary available.

Import WIP

Import items using Serial and Category. Category READY closes WIP, releases the item to normal DC inventory, and excludes it from WIP reports.

Required columns: Serial and Category. READY = WIP complete / normal DC stock.

Checking Area WIP Report

Active WIP items with category, status, movement time and responsible user. READY items are closed and excluded.

SerialOriginal BarcodeStyle #Item DescriptionBrandSize Inventory SourceInventory LocationSub AreaCategoryStatusChecked InLast MovementAssigned UserWMS StatusAction
Generate WIP data to begin.

WIP Movement Audit

Every Checking / Fixed movement is logged with date, time and user.

TimestampActionSerialBarcodeStyle #FromToCategoryUserDetails
No WIP movements.

Replenishment is on demand

Nothing is calculated or displayed until you press Generate Data. This keeps login and page navigation fast on the shared server.

Replenishment: choose the store, filter the items you need, review quantities, and export or apply the plan.
Smart Replenishment
Start by choosing DPL or OGF. The system focuses on items available in DC, then lets you narrow the result by category, brand, size or search.

Replenishment Workspace

Recommended workflow: Store → Need / DC Available → Category filters → Review quantity → Export or move selected DC serials.

Recommended Need shows only items where the selected store needs stock and DC has units available. All Available in DC is ideal for category or sub-category replenishment: it shows every matching item with DC stock, even if the formula currently suggests zero. You can manually enter the quantity you want to move. Item / Barcode View consolidates stock by item. Serial View shows DC serial balances individually so you can choose exact serials. WIP exclusion: items currently in Checking or Fixed WIP are removed from DC Available and cannot be selected for replenishment.
Select Serial Original Barcode Style # Item Description Division Category Sub Category Brand Gender Size Line Store Stock DC Available Net Sales / Lookback Suggested Replenish Qty Status

Replenishment Performance Report

Replenishment uses Net Units Sold = Gross Sales − Customer Returns. Returned units do not continue to count as demand.

Side-by-side DC, DPL and OGF report by Style / UPC. It uses the current replenishment lookback and the filters selected in the Replenishment Workspace above.

Sell-Through % = Units Sold ÷ (Units Sold + Remaining Stock). Urgent Replenishment = 75%+, Monitor = 50%–74%, below 50% = No Replenishment Needed.
Not generated yet.
Goods @ DC
Style No. or UPC		 Brand Category Sub Category Gender Size Line DC Available
Quantity		 DPL OGF Image / Link
Net Units Sold Remaining Stock Transferred Qty
Initial + Transfers		 Sell-Through % Replenishment Action Net Units Sold Remaining Stock Transferred Qty
Initial + Transfers		 Sell-Through % Replenishment Action
Click Generate Report to build the replenishment performance report.
↔ Scroll horizontally to see all DPL, OGF and Image columns. Scroll down to automatically load more rows.
First 100 rows load initially. Scroll down to load more.

Analysis Pivot

Use the Business Central-style Analysis area below for filtering, grouping and pivot analysis. Operational replenishment is handled in the workspace above.

Excel Import Center is on demand

Nothing is calculated or displayed until you press Generate Data. This keeps login and page navigation fast on the shared server.

Exact Excel / CSV Layout

The app now matches your uploaded 33-column layout exactly. Operational location for normal inventory/sales comes from Store. For Customer Returns, the return destination comes from Store. Currency fields are Original Retail LKR, Selling Price LKR, Selling Price USD, and Original Retail USD.

STORE ONLY
Duplicate Serial Exception
OFF = true duplicate imports are blocked, but a serial returned to stock can be sold again normally. ON = duplicate serial safeguards are bypassed for approved exceptions. Required Store and operational validations still apply where possible.
Import Error Handling
BLOCK FILE = any invalid row stops the whole import. SKIP INVALID = import valid rows and retain rejected rows for Excel error export.
View exact 33-column header layout
1. Serial2. Original Barcode3. Original Retail LKR4. Selling Price LKR5. Line6. Location7. Fabric8. Season9. Division10. Category11. Sub Category12. Return Type13. Style #14. Color15. Size16. Country of Origin17. Item Description18. Cusdec Number19. Unique ID20. Gender21. Type22. Brand23. Selling Price USD24. Original Qty25. Original Cost26. Original Retail USD27. Gender Consilidated28. Store29. Discount30. Inventory Location31. Supplier Abbreviation32. Vendor Abbreviation33. Posting Date
View exact 34-column Customer Return layout
1. Serial2. Original Barcode3. Original Retail LKR4. Selling Price LKR5. Line6. Location7. Fabric8. Season9. Division10. Category11. Sub Category12. Return Type13. Style #14. Color15. Size16. Country of Origin17. Item Description18. Cusdec Number19. Unique ID20. Gender21. Type22. Brand23. Selling Price USD24. Original Qty25. Original Cost26. Original Retail USD27. Gender Consilidated28. Store29. Discount30. Inventory Location31. Supplier Abbreviation32. Vendor Abbreviation33. Posting Date34. Return Date

Import Error Report

When an import has rejected rows, export the complete issue list to Excel. In SKIP INVALID mode, valid rows can still be imported.

No import errors recorded in this session.

Initial Stock Upload

Additive inventory mode: every upload adds NEW unique Serials to existing stock. Store is read from the Store header. Existing stock is never replaced.

Daily Sales Import

Preferred simple format: Serial | Store | Sales Date | Net Sales LKR. Header matching is case/spacing tolerant. Gross Selling Price LKR comes from Item Master. Net Sales LKR is provided by the Sales upload. Glowbal calculates the effective discount and converts Net LKR to USD using the saved daily exchange rate. Legacy 37-column files remain supported.

View exact Daily Sales header layout
1 row = 1 sold serial. Store = sold location. Gross LKR comes from Item Master. Net Sales LKR comes from the uploaded Sales row. Discount % is derived from Gross vs Net; Net USD = Net LKR ÷ daily LKR/USD rate.

Transfer Import

Preferred simple format: Serial | Store/Destination | Transfer Date. Glowbal pulls all item attributes from Item Master and infers the source from the quantity ledger.

View Transfer header layout
Store = destination. Inventory Location is not used for the movement calculation. Repeated transfers of the same serial are valid and increase that serial's quantity at the destination. Transfers to shops may temporarily make the DC serial balance negative. When Store = DC later, Glowbal deducts from the shop balance and adds the quantity back to DC.

Customer Returns

Preferred simple format: Serial | Store/Location | Return Date. Glowbal pulls all item information from Item Master and adds +1 back to the selected return location. Legacy full return files remain supported.

Returned serials are added back into the Store/Location shown in the workbook (DPL, OGF or DC). For the simple template, all product information comes from Item Master and Return Type defaults to Customer Return.

Style Image Import

Link product pictures to Style #. Once imported, the image is automatically used in the Replenishment Performance Report.

0 style images

Option 1 · Excel / CSV Mapping

Use two columns: Style # and Image URL. The image URL can be a normal web image link or a data-image URL.

Option 2 · Upload Image Files

Name each file using the Style #. Example: AA3179.jpg, P7308407Q88.png. The filename before the extension becomes the Style #.

No style images imported yet.
Style #ImageSourceUpdatedAction
No style images imported.

Item Master Import

Import once and reuse forever. Serial is the unique key. All other columns become reusable item attributes for future scans/imports.

0 master items
Required key: Serial. The downloadable template uses the full 34-column Item Master layout including Item FG.

Physical Inventory Reconciliation

Select one Stock Take Location, upload its physical Serial count, preview the differences, then post adjustments only for that location.

Location-specific stock take
Select the location being physically counted. Glowbal adjusts only that selected location. Serials in other locations are not treated as missing. Each Serial always equals 1 unit. A counted Serial found in another location moves to the selected location. A Serial currently in the selected location but missing from its physical count becomes UNLOCATED. Active WIP remains DC / WIP.
Serial Old Location Physical Location Old Stock Physical Stock Adjustment Final Location Action Item Status
Upload a complete physical count and preview before posting.

Posting Date Adjustment

Bulk-correct initial inventory Posting Date by Serial. This updates aging dates only and does not change stock quantity.

Required Excel columns: Serial, Posting Date (DD-MM-YYYY)
Every matching initial-inventory Serial receives the visible Posting Date exactly as DD-MM-YYYY. Example: 01-05-26 = 01-05-2026. Unmatched serials are listed in an error export.

Import Jobs

Audit history with rollback. Use Remove for one import, or Clear All Data to restart completely.

Use Export Imported to download the rows from any import job.

Reports is on demand

Nothing is calculated or displayed until you press Generate Data. This keeps login and page navigation fast on the shared server.

Reports · Fast View
Reports are generated only when requested. The screen shows the first 100 rows; Excel export includes the full report. Sales Report also includes a separate formatted Sales Summary Layout export.

Report Builder

Select the report, location and optional date range, then generate it. Sales Report uses Sales Date only. WIP Process Report uses WIP Check-In Date and includes the complete Imported / Scanned → Checking → Fixed → WMS / Removed process trail. For every Sales Date + Store, only the latest imported daily snapshot is active; older versions remain in history but are excluded.

No report generated yet.

Report Preview

First 100 rows are shown for speed.

Choose report options and click Generate Report.

Users & Activity is on demand

Nothing is calculated or displayed until you press Generate Data. This keeps login and page navigation fast on the shared server.

Create / Update User

User profile, role, group membership and direct permission overrides.

Permission Groups
Direct Permission Overrides

Use the Permission Designer on the right. Direct permissions are added on top of group permissions.

Users & Permission Groups

Select a user to edit, or build reusable groups below.

Permission Groups

Screen Permission Designer

Select the target and screen, then grant only the functions required.

Select a user or permission group.

User Activity Log

Login, logout, imports, removals, clear-all actions and user changes.