Literally any information displayed anywhere in the program is a 'report' which can include any information stored in the PPSS database.
|Possible PPSS Reports (*Available in Diamond and 24k)|
Last Purchase Dates
Quantity on Hand
Sales on Hold
The content of each report is determined by settings which act as 'filters' to filter out information not needed in the report.
For example, clicking on an option in the Work-Areas menu (like Clients)...
...presents a list (a report) of clients in the Main Table:
Clicking on any of the time-period buttons...
...narrows the list (the report) to only those records added or edited for the time period selected. Clicking on 'Today' for example shows only records added or edited today.
(Click 'View All' to see all records again.)
Every work area has a section at the bottom presenting (reporting) information about the record selected. This is the Details Area for a selected client record showing account information:
Clicking on the colored buttons:
...displays other information about the selected record. For example, clicking on the General tab displays contact information for the person selected:
Selecting other colored buttons (like General, Items, Loans/Checks, Pawns and Notes in the Clients Work Area) present (report) information about the client and his/her account.
Each Work Area...
...has Quick Links (like these for the Clients Work Area)...
...that either produce information or perform a task.
Select a Client and use Quick Links to:
Other Work Areas and Their Quick Links
Quick Links for the Inventory Work Area:
Key-Press Reports: Press a function key at the top of the keyboard to view these reports:
|Inventory Entered Today||F8|
Producing Custom Reports
Filtered reports are accessed by clicking on Reports on the Main Menu:
Select one of the options under Reports:
Choose settings (filters) on the ensuing screen to determine what information is to be included in the report.
For example, to create a list of Clients who are Active, who are on the Mailing List and who have account balances between $0 and $500, make these settings:
Reports may be printed in PDF format using a 'printer driver' for a (free) program like PDFCreator. Just select that 'printer' on the Windows Print Screen to print any report to file in PDF format (and attach the report to an email or print it out any time).
All reports for all other options function in the same way.
Search and Sort Records
Note: Columns containing both letters and numbers are sorted (in databases) as text so numbers will appear in order of 1,10,2, not 1,2,10.
When looking for records currently added or edited, click on the time-period buttons to display records for the time period selected:
Click on View All to restore all records.
If a record doesn't appear after it's been added, click on View All.
Sort Columns in the Main Table (version 6.0.516 and later)
In any Work Area, click on the table header to sort the column alphabetically or numerically:
Click on the header again to reverse the sort order.
The triangle on the right of the column header indicates the sort order:
It may be necessary to move the vertical scroll bar (on the right of the main table) up or down to find a record.
In the 24k edition, include images of clients and pawns in LEADS reports.
When storing pictures of people and items save each picture file with a descriptive filename, like part of the person's last name, or the Item ID for the item. Always use lower case letters and do not use spaces or punctuation other than hyphens in filenames.
The Law Enforcement Automated Database Search (L.E.A.D.S., 800-286-5388, video) is a national database of items acquired by pawnbrokers, secondhand and scrap-metal dealers, Internet drop-off stores and eBay listings.
Dealers can view a history of transactions and can receive alerts of and law enforcement use LEADS to search for stolen merchandise.
Register with LeadsOnLine for an ID and enter it in PPSS under File, Program Setup, Pawn Etc:
Manually Send LEADS Reports
After new items have been entered in PPSS, at the lower left in the Pawns Work Area, select 'L.E.A.D.S. Text File'. A 'File-Save' window will open. A filename is automatically generated which complies with LeadsOnLine specifications. (It will look something like this: 'w_0_876986_5_1_2018_161707.txt'.) Do not change the filename.
Click 'Save' to save the file in the folder presented, or use the drop-down menu in the 'Save-in window' to select a location (preferably on an external storage device) to save the file, then transmit the saved file to LEADS according to the instructions provided by LEADS.
The LEADS system will ignore the duplicates and only record new transactions.
Uploading to LeadsOnLine (800) 311-2656
There are 3 ways to send the file to LeadsOnLine. For single stores the simplest way is through the LeadsOnLine website. Multiple stores should use Secure Export or FTP (File Transfer Protocol).
Upload Using the LeadsOnLine Website:
A message will appear confirming a successful transmission.
Automatic Upload to LeadsOnLine with Secure Export:
This requires the installation and configuration of a secure export application developed by LeadsOnLine. Follow these instructions from LEADS.
Upload via FTP
Please be careful to follow the file-naming conventions when using Secure Export or FTP so LEADS can identify files when they are received.
Read the instructions below or refer to online instructions from LEADS.
The shop owner needs to be familiar with local police reporting requirements.
These are a few of the things that vary from jurisdiction to jurisdiction:
Default PPSS police reports include: Ticket #, Item ID and Value, Date/Time, Description (up to 20 characters), Pawn Amount, Client Age, Race, Sex, DOB, Height, Weight, Eye/Hair Color, and 2 ID #s and Types (drivers license, green card,etc). Enter additional information as needed in the details field (up to 100 characters).
The first police report will include all transactions recorded in the program. Each subsequent report will only include transactions added since the last report. To generate
To create a report that includes all transactions, go to File then Program Setup. On the General tab check 'All Data' then Save/Exit. After the report is finished, GO BACK TO PROGRAM SETUP AND REMOVE THE CHECK IN 'ALL DATA' to avoid including all transactions again in the next report.
Police Reports can be generated in various formats:
CSV and PDF and TXT can be emailed.
To access the Police Reporting functions in PPSS, on the Main Menu click on Reports:
Police Report Generic presents a list (print preview) of transactions and details that can be printed by clicking the printer icon:
Reports in CSV, PDF and TXT should be stored off of the hard drive on an external storage device, like a small flash drive. Plug an external storage device in and on that drive, create a new folder and name it 'Police Reports'.
Police Report Generic to File opens a Windows' 'Save-as screen' with 'police.csv' entered as the filename. (It may be helpful to rename the report using the store name and date, like samspawn-7-7-18, or the police might prefer a different naming format.) Navigate to the folder where police reports are kept. Click 'Save' to save the report to the destination folder.
To email the report, open an email, enter the email address provided by the police and enter 'Police Reports for [shop name]' in the subject line. In the body write something like 'Attached is our latest report of pawns. Sam Smith, Sam's Pawn, [address and phone].
Print Entire Report
To create a report that includes all transactions, go to File then Program Setup. On the General tab check 'All Data' then Save/Exit.
Under Reports on the Main Menu use either 'Police Report Generic' or 'Police Report Generic to File' under Reports. After the report is finished, GO BACK TO PROGRAM SETUP AND REMOVE THE CHECK IN 'ALL DATA'.
If 'No pawned items to export' appears, that means that no new pawn records have been created since the last police report was created.
ATF (Bureau of Alcohol, Tobacco, Firearms and Explosives)
Brady Law Requirements for Transferring a Firearm
The licensee initially will get either a 'proceed' or 'delayed' response from NICS.
Of course, the licensee must still comply with any waiting period requirements under State law. FFL's (Federal Firearms Licensees) contacting the FBI directly will receive information from the FBI indicating when the 3 business days time period elapses on 'delayed' transactions.
A Firearms Transaction Record (Form 4473, is a U.S. government form that must be completed when someone purchases a firearm from a Federal Firearm License holder (like a gun store or pawn shop).
In addition, the sale of two or more handguns to a person in a five-day period must be reported to ATF on Form 3310.4.
Section A instructions of the 4473 state, "Must Be Completed Personally By Transferee (Buyer).
This form has been removed from the PPSS 24k edition as a precautionary measure, because stores completing this form using a keyboard for input does not meet the requirement.
However, the ATF does maintain the e-Form 4473 online.