Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 07-12-2019, 04:57 PM   #1
T. McConnell
Newly Registered User
 
Join Date: Jun 2019
Posts: 19
Thanks: 5
Thanked 0 Times in 0 Posts
T. McConnell is on a distinguished road
Maintain cost after order submitted and price changes??

Sorry for the title, not sure the best way to word it. So my question is for all you experts, (thank you all by the way for everything, ya'll have helped a LOT) I have a two inventory tables with forms (well subforms on a mainform) that have a part cost associated with them, and a selling price. Is there a good way to have these setup as to when an order is created and submitted, that if the cost and selling price changes it won't affect any previous order in the Orders Table? To hopefully explain this better I have part A that I paid $10 for and sell it for $15, I go through this batch of inventory and my new batch I purchased for $12 and sold for $17. How can I manage the inventory that if I edit the price in the inventory table any orders prior to the change isn't affected. Would this be a similar case to doing an inventory transaction type setup, if so any suggestions. I want to be able to maintain the changes of the parts without affecting any previous orders at the same time, tell all this information for reporting purposes. Everything I have now is setup for a static price but was asked if it could be a dynamically changing inventory price. Any help would be greatly appreciated, and I apologize for the confusing post. If you need any other information let me know.
Thanks

T. McConnell is offline   Reply With Quote
 

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Query to find cost at time of order Cowlers Queries 5 01-27-2014 07:20 AM
Max Date for Price for Order Details tl mike Queries 2 06-06-2008 02:16 PM
Assign a cost/price value toodrop down box nbqw General 5 01-17-2008 01:57 PM
Auto Updating Total Order Cost After Quantity is changed dblaszak Forms 4 10-12-2006 04:50 AM
Update New Price From Order TVReplay99 General 6 12-12-2003 11:47 AM




All times are GMT -8. The time now is 05:27 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World