Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. In the Navigation panel, go to Reports then Reports>Form Reports.
  2. In the list of reports find the category Cards and then select Customer Trial Balance (summary) or search for the report in the name field
  3. Highlight the report F-017 Customer Trial Balance (summary)
  4. Select a parameter some options may be as per imageIn the detail area select and highlight one of the parameter names with the view.  There is a 'date range without criteria parameter'  that can be added if it is not already there or you can just use the 'customer trial balance parameter '.
  5. Click on the 'Show report using parameters' action button 


    Click on Show Report Using Parameters, screen as per below will appear
    Expand
    titleShow me

    Image Removed

  6. Select the parameter 
  7. Customer Trial Balance Summary

    Image Added


  8. The window 'customer trial balance parameters' will open depending on which parameter you chose


  9. Expand
    titleShow me

    Image Removed

  10. Enter the date required.
  11. Image Added


  12. Enter the last day of the month in question, eg if you are running the trial balance for April 2020 then insert the last day of April.
    If you select the parameter name of 'date range without criteria parameters, you would enter the start date and year and the end date and year eg 01/07/2022 to 30/06/2023 and no start and end customer required.
  13. If you select the 'customer trial balance parameter' with respect to the Start Customer and End Customer fields
    1. If you require all customers to leave both fields blank
    2. If you require 1 customer key in the same card id into in both fields
    3. If you require a specific range of customers based on card id enter start customer and end customer for that range. 
  14. Click OK and the report runs
  15. Result appears as above imageThe result appears on to screen.

Use Case

Its the end of the month and your accounts staff want to check the accounts that are overdue by 60 days or more, run the above report for these results and highlight the ones you want chased up.