source: WorldVistAEHR/trunk/r/ENGINEERING-EN/ENFARB.m@ 1111

ENFARB ;WIRMFO/SAB-FIXED ASSET RPT, SUMMARY OF SGL $ BALANCES; 12/16/96

 ;;7.0;ENGINEERING;**39**;Aug 17, 1993

 ; Summary of $ Balances by Station, [Fund,] and SGL

EN ;

 ; ask for period (month/year)

 S DIR(0)="D^::E^K:($E(Y,4,5)=""00"")!($E(Y,1,5)>$E(DT,1,5)) X"

 S DIR("A")="Enter month of desired closing balances"

 S X("Y")=$E(DT,1,3),X("M")=$E(DT,4,5)

 S X=$S(X("M")="01":(X("Y")-1)_"12",1:X("Y")_$E("00",1,2-$L(X("M")-1))_(X("M")-1))_"00"

 S DIR("B")=$$FMTE^XLFDT(X)

 K X

 S DIR("?",1)="Month and year are required and future dates are invalid."

 S DIR("?",2)="This date will be used to select the closing balances"

 S DIR("?",3)="that will be shown on the output."

 S DIR("?",4)=" "

 S DIR("?")="Enter the month and year."

 D ^DIR K DIR G:$D(DIRUT) EXIT

 S ENDTR=$E(Y,1,5)_"00" ; month to report

 ; ask type of breakdown

 S DIR(0)="Y",DIR("A")="Report SGL totals by Fund"

 S DIR("B")="YES"

 D ^DIR K DIR G:$D(DIRUT) EXIT

 S ENBYFUND=Y

 ; ask device

 S %ZIS="QM" D ^%ZIS G:POP EXIT

 I $D(IO("Q")) D  G EXIT

 . S ZTRTN="QEN^ENFARB"

 . S ZTSAVE("ENDTR")="",ZTSAVE("ENBYFUND")=""

 . S ZTDESC="FAP $ Balances"

 . D ^%ZTLOAD,HOME^%ZIS K ZTSK

QEN ; queued entry

 U IO

COLLECT ; collect data

 S END=0 K ENT

 I 'ENBYFUND S ENFUND="all"

 ; loop thru stations

 S ENI(1)=0 F  S ENI(1)=$O(^ENG(6915.9,ENI(1))) Q:'ENI(1)  D

 . S ENSN=$$GET1^DIQ(6915.9,ENI(1)_",",.01)

 . ; loop thru funds

 . S ENI(2)=0 F  S ENI(2)=$O(^ENG(6915.9,ENI(1),1,ENI(2))) Q:'ENI(2)  D

 . . S:ENBYFUND ENFUND=$$GET1^DIQ(6915.91,ENI(2)_","_ENI(1)_",",.01)

 . . ; loop thru standard general ledgers

 . . S ENI(3)=0

 . . F  S ENI(3)=$O(^ENG(6915.9,ENI(1),1,ENI(2),1,ENI(3))) Q:'ENI(3)  D

 . . . S ENSGL=$$GET1^DIQ(6915.911,ENI(3)_","_ENI(2)_","_ENI(1)_",",.01)

 . . . S ENBAL=$$GETBAL^ENFABAL(ENI(1),ENI(2),ENI(3),ENDTR)

 . . . S:ENBAL>0 ENT(ENSN,ENFUND,ENSGL)=$G(ENT(ENSN,ENFUND,ENSGL))+ENBAL

PRINT ; print results

 S ENPG=0 D NOW^%DTC S Y=% D DD^%DT S ENDT=Y

 S ENDTR("E")=$$FMTE^XLFDT(ENDTR)

 S ENL="",$P(ENL,"-",IOM)=""

 S ENSN="" F  S ENSN=$O(ENT(ENSN)) Q:ENSN=""  D  Q:END

 . D HD Q:END

 . S ENTS="0^0" ; initialize station totals

 . S ENFUND="" F  S ENFUND=$O(ENT(ENSN,ENFUND)) Q:ENFUND=""  D  Q:END

 . . S ENTF="0^0" ; initialize fund totals

 . . S ENSGL=""

 . . F  S ENSGL=$O(ENT(ENSN,ENFUND,ENSGL)) Q:ENSGL=""  D  Q:END

 . . . I $Y+4>IOSL D HD Q:END

 . . . W !,?12,ENFUND,?22,ENSGL

 . . . W ?30,"$",$J($FN($P(ENT(ENSN,ENFUND,ENSGL),U),",",2),16)

 . . . S $P(ENTF,U)=$P(ENTF,U)+$P(ENT(ENSN,ENFUND,ENSGL),U)

 . . Q:END

 . . S $P(ENTS,U)=$P(ENTS,U)+$P(ENTF,U)

 . . Q:'ENBYFUND

 . . I $Y+5>IOSL D HD Q:END

 . . W !,?30,"-----------------"

 . . W !,?30,"$",$J($FN($P(ENTF,U),",",2),16),!

 . Q:END

 . I $Y+5>IOSL D HD Q:END

 . W !,?30,"-----------------"

 . W !,?16,"STATION TOTAL"

 . W ?30,"$",$J($FN($P(ENTS,U),",",2),16)

 I 'END,$E(IOST,1,2)="C-" S DIR(0)="E" D ^DIR K DIR

 D ^%ZISC

EXIT I $D(ZTQUEUED) S ZTREQ="@"

 K DIR,DIROUT,DIRUT,DTOUT,DUOUT,X,Y

 K ENBAL,ENBYFUND,ENDA,ENDTR,ENFUND,ENI,ENSGL,ENSN,ENT,ENTF,ENTS

 K END,ENDT,ENL,ENPG

 Q

HD ; header

 I $D(ZTQUEUED),$$S^%ZTLOAD S ZTSTOP=1,END=1 Q

 I $E(IOST,1,2)="C-",ENPG S DIR(0)="E" D ^DIR K DIR I 'Y S END=1 Q

 I $E(IOST,1,2)="C-"!ENPG W @IOF

 S ENPG=ENPG+1

 W !,ENDTR("E")," ",$S($E(ENDTR,1,5)=$E(DT,1,5):"CURRENT",1:"CLOSING")

 W " BALANCES FOR STATION: ",ENSN

 W ?49,ENDT,?72,"page ",ENPG

 W !,ENL

 W !!,?20,"STANDARD",?30,"TOTAL"

 W !,?20,"GENERAL",?30,"ASSET"

 W !,?12,"FUND",?20,"LEDGER",?30,"VALUE"

 W !,?12,"------",?20,"--------",?30,"-----------------"

 Q

 ;ENFARB