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 is not populated. In the report there is a link between the vs_company and the arprintqueue tables.  Because the arprintqueue table is not populated, there is 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]

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×