Jump to content
Sign in to follow this  

Calculating Stock

Recommended Posts

We are a high end jewellery business and I am about to start a project to cover the entire business.  The first part of this project will be calculating stock in multiple branches.  I will need to be able to calculate the stock values and quantities for different dates at all times, so for instance today is 31st January 2017, how do my stock levels compare to 31st January 2016.

Most stock is made up of one off pieces although some repeating products might have 20 years of history and up to 100 sales.  There would generally be up to 15,000 different articles in stock at any one time, but I feel I should be thinking about growth in this area.

I know that I am asking a huge question for a forum, instead I am asking where should I look for answers to this?

At the moment I imagine a movements table, that will have the fields, 

Date of movement

Entry Qty

Sale Qty

Sale Return Qty

Exit Qty 

Correction Qty (this is for when things don't give us the correct answer)


Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.