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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Sales Historical Aged ...
Finance | Project Operations, Human Resources, ...
Suggested answer

Sales Historical Aged Trial Balance Multicurrency Balance Issue - $0.01 CAD balance/$0.00 USD balance

(0) ShareShare
ReportReport
Posted on by aclayf 15

We've been having issues when running our sales historical aged trial balance for our AR reports where documents in USD that have been fully paid & applied are showing up with a CAD reporting subtotal, usually just $0.01 but some are a few more cents. Some are from clients that are long gone but are still showing up on our AR with $0.00 USD under originating subtotal and $0.01 CAD under reporting subtotal, causing a balance of $0.01 for fully paid invoices. We can't enter a credit note in CAD because it doesn't show up with anything to apply it to, nor in USD. They make an absolute mess of our AR so it would be great if there was some way to get rid of them. This is what it looks like for reference:

pastedimage1613051232877v1.png

Anyone have any idea how to get rid of these $0.01 balances? We have GP 2015 and it has been happening for years, not only on past clients' payments but current ones as well. 

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: Sales Historical Aged Trial Balance Multicurrency Balance Issue - $0.01 CAD balance/$0.00 USD balance

    Hello,

    We do have a Quality issue for this under these specific conditions that has only ever had 1 customer open a support case on.  If this sounds like your scenario, then at this time we do not have a fix, but I will add you to the customer count on the issue as we will prioritize our fixes based on the number of customers effected.  (number of cases opened on the issue)

    HATB ‘Balance’ and ‘Current bucket’ payment (cash receipt) functional amount off by amount of rounding difference when the following is true:

    1. Printed ‘as of’ a date prior to when the rounding difference was posted.

    2. AND the rounding difference was posted on a date AFTER the cash receipt is posted in RM.

    The HATB will be inaccurate for all dates between the cash receipt posting date and the rounding difference posting date in RM (usually the apply date).

    If this is not your scenario, then you may want to open a support case so we can review the data on one of these transactions to verify if there are issues with the data.  

    For your reference the quality issue above is number 77620.  

    Thanks,

    Isaac Olson

    Microsoft Support

  • aclayf Profile Picture
    aclayf 15 on at
    RE: Sales Historical Aged Trial Balance Multicurrency Balance Issue - $0.01 CAD balance/$0.00 USD balance

    The cash receipt posting dates are the same as the apply dates. I'm not sure when the rounding difference posting dates are, but I would assume they are the same dates as well if they are the apply dates.

    The print/age as of dates are current and not prior to the rounding difference being posted, for example the print as of date for this one is Feb 11, 2021 but this difference has been on our report since 2015:

    pastedimage1613155835417v1.png

  • Suggested answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: Sales Historical Aged Trial Balance Multicurrency Balance Issue - $0.01 CAD balance/$0.00 USD balance

    Thank you for the additional information.  I am thinking that this is a different issue.  I have seen issues like this when transactions are imported with more decimal places than GP has set up for that currency which causes rounding issues.    I would check the RM20101 on the following values.  The CURTRXAM should be 0 if its fully applied. and the other fields should be equal to the amount of the document.  If they are not you may have to try updating them in a Test company with a copy of live.

    "How to set up a test company that has a copy of live company data ":

     support.microsoft.com/.../871973

    select CURTRXAM ,ORTRXAMT,SLSAMNT,DSCDLRAM, * from RM20101 where CUSTNMBR = 'XXXXX' and DOCNUMBR = 'YYYYY'

    If you ran Paid Transaction Removal (PTR) then you would just replace the RM20101 with the RM30201 table.  

    If you need assistance reviewing the data or are still stuck please open a support case and we can assist you with clearing up the issue.

    Thanks!

    Isaac Olson

    Microsoft Support

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,122

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 918 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 646 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans