This report shows the total number of bottles (containers) at each customer’s location. The Product Deposits on Hand report can be found under Reports>Accounting Reports>Other>Product Deposits on Hand.
Fields:
Sort Option 1 & 2: The primary and secondary fields to sort by. You can choose from the following categories:
- Account Number
- Account Name
- Quantity
- Asset Tax ID
Change Branch: If you are logged into multiple branches, this option may be shown and allows you to re-select the branches to include in the report instead of having to completely exit the report.
Product Code: Select the range of product ID’s to include in the report.
Acct No: Enter the range of customers to generate in this report.
Deposits on Hand: Enter the range of the number of deposits on hand.
Major Account Code: Select the range of Major Account Codes to include in the report.
Print Details: Check this box to include account level detail on the report.
Include Customers with Zero Quantities: Check this box to include customers without any bottles-on-hand quantities.
Show Customer Activity: Select this option to display the report based on a range of customer activity dates.
Inactive Accounts Only: Select this option to only show inactive accounts on the report.
Select the ‘Print Details’ option to enable the Bottles on Hand field and include customer detail on the report. The prices and quantities included are calculated based on the Products tab within each customer’s account.
NOTE: The report includes assigned Account Status Codes when generated with ‘Print Details’ enabled.