Click here to Skip to main content
14,973,117 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
We are trying to developed a CA office management software in VB.Net (visual basic) with sql server. We are only develop software without and financial (fiscal year) year basis. But now we want to store client data with work and bill in financial year wise (like 2019-20,2020-21). And also required one common data for master (like client, auditor, staff ect.).
We want to know the coding for required condition. And also want to know the Table structure for Database (sql server).

With Regards
Shailendra Agrawal

What I have tried:

i am not able to code such. i am not regular programmer. i am student .
Updated 11-Mar-21 20:15pm

This forum is called "Quick Answers" which means that we can help when you get stuck on something specific.

In this case you need to hire a developer to build out the database and write all the code.
Fiscal or financial year is just a contractual date range, such as calendar year (January - December). This means that you are able to aggregate data based on dates: date of sale, date of ... (whatever).

Conclusion: you shouldn't change your database and store client's data in "financial year wise".

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900