Modify Current Formula 1

[Crystalfire]

This formula limits the AccountID's I need to see. I had a request to also show the account # 30850000 but not any accounts between 3080000 and 30850000. How would I modify this formula. Thanks!


{RECEIVABLE_DIST.POSTING_DATE} = {?POSTING DATE} and
{RECEIVABLE.INVOICE_ID} = "INV-10355" and
{RECEIVABLE_DIST.GL_ACCOUNT_ID} in "3010000" to "3080000"

 

[kskid]

Try this

{RECEIVABLE_DIST.POSTING_DATE} = {?POSTING DATE} and
{RECEIVABLE.INVOICE_ID} = "INV-10355" and
{RECEIVABLE_DIST.GL_ACCOUNT_ID} in "3010000" to_ "30850000"

the to_ will exclude 30850000

 

[Crystalfire]

I need to see 30850000 but not anything less than 3085000 and greater than 3080000.

 

[bdreed35]

Write it this way:

{RECEIVABLE_DIST.POSTING_DATE} = {?POSTING DATE} and
{RECEIVABLE.INVOICE_ID} = "INV-10355" and
{RECEIVABLE_DIST.GL_ACCOUNT_ID} in ["3010000" to "3080000","30850000"]

~Brian

 

[Crystalfire]

Thanks for the help!!