Announcements
No record found.
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
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
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
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??
"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
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
Hello Shabir,
Can you try filtering out the negative amounts as exemplified below?
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.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 617
André Arnaud de Cal... 461 Super User 2026 Season 1
Syed Haris Shah 298 Super User 2026 Season 1
