How to Bind Transaction Type Master

Query: How to Bind Transaction Type Master?

Solution : See following Scree shot for Map Tran Table

 

POSServerDatabase

--> Payment_Master

SteekNewRest

--> POS_TranType

POSDataTransfer

-->  POS_SalesReceiptDetails

 

 

How to make Cash Sales Invoice ?

Query : How to make Cash Sales Invoice

Solution

Step : 1

Pre-Requisition: Create Following Accounts in below Heads:

1. ·         Direct Income > Revenue > Product & Service Sales > Cash Sale
2. ·         Current Assets > Cash & Cash Equivalents > Cash In Bank > Cash Account
3. ·         Direct Expenses > Cost of Goods Sold > COGS Product
4. ·         Current Assets > Inventories > Trading Inventory A/c.

See Following Account effect of Cash Sales Invoice

Sr. No.	Description	Debit.	Credit
1	Cash Account Dr.	50.00
	Cash Sales Cr.		50.000
	COGS-Product Dr.	24.903
	Trading Inventory Cr.		24.903

Step:2 Let's see now transaction wise

Master  > Sales Configuration

Step:3

Transaction > Cash Sales Invoice

Step : 3

Account Effect Report

How to do Multiple Division Translation?

Query: How to do Multiple Division Translation?

Solution : Please see the following Screen shot.

Pre-Requisition for Multiple Division Transaction

[1] Create Division Wise Contra Account 

[2] Bind such contra Account with Divisions

Step: 1 Make Group

Path : FAS > Master > Group Master

Step: 2 Make Contra Accounts

Path : FAS > Master > Account Master

Step: 3 Bind Contra Account

Path : FAS > Master > Configuration > Contra Account Configuration

Step: 4  Now, Make multi Division Transaction

Path : FAS > Master > Transaction > Multi Division Cash Payment

Step: 5   Let's see the accounting effects of same.

Path : FAS > Report > Ledger

How to Enter Purchase Voucher (Direct)

Query: How to enter Purchase Voucher Directly ?

Solution:

Please see the following screen shot for your reference

See Screen shot 1.1

Division : Select Division
Bill No : Enter Bill Number, also with this Add Bill Date
PR Type: Select Purchase type
Supplier : Select Supplier name
Radio Button : Use "Direct" Option for Raise Purchase Voucher
Select Item (Button): Select your Purchase items from POP Windows
Tran Qty : Enter Qty you had buy against Item
Rate : Enter Rate of Tran Qty which you had buy against Item
Levy : Here System auto Calculate GST base on GST Configuration in HSN Code Master
Save&Print : Final Give Save and View Print Invoice Number

See Screen shot 1.2

How to Add Purchase Configuration?

Query :How to Add Purchase Configuration?

Answer:
Open Purchase Module> Master > Purchase Configuration

See the following screen for your reference:

Configuration to: Select Transaction for Make Type for generate Separate Series
Code: Enter Code (e.g. SPR)
Title
Sr.No.
Division Name
Location
Item Type
Levy Formula

Year Locking Process

Year Locking Process
                 1. Gen_LockMonth
                 2. Lock Inventory Tables


D:\Client\Common\Year End Updates\Month Lock

ERP Solution for Chain of Restaurant

Macro Vision- ERP Solution for Chain of Restaurant

Perfect solution for  medium and Big size Organization having Chain of Restaurants, Fast food Outlets and Confectionary stores 

Macro Vision- KW Solution is total integrated solution required for managing needs of all departments of trading units viz. Accounts, Purchase , Sales and  Inventory.

Benefits:

Increasing Staff efficiency

Macro Vision- KW  Solution helps in synchronizing all the operations by providing simplicity in operations & transaction entries. It eliminates work duplication and provides transaction entry / approval / data locking after audit.

Quick & Intelligent Decision Making

Macro Vision- KW  delivers processed data to Executives & Management enables to make fast and intelligent decisions. This eliminates errors in assumptions while making decisions and provides real-time business details at required points.

Total Security

Macro Vision- KW  provides full security through user level rights for Transactions, Reports, Data transfer to Internal Server .

Macro Vision- RST- KW Solution:   Total Integrated Software Solution for Trading Unit

Main Modules:

Material Management for Central Store , Central Kitchen, Restaurants, Fast food Outlets, Confectionary stores. Central Store & Central Kitchen can be multiple for different type of Items . The Inventory Management - is based on requirements generated at Sales centers Like Restaurants, Fast food Outlets, Confectionary stores. The Production of Sales Items can be directly procured, Partially or fully prepared by Central Kitchen and Fully prepared by All type of Sales Outlets. The major raw material will be purchased by central authority in Central Store, but some items may be purchased by central kitchen or Sales Outlets. Material can be procured based on Minimum level of stock or as and when required. The Central Kitchen, Restaurants, Fast food Outlets, Confectionary stores.

The Purchase Management & inventory management - will be different at different places and it is again different for type of material.

PURCHASES MANAGEMENT -

Purchase decisions can be taken by various authorities differently with different situations.

1. Food  Items having longer life time and Non food items will be procured centrally in quantity and then distributed by central store . These Items are like Grains, Sugar, Cheese, packed food , packing material, utensils, etc,

2. Perishable Items like Milk, Vegetables, cakes ,etc, are having shorter life. This will be procured as per requirement. The requirements will be gathered based on daily basis from different units and then one common order will be provided. Macro Vision helps in generating consolidating one order from  all orders from all the units. This is also having individual quantities to enable supplier to distribute material as per order directly to the units.

§  Purchase Planning based on  minimum level of stock.

§  Purchase Indent from all Units ( restaurants / Fast food counters / Confectionary store) .  

§  Generate 1 or more Purchase Inquiries from multiple Indents & Send online emails to suppliers.

§  Generate quotation comparison & export to excel

§  Create Purchase order for material or  Service Order for services.

§  Rate contracts and approved supplier list.

§  Supplier performance , last purchase details and Item consumption pattern to decide Purchases.

§  Material Gate Entry and Goods Receipt Note.

§  Purchase voucher - Bill passing with all taxes and expenses incurred. Calculate Landing Cost.

§  Purchase Returns with reasons, Rejection analysis.

§  Online Approval of Transaction like Purchase Indent, Inquiry, Purchase Order, GRN & Purchase Invoice.

INVENTORY MANAGEMENT     

§  Multiple Location Wise Inventory handling

§  Inventory calculation based on Material Lot Number (MLN), Bach number and expiry date.

§  Issue to location, Consumption, Wastage Entry

§  Provision of converting Inventory to Capitalization / Fixed Asset

§  Stock Adjustment in case of Item code changes.

§  Stock Transfer Out - Material outward from one division (Unit) to other Division (Unit) and Stock transfer In for Inward. Transit Location for material not received at receiving end.

§  Accounting effect based on Cost price or Standard Price of the item maintained in the system.

§  Physical Stock Verification. Stock adjustment - Shortage and Excess. Daily or Monthly report.

§  location wise, Division (Unit) wise Inventory Reports, Stock Ledger, Stock Summary

§  Issue, Consumption, Wastage Registers.  Wastage and consumption can be multiple types; can be different for different purpose. like Prepared Item wastage, Raw material  Wastage,  Wastage due to mishandling, etc,. MIS reports.

§  Material expiry handling. No issue for Expired items. Issue on basis of FIFO or FEFO.

§  Physical Stock Verification with Barcodes System

Financial accounting

§  Multiple  Level Account Grouping & Control Account

§  All Accounting Vouchers (Receipt, Payment, JV, Contra, Credit Note, Debit Note)  entries

§  Voucher entries with different authorities User wise.

§  Cost center can be entered in vouchers for required accounts. Cost center wise reports.

§  – Users Authorities for Add – Edit Delete and view. Transaction locking after prescribed period. 

§  All Vouchers Printing & Register & Summary

§  All Voucher Approval & Posting in Trial Balance & Balance Sheet

§  Bill wise Payment & Receipt & Handling of Bill wise Advance Payment Settlement

§  Bank wise Auto Reconciliation

§  Cheque printing for cheque payments.

§  Assets Management – fixe asset purchase, Division wise transfer, Asset sale.

§  Depreciation Calculation & Accounting. Fixed asset register. (CWIP TO FA CONVERSION, EXPENSE TO FA CONVERSION.

§  Multiple general ledger printing

§  Trading account, Profit & Loss account, Monthly Profit and Loss.

§  Trail balance,

§  Balance sheets with schedules

Special features:

·         Division to division Auto Contra entries, when Cross divisions transaction is done. E.G. Supplier payment  of Restaurant unit is done by Head Office. in this case Contra entry of Credit accounting for HO and debit accounting entry for Restaurant will be done with same amount  automatically by the system. This can be one to many Divisions also.

·         Expense can be Shared / Distributed to Other Units ( Divisions) , which is paid by Head Office or any special unit.

·         Purchase Bill or expense bill  of Other Units ( Divisions) can be settle while making payment from HO bank in single entry.

·         General Expense Allocations from Cost Center to profit center on monthly & yearly Basis based on sales percentage automatically

·         Clear view of General Expense in P&L with before & after Profit of General Allocations from cost Center.

USER MANAGEMENT

§  User Master with password and group rights.

§  Access Rights Management

§  Log book for System Administrator

§  Record Level rights Management

§  Branch Manager Rights

Central Kitchen operations

• Centralized Order collections from various Outlets / Restaurants / or Confectionary Store ( Divisions).
• Trip wise Orders or delivery planning.
• Production Planning for kitchens for preparation of Semi finished Items or Finished Items.
• Recipe For each Item ( Semi- Finished or Finished ), helps in calculating Raw material required for the production to de done.
• Calculated Consumption of Raw Material ( Theoretically Calculation )based on recipe.
• Standard Raw Material Rate and Standard Cost for each Cooked items for Deviation Calculation.
• Internal Raw material Inventory management. Multiple stores for Stock keeping.
• Store requisition from Kitchen for Material Issue, based on Cooking planning.
• Material Issue from store to Kitchen .
• Finish item - semi finish Items - stock transfer from Central Kitchen to Different Outlets/ Divisions.
• Accounting between  Divisions to Central Kitchen  for material Transfer ( stock transfer ) based on Cost value or standard transfer price decided .
• Daily report for Actual Raw material Used / Consumed V/s Calculated Consumption. ( For Quantity Deviation)
• Daily report for Actual Raw material Cost( based on Actual RM Rates at Landed Cost ) V/s Calculated Cost (based on Standard RM rates) . ( For RM purchase price  Deviation)
• Physical Stock verification - to Match physical stock every month.
• RM wastage report for actual food costing. Multiple type of Wastage - for detailed MIS reports.
• RM Consumption entries - 1. Auto consumption based on production done 2. Auto Consumption entries for Daily material issued to Kitchen / Kitchens. 3. Manual Consumption Entries for Item preparation for testing or sampling. 4. Manual Consumption entries for Staff Food Preparation.
• Inventory management
• Driver Management System
• Special Cake Provision
• Outdoor Catering Management

Central Warehouse

For Most of the Items purchase is done by Central Warehouse and then distribute it to other divisions (Units) as and when required. Centrally Purchased items reduces over all business processes with compare to , if it is done by all units individually and make purchase process economical and efficient.

• Centralized Order collections from various Outlets / Restaurants / or Confectionary Store ( Divisions).
• Trip wise Orders or delivery planning.
• Procurement planning for perishable items will be based on day to day requirements. Since this is daily and big process, System is supporting fast and automatic Operations to speed up to consolidate total qty required Item wise and then prepare supplier wise Purchase order based on Item wise Preferred suppliers and Best rates or rate contracts. The Auto PO making process is also helping all the supplier to see individual unit's order quantity.
• For non perishable item, purchase is done in Bulk based on either Minimum- Maximum stock level, procurement cycle or season.
• Material is issued ( Stock transfer out)  based on Stock transfer request coming from Units.
• Internal Raw material Inventory management. Multiple stores for Stock keeping.
• Accounting between  Divisions to Central Kitchen  for material Transfer ( stock transfer ) based on Cost value or standard transfer price decided .
• Physical Stock verification - to Match physical stock every Day or  month depending on Company's policy.
• Bar code printing for Rack wise - stock Management.
• Driver Management System

Sales:

• Sales  will be done on Point of Sales( POS) Terminals, in Restaurant , Fast food counters or Confectionary Store Counter.
• The Sales is mostly not connected directly with ERP system.
• Total Item wise sales , Cash Sale, Card Sale, etc, will be transferred in ERP on daily basis. Macro Vision is having Data fetching module which will be configured for extracting data on daily basis on set schedule.
• The sales rates, Items , and Other required metadata can be transferred from centralized Application or Macro Vision ERP.
• Macro Vision will be also having Sales Module to enable Organization to make conventional sale, in case they want to do trading of Food Items Directly From  Central Store to Other organizations/ Customers.