Inventory Template

[JReed1957]

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,

 

Jim

[doughemi]

See if this helps:

 

jreed1957.fp7.zip

[Alfriston]

Is there any way to get alerts when an item is almost run out?

[Lee Smith]

And this:

https://www.geistinteractive.com/2010/04/21/inventory-transactions/