VISUAL Did You Know?

If you have any questions about Infor VISUAL, contact us at 800.804.4715. We would be happy to help you!

Do you have VISUAL and want monthly tips and news? Subscribe to the BizTech VISUAL eNewsletter.

Are you looking for an ERP software? Subscribe to our monthly eNewsletter about ERP selection & implementation. Subscribe to the BizTech intERPreter.

Join the VISUAL Manufacturing Group on LinkedIn!

Search This Blog

Friday, January 10, 2014

Did you know that you can execute conditional printing in the GL financial report writer?

Report Writer has a default Print Code of 0 on all the lines.  For lines you want to suppress change the Print Code to 1.  This can be done by highlighting the line and click on Edit Row.  Change the value to zero.

Open the QRP.  The account values are shown on the 1st line that states Line Description.  The totals are shown in the 2nd line that shows Line Description.  Click on the line you want to suppress.  Find a blank spot (not a field) so the entire line is highlighted. 

Click on Right Mouse Button, Select Properties. The Properties box will appear.

Conditional Display – controls printing.  If a line has a value of zero it will not display.  
Click on the formula … button.

In the formula box add the following   * (LINE_PRINT_CODE – 1).  You can select LINE_PRINT_CODE from the list or type it. 

Once complete, click OK to close the Formula Box then OK to close the Properties box.

You may want to repeat on other lines such as single underlines or double underlines.

This VISUAL Did You Know Tip was brought to you by BizTech VISUAL Consultant, Kim Worrall.  

Friday, January 3, 2014

Print VISUAL Vendor Payment Information
Directly on 1099-MISC Forms!

VizReports 1099 Edition for 2013

Here is what’s new in the VizReports 1099 Application for the Tax Year 2013.

  • Updated default dates for tax year 2013.
  • Revised User Interface.
  • Support for VISUAL 7.1.x Multi-Entity/Multi-Site Databases.
  • Verification that the forms print correctly on the 2013 Form 1099-MISC and Form 1096.
  • Support for Access 2010 and Access 2013 or the Access 2007/2010 Runtime.
  • Verified Support for all VISUAL Versions 6.4.1 through 7.1.2.
  • Reporting Solution for all versions of SQLBase, SQL Server, and Oracle.

VizReports™ 1099 Edition is a reporting tool for Infor VISUAL™ designed to prepare and print Federal 1099-MISC tax forms by pulling vendor payment information from the VISUAL database.

For more info, screenshots, demo & how to purchase, go to