OfficeLink notes and warnings

If you want to view the Cash Flow Analysis Report in Excel

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.

Note: If you want to view the Cash Flow Analysis Report in Excel

Important note about changing templates!

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.

Note: You must have experience with Word templates to change OfficeLink templates!

Your box entries will be used on all letters you select

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.

Note: The items you enter in the word processing dialog box will be used on all the letters you’ve selected.

Use caution when modifying AccountEdge Excel templates!

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.

Please refer to your Excel documentation for specific help.

These products are compatible with OfficeLink

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).