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. Microsoft Management Report does not display budget amounts for budgets that use a date range

Microsoft Management Report does not display budget amounts for budgets that use a date range

Symptoms

When you generate a report in Microsoft Management Reporter, no data is returned for budget columns.  This happens if the budget is set up in Microsoft Dynamics GP with a date range. 

↑ Back to the top

Cause

The GL00201 table in the company database is populated with a 0 instead of the actual year.

↑ Back to the top

Resolution

1.  Backup your Dynamics and Company Database.

2.  Run the following statement against your company database.

update GL00201 set YEAR1 = (select YEAR (perioddt))

↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, vkball, kb

↑ Back to the top

Article Info
Article ID : 2655682
Revision : 1
Created on : 1/8/2017
Published on : 12/16/2011
Exists online : False
Views : 81