Skip to main content

Notifications

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

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: voiding receivables transactions

    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

  • Ian Richardson Profile Picture
    Ian Richardson 4,150 on at
    RE: voiding receivables transactions

    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
    RE: voiding receivables transactions

    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
    RE: voiding receivables transactions

    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.

  • soma Profile Picture
    soma 24,410 on at
    RE: voiding receivables transactions

    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)

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,307 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans