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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Customer account statement in D365 not showing Balance column

(4) ShareShare
ReportReport
Posted on by 73
Our users are trying to run Customer account statement for specific customer by the following path:
Sales Ledger module > Customers > All Customers.
 
Filter on and a select a customer, then under Customer Balances, select Statement.
 
When the statement is run, it runs as normal but there is no balances column.  It looks like its been chopped off.  I can't show a copy of the screen for data protection reasons.
 
However, if I run the same report by going to Sales Ledger > Periodic tasks > Customer account statement, the balance column shows - although there is no data and we need to run it for individual customers.
 
We are on version 10.0.42 of finance and operations and update 66.
 
Any advice or known issues?
 
Kind regards 
Rebecca 
Categories:
I have the same question (0)
  • Hylke Britstra Profile Picture
    93 on at
    Hi Rebecca,
     
    I use version 10.0.42 (10.0.2095.59). If I run the statement from the customer or from the periodic tasks, I get the same outcome (and I think it is linked to the same report).
     
    If you run the Periodic task you can also run it for a single customer by using the filter. It can even be that the customer number of the last used customer from the Customer statement directly from the customer master data is automatically already entered when opening the periodic task for the Customer Account Statement:
     
     
    What happens if you change this filter and run the periodic task Customer account statement for the customer where you miss the balance column when running the same report directly from the customer card? 
     
    Kind regards,
     
    Hylke
  • Chocolate_Pizza Profile Picture
    73 on at
    Hi Hylke 
     
    Thanks for your help.  I've just gone through that with the user but unfortunately it is also chopping off the balance column even if we do it through periodic tasks.
     
    Any other thoughts?  
     
    Kind regards
    Rebecca
  • Chocolate_Pizza Profile Picture
    73 on at
    There is something really odd happening here.  I asked the user to turn on "Balance other than zero" and one of the customer reports printed with the balance column.  However, the other customer, who definitely owe us some money, still did not print out with a balance column (i.e. we get the full print minus the balance column).  Just for some clarification.
     
     
  • Hylke Britstra Profile Picture
    93 on at
    In my machine version 10.0.42 after a while I get the same scenario. Just one customer, not having balance column in the customer statement. No matter what I try to change (also deleting usage data), the error exist. For all other customers it works fine, except one. 
     
    With the same customer in version 10.0.43 that I also have everything works fine, also after changing some settings. So maybe it is indeed an issue for 10.0.42.
     
    Kind regards,
     
    Hylke
  • real_ashwin Profile Picture
    1,229 on at
    I have the same issue, were you able to resolve it ? If so please let me know how ?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 689

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 258 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans