Sample CENTGL/CENTSYSF FML code and output:

SET BLANKINDENT=ON
SET FORMULTIPLE = ON

JOIN SYS_ACCOUNT IN CENTGL TO ALL SYS_ACCOUNT IN CENTSYSF

TABLE FILE CENTGL
SUM
NAT_AMOUNT/D10.0
NAT_YTDAMT/D10.0
FOR GL_ACCOUNT
2000 GET CHILDREN ALL ADD AS CAPTION OVER
BAR OVER
2000 ADD AS CAPTION    LABEL GROSS   OVER
BAR
IF PERIOD EQ '2002/03'
END  

                                              Month      YTD 
                                             Actual     Actual 
Sales Revenue                            -10,398,305. -30,877,546. 
Retail Sales                              -8,237,253. -24,539,197. 
Retail - Television                       -1,391,696. -4,035,597. 
Retail - Stereo                             -519,811. -1,538,197. 
Retail - Video Player                     -1,083,138. -3,096,726. 
Retail - Computer                           -193,499. -583,730. 
Retail - Video Camera                     -5,049,109. -15,284,947. 
Mail Order Sales                          -1,138,414. -3,403,387. 
Mail Order - Television                       -5,265. -15,277. 
Mail Order - Stereo                          -20,544. -57,617. 
Mail Order - Video Player                    -20,618. -58,537. 
Mail Order - Computer                       -424,162. -1,201,155. 
Mail Order - Video Camera                   -667,825. -2,070,801. 
Internet Sales                            -1,022,638. -2,934,962. 
Internet - Television                         -5,307. -15,457. 
Internet - Stereo                            -49,450. -148,428. 
Internet - Video Player                      -51,492. -149,802. 
Internet - Computer                         -199,990. -572,334. 
Internet - Video Camera                     -716,399. -2,048,941. 
Cost Of Goods Sold                         5,884,646. 17,796,997. 
Variable Material Costs                    4,415,560. 13,410,629. 
Television COGS                              860,164. 2,517,319. 
Stereo COGS                                  194,222. 581,740. 
Video COGS                                   580,045. 1,732,536. 
Computer COGS                                395,016. 1,173,602. 
Video Camera COGS                          2,386,113. 7,405,432. 
Direct Labor                                 961,143. 2,920,449. 
Fixed Costs                                  507,943. 1,465,919. 

Gross Margin                              -4,513,659. -13,080,549. 

If in addition to the gl accounts, there were also account units that gave a further breakdown how could you include that in your FML code so that it was in the output as follows?

Account Unit 100100 - Chicago Office
Account Unit 100200 - Boston Office

                                              Month      YTD 
                                             Actual     Actual 
Sales Revenue                            -10,398,305. -30,877,546. 
Retail Sales                              -8,237,253. -24,539,197. 
Retail - Television
         100100 Chicago Office            -1,000,000. -4,000,000. 
         100200 Boston  Office              -391,696.    -35,597. 
Retail - Stereo                              
         100100 Chicago Office              -500,000. -1,000,000. 
         100200 Boston  Office               -19,811.   -538,197. 
Retail - Video Player                      
         100100 Chicago Office            -1,000,000. -3,000,000. 
         100200 Boston  Office               -83,138.    -96,726.
Retail - Computer                           
         100100 Chicago Office              -100,000.   -500,000. 
         100200 Boston  Office               -93,499.    -83,730. 
etc.....
Gross Margin                              -4,513,659. -13,080,549. 

Bethany

Bethany,

That would have to be included within the parent child herarchy to get it how you would like.

T