Can this work for me


#1

We are a hire company and are looking for a new database system to track items in and out of our stores.
Due to the nature of our business the same item will be going in and out regularly.
Ideally we would prefer an interface to allow bar-code scanning to log items to and from jobs.
Firstly is this possible using AyaNova? and secondly would it be difficult to set up baring in mind I am not a database wiz:)


#2

Hi icriddle, great to hear from you!

Is the item that goes in and out loaned/rented?
And is the client charged for the rental?
If so, what you may be interested in is the Loan Items feature of AyaNova
Review http://www.ayanova.com/AyaNova7webHelp/loan_items.htm and definitely http://www.ayanova.com/AyaNova7webHelp/loans2.htm and then we can certainly discuss specifics and so on

Or is the item that goes in and out a piece of equipment that is “owned” by the client for a period, and during that time you want to track service?
Enter as a unit if so.
First review about units at http://www.ayanova.com/AyaNova7webHelp/what_do_i_use_a_unit_for.htm and selection in the workorder http://www.ayanova.com/AyaNova7webHelp/unit.htm

Perhaps a suggestion after reviewing about loan items and units above, is to provide a few examples of what actually happens in your company - how does this item go out, how does it come back in, etc.

Any software is barcode compatible, as is AyaNova. Any generic barcode reader can enter the data it scans into a field as if it was typed in by a keyboard - saving entry time and preventing accidental incorrect entries.
You can use a barcode to scan a loan item or an unit’s serial number or an part number off of the physical item to bring up that AyaNova unit or AyaNova part from the appropriate drop down list when selecting within a workorder.
Or scan the unit’s serial number or the part number barcode off the physical item when first entering into AyaNova - i.e. if entering a part into AyaNova, place the cursor within the Part Number field, scan the part’s actual part number that is on its existing barcode, and than fill in the other fields. Or place the cursor in the UPC field in the part entry screen, scan the actual part’s UPC barcode which will automatically fill it in. Then in a workorder, when about to enter parts into the workorder, place cursor in the drop down list and scan the physical barcode of the part. Or if have entered the parts UPC code in the part entry screen, than place your cursor in the UPCX field in the workorder to bring up the corresponding part.
You can also integrate bar codes to display on reports or labels printed from AyaNova so that you can also use your scanner on printed reports (i.e. scan the workorder number barcode on a client’s claim receipt when your cursor is in the Direct Open field at the top to enter in the workorder number for you).Let me know if you have additional questions.

Take a look at the above, and let me know. We can certainly discuss specifics.

  • Joyce