Stock Inventory Management Files

Srock Inventory Management (SIM) Stockmag readme help file 												
												
1) First enable macro and then change profile data. Generate Product List Prodlist worksheet always after any correction												
alteration addition in product master that is products worksheet.												
												
2) Master worksheets such as Customers Masters, Suppliers Masters, Products Master can be updated,add,correct by clicking												
 [Customers/Suppliers/Products updation] button. It will make a form of data entry to customers,suppliers and products .												
The form has three options, these are add new,correction and delete.												
												
3) Sales Transaction Invoice/Purchase Order placing/Purchase Transaction Invoice can be done by clicking respective option												
 [ Purchase Order/Purchase Transactions/Sales Transactions] 												
												
4) Suppliers wise cumulative purchase and Customers wise cumulative sales can be opted by clicking												
 [Suppliers wise cumulative purchase]  and [Customers wise cumulative sales]												
												
5) Go to Profile Worksheets and change company particuars, from data and to date. Then you can proceed for data entry												
												
6) Worksheet PurOrder, that is purchase order, it is set for entering purchase order data. There are options for new order,												
order correction,order delete, printing order data AND Posting Putchase Order. After entering data click on												
Posting of Purchase Order always and after correction also.												
												
7) Order wise updation is set for goods received against purchase order. In OrdItwise worksheet all orders and their												
respective data order quantity placed products wise and products received against the order with outstanding position 												
will be figured there.												
												
8) Sales Transaction button is for entering sales transaction data invoice wise. Here also options are add new sales, correction												
delete sales invoice, posting of sales transaction, printing of sales invoice and return to main menu. After entering sales												
invoice click on Sales Transaction Posting .												
												
9) Products wise order, this menu is for display and print of purchase order position products wise, order quantiy, received												
quantity and due quantity.												
												
10) Purchase Ttransaction Invoice Wise, is the option for displaying and printing invoice wise purchase of products.												
												
11) Purchase Transactions Products Wise is the option for displaying and printing purchase transaction according to products.												
												
12) Sales Transactions Customers Wise is the option to show and print customer wise sales data. Worksheet SalesTran												
												
13) Sales Transaction Invoice Wise is the option for showing / printing invoice wise data details of sales transactions												
												
14) Producs wise stock updation is the option for updating products wise stock, ordered,receipt and sales quantity												
This option must be run before placing purchase order,sales and purchase transactions.												
												
15) Products wise detail ledger will be displayed/print by clicking the option Products Wise Ledger. It will show opening 												
balances, total purchased, total sales and total ordered quantity transaction date wise.												
												
16) Print option is for print all the above options. Purchase order,Purchase invoice and sales invoice will be printed from												
their respective page.												
												
Payment option and other options will be added next version. Any thing about this StockMag write to 
akgbest77@yahoo.com / akgbest77@gmail.com