TBRYAN
03-28-2002, 02:02 PM
I have a client that has employee loans, and we had a custom formula, which was done on ver 7 of peachtree complete. we upgraded them to ver 8 and now the formula doesn't work right. Does anyone have a better way of tracing employee loans or maybe some help with our current formula.
BAL LOAN
BalLoan EE 02
LOCAL-EXCEPTION
ANSWER=(LOCAL_AMT)+YTD(EMP_LOANS)-EMP_LOCAL_NUMBER
EMP LOAN
EMP LOANS EE 02
LIMIT=(LOAN_AMT);
A=EMP_LOCAL_NUMBER;
B=-YTD(EMP_LOANS);
C=A-((A+B)-LIMIT);
D=IF((A+B)<LIMIT,A,C);
ANSWER=-D
BAL LOAN
BalLoan EE 02
LOCAL-EXCEPTION
ANSWER=(LOCAL_AMT)+YTD(EMP_LOANS)-EMP_LOCAL_NUMBER
EMP LOAN
EMP LOANS EE 02
LIMIT=(LOAN_AMT);
A=EMP_LOCAL_NUMBER;
B=-YTD(EMP_LOANS);
C=A-((A+B)-LIMIT);
D=IF((A+B)<LIMIT,A,C);
ANSWER=-D