Food and Beverage Management System

Document Sample
Food and Beverage Management System Powered By Docstoc
					CNET_ERP Stock
 management
    system
     Course 2545 and 2520
Course contents

   Setting up Stock management system
   Stock transaction
   Audit and reporting
Setting up CNET_ERP
Stock management
1.   Maintain Global System Library (GSL)
2.   Maintaining Store
3.   Maintaining Recipe
4.   Maintaining beginning balance
5.   Proof reading and checking setting
      1.1
  Maintain Global
System Library (GSL)
Global System Library (GSL)
  Items - Non processed raw material
  Products – Processed value added
     Product
     – Finished Product and None finished Product.

  Customers – Buyers, Guests, Patients…
  Suppliers – Seller, vendors, provider

  Employees – Workers of the
     organization
    Miscellaneous – Various
      Global system library
      illustration
                   Global System Library (GSL)
    Sales Module    Inventory Module Accounting Module     FBM Module

•    Customer       •   Supplier
                                     •Customer
•    Item           •   Item                             •Item
                                     •Supplier
•    Product        •   Product                          •Product
                                     •Employee
•    Employee       •   Employee
GSL Grouping

SN GSL                Group
1   Item              Article
2   Product
3   Customer/Guest/   Customer
4   Supplier
5   Employee
6   Miscellaneous
     Item/Products
   General
   Price list
   Supplier list (Only for item)
   Balance list
   Specification list
   Catalogue list
   Package
   Advanced
   Master record
    – Medicine, Book, Electronic, Garment,
General
   Article Code
    – Auto, Manual, Barcode
   Article Name
    – Brand + Generic + Size
   Family
    – Main Family, immediate family
   Unit of measurement
    – Smallest Processing Unit (SPU)
   Article tax
    – Taxable or not taxable
Price List
   Price modification
    – Adjusting price (will be tracked)
   Multiple price selection
    – Whole sales, retail, consumer
   Price tagging
    – Assign a price for a customer or group of
      customers
   Price and time
    – Assign a price for time
Balance list

   Balance in terms of Quantity
   Balance in terms of Cost
   Balance must be accompanied by cut
    of period.
Suppliers list

   Help to stream line the suppliers
   Maintain multiple supplier for single
    article
   Assign one of the supplier as favorite
Customer/Supplier

   General
    – Name and TIN (No Abbreviation)
   Address
    – Local Address
    – International Address
   Advanced
    – Picture
    – Translator
Employee

   General
   Address
    – Local Address
    – International Address
   Advanced
    – Picture
    – Translator
Miscellaneous
   Bank                Department
   Tax                 Cart
   Message*            Period
   Lookup              Commission
   Table*              Font
   Item category*      Fixed Asset Class
   Store*              Cost factor*
   Exchange rate
Methods of Maintaining GSL
   Automatic (Using data migrator)
    – From Excel (Standard formats)
    – From Pervious version of CNET_ERP V.4.0
    – During Synchronization
    – Fast Registration
   Manual maintenance
    – All GSL maintenance are found on maintain
      main menu.
   Maintain history
Methods of editing GSL

   From maintain dialogue box
    – Must select the GSL to edit
    – Make changes and save
   From editing list
    – Excel like sheet
    – Has searching criteria
    – Multiple editing at once
    – Takes effect after saved
   Edit history
   1.2
Maintain Store
What is store

   Store is like a water tanker
   Has inlet and outlet
   All inlets and outlets are accompanied
    by document
   Will automatically balance to full
   All stores must have an account
   The system requires at least one main
    store
 Water tanker example


                    Normal

Inlet
                    Minimum




                        Outlet
Water tanker example

   Has inlet
   Has outlet
   Will store
   Will balance the level automatically
    – Minimum level
    – Normal level
Maintaining levels

   Minimum order qty
   Normal qty
   On the balance list tab
   Needs analysis and a formula can be
    applied
   For every store
Store Types

   Single Store
   Multiple
    – Hierarchy stores*
    – Parallel store
Single Store Model



       Store
Multiple hierarchy stores
          model


          Main Store




  Bar      Kitchen     House keeping
Multiple parallel store
        model



   Store 1     Store 2
1.3
Maintaining Recipe
What is Recipe

   Formulation, ingredient, composition.
   A one to many relationship.
   One product is made out of one or
    more raw material.
   A product can be used to make
    another product called semi finished
    product.
Recipe chart
  Products      Item/Products

                    Water
                     Tea
                Grinded Meet
      Tea
                    Sugar
                 Steak souse
     Burger         Bread
                   Tomato
                    Onion
    Spaghetti
                    Pasta
                   Olive oil
                   Cheese
Methods of recipe formula
   Lot size
   Unit conversation
   Portion calculation
    – 4 decimal place
    – Measurement tools must be used during
      production
   One to one relationship
   Application of semi finished products
   Cost is calculated automatically
1.4
Maintaining beginning balance
Balance list

   Balance in terms of Quantity
   Balance in terms of Cost
   Balance must be accompanied by cut
    of period.
Qty balance
   Inventory count is taken in every store
   Can be done by a counting machine
   Inventory count
    – Dynamic inventory
        Taking inventory while transaction is active
        Special program is used

    – Static inventory
        Traditional way
        All transaction will freeze
Balance in cost

   Taken from the old system
   From Stock card
   Last purchase price
   If the qty balance is 0 the beginning
    cost will be 0
Cut off period

    Balance is subjected to date
    1.   Beginning of the fiscal year
    2.   Half year
    3.   Quarter
    4.   Period (Month)
2.1 Vouchers
(Transactions)


      Source Document layer
    Vouchers (Transactions)
   Transactions are made out of one or many
    GSL
   Transactions are curried via Vouchers
   Vouchers are building blocks of subsystems
   There are 39 Vouchers in 5 Subsystems in
    CNET_ERP V.5.0
   Vouchers are source documents
   Will take effect after being issued
   Voucher will be further processed to
    produce Journal
    Kinds of Vouchers
   With respect to structure
    – Line Item Voucher (29 – 75%)
    – None line item Voucher (10 – 25%)
   With respect to Stock movements
    – Stock Moving
    – None Stock moving
Vouchers and Sub systems
division
   Core Sub system
    – Sales (7)
    – Inventory (15)
    – Accounts (7)
   Extended Sub system
    – Front office management (3)
    – Productions management (7)
    – Human Resource management (-)
Rules of Vouchers
   Sequentially Numbered
   Need time stamp
   Need one or more owner
   Should be contained in a single page
   Can not be modified after being issued
   Need a copy distribution management
    (CDM)
   Can be void
   Must support multiple print size and formats
   Has execution procedure
Line Item and None Line
item Vouchers
   All Sales, inventory and production
    Vouchers are line item vouchers
   All Accounting Vouchers and FOMS
    vouchers are non line item vouchers
   Dual Life vouchers
    – Credit sales (FOMS Room sales)
    – Refund (FOMS Room Refund)
      Parts of line item voucher
   Address section         Value section
   Item Information/       Cart Section
    (Nested reference)      Batch section
   Command section         Payment method
   Item collector          Store Section
                            Operation Section
   Term Section
                            Reference section
   Summery Section
                            Purpose section
   Voucher no Section
Parts of non Line Item
Voucher
    Address Section
    Reference section (Nested)
    Tax Section
    Account Section
    Voucher No Section
    Amount Section
    Description Section
    Cart Section
    Payment method section
    Operation Section
Sales subsystem

1.   Sales Order
2.   Performa Invoice
3.   Cash sales Invoice
4.   Credit sales invoice
5.   Sales return (Refund)
6.   Consignment sales invoice
7.   Consignment sales return
Item moving Vouchers
(Sales)
SN Voucher                      Effect
1   Cash Sales Invoice          -
2   Credit Sales Invoice        -
3   Sales Return                +
4   Consignment Sales Invoice   (-)
5   Consignment sales Return    (+)
Inventory Sub system
1.     Store Request
2.     Store Issue Voucher
3.     Store Transfer Voucher
4.     Goods Receiving Voucher
      1.   Cash Goods Receiving
      2.   Credit Goods Receiving
      3.   Dispensary Goods Receiving
      4.   Consignment Goods Receiving
5.     Purchase Request
6.     Purchase order
7.     Store Return Voucher
8.     Disposal Voucher
9.     Stock Adjustment voucher
10.    Supplier Return
11.    Consignment Supplier return
12.    Delivery Order
      Item moving Vouchers
           (Inventory)
SN   Voucher                                   Effect
1    Goods receiving                           +
       Cash, Credit, Dispensary, Consignment

2    Store Issue Voucher                       +-
3    Store Transfer Voucher                    +-
4    Supplier return Voucher                   -
5    Disposal Voucher                          -
6    Store Return Voucher                      +-
7    Stock Adjustment Voucher                  +-
8    Delivery Order                            (-)
9    Consignment Supplier return               (-)
None Item moving Voucher
SN Module        Voucher
1   Sales        Sales Order
                 Performa Invoice

2   Inventory    Store Request

                 Purchas Request

                 Purchase Order

3   Accounting   All Accounting Vouchers are
                 non item moving vouchers
4   FOMS         AllFOMS Voucher are non
                 item moving vouchers
     Accounting Vouchers
1.   Cash Receipt Voucher
2.   Bank Advise Voucher
3.   Bank Payment Voucher
4.   Pity cash Payment Voucher
5.   I O U Voucher
6.   Bank Deposit Voucher
7.   Payment Order Voucher
Sales Order

   Line Item Voucher
   Do not move item
   Shows customer interest or order info.
   Generally used to analyze market
    demand
Performa Invoice

   Line item voucher
   Non item moving voucher
   Shows the company’s pricing
    information for a specific article
Cash sales invoice

   Line item voucher
   Item moving voucher
   It is a document made during sales in
    cash 100 %
   It has a deducting effect in the
    operating store
Credit sales invoice

   Line item voucher
   Item moving voucher
   It is a document made during sales in
    credit < 100 %
   It has a deducting effect in the
    operating store
Sales Refund invoice

   Line item voucher
   Item moving voucher
   It is a document made during the
    return of items from sales
   It has a Addition effect in the
    operating store
Consignment sales invoice

   Line item voucher
   It can be Item moving voucher or non
    item moving (company policy)
   It is a document made during sales of
    items with out receiving sales
   It has a deducting effect in the
    operating store (if configured)
Consignment sales return

   Line item voucher
   It can be Item moving voucher or non
    item moving (company policy)
   It is a document made during return
    of items with out receiving sales
   It has a Addition effect in the
    operating store (if configured)
Store request

   Line item voucher
   Non item moving
   It is a document made during article
    demand from the main store
   Needs to be approved before
    proceeding
Store Issue Voucher (SIV)

   Line item voucher
   Item moving
   It is a document made during article
    issuing from the main store
   It has a dual effect.
    – Deduction effect from main store
    – Addition effect to the store issued
Purchase request

   Line item voucher
   Non item moving
   It is a document made during Item
    demand from the supplier
   This document is made in the main
    store
   Needs to be approved before
    proceeding
Purchase Order

   Line item voucher
   Non item moving
   It is a document made during Item demand
    from the supplier
   This document is made in the main store
   This document is a legal document and the
    supplier should respond and the ordering
    part should purchase the items
Goods receiving Vouchers (GRV)
     Line item voucher
     Item moving Voucher
     It is a document made during Item receiving
      from the supplier
     There are four receiving vouchers
      – Cash Goods receiving voucher
            Purchased and received in cash
      – Credit goods receiving voucher
            Purchased and received in credit
      – Consignment good receiving voucher
            Received in good faith
      – Dispensary goods receiving voucher
            Purchased and received in subsidiary store
Store Transfer Voucher
(STV)
   Line item voucher
   Item moving
   It is a document made during article
    issuing from one store to another
   It has a dual effect.
    – Deduction effect from store
    – Addition effect to the store
Store Adjustment Voucher

   Line item voucher
   Item moving
   It is a document made during article
    discrepancy and need adjustment
   It has a dual effect.
    – Deduction effect from main store
    – Addition effect to the store issued
Delivery Order Voucher (DO)

    Line item voucher
    It can be Item moving voucher or non
     item moving (company policy)
    It is a document made during
     delivering of article.
    It has a deducting effect in the
     operating store (if configured)
Disposal Voucher

   Line item voucher
   Item moving
   It is a document made during article
    discrepancy and need adjustment
   It has a dual effect.
    – Deduction effect from main store
    – Addition effect to the store issued
Store Return Voucher

   Line item voucher
   Item moving
   It is a document made during article
    return from subsidiary store to the
    main store
   It has a dual effect.
    – Deduction effect from subsidiary store
    – Addition effect to the main store
Supplier Return Voucher

   Line item voucher
   Item moving
   It is a document made during article
    return from main store to the supplier.
   This happens when the item found to
    be defective.
Merchandise stock model
Audit &
Reports
Reports Classification

1.   GSL Report
2.   Subsystem Reports
     – Voucher Reports
     – Analytical Reports
          Industry standard reports
3.   Dash Board reports
4.   Security Report
5.   Setting Reports
    GSL Reports
   Item
   Products
   Customer
   Supplier
   Employee
   Miscellaneous
     Voucher Reports
   Made by direct analysis of the voucher
   There are 15 types of voucher report
   7 of the report are only made for line item
    vouchers
   The rest 8 of them serves both types
   Therefore
    – 15 report types * 29 voucher = 435 reports
    – 8 report types * 10 vouchers = 80 reports
   There are total of 515 Voucher reports
Voucher Reports Chart
SN Voucher                          Remark
1    Categorized                    Line Item Voucher only
2    Categorized summarized         Line Item Voucher only
3    Summarized                     Line Item Voucher only
4    Running                        Both
5    Detail                         Line Item Voucher only
6    Summarized by to               Both
7    Summarized by Machine          Both
8    Summarized by Date             Both
9    Summarized by operator         Both
10   Item in voucher                Line Item Voucher only
11   Removed                        Line Item Voucher only
12   Transaction Reference          Both
13   Void Report                    Both
14   Voucher Operation              Both
15   Categorized Summarized by to   Line Item Voucher only
    Sales Subsystem report
   Sales Voucher Reports     Hospitality industry Reports
                                Daily Sales Summery
   Profitability report        Profitability report
   Business Agent              Sales Report (sales center)
                                Categorized charge type
   Summery by to and type      Summarized charge type
   Summarized sales report     Summarized Waiter
   Commission report           Waiter efficiency
                                Cash V Room Charge
   Price change                Item modifier
   Sales history report
Inventory report

   Inventory vouchers report
   Reorder
   Inventory closing
   Store report
   Purchase report
Dash Board reports
   Item
   Product
   Customer
   Supplier
   Security
   Employee (HRM)
Item/Product Dashboard
   Item/Product
    – Bin Card
    – Stock Card (Ledger)
    – Stock Valuation
         Multiple store balance
    – Stock movement
         Hourly, daily, monthly, yearly
    – Expiring
    – Reordering level monitor
    – Item analysis
Customer/Supplier
Dashboard
   Customer/Supplier
    – Customer ledger
         Summery, detail
    – Ageing Analysis
         Summery, detail
    – Customer activity
         Hourly, daily, monthly, yearly
Security Dashboard
   Active users
   Operation log
   Operation History

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:6
posted:3/11/2012
language:
pages:79