Jump to content
Sign in to follow this  

Inventory Template

Recommended Posts

Hi everyone,


I hope someone can help me. I started a new job and wanted to create a simple inventory program whereby we have a part number, description, received quantity and picked quantity and then have it keep a current inventory level for that item.


I would probably want to create a new record each time we have a transaction. I would look up by part number and it would fill in the description automatically. I think I can do that. My problem is how to show a current stock level of that one item based on all the transactions, either positive or negative, for that item when I do a find by the part number.


So if I looked up sku 123456 I would see all the transcations for that sku and a running TOTAL based on everything that came in or went out.


Can anyone help me? This would put a feather in my cap at my new position if I could make this work.


Thanks so much in advance,



Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  


Important Information

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