ACCPAC Advantage 5.2 Financial Reporter

[nellerbug]

I have 10-digit Account Numbers in my G/L consisting of 3 Segments, Account Number-Department-Division

I want to produce a Statement showing Account Number-Department going down the report, and Current Month $ for each Division going across the report, for example:

Division 1 Division 2 Division 3
Sales
Cost of Sales
etc

My problem is I can't see how to get around Financial Reporters tendency to only deal with the Account Number being defined in COlumn A and $ being Actual or Budget for the entire account.

I would appreciate any assistance on this.

 

[Lancedac]

In column A you could make the account range references like this: 4000:4000.

Under the different divisions use =FRAMTA("BALP",""," ( ACCTFMTTD LIKE ""%-%-division"" ) ")

substitute division for the segment code. You might have to hard code account descriptions.