fdtoo

Hi mwaikange, From what i gathered from your concern below, you want to build an interactive website that can allow both the user and administrator (yourself) to access/write to your database. First, you need to decide whether to integrate your website content with your business database (i assumed this to …

Your previous posted question as per below : Its got to track the location of items in the warehouse (and shop floor) for stocktake/empty peg etc... It has to handle refunds and sales. So far ive come up with: Product (ProductID, Name, ProductCategory,Description,Price,SupplierID) ProductCategory(ProductCategory) Location (LocationID, Description) ProductLocation (ProductID, LocationID, …

Using vb or vb.net as front end to your inventory database is possible. I have done that using vb6. Try it out. Cheers! accountingdes

If you are looking for some inventory schema and some sql scripting to generate some inventory reports, maybe you may try downloading this book from accountingdes.

try accountingdes website, they have an interesting book on accounting schema, that gives you some idea as to how and what you need to design and build your own inventory system

I have the following fields in table A: GL_ID| Date |GL_Name_VC | Amount |Period_TI|Year_SI =============================================================== 1000|31/12/2005 | Sales | -8,000.00 | 12 | 2005 =============================================================== 1000|06/01/2006 | Sales | -6,000.00 | 01 | 2006 =============================================================== 1000|20/01/2006 | Sales | 2,000.00 | 01 | 2006 =============================================================== 1000|28/01/2006 | Sales | -4,000.00 …

I have the following fields in table A: GL_ID|GL_Name_VC | Amount |Period_TI|Year_SI =================================================== 1000| Inventory| 8,000.00 | 01 | 2005 =================================================== 1000| Inventory| -3,000.00 | 02 | 2005 =================================================== 1000| Inventory| 5,000.00 | 02 | 2005 =================================================== the fields above have the following datatype: Fields | Datatype =================================== GL_ID | …

I have the following fields in table A: GL_ID|GL_Name_VC | Amount |Period_TI|Year_SI =================================================== 1000| Inventory| 8,000.00 | 01 | 2005 =================================================== 1000| Inventory| -3,000.00 | 02 | 2005 =================================================== 1000| Inventory| 5,000.00 | 02 | 2005 =================================================== the fields above have the following datatype: Fields | Datatype =================================== GL_ID | …

I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI| =================================================== 1000| Sales_HW| -20,000.00 | 01 | 2005 =================================================== 1000| Sales_SW| -10,000.00 | 01 | 2005 =================================================== 1001| Cost_HW | 5,000.00 | 01 | 2005 =================================================== 1001| Cost_SW | 5,000.00 | 01 | 2005 the fields above have the …

I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI| =================================================== 1000| Software| 2,000.00 | 01 | 2005 =================================================== 1000| Software| 2,000.00 | 01 | 2005 =================================================== 1000| Software| 5,000.00 | 02 | 2005 =================================================== 1000| Software| 5,000.00 | 02 | 2005 ================================================== 1001| Hardware| 10,000.00 | 02 | …

I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI| =================================================== 1000| Sales | -20,000.00 | 01 | 2005 =================================================== 1000| Sales | -10,000.00 | 02 | 2005 =================================================== 1001| Cost | 5,000.00 | 01 | 2005 =================================================== 1001| Cost | 5,000.00 | 02 | 2005 the fields above …

I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI =================================================== 1000|liability | -10,000.00 | 08 | 2005 =================================================== 1001| asset | 20,000.00 | 08 | 2005 =================================================== 1000|liability | -9,000.00 | 09 | 2005 the fields above have the following datatype: Fields | Datatype =================================== GL_ID | Integer …