Hi all is it possible to create a customer statement pdf via suitescript 2.0 ? Standard customer statement aging buckets are based on 30 days e.g current,0-30,30-60,60-90 days i want aging bucket to reflect values for each month e.g current, previous month , previous to previous month Example statement generated in July Aging buckets should be July, June, May , April , March and earlier Any help in this regard would be appreciated . Thanks

I've done this before without scripting. You can create custom fields for each aging band which use a summary saved search to calculate the open AR for that date range by summing amount remaining. The only gotcha is that amount remaining is always positive even for credits etc. I ended up with a formula, something like

{amountremaining} * CASE WHEN {amount} > 0 THEN 1 ELSE -1 END

We did something for aging for the past 1,2,3 months and then everything older than that. I wrote this a couple of years ago so probably could be done in a better way (it's 200 odd lines!!)