|
Thanks for response, Yes screen is the main screen, But how to capture the Screenshort of it... pls suggest
|
|
|
|
|
Dear All,
I am on the beginning stage on C# development. Currently I am developing an Voucher based Accounting Software with following:
1- Visual Studio 2010
2- Programming Language: C#
3- Database: MySql 5
At present, Database structure is as follows:
1.accAccounts (For holding information about Chart of Accounts like Account Code, Name, Subsidiary or Detail, Opening Balance etc)
2.vMaster (For Vouhcer Master information, Like Voucher Number, Date, Voucher Type (i.e Payment/Receipt/Journal), Payee Name, Remarks, Debit Account, Credit Account, Amount)
3. vDetails (For Voucher Detail information, used for further allocation of Expenses/Assets uses AccCode, Debit Amount, Credit Amount)
4. TranPost (All transactions from vMaster and vDetails will be posted in this table)
The General idea is this: User create new Voucher, enter transactions for Payment/receipt/journal etc. Then save the voucher. After approval of supervisor, Voucher will post and all transactions were copied to TransPost, once posted vMaster and vDetails were restricted to further editing.
Ofcourse when data is available in TransPost table, generation of Trial Balance, Balance Sheet & Income Statement will be based upon it.
Now my Question is: Is this the correct approach for development of Accounting Software? I am mainly concern about Year end closing process. Should I use same vMaster/vDetails/TransPost tables for every Accounting period or should I create new tables for each period? Assuming 50-80k transactions per year. What is the recommended way? For accMaster I think it should be the global table for All accounting periods, if yes, then it needs also in Master/Detail structure for holding different Opening balances for each year.
As mentioned, I am a beginner and what I've learned so far is by 'learn-by-doing' approach and guidance of all experience programmers in the forums like this. So I am in need of guidance again.
Looking forward for suggestions from all Masters specially those who are in development of Accounting Softwares.
Thanks in advance
Ahmed
|
|
|
|
|
As a beginner taking on a project of this scope I think you are nuts. I'd look for a smaller more defined project (probably business based but not the underlying accounting system).
If you are serious then you need to talk to an accountant conversant with various accounting systems, then nail down the scope of what you want to attempt and start getting some specs together working with the accountant.
On the other hand if you are attempting to create a simplistic invoicing system then talk to an accountant AND the business user - your client.
If this is for a business you should consider buying an existing system and bolting on your customised front end.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thanks for your reply, I haven't take this project for business purpose. It's a practice project for my self. Once mastering the important areas, I will move on to more advance topics.
Your suggestion to consult with accountant is already followed, as I am an Accountant , and learning programming as an hobby.
As an accountant I can assure you we can only provide information about Accounting policies not how a programmer map it to business logic in application, hence I am here.
So back to my original question: What is the recommended way to design Tables to record accounting transactions? Is it same transactions table to records multiple financial year data or multiple Tables for multiple year.
Regards
Ahmed
|
|
|
|
|
I am not an accountant nor have I ever worked on any accounting software, but I have dealt with database applications a lot. Your suggested records per year of 50-80K will definitely not be an issue for a database table on platforms like MySQL or MSSQL or Oracle or the likes, unless you are running wide open queries such as (select * from table) without any filter or limitation on rows returned.
Database design can become complicated if you want a very efficient means of storing your data. You may look over your required data several times and see if there are relations to break out into separate tables as much as possible and use primary keys, foreign keys and joins to bring your data together. Such as your "year" you could create a table that contains a primary key, year identifier and other year associated data and then that primary key would be a foreign key in your transaction table to match those transactions to that year etc.
Hopefully that kind of makes some sense and helps in some way.
|
|
|
|
|
Trak4Net wrote: I am not an accountant nor have I ever worked on any accounting software, but I have dealt with database applications a lot. Your suggested records per year of 50-80K will definitely not be an issue for a database table on platforms like MySQL or MSSQL or Oracle or the likes, unless you are running wide open queries such as (select * from table) without any filter or limitation on rows returned.
Database design can become complicated if you want a very efficient means of storing your data. You may look over your required data several times and see if there are relations to break out into separate tables as much as possible and use primary keys, foreign keys and joins to bring your data together. Such as your "year" you could create a table that contains a primary key, year identifier and other year associated data and then that primary key would be a foreign key in your transaction table to match those transactions to that year etc.
Hopefully that kind of makes some sense and helps in some way.
Very nice guidelines, I will definitely follow them, thanks a lot.
|
|
|
|
|
Hi,
i created with visual studio 2012 a windows class library. After the execution of my Stack.cs i have found Stack.dll in debug folder.
I tried to use my dll in a windows console application importing my .dll (using system; using Name_Space_In_Stack.dll) but it doesn't work.
Anyone can help me?
Thanks
|
|
|
|
|
queenB&S wrote: but it doesn't work. Please explain the exact details of the problem, including code extracts and error messages.
Veni, vidi, abiit domum
|
|
|
|
|
Without seeing the code in the .DLL, it's pretty much impossible to tell you EXACTLY what you need to put in the user statement.
But, basically, it's going to be the name supplied in the namespace line in your .DLL code. But, since you can define multiple namespaces and namespaces as children of namespaces, you have to be sure you're importing the correct namespace for the classes you want to use in your library.
|
|
|
|
|
Can i show an image of the code? i don't see how add
attachments...
|
|
|
|
|
No images allowed and no attachments.
Paste the code between HTML <pre> tags.
|
|
|
|
|
Open your original question above and click on the Edit link at the bottom of the message. you can then add your code sample, remembering to surround it with <pre> tags as beolow; you can use the code button at the top of the edit window to do this.
public void method()
{
}
Veni, vidi, abiit domum
|
|
|
|
|
In your new project, right click on the References folder and select Add Reference. Then browse to the location of your DLL and select it.
Then you can use:
using dll_namespace;
Notice without the .dll at the end, the namespace in the DLL has nothing to do with the file name.
|
|
|
|
|
Hi Ron, I note that there's a long delay before answers to questions are being updated on the site; this is resulting in, as in this case, my not seeing some other replies, like yours, before I post my own.
Which leaves me feeling a bit strange, but, at the same time, if my reply was on the same track as replies from you, and OriginalGriff, and a few others, that my soul has felt the winds in the wake of angels' wings as they flew past
But, perhaps these inadvertent me-too's will serve as bait for my mystery down-voter.
“But I don't want to go among mad people,” Alice remarked.
“Oh, you can't help that,” said the Cat: “we're all mad here. I'm mad. You're mad.”
“How do you know I'm mad?” said Alice.
“You must be," said the Cat, or you wouldn't have come here.” Lewis Carroll
|
|
|
|
|
Great minds think alike my friend.
Everybody gets a down voter once in a while, usually they are ones who's votes only count as -1 point, so they think they are doing harm when they are just annoying. Eventually they get tired of following you around and clicking, I got your back and gave you some points here
|
|
|
|
|
Hi Ron, that's very thoughtful of you, but I wasn't really kvetching.
Please wait to administer "mercy points" until you hear I'm in an ICU
I do believe in "paying the iron price," as the Ironborn would say.
cheers, Bill
“But I don't want to go among mad people,” Alice remarked.
“Oh, you can't help that,” said the Cat: “we're all mad here. I'm mad. You're mad.”
“How do you know I'm mad?” said Alice.
“You must be," said the Cat, or you wouldn't have come here.” Lewis Carroll
|
|
|
|
|
Well if it makes you feel any better, I wouldn't have voted a 5 had you told him his problem was with a divide by zero in his main routine
|
|
|
|
|
Did you add a reference to the DLL by opening the Solution Explorer, context-clicking on References, selecting Add References from the drop-down, and browsing to find the DLL ?
“But I don't want to go among mad people,” Alice remarked.
“Oh, you can't help that,” said the Cat: “we're all mad here. I'm mad. You're mad.”
“How do you know I'm mad?” said Alice.
“You must be," said the Cat, or you wouldn't have come here.” Lewis Carroll
|
|
|
|
|
Why someone down voted your question I do not know, it shows a lack of knowledge rather than blind stupidity. However the knowledge should not be gathered just from forums, get a book/tutorials and work through the examples.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I followed your advices and now it works
Thanks to everyone
|
|
|
|
|
I have a decstop application in c# and i want to run on diffrent client machine in diffrent cities . which type of services i have to use
please suggest me ....
Er. vipin gupta
|
|
|
|
|
If you're talking about a "desktop" application, we have no idea what it does, what it's requirements are, what kind of communication it requires and with what type of services, or anything else about your app.
Basically, your question, as asked, is impossible to answer!
|
|
|
|
|
Recently, i saw a person who was not changing the question and answer a bit but using improve solution to get points.
1) So please check if the matter before and the new matter is not exact.
2) Please make it compulsory for everyone to write in "What have you changed".
|
|
|
|
|
Please don't post questions like this in the technical forums.
Veni, vidi, abiit domum
|
|
|
|
|
Wrong forum. And there's no clear(& complete) details in your message. Include the link which are you talking about
Post your detailed message there[^] or there[^]
thatrajaCode converters | Education Needed
No thanks, I am all stocked up. - Luc Pattyn
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute
|
|
|
|
|