apa itu AT&MS (asset tracking & management system)?
February 15th, 2011 at 08:55am Under Forum
apa itu AT&MS (asset tracking & management system)?
What’s AT& MS ?
By Barcode Scanner 1 comment
What is a good asset tracking database or software system?
February 15th, 2011 at 08:24am Under Forum
What is a good asset tracking database or software system?
We know about inFlow Inventory Software and have seen the templates for MS Access and OpenOffice.org for databases. We have also tested QuickBooks for inventory tracking, however none of the above quite fit what were looking for. We would like a software or database that is simple, does not have monthly fees (or ludicrous licensing fees), does not require a programmer to build a complex database to manage and maintain, and things of that nature. We want a system similar to how a library works; a worker comes in and checks out a ladder, we log it in the database and when it is returned, we log it again showing it is available.
Thanks for reading and please share your ideas.
Thanks!
By Barcode Scanner 2 comments
what is asset tracking and how it is linked with RFID explain briefly.?
February 15th, 2011 at 08:19am Under Forum
what is asset tracking and how it is linked with RFID explain briefly.?
By Barcode Scanner 1 comment
Where can I get freeware for Fixed Asset Tracking? Please your helllllllp?
February 15th, 2011 at 08:19am Under Forum
Where can I get freeware for Fixed Asset Tracking? Please your helllllllp?
By Barcode Scanner 1 comment
Tracking inventory in Acctg ( QBKS)…what is the diffference between sku #s and upc codes? Do I need both?
February 15th, 2011 at 08:15am Under Forum
Tracking inventory in Acctg ( QBKS)…what is the diffference between sku #s and upc codes? Do I need both?
I am managing the accounting for a bath and body product wholesale manufacturer. in th process of trying intentory add-on software to work with QBKS, I have come across UPC code options. We currently have our sales items organized by SKU’s iS a UPC code different? What purpose doe sit serve? do I need both sku’s and upc codes? please advise.
By Barcode Scanner 3 comments
I am looking for Vendors Providing Asset tracking & Management solution with GIS component to it in India?
February 15th, 2011 at 08:15am Under Forum
I am looking for Vendors Providing Asset tracking & Management solution with GIS component to it in India?
By Barcode Scanner 1 comment
asset tracking tables setup in sql?
February 15th, 2011 at 08:13am Under Forum
asset tracking tables setup in sql?
I need to set up a asset tracking db. I have to track where computers are by location. I have several locations that a computer can be located: users house, my office for repair, my office for employees to use, manufacturer for repair, returned to manufacturer if it dead on arrival. I have technicians that install the computers at users houses. I need to know when and where these computers are installed. The technicians also pick up the computers. I need to know when they do this and when the computers are returned to the office and why. I am having trouble setting up my tables correctly. here is what I have so far…
computer_location
computer_location_id pk 1 2 3 4
computer id problem: (solved with the type id they may be equal but their type wont be so they will be dealt with accordingly.)what if user_id and company_id are equal? How do we know which one it is? The type id will tell you if it is a user or a company where the computer is located! 1 2 1 4
location id(users id or company id[ial is a company in the list of companies]) who has pc can= user,company (ial or manufacturer) (ses userid=)2 2 (compid=)1 2
type_id 1 1 2 2
transaction_id 1 1 6 7
transaction_date_time 1/1/2011 1/1/2011 1/15/2011 1/15//2011
status_id 4 4 6 1
notes sent for repair @ office
type_id_name 1 2 3 4
type_id ses user company contact? lead
type_name
status 1 2 3 4 5 6
status_id staging DOA ready deployed retrieve repair KIA
status_type we have it but not ready we have but doesn’t work ready to be installed at eu installed needs pick up and returned to office repair and change status to ready used but died in service must be sent back to manufacturer if under warranty
transaction_type
transaction_type_id 1 2 3 4 5 6 7
transaction_type install repair return pickup change ownersship swap-out(took this computer out) swap-in(installed this pc in)
includes headset, camera, sometime monitor
I need help structuring the tables and I guess the logic of how this works.
thanks
By Barcode Scanner 1 comment
asset tracking database design help?
February 15th, 2011 at 08:11am Under Forum
asset tracking database design help?
I need to set up a asset tracking db. I have to track where computers are by location. I have several locations that a computer can be located: user’s house, my office for repair, my office for employees to use, manufacturer for repair, returned to manufacturer if it dead on arrival. I have technicians that install the computers at user’s houses. I need to know when and where these computers are.
The part I am very confused about is how to design the tables for tracking the computer location and status with date time stamps.
I need to know when and where a technician installs a computer, picks up a computer, swaps out a piece of hardware or tower, has them in their car, then when they get back to the office the equipment is received. once at the office it is received and diagnosed then it is repaired, sent back to the vendor/manufacturer(if under warranty), sold, used for parts, or disposed of.
each computer can have several users at one address or location. They also can be at many addresses and locations.
Conversely, a user can have many computers over a period of time. Not so much having more than one computer at one time. Users can also have many addresses over time. Not at the same time though.
I have been struggling with this for days now. I can’t seem to wrap my mind around it! Please help!!!!
thanks
By Barcode Scanner 2 comments
Best Asset Finding and People Tracking sites for a Licensed Investigator?
February 15th, 2011 at 08:05am Under Forum
Best Asset Finding and People Tracking sites for a Licensed Investigator?
I’m a licensed investigator and have all the documents to prove it. I’m also old and terrible with computers, and my employee that usually does my internet work for me is out this week. I know we recently dropped our main source, and I’m hoping someone here can give me some direction. if not, no big deal.
By Barcode Scanner 1 comment
is there a php script to allow clients to use tracking numbers to asset data?
February 15th, 2011 at 08:02am Under Forum
is there a php script to allow clients to use tracking numbers to asset data?
i am a computer technician and i want to give my customers tracking numbers so they can track the status of there computer into repairs. like give them the number and they enter it into the website and it pulls info from a database i guess saying wateva i want it to say example…this computer is pending repair things like that
Does a script exist is this even possible??? and whats the correct name for something like this?
P.S it doesnt have to be a PHP script
By Barcode Scanner 1 comment