Solution Properties
Solution ID:
200427112241920
Last Modified Date:
Wed Aug 09 10:35:52 UTC 2023
Taxonomy Path:
Case category//How do I...//setup/create/run a report
Author:
[email protected]
How to sort supplier statements in date order
Description

Supplier statements show transactions in transaction number order. You can edit your report to sort the transactions in date order.

The steps to amend your statement are different when it's an individual or a grouped statement.

Cause
Resolution

Individual statement layouts

  1. Select the document you want to amend, then click Edit.
  2. On the menu bar click Report, then click Report Properties.
  3. Enter a new report name and description, then click OK.
  4. On the menu bar click Report then click Sorts then click Add.
  5. Complete the Sort window as follows:
    Table Choose AUDIT_SPLIT.
    Variable Choose DATE.
    Sort the data in Choose Ascending or Descending as required.
  6. Click OK then click OK.
  7. On the menu bar click File, then click Save As.
  8. Enter a new file name, then click Save.
  9. On the menu bar click File, then click Exit.

Grouped statement layouts

  1. Select the document you want to amend, then click Edit.
  2. On the menu bar click Report, then click Report Properties.
  3. Enter a new report name and description, then click OK.
  4. On the menu bar click Sections then click Add Section then click Group Header And Footer.
  5. On the Fields pane, double-click AUDIT_SPLIT and then double-click DATE and click OK.
  6. Select the AUDIT_SPLIT.DATE Header section, then click View, and click Properties.
  7. In the Properties pane, in Suppress Printing choose True and in Visible choose False.
  8. Select the AUDIT_SPLIT.DATE Footer section then click the Sections menu and click Move Section Down.
    TIP: You can also click the Move Group Down icon [˅] to the right of the section header bar on the design.
  9. Select the AUDIT_SPLIT.DATE Footer section then in the Properties pane choose True for Suppress Printing and False for Visible.
  10. On the menu bar click File, then click Save As.
  11. Enter a new file name then then click Save.
  12. On the menu bar click File, then click Exit.
[BCB:19:UK - Sales message :ECB]
Steps to duplicate
Related Solutions