Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Previous Function and Grouping

Status
Not open for further replies.

laurenbattaglia

Technical User
May 3, 2002
28
US
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}) = &quot;&quot;
and {FA_MASS_ADDITIONS.AP_DISTRIBUTION_LINE_NUMBER} <> 1
then
FirstDiv
else
{FND_FLEX_VALUES_TL.DESCRIPTION}



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top