NETWORK INVENTORY

[qt1504]

I have two small stores in two different building which is not a LAN
network. However, each has an internet access. I am trying to write
an inventory program which manage inventory two stores. Can anyone
help or guide me how to start? Please advise.

Thanks,
QT

[jimfortune]

qt1504 wrote:

I have two small stores in two different building which is not a LAN
network. However, each has an internet access. I am trying to write
an inventory program which manage inventory two stores. Can anyone
help or guide me how to start? Please advise.

Thanks,
QT

When it comes to custom inventory software I always tell the management
to buy a canned program. Once they find out that a $400 program
doesn't solve the real issues they are much more receptive to custom
software that addresses those issues.

James A. Fortune

[jimfortune]

qt1504 wrote:

I have two small stores in two different building which is not a LAN
network. However, each has an internet access. I am trying to write
an inventory program which manage inventory two stores. Can anyone
help or guide me how to start? Please advise.

Thanks,
QT

When it comes to custom inventory software I always tell the management
to buy a canned program. Once they find out that a $400 program
doesn't solve the real issues they are much more receptive to custom
software that addresses those issues.

James A. Fortune

[pietlinden]

I agree with James. Only because writing all the utilities to make
automating inventorying is such a nightmare. Once you factor in the
costs (time and effort) of learning all the stuff yourself, you might
as well just spend the $400. You might look at TrackIT, which Intuit
bought from BlueOcean. Should be fairly straightforward. The only
thing I wasn't nuts about when blue ocean owned it was that creating
custom reports was a pain. (Could just be my ignorance.) that said,
learning to tweak the reports would be a minor thing compared to
learning the other stuff they incorporated in the software.

Okay, back to my village... no, I don't live in Crawford. I heard that
job was taken.

[pietlinden]

I agree with James. Only because writing all the utilities to make
automating inventorying is such a nightmare. Once you factor in the
costs (time and effort) of learning all the stuff yourself, you might
as well just spend the $400. You might look at TrackIT, which Intuit
bought from BlueOcean. Should be fairly straightforward. The only
thing I wasn't nuts about when blue ocean owned it was that creating
custom reports was a pain. (Could just be my ignorance.) that said,
learning to tweak the reports would be a minor thing compared to
learning the other stuff they incorporated in the software.

Okay, back to my village... no, I don't live in Crawford. I heard that
job was taken.

[PC Datasheet]

Create an Excel file with three columns. A = ProductID, B= Product Name and
C= Closing Inventory. Install it at the remote store. At the end of the day,
email the Excel file to the central store. Save the file to the computer
with your database. Link to the Excel file and through a query update your
inventory in the database.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"qt1504" <qu*******@yahoo.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

I have two small stores in two different building which is not a LAN
network. However, each has an internet access. I am trying to write
an inventory program which manage inventory two stores. Can anyone
help or guide me how to start? Please advise.

Thanks,
QT

[PC Datasheet]

Create an Excel file with three columns. A = ProductID, B= Product Name and
C= Closing Inventory. Install it at the remote store. At the end of the day,
email the Excel file to the central store. Save the file to the computer
with your database. Link to the Excel file and through a query update your
inventory in the database.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"qt1504" <qu*******@yahoo.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

I have two small stores in two different building which is not a LAN
network. However, each has an internet access. I am trying to write
an inventory program which manage inventory two stores. Can anyone
help or guide me how to start? Please advise.

Thanks,
QT

[qt1504]

So what is the software would you suggest to buy? Creating an excel
sheet doesn't work in my case because what happen if two stores were
selling the same item at the same time but the item has limitted in
quanity. It turns out we were short quanity for customer.

-QT


*** Sent via Developersdex http://www.developersdex.com ***

[qt1504]

So what is the software would you suggest to buy? Creating an excel
sheet doesn't work in my case because what happen if two stores were
selling the same item at the same time but the item has limitted in
quanity. It turns out we were short quanity for customer.

-QT


*** Sent via Developersdex http://www.developersdex.com ***

[PC Datasheet]

Given you want an accurate inventory at the time of each sale and you don't
have a direct connection between the two locations, you could put your
complete product inventory on a web page whereby each location connects to
the webpage through Active Server Pages (ASP) via a browser. You would need
some ASP code so either location could change the inventory through a
browser. Each location at the time of a sale would go to the webpage and
check if there is adequate inventory to meet the sale. If there is, the
location would adjust the inventory on the web page for the sale and then
complete the sale. Returns and receipt would be handled in a similar
fashion.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"qt1504" <qt****@devdex.com> wrote in message
news:Vc***************@news.uswest.net...

So what is the software would you suggest to buy? Creating an excel
sheet doesn't work in my case because what happen if two stores were
selling the same item at the same time but the item has limitted in
quanity. It turns out we were short quanity for customer.

-QT


*** Sent via Developersdex http://www.developersdex.com ***

[PC Datasheet]

Given you want an accurate inventory at the time of each sale and you don't
have a direct connection between the two locations, you could put your
complete product inventory on a web page whereby each location connects to
the webpage through Active Server Pages (ASP) via a browser. You would need
some ASP code so either location could change the inventory through a
browser. Each location at the time of a sale would go to the webpage and
check if there is adequate inventory to meet the sale. If there is, the
location would adjust the inventory on the web page for the sale and then
complete the sale. Returns and receipt would be handled in a similar
fashion.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"qt1504" <qt****@devdex.com> wrote in message
news:Vc***************@news.uswest.net...

So what is the software would you suggest to buy? Creating an excel
sheet doesn't work in my case because what happen if two stores were
selling the same item at the same time but the item has limitted in
quanity. It turns out we were short quanity for customer.

-QT


*** Sent via Developersdex http://www.developersdex.com ***

[PC Datasheet]

If you have WindowsXP, take a look at Remote Desktop.

Also check into Go To My PC.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"qt1504" <qt****@devdex.com> wrote in message
news:Vc***************@news.uswest.net...

So what is the software would you suggest to buy? Creating an excel
sheet doesn't work in my case because what happen if two stores were
selling the same item at the same time but the item has limitted in
quanity. It turns out we were short quanity for customer.

-QT


*** Sent via Developersdex http://www.developersdex.com ***

[PC Datasheet]

If you have WindowsXP, take a look at Remote Desktop.

Also check into Go To My PC.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"qt1504" <qt****@devdex.com> wrote in message
news:Vc***************@news.uswest.net...

So what is the software would you suggest to buy? Creating an excel
sheet doesn't work in my case because what happen if two stores were
selling the same item at the same time but the item has limitted in
quanity. It turns out we were short quanity for customer.

-QT


*** Sent via Developersdex http://www.developersdex.com ***