Simple inventory system

[Henrik]

Hi all,

I'm a .net developer working with developing automation equipment for the
sawmill industry. The main focus of our product line is mechanical and
measurement equipment but our clients start asking us for an inventory system
to keep track of their produced volume.

I am new to this area (all I've done so far is store production data in a
SQL DB and create daily production reports). What we are asked to do is a
simple inventory system where our customers can keep track of the produced
artichles and create inventory reports.

The simple flow is something like this:

1. A produced item is inserted in the inventory when it is produced. Some
properties of the item like article ID, volume and maybe more is inserted.
This is done by an operator at the delivery bay of the mill.
2. The item is removed from the inventory when it is shipped to a customer.

What could be a suitable plattform for this? Are there any simple products
like this on the market? Is this a job for Access?

NOTE: I'm not interested in a full scale inventory system like what you can
get from MS Dynamics.

Thanks

[Kevin Yu [MSFT]]

Hi Henrik,

Searching through the web, there are a lot of simple inventory systems. A
lot of them are free. For example, here is a list of them.

http://www.sofotex.com/download/Busi...are/Inventory/

If you would like to have a DIY, developing such software is not very
complicated. You can use SQL Server as database, which does better in a lot
of aspects than Access. (Use SQL Express if you need free edition.) For
database software development, you can reference the PetShop in MSDN.

http://msdn.microsoft.com/library/de...us/dnbda/html/
bdasamppet.asp

If anything is unclear, please feel free to let me know.

Kevin Yu
Microsoft Online Community Support

=============== =============== =============== =====
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
=============== =============== =============== =====

(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[Nick Malik [Microsoft]]

"Henrik" <he*****@commun ity.nospamwrote in message
news:36******** *************** ***********@mic rosoft.com...

Hi all,

I'm a .net developer working with developing automation equipment for the
sawmill industry. The main focus of our product line is mechanical and
measurement equipment but our clients start asking us for an inventory
system
to keep track of their produced volume.

I am new to this area (all I've done so far is store production data in a
SQL DB and create daily production reports). What we are asked to do is a
simple inventory system where our customers can keep track of the produced
artichles and create inventory reports.

The simple flow is something like this:

1. A produced item is inserted in the inventory when it is produced. Some
properties of the item like article ID, volume and maybe more is inserted.
This is done by an operator at the delivery bay of the mill.
2. The item is removed from the inventory when it is shipped to a
customer.

What could be a suitable plattform for this? Are there any simple products
like this on the market? Is this a job for Access?

NOTE: I'm not interested in a full scale inventory system like what you
can
get from MS Dynamics.

Thanks

You may not have a software problem. You may have a business model problem.
If your company isn't set up to deliver business software, like inventory
control, you may create more problems than it is worth by rolling your own
solution. If it were me, I'd look around my area or industry and find a
good software partner. You can increase your sales by integrating with a
solution that some of your prospective customers already use, and you can
build a relationship that allows your company to earn a profit on referring
software sales without the cost of creating or maintaining a software
package that your company doesn't have the expertise to deliver better than
the competition.

In other words, if you create a cooperative marketing agreement with another
company, one that delivers your inventory control, and you write the
software to integrate with that company's software, then you BOTH benefit.

<infomercial>Mi crosoft has programs for their partners along these lines, as
many software providers do. If you'd like to partner with Microsoft, please
contact your local sales office and explain what you are looking for. They
can help you get set up. You can find a local office on the microsoft.com
site.</infomercial>

--
--- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik

Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
--

[bhar]

Hi,

If you want to develop your own Inventory system with Microsoft
products, try this Title:" Develop an Inventory managment application
using Microsoft's visual basic" published by Vk publishers. Visit
http://www.vkinfotek.com for the contents of the book.

Regards
bhar
Henrik wrote:

*Hi all,

I'm a .net developer working with developing automation equipment for
the
sawmill industry. The main focus of our product line is mechanical
and
measurement equipment but our clients start asking us for an
inventory system
to keep track of their produced volume.

I am new to this area (all I've done so far is store production data
in a
SQL DB and create daily production reports). What we are asked to do
is a
simple inventory system where our customers can keep track of the
produced
artichles and create inventory reports.

The simple flow is something like this:

1. A produced item is inserted in the inventory when it is produced.
Some
properties of the item like article ID, volume and maybe more is
inserted.
This is done by an operator at the delivery bay of the mill.
2. The item is removed from the inventory when it is shipped to a
customer.

What could be a suitable plattform for this? Are there any simple
products
like this on the market? Is this a job for Access?

NOTE: I'm not interested in a full scale inventory system like what
you can
get from MS Dynamics.

Thanks *

--
bhar
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message2469005.html