帮助....如何避免更新售价？ [英] HELP.... How to avoid updating selling prices?
问题描述
我有一个查询计算
客户订单的产品售价。销售价格根据购买时物品的平均成本计算。
当我进行新购买时，产品成本会变化（应该）到
反映了新的平均成本。然而，问题是以前售出的商品的销售价格也随着新购买的价格而变化。
请记住我我没有在任何地方存储任何计算值。
如何在不存储
计算值的情况下克服之前销售的价格变化？
我将不胜感激。谢谢。
co *** @ muskoka.com （Colin）写道：
我有一个查询来计算客户订单上产品的销售价格。销售价格根据购买时物品的平均成本计算。
当我购买新产品时，产品成本会发生变化（应该如此）以反映新的平均成本。然而，问题在于，当进行新的购买时，以前售出的商品的销售价格也会发生变化。
请记住，我没有在任何地方存储任何计算值。如何在不存储计算值的情况下克服之前销售的价格变化？
在这种情况下，您应该将成本和价格存储在销售时间。
这不违反正常形式，因为
库存项目的成本和价格可能会发生变化。你需要记录当时的情况。
Tony
-
Tony Toews，Microsoft Access MVP
请仅在新闻组中回复，以便其他人可以阅读整个消息主题。
Microsoft Access Links，Hints，Tips&会计系统
http://www.granite.ab.ca /accsmstr.htm
谢谢Tony。
我理解你所说的逻辑，但我如何存储<每个查询的结果（即计算出的成本和销售价格）进入
a表。显然我需要在Customer Sales表中为这些项创建字段
但是如何将查询结果输入这些字段？
Colin
PS：我是访问和数据库应用程序的新手。 VBA代码目前不是我的实力中的一个。 < g>
在这种情况下，您应该在销售时存储成本和价格。
这不违反正常情况表格，因为库存项目的成本和价格可能会发生变化。你需要记录当时的情况。
Tony
Tony Toews写道：
< blockquote class =post_quotes>在这种情况下，您应该在销售时存储成本和价格。
这不违反正常形式，因为
库存的成本和价格项目可以改变。你需要记录当时的情况。
Tony
我见过亲开发者这样做......使用calced fields ...不确定
职业有哪些。我常常想知道在YTD报告中发生了什么，因为价格变化了。如果他们使用那些
数字进行税收计算，他们可能欠一些高税。
I have a query that calculates the selling price of products on
customer orders. Selling prices are calculated based on the average
cost of the items when purchased.
As I make new purchases, the product cost changes (as it should) to
reflect the new average cost. However, the problem is that the selling
price of previously sold items also change when new purchases are
made.
Keep in mind that I''m not storing any calculated values anywhere. How
can I overcome price changes on previous sales without storing
calculated values?
I would appreciate any ideas on this. Thank you.
co***@muskoka.com (Colin) wrote:
I have a query that calculates the selling price of products on
customer orders. Selling prices are calculated based on the average
cost of the items when purchased.
As I make new purchases, the product cost changes (as it should) to
reflect the new average cost. However, the problem is that the selling
price of previously sold items also change when new purchases are
made.
Keep in mind that I''m not storing any calculated values anywhere. How
can I overcome price changes on previous sales without storing
calculated values?
In this situation you should be storing the cost and price at the time of the sale.
This is not a violation of the normal forms because the cost and price of the
inventory item can change. You need to record what it is at that moment in time.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Thanks Tony.
I understand the logic of what you are saying but how do I store the
result of each query (i.e. the calculated cost and selling price) into
a table. Obviously I need to create fields in the Customer Sales table
for these items but how do I get the query results into these fields?
Colin
PS: I''m a new to access and database applications. VBA code is not one
of my my strenghts at this time. <g>
In this situation you should be storing the cost and price at the time of the sale.
This is not a violation of the normal forms because the cost and price of the
inventory item can change. You need to record what it is at that moment in time.
Tony
Tony Toews wrote:
In this situation you should be storing the cost and price at the time of the sale.
This is not a violation of the normal forms because the cost and price of the
inventory item can change. You need to record what it is at that moment in time.
Tony
I''ve seen pro developers do that...use calced fields...not sure how
professional there are. I often wondered what happend in YTD reports as
prices changed. They could owe some wopping taxes if they used those
figures for the tax calculations.
这篇关于帮助....如何避免更新售价？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
