Training Day 1
MASTER DATA ENTRY
INDEX
1. MARKETING GROUP
2. PRODUCT CATEGORY
3. PRODUCT MASTER
4. TAX CATEGORY
5. PRODUCT ATTRIBUTE
6. CUSTOMER MASTER
7. VENDOR MASTER
8. EXPORT-IMPORT MASTER DATA
9. HOW TO BACKUP & RESTORE DATA
1. Marketing Group
User should
understand that all the marketing (principal) companies of the products he is
dealing in will be created under Marketing Group.
2. Product Category
User should understand that to start, product category master needs to be created first. User can club similar tax type products under one category. After entering Category name, applicable Sales & Purchase Tax types are to be defined. Also different categories can be clubbed under one Category Group that can be defined in Category Group. Multi level grouping of categories is also possible in RetailGraph. Explain that rate, margin and discount methods are defined in Category Master to calculate sales rate.
3. Product Master
Besides using Masters->Inventory->Product option to open the product master, you can also use Ctrl+F1 key to open Product Master from anywhere in the program. Product Master is divided in four tabs i.e. Product Detail, Lot Details & Image.
i. Product Details: In product detail screen marketing company, Category, Product, Billing Unit & Rate Unit fields (* marked) are mandatory and rest of the fields can be used depending upon your requirements. For example you can define Brand name of the product in Brand field and get various Brand wise reports. Please enter proper Size/Strength of the product in gm/ml/kg whatever is applicable. Also ensure that you define proper Unit of the product. In RetailGraph you can maintain different units in Box/Loose, Kg/Gm, Pkt/Pcs etc. You can also define product code or can generate the code in Alias field. If you want to generate your own bar code than please click on Generate link to do the same. Here you can also enter the manufacture’s Bar code given on the product, especially in case if you are dealing FMCG items. If you want to maintain Lot/Batch wise Bar codes than please leave the Bar Code blank. You can define the features that will be required for the particular product in “Apply on Lot” part. Here you can check box on Size, Batch, Color, Mfg Date, Expiry Date etc field that are required for the product. You can also create different attributes like Fast Moving items, Cold Storage items, Costly items etc. and can select different attributes you want to associate with a particular product. You can get various reports based on these attributes in RetailGraph. You can also define product status (continue/discontinue), product description & rates while adding a new product.
i.
Lot Details: To enter opening stock or view Lot wise stock position please click on Lot Detail Tab. In Lot Details entry screen, you can enter Location wise opening stock. In RetailGraph whenever you make purchase of any item it creates a new Lot with unique Lot No. and a subsequent Bar Code for that Lot is generated automatically. For the items that have Unique IDs like in case of electronic items, mobile phones etc. you can define Unique ID wise stock in this screen.
i.
Image : Please use
Image Tab to store the image.
4. 4. Tax Category
You can create different tax type related with VAT, Tax on MRP etc using this option. You need to define tax rate & related posting accounts while creating a tax type. Please create one tax type & explain how it is linked with product in product master.
5.Product Attribute
You can create different attributes like Fast Moving items, Cold Storage items, Costly items etc. and can select different attributes in product master so that you can get various reports based on these attributes.
6.Customer Master
You can create new Customers, Vendors, Bank, Carrier (Transport), Refer by Masters from Masters->Customer
In the above
Customer Master Entry screen, you can enter complete details including email
ID, phone numbers, date of birth/wedding, credit days/limit, payment mode etc.
You can also print the cards for customers using “Print
Card” option.
You can also define customer’s license details, customer wise price list in
customer master.
7.Vendor Master
In Vendor Master Entry screen, you can enter complete details including email ID, phone numbers, date of birth/wedding, credit days/limit, payment mode etc. Approved product list with discount & price list can also be maintained vendor wise. Please to create 2-3 customers.
In Vendor Master Entry screen, you can enter complete details including email ID, phone numbers, date of birth/wedding, credit days/limit, payment mode etc. Approved product list with discount & price list can also be maintained vendor wise. Please to create 2-3 customers.
8.Export-Import Master Data
In RetailGraph you have the facility to export the master data to excel sheets, do the change required and import the data back in RetailGraph. You can export blank template files for master data creation using Export/Import Master Data option from Options menu. You can open these template files in Excel and can enter your master data in Excel and then import these file back into RetailGraph to add master data from these files. This feature not only saves a lot of time but also allows a chance to import already entered data in other software or Excel.
How to Export template files to Excel
To export template files to excel, please select the master you want to export from Export/Import Master Data in Options menu i.e. product, customer, vendor etc. For example when you select Product a list will fields will appear on your screen. Now please select the fields you want to export and click on Export Data button at the bottom. It will automatically open the excel sheet with exported data that you can save on your computer.
How to Import data from Excel files
After addition/deletion in the exported list again select the same option from Export/Import Master Data in Options menu. For example to import the exported product master, please click on Product and you will get the same screen displaying the list of field to import. Now please select the fields in which you have added/changed data and click on Import Data button and select the file from which you want to import the data. It will automatically update the master data from the selected excel sheet.
9.How to Backup & Restore Data
How to Backup Data?
Data backup must be taken daily. You can either use CD or Pen drive to take your backup. Six sets of CDs should be kept in order to maintain daily backup for the complete week. Each CD should be named as week days i.e. Monday, Tuesday, Wednesday, Thursday, Friday & Saturday. On month end backup should be taken in new CD and should be kept safely. So there will be 6 CDs for the daily backup & 12 CDs of monthly backup in a year.
To backup your data you can use Data Backup option available in Option Menu. It will ask you the path where the backup file is to be created. You can create backup file on your server hard disk and then can copy the backup file on the CD.
How to Restore Data?
You can restore your data using “Restore Database" option from Data Link Properties Link available at Login Screen (refer database restore) but please be careful before you restore the backup because it will overwrite your current data and you can restore any old data on your current data by mistake. It’s always better to call our customer care center before restoring the data backup.
If you need to format Hard disk or restore data because of a virus attack or some other reason, please make sure to take fresh backup of your program folder \SWIL and all data in SQL Server.
Please make sure that backups are taken regularly at the end of the day. In case of a data loss due to the virus attack or a hardware failure or some other reason, restoring data from backups is the only remedy with us.
Please see the attached file with this article.