|
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
|
|
|
|
|
sorry sir i will post it in the link you provided
|
|
|
|
|
I have two tables, call it part and customer.
Part
PartId PartDesc
1 Bolt
2 Screw
3 Nut
Customer
CustomerId PartId
1 1
2 1
3 1
1 2
I want a result that looks like this:
PartId CustomerId
1 1, 2, 3
Sorry for the rough example, but how do I flatten multiple records like that into a comma separated list?
Thanks for any guidance, cheers, --EA
|
|
|
|