AR invoices print blank when you enter any selection criteria
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
AR invoices print blank when you enter any selection criteria.
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.
In Database maintenance > Update databases, select Synchronize All Security & ownership
Run this statement in Management Studio against the application database.
grant select on vs_company to [07718158D19D4f5f9D23B55DBF5DF1]