Inventory

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Os - 17 Feb 2007 13:47 GMT

Is there any simply way to use excel to keep Inventory purchases,
sales, adjustments
and Balances ? I like to be frank, I am asking this because I
cannot afford to buy commercial versions.

tks in advance

Os.

Reply to this Message

Ron Coderre - 17 Feb 2007 14:08 GMT

An argument could be made that Excel can be used to track very modest
inventory transaction volume, but it would be a weak substitute for the real
thing.
Honestly, a database would be a better solution. If you have MS Access...it
offers pre-built models for various applications. One of them is Inventory
Control. There may even be an industry specific inventory model that would
meet your needs closely.

I hope that helps.
***********
Regards,
Ron

XL2002, WinXP

> Is there any simply way to use excel to keep Inventory purchases,
> sales, adjustments
[quoted text clipped - 4 lines]
>
> Os.

Reply to this Message

Os - 17 Feb 2007 19:37 GMT

On Feb 17, 11:08 am, Ron Coderre <ronREMOVETHIScode...@bigfoot.com>
wrote:

> An argument could be made that Excel can be used to track very modest
> inventory transaction volume, but it would be a weak substitute for the real
[quoted text clipped - 6 lines]
> I hope that helps.
> ***********

Tks Ron, I will take a look into it.

Very kind of you !

Os

> Ron
>
[quoted text clipped - 8 lines]
>
> > Os.

Reply to this Message