PSA LRW - Rows: How to add an Account Code Range

How to add an Account Code Range

  1. To add an Account Code Range, first get a list of all your accounts from Reports → Accounts → List.
    Note: The account type can be limited as shown here.
          
  2. To Add a Range of Accounts, in the Rows screen, select Account Code Range on the Left, and Click Add Row. Note: Each Segment represents its own Begin and End Range. See note below for more detail
  3. The following screen will display allowing you to enter a range of accounts. Make sure the Mask Begin Code and the Mask End Code are on that Account List you printed. Enter each exactly as it shows on the list.   
  4. Save.

 

Please Note: Ledger Report Writer is designed to take each segment listed in the Begin and End Range and find only Accounts that satisfy all.

For example, if you have the following accounts and use the Range, Begin: I-1-0010-4000-01 End: I-1-0010-4030-03

I-1-0010-4000-00
I-1-0010-4000-01
I-1-0010-4000-02
I-1-0010-4030-00
I-1-0010-4030-01
I-1-0010-4030-02
I-1-0010-4030-03

You will get the following list. Note: no accounts with -00 at the end are listed. This is because it finds all accounts with Natural Account between 4000 and 4030 and with Sub-Account between 01 and 03

I-1-0010-4000-01
I-1-0010-4000-02
I-1-0010-4030-01
I-1-0010-4030-02
I-1-0010-4030-03

Each segment reduces the output. Starting with the first segment accounts are eliminated. Then the second segment may remove more. This continues on through all of the segments. 

 

 

 

 

 

Updated

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request