I've recently been tasked with integrating QuickBooks with a custom built e-commerce site. What is the most painless way to go about integrating QuickBooks with my code? Are there any F/OSS or commercial software packages available that will simplify this process? Are there any F/OSS shopping cart solutions out there that include supp...
We are rewriting our legacy Accounting System in VB.NET and SQL Server. We brought in a new team of .NET/ SQL Programmers to do the rewrite. Most of the system is already completed with the Dollar amounts using Floats. The legacy system language, I programmed in, did not have a Float so I probably would have used a Decimal. What is your...
Can anyone recommend an open source accounting/erp solution? Ideally I'm looking for something web-based that can handle both standard and non-profit accounting. But there's not a lot out there, so I'd like to hear about anything that people use and like. EDIT: I'm not looking for something to turn me into an accountant. This is for a r...
Has anyone found a working PHP API/framework for syncing my custom built ecommerce web site back to Quickbook for accounting? Update: I've looked into using the framework found at: http://idnforums.intuit.com/messageview.aspx?catid=56&threadid=9164 But I'm amazed to not find any other viable solutions. How else are people runn...
Are there any good resources (books, authoritative guides, etc.) for design patterns or other best practices for software that includes financial accounting features? Specifically, where is good information about handling issues like the following: Internal representations of money quantities Internal representations of accounts, jour...
Here are my current options. .Net : Using WPF, Visual C#, SQLServer Java : Using Spring, Hibernate, Enterprise DB, web-based Can you suggest which one is better?, especially with regards to building complex forms. ...
I am in the early stages of planning and designing a custom accounting application for my firm. My goal is to utilize an open source relational database for the data storage portion and I'm aware of two solid databases that are widely supported: MySQL and PostgreSQL. For a system that will require transactions, stored procedures, functi...
I'm building a simple accounting app to be used for personal finance. A user might keep track of purchases, upcoming bills, recurring deposits, etc. It will be verrrrry simple. Two questions: 1) Any advice I should keep in mind? Obviously, I'll use transactions where appropriate, but proper datatypes and other considerations would be ...
Back in October, Kristopher Johnson asked about Accounting Software Design Patterns He received several answers, but they were all basically the same, pointing to Martin Fowlers Accounting Patterns. I don't really find Fowlers patterns all that useful. They seem overly complex for a more simplistic accounting system, so I'm rehashing ...
I've been reading about accounting patterns described by Martin Fowler in his book "Analysis Patterns - Reusable Object Models". I understood the basic concepts: account, entry, transaction, etc; but I am not quite clear when it comes to the money flow when external funds flow into the system. To make sure that no money is created or des...
Hello, What kind of databases do product based accounting packages such as MYOB in Australia and Tally & Wings in India use? They don't seem to use SQL SERVER or Oracle. Their storage file appears to be totally different. Without using any third party database package...I'm amazed at how they manage to rapidly grow by adding features. ...
Hello, How do people make reusable databases that can be used for many products? For example,if we have a database designed for a school...Can it be easily modified to be given to a college? What is the way to create a database that can be used as a product to give solution to many customers with coding just once? Thanks ...
The team I'm part of manage a number of software projects - and most of the stuff we do is end to end, from requirements tracking, to project management to purchasing and setup - a big pain is tracking of financials as we have a whole process to go through for our financials. At the moment we use a spreadsheet and store all the invoices...
Before you start flaming, I'm going to tell you that I am trying to convince myself that this is a bad idea. Basically, I'm trying to create a website with some basic accounting functions. My friend, a consultant who only knows excel, asked if this could be an excel spreadsheet instead of a web interface. I found myself thinking, why i...
Our website uses a credit system to allow users to purchase inexpensive digital goods (eg. photos). We use credits, rather than asking the user to pay for items individually, because the items are cheap and we are trying to keep our credit-card/PayPal overhead low. Because we aren't a bank, we have to expire credits after a certain amo...
We use 4-4-5 Accounting Periods. In case you aren't familiar with this, you can find info at Wikipedia. To accomplish this, I created a date table with all the days for the next 10 years. I used the script (albeit modified) found here. The creation script for my table is: USE [RedFridayDates]; GO SET ANSI_NULLS ON; GO SET QUOTED_...
I have been asked to build a simple database for my church. Those using the database will need to use the form view only, so I am trying to make it very user friendly. The church has 3 bank account (checking, savings, and allocated). The allocated account is my problem. This account holds money for 4 separate missions, fundraisers, youth...
Could someone please lead me to a sample database for a financial accounting system? ...
I need to integrate my java web application with Tally software. Is it possible? Please provide some idea. ...
I am using IDS 10 and I have a simple transaction table with the inventory changes with product ID, transaction time, volume, quantity and price. Is it possible to determine the FIFO valuation solely with SQL/Stored procedures or do I need to use something like Perl with DBI for the cursor handling? Fifo valuation requires cursor-handlin...