Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / AR Reconcile
Microsoft Dynamics GP (Archived)

AR Reconcile

(0) ShareShare
ReportReport
Posted on by V 75

Hi,

I am on GP9 and am trying to reconcile my AR to the GL, using the HATB report, however I have a large difference which I believe is due to the apply date on many of the transactions as cash may have been received in Jan 09 but not applied until Feb 09 and there will have been a FX gains and loss against that cash receipt.

Can you please tell me if this there is a SQL script that would help me highlight this.

I can confirm that the difference is not due to mispostings, or batches not posted into the GL.

 Thanks

Regards

V

*This post is locked for comments

  • Ron Draganowski Profile Picture
    Ron Draganowski 1,575 on at
    Re: AR Reconcile

    Oh, I should have mentioned that there is a third party product that helps with this from Software Index out of the UK. 

    http://www.swareindex.com/

     

    Ron Draganowski
    Solution Services Practice Manager
    Olsen Thielen Technologies, Inc.
    St Paul, Minnesota
    rdrag@ottechnologies.com
    http://www.ottechnologies.com



         Find me on LinkedIn: http://www.linkedin.com/in/rondraganowski 

     

  • Ron Draganowski Profile Picture
    Ron Draganowski 1,575 on at
    Re: AR Reconcile

    I have been doing GP and SQL for 10 years now, and I have not yet come across a script like you're suggesting that is just published for use.  However, creating your own query is possible by looking at the TRX Source on the GL20000 table.  Note that certain trx sources line up to certain RM Trx Type All values in RM20101. 

     But if someone has a script already typed up, send it this way!

    Ron Draganowski
    Solution Services Practice Manager
    Olsen Thielen Technologies, Inc.
    St Paul, Minnesota
    rdrag@ottechnologies.com
    http://www.ottechnologies.com

     Find me on LinkedIn: http://www.linkedin.com/in/rondraganowski 

     

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans