Apparel Business Process Modif

Apparel Retail Solution Enhancing Productivity of your Retail Operations

Polaris Retail – A Snapshot 

Developer of Retail Excel



Group Company of Polaris Software Lab Ltd

Polaris Retail Infotech Limited A Global company with extensive experience and proven credentials One-stop Shop Global Presence 

End-to-end Retail Solutions



Expertise across Retail verticals & categories



Focused on long term Customer Relationship

World Class Capabilities 

Part of World’s first SEI CMMi level 5 company



Group certification of ISO 9001:2000



Partner network in MEA and SEA, expanding globally



2 offshore development centers in India



3 near shore development centers in MEA and SEA

Product Strength 

Retail excel: A complete solution for midsized retail chains.



Leaders in deploying Integrated solution for Tier 1 & Tier 2 retail chains

Talent Pool 

Team of 100+ professionals



1,000+ Person Years of Domain Experience

Proven Track Record 

9 years in Retail domain



1000+ installations in India, SEA & MEA



Projects for Retail chains – world-wide

Retailers Need Significant Sales Uplifts

Increased Stock Accuracy

Customer Satisfaction

Reduced Markdowns

Reduced Critical Inaccuracy

Business Concerns – Apparel Retailer •

Merchandise Management – – – –

•

Classification of Item Style Definition Bar-coding Product Code Definition

Reports – – – –

Sales Reports Inventory Reports Salesman Profitability Stock Status of all Stores

•

Transactions – – – – –

PO Style wise POS Billing with the style Promotion based on Style Stock Requisition by Style Stock Adjustments by Style

• • • •

By Brand By Style By Size By Color

 Retail Excel - The Right Choice

Retail Excel Merchandise

Retail Excel Warranty

Multiple set ups for different merchandise types

Retail Excel Inventory

Retail Excel Sales

Inventory visibility across locations

Sales Order Processing

Retail Excel Replenishment

Retail Excel POS

Requisition and Allocation processes

Powerful POS Solution

Retail Excel Procurement PO; Multiple Delivery & Returns

Retail Excel Re-packing

Retail Excel Club & Campaign

Retail Excel Accounting

Customer Loyalty programs & promotions

Comprehensive accounting

Re-packing and cov of uom

Retail Excel-Analytics Pre-defined reports and Customizable Report Designer

Six Dimensional Solution

Retail Excel Features Retail Excel Warranty

Retail Excel Merchandise Multiple set ups for different merchandise types

Retail Excel Inventory

Retail Excel Sales

Inventory visibility across locations

Sales Order Processing

Retail Excel Replenishment

Retail Excel POS

Requisition and Allocation processes

Powerful POS Solution

Retail Excel Procurement PO; Multiple Delivery & Returns

Retail Excel Re-packing

Retail Excel Club & Campaign

Retail Excel Accounting

Re-packing and cov of uom

Comprehensive accounting

Customer Loyalty programs & promotions

Retail Excel-Analytics Pre-defined reports and Customizable Report Designer

Demo on Apparel and Footwear         

Merchandising Procurement Replenishment Inventory Management Sales Order Processing Point of Sales Accounting Club and Campaign Centralized Operation

• • • • • • • • •

Click Click Click Click Click Click Click Click Click

here to View here to View here to View here to View here to View here to View here to View here to View here to View

Merchandising  Division Excel • Multiple Attribute Definition • Defining Row and Column level Variant Matrix (Size and Color)  Assigning Multiple codes to a Single Item • Item Code • Old Item Code • Barcode (Multiple) • Style wise Barcode  Item Code Logic • Define Item Code Length • Manual / Automated Item code Generation • Assign Attributes codes to the Item Codes • Assign Attributes codes to the Style Codes • Define Attribute Code Length

Click on New Enter Division Select Division

Enter Attribute Caption Details and Select Row / Column for Variant

No.Of Attributes

Select Variant Matrix

Click on New

1

2

3

4 8

Select Item Logic

1.

Select Division

2.

Enter Length of Item Code

3.

Tick Item Code Generation Auto / Manual

1.

Select for Style Creation

1.

Select for Variant Matrix

6.

Select to generate attribute code automatically

1.

Enter the Attribute code length

8.

Tick if the Item Code should containattribute code also

5 6

7

Procurement  Purchase Order • Raise Consignment or Local Purchase Order • Enter Qty based on Variant Matrix  Material Receipt • With or Without Reference of PO • Manual or Auto Generation • Accept or Reject with Reason on Received Qty’s • Enter Sales price while raising the GRN  Purchase Invoice • With or Without reference of MR • Summary of PO / GRN / Invoice Qty

 Purchase Returns • All reports based on Variant Matrix

Click New

Select PO

Click Variant Matrix to Select Style wise Items

Select PO Category

Select Vendor

Select Delivery Shipment

Select Location

Select Division

Select Style

Enter Qty Size / Colour Wise

Click New

Select PO

Click Variant Matrix to Select Style wise Items

Select PO Category

Select Delivery Shipment

Select Location

Select Vendor

Select Delivery Type/Level/Org/Date

Enter Quantity to be order

Press F10 to Save Transaction

Click New Select PO Delivery Schedule

Select PO Number

Select Level

Select ORG

Enter Schedule Qty for Delivery to this store. Select Item

Click on New

Select Manaul / Auto Pick list

Select Vendor Details

Select PO Number

Select Reference with or without PO

Select Material Receipt

If PO Qty is 123.00 and Received Qty 100 and Accepted Qty 75 then balance qty should be entered as Rejected and Reason for Rejection to be selected.

Enter Accepted Qty

Click on New Select PO / GRN Details

Invoicing with or without Ref

Select / Enter Vendor Details Click Populate Item Details3

Select Purchase Invoice

Press F10 to Save Transaction

Replenishment Management •

Item wise Re –order Level – All/Particular/Group of Store – Fix up Safety / Maximum / Minimum stock level

•

Stock Requisition – Auto Requisition based on Min Re-order Level – Selective Items Stock Requisition

•

Stock Allocation – View Stock Level of all branches while allocation

•

Stock Transfers – Direct Transfers – Transfer based on Allocation

Click New

Select Level Requested

Select Org Requested

Select Requisition

Click on populate

Select Requisition no

Select Warehouse from which you want to transfer

Here Item wise requisition detail will be displayed and enter the transfer quantity to organisation wise allocation detail for item

Inventory Management • Physical Stock Take – By Manual – By PDA Device

• Allocating Initial Stocks • Stock Adjustment

Click on New

Select Stock Adjustments

Select Adjustment type if manual enter item

If By Stock Take cycle import TXT file

Select item from the item search and enter the adjusted Qty

Sales Order Processing •

Consignment Sales

•

Contract Sales

•

Standard Sales

•

Franchise Sales

•

Multiple Location

•

Multiple Scheduling

•

Supply from Different Location

Point of Sale • • • • • • • • • • •

Billing Bill Cancellation Bill Refund Tender Declaration Sales Audit Packing Slip Customer History Counter Management Layaway Sales Gift voucher Sales Multiple Payment Modes

Select type of sales – Itemsales,Gift Voucher Sales, Layaway Sales

Select Customer

Select Salesman

Scan / Enter / Search Item Code

Click on Hold to Hold the current bill

Click to take refund of item

Click to enter payment

Click to enter fright

Click to enter cancel item

Accounting • • • • • •

Cash / Bank –Payment Cash / Bank - Receipt Journal Debit Note Credit Note Financial Sales / Purchase • BRS • AR / AP Adjustment

• • • • • • • • • •

Balance Sheet Profit and Loss Trading Account Trial Balance Cash / Bank Register BRS Register Opening Balance Trial Accounts Payable Accounts Receivable Reminder Letter

Click to enter New Select Voucher Type

Click Accounting Transcations

Enter Transcatgion

Select Ledger Filter

Retail Excel – Campaign (Promotions)

Types of Campaign •

Invoice Level Campaign – Buy one Item get % Discount on Net Bill – Buy One Item get Value Discount on Net Bill – Buy One Item for X Value and get one Item Free

•

Item Level Campaign – Buy One Item Get % Discount on that Item – Buy One Item Get Value Discount on that – Buy one Item Get One Free – Buy One Item Get Any Item from defined category

•

Seasonal or Time Line Campaign – Create seasonal promotions based on • Date • Time • Specfic Customer

Invoice Level – Campaign

The impact of campaign on Billing

Campaign At Item Level

The impact of campaign on Billing

Retail Excel – Loyalty Program

Retail Excel – Loyalty Module •

Loyalty Card Type Excel •

General/Special offer Reward points formula

•

Loyalty Card Registration

•

Loyalty Card Maintenance • Card Closure • Card Re Instatement • Card Renewal/Re Issuance • Card Upgradation • Transfer Points

Loyalty Card Type Excel

Loyalty Card Registration

Data Transfer • Data Transfer by FTP (File Transfer Protocol) • Scheduling of Data Transfer • Reduce the Cost and time for Delivery of Information • No Need for a Dedicated Manpower

Questions ? • What are you looking for ? • Contact our Retail Specialist • Get into NO PAIN ONLY GAIN

Thank You