replace a subset value in db function
Posted: Thu Oct 12, 2017 12:27 pm
Hi,
I have to replace a subset value in place of hard coded month in the below DB expression
['Average DSO'] =DB('AR History', !Customers SoldTo Only, 'US01', 'Jul 2017', 'All Currencies', 'Local Currency', 'ASSETS', 'All Customer Types', '6 month DSO');
I have a subset name called Months - Prior Month which has one item .
If we cannot use the dynamic subset in rules, how can i generate the last completed month which is sep 2017 with in rule.
Thanks,
I have to replace a subset value in place of hard coded month in the below DB expression
['Average DSO'] =DB('AR History', !Customers SoldTo Only, 'US01', 'Jul 2017', 'All Currencies', 'Local Currency', 'ASSETS', 'All Customer Types', '6 month DSO');
I have a subset name called Months - Prior Month which has one item .
If we cannot use the dynamic subset in rules, how can i generate the last completed month which is sep 2017 with in rule.
Thanks,