Back Office

The product maintenance module is the entry point to all database modifications. LOC Store Management Suite includes a full featured product maintenance program based on the SIL (Standard Interchange Language) data dictionary. The SIL data dictionary is a voluntary standard that has been widely accepted among wholesalers and retailers that have a need for data exchange between systems.

It was designed to allow multiple record entries in database tables, that differ per region. Pricing management and point of sale taxability of products are good examples of why LOC Store Management Suite offers true top-down store control for multi-store corporations.

Balancing

LOC Store Management Suite has included different types of Balancing to adapt to retailer's needs making it our priority to offer retailers the tools needed.

Specifications

POS features

Operator, lane or till balancing
Multiple and simultaneous login on the same register
Loan and withdrawal directly on the register
Training mode with GT tracking
Support entry on any date, with limits
Multiple reports available at the POS

Cashier Balancing

Programmable week start (Sunday, Monday, etc)
Balancing periods: daily, weekly, opened
Real time list of active cashier with drawers
Pickup, loan and declare from a media list
Calculator to count money by coin, roll or paper
List of cashier by short/over order
Pickup check from a list of accepted checks
Pickup slip number management

Safe Balancing

Display real time safe balancing
Deposit and receive to/from bank
Display opened safe values
Brinks sheet printing
Bank conciliation report by date
Management of 2 or more safes

Reports

Store Balancing Sheet
Store Balance Sheet 7 days
Cashier Balance Sheet
Cashier Transaction Details
Cashier List
Safe Totals
Safe Transaction Details

Product Maintenance

The LOC Store Management Suite Maintenance Module has been designed to allow multiple entries in database tables for records that may differ from one region to another. Pricing management and point-of-sale taxability of products are good examples proving that the LOC Store Management Suite software does offer true top-down store control for multi-store corporations.

Items can be searched by a simple query based on single or multiple index(es), including description, UPC, vendor, size, category, family and many more.

Simplified Maintenance

Design your screen with only the field you want to maintain
Multiple search: UPC, Description, Category
Control up to 3 prices types by date (Regular, Promotion and TPR)
Active price always shows
Next price event automatically generated
Package and limited price
Pop up screen for easy selection

Advanced Maintenance

Advance searching method
Unlimited alternate code for selling, receiving and inventory management
User define screen layout
Price calculator with margin
Global change utility
Kit to attach item together for selling
Scale information; Tare, price and ingredient
Advance batching
Sale report directly in maintenance screen
Label selection directly in maintenance screen
Every database modifications keep in the Electronic Journal
Powerful search functions
Unlimited preference screen can be saved by user
Manufacture code and Alias code
Width, Height and Depth for graphic representation
Cubic and Weight fields for shipping cost calculation
Group items by department, sub-department, category, family, report, code, group and section for report and searching purposes

POS Information

Up to 4 different taxes with the follow sub-department flag to follow sub-department taxability
Scalable flag with divisor, tare, variable weight tare and manual weight
Restrictors to block sale on a particular time/day
Client age and operator age restriction
Promo id number to link multiple items in a same promotion
Link to bottle table
Coupon family code for perfect item matching
Food stamp and WIC flags
Management of different link values per price level

Price Management

Unlimited price levels for frequent shoppers, employee purchases, corporate sales, etc
4 different price types (regular, promotion, temporary price reduction (TPR) and in-store)
Programmable priority of in-store prices over other prices
Start/end date and time for price activation
Package price and limited quantity price
Automatic dollar or percent discount
Mix and match price grouping
Specific shopper points per item
Next price event on screen
Item links to register 2 items together
Target profit margin
Suggested retail price management
Points redemption for discount or item for free
Volume pricing

Reports

Item multi totals
Item single total
No grouping of items
Active price list
Next price list
Past price list
Sale price list
Multi totals
Single totals
Item single total
Item single
Markdown by vendor
Item by UPC

Cost Table

The Cost Table is the power behind the Receiving and Inventory Modules.

Specifications

Unlimited number of vendors for one product
Unit cost and next cost calculation
Back order flag
Sequence number for vendor invoice order
Fees in $ or %
Split case cost management
Split code for items sold by case and unit
Weightable item management
Cases and layers
Allowance in $ or %, on/off invoice
Discount in $ or %, on/off invoice
Rebate in $ or % on/off invoice
4 different bill back, in $ or %
Discount in $ and % on quantity
Delivery information
Calculation method for the inventory value

Other Item Table

Unlimited alternate codes per item
Kits programming to link an item with one or many others for inventory control
Shelf management with location, position, section, aisle
Visual shelf management with product pictures
Multiple locations for one item
Scale information with ingredients and product life
Re-order information with minimum or maximum quantity

Auxiliary table

The Maintenance module allows LOC Store Management Suite users to manage tables related to all products. With this flexible screen layout, tables can be managed by departments, sub-departments, categories, mix & match, and tare.

Department and Sub Department

Min/Max entry
Max void and refund
Customer and/or cashier age control
Taxability and other flags
Discount

Bottle Link

Configurable amount per case
Could be used for environmental fees
Taxability, food stamps or WIC control

Vendor

Grouping by category
Back order life
Delivery days setup
Terms: days and discount
Minimum order/cubic
Broker and weight/cubic shipping rate

Programmable Restriction

Configurable restrictions on different time/days
Possibility to change the restrictions into permissions

Category, Family and Report Code

Different ways of grouping items that are part of the same sub-department/department

Customer Maintenance

The LOC Store Management Suite's Customer database has been designed to provide retailers with all the flexibility options needed to serve clients efficiently. A customer database may be used for multiple management purposes such as Accounts Receivables, Check Validation and Loyalty Program.

Customer Table

Contact and company name
Comments to send to cashier's screen on customer's next visit
2 different grouping fields
4 tax exemption numbers
Customer language
Attach customer to certain employees (salespersons)
Credit card information
Membership control (creation, solicitation and renewal date)
Easy customer deletion/re-numbering/merge
Option to store customer's photos

Risk level table

Unlimited risk levels
Credit limit
Positive and negative check file
Check change limit
Invoice template by customer
Terms of payment
Interest rates
Weekly check acceptance
Weekly private card acceptance

Shopper level table

Unlimited shopper levels
Customer discounts
Points management
3 different price levels
Double couponing (or any factor)
Best price method
Cost plus pricing
Choice of discounts allowed (item $, item %, e-coupons, packaging price, limited price, sub-department discount)
Upgrade to another shopper level according to some conditions (transaction total over points, balance over, specific days, etc.)

Reports

Customer Multi Totals
Customer Group Multi Totals
Customer Transaction Details:
Customer sale statistic
Statement by customer
Age of accounts by month
Customer list
Points balance history

Batch Maintenance

LOC Store Management Suite provides a Batch Entry system for users who need to create products or modify price/costs on existing items without working directly in the database. The batch system can contain an unlimited number of batches on file for both analysis and implementation purposes. And the batches may be used to make price changes in advance for an ulterior date.

Features

Unlimited future batch events
Price events maintained by batch (regular, sale, temporary price reduction (TPR) and instore)
Cost events maintained by batch (cost, allowance, rebate, discount and bill backs)
Electronic coupons maintained by batch
Mass price changes using batches
Price generation from margin using batches
Date and time activation control
Automatic batch activation
Batch archives (for movement analysis)
Recursive batches

Reports

Item sale based on future price batch
Item sale based on external batch
Item sale based on archived batch
Markdown report from a batch

Labeling

A fully integrated label designer is provided with the LOC Store Management Suite package. We have designed our own label printing engine so it fits better with out pricing method and the retail industry requirements.

Specifications

Printing labels and promotional signs
Instant label printing from maintenance screen
Printing labels from internal or external batch
Printing labels by shelf location
Printing labels on all item changes for a specific date
Selection of labels by category or sub-department
Queuing of labels by format for bulk printing
Unlimited label formats
Landscape or portrait orientation
Description formatting to best fit on labels (centering, word wrapping, etc.)
Price displayed with dollars and cents
Package and limited price supported
Split pricing and taxability showing on label
15 types of bar code supported (UPC, EAN, CODE39, 2of5, MSI, etc)
Full featured label designer for label creation
Standard printers with a window driver supported
Thermal label printers with a window driver supported
Multiple printers and trays (for different stocks) supported
Use printer native font for fast printing
Kilogram and pound supported for scalable products
Image printing on labels

Accounts Receivables

LOC Store Management Suite allows users to create transaction records for database updates cash variation transactions, account payment entries and miscellaneous data entries that are more logically performed on office PCs.

Specifications

Complete invoicing module
Account adjustment transaction
Account statements on screen
Full or partial payment of invoices
Verification of addresses at the cash register
Debit notes
Open payment
Open payment (can be matched later)
Entry of a payment amount and selection of matching invoice
Suspension and retrieval of a transaction at anytime
Identification by check reference number
Automatic conciliation of paid invoices
HTML designer for screen configuration with custom information
In-house credit terms with interest calculation
Gross profit report by customer
Sales analysis by salesperson
Commission report by salesperson
Optional minimum payment based on invoice amount
Customer mailing labels
Repetitive invoicing on different periods

Reports

Sort statements by customer name, group or zip code
Account Totals
Account Balances
Statements by dates
Statements by invoice
Statements by groups
Account aging
Calculated balance
Payment journals

Labor

LOC Store Management Suite's Labor module is the management tool that enables managers to schedule personnel quickly and efficiently. Fully-integrated to the POS system, this tool simplifies the time entry process and provides access to staff information anytime. Various printout formats are available to fit specific needs. This module also facilitates schedules to be printed by department or employee, in a weekly or monthly calendar style.

Labor Management

Punch IN / Punch OUT at Point of Sales
Integrated employee table for all department
Employee grouping for hourly rates
Support regular hourly rate and overtime rate
Add or manually adjust employee's punch
Compare by department total hour, total wage and cost of labor.
Original Punch always available
Worked hours in a calendar view
Control lunch hours
Unlimited shift hours
Report by shift hours

Employee Management

Record worked hours directly at POS
Integrated table of employees for each department
Original punch clock always available
Hours worked in calendar format
Break time control
Obtain work shift reports

Schedule Management

Creation of schedule
Repetitive schedule from week to week
Schedule of transferable hours to worked hours for accounting purposes
Printable schedule by employees, department or store
Print schedule by employee, department or store
Control lunch hours
Scheduled in a calendar view

Analysis

With LOC Store Management Suite, the information flows transparently from the cash register into the report system where it becomes part of the decision making process. Reports can be generated for any period using recognized retail formats including departments, categories, items, customers, cashiers, hours, etc. Comparative reports show movement trend over any length of date ranges using the intervals that mean the most to the user.

Drill Down Report Cube

A "Drill-down Report" is a summary of information that contains links to let you browse through detailed data. Our Drill-down report provides the ability to simply click on a data item in a HTML report and drill-down to the source data. By clicking on a value, LOC Store Management Suite will launch a new detailed report based on the previous value.

Specifications

Forecast / budget
Ability to keep track of forecast sale
Budget reporting
Multiple period reports
Drill down by department
Drill-down by sub-department
Cashier statistics
Refunds processed over the week, may be viewed by clicking on the amount.

Sales Reports

LOC Store Management Suite collects a staggering amount of data on a per transaction basis. A UPC is recorded every time it is transacted on the cash register; every time payment is processed at the POS, it is recorded; and every cashier entry is recorded.

Reports can be generated for any period using recognized retail formats including:

departments
categories
items
customer
hours

Scale Interface

While distributing accurate price information in real time between cash registers, POS systems, and department scales; the scale interface prevents pricing errors and ensures centralized data management throughout the entire store. LOC Store Management Suite provides higher levels of scalability, reliability and price accuracy in retail stores.

Using drivers developed by Invatron, the interface can be connected to all major brands of scales.

Specifications

Scale Status Verification
Initial load with warning that the scale will be zeroing
Item, Price and Ingredient load
Item, Price and Ingredient load by Sub Department
Item and Ingredient reading for verification
Productivity reading with zeroing
Interface to all major scale manufacturer
Interface to TEC scale directly

Receiving and Purchase Order

The LOC Store Management Suite's Receiving module allows users to manage receiving and cost of goods. Goods receiving can be done through an RF controller or directly from a computer. Multiple reports are also available as decisions making tools.

Specifications

Complete control of Purchase Orders, Receiving and Billing
Direct store delivery
Item report for open Purchase Order
Expected delivery
Vendors access controlled by users
Shipping via vendor if different from supplier
Weight and cubic freight rates
Minimum order and/or minimum cubic
Information on brokers
Global discount/item discount
Back order life
Multiple searching options for items
Real time analysis of sales, receiving, adjustment and inventory while ordering
Average of last 4 to 10 weeks sales on screen
Purchasing history
Best deal availability on screen
Order based on sales history
Order by case, unit or weight
Order based on purchase
Order based on forecast
Ordering based on sale factored with trends
Order based on inventory (minimum/maximum quantities)
Order based on receiving slip
Allowance, discount and rebate off/on invoice (% or $)
4 different bill backs
Generation of retail or sales prices based on discount
Comment by item available
Ability to keep track by user of ordering, receiving and billing for every document
Quick list of open documents
Auto generation of Purchase Orders from Sales Orders
Receiving from the list of Purchase Orders
Receiving from the list of backorder items
Ability to maintain item from Receiving screen
Create or maintain item from buying screen
See all item information while buying
Combined all item search criteria in one screen
Quick item lookup using all keys available
Screen preference and positions are saved by user profile
Pick and fields you wish to display in the grids
The grid position is saved and restored automatically
Production of a daily Back Order Fill Report
Export capability to a payable software
HTML editor to edit receiving/inventory information on screen
Search through current documents
Drill down in old documents
Document transfer between stores or between Host and stores
Document export available in different formats including XML

Reports

Final receiving confirmation
All back orders
Receiving checks for a date
One receiving check
All items on order
Purchase order for a date
Purchase order
Shorted on order

Direct Store Delivery (DSD)

LOC Store Management Suite offers a complete direct store delivery (DSD), price management and inventory control solution. This complete solution allows retailers to manage their business operations in a cost effective and efficient manner.

Specifications

Its capabilities help improve profitability through:

Improved price accuracy
Consistent price image
Higher margins
Greater vendor and merchandise delivery control
Reduced labor needed to manage store-level inventory and pricing
Screen preferences and positions are saved by user profile
Pick any field you wish to display in the grids
The grid position is saved and restored automatically
See all item information while buying
Create or maintain item from buying screen
Ordering based on forecast
Quick item lookup using all keys available
Search through current documents
Drill down in old documents

Inventory Count

LOC Store Management Suite is a fully integrated system that tracks items from the back door to the front door. Profits begin with a reliable inventory control system.

Specifications

Inventory count and/or adjustment
Variance on cost and retail calculation
Reason code for adjustment
Transfer of items between stores
Multiple searching capability
Suspension and retrieval of inventory count or adjustment
Sales kit management for inventory with listing
Inventory Turnover report
Inventory Backorder fill report
Tracking both average and last cost
Detailed view of the inventory movement for an item
Different retail price for each unit size (ex: 6-pack, 12-pack, 24-pack)
Screen preferences and positions are saved by user profile
Pick any fields you wish to display in the grids
The grid position is saved and restored automatically
See all item information while buying

More Features

HTML editor to edit receiving / inventory information on screen
Document transfer between stores or between Head Office and stores
Document export available in different formats including XML

LOC Software Buy

LOC Software Money Management