This way you can have more than one purchase journals (GRN, Purchase Invoice, Purchase Returns, Vendor Discounts.)ģ)Your friend ask you for a simple program today. You can separate sale entries from purchase entries by a "Journal kind" code. Plan for more than one warehouses but will be very difficult to do it after.Ģ)Use only one table for journals. When we need to calculate the number of stock on hands, and the stock value, do we need to calculate the purchase table minus sales table? Also for calculating the values using First In First Out method? Normally this would be the easiest way, but I am thinking in the future where we are having large number of record, this method will be very expensive in term of processing power.ġ)Keeping the stock levels at the product table will limit you forever to only one warehouse. Sales table is for goods out, it links to product table, have timestamp, quantity and price attributes to calculate the sale price.Puchase table is for goods in, it links to product table, have timestamp, quantity and price attributes to calculate the purchased price.What they need is only to keep track goods in, goods out, supplier, customer, and purchase price and sell price so we are able to calculate purchase price, sales price, and stock value. I am going to write a small inventory tracking app for a small company.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |