Hi all is it possible to create a customer stateme...
# suitescript
a
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
@battk any idea sir?
b
a
Thanks But actually this will print the standard customer statement with 30 days aging buckets Actually my requirement is to calculate aging based on month , e.g month buckets, If statement date is july than aging bucket need to be July,June,May, April , MArch &Earlier
is it possible to calculate aging via suitescript 2.0 and show it by creating custom customer statement via Suitelet pdf
b
its more advanced pdf than suitescript
you need to create your own statement form
which uses your own buckets
which likely means you need to add fields to the customer record to store that information to use in the form
a
I see , I need to populate aging bucket values via suitescript ? to those custom fields ?
is it even possible to calculate aging bucket values via suitescript ?
b
you would need to calculate that information yourself
a
is it possible though via scripting ? cuz as far as i know , need to consider all the AR transactions and scenerios for aging calculation !
b
you only really would be using the transaction date and amount if you are doing it by month
m
See my answer in #C298P0BCK. You don't need scripting doe this.