库存中物品期初余额的使用情况怎么做 [英] What the use of item opening balance in inventory & how to do

问题描述

What the use of Item Opening Balance in inventory & how to do

我的尝试：



我创建了一个名为库存的应用程序。



交易是



PO

好​​收货单[GRN]

好​​发行说明[GIN]



当创建GRN的交易时，股票将添加（+）到Mst_Stock表中



当创建GIN交易时，股票将减去（ - ） ）来自Mst_Stock表。



然后如何以及在何处进行每件商品的期初余额



我的Mst_Stock表是



StockNo

商品编号

库存数量



谢谢

Basit。

What I have tried:

I have created a apps called inventory.

The transaction are

PO
Good Receive Note[GRN]
Good Issue Note[GIN]

When transaction of GRN created then the stock will added(+) into Mst_Stock Table

When transaction of GIN created then the stock will Minus(-) from Mst_Stock Table.

Then how and where to do the opening balance of each item

My Mst_Stock Table is

StockNo
ItemNo
StockQty

Thanks
Basit.

推荐答案

期初余额是首次输入商品时库存的商品数量在系统上，通常手动计入库存获取/库存检查的一部分。您需要有一些系统才能将这些内容输入到数据库中，因为一般来说，您将无法获得准确的内向，交货单，采购订单或发票详细信息。



你怎么做这里很难解释，因为我们不知道你的系统的其余部分是如何工作的，但一般来说你会有一个开放平衡的字段作为新项目屏幕的一部分，用户完成。它作为当前余额进入股票表（或者如果您要动态计算库存水平，则作为期初余额），如果数字不准确，应该有一种方法来调整（使用适当的记录）库存盘点/库存检查。

An Opening Balance is the number of items you have in stock when the item is first entered on to the system, normally manually counted as part of a stock take / inventory check. You need to have some system to get these in to the DB, since generally speaking you won't have exact good inward, delivery notes, purchase order, or invoice details to go with them.

How you do it is difficult to explain here since we have no idea how the rest of your system works, but generally speaking you would have a field for opening balance as part of the "new item" screen that the user completes. It goes into the stock table as the current balance (or as an opening balance if you are going to work out the stock level dynamically), and there should be a way to adjust this (with appropriate logging) if the number is inaccurate following a stock take / inventory check later.

这篇关于库存中物品期初余额的使用情况怎么做的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！