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 differential hormone in the womb itself and they
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 will be
Read more

Identify the best people to work and improve creativity and productivity

In the current managerial structure it is a rat race. Everyone is competing with each other. This makes more people who cheat there way to the top and makes your place of work that dose not do much of productive work and that lacks creativity. This what most of the software industries face no creative out come after its built up. You can clearly see that example when we look at big corporation the products which they supply. The best example is the new iphone 7 as most of the people talks about. As I'm not a huge iphone fan i see the lack of creativity and innovation has drooped drastically seeing the new replacement of the headphone jack and the bluetooth headphone that sells for $160 that looks like a tooth brush. This the lack of creativity and innovation which made people hooked to them and then they made there customers looks like clowns wearing two wireless headphones. What really happen most of the people will not notice, what was missing when you bought your new iphones 7
Read more