 | |
#1
 
| |||
| |||
|
Inventory -
03-08-2007
, 01:46 PM
#2
| |||
| |||
|
|
Hello, A friend of mine who has a clothing shop for children asked me to write an application for him which should allow him to track his inventory. I have a Purchase Orders file (with a line items file) and a Sales Orders file (with a line items file). What is the best way to calculate stock? The easiest way to do this is through the line items files and calculate the sum of quantities purchased an quantities sold for each item. Won't this slow down the application? Is there a better way to do this? |
I would use scripts that perform functions like "Mark item received"
or "Mark PO received" and "Mark Sales Order Shipped" such that they
perform the correct additions and subtractions to your inventory
records which will have fields for "quantity on hand" "quantity
reserved" "quantity on order" etc.
#3
| |||
| |||
|
|
On Mar 8, 2:46 pm, hpu... (AT) gmail (DOT) com (Hans Puype) wrote: Hello, A friend of mine who has a clothing shop for children asked me to write an application for him which should allow him to track his inventory. I have a Purchase Orders file (with a line items file) and a Sales Orders file (with a line items file). What is the best way to calculate stock? The easiest way to do this is through the line items files and calculate the sum of quantities purchased an quantities sold for each item. Won't this slow down the application? Is there a better way to do this? Yes, it will. I wouldn't advise setting it up with live calculations. I would use scripts that perform functions like "Mark item received" or "Mark PO received" and "Mark Sales Order Shipped" such that they perform the correct additions and subtractions to your inventory records which will have fields for "quantity on hand" "quantity reserved" "quantity on order" etc. |
Even if you've got a fast computer, eventually trying to calculate
sales and additions on the fly is going to get slower and slower as
more records are added.
Using a script means you can avoid this and it alos makes it easier to
"archive off" old sales records no longer needed without affecting the
stock amounts.
Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
#4
| |||
| |||
|
|
Hello, A friend of mine who has a clothing shop for children asked me to write an application for him which should allow him to track his inventory. I have a Purchase Orders file (with a line items file) and a Sales Orders file (with a line items file). What is the best way to calculate stock? The easiest way to do this is through the line items files and calculate the sum of quantities purchased an quantities sold for each item. Won't this slow down the application? Is there a better way to do this? Thank you in advance, Kind regards, Hans |
Thanks for the help. Your
#5
| |||
| |||
|
|
Yes, it will. I wouldn't advise setting it up with live calculations. I would use scripts that perform functions like "Mark item received" or "Mark PO received" and "Mark Sales Order Shipped" such that they perform the correct additions and subtractions to your inventory records which will have fields for "quantity on hand" "quantity reserved" "quantity on order" etc. Yep, a scripts approach is much better. Even if you've got a fast computer, eventually trying to calculate sales and additions on the fly is going to get slower and slower as more records are added. Using a script means you can avoid this and it alos makes it easier to "archive off" old sales records no longer needed without affecting the stock amounts. |
would be the best solution. More work, but less trouble later on ...
Hans
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.