Recent content by dcartford

Not sure if a database designed with MS SQL Server is relevant to your required specification of an accounting system. You may download the database file and get an overview of the database structure and ER model, by downloading the ebook from accountingdes.com. Hopes this will help.:)

Hi, does your inventory management module covers the conventional costing mechanism (e.g. FIFO/LIFO). This mechanism is important, before you consider integrating it into your accounting system. You might even need to build control and automation in your database to create back-end entries for...

Correct me if I'm wrong, from your description, it seems you are trying to generate a cash flow report from these two tables. If that's the only report you are concerned with, try doing this way, create one table for storing the bank's particulars, e.g. banker name, address, contact, account...

Hi mz007, For greater visibility, i have included your table's fieldname below : productid product_name product_description serial_number units_in_stock units_on_order unit_price start_date To begin with, the above table would fit to function as your Product Master Table, helping you to...

Let me rearrange your thoughts. Don't split your inventory from your delivery into separate table. Create 1 table to store all your inventory movement, this will allow you to keep track of your individual stock usage and balance at each period. You may need to consider how you can apply the...

Hi farmir, Access reminds me of my young age, where i use to play around with their Northwind database. The good side of it, is it has the front and back-end compiled as a standalone application. If i understand your problem here, is that you are trying to load data from excel to access as...