Accounting Software Development using SQL Server and VB.Net or ASP.Net
?

Madhav
http://www.vkinfotek.com
Kiss Goodbye to expensive training programs

pedaamm***@yahoo.com wrote:
Is this a yes/no question, or multiple choice?  Perhaps an essay?

Fair enough question?

To avoid an essay, I'd like to point out that several MS-SQL based
accounting packages exist, most specifically MS Small Business
Accounting (which runs on SQL Server Express or MSDE) as well as
Microsoft Business Solutions Great Plains (which can also run on MSDE,
but SQL Server is recommended for real-world live installations).

Check out: http://www.microsoft.com/dynamics/gp/default.mspx

But don't assume because your Accounting Package is MSSQL based you
will be able to run queries, views, IOs and mass transaction updates
simply or easily - a lot of accounting solutions have extremely arcane
(or seemingly so) database structures and schemas. I don't think this
is purposefully to make the software complex, but rather the fact that
any fully featured accounting package which must be flexible enough to
be installed off the shelf needs a fair amount of latitude as far as
datastructure is concerned.

Simply put, don't look in a Great Plains, or any other accounting
system, database for total relational adherance or compliance to Cobb's
rules - it simply isn't going to happen - but you could learn a lot
about real world database designs that successfully work on tens of
thousands of installations - and that is always a good place to learn
from (just like the MSSQL System SPs)

Hope this advice has set you on a path of discovery.

Andrew La Grange
------------------------------------
BUSINESS ARTISTS
Systems / Solutions / Consulting
-------------------------------------
Web: http://www.businessartists.co.za
-------------------------------------





Tracy McKibben wrote:
Show quoteHide quote

Andrew La Grange wrote:
I still don't understand your original post.  I've spent the last four
years supporting a production Great Plains installation, so I'm quite
familiar with it.

Were you asking a question, or simply posting a comment?

Distributed Queries
get a count between a time range
Why run time double in a script?
time-series calculation logic question
paramater values inside IN clause