web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Is the RM HATB wrong?
Microsoft Dynamics GP (Archived)

Is the RM HATB wrong?

(0) ShareShare
ReportReport
Posted on by Community Member

Hello:

In GP 2013 R2, I'm generating the Receivables Management Historical Aged Trial Balance (RM HATB) for one customer and as of 09/30/2015.

This customer has a sales return of $56.76 that was posted on 07/31/2015.  The sales document that this return was applied to was posted on 07/01/2015.

But, the apply date was 11/15/2015.  This date is, of course, after the 09/30/2015 date for which I ran the report.

Yet, the report subtracted this return's $56.76 from the balance of this customer. 

To me, that isn't correct.  If the report is run as of September, but the return was not applied until November, than this $56.76 should actually be "added back" to the balance of open accounts receivable.

I have seen other similar instances in this report, for other customers' balances.  And, I tested the unchecking and checking of the selections in the report options window, among other things.

Too, I ran GP's Receivables Reconcile utility against this customer.  Even after doing so and running the report again, this same incorrect result appeared.

Is this report simply inaccurate?

Thanks!

John

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Hi John,

    Wouldn't it be proper for the customer's overall balance to be reduced by the $56.76, but the document to which the 56.76 was later applied would still show as individually outstanding. The amount was received and posted, thereby reducing the overall balance, but the specific credit wasn't applied until later.

    Am I interpreting this correctly?

    Leslie

  • Community Member Profile Picture
    Community Member on at

    Hi There, Leslie:

    Yes, your interpretation of my question and "curiosity" on this topic is correct.

    It's just that, to me, the overall A/R balance (i.e. open A/R balance) of the customer should be $56.76 greater at 09/30/2015 than at, say, 11/15/2015.

    That's why I don't understand why the open A/R balance is $56.76 lesser, when I run the RM HATB at 09/30/2015.  If I had run the report as of 11/15/2015, I could understand.

    Oh, and I'm running this report in Summary rather than in Detail.  I should have been more clear, on that important point.  My apologies.

    John

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Hi John,

    The original document was posted on 9/01/2015. At that point the customer owed you money so the HATB would have increased by however much the original invoice was for. The $56 credit was posted with a document date of 7/31/2015. At the time of that posting, the customer's balance decreased. The fact that the credit wasn't applied until 11/15/2015 does not change the HATB. The $56 credit should reduce the customer's balance as soon as it is posted. I would expect your HATB as of 9/30/2015 to include the unapplied credit. Also, I would expect to see the $56 credit listed as unapplied on the HATB at 9/30/2015. The only thing that happened on 11/15 is that this already existing credit was applied to an invoice. This apply did not change the overall balance of accounts receivable.

    To me, it looks like the report is working perfectly.

    Kind regards,

    Leslie

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans