Excel file for customer purchase totals
To create an Excel file of a customer’s dollar amount of their purchases during a specific date range: In Paladin, from the top ribbon, select the Customers module. On the bottom ribbon of the module, select F1 Advanced Lookup. On the top of the Advanced Lookup window, enable All. In the Key Word search box, […]
Microsoft Excel ODBC Wizard
Many software products that store data are Open Data Base Connectivity (ODBC) compliant, allowing users to gain access to data contained in database tables. ODBC is a standard Application Programming Interface (API) for accessing disparate databases. When using ODBC, the user has the ability to access data from a number of different databases, including Firebird, […]
Top selling items in inventory
The following is an enhancement to the Inventory Count List Report KBA, showing how to use the report to determine your store’s top selling items. In Paladin, from the top ribbon, select the Reports module. In the Report Area pane, select Inventory > General. In the Report List pane, select Inventory Count List. Note: You […]
Inventory Count List Report
To create an Inventory Count List report: In Paladin, on the top ribbon, select the Reports module. In the Report Area pane, select Inventory > General. In the Report List pane, select Inventory Count List. In the Choose Report pane, click F12 Next. In the Inventory Count List window, set your report parameters in the […]
Set up a Store Use customer account
A Store Use customer account allows you to: Track products you are pulling off the shelf to use in the store. Correctly reduce the stock on hand (SOH) quantities of the products you are pulling off the shelf. Track which employee is pulling these items off the shelf. Ring out these items at cost instead […]
Invoice Payment History Report
To run an Invoice Payment History Report: In Paladin, on the top ribbon, select the Customers module. Enter or select a customer account from the Customer list. On the bottom ribbon of the module, select F6 Payment Management. In the Payment Management window, in the Charge Invoices pane, there are three options: All Applied Open […]
Applied Credit History Report
To run an Applied Credit History Report: In Paladin, on the top ribbon, select the Customers module. Enter or select a customer account from the Customer list. On the bottom ribbon of the module, select F6 Payment Management. In the Payment Management window, in the Charge Invoices pane, there are three options: All Applied Open […]
Accounting Detail Report
To create an Accounting Detail report: In Paladin, on the top ribbon, select the Reports module. In the Report Area pane, select Accounts Receivable > Accounting Reports. In the Report List pane, select Accounting Detail Report. In the Choose Report pane, click F12 Next. In the Accounting Detail Report window, in the Report Settings pane: […]
Master Report: Inventory Check
Using Paladin’s Master Report, you can filter for items that have not been ordered for quite some time and check stock on hand (SOH). To run the Master Report for this situation: In Paladin, on the top ribbon, select the Reports module. In the Report Area pane, select Inventory > General. In the Report List […]
End of Day reports
There are two reports that Paladin recommends you run daily to help with your closing procedures: Today’s Register Balance Today’s Comparative Revenue Report Paladin also suggest you backup your database on a regular basis. For information on this, refer to: Backup and copy a Paladin database to a USB drive Today’s Register Balance In Paladin, […]
Accounting: Automated Check Handling option
To include Automated Check Handling (ACH) data in the GL Summary, the following must be set: In Paladin, from the main menu, select File > Setup. Select the Accounting tab. In the Asset Accounts pane, check Include ACH. Enter the ACH account number in the ACH Account box. Click Save, then click Close. Figure 1: […]
BlockChyp: Credit card reconciliation
To maintain accurate accounting and to catch and fix problems before they affect your business and customer relationships, you must reconcile your Paladin, debit, gift, and credit card sales with your credit card processor’s records every business day. Important: BlockChyp accounts have their fees assessed at the end of a statement period. To reconcile Paladin […]
Transaction report from Quote to Order invoices
The Transaction report from Quote to Order invoices includes all invoices produced from any quote. To create a Transaction report from Quote to Order invoices: In Paladin, on the top ribbon, select the Reports module. In the Report Area pane, select Sales Analysis > What I Need to Know. In the Report List pane, select […]
Customer File Export report
You can export Paladin customer account information for both active and inactive accounts. The following customer type details are provided in the Customer File Export report’s spreadsheet columns: Customer Type ID: The integer ID assigned to the customer type in Paladin. Example: 16 Customer Type: The customer type name. Example: Farm/Agriculture Customer Type Code: The […]
Buy Down Quote Report
The Buy Down Quote report is in an Excel format generated in Paladin’s Invoice/Quote module. Before being able to generate this report, you must first: Create a quote, refer to the How to create a quote section in the Quotes KBA. Turn the quote into an order: Order Manager: Turn quotes into orders Once you […]
