We can find this by querying on all transactions with a generated receipt number in eTapestry, and then running a report that sorts the transactions starting with the largest number first, followed by the rest in descending order. You can then find the largest number generated by looking at the top transaction listed in the report.

A. First we query on any transaction with a receipt number assigned:
  1. Click Queries in the menu
  2. Click Manage Queries
  3. Click on a category to store the query under (ex: Base)
  4. Click New Query under Tasks
  5. Give the query a name “All transactions with assigned receipt number”
  6. Set the Starting Query to Base>All Constituents
  7. Set the Data Return Type to Journal Entries
  8. Select Journal in the Browse Fields section and click on Transaction Generated Receipt Range
  9. Check off ‘Field has any value’
  10. Click Save And Run Report

B. Now for the report:
  1. Click Report in the menu
  2. Click Manage Reports
  3. Click on a category to store the report under (Ex: System)
  4. Click New Report under Tasks
  5. Give the report a name
  6. In the Browse Fields section select Commonly Used Fields and click on Account Name, Date and Received
  7. In the Browse Fields section select Journal Fields and click on Generated Receipt Number
  8. Click on the expand icon next to the Generated Receipt Number field and click on the Z icon next to Sort Order
  9. Click Save And Run
  10. Select your query at the top of the page to “All transactions with assigned receipt number”, the query we created in Step A
  11. Set your Report Format to Display Results on Screen
  12. Click Submit