Home Page link  

Physical Inventory Count / Software

 

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Physical Inventory Count / Software Alex 08-09-2007
Posted by Alex on August 9, 2007, 4:39 pm
Please log in for more thread options
I would like a program that will work on PocketPC 2003 (Symbol MC50) that
will basically do the following:

Creates a simple CSV file from items scanned in through a PocketPC.

1.. The CSV file will only have three fields per line: SKU (scanned in),
Quantity (needs to default to 1 will never be more than 99), and a date &
time stamp (system date and time)
2.. Have a spreadsheet/grid style screen with 2 columns so we can see
previous scanned items and their quantities (in case the operator gets
distracted or needs to take a break and can "see" where (s)he left off).
3.. If multiple of the same items (SKUs) are scanned consecutively they
can be grouped (tallied) together, but NOT if they are not scanned
consecutively.
4.. Most of the time we will just scan then scan the next item without
entering a quantity or any other key for that matter, but sometimes we need
to manually enter the quantity (if there are a bunch of the same SKUs in a
row or box)
5.. When we start a new scan file we would like to have it ask us for a
file name (nice but not required).
The reason for requirements #4 is to make it possible to do an audit on the
scanned in items. This way we can follow the original scanning path/trail
and verify the items and quantities from the original scan.

Does anybody know of a program available to accomplish the above? If not I
would like to see if anybody is interested in developing this (simple)
program and how much it would cost to create it and when could it be
completed?

Before anybody suggests the following:

Pocket Excel: This is essentially what I need, but the only problem is that
it's to easy for people to "end up" in the wrong cell and start scanning in
ILCs in the quantity field or visa versa and we would have to set the
default quantity and time fields/columns.

New West's Mobile Inventory Count: This is the almost perfect example for
the program that I need EXCEPT this product groups/tallies the same ILCs
together, which makes it impossible to properly audit the scanned batches.
In other words if I scan 1000 ILCs but there are only 200 different ILC I DO
NOT want to see a list/CSV file with only 200 ILCs in it with total
quantities for each ILC (RMS Physical Inventory does this for me already
anyway!).

Anybody?



Posted by Ryan @ RITE on August 9, 2007, 5:13 pm
Please log in for more thread options
Alex,
We could easily accomplish what you are looking for. If you are interested
in getting a bid on this please give us a call at 1-888-267-RITE or drop us
an email at sales@rite.us.

--
Thank you,

Ryan Sakry
Program Manager
Retail Information Technology Enterprises (RITE)
rsakry@rite.us
http://www.rite.us
320-230-2282 ext. 4002 (Office)
320-230-1796 (Fax)
>I would like a program that will work on PocketPC 2003 (Symbol MC50) that
>will basically do the following:
>
> Creates a simple CSV file from items scanned in through a PocketPC.
>
> 1.. The CSV file will only have three fields per line: SKU (scanned in),
> Quantity (needs to default to 1 will never be more than 99), and a date &
> time stamp (system date and time)
> 2.. Have a spreadsheet/grid style screen with 2 columns so we can see
> previous scanned items and their quantities (in case the operator gets
> distracted or needs to take a break and can "see" where (s)he left off).
> 3.. If multiple of the same items (SKUs) are scanned consecutively they
> can be grouped (tallied) together, but NOT if they are not scanned
> consecutively.
> 4.. Most of the time we will just scan then scan the next item without
> entering a quantity or any other key for that matter, but sometimes we
> need to manually enter the quantity (if there are a bunch of the same SKUs
> in a row or box)
> 5.. When we start a new scan file we would like to have it ask us for a
> file name (nice but not required).
> The reason for requirements #4 is to make it possible to do an audit on
> the scanned in items. This way we can follow the original scanning
> path/trail and verify the items and quantities from the original scan.
>
> Does anybody know of a program available to accomplish the above? If not I
> would like to see if anybody is interested in developing this (simple)
> program and how much it would cost to create it and when could it be
> completed?
>
> Before anybody suggests the following:
>
> Pocket Excel: This is essentially what I need, but the only problem is
> that it's to easy for people to "end up" in the wrong cell and start
> scanning in ILCs in the quantity field or visa versa and we would have to
> set the default quantity and time fields/columns.
>
> New West's Mobile Inventory Count: This is the almost perfect example for
> the program that I need EXCEPT this product groups/tallies the same ILCs
> together, which makes it impossible to properly audit the scanned batches.
> In other words if I scan 1000 ILCs but there are only 200 different ILC I
> DO NOT want to see a list/CSV file with only 200 ILCs in it with total
> quantities for each ILC (RMS Physical Inventory does this for me already
> anyway!).
>
> Anybody?
>
>



Posted by Brent on August 9, 2007, 9:19 pm
Please log in for more thread options
Too bad you are not using Palm- you could use Onhand that retails for 50 or
60 bucks- easy to us and very powerful. I had some Pocket pcs and the
software that came close to Onhand was hundreds of dollars. I got rid of my
CE windows pocket pc.


>I would like a program that will work on PocketPC 2003 (Symbol MC50) that
>will basically do the following:
>
> Creates a simple CSV file from items scanned in through a PocketPC.
>
> 1.. The CSV file will only have three fields per line: SKU (scanned in),
> Quantity (needs to default to 1 will never be more than 99), and a date &
> time stamp (system date and time)
> 2.. Have a spreadsheet/grid style screen with 2 columns so we can see
> previous scanned items and their quantities (in case the operator gets
> distracted or needs to take a break and can "see" where (s)he left off).
> 3.. If multiple of the same items (SKUs) are scanned consecutively they
> can be grouped (tallied) together, but NOT if they are not scanned
> consecutively.
> 4.. Most of the time we will just scan then scan the next item without
> entering a quantity or any other key for that matter, but sometimes we
> need to manually enter the quantity (if there are a bunch of the same SKUs
> in a row or box)
> 5.. When we start a new scan file we would like to have it ask us for a
> file name (nice but not required).
> The reason for requirements #4 is to make it possible to do an audit on
> the scanned in items. This way we can follow the original scanning
> path/trail and verify the items and quantities from the original scan.
>
> Does anybody know of a program available to accomplish the above? If not I
> would like to see if anybody is interested in developing this (simple)
> program and how much it would cost to create it and when could it be
> completed?
>
> Before anybody suggests the following:
>
> Pocket Excel: This is essentially what I need, but the only problem is
> that it's to easy for people to "end up" in the wrong cell and start
> scanning in ILCs in the quantity field or visa versa and we would have to
> set the default quantity and time fields/columns.
>
> New West's Mobile Inventory Count: This is the almost perfect example for
> the program that I need EXCEPT this product groups/tallies the same ILCs
> together, which makes it impossible to properly audit the scanned batches.
> In other words if I scan 1000 ILCs but there are only 200 different ILC I
> DO NOT want to see a list/CSV file with only 200 ILCs in it with total
> quantities for each ILC (RMS Physical Inventory does this for me already
> anyway!).
>
> Anybody?
>
>



Posted by Alex on August 9, 2007, 11:16 pm
Please log in for more thread options
What kind of Palm are you using? And what price range? Do you use them for
(heavy) inventory scanning? We currently only have 2 Symbol MC50s but we
need (at least 5) more PDAs for our physical inventory so I don't have a
problem switching if necessary.

Any other product or software suggestions?


> Too bad you are not using Palm- you could use Onhand that retails for 50
> or 60 bucks- easy to us and very powerful. I had some Pocket pcs and the
> software that came close to Onhand was hundreds of dollars. I got rid of
> my CE windows pocket pc.
>
>
>>I would like a program that will work on PocketPC 2003 (Symbol MC50) that
>>will basically do the following:
>>
>> Creates a simple CSV file from items scanned in through a PocketPC.
>>
>> 1.. The CSV file will only have three fields per line: SKU (scanned in),
>> Quantity (needs to default to 1 will never be more than 99), and a date &
>> time stamp (system date and time)
>> 2.. Have a spreadsheet/grid style screen with 2 columns so we can see
>> previous scanned items and their quantities (in case the operator gets
>> distracted or needs to take a break and can "see" where (s)he left off).
>> 3.. If multiple of the same items (SKUs) are scanned consecutively they
>> can be grouped (tallied) together, but NOT if they are not scanned
>> consecutively.
>> 4.. Most of the time we will just scan then scan the next item without
>> entering a quantity or any other key for that matter, but sometimes we
>> need to manually enter the quantity (if there are a bunch of the same
>> SKUs in a row or box)
>> 5.. When we start a new scan file we would like to have it ask us for a
>> file name (nice but not required).
>> The reason for requirements #4 is to make it possible to do an audit on
>> the scanned in items. This way we can follow the original scanning
>> path/trail and verify the items and quantities from the original scan.
>>
>> Does anybody know of a program available to accomplish the above? If not
>> I would like to see if anybody is interested in developing this (simple)
>> program and how much it would cost to create it and when could it be
>> completed?
>>
>> Before anybody suggests the following:
>>
>> Pocket Excel: This is essentially what I need, but the only problem is
>> that it's to easy for people to "end up" in the wrong cell and start
>> scanning in ILCs in the quantity field or visa versa and we would have to
>> set the default quantity and time fields/columns.
>>
>> New West's Mobile Inventory Count: This is the almost perfect example for
>> the program that I need EXCEPT this product groups/tallies the same ILCs
>> together, which makes it impossible to properly audit the scanned
>> batches. In other words if I scan 1000 ILCs but there are only 200
>> different ILC I DO NOT want to see a list/CSV file with only 200 ILCs in
>> it with total quantities for each ILC (RMS Physical Inventory does this
>> for me already anyway!).
>>
>> Anybody?
>>
>>
>
>



Posted by TomT on August 10, 2007, 10:41 am
Please log in for more thread options
Have you looked into NewWest's Mobile Suite? It runs on the Symbol Pocket
PC and is integrated into RMS. Only 1 licience is needed for howevery many
devices you have.

TomT

> What kind of Palm are you using? And what price range? Do you use them for
> (heavy) inventory scanning? We currently only have 2 Symbol MC50s but we
> need (at least 5) more PDAs for our physical inventory so I don't have a
> problem switching if necessary.
>
> Any other product or software suggestions?
>
>
>> Too bad you are not using Palm- you could use Onhand that retails for 50
>> or 60 bucks- easy to us and very powerful. I had some Pocket pcs and the
>> software that came close to Onhand was hundreds of dollars. I got rid of
>> my CE windows pocket pc.
>>
>>
>>>I would like a program that will work on PocketPC 2003 (Symbol MC50) that
>>>will basically do the following:
>>>
>>> Creates a simple CSV file from items scanned in through a PocketPC.
>>>
>>> 1.. The CSV file will only have three fields per line: SKU (scanned
>>> in), Quantity (needs to default to 1 will never be more than 99), and a
>>> date & time stamp (system date and time)
>>> 2.. Have a spreadsheet/grid style screen with 2 columns so we can see
>>> previous scanned items and their quantities (in case the operator gets
>>> distracted or needs to take a break and can "see" where (s)he left off).
>>> 3.. If multiple of the same items (SKUs) are scanned consecutively they
>>> can be grouped (tallied) together, but NOT if they are not scanned
>>> consecutively.
>>> 4.. Most of the time we will just scan then scan the next item without
>>> entering a quantity or any other key for that matter, but sometimes we
>>> need to manually enter the quantity (if there are a bunch of the same
>>> SKUs in a row or box)
>>> 5.. When we start a new scan file we would like to have it ask us for a
>>> file name (nice but not required).
>>> The reason for requirements #4 is to make it possible to do an audit on
>>> the scanned in items. This way we can follow the original scanning
>>> path/trail and verify the items and quantities from the original scan.
>>>
>>> Does anybody know of a program available to accomplish the above? If not
>>> I would like to see if anybody is interested in developing this (simple)
>>> program and how much it would cost to create it and when could it be
>>> completed?
>>>
>>> Before anybody suggests the following:
>>>
>>> Pocket Excel: This is essentially what I need, but the only problem is
>>> that it's to easy for people to "end up" in the wrong cell and start
>>> scanning in ILCs in the quantity field or visa versa and we would have
>>> to set the default quantity and time fields/columns.
>>>
>>> New West's Mobile Inventory Count: This is the almost perfect example
>>> for the program that I need EXCEPT this product groups/tallies the same
>>> ILCs together, which makes it impossible to properly audit the scanned
>>> batches. In other words if I scan 1000 ILCs but there are only 200
>>> different ILC I DO NOT want to see a list/CSV file with only 200 ILCs in
>>> it with total quantities for each ILC (RMS Physical Inventory does this
>>> for me already anyway!).
>>>
>>> Anybody?
>>>
>>>
>>
>>
>
>



Similar ThreadsPosted
physical count inventory March 1, 2007, 6:46 pm
Physical Inventory Count August 17, 2007, 10:27 pm
Physical Inventory Count??? March 25, 2008, 7:28 am
physical inventory count sheets September 15, 2006, 5:30 pm
Import Physical Inventory Count July 30, 2007, 4:46 am
Physical Inventory Count Date Error June 21, 2005, 9:09 am
physical count questions May 31, 2005, 3:32 pm
physical count of serialized items April 9, 2008, 12:38 pm
physical count sheet shows wrong departments and catagories August 7, 2007, 4:08 pm
Inventory count June 16, 2006, 4:31 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap