| Author |
Message |
|
ocpistol
|
Post subject: Serial Number Questions  Posted: Thu Aug 02, 2012 2:05 pm |
|
Joined: Thu Aug 02, 2012 2:01 pm
Posts: 9
|
|
Well I have been playing around with this software. My company really needs to switch to something new.
Some of the things I cannot figure out is tracking serial numbers or who ordered a certain product. We need to be able to see what serial numbers are available, track who got them and when. Is this all in the current version or something that needs to be modified?
Thank You for any help!
|
|
  |
|
 |
|
dave
|
Post subject: Re: Serial Number Questions Posted: Tue Aug 07, 2012 5:08 pm |
|
Joined: Fri Oct 26, 2007 3:55 pm
Posts: 3499
Location: Colorado, US
|
|
You'll need to do this through the report tool. There is no standard report to show serial numbers but the information is stored with the invoice transaction in the journal_item table. You may be able to modify one of the standard reports and add the column serialize_number field to pull the information you are looking for.
Dave
|
|
| |
|
|
|
hucka
|
Post subject: Re: Serial Number Questions Posted: Fri Aug 10, 2012 12:05 pm |
|
Joined: Wed Sep 21, 2011 11:42 am
Posts: 93
Location: Brno, Czech Republic
|
|
I use this form for to track the serialized items movement. I hope it will help.
The primary usage is to track all movements of one item with the serial number. You can also use it to display all movements for item with one SKU. This is useful for searching of the lost items.
Note: You have to set either S/N or SKU field to equal. Otherwise the output will be very long and useless.
| Attachments: |
File comment: Serial number tracking form
SNtool.zip [1.04 KiB]
Downloaded 39 times
|
|
|
| |
|
|
|
ocpistol
|
Post subject: Re: Serial Number Questions Posted: Sat Aug 11, 2012 7:11 am |
|
Joined: Thu Aug 02, 2012 2:01 pm
Posts: 9
|
|
That report is awesome! thank you!
|
|
| |
|
|
|
