June 2019

menutop.png


In This Newsletter


AVAware Video Production: The First Six Months

AVAproject Fusion: Intuit QuickBooks Plugin

AVAware Hardware Catalogs

AVAproject Tip: Row Sequence Numbers






Watch AVAproject Tip Video!


Catalog Updates


 U.S. Price Books:

  • Yale
  • Ceco
  • Corbin-Russwin
  • Curries
  • Falcon
  • Markar
  • McKinney
  • Norton
  • Pemko
  • Rixson
  • Rockwood
  • Sargent
  • Schlage Residential
  • Yale



 Canadian Price Books:

  • Canaropa
  • Corbin-Russwin
  • Markar
  • McKinney
  • Norton
  • Pemko
  • Rixson
  • Rockwood
  • Sargent



AVAware Video Production:
The First Six Months

Six months after launching a new video production initative, AVAware instructional videos are receiving raves from AVAproject users!


In January of this year AVAware announced the formation of a new in-house production team, with the intention of producing instruction videos for our various software products. The ultimate goal is to offer a library of demonstration, training and advanced concept videos for current users as well as those interested in AVAware products.

Over the past six months, the production team has released six new videos; one each month accompany the AVAware newsletter. The focus this far has been on "AVAproject Tips", demonstrating unique and often obscure features of the AVAproject software to current users. Presented in the form of 3-5 minute videos, these early releases have allowed the production team to develop their distinctive look and experiment with the use of visuals such as 3D modelling to illustrate software concepts.





One of the primary productions objectives is to avoid the "typical" software demonstration video – the screen capture with the "off-the-cuff" voice over. Every effort has been made to create content that is as visually compelling as it is informative.



"Copying Spreadsheets with the AVAproject Clipboard"  features
animated 3D "clipboards" to illustrate advanced copy/paste functions.


"Hardware Locations" uses 3D door and frame models to
illustrate how hardware locations are translated to 'machining sheets'.



In addition to the ongoing development short "tip" and "feature focus" videos, AVAware's production team has begun work on much longer demonstration and training videos for AVAproject, AVAcad and AVAproject Fusion. The intention is to supplement traditional product training with videos that can be shared amongst users and reviewed when needed.

 

 

Visit AVAware's YouTube Channel

 

The first six AVAproject Tips are now available on the AVAware YouTube channel (accessible via the link below). AVAproject users are strongly encouraged to visit and view the videos for themselves. New content is posted monthly; subscribing to the channel will ensure that users are notified as new videos become available.

"Subscribe"
 YouTube Channel



AVAproject Fusion:
Intuit QuickBooks Plugin




The AVAproject Fusion QuickBooks plugin allows products to be sourced, organized, and pushed directly into Intuit QuickBooks as purchase and sales order documents.


Built upon a powerful data extraction engine, AVAproject Fusion allows users of AVAproject to harvest project data to build highly customized reports and pivot tables – as well as move data directly into many accounting/ERP platforms. Through the use of specialized "plugins", AVAproject Fusion is able to integrate directly with virtually any API enabled accounting software.

One of the most popular accounting solutions, for small to mid-sized distributors, is Intuit's QuickBooks. QuickBooks is a cost-effective and easily maintained package that offers many of the advanced accounting features found in much more expensive products.

» Click here to read full article...



AVAware Hardware Catalogs




AVAproject users have always known that the Hardware catalogs that drive it provide extraordinary functionality and offer some truly unique capabilities.

Architectural hardware catalogs and the data they provide are at the heart of the estimating and detailing process, and an invaluable benefit to AVAproject users. AVAware maintains an in-house team of experts that manually curate content from manufacturers' printed price books and adapt it for use with AVAproject. While other providers may offer databases of manufacturer's products, AVAware has taken catalog technology to an entirely different level. All catalogs are definitely not created the same.

The ever-growing AVAware catalog library contains product and pricing information from dozens of leading industry manufacturers. The difficulty in creating a single database standard arises from the fact that the price books themselves and the "rules" used to determine costs are as diverse as the products themselves. As such, AVAware created a catalog architecture that more closely resembles a platform than a typical database structure.

When catalogs are created, the AVAware team always strives to match the information in the printed price books exactly. This information includes product nomenclature and pricing in addition to option codes, build options and specific pricing rules. Product codes are arranged based upon the series designations used in the printed price book, and can be searched or browsed with ease.



» Click here to read full article...



 

AVAproject Tip: Row Sequence Numbers

The ability to re-sort the AVAproject Openings Schedule is extremely convenient, and offers a variety of options in terms of presentation and editing. Estimators will often want to manipulate the sequence of the data in the schedule in order to group openings by various pertinent details, such as opening type, handing, label, etc. This is a great way to see and share information with colleagues and clients, however it does change the original order in which openings were scheduled.

Row Sequence Numbers were built for the purpose of preserving a specific order in which data is to be presented. As data is entered into the Openings Schedule, "Sequence Numbers" are automatically assigned to each row as it's added.


There are two methods offered by AVAproject to view them. The first, and most popular method is to add the specific "Sequence Numbers" column (offered in the "Information" group). This is a "read only" column that contains the Sequence Numbers assigned to each row of the schedule.

The second method is to select "Tools" in the menu bar and open the AVAproject Preferences dialog. Within the "Openings" tab, an option labelled "Use automatic Sequence Numbers to preserve the order in which rows are entered" is shown.



When selected, the Row Sequence Numbers will replace the traditional row numbers displayed at the beginning of each row of the Openings Schedule, and are identified by a decimal following each.





» Click here to read full article...




AVAproject Tips now feature accompanying overview and demonstration videos courtesy of the AVAware production team.

Click below to view the video for this month's Tip!








Visit The AVAware YouTube Channel and Connect on Social Media

 

In addition to the embedded links found on the AVAware website and with our newsletters, all our videos can be directly accessed through our YouTube channel. Our subscribers will have the opportunity to preview videos prior to their official release. Please don't forget to subscribe in order to be automatically notified as new content becomes available.

While you're at it, don't forget to connect, follow & like AVAware on all your favorite social media platforms to receive immediate notifications of newly published content and releases.

"Connect" with us
 linkedin.com/company/AVAware

"Follow" us
 @AVAware

"Like" us
 facebook.com/AVAwareTech

"Subscribe"
 YouTube Channel


We welcome any questions, comments or suggestions about any topic mentioned in this edition of AVAwire. Please visit our website for more information, or contact us directly at (416) 239-9099.