- Go to Analysis > Information Library
- Click to Add a new Ad-hoc query
- Select the source view of Sales Order and click OK.
- In the left column (Browse for Fields In), expand Sales Order Item Payment. Here you will be able to see details about the payments, the user that processed the payments, and the drawer close information. Here are a few suggestions for fields to drag into Include Records Where:
Information Field Needed Payment Date Sales Order Item Payment\Revenue\Date Drawer Close Date Sales Order Item Payment\Drawer Close\Drawer Close Date Drawer Status Sales Order Item Payment\Drawer Close\Status (status will be one of Submitted, Approved, or Deposited) User Sales Order Item Payment\Application User\Application User Record (this will allow you to search for a specific user)
- Next, to see information about what was in the drawer, we suggest adding the following fields in to Results Fields to Display:
Information Field Needed Payment Method (Cash, Check, etc.) Sales Order Item Payment\Revenue\Payment Method Payment Amount Sales Order Item Payment\Amount Payment Date Sales Order Item Payment\Revenue\Payment Date Refund Amount Sales Order Item\Refunds\Refund Payment\Amount Username Sales Order Item Payment\Application User\Display Name Drawer Close Date Sales Order Item Payment\Drawer Close\Drawer Close Date Deposited Cash Amount Sales Order Item Payment\Drawer Close\Deposited Cash Amount Starting Cash Amount Sales Order Item Payment\Drawer Close\Starting Cash Amount Drawer Status
Sales Order Item Payment\Drawer Close\Status (status will be one of Submitted, Approved, or Deposited)
- Here is a screenshot example of a query that is looking for details on all drawers closed today with a Status of Deposited:
- Here is a preview of results:
- You can see there is a row for each sale that was processed through the drawer. While we can only see limited information, you can see what the cashier entered as their Deposited Cash Amount (Ending Cash - Starting Cash). In the example above, the cashier processed $130 in cash transactions, but their deposited cash amount was only $100. This query does not count refunds (only sales), so we can run the Refund Report to see if this user processed any refunds. If they had not processed any refunds, we can assume that their drawer was $30 short.
Connect and collaborate with fellow Blackbaud users.