Hello again:
I've read a lot here about these topics, but it's time that we need to start cracking on the actual work....
Been using some un-meaningful "1 of 10000" kind of number for the logbook, and not really correlating the 4473 to the logbook.
We aren't using a POS system yet - I like that idea for tracking but it's some years down the road. Until owner retires from day job in 4 years it's just going to be part time, but it's already gotten busy and unmanageable so that's why I'm here to get everything in line.
So, the DROS number seems like a decent idea because it's official, links the log book to the background check, etc. But, it's not available to you when you buy and log the firearm in. Sure, you can work backwards as soon as you DROS the firearm....
Do you all DROS the firearm before filling out the 4473 form?
The other one that makes sense for us is to use the "date-coded" transaction number...
120307-01 "YYMMDD-sequential number"
or something like that.
I'm thinking about using 10%'s excel log, but wondering if there is a way to program the sheet to assign this number automatically - so you run a macro in excel that grabs the current time, and checks to see if it can use "-01" or needs to move on to "-02" etc...
Little help?
Thanks
CM
I've read a lot here about these topics, but it's time that we need to start cracking on the actual work....
Been using some un-meaningful "1 of 10000" kind of number for the logbook, and not really correlating the 4473 to the logbook.
We aren't using a POS system yet - I like that idea for tracking but it's some years down the road. Until owner retires from day job in 4 years it's just going to be part time, but it's already gotten busy and unmanageable so that's why I'm here to get everything in line.
So, the DROS number seems like a decent idea because it's official, links the log book to the background check, etc. But, it's not available to you when you buy and log the firearm in. Sure, you can work backwards as soon as you DROS the firearm....
Do you all DROS the firearm before filling out the 4473 form?
The other one that makes sense for us is to use the "date-coded" transaction number...
120307-01 "YYMMDD-sequential number"
or something like that.
I'm thinking about using 10%'s excel log, but wondering if there is a way to program the sheet to assign this number automatically - so you run a macro in excel that grabs the current time, and checks to see if it can use "-01" or needs to move on to "-02" etc...
Little help?
Thanks
CM

Comment