topic Re: Need help with due amount calculation in App Development

Need help with due amount calculation

usamabinsadiq — Sun, 05 Apr 2020 12:36:52 GMT

Hi,

I have data fields like: (date field is calculated, it has all the dates from min(order_date) till today)

date,

order_date,

Due_date,

invoice date,

invoice_amount,

customer_name,

.....

I need to calculate total due invoice_amount (due_date < date) in master items, can anybody help with it.

Thanks.

Re: Need help with due amount calculation

msKarthikeyan — Sun, 05 Apr 2020 17:04:01 GMT

Hi ,

Do u want to calculate due items at customer level?

-Karthik

Re: Need help with due amount calculation

usamabinsadiq — Sun, 05 Apr 2020 18:15:51 GMT

yes I want to get customer level, due amount. but amount must be calculated after due date is passed like (due_date < max(date))

Re: Need help with due amount calculation

lorenzoconforti — Mon, 06 Apr 2020 13:24:39 GMT

According to your data structure there is one date per record so due_date < date will work (technically) but it doesn't look like it is what you are looking for

Can you explain what the date field includes and in which tables does it appear? Do you have a master calendar built on this?

Re: Need help with due amount calculation

usamabinsadiq — Mon, 06 Apr 2020 13:52:48 GMT

Thank you guys, I resolved it by my own using,

sum({<TRX_DUE_DATE={"$(= '<' & max(DATE)) "}>} DISTINCT [INVOICED_SELLING_AMOUNT])

but thank you all.