I usually start from the following "formula": SI+P-S+/-R+/-A= FI
SI: starting inventory (can be the result of a physical count) P: purchases S: sales R: returns to vendors or from customers A: plus / minus adjustments due to theft, losses, breakage,owner withdrawals, internal use or whatever FI: Final inventory (or stock on hand at any one time) At each stage, companies usually have internal procedures which are the kernel of the business rules concerning inventories. These rules always include forms, internal document flow, responsibilities (ie: who authorizes customer returns, who authorizes inventory adjustments, etc, etc) The VFP app is then built around these rules and all controls have to comply with this internal system. I hope this helps Rafael Copquin ----- Original Message ----- From: "Eugene Vital" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 04, 2006 8:36 PM Subject: Inventory suggestions >I am tasked with taking an inventory system that is currently being done > in Lotus and porting the functionality over to a VFP app. Are there any > Inventory Gurus out there > that could offer any advise on what is the best way to implement this? ( > it is an inventory of raw materials) > > Pointing me in the direction of any reading material would be helpful > also. > > > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

