Improving Business Performance with Technology


# Thursday, September 30, 2010
Tips for Catching Blank Records


This is a question I get asked quite often.  When running any standard Syteline report, a range of “blank” returns the value for all records.  So how do you capture only those records that are truly blank? Thanks to the Syteline filtering capabilities on forms, you could filter in the field using the “null” command which works fabulously.  Unfortunately it doesn’t help much with Standard Syteline Output Reports.
 

In this case, the answer is very simple.  You only need to create a unit code record of 01 with a description of “Accounting Only Do not Use”.  And then of course, never use it.

 

So if for example, you want to see all of the ledger entries for a given period where the account number is equal to Office Supplies and there is no department associated with it, you would select a unit code 1 range of “blank” through “01” and it will give you that answer.  This is also handy in writing financial statements.  Some users have even created financial statements named “Reclass” to capture all of the missing values for easy reclass identification.

 

How many of you already use this trick?

 

Mary Farina
BTA Senior SyteLine Accounting Consultant


Thursday, September 30, 2010 5:20:23 PM (Central Daylight Time, UTC-05:00)  #    Comments [0]  SyteLine | SyteLine Technical

All comments require the approval of the site owner before being displayed.
Name
E-mail
Home page

Comment (Some html is allowed: a@href@title, strike) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.  

Enter the code shown (prevents robots):

Live Comment Preview
Copyright ® 2010 BTA, All rights reserved.