laurenbattaglia
Technical User
I am using the following 2 variables, which I need to reset on change of invoice number. But previous forces formula to evaluate whileprintingrecords, which prohibits me from grouping on the result. Is there any way around this?
1)
WhilePrintingRecords;
Global stringvar FirstDiv;
if previous({FA_MASS_ADDITIONS.INVOICE_NUMBER}) <> {FA_MASS_ADDITIONS.INVOICE_NUMBER}
AND {FA_MASS_ADDITIONS.AP_DISTRIBUTION_LINE_NUMBER} = 1
and not isnull({FA_MASSADD_DISTRIBUTIONS.DEPRN_EXPENSE_CCID}) and
{FND_FLEX_VALUES.FLEX_VALUE_SET_ID} = 1002542
then
FirstDiv := ({FND_FLEX_VALUES_TL.DESCRIPTION})
2)
WhilePrintingRecords;
Global stringvar FirstDiv;
if isnull({FND_FLEX_VALUES_TL.DESCRIPTION})
or ({FND_FLEX_VALUES_TL.DESCRIPTION}) = ""
and {FA_MASS_ADDITIONS.AP_DISTRIBUTION_LINE_NUMBER} <> 1
then
FirstDiv
else
{FND_FLEX_VALUES_TL.DESCRIPTION}
1)
WhilePrintingRecords;
Global stringvar FirstDiv;
if previous({FA_MASS_ADDITIONS.INVOICE_NUMBER}) <> {FA_MASS_ADDITIONS.INVOICE_NUMBER}
AND {FA_MASS_ADDITIONS.AP_DISTRIBUTION_LINE_NUMBER} = 1
and not isnull({FA_MASSADD_DISTRIBUTIONS.DEPRN_EXPENSE_CCID}) and
{FND_FLEX_VALUES.FLEX_VALUE_SET_ID} = 1002542
then
FirstDiv := ({FND_FLEX_VALUES_TL.DESCRIPTION})
2)
WhilePrintingRecords;
Global stringvar FirstDiv;
if isnull({FND_FLEX_VALUES_TL.DESCRIPTION})
or ({FND_FLEX_VALUES_TL.DESCRIPTION}) = ""
and {FA_MASS_ADDITIONS.AP_DISTRIBUTION_LINE_NUMBER} <> 1
then
FirstDiv
else
{FND_FLEX_VALUES_TL.DESCRIPTION}