Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. AR invoices print blank when you enter any selection criteria

AR invoices print blank when you enter any selection criteria

View products that this article applies to.

Symptoms

AR invoices print blank when you enter any selection criteria.

↑ Back to the top

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.

↑ Back to the top

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]

↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2791649
Revision : 2
Created on : 2/3/2017
Published on : 2/3/2017
Exists online : False
Views : 311