Online sales application for consumerfed kozhikode region

Online sales application for accounts section

Description

The application was initially developed for supporting the inventory system developed by I T section (head office). The project was assigned by Regional Manger through the I T, which then modified and new features are added as a requirement by pco kozhikode. The features like cash-credit report . subsidy monitoring, monthly sales, tranfer-in transfer out monitoring were include as per the requirement of accounts manager +deepa. The project was developed on may 2015 to validate sales details for Bee bee software developed by IT section consumerfed. The data were missing, double in the software at that time, so to analyse and solve the data issue the spreadsheet was very much helped them.

     This spreadsheet helps to validate the data in the software, help to fix the bugs related with data (includes sales, expense, r&d etc). Proper internet connection is mandatory to run the sheet. The spreadsheet will change daily so as to help the triveni units to enter their last day sales details, also the system automatically compute the reports needed for accounts section and email accounts manager. The branches under kozhikode region can also enter their monthly sales transaction / account details in the sheet.  The application automatically keep a backup in consfedkozhikode@gmail.com google drive folder named " Backup ". link to spreadsheet is given in the page.

To edit the template of the sales sheet use the controller sheet, I T admin can edit this. contact number : 8281808029

controller sheet

In addition to source code , my soul is also present in this project.  I worked so sincerely and honestly on this project. Each steps were challenging as there was an unsupported behavior from the regional manager as well as regional I T section once the project was deployed. They made me to stop running the project by defaming my work.

The below are the features in the apps.

Daily sales html report

Daily sales html report

sample download here

Daily sales pdf report

sample download here

Day wise subsidy report

Day wise subsidy report with packing charges details

For sending fund flow statement

Day wise cash credit sales

Monthly wages details

Wages details email

sample download here

Monthly expense, purchase, sales report

monthly expense, sales, purchase

sample download here

Messaging to unit

sending message to unit through google spreadsheet

Fast moving consumer goods to accounts section

FMCG report consumerfed

Online sales monitoring application

Online sales monitoring application

Daily sales google script code

Google script code for spreadsheet

Automatic Backup of spreadsheet

The application will automatically create a back up of the whole spreadsheet with monthly data entered by the user in office google drive folder named backup

Messaging to triveni units through spreadsheet

any one who can login to office mail can access the spreadsheet script editor, there by helps them to send message to triveni units, a pop up will show on the screen as shown in the screen shot

Admin can lock & unlock the spreadheet

Locking and unlocking the sheet prevents the user for entering the data, the task was initially assigned by Regional Manager


link to daily sales spreadsheet


Thanks to +deepajayaprakash payyanakkal

http://javabelazy.blogspot.in/