This release includes the following additions and modifications to functionality:
Legislative Changes
The 8.1.11 release satisfies legislative requirements changes as follows:
The Homestead Application (50-144) has been modified. Changes to the PACS version of the application include:
Back content such as general instructions, application deadlines, and filing info added to the last page
Formatting and editing changes to the Mobile Home section, the Sign and Date section, and the fine print about the Tax Code
The addition of an Affidavits page
An introduction to the Exemptions section and modified exemption descriptions
Addition of the DVHSS exemption (Disabled Veteran’s Homestead Spouse, explained more below)
Versions with and without the barcode are available
The Order Determining Protest form (50-221) has been modified. Changes include:
Edited front matter about notice of the hearing
Protest reason codes display in addition to the protest reasons
Current Market Value and Current Appraised Value rows have been removed from the appraised value section
A column displaying the values prior to the hearing decision, including the ARB submitted market, appraised, and assessed values, has been added to the value breakdown section. Headers display for ARB Submitted Value and Final Values
Each property value is represented by a row displaying total appraised value
A new footnote that states: “As shown in the appraisal records submitted to the board by the chief appraiser under Section 25.22 or 25.23”
The Notice of Final Order now informs recipients that suit must be filed within 60 days instead of 45.
Note When generated from PACS, the Order Determining Protest is combined with the Notice of Final Order (50-222). PACS supports ODP letters for both granted and denied motions.
BPP Rendition forms (form 50-144 (10-11/9)) have been modified per State Comptroller orders. Primary changes include the additions of relevant tax code information and agent information (when appropriate). Also, the form generated from PACS now accommodates longer legal descriptions.
On all TA/PACS forms, the state form number is replaced with a TA number, for example: 50-221 now displays as TA-221.
SB 402 section 11.1827 now provides a local option property tax exemption for land owned by a community land trust as described under Local Government Code Section 373B.002 (with housing units located on and owned by the trust). In compliance with this change, the Community Land Trust Exemption has been added to the list of available Special Exemptions. Choose either Activities > Enter Exemptions or, from the property record, choose the Entity-Exempt tab and click Add next to the Exemptions window. The Community Land Trust Exemption is coded CLT, and is set exactly like a Community Housing Exemption (CHODO) in that, for each entity, the value of the exemption is set as an amount, percent, or segment.
All affected Reports and the Appraisal Info Import and Export processes have been modified to accommodate the new exemption.
SB 516 section 11.131 now allows 100% Disabled Veteran’s Exemption to transfer to his/her surviving spouse (the individual married to a disabled veteran at the time of the veteran’s death) if the veteran qualified for the exemption at the time of death, the survivor has not remarried, and the property was the survivor’s residence homestead at the time of the veteran’s death. The surviving spouse may transfer an amount equal to the last year’s dollar amount of the exemption to a different homestead. In compliance, the new Disabled Veteran’s Homestead Surviving Spouse (DVHSS) exemption has been added to the list of available Special Exemptions. Its default value is 100% of the HS value. It can be applied to Real and Mobile Home-type properties. Choose either Activities > Enter Exemptions or, from the property record, choose the Entity-Exempt tab and click Add next to the Exemptions window. DVHSS is set up as a Special exemption to enable the exemption transfer as a dollar amount according to the Tax Code. The Freeze/Transfer Information dialog is not available on special exemptions; however, the new Transfer Certificate is intended to help taxpayers transfer their values (Property > Print DVHSS Transfer Certificate). Note: When printing the transfer certificate, the dialog displays a drop-down list containing only certified years where the supplement has been accepted or bills have been created. Supplement 0 for a certified year may be included in the list.
SB 201 section 11.42 allows a person who qualifies for 100% of the Disabled Veteran’s Exemption (DVHS) after January 1 of a tax year to prorate the exemption. Prorate amounts can be added in the Property Exemption Wizard by choosing either Activities > Enter Exemptions or, from the property record, choose the Entity-Exempt tab and click Add next to the Exemptions window. Prorate an existing exemption by highlighting the exemption in the Entity-Exempt tab and click Details.
After entering a Prorate Begin Date, Taxes = Taxes otherwise imposed x (The number of days prior to qualification / 365)
After entering a Prorate End Date, Taxes = Taxes otherwise imposed x Number of days after the exemption terminates
SB 551 – Functionality supporting omitted Improvements, as well as interest for assessed back taxes, has been added. When a property is supplemented, users can designate an Improvement as omitted and enter the omitted value by choosing the Omitted Improvement option displayed in the Improvement dialog (from Property view of a supplemented property, choose the Improvements tab, highlight an Improvement and click Details).
The value associated with omitted improvements is not automatically included as New Value for the purpose of calculating the HS cap. The user will need to indicate new value on the improvement with the New Value checkbox at the Improvement or Detail level.
Interest on omitted improvement tax calculates starting the 120th day after the supplemented bill’s due date. In PACS Collections, regular and omitted interest calculations are as follows:
The total interest is the sum of the regular and omitted interest. For example:
Regular
Omitted
Total
Improvement Value
15000
100000
M&0 Tax Rate
.5
.5
I&S Tax Rate
.25
.25
M&0 Tax Value
425.00
75.00
500.00
I&S Tax Value
212.50
37.50
250.00
Regular M&0
Omitted M&O
Regular I&S
Omitted I&S
Total
Value
425.00
75.00
212.50
37.50
750.00
Interest Rate
11.00
8.00
11.00
8.00
Interest
46.75
6.00
23.38
3.00
79.13
Property statements display the interest values in the P&I line of the Unpaid Bills Summary. Corrected Supplement Tax Statements display omitted improvement value below the penalty and interest breakdown.
The Appraisal Export and Appraisal Data Import processes do not include omitted interest values.
HB 252 – Previously, the HS exemption was applied to the value of the home, but not the land. Now, the residential HS exemption is apportioned between the land and real property, such as a manufactured home, on a pro rata basis according to the appraised value of the components. This now occurs within property associations in PACS called Homestead Groups. The HS exemption applies proportionally to all properties in the group. Likewise, the cap loss is prorated over all properties.
To create the Homestead Group, click the SplitMerge-Lnk tab on a property and click the Add button displayed to the right of the new Homestead Group window. This opens the Select Property Wizard.
The Homestead exemption and cap loss values are detailed in the HS Cap Value Breakdown dialog box, which you can access by clicking the HS Cap Loss button in the Property Values tab.
The Edit Homestead Group user right must be assigned to your ID to make use of this functionality. In PACS Collections, Homestead Group info is read-only.
Homestead Groups work as follows:
Only Real and Mobile Home properties may be added to a Homestead Group
UDI Parent properties may not be included
A property may only be part of one Homestead Group per year and per supplement number
Year Layer
When creating the New Year Layer (Activities > Certify Appraisal Roll > Create New Year Layer), Homestead Groups are copied from the current year or future year layer
If you copy a property in a Homestead Group to the Future Year Layer (Property > Copy Property to Future Year), then all properties associated with the selected property are also copied to the Future Year Layer. This applies to Homestead Groupings, UDI Groupings, and Income Groupings
The above is true when removing a property from the Future Year Layer unless the Homestead Group association was created in the Future Year Layer, in which case only the selected property is removed, leaving the remaining grouped properties intact
If you copy a property in a Homestead Group to another year (Property > Copy Property Information to Another Year), the other properties associated with the property are not copied and, therefore, neither is the grouping
Supplements
If you supplement a property in a Homestead Group, then all properties associated with the selected property are also supplemented. This applies to Homestead Groupings, UDI Groupings, and Income Groupings
If you move a property in a Homestead Group between supplements, then all properties associated with the selected property are also moved. This applies to Homestead Groupings, UDI Groupings, and Income Groupings
If you remove a property in a Homestead Group from a supplement, then all properties associated with the selected property are also moved if the grouping existed in the previous supplement. This applies to Homestead Groupings, UDI Groupings, and Income Groupings
Split/Merge
A split or merged property loses its group association
UDI Groups
When creating a UDI Group, a Homestead Group association is removed from the UDI Group parent property; child properties retain associations when added to or removed from a UDI Group
Prorated Homestead Group calculations are as follows, with examples:
If one (or more) property in the Homestead Group has a cap Loss but another does not, then Homestead Cap Loss is prorated across the individual properties. This is done as follows:
Sum the current assessed values for each property to reach the Total Current Year Value
Then sum the prior year assessed values for each property to reach the Total Prior Year Value
Calculate the 10% Cap Total as (Total Prior Year) * 10%
Calculate the Max Value as (Total Prior Year) + 10% Cap Total
Calculate the Total Cap Loss as (Total Current Year Value) – (Max Value)
Prorate Factor For Each Property = (Current Year Value For Property – Max Value For Property) / Total Cap Loss
Cap Loss For Each Property = Prorate Factor For Each Property * Total Cap Loss
Example 1:
MH Property Proration Amount = MH Assessed Value / Total Values
Land Property Exemption Amount = 15000 * .375 = 5625
Example 2: One value increases over 10% – Total Value Under 10%
Properties
Current Year Value
Prior Year Value
10% Cap
Max Value
Total Cap Loss
Prorate Factor
Cap Loss Per Prop
Land Property
16000
16000
1600
17600
0
0
MH Property
25000
22000
2200
24200
0
0
Totals
41000
38000
3800
41800
0
Example 3: Both values increase over 10% – Total Increases Over 10%
Properties
Current Year Value
Prior Year Value
10% Cap
Max Value
Total Cap Loss
Prorate Factor
Cap Loss Per Prop
Land Property
18000
16000
1600
17600
.333
400
MH Property
25000
22000
2200
24200
.666
800
Totals
43000
38000
3800
41800
1200
The Sales Submission export file must now include a confidentiality code that indicates which portion(s) of a sale record are confidential. In PACS Appraisal, sales are marked confidential by choosing the Confidential Sale option displayed on the Sale Information tab of the Ownership History dialog box. This dialog is opened when viewing details of a sale record in the Deeds-Sales view of a Property record, or when creating sale information. Now this option is paired with a drop-down list from which a confidential code is selected.
Note
The system is currently designed to handle existing sales records as follows:
– Existing confidential sales in your database will display a O code selection after this update.
– When exported, sale records without the confidential flag selected are automatically assigned the Q code (no confidential information) in the export file. Sale records with the confidential flag selected that have no assigned code displaying in PACS are automatically assigned the O code (parcel address, sale price, grantee address and grantor address) in the export file. The export file is generated through File > Export > Sales Submission.
The confidentiality codes are:
Code
Description (Export submission file field)
A
parcel address (Field 7)
B
sale price (Field 10)
C
grantee address (Fields 22 and 23)
D
grantor address (Fields 29 and 30)
E
parcel address and sale price (Fields 7 and 10)
F
parcel address and grantee address (Fields 7, 22 and 23)
G
parcel address and grantor address (Fields 7, 29 and 30)
H
sale price and grantee address (Fields 10, 22 and 23)
I
sale price and grantor address (Fields 10, 29 and 30)
J
grantee address and grantor address (Fields 22, 23, 29 and 30)
K
parcel address, sale price and grantee address (Fields 7, 10, 22 and 23)
L
parcel address, sale price and grantor address (Fields 7, 10, 29 and 30)
M
parcel address, grantee address and grantor address (Fields 7, 22, 23, 29 and 30)
N
sale price, grantee address and grantor address (Fields 10, 22, 23, 29 and 30)
O
parcel address, sale price, grantee address and grantor address (Fields 7, 10, 22, 23, 29 and 30)
P
other confidential information
Q
no confidential information
Report Designer
A new method for developing custom reports is available with the 8.1.11 release. Report Designer allows users to combine the PACS interface and database with Crystal Reports functionality to generate almost any report imaginable. Reports published on your system can be accessed by other users on your network.
This is a billable module. Contact LPS True Automation to get access.
Start using Report Designer by choosing Tools > Report Designer. The new Report Designer user right is required to open the Report Designer module.
Report Designer includes email functionality called PACS Inbox. Users receive custom report runs in their own Inbox and can circulate messages and reports among other users’ Inboxes. Choose File > Open Inbox for access.
Important
(1) Report Designer requires SQL Server 2005 or greater/newer.
(2) For Report Designer users: When first upgrading to a version of PACS equipped with Report Designer, either have the upgrade on the machine performed by a user with administrator rights/access or contact TA Support and they will provide you with a registry script that enables the upgrade to complete. This is required only once.
Reports
(93780) A new State Codes filter has been added to the Top Taxpayers Report in PACS Appraisal. Generate the Report by choosing Reports > Certification > Print Top Taxpayers. Criteria selections display on the report.
Supplement Processing
(104227) The 25.19 page has been added to the Appraisal Notice Selection Process Wizard for supplement processing. Access the Wizard by choosing Activities > Assessment > Supplement Functions > Print Supplemental Appraisal Notices, highlight run, right-click and choose New Appraisal Notice Selection. This change was made to allow properties with no taxes due and properties with EX or EX366 exemptions to be included in supplemental appraisal notice runs.
Updates
Help STAR
Description of Update
PACS Appraisal
Arbitration
105640
A letter tag for 1st Motion Decision Date has been added to ARB Letters.
21424
ARB protests had difficulty saving, and an unexpected field was populated (File > New > Protest, choose property, enter the Protest Reason Code and Evidence Request Date and save). This issue was resolved in a previous release, but the fix was overwritten, allowing the issue to reappear. The original fix, which had resolved the issue, has been restored.
Appraisal Cards
105667
Subsegments displayed on the wrong property’s appraisal card (open Property Summary view, click Print Appraisal Card). In this case, the subsegments had the same IDs for the same year and supplement number. Now, associated property IDs are considered when selecting subsegments, correcting the issue.
101892
An attempt to print an appraisal card generated an unexpected error because the property’s sketch was larger than what the system was prepared to handle (open property and choose Property > Print Appraisal Card). The necessary change has been made to allow printing of large, complex sketches.
Appraisal Notices
102628
Too many characters in account phone number fields caused an unexpected error to occur when exporting appraisal notices that included e-file notices (Activities > Appraisal Notices > Appraisal Notices Maintenance, highlight and right-click the run to be printed and choose Print Appraisal Notices, select options including Export to File and Include E-File Information). Exceeding the 18 character limit no longer causes an error, resolving the issue.
103098
The first address line was duplicated in an appraisal notice export (Activities > Appraisal Notices > Appraisal Notices Maintenance, highlight and right-click the run to be printed and choose Print Appraisal Notices, select options including Export to File). This issue has been resolved.
ARB Processing
104650
Comparable sales grids generated from a Protest record reflected Inquiry settings (from Protest record, click Comp Grid). The system now distinguishes between Protests and Inquiries when sending the required info to display.
Certification Procedures
94446
The EX366 exemption was not accurately represented on the Appraisal Transfer Totals (from the appraisal data export file). This issue has been fixed.
106345
An unexpected error occurred when attempting to generate a PDF version of the Certified Roll (Activities > Certify Appraisal Roll > Print Certified Roll, set criteria and click Print PDF). Errors occurred when a property had too many taxing entities to fit on a single page. Page breaks are now accommodated, resolving the issue.
Comparable Sales
103732
Attempting to view an equity summary from the Equity Comparables search results caused an unexpected error (open Property record and choose Property > Comparable Equity > Manage Comparables, choose Create Residential Grid, click Search, right-click and choose Select All, right-click and select View Equity Summary One). This issue stemmed from the character length of the Appraisal Method. The system is now prepared to handle and display up to 15 characters in this code field.
108363
The Commercial Comparable Equity Search previously retrieved data going back up to four years, and displayed that data with the current year’s (File > Open > Comparables – Commercial, select Equity Comparables). Residential and Commercial comparable grid searches now include any and all years for which the system has relevant records. Configure comp grids through Tools > Comparable Property > System wide configuration.
Exemptions
81187
When adding an exemption to a property for the current year and a certified year, comments entered in the Property Exemption Wizard failed to copy to the current year (Activities > Enter Exemptions, search for a property/taxpayer and choose multiple years, including the current and a certified year). Comments now copy forward as expected.
An additional issue: The Comment field was disabled in one year when navigating the Wizard. The field has been enabled and is now available.
102382
The Auto Add OV65 process added the exemption to properties that already had the DPS exemption (Activities > Auto Add OV). This issue has been corrected. An additional issue with supplemented properties getting updated and appearing multiple times on the Auto Add OV65 Exemptions Report has also been found and corrected.
112905
After 8.1.11.0019 was released, a recalculation error resulted when two or more properties in a Homestead Group (new functionality) had a Qualify Year equal to the current year layer. A fix allows the recalculation to complete when the Qualify year equals the current year layer. Note the following: The HS Cap should be 0 in these scenarios. Also, you cannot recalculate if the Qualify year is set in the future.
TFS 21418
After selecting Group Applications by Property option and clicking Print in the Print Exemption Applications dialog box, applications failed to print in duplex mode despite the printer’s configuration; the application printed instead on separate pages (Activities > End of Year Processing > Print Exemption Applications). PACS and the user’s printer did not communicate. This issue has been resolved.
Exports
107952
Data entered in the situs Unit field was omitted from the BPP application data export (File > Export > Application Date, choose BPP in the From Type drop-down list). This data is now included.
General
106533
A typo in a confirmation message displayed when deleting an agent has been corrected.
111794
The Sort Order drop-down list option in the Print Property Applications dialog box has been re-enabled (Activities > Print Property Applications). This issue stemmed from the renaming of reports following recent application/report changes.
GIS Viewer/Appraiser
TFS 20794
State law now requires that all GIS maps display a disclaimer similar to, “This product is for informational purposes only and may not have been prepared for or be suitable for legal, engineering, or surveying purposes. It does not represent an on-the-ground survey and represents only the approximate relative location of property boundaries.” When present, custom disclaimers (Tools > Manage GIS) display in lieu of the default text (above). However, if no custom disclaimer exists, the default disclaimer is displayed on the GIS Viewer/Appraiser view as well as the printed map.
106928
School-type Entity Codes can now be added to the parcel layer through Manage GIS Environment (Tools > Manage GIS). After doing so, School Entities can be seen in GIS Viewer/Appraiser.
Import
108081
Fields did not populate as expected after the Appraisal Data import was performed (File > Import > Appraisal Data). The system did not handle fields that were NULL as expected; in some cases, NULL fields resulted in other fields being treated as NULL. This issue has been corrected.
Images
101366
After changing the image type, record type, and sub type, the image tree in the Images tab failed to update as expected. The update has been directed to retrieve an expanded range of IDs, correcting the issue.
Letter Processing
94091
A letter tag for Map ID has been added to the list of tags under the Property node/tree when working with a letter.
105860, 112867
A letter tag for BPP Penalty Estimate is now available; this value is current appraisal year market value times current year tax rate/1000. A query for verifying values is as follows:
select
poev.prop_id,
poev.sup_yr,
poev.sup_num,
Cast(CONVERT(DECIMAL(10,2),(sum(poev.market_val * tr.m_n_o_tax_pct + poev.market_val * tr.i_n_s_tax_pct) / 1000)) as nvarchar) AS bpp_penalty_estimate
from
prop_owner_entity_val poev (nolock)
inner join
tax_rate tr (nolock)
on
poev.sup_yr = tr.tax_rate_yr
and poev.entity_id = tr.entity_id
group by
poev.prop_id,
poev.sup_yr,
poev.sup_num
having
poev.sup_yr = @year
and poev.prop_id = @prop_id
and poev.sup_num=@sup_num
Following the 8.1.11.0019 release, this fix prevented letter tags from printing on newly created properties. This issue has been fully resolved.
Ownership Transfer
104868
An owner with multiple properties could not be added multiple times as a seller in an ownership transfer (open Property Deeds-Sales view, select ownership history and click Details, click Add in Properties section and select owner IDs). Now the property is considered in addition to the owner ID, allowing the same ID to be added more than once.
45454
While performing an ownership change, search results in the Property Ownership Wizard could not be sorted by any of the columns (from Property, open Owner-Agent view and click Change in Current Taxpayer section, then perform search and view, sort results). This oversight has been corrected, allowing sorting of results.
Property Access
111068
Land Detail Market Value did not display as expected when the Distribute appraisal method was selected. The correct value is now selected for export, resolving this issue.
Sketches
93804
After modifying the default increment size in sketchpad, the setting was lost when creating a new sketch (click the Menu button at the top left corner of the Sketch Pad window and choose Edit > Increment). The increment size is now preserved, resolving the issue.
Tax Ceiling Certificate
99405
An unexpected error occurred when generating a tax ceiling certificate for accounts with apostrophes in the account name, such as O’brien (open Property account and choose Property > Print Tax Ceiling Certificate). PACS now compensates for an issue in Crystal Reports, resolving this issue.
106007
The tax ceiling certificate could only be previewed 20 times (open Property account and choose Property > Print Tax Ceiling Certificate). Each preview opened a Windows share session; PACS did not close a session after opening it, and there is a 20 session limit. PACS now closes sessions, resolving this issue.
TIF Zone Maintenance
104129
Values on a personal property’s TIF Zone were lost during mass recalculation (open a property record and click the Prop Codes tab and, in the TIF Zone section, click Add, then, in the TIF Zone drop-down box, select the TIF zone to apply to the property record, in the Entities section, select an entity and click Details, enter the improvement value and the land value of the TIF, save and close property; then choose Activities > Recalculate Value, select All Properties and click Recalculate). The system now copies these values successfully, allowing them to be preserved after recalculation.
VIT Processing
99382
Distributed values were not copied over when a VIT Property was moved from the pending supplement group to a normal supplement group. Distributed values are now eligible for copying when a property is moved between supplements, correcting the issue.
107036
VIT sales records for years older than the previous year were not available for viewing through the Property VIT Sales tab. The system now looks for all year data available in the property’s VIT sales records in the database.
Resorting properties listed in the Mass Post Escrow Wizard – Select Properties dialog box confused links between the property being displayed and its associated data held in memory (Activities > Mass Post Escrow to Current Year Bills). As a result, if a property was removed from the list, its data might continue to display in the report while another property’s did not. This coding flaw has been corrected.
General
101579
The Create Property for Previous Year menu option (under Activities in Collections) has been changed to Copy Property Information to Another Year. This option is enabled in PACS Collections for Collections-only properties on shared sites and all properties on C sites. The Supplement Process user right must be assigned to your ID.
Letter Processing
107550
Letters could not be generated for a property using the Activities menu when the property did not exist in the current tax year (Activities > Letter Processing > Print Property Letters). A message now displays and informs the user that no record for the property ID was found in the current year.
Payment Processing
106530
Clicking Pay Q4 Amt in the Quarterly Bills view of the property record Tax Due tab loaded prior year bills in the payment cart. The prior year bill had been paid with a variance. The system now carefully filters bills and amounts due, correcting the issue.
107250
Field locations within the Quick Post (All Items) Post Payments dialog box have been rearranged to use space better (Activities > Quick Post (All Items)).
109653/ 110786
Processed check payments did not display in the Check Register Report (Activities > Quick Post (All Items); Activities > Daily Collections > Daily Check Register Report). The problem: While multiple users were processing payments, the system failed to retrieve all tender IDs–an identifier assigned to payments entered in the system. The SQL code previously used to read and update IDs has been replaced with a stored procedure, which is a more reliable, self-contained measure for data validation. Additionally, the procedure now occurs earlier during processing. But this fix resulted in voided payments being assigned only a tender ID of 0, so that each void overwrote the previous void (open the bill Transaction History view and click Details, view the Payment Info and click Void). Both issues have now been resolved.
Receipts
20114
The tender description has been added to the tax and fee receipts.
Reports
104507
An drop-down menu option allowing users to include Paid Bills, Unpaid Bills or All bills has been added to the Print Statement of Account dialog box (open property, choose Property > Statement of Account).
105433
The Adjustment Code Listing Report has been modified as follows: (1) Columns for Base Tax Due, Effective Date, and Expiration Date have been added; (2) the Statement ID has been removed; and (3) in the Adjustment Code Listing Report dialog box, the Bill Adj Code drop-down list has been replaced with a code chooser (Reports > Collections > Adjustment Code Listing Report).
112846, 112930
Generating the Delinquent Tax Roll for certain entities returned errors or a blank report (Reports > DTR > Delinquent Tax Roll Report). This issue has been resolved.
Supplement Processing
104651
A supplemental tax statement displayed the same business personal property item twice (Activities > Assessment > Supplement Functions > Supplement Statement Maintenance). The query that gathers bills on supplemental tax statements now filters inactive bills and bills with a collection status code of RS, allowing statements to generate as expected.
44464
On Collections-only systems (Type C), users can now add or remove Property Group Codes from a property in certified and uncertified years without supplementing the property.
Tax Statements
112897
Some verbiage ran off the page onto the coupon on the printed corrected tax statement for a property eligible for a quarterly payment plan (open a property in the required year and choose Property > Create New Tax Statement). The font size has been reduced to resolve this issue.
VIT Processing
112412
PACS Collections unexpectedly closed while attempting to navigate through VIT processing (Activities > VIT Processing). Properties with no bills, no amount paid, or with penalty and fines greater than the UPTV paid were not properly handled. This issue has been resolved.