In order to view the AccountEdge Cash Flow Analysis report in Excel, you must first display the Cash Flow Worksheet. If you choose the Cash Flow Analysis report in the Index to Reports window, then click Send To > Excel. A message will appear to alert you about this requirement. Click OK and the Cash Flow Worksheet window will be displayed for you automatically.

Select an account and enter a number in the Days to Look Ahead field. Click the Analyze Cash Needs button and the Cash Flow Worksheet will fill with data. Click the Excel button in the Cash Flow Worksheet window to view the Cash Flow Analysis report in Excel.

You must have extensive knowledge about Microsoft Word templates to use the information we’ve provided here. If you don’t feel comfortable with this information, make a point of getting assistance from someone who is more knowledgeable about templates, such as an MYOB Certified Consultant.

You can enter more than one item in the dialog box that appears when your word processing program is started. It’s important to note, however, that whatever entries you make in this box will be used for every letter you’ve selected. Using the example above, every customer you’ve selected will be told that their geometric wallpaper and floral wallpaper are on backorder.

If some customers have ordered another combination of backordered items, you’ll need to repeat this procedure for those customers. Following our example, you might create one set of letters for people who ordered geometric wallpaper, a second set of letters for those who ordered floral wallpaper, and a third set of letters for those who ordered both types of wallpaper.

If you modify the Excel templates for your AccountEdge reports, be sure that you do not move the [[Tbl:Body Table]] field. This field must be located in Column B, row 15, in order for each report’s total amounts to be calculated correctly. If you move [[Tbl:Body Table]], the totals will be inaccurate.

Also note that you cannot directly reference a specific piece of data within a report when creating additional calculations on your report data. This is because Excel will push the reference field you create to a field below the end of the report body when the report is imported into Excel. As an alternative, you can either create a macro that will be calculated after the report is imported or place your reference field on a separate spreadsheet that will be updated after the report is imported.

OfficeLink is compatible with Microsoft Office v. X (Microsoft Word X and Microsoft Excel X) and Microsoft Office 2004 (Microsoft Word 2004 and Microsoft Excel 2004).