Creation Parameters for Financials 1

[Jason2121]

I am trying to create Financial Statements using the Financials. Each Line Item contains multiple Accounts. I cant remember how to do a Between Formula so only certain Accounts will be pulled for their Data(Amounts).

Does anyone have a tip?

Jason

 

[CoSpringsGuy]

show a sample of what your line items look like and an example of which ones you want to select and dont want to select.

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[Jason2121]

5082.1 SWITCH ACCESS INTER ATT
5082.2 SW ACC REV - INTERSTATE
5082.3 SWITCHED ACCESS INTER PTL
5082.4 SWITCH ACCESS INTER NECA
5083.1 SPL ACCESS INTER ATT
5083.2 SPL ACCESS INTER OTHER
5083.3 SPECIAL ACCESS-INTER PTLD
5084.1 SWITCH ACCESS STATE ATT
5084.2 SW ACC REV - STATE - OTHE
5084.21 SW ACCESS-STATE-OTHER-UAF
5084.3 SW ACC REV - STATE - BELL
5084.4 SWITCHED ACCESS STATE PTL
5084.99 INTRALATA CREDIT
5085.3 SPL ACCESS STATE BELL
5085.5 SPECIAL ACCESS STATE PTLD
These Accounts and their Amounts would be classed as Network Access Services in the Income Statement

5001. BASIC AREA REVENUE
5001.1 LOCAL SERVICE LIFELINE
5001.5 LOCAL SERVICE - DSL
5001.6 LOCAL SERVICE - INTERNET
5001.7 LOCAL SERVICE-EFFINGHAM S
5001.99 SUBSCRIBER LINE CREDIT
These Accounts and their Amounts would be grouped as Local Service Revenue in the Income Statement.

For instance, my Cash line item contains Accounts 1130.11 thru 1150. in the Balance Sheet.

Let me know if this is enough info. I could swear there is a formula that I can writer which will grab the Amounts in these Accounts. This way I only have to write the Formula once and use the Reports for all my clients at End of Month.

Jason

 

[lbass]

You can write formulas like this:

if left({table.account},4) in ["5082" to "5085"] then
"Network Access Services" else
if left({table.account},4} = "5001" then
"Local Service Revenue" else //etc.

It becomes trickier if you have to consider the decimals. You then might want to wrap the string in val() so that the ranges are interpreted correctly.

-LB

 

[Jason2121]

Thanks. The Formula is long but it worked out great.

Jason