Using the Order Action Macro to Create an Order Action Report in Microsoft Excel

Order Entry is shipped with a sample Visual Basic macro that you can use to produce a dynamic Order Action report in Microsoft Excel.

To run the Order Action macro:

1. On the Sage 300 Desktop, click Macro > Run.

   The Run Macro screen appears.

2. From the Files Of Type list, select VBA Macro Files.

3. Select OEORDACT.AVB from the list of macros.
4. Use the Report Type tab to define options for the report.

5. Use the Selection Criteria tab to define the order by which you want to view data. Each option you choose appears as a column heading in the Excel spreadsheet.

6. Click OK to start the Order Action macro.