customer_query

customer query

In cash receipting and web services, a customer query is a request to retrieve information about a specific customer or a list of customers from a database or system, usually by an API or service interface. It is used to identify, validate, or retrieve details about the individual or organization making a payment, donation, or transaction. 

A customer query searches customer records by filters using the 

  • Customer ID 

  • Name

  • Email or phone number

  • Account number

  • Tax ID or other identifiers

 

It returns key customer information, which may include

  • Full name

  • contact details (email, phone, address)

  • Account status (active, inactive)

  • Outstanding balances or credit

  • Transaction history or receipt references

  • Associated accounts or departments

 

Why it's used in Cash Receipting: 

  • To validate the payer before applying a receipt.

  • To retrieve billing or outstanding balance information when accepting a payment.

  • To populate receipt details automatically, improving accuracy and speed. 

  • To prevent duplicate records in systems that handle high transaction volume.

 

The customer query was updated to support Community Development Permit Deposits and Project Deposits. 

 

 

 

Copyright © 2025 Caselle, Incorporated. All rights reserved.

    • Related Articles

    • receipt query

      In cash receipting, a receipt query refers to a request to retrieve information about one or more receipts from the cash management system. This is commonly used in reporting, auditing, customer service, and reconciliation tasks. If you're working ...

    • How do I set up customer types?

      Customer types Set up a customer type to help you filter customers by what they do, how they operate, where they are located, and so on. Some common examples include residential customers and commercial customers. You can assign one customer type per ...

    • Error: Metered locations without an active customer

      Issue A location with a meter does not have an active customer. Explanation Usage cannot be billed unless the location is tied to an active customer. Solution Add an active customer to the location. Contact customer service at (800) 228-9851 for ...

    • How do I set up a customer with more than one customer type?

      Customer types You can assign one customer type to each customer. If you need to assign more than one customer type, then you can create a new customer type that will include both customer types in it, or create a user-defined field. 202302, ...

    • Error: Customer is part of a consolidated billing setup without an active master customer account

      Issue A customer using consolidated billing does not have an active master customer account. Explanation If a customer is using consolidated billing for utilities, the customer must have an active master customer account. The master customer account ...