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/
