建议创建与数据处理有关的库存数据库 [英] Suggesting for Creating an Inventory Database with respect to datahandling

问题描述

我目前正在为我的工作开发一个库存数据库。


随着我开发它的进展，我一直在考虑处理输入差异的最佳方法并输出数据以创建剩余库存'

目前我的思路是：

有一个表单来接收输入数据...创建输入数据表

有一个表单来接收输出数据...创建一个输出数据表


然后我可以使用查询来隔离各个部分（查询将显示以ID678开头的所有部分，然后我可以计算它们并为我的输入和输出数据表生成每个部分的计数


理论上我可以从计数（输出）中减去计数（输入）以确定存储剩余的数量。


这是进行库存数据库和确定的最佳方法装运零件后剩余多少库存？任何其他可能更清洁的建议都是受欢迎的

I am currently working on an inventory database for my work.

As i''ve progressed in developing it I have been thinking about the best method for handling the difference in input and output data to create a ''remaining inventory''

Currently my line of thinking is:
Have a form to receive input data... creating an input data table
Have a form to receive output data... creating an output data table

I can then use a query to isolate various parts (query will show all parts that start with the id ''678'' which I can then count) and produce a count of each for both my input and output data table

Theoretically I can subtract the count(input) from the count(output) to determine how much is leftover for storage.


Is this the best method for going about an inventory database and determine how much stock is left over after shipping parts out? Any other suggestions that may be a little cleaner would be welcome

推荐答案

我认为没有理由让单独的表来处理输入和输出。他们都是这样或那样的三角洲。


也就是说，库存控制通常通过将增量应用于库存检查值来处理。每个股票支票都提供覆盖之前所有价格的价值，但是增量可以应用于股票支票价值直到下一次股票检查。

I see no reason for separate tables to handle the inputs and the outputs. They''re all deltas one way or another.

That said, stock control is often handled by having deltas applied to a stock-check value. Each stock check supplies values that override all that went before, but deltas can be applied to stock-check values up to and until the next stock check.

我认为最好的方法是创建针对每个库存项目的交易，然后您就拥有完整的记录。


交易至少需要

StockID

TransDate

TransQuantity

其他信息或许与发送地点相同


股票余额显然是期初余额+或 - 交易。


Phil

I believe the best way is to create transactions against each stock item, and then you have a complete record.

Transaction would have at least
StockID
TransDate
TransQuantity
Other info perhaps like where it was sent

Stock Balance is obviously opening balance + or - Transaction.

Phil

虽然可以输入库存作为调整，但它们也可以设置为第三种交易类型，它是绝对交易而不是交易。这样就可以随时添加一个新的绝对值，因此可以在不需要遍历每天多次进行的多年交易的情况下完成当前情况 - 每个项目的累计数量达到数十万。在这种情况下，所有必要的是找到最新的绝对值和之后的任何三角洲。


这只是一个捷径。并非总是必要，但通常比替代方案更实用。

Although stock-takes can be entered as an adjustment they can also be set up as a third type of transaction which is an absolute rather than a delta. That way a new absolute value can be added any time so finding the current situation can be done without the necessity to trawl through what may consist of many years of transactions that come in many times each day - adding up to hundreds of thousands for each item. All that''s necessary in such a case is to find the latest absolute and any deltas dated after that one.

It''s just a short-cut really. Not always necessary, but often more practical than the alternative.

这篇关于建议创建与数据处理有关的库存数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！