AR invoices print blank when you enter any selection criteria

  • Article

This article provides a solution to an issue that Accounts Receivable (AR) invoices print blank when you enter any selection criteria.

Applies to:   Microsoft Dynamics SL 2011
Original KB number:   2791649

Symptoms

AR invoices print blank when you enter any selection criteria.

Cause

A preprocess on the AR invoice screen populates the arprintqueue table by using the 07 user. When that user has no rights to the vs_company view, the arprintqueue table isn't populated. In the report, there's a link between the vs_company and the arprintqueue tables. Because the arprintqueue table isn't populated, there's no match. The report finds no data and prints blank.

Resolution

  • Resolution 1:

    In Database maintenance > Update databases, select Synchronize All Security & ownership

  • Resolution 2:

    Run this statement in Management Studio against the application database.

    grant select on vs_company to [07718158D19D4f5f9D23B55DBF5DF1]