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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / voiding receivables tr...
Microsoft Dynamics GP (Archived)

voiding receivables transactions

(0) ShareShare
ReportReport
Posted on by Ian Richardson 4,150

hi folks

we have voided payments in a/r that were entered incorrectly in prior periods.  We used a void date and posting date of December 31 2013.  The sales module was closed at the time.  The gl module was open.

Today we run the historical aged trial balance based on gl date and the voided transaction is still on the aging report.  Running based on the document date the transaction is not on the aging report.

This is backwards to my thinking.  We sent a JE in December.  Is it because the sales module was closed that the HATB still shows the transaction?

thanks!

*This post is locked for comments

I have the same question (0)
  • soma Profile Picture
    soma 24,410 on at

    what is the document date used to running the aging report?(Running based on the document date the transaction is not on the aging report)

  • Ian Richardson Profile Picture
    Ian Richardson 4,150 on at

    hi Soma

    we are running for dec 31 2013.  Using doc date the voided payment is not on the report.  Using the gl date the voided payment is on the report.

    the void had both a void date and posting date of Dec 31 2013.

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

    Hi Ian,

    If you look at the RM20101 table, what are the values in the following fields:

    VOIDDATE

    VOIDSTTS

    DINVPDOF

    DOCDATE

    GLPOSTDT

    POSTDATE

    Kind regards,

    Leslie

  • Ian Richardson Profile Picture
    Ian Richardson 4,150 on at

    hi Leslie

    voiddate voidstts DINVPDOF DOCDATE GLPOSTDTPOSTDATECUSTNMBR

    1/1/2014 1 12/31/2013 12/13/2013 12/13/2013 12/18/2013 ROSF01        

    1/1/2014 1 12/31/2013 12/16/2013 12/16/2013 12/18/2013 FED002        

    1/1/2014 1 12/31/2013 12/16/2013 12/16/2013 12/18/2013 JIE001        

    1/1/2014 1 12/31/2013 12/19/2013 12/19/2013 12/19/2013 TAE001        

    1/1/2014 1 12/31/2013 12/19/2013 12/19/2013 12/19/2013 AND006        

    1/1/2014 1 12/31/2013 12/19/2013 12/19/2013 12/19/2013 FEH001        

    1/1/2014 1 12/31/2013 12/19/2013 12/19/2013 12/19/2013 LVL002        

    1/1/2014 1 12/31/2013 10/2/2013 10/2/2013 10/11/2013 POU001        

    1/1/2014 1 12/31/2013 10/9/2013 10/9/2013 10/11/2013 CBI002        

    1/1/2014 1 12/31/2013 10/9/2013 10/9/2013 10/11/2013 CBI002        

    1/1/2014 1 12/31/2013 10/4/2013 10/4/2013 10/11/2013 DIG001        

    1/1/2014 1 12/31/2013 10/1/2013 10/1/2013 10/7/2013 PHM001        

    I think its the void date of Jan 1 that is driving the JE, despite the posting date being in prior periods hence the HATB by GL still showing the transactions.

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

    Hi,

    The sales module being closed _shouldn't_ make any difference. I tried to recreate the situation in Fabrikam, but could not.  Having the void date of 1/1/2014 is mighty suspicious - again, it _shouldn't_ matter. I haven't tried changing my system date and trying it - I only changed the user date.  This is interesting, I've not heard of it before.  I'll try to build it again using your dates AND changing my system date. A little too late tonight, but I hope to try it tomorrow.

    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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans