Search and Filter Customer and Supplier Documents

The system enables advanced search and filtering in customer receipts and vendor receipts to access a specific receipt or group of receipts easily, using a wide range of filters that can be combined together, with the ability to export results.

First: Accessing Customer Receipts and Vendor Receipts

Accessing Customer Receipts

• From the dropdown menu select Sales

• Then select Customer Receipts

Accessing Vendor Receipts

• From the dropdown menu select Vendors

• Then select Vendor Receipts

All filter options work the same way on both pages.

Second: Available Filter Options

You can filter receipts using one or more filters at the same time, and all filters work together to narrow search results precisely.

Available Filters:

1. Reference

   • Reference number of the customer receipt or vendor receipt.

2. Type

   • Receipt

   • Payment

3. Status

   • Used: The receipt has been fully allocated to invoices.

   • Partially Used: Part of the amount has been allocated and part remains unallocated.

   • Unused: The receipt has not been allocated to any invoice.

4. Entity Name or Reference Number

   • You can search by:

     • Full entity name

     • Or part of the name (partial search)

5. Minimum Amount

   • Set the minimum amount for the receipt.

6. Maximum Amount

   • Set the maximum amount for the receipt.

7. Date (From, To)

   • Search within a specific time range.

8. Financial Year and Financial Period

   • For example: Year 2026, January

   When selecting the financial year and period:

   • The date (From / To) is automatically adjusted

   • And you cannot use the date filter manually with them at the same time.

9. Additional Fields

   • Search using previously added custom fields.

   • Example:

     • Field name: Collector Representative Name

     • Value: Fahd

10. Currency

    • Filter receipts by currency.

Third: Important Notes on Filtering

• You can combine more than one filter at the same time (for example: Status + Date + Currency).

• If the receipt does not appear:

  • Make sure to remove some filters or expand your search range.

• You cannot use:

  • Date

  • and Financial Year
    together at the same time.

Fourth: Exporting Customer and Vendor Receipts

Export Method

• From the Customer Receipts or Vendor Receipts page

• Click the Export option at the top of the page

Export Notes

• Export depends on the current filtering.

• Only visible receipts in the list will be exported.

File Type

• The exported file is in CSV format

Data That Appears in the Export File:

• Reference Number

• Description

• Entity

• Date

• Type

• Account

• Amount

• Unallocated Amount

Fifth: Current Filtering Limitations

Filtering by Location (Branch)

• Currently, you cannot filter receipts directly by location (branch) from the receipts page.

Filtering by Project

• There is no direct filter by project name within the receipts page.

Sixth: Available Alternative Solutions

Filtering by Project (Alternative Solution)

You can use:

• Reports

• Then Customer Statement Report

• Select the customer name

• All documents related to the customer and their projects will appear

• You can:

  • Export the report to Excel

  • Then filter by document type or project

Filtering by Location (Alternative Solution)

You can use:

• Account Statement Report

• Select the collection account (such as cash or bank account) or select the main cash or bank account that includes all collection accounts.

• Choose the filter type:

  • Branches and Warehouses

• Select the desired location

• Search then export to Excel

• After exporting:

  • Filter by document type (Receipt / Payment)