View Single Post
Old 07-15-2019, 06:49 AM   #4
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 32,965
Thanks: 13
Thanked 4,055 Times in 3,991 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Maintain cost after order submitted and price changes??

Quote:
Originally Posted by T. McConnell View Post
All I want to really mess with is the best way to manage my inventory and control the costs as it changes with each batch of stock I get in.
Well, in my view the easiest way to do that is to save the selling price in the order details table along with quantity. It would be simple to populate that field when the user selects a product from the combo using the second method here:

http://www.baldyweb.com/Autofill.htm
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is online now   Reply With Quote