Gemsoft Treasure Jewelry Software with Imaging and Loose Diamond Inventory

Treasure32

Description of Available Reports in Gemsoft Treasuree

No one can possiblly think of everything, and we realized that along time ago, thats why Gemsoft Treasure reports are written using the industry standard RPT report format. This is the same report format that large corporations and multi-national banks use on their systems. The reports can be changed with off the shelf report software availabe at most software and business stores.

Report	Description	Fields
Inventory Listing (Short Format)	Inventory Status	Item, Description, Style, Location, Category, Selling Price
Inventory Listing (Long Format)	Inventory Status	Item, Description, Qty, Date, Location, Category, Style, Supplier, Part no., Type, Serial Number, Unit, Unit Cost, Cost, Labor, Cost and Price
Inventory Grouped by Category, or Supplier, or Model, or Style or Location	Inventory Status (Grouped by)	Item, Qty, Supplier, Category, Location, Style, Part No. Type, Unit, Unit Cost, Cost Stock, Price Stock
Inventory Reorder List	Prints Inventory Items that need to be reorders.	Item, Qty, Supplier
Lost Merchandise Report	Prints Merchandise that is lost, stolen or misplaced after completing an inventory check.	Item, Qty, Description, Location
Labor Costing	Prints added value labor costs to Inventory	Process, Who, Cost, Item
Vendors List	Prints Vendors.	Account No, Vendor, Address
Vendor Account Activity	Prints single Vendor Balance.	Name, Address, Phone, Fax, Account No. Beeper, No, Date, Ref. No. Description, Credits, Debits, Balance, Balance to Date
All Vendors Account Activity (Short Format)	Prints all Vendors Balances	Account No, Vendor, Date, Ref No. Credit, Date, Sum, Balance, Grand Total, Grand Total Balance
All Vendors Account Activity (Long Format)	Prints all Vendors Balances with detailed transaction history.	Account No, Vendor, Date, Ref No. Credit, Date, Sum, Balance, Grand Total, Grand Total Balance
Customer List	Prints Customer List.	No, Customer, Address, Phone
Customer Statement	Prints Customer Statement for a given date range.	Invoice No, Date, Credit, Amount, Invoice Balance, Balance to Date, Balance From To, Previous Balance Until, Balance to Date
Customer Statements All Customers	Prints Customer Statements for a given date range.	Invoice No, Date, Credit, Amount, Invoice Balance, Balance to Date, Balance From To, Previous Balance Until, Balance to Date
Customer Aging Report	Prints Customer Aging Report.	Date, Invoice, Amount, 0-30, 31-60, 61-90, Over 90, Total, Balance, Grand Total, Total Balance
Customer Aging Report All Customers	Prints Customer Aging Report.	Date, Invoice, Amount, 0-30, 31-60, 61-90, Over 90, Total, Balance, Grand Total, Total Balance
Customer Aging Report (flexible report)(Short Format)	Prints Customer Aging Report with Balance and Totals only for each customer.	Customer, Amount, 0-30, 31-60, 61-90, Over 90, Total, Balance, Grand Total, Total Balance
Customer Aging Report (flexible report)(Long Format)	Prints out Customer Aging Report with Balance and Totals and each transaction for each customer.	Customer, Date, Invoice, Amount, 0-30, 31-60, 61-90, Over 90, Total, Balance, Grand Total, Total Balance
Customer Balances (flexible report)	Prints out simple customer balance listing.	Customer, Contact, Phone, Email, Balance
Customer Mailing Labels (flexible search enabled)	Prints out Mailing labels based on flexible criteria.	First name, last name, company name, contact name, or current resident
Commissions report (Complex)	Prints out salespersons commissions based on percentages for each salesperson on each Item in Inventory. Reports is for a given time period.	Salesperson, Credit, Reference No, Comm %, Commission, Date, Customer, Grand Total
Commissions report (Simple)	Prints commission reports based on fix percentage given to each salesperson.	Salesperson, Credit, Reference No, Comm %, Commission, Date, Customer, Grand Total
General Ledger (GL) Summaries (Short Format)	Prints totals and summaries for specified criteria for each ledger code matching the criteria and given date range.	Ledger Code, Qty, Debit, Credit, Sums
General Ledger (GL) Summaries (Long Format)	Prints all transaction, totals and summaries for specified criteria for each ledger code matching the criteria and given date range.	Ledger Code, Account, Reference #, Date, Description, Item, Qty, Tax, Category, Style, Supplier, Customer, Cost, Credits, Debits
Discounts Report	Prints out Discount summaries for a given time period.	Ref#, Date, Description, Item, Qty, Style, Customer, Cost, Credit, Discount
General Ledger Report (Short Format)	Prints out all transactions posted to the GL matching the criteria.	GL Code, ACC, Ref#, Date, Description, Item, Qty, Tax, Category, Style, Customer, Credit, Debit
General Ledger Report (Long format)	Prints out all transactions posted to the GL matching the criteria.	GL Code, ACC, Ref#, Date, Description, Item, Qty, Tax, Category, Style, Supplier, Customer, Cost, Credit, Debit, Profit and Loss, Total Taxable, Non Taxable, Total Credit, Total Debit, Balance, Total Profit and Loss, Total Qty, Total Cost
Receive Methods Report	Prints out transactions by method of payments, ie Credit Card Type	GL Code, ACC, Ref#, Date, Description, Item, Qty, Tax, Category, Style, Customer, Credit, Debit
Transaction Report Listing Report	Transaction Report Listing by General Ledger Codes	GL Code, ACC, Ref#, Date, Description, Item, Qty, Tax, Category, Style, Customer, Credit, Debit
Inventory Item Numbers Report	Transaction Report by Inventory Item numbers.	GL Code, ACC, Ref#, Date, Description, Item, Qty, Tax, Category, Style, Customer, Credit, Debit
Salesperson Listing Report	Transaction Reports by Salespersons	GL Code, ACC, Ref#, Date, Description, Item, Qty, Tax, Category, Style, Customer, Credit, Debit
Work Orders (Repair Job Lists)	Prints out report of work orders based on criteria entered	Repair No., Item, Description, Location, Status, Qty, Unit Cost, Total
Customer Statement of Balance	Prints out the statement for the current active customer on the POS screen	Invoice, Type, Date, Credit, Amount, Invoice Balance
Inventory Listing with Images	Prints out a listing of inventory with images matching the search criteria and or items manually selected from the item listing.	Image Item, Qty, Location Description, Price