3,110
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,
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.
Hello Shabir,
Can you try filtering out the negative amounts as exemplified below?
Best regards,
Ludwig
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
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
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
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 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
#1
André Arnaud de Cal...
294,261
Super User 2025 Season 1
#2
Martin Dráb
233,013
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
