What the use of item opening balance in inventory & how to do

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

C#

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

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.

Posted 7-Jun-16 22:27pm

basitsar

Updated 7-Jun-16 22:37pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2016-06-07T22:37:00

Solution 1

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.

Posted 7-Jun-16 22:37pm

OriginalGriff

Comments

basitsar 9-Jun-16 0:08am

Thanks A lot. In Mst_Stock Table i have StockQty, but I don't have column called opening qty and this StockQty will (+) & (-) depend upon GRN or GIN. Is the opening qty if we enter first time in stock table then it should not change is that correct?

OriginalGriff 9-Jun-16 2:42am

No, you can put the Opening Balance into the stock quantity, that's not a problem.

basitsar 9-Jun-16 4:08am

I want to clear more about opening Balance Qty. Suppose i have store many items are there. One by one i will add into stock table and StockQty/OpenQty Column will updated. After Good Issue transaction will updated then StockQty will change accordingly. Is that correct? or I need to create another column called openingBalQty where i can store OpeningBalQty. Becoz stockQty will Changed according to transaction

OriginalGriff 9-Jun-16 4:17am

Once you have started transactions, the Opening Balance is pretty irrelevant, the stock in hand is what matters - so setting the stock to the initial value shouldn;t be a problem (unless you are trying to do full traceability in which case it becomes a whole load harder as you need to track each and every item separately - but it doesn't look like you need that level of complication).
So just set the StockQty to the opening balance initial value and don't create a new column.

basitsar 9-Jun-16 5:04am

Many Many Thanks

OriginalGriff 9-Jun-16 5:14am

You're welcome!