Steps to generate Aged Analysis reports

From FloristWiki

(Difference between revisions)
Jump to: navigation, search
Line 6: Line 6:
#In the '''Customer Type''' section, select which customers’ information that you want to view, '''Balance Forward''', '''Open Item''', or both.
#In the '''Customer Type''' section, select which customers’ information that you want to view, '''Balance Forward''', '''Open Item''', or both.
#In the '''Report Type''' section, select the type of report that you want to print.
#In the '''Report Type''' section, select the type of report that you want to print.
-
#In the '''Past Due''' section, select the past due accounts that you want to view. You can choose
+
#In the '''Past Due''' section, select the past due accounts that you want to view. You can choose accounts that are current (up-to-date) or accounts that are 30, 60, 90, and/or 120+ past due.
-
accounts that are current (up-to-date) or accounts that are 30, 60, 90, and/or 120+ past due.
+
#In the '''Print Order''' section, select how you want to sort the printing order of the data records. You can sort the records by Customer ID, Sale Date, or Sort Name (customer name).
#In the '''Print Order''' section, select how you want to sort the printing order of the data records. You can sort the records by Customer ID, Sale Date, or Sort Name (customer name).
#In the '''Balance Forward Date''' field, click the arrow and select the balance forward date of the customers that you want to print.
#In the '''Balance Forward Date''' field, click the arrow and select the balance forward date of the customers that you want to print.

Revision as of 12:17, 17 April 2008

  1. On the FTD Mercury Main Menu, click Business Reports.
  2. Double-click Mercury Forms.
  3. Double-click on the Aged Analysis Report icon to open the template.
  4. If a window opens asking whether you wish to enable or disable macros, click Enable Macros.
  5. In the Store of Origin field, click the arrow and select the store’s data that you want to use for the report.
  6. In the Customer Type section, select which customers’ information that you want to view, Balance Forward, Open Item, or both.
  7. In the Report Type section, select the type of report that you want to print.
  8. In the Past Due section, select the past due accounts that you want to view. You can choose accounts that are current (up-to-date) or accounts that are 30, 60, 90, and/or 120+ past due.
  9. In the Print Order section, select how you want to sort the printing order of the data records. You can sort the records by Customer ID, Sale Date, or Sort Name (customer name).
  10. In the Balance Forward Date field, click the arrow and select the balance forward date of the customers that you want to print.
  11. In the Account Balance as of field, click the arrow and select the date for calculating aging. Setting the Account Balance as of date later than the current date allows you to include future transactions in the Aged Analysis report.
  12. Select Include Wire Service Accounts only if you want to include wire service accounts (FTD, TEL, etc.) in the report.
  13. Click Finish. The report generates and opens in Excel.
  14. To print your report from Excel, on the File menu, click Print.
  15. Click Finish. The report generates and opens in Excel.

Back to Business Reports

Personal tools