Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Cust Aging Report Negative amount or minus value

Posted on by 2,988

CustagingNegativeandPositiveValues.png

Hi Experts,

I have chosen Due date while running the aging Report. I can understand the plus(Positive amount) in the report that is an amount will be paid by the customer to our company. But what about the negative amount in the report if it (Trans Date or Due date) with both the date I watching negative amount as shown above in the image. Could you explain to me please. Positive value and negative values with a due date and Trans date both. Thanks in advance.

Best Regards,

Shabir Ahmad

  • OsmanIstanbul Profile Picture
    OsmanIstanbul 2,801 on at
    RE: Cust Aging Report Negative amount or minus value

    Hi Shabir,

    you can assume sales orders as customer Invoice (roughly), payment is just payment (customer gives money to you), settlements aren't a physical transaction, the system generates them for different purposes, and sum of them settlements always  0. So you can ignore settlement transactions.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Cust Aging Report Negative amount or minus value

    Hello Shabir, 

    Can you try filtering out the negative amounts as exemplified below?

    custag1.png

    custag2.png

    Best regards, 

    Ludwig

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 2,988 on at
    RE: Cust Aging Report Negative amount or minus value

    CustomerTransaction.pngCustomerTransaction2.png

    Hi both,

    Let me show you some more info so it will make this case more easy check the report with negative (-) values in the end of one of the customers I click on and expose the transaction as shown in the report.

    I will be happy if anyone tells me about these three 3 things as well. What does mean by Transaction type Sales order 2 what does mean by transaction payment and last what does mean by transaction type settlement please explain this as well to clear my doubts.

    Best Regards,\

    Shabir 

  • OsmanIstanbul Profile Picture
    OsmanIstanbul 2,801 on at
    RE: Cust Aging Report Negative amount or minus value

    Hi Shabir,

    "The last thing is it possible that payment was given more than invoices??": yes, it is possible. If this scenario happens then the report will show a negative amount of course. for credit note, you can refer to docs.microsoft.com/.../about-credit-notes

    Best Regards

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 2,988 on at
    RE: Cust Aging Report Negative amount or minus value

    Hi Both,

    Thanks for your valuable ideas and info I got your point but how can check this credit note (returning of items from customers is credit note. right??). Further, let me check settlements as well. The last thing is it possible that payment was given more than invoices??

    Best Regards,

    Shabir Ahmad

  • OsmanIstanbul Profile Picture
    OsmanIstanbul 2,801 on at
    RE: Cust Aging Report Negative amount or minus value

    Hi shabir

    Es Ludwig mentioned it can be credit not or maybe payment even. Aging reports show open transactions(credit or debit). Can you check if you made settlements or not. If you make settlements, as you said, report will show only positive transactions.

    Regards 

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Cust Aging Report Negative amount or minus value

    Hi Shabir,

    I would assume that this is a credit note that you have for a customer.

    Have you tried if you can filter out amounts < 0.00 by making use of the standard report filters?

    Best regards,

    Ludwig

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans