<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=371557583225568&amp;ev=PageView&amp;noscript=1">

BizNetSoftware Blog

BizInsight for Intacct - Enhancements and Best Practices

Posted by Art Simmons |
June 30, 2016

BizInsight for Intacct on V7 Platform - Enhancements and Best PracticesIntacct

Enhancements

1. Start Over Button

IntacctBlog1

2. Select Column Reorder

Drag-and-drop re-order columns feature in the Select Columns form allows users to insert tables with the columns appearing in the order of their choosing.

3. Check for Errors

The feature contains new UI changes

IntacctBlog2

IntacctBlog3

 

Best Practices

1. Using Selected Excel Data

The product requires that you have a unique name for your data. Utilize a unique Range name or Table Name across all workbooks in a single Excel session.

The product works best when you do not alter the Worksheet Name, Range Name, or Table Name used when selecting the data (Select Data option). However, if you decide to change the Worksheet Name, Range Name, or Table Name, the easiest way to make sure your data is updated successfully is to add the data again using the Select Data option on the ribbon.

If you decide to change the Worksheet Name, Range Name, or Table Name and do not re-add the data using the Select Data option, here are the exceptions to data synchronization:

  • Renaming a Table Name or Range Name will cause the Cell Address to be used in place of the original name. If the renamed Table Name or Range Name is resized on refresh, the data will not be available in BizInsight
  • Renaming a Worksheet Name and then setting focus to another Worksheet will allow BizInsight to locate the renamed Worksheet. However, if you fail to set focus to another Worksheet after renaming the Worksheet, updated data will not be available in BizInsight.

Re-naming a workbook will not cause data synchronization failures.

2. Use of Named Ranges or Cell Ranges vs. Tables

Selecting Excel tables for use (as opposed to a range of cells or a named range) is the best practice. With tables, deleting a row or column from a table that has been selected with the Select Data button will update the selection of data seen by the product. This feature is not supported with cell ranges and only partially supported with the use of named ranges (for example, adding rows or columns to the outer edge of a named range is not supported)

3. Working with Dates, Times, and DateTimes

When working with data that is either a Date, Time, or DateTime data type, it is important for users to format the cells containing that data accordingly. Cells containing data values should be formatted as Date, cells containging time values should be formatted as Time, and cells containing a date and a time should be formatted with a custom format that contains both date and time (i.e. "mm/dd/yyy hh:mm:ss AM/PM")

 

About BizNet Software
BizNet Software, Inc., is a market leader for Microsoft Excel in-memory, cloud-enabled reporting and business intelligence. Founded in 1996 to take the mystery out of databases, BizNet focuses on Microsoft Excel reporting solutions based upon a real-world understanding of corporate financial, operational and technical requirements. The BizNet Excel Suite creates a user-friendly, drag and drop environment with real time access to the world’s leading Enterprise Resource Planning (ERP) systems. BizNet Software is endorsed by more than 200 partners and 15 software publishers; and currently has 20,000+ users in more than 2,100 companies worldwide.

Microsoft® and Excel® are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. For more information, visit http://www.biznetsoftware.com or call .

 

Topics: Biz|Blog~, Excel, Excel reporting, Intacct, Intacct reporting, reporting, Reporting for Intacct

Subscribe to Email Updates

Recent Posts

Posts by Topic

see all