Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

AR Trial Balance Issue

(0) ShareShare
ReportReport
Posted on by 46,278 Super User 2025 Season 1

Here's one that after 4 hours of analysis, I cannot figure out.  Client is reconciling October 2010 AR (go figure) on GP 7.5.  Run the Historical ARTB at 9/30/10 for ONE customer results in $X.  Run the same report, filtering for only October transactions @ 10/31/10 returns $154k in transactions.  One would expect the 10/31/10 Historical ARTB for that customer to equal $X+$154k=$Y.  However, the result showing on the report @ 10/31/10 = $X+$444k.

I have analyzed the transactions every way I can think of, using Smartlists, exporting the ARTB at the end of both periods to Excel and further analyzing, running the ARTB with every combination of options, exclusions turned on and off, running based on both GL Posting Date and Document Date, etc.  I've run Checklinks on the AR tables, the Reconcile utility with every option possible, and even checked the same periods using a different customer, which tied out perfectly.  That tells me it has something to do with that Customer and the only thing I can think of is perhaps a write-off or an FX variance that doesn't appear on the ARTB.  However, that's unlikely given the size of the difference ($290k).

Anyone have any ideas where I should look next?

Thanks in advance!

*This post is locked for comments

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,278 Super User 2025 Season 1 on at
    Re: AR Trial Balance Issue

    I'll have a look at that Ian.  And yes, we'll see you next week.  Look forward to meeting you!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: AR Trial Balance Issue

    Hey Frank.

    Could it be an apply record? What if you unapplied payments if they are still in Open...and then printed the TB?

    (See you next week?).

    Ian.

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…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,994 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans