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. RM Statement balance incorrect when 'Summarize To' Date is used in Receivables Management for Microsoft Dynamics GP

RM Statement balance incorrect when 'Summarize To' Date is used in Receivables Management for Microsoft Dynamics GP

Symptoms

When printing a Receivables Statement, the A/R statement balance is incorrect when a 'Summarize To' Date is used. 

(To print a Receivables Statement click on Microsoft Dynamics GP, click on Tools, point to Routines, point to Sales and click on Statements.) 

↑ Back to the top

Cause

The 'date' used for the Summarize To date may cause varied results. The Summarize To Date needs to be greater than the last document date that is in OPEN status, and has an applied record in HIST status. If the Summarize To Date is less than this document date, then it will not pick up the applied record in history and the ending statement balance will be incorrect.

↑ Back to the top

Resolution

Enter a 'Summarize To' Date that is greater than the last document date that has an applied record in history.

As a recommendation, we can say to use a date greater than the last 'Paid Transaction Removal' date that was used, and you would be pretty safe with this date. Never use a Summarize To date less than the last Paid Transactin Removal Date that was used.

↑ Back to the top

More Information

For example, consider these documents applied to each other for this customer:

HIST 1/16/2010 CRM ($100.00) 
OPEN 3/15/2010  INV $300.00 
---------------------------------
Net Balance $200.00


Result #1 - If you use a Summarize To date between 1/16/2010 and 3/14/2010, the ending balance of the statement will incorrectly show $300 because the applied record in history will not be picked up.

Result #2 - If you use a Summarize To date of 3/15/2010 or greater, then the ending balance will correctly show $200. 


↑ Back to the top

Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2141603
Revision : 1
Created on : 1/7/2017
Published on : 8/4/2011
Exists online : False
Views : 96