| ALL
PRODUCTS |
| |
| 3/20/08 - Added new programs to view the Web Log. |
| Programs: Custom.jsp (by customer), Custom1Servlet, weblogs/JSP
Folder, WebLogServlet, WebLogRules, WebLogTabChangeServlet. |
| |
|
TRUST
AND IRA IS
|
| |
| DEPARTMENTAL
REPORTS |
| |
| Detail
Trial Balance |
| 5/23/07 - Added option to sort and subtotal by trust
type for Westernbank. |
| Programs: tlr020w/JSP folder, TLR020 (RPGLE), TLR020JCL
(CLP). |
| |
| Transactions
for Selected Date |
| 6/4/07 - Repaired problem with handling a zero transaction
code (CCOPG). |
| Programs: TLR215 (RPG). |
| |
| IRA
5498 Reports |
| 5/2/07 - Changed the allowable date for prior year contributions
from 4/15 until 5/31. There are some situations when it
may be allowable to post prior year contributions after
4/15, ie. lost checks, weekends and holidays. |
| Programs: Ira094Rules, IRA094 (RPGLE). Change was requested
by ETC. |
| |
| Check
Reconciliation |
| 5/2/07 - When a check is stopped or voided, the program
will now create a reversing creditor payment and a reversing
cash transaction. |
| Programs: Tlr560Rules. Change requested by CCOPG. |
| 7/17/07 - Added a new tab called "Outstanding Check
File" that will create a CSV file containing check
data for outstanding checks for a given period. |
| Programs: Tlr560OutstandingChecksRules, Tlr560OutstandingChecksServlet,
Tlr560wTabChangeServlet, outstandingCheckFile.jsp, checkFileHistory.jsp,
HelpOutstandingCheckFile.html, outstanding_checks tabs |
| 10/26/07 - Added Review Mode to the Check File History
screen. |
| Programs: Tlr560wMaintenanceServlet, Tlr560wModificationServlet,
checkHistoryModification.jsp, checkFileMaintenance.jsp |
| |
| Puerto
Rico Tax Forms |
| 11/2/07 - Removed from Trust Departmental Reports menu
and relocated on custom menus. |
| Programs: trust2.jsp, Trust2DepartmentalReportsServlet |
| |
| RECORD
ENTRY |
| |
| Trust
Master Record |
| 6/11/07 - Fixed a 500 error on the ebtGeneral1.jsp screen
if you went straight to the Select Trust Type lookup and
then opened up a trust. |
| Programs: Tlr000Rules, Tlr000wServlet |
| 10/24/07 - Removed the unused "Principal Business
Activity Code" field BACODE from the EBT General 2
screen. |
| Programs: Tlr000Rules, ebtGeneral2.jsp, HelpGeneral2.html |
| |
| Investment
Catalog Records |
| 1/17/08 - Improved appearance of all screens and help
text. |
| Programs: sponsor/jsp folder, tlr300w/jsp folder. |
| 1/18/08 - Added new file to store Real Estate Descriptions
which is attached to the Catalog program. |
| Programs: images/tlr300, tlr300w/displayRealEstateDescription.jsp
and help text, Tlr300Rules, RealEstateDescriptionServlet,
Tlr300wServlet, Tlr300wTabChangeServlet, Tlr300wUpdateTickerServlet,
TRREALS (DDS). |
| 2/17/08: Added Sponsor Tax ID# and Single Member LLC
to the Sponsor Record (TRSPONSORS). |
| Programs: SponsorRules, sponsor/displaySponsor.jsp, SponsorUpdateServlet,
TRSPONSORFormat, TRSPNAMEFormat, TRSPONSORS (DDS). |
| |
| Creditor
Records |
| 1/29/08 - Corrected problem with deleting multiple creditor
history records with the same posting date. Also corrected
problem with the ACH/Mail drop down menu when adding records. |
| Programs: displayDetailBalanceCreditor.jsp, Tlr525Rules. |
| |
| Strategy
Trading Records |
| 12/18/07 - Revised screens and help text. |
| Programs: tlr850w/All jsps and help text, Tlr850Rules,
Tlr850wServlet, Tlr850wUpdateServlet, Tlr850wGlobalChangeServlet. |
| 3/24/08 - Corrected printing of strategy name on the
report. |
| Programs: TLR850P (RPGLE). |
| |
| RECORD
UPDATE |
| |
| Accounts
Payable |
| 5/1/07 - Added new option to calculate interest to the
date an account closes in order to avoid small trailing
interest payments after disbursing funds. The accounts
payable transaction code must be 712. When using it, do
not enter a payment amount. The program will get the current
balance in the sweep account and post a transaction code
611 for accrued interest. The interest rate is optained
from the investment catalog record of the sweep fund. |
| Programs: tlr530w/JSP folder, Dates.java, Tlr530wTabChangeServlet,
Tlr540Rules, Tlr540wAddNewPayablesServlet, TLR040, TLR045
(RPG). Also see notes under Distribute Income to Account
Holders. Change was requested by ETC. |
| |
| Daily
Interest Accrual Factors |
| 12/8/07 - Corrected problem with no decimal places found
in the Investment Catalog Record when Income Table = "Y".
Also improved the display and help text. |
| Programs: tlr360w/JSP Folder, All Tlr360w Servlets and
Tlr360Rules. |
| |
| Distribute
Income To Account Holders |
| 5/1/07 - Changed the time weighted interest calculation
programs (cash only) to bypass terminated accounts. |
| Programs: TLR040, TLR045 (RPG). |
| 1/16/08 - Changed the time weighted interest calculation
program (specific cusip#) to bypass terminated accounts. |
| Programs: TLR150A (RPGLE). Change was requested
by ETC. |
| |
| Price
the Investment Catalog |
| 11/7/07 - Added the ability for customers to have their
own custom import file format. |
| Programs: CsvImport, Tlr330Rules, Tlr330wImportServlet,
Tlr330wTabChangeServlet, importPrices.jsp, HelpImportPrices.html. |
| |
| Transaction
Delete |
| 3/15/08 - Added new security options to block change
and delete options. Added new capability to reverse transactions. |
| Programs: tlr230w/JSP folder, TRDCHISFormat, Trust4RecordUpdateServlet,
tsc.security.UserRestrictionRules, Tlr230Rules, All Tlr230
Servlets but delete DescLinesServlet, ExitServlet, DescLineUpdateServlet
and GlobalDeleteServlet. MANAGERS (DDS), config.xml
(tlr230), TRDCHISS (DDS) with CHGPF. |
| |
| SYSTEM
MAINTENANCE |
| |
| Automated
Pricing |
| 5/1/07 - In Scheduled Pricing, added the option to price
funds across all TANs. This option is set in a WRKJOBSCDE
parm that is passed to TLR335SJCL. |
| Programs: Tlr335Rules, HelpScheduledPricing.html, TLR335SJCL
(CLP), |
| |
PLAN
IS
|
| |
| INQUIRY
AND REPORTS |
| |
| Discrimination
Testing |
| 11/5/07 - Corrected display of source selections for
the 415 Test. Repaired a missing total line in 401m) Make
It Pass with Refund. |
| Programs: PLR170r (RPGLE), section415Test.jsp and Plr160Rules. |
| 11/7/07 - Changed parm list to pass the lead Tan to get
contributions for refund calculations. |
| Programs: PLR170R (RPGLE). |
| 2/26/08 - Repaired problem with possible zero salary
in Cap Defferal logic. |
| Programs: PLR170 (RPGLE). |
| |
| Loan
Delinquency Report |
| 2/6/08 - Removed bypassing closed loans in order to implement
"as of" date accounting. |
| Programs: PLR350B (RPGLE). |
| |
| IRS
Form 5500 Report |
| 6/15/07 - Added new schedules for 5500 item#s 6 and 7a. |
| Programs: TLR650 (RPGLE), TLR600JCL and TLR650JCL (CLP). |
| |
| DEPARTMENTAL
REPORTS |
| |
| Required
Minimum Distributions |
| 11/4/07 - Added file download button for 4/1 and 12/31
RMDs. |
| Programs: All Plr060 Servlets, plr060w/JSP folder. |
| 11/12/07 - Changed to report only plans that have RMDs
when the "All" and "Batch" options are chosen. Also changed
the report to one spool file per Tan with spool file name
"RMD" + TAN. |
| Programs: PLR060A and PLR060B (RPGLE), PLR060JCL
(CLP) and HelpRMD HTML files. |
| |
| Price
Correction Report |
| 4/15/08 - Repaired problem with Trust Level price correction
report. It was not printing the before shares, only the
after shares. Problem was the report, not the calculation. |
| Programs: PLR290C (RPGLE). |
| |
| Auditing
Reports - Participant Total Account Balances |
| 1/10/08 - Added option to restrict to a specific Cusip#
for BAC. |
| Programs: plr550w/participantTotalAccountBalances.jsp,
Plan6DepartmentalRecordsServlet, Plr660wServlet, PLR660JCL
(CLP), PLR660 (RPGLE). |
| |
| Auditing
Reports - Trust Balances By Cusip Number (formerly Participant
Trial Balance by Fund) |
| 4/15/08 - Completely rewritten with Jasper Reports and
includes new Alpha sequence (BAC). |
| Programs: plr285w/JSP folder, Plr285Rules, Plr285wServlet,
Plr660TabChangeServlet, BalanceByCusipNumber.jasper. Eliminates
PLR285A and PLR285B (RPG) and PLR286JCL and PLR285JQ (CLP). |
| |
| Auditing
Reports - Inactivity Report |
| 2/18/08 - Increased maximum for Account Balance Limit
field to 9,999,999. |
| Programs: Plr430wServlet, PLR430 (RPGLE). |
| |
| Auditing
Reports - Transaction History Report |
| 3/23/08 - New program to query information for balancing
purposes and autit requests. Done for BAC. |
| Programs: Plr660wTabChangeServlet, TransactionHistoryReportServlet,
TransactionHistoryReportRules, plr125w/enterParticipantSummaryTrialBalance.jsp,
plr280w/enterEmployeeBalancingReport.jsp, plr285w/enterParticipantTrialBalance.jsp,
plr430w/inactivityReport.jsp, plr650w/summaryAuditReportBy
Asset.jsp, plr660w/participantTotalAccountBalance.jsp,
transactionHistoryReport/jsp folder, images/plr660/transactionhistoryreport.jpg,
TransactionHistoryReport.jasper. |
| |
| Auditing
Reports - Holder List |
| 3/30/08 - New program to get a list of all participants
that currently hold shares in a specific investment. |
| Programs: Plr660wTabChangeServlet, HolderListServlet,
HolderListRules, holderList/JSP folder, plr125w/enterParticipantSummaryTrialBalance.jsp,
plr280w/enterEmployeeBalancingReport.jsp, plr285w/enterParticipantTrialBalance.jsp,
plr430w/inactivityReport.jsp, plr650w/summaryAuditReportBy
Asset.jsp, plr660w/participantTotalAccountBalance.jsp,
transactionHistoryReport/jsp folder, images/plr660/holder_list.jpg,
HolderList.jasper. |
| |
| Participant
Labels |
| 1/11/08: Added Trustee ID# and Department# to selection
criteria. |
| Programs: participantLabels/jsp folder, Plan7DepartmentalRecordsServlet,
ParticipantLabelRules, ParticipantLabelsServlet. |
| |
| Beneficiary
Report |
| 12/27/07: Added new Beneficiary Report |
| Programs: Plan7DepartmentalRecordsServlet, UserRestrictionRules,
UserRestrictionPlan2UpdateServlet, BeneficiaryReportRules,
BeneficiaryReportServlet, beneficiaryReport.jsp, helpBeneficiaryReport.html,
plan2.jsp, plan2UserRestrictions.jsp, beneficiaryReport.jasper |
| |
| RECORD
ENTRY |
| |
| Participant
Information Records |
| 8/17/07 - Added the new Beneficiary relationship option "Estate". |
| Programs: Plr000Rules, displayBeneficiaryRecord.jsp |
| |
| Benefit
Payment Records |
| 5/22/07 - Changed to read the Distribution Codes from
TRDISTCD instead of a hard coded list. |
| Programs: Plr400Rules, Plr400Rules$1DistCodeCompare,
select.jsp |
| 2/27/08 - Changed to assume a final payment date is always
after year 2000. |
| Programs: Plr400ProcessPaymentScreen1Servlet. |
| |
| Participant
Transaction Entry |
| 11/8/07 - Added the ability to import transactions from
a CSV file. |
| Programs: Plr200ImportRules, Plr200Rules, Plr200wTabChangeServlet,
Plr200wImportServlet, Plr200wImportUpdateServlet, import.jsp,
importErrorLog.jsp, displayImport.jsp, enterTransactions.jsp,
HelpParticipantTransactionImport.html Participant Transaction
Import images, import tab images, /tsc/conf/import/participant_transactions.xml |
| |
| Participant
Distributions |
| 5/22/07 - Changed to read the Distribution Codes from
TRDISTCD instead of a hard coded list. |
| Programs: Plr450Rules, Plr450Rules$1DistCodeCompare,
summaryDistribution.jsp |
| 2/27/08 - Changed to assume a final payment date is always
after year 2000. |
| Programs: Plr450DisplayBenefitPaymentRecord1Servlet. |
| |
|
RECORD
UPDATE
|
| |
| Participant
Transfers |
| 10/1/07 - Fixed a problem where open trades in the "from
fund" would not be caught. This would let a duplicate
transfer through. Only applicable to customers using the
Trading System. |
| Programs: Plr370wNewTransferRequestServlet, Plr370wTransferToServlet |
| 11/19/07 - Fixed a problem where previous values entered
would be redisplayed even after being deleted over by
the user. |
| Programs: Plr370Rules, Plr370wTransferToServlet |
| 1/22/08 - Changed transfers and trading system to allow
rebalancing transactions to have a different trancode.
This is necessary because of 22C-2 reporting. |
| Programs: PLR370B, PLR370D, PLR370R2, PLR370R3, PLR800,
PLR870, PLR875 (all RPG). PLR370R1, PLR380B (all RPGLE). |
| |
| Payroll
and Loan Processing |
| 4/6/08: Added new CBR Comparison Report that looks for
differences between a reference source and other selected
comparison sources. This program will also correct discrepancies. |
| Programs: plr300/cbr_comparison jpg's, planas.cbrComparisonReport/JSP
folder, planis.cbr.payroll/enterPayrollProcessing.jsp,
plr360w/JSP folder, planis.cbr.payroll/TabChangeServlet,
tsc.business.rules.CompareCBRSources, tsc.planas.servlets.CompareCBRSourcesServlet.
NOTE: May also need planis.cbr.payroll.PayrollProcessingRules
and Servlet. |
| |
| Trading
System |
| 10/31/07 - Added new Transfer / Exchange Report to balance
omnibus level exchanges. |
| Programs: plr800/reports.jpg, plr800w jsp folder, plr880w/enterDisplayOpenTrades.jsp,
TradeReportRules, TransferExchangeReportServlet, Plr800wTabChangeServlet,
TradingReportsServlet, tradingReports jsp folder, |
| TransferExchangeReport.jasper. |
| 2/28/08 - Add new Charles Schwab trade export file (GWN). |
| Programs: Plr800Rules, Plr800NewTradesServlet, SCHWAB
(DDS), various custom programs in GWNS folder, tsc/conf/customers
XML
file. |
| 3/21/08 - Repaired new request tab on Assign Plans to
Banks. |
| Programs: plr840w/enterPlantoBankNumber.jsp and displayPlantoBankNumber.jsp. |
| 3/21/08 - Repaired problem with retaining parameters
when Assigning New Trade Account Numbers. |
| Programs: Plr830wServlet, Plr830wSelectServlet. |
| 4/27/08 - Changed the index in Confirms file (PSC). |
| Programs: Confirms (DDS), CONFIRMFormat, Compile PLR860B,
RPL865 (RPGLE) and PLR895B (RPG). |
| 4/27/08 - Added the Trade# to the Transfer File (TRANSFEF)
in order to handle same day trades with Charles Schwab
(GWN). |
| Programs: TRANSFEF (DDS), TRANSFERFormat, Plr800Rules,
SchwabImportRules, customer_cnfig.xml, PLR805, PLR806.
Compile PLR800 (RPG), PLR870A (RPGLE) and PLR870F
(RPG). |
| |
| Plan
Level Changes |
| 10/19/07 - Added a new option to assign a RRN to all
participants in a plan. |
| Programs: Plr900Rules, PlanLevelChangesServlet, Plr900wRRNServlet,
planLevelChanges.jsp, changeRRNs.jsp, HelpChangeRRNs.html |
| |
| Portfolio
Rebalancing |
| 1/28/08 - Fixed the Strategy Trading Reports tab. |
| Programs: Plr380wTabChangeServlet, plr380w/portfolioRebalancing.jsp.
plr385w/enterStrategyTradingReports.jsp |
| 1/29/08 - Repaired problems with rounding error. |
| Programs: PLR380B (RPGLE). |
| 2/11/08 - Added new logic to separate
transfers from rebalancing using different trancodes. This
is necessary for 22C-2 implementation. |
| Programs: PLR370B, PLR370D, PLR370R1, PLR370R2,
PLR370R3, PLR450I, PLR800 (RPGLE), PLR870, PLR875 (RPG). |
| |
| Fund
Mapping |
| 11/3/07 - This program was changed to allow
across the board fund mapping changes. It will set trades
and/or change investment elections. |
| Programs: Plan9RecordUpdateServlet, plr370w/fundMap.jsp
and HelpFundMap.html, FundMapRules, FundMapServlet, PLR370M
(RPGLE), PLR370MJCL and PLR370MJQ (CLP). Remove PLR370MJCL.java
and Plr370wFundMapServlet. |
| 1/9/08: - Added report when the change investment
option is selected. Added new feature to map from one fund
to the participants current investment elections. |
| Programs: plr370w/fundMap.jsp and html, FundMapRules,
FundMapServlet, Plan9RecordUpdateServlet, PLR370M (TESTLIB2/RPGLE),
PLR370MJCL and JQ (TESTLIB2/CLP). |
| |
| TRANSFER
IS |
| |
| |
If
you have any questions while reviewing our website, please use our typewriter
and send e-mail to swhittle@expertplan.com
