Be hungry for success, hungry to make your mark, hungry to be seen and to be heard and to have an effect. And as you move up and become successful, make sure also to be hungry for helping others.
Hi Rick, Pleased to see you looking at inventory control. It would be nice to have A - Units in stock B - Minimum / reorder stock level C - Required stock level. D - Units to order E - Units on order F - Parts received G - Parts to follow So when A drops below B it calculates the difference with C and inserts it into D. D is available in a report as a requisition / order. when this is approved & processed to a supplier D is automatically added to E Upon receipt of the goods the number received is entered into F which automatically adjusts the values of A and G. and naturally resets all other fiels accordingly Each purchase order to be given a unique PO number (it would be nice if the number reflected last 2 digits of the year, the week number and the order that week ie 081403 That is 08 the year Week 14 and the 03 is the third order raised that week but a boring old sequential number would do) All with unit prices etc as your earlier tutorials.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.