Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Richard Goward]

In the customer card, there is a total sales amount of $0.00 showing for a customer. The customer has sales activity.
We have noticed this since 2017. This customer has activity in 2016 as well as 2017.
This is the same for all customer cards.
Any idea why our Total sales field does not show accurate information?

——————————
Richard Goward
Dermae
——————————

[David Wiser]

This should be pulling from the “Sales (LCY)” field in the Customer Ledger Entry table.  Check to see if there is information in that field for the customer.  If so, you’ll need to check the flowfield in the Customer Card table or the formula in the factbox page.

——————————
Dave Wiser
Controller
Beckwith & Kuffel
Seattle WA
——————————
——————————————-

[Kris Ruyeras]

As Dave mention, check in that ledger entries. I would also like to know if you’re using Bill-to on invoices. So this wouldn’t show on the Sell-to customer card but their Bill-to if different.

——————————
Kristoffer Ruyeras
Director of Business Technology
Bellegrove Medical Supply
Redmond, WA
——————————
——————————————-

[Richard Goward]

So we just needed to add the accounting periods for 2017.
We are new to NAV (since Aug 2016). We have never started a new year.
Definitely will have this taken care of next year.
Thanks for all the assistance.

——————————
Richard Goward
Dermae
——————————
——————————————-