Customer account statement in D365 not showing Balance column

(4) Share

Report

Posted on by Chocolate_Pizza

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:

Dynamics 365 Finance

I have the same question (0)

All responses (5)

Answers (0)

Hylke Britstra 93 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Chocolate_Pizza 61 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Chocolate_Pizza 61 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Hylke Britstra 93 on at

Like (0)

Report

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

Was this reply helpful? Yes No
real_ashwin 1,225 on at

Like (0)

Report

I have the same issue, were you able to resolve it ? If so please let me know how ?

Was this reply helpful? Yes No