Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Microsoft Dynamics GP AR History Trail balance

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello Friends,

Items being included in the AR History Trail balance that have been previous paid. For customer ABC and XYZ. An example is invoice #999999 for ABC showing open in History sales Trail Balance but was paid in 2010. Not included in current balance totals.

Please help...

Thanks you in advance,

Jay

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Microsoft Dynamics GP AR History Trail balance

    Hello Richard,

    Can you please provide me steps to run checklinks on the AR tables first and then run Check Links.

    Also, d o I need to take backup for databases or backup in GP for reports? Please provide me those steps also.

    Many Thanks!!

    Jay

  • Verified answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: Microsoft Dynamics GP AR History Trail balance

    If this happened following a WS Crash, run checklinks on the AR tables first and then run Check Links.

    Do Backups first.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Microsoft Dynamics GP AR History Trail balance

    Hello Frank,

    I do not see any reports in Customization Maintenance window to export.

    Step 1: Export resources from the current Reports.dic file

      1) Follow the appropriate method:

          -- In Microsoft Dynamics GP 10.0, click Microsoft Dynamics GP, click Tools, click Customize, and then click Customization Maintenance.

          -- In Microsoft Dynamics GP 9.0 and earlier versions, click Tools, click Customize, and then click Customization Maintenance.

       2) Select the forms or the reports that you want to export from the current dictionary files. Use the SHIFT key or the CTRL key to select more than one resource.

       3) Click Export.

      4) In the Please select a package file dialog box, select the location where you want to save the file, name the package file, and then click Save.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,317 Super User 2025 Season 1 on at
    RE: Microsoft Dynamics GP AR History Trail balance

    Okay, you may have a corrupt reports dictionary on that machine then.  It wouldn't hurt to follow the instructions in this KB article - support.microsoft.com/.../en-us.

    That might resolve it.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Microsoft Dynamics GP AR History Trail balance

    Yes, this is just started this week for only customers ABC and XYZ. One of the user PC crash last to last week and I believe this is happening because of that crash only for that two customers.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,317 Super User 2025 Season 1 on at
    RE: Microsoft Dynamics GP AR History Trail balance

    Jay, did this just start occurring?  Is it with certain customers or all customers?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Microsoft Dynamics GP AR History Trail balance

    Thanks Richard for your help..

    But my concern is AR History Trail balance that have been previous paid in 2010 should not being  included when I run report for last week date right?

    what are the steps to remove old history from utility? If I remove old history from utility means the data is permanently gone? In back end sql what table I can look to find old data?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Microsoft Dynamics GP AR History Trail balance

    Yes, Report Options settings have 'Exclude Fully Paid Documents' checked.

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: Microsoft Dynamics GP AR History Trail balance

    I am sorry, you did say HISTORY trial balance.....this is correct.  The history TB shows all invoices and payments etc applied.

    To remove old history, there is a utility to remove history.  Make sure you will never need this again or you have it moved to a DataWarehouse

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Microsoft Dynamics GP AR History Trail balance

    Yes, I marked both in the Report Option window.

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,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans