Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Alexis Barrios]

Hi everyone,

I am trying to build my aging definitions to get the following figures:

Current        0 – 30 

30              31 – 60 

60              61 – 90 

90+            90+

this is how is set now:

Period
90+       -30  Unlimited
61-90    -30  Day
31-60    -30  Day
1-30      -30  Day
Current    0  Unlimited

and this is what I am getting

                             90+               61-90               31-60            1-30               Current
Balance as of   10/02/2020   11/01/2020     12/01/2020     12/31/2020       12/31/2020
12/31/2020       10/01/2020     10/31/2020   11/30/2020      12/30/2020     12/31/2020

——————————
Alexis Barrios
Fyffes Group Ltd
Pompano Beach FL
——————————

[Julia Simpson]

Changing the Printing Direction on the Ageing Period Definition should give you what you want 🙂

——————————
Julia Simpson
Senior Consultant & Team Lead
HSO Customer Service B.V.
Reading
——————————
——————————————-

[Stacy Black]

Hello Alexis,

Your over 90 should be set to -999 Unlimited instead of -30. You may want to have the Current starting on the left, I would mark the aging to be run backwards.  

——————————
Stacy Black
Senior Application Consultant
MCA Connect
Mukilteo WA
——————————
——————————————-