All Posts

Coupon based subscription management software for flourish dairy - Ahmedabad

  We all have experience of product subscriptions mostly either monthly or annually. Ideally this is for collecting the payments against the active services the user has bought with us. Have you ever thought of susbcription process for perishable items?   A new dairy in Ahmedabad - FLOURISH came to us with this complex task of managing subscriptions for their daily users.   At first this seemed like a simple task of just managing a point/balance based card system, but then here we were looking at a massive on ground operation of door to door deilvery.   Secondly for dairy industries scalability is a complex task. Firstly for achieving it they need local presence among masses via chain of stores. Our client seems to have a vision planned out to go pan India in next 2-3 years. So basically after our first meeting, we understood our client requires following major benefits from the software application Managing a master of all clients with their suscription data against a store Managing the number of coupons purchased against each product Getting the exact tally of coupons with the stores and respective clients of the store to get daily demand count Managing and validating coupons at each store. COUPONS Coupons are a core of this application. Basically our end user here will be buying exact number of coupons against the daily usage of product. For e.g. a user has a requirement of 2 milk packets per day, then the user will be pre-buying for e.g 60 coupons of that variant for a monthly usage. So the hurdle here was to find a way to create a print format of all the coupons in one shot. So firstly we co-ordinated with their coupon printing guy and setup a pixel perfect pdf print according to their input requirement. COUPON ALLOCATION Once we have coupons printed, then part is to scan them link against the store and then against the end user via store operator login. Challenging part here was the UI/UX design. The UX need to be very easy & fast for multiple coupons to be scanned. COUPON OPERATIONS So once we have finalised with the coupon allocation UI, we implemented the same for the full coupon rotation. Following inward & outward process steps were created: Coupon allocation from HO to Stores Coupon allocation from store to user Daily inward of coupons from user to store via delivery boy Direct returned coupons by users to stores Cancelled coupons REPORTS All coupon operations are managed like double entry accounting system. Hence we can get exact tally of coupons on that particular date and time. With this we gave following reports which can be helpful in their day to day operations: Store wise coupon issued to customers Store wise coupon recevied from customers Store balance report Customer balance report Unused card report Card status report Card movement log New  & renew customer report  OUTPUT Since its implementation our client is successfully managing more than 2 Lakh+  of coupons & 40+ stores accross the cities.   TECHNOLOGIES & TOOLS USED Server end we used PHP Codeigniter framework, Angular JS for the frontend rendering. Backend we have used MySQL. Design framework is developed using Bootstrap4. Other day to day tools for project management includes our Aimcor ERP & we use GIT for version control.

case-study    |   02 Aug 2019   |   by Bhaumik Kothari

GST Invoicing software & auto return filing with API

GST came into effect in India from 1st July 2017. For smooth implementation of the system the GST Network(GSTN) was already closely partnering with the accounting and software enterprises which will help bridge this transition.   The GSTN had identified 32 such companies and were designated the status of GST Suvidha Provider(GSP). GSP’s have been given special access to the GST api's  and can build services on top it to directly integrate and smooth the return filing for the end users.   We were approached by IRIS Business Services Ltd. almost a month before the GST came into affect, to develop invoicing software which then directly files return with the help of their api services directly into the GST servers without the need of the user to login into the GST portal.   The primary challenge in this was freezing the scope of the project, as the requirements were changing rapidly almost every week as new format & parameters were surfacing after studying the GST guidelines shared by the government.   Major milestones Pixel Perfect invoice print We first tried with html invoice preview, though we realized that downloading an exact pdf of the html will not be possible technically. Hence we later improvised to directly print pdf version of the invoice.   Import of invoices Building invoice import to add as well as update invoices in the system was a major challenge. The issue was setting up the key identifier to be linked with particular invoice and adding multiple item lines against the same invoice number.   GST excel export Here the hard work was thorough study of the default export formats suggested by the GST council and understanding the linkages between all the tax document.   Following documents are covered under this software Sales documents Tax Invoice Credit & debit note Debit Note Bill of supply Advance receipt Tax paid Advanced received aggregate Tax paid aggregate Payment Receipt Purchase documents Purchase invoice Credit & debit notes Advance paid Tax paid on purchases Advance paid aggregate Tax paid aggregate Payment made   If you are looking for an invoicing solution, signup for AimcorERP – our one stop solution for all your business automation tools. Let’s empower your team.   At ADEPTSTATION we have follow agile methodology for customized software development and you can also hire dedicated resources for your next project with us. Shoot us an email at [email protected] and let us together execute your vision.   If you are developer and looking out for a job, feel free to drop your resume at [email protected].        

invoicing software  gst software  case-study    |   08 May 2020   |   by Bhaumik Kothari

Tajpura Eye Hospital ERP Implementation

Client brief Shree Narayan Eye Hospital, Tajpura, Gujarat, is a trust managed hospital & does free eye checkups and surgeries for all the patients.   Requirement To take online registration of the patients to have managed OPD’s & plan and schedule surgery allocation.   Challenge Since this was a trust managed hospital, we are looking here to manage upto 1000 OPD’s and 300 surgeries in a day.   Patient registration Patient registration is a key part when you are looking to register around thousand patients in a day. The form parameters need to be to the point and very user friendly for the reception desk to easily create a new patient with a photo and a print with unique qr code linked.    OPD management After successful registration each patient was given a card with qr code and the doctor has to just scan that to start adding examination data of the respective patient. QR code scan helps save doctors time rather than a patient search in the master.   Surgery scheduling Once the patient examination is done, they will be routed to surgery appointment if surgery is advised to them in the OPD. Surgery schedule limits the number of surgeries that can be done on a particular date, and if that number is reached it will auto assigned for the next working date.   Electronic Medical Record (EMR) All examination data will be preserved against the patient visit & the doctor will be able to easily view that while taking new examinations. This helps know patients history while in surgery and post surgery treatment.   We also have covered back office modules like accounting, HR, inventory covered in AIMCOR for smooth functioning of hospital. At ADEPTSTATION we have a team to take forward customized software development and you can also hire dedicated resources for your next project with us. Shoot us an email at [email protected] and let us help achieve your goals.   If you are developer and looking out for a job, kindly drop your resume at [email protected].   See you soon!    

aimcor  case-study  erp  hospital erp    |   09 May 2020   |   by Bhaumik Kothari