I want to write a report about invoice payment.
What is the different between paidtodate and paidsum in OINV table?
Total Balance Due =doctotal - paidtodate
Total Balance Due =doctotal - paidsum ???
Edited by: wing168 on Feb 14, 2012 3:41 AM
Total Paid Sum is nothing but Money that you Received from Customer through Payment Means.
But PaidToDate is nothing but either money that you collected from customer or any AR Credit Note that you adjusted against AR Invoice.
So I woud suggest if you wnt to have such report where you need to show how many AR Invoices are paid in terms of Money Collection then go for PaidSum else
if you want a report for AR Invoice status then go for PaidtoDate......