First Job Trading Accounting System Convert GST to VAT

This was my first software job i had to do for Info System (pvt) Ltd. And i was a fresh starter to handle a system. I really didn't have faith in me that i could do the job. But my first Boss Mr. Thayaparan (CEO of Info sys & ewave) Gave me the job and explained i had to do. What he said was our government is changing the Tax GST to VAT and change Job Trading Accounting System to handle VAT as well.
When i went trough the code i saw every thing was hard coded to GST 12.5 when calculating tax. it was used on many modules with hard coded values. I think this is not the way the tax should be Handled. what i thought was to make a tax master and save value to the database and get that value and calculate the tax amount. in the future developer or customer will be able to change it when ever the government change the tax. And my deadline was one week to finish it.

My Solution for the Tax Issue.
  • Tax master with the bellow fields (Tax Code , Tax Name , Tax Personage)
  • Tax Module configuration ( This is to pick the tax code where we can conceder the tax percentage for calculation)
  • Then went it to all the modules that uses tax calculation used that configured tax percentage to calculate.
Problem faced
  • Didn't know the business process before i started it.
  • My first code change in a big company and i didn't have experience to modify code or to look at it.
  • Needed to modify all the reports that considered tax percentage because its now dynamic.
I finished the project within a week. its was a hard start but i think i have given the solution for the problem. for DB Security i have set a password and changed the database connection string as well.

Technologies Used

Languages : Visual Basic 6

Database : MS Access 97

Reports : Crystal Report 6.0

OS : Windows 98/95

Implementation

My new office gave me the address to the client place. And handed me with the invoice and asked me to get the money on the way back. I went to the client and implemented it and showed them how it works in a test environment. and they were satisfied handed over the Invoice and ask them for the money. They said that they will bank money because there accountant was not in. But i was given task to Collect the money and come back. So i waited till the accountant come for more than 2 hours. And collected the money came back to office. when i handed over the money to our accountant he was surprised he said that collecting the money was a practical joke ha ha ha .... what joke for new comer.. all laughed it out ... ha ha ha...

Comments

Post a Comment

Popular posts from this blog

The true face of LGBTQ+ Agenda and your future

Image
What you're going to read now will shock you. The future is going to get more darker family units can be destroyed in the near future. This is a study done by a Doctor in Canada who shared why sexual orientation changes,           A person to be Gay /Lesbian contains different factors. If a child is turning out to be a gay due to a problem with a genetical disorder of his genes and parental hormones. Why dose these in-balances happens you may ask for this we need to goto the root of the problem.  1. Sexual imbalances of parents of the genetic line (sexual immorality)    When a parent /great parent was involved in many sexual relationship(Have sex with many different sexual partners with different hormonal structures) will get their hormonal structure in an imbalance state this will affect brain structure of the baby, Sine sexual differentiation occurs within the womb, Homosexuality (gay /Lesbian) must be a result from the differen...
Read more

Why people stop growing when they are not rewarded

Image
Most of us give to get a reward/return. And when we give there is no reward/return we harm our self by thinking its our problem we are not good and that we have just been used. Its actually not our problem, only thing is to do is not to think about the reward but focus on moving your self forward by giving abundantly and raise your self to a place you can give more. Never try to linger and wait for the return because it will drag you down and restrain you from growing;  sometimes the best way is to let go, it will help us to feel good about our selves and move forward in life, in conclusion do deliver but dont do so expecting a return, instead expect only to give more. Being selfless is the ultimate form of being a complete being. This was taken from the teaching of the Bible. Don't forget to share this  if you agree :) Proverbs 11:24-25 One gives freely, yet grows all the richer; another withholds what he should give, and only suffers want. Whoever brings blessing wil...
Read more

When you try too hard

We when try too hard but we fail. Even you try so much things wont work out then ultimately we put our self down and tell our self we are not born to do this. Now its time to stop and let your self recover and think what went wrong how can make it easy without trying so hard. Sometime we need to try it differently focusing on the failures finding a easy solution. Trying hard is not the solution for your problems. Don't push your self to the limits and get hurt because  you cant achieve it but try approaching it in a different way. First thing you need to understand trying hard doesn't make you achieve your goal but doing it smartly.   Life is easy don't complicate it.
Read more