accounting

Calculate fiscal year in SQL Server

How would you calculate the fiscal year from a date field in a view in SQL Server? ...

Year end budget - what development software should be considered?

My department, and I assume many others, have an unusual year end problem: they haven't consumed all their budget. If they don't spend it all, then next year the budget will be reduced. We've recommended numerous small pieces of software, but they've been rejected as "too inexpensive - we need to buy software development tools that cos...

Financial Account pattern implementation in Clojure: ref or agent?

I'm working my way through Fowler's Analysis Patterns and programming examples for myself in Clojure as way of developing a better understanding of both. Putting persistence/durability issues to the side for the moment[1], it seems that Clojure refs with their synchronization would be the obviously best approach. On the other hand, giv...

Average pricing implementation in a POS application?

I am developing a POS (Point of Sale) application which should be able to calculate average price. Here is the deal, i don't know what it is and how it is calculated for consumer products. I just got this requirement. All i know is this, that there is no way to know from which particular stock of goods, an item was sold from (i.e. when s...

Good online resources for Microsoft Dynamics SL?

Does anyone know of good online resources for Microsoft Dynamics SL (Solomon)? I'm interested in general support information and back end SQL support information, as well. Thanks. ...

Evenly divide a dollar amount (decimal) by an integer

I need to write an accounting routine for a program I am building that will give me an even division of a decimal by an integer. So that for example: $143.13 / 5 = 28.62 28.62 28.63 28.63 28.63 I have seen the article here: http://stackoverflow.com/questions/577427/evenly-divide-in-c, but it seems like it only works for integer divis...

Anyone have experience integrating with MYOB?

Looking to integrate a web application with MYOB. There's not much in terms of documentation out there. I've found a couple of companies that provide middleware, but nothing promising. Just thought I'd see if anyone else out there has had experience with this and might be able to save me a bit of time. Cheers ...

Multi-Country Accounting System Default currency

Hi, We are developing an enterprise-size accounting system and we have logical design problem which we couldn't solve so far. according to the GAAP standards all the financial transactions have to be stored in one currency only in the database which is pretty obvious and logical concept. but how you can satisfy this concept when you ha...

Tax calculation, Included & excluded, worldwide market...

I finishing the engine of my iPhone App, and need a flexible setup for tax handling. This is for LatinAmerica, USA & Europe markets. The App is a POS system. I support right now 2 taxes, and store the taxes in a table with Code, Name, Percent, FixedValue and if is included or excluded of the price. In this enough? Exist some sample or...

MS Dynamics GP and cost accounting

Is cost accounting native to GP? ...

Where can I find a SWIFT form in HTML?

I'm developing a banking/accounting system and want to make possible printing a SWIFT (Society for Worldwide Interbank Financial Telecommunication) payment order. Does anybody meet a HTML template of such form? ...

MySQL cloud transaction accounting per user?

We are expanding our hosting capabilities and want to provide MySQL database access in a large shared environment (think cloud services) - our goal is to charge per transaction per user similar to Amazon's EC2 services. What mechanisms are available for this type of DB accounting in MySQL? ...

Accounting System for Winforms / SQL Server applications

If you were going to write a vertical market C# / WinForms / SQL Server application and needed an accounting "engine" for it, what software package would you chose ? By vertical market, I mean the application is intended to solve a particular set of business problems, not be a generic accounting application. Thus the value add of the pr...

Using Small Business Accounting API with TransactionScope

Hi I want to wrap data operations involving 2 dbs one of which is an SBA db using the SBAAPI. Several problems arise: 1. The API insists on the transaction Isolation level being Snapshot. Any other level gives and error. 2. When I use Snapshot level, I get an error "SQL Server does not exist, the service is stopped, or access is denied"...

Database schema design for a double entry accounting system??

Does anybody know or have any links to websites describing details of how to design a database schema for a double entry accounting system ??. I did find a bunch of articles but non were very explanatory enough. Would appreciate it if someone could help me on this. ...

is there a general accounting system database schema which i can use ?

i require a generic accounting system database schema is there any sites which provide this ? ...

Open-source PHP Accounting/General Ledger Implementation

Hi, I'm looking for any open-source accounting module that I can include in my Symfony project. I was thinking of writing my own & releasing a plugin, but then I came across 2 solutions: http://arias.sourceforge.net/ http://frontaccounting.net/ Please answer on the lines of... Choosing one of the above, your experience, community s...

Java - Which accounting module is best to embed in my JAVA application?

I am developing a java application. I want to integrated some accounting module in my app. I don't want any feature-rich accounting module. I just want to maintain salaries expenses generating invoices So do you know any FREE OPEN SOURCE accounting module so that I can integrate it with my app. ...

Database Design for a double entry accounting system

Should journal entries be recorded in a database design? In the real world it makes sense to keep a daily entry book, then later transfer the daily entry book into double entry accounts. but in the computerized version, doing this produces duplicate records and that doesn't quite make sense? Real life: User ---> journal day book (singl...

Gaussian/Banker's Rounding in Javascript

I have been using Math.Round(myNumber, MidpointRounding.ToEven) in c# to do my server-side rounding, however, the user needs to know 'live' what the result of the server-side operation will be which means (avoiding an ajax request) creating a javascript method to replicate the MidpointRounding.ToEven method used by c#. MidpointRounding....