LandWorks Release Notes

Pandell LandWorks 6.0.115

Released March 25, 2025

Bug Fixes

Payments

  • An issue that arose from a Microsoft change is resolved so that Payment Profiles can be launched from within a Payment (the Excel file opens or downloads correctly).

Pandell LandWorks 6.0.114

Released December 20, 2024

Bug Fixes

Other

  • Read-only users can view Depth remarks.
  • The Agreement Copy process successfully copies Payee Split.

Pandell LandWorks 6.0.113

Released September 27, 2024

Enhancements

Agreements

  • The All Tracts functionality is removed from the Cross References Agreement Maintenance screen so that each cross reference can be assigned a tract.
  • The Agreement Tract Number now allows up to 26 characters.

Bug Fixes

Other

  • Only active COA codes are available for selection in the Chart of Accounts Maintenance window.

Pandell LandWorks 6.0.110

Released April 05, 2024

Enhancements

File Import Utility

  • The Expiring Area Spreadsheet populates the county from the county code instead of the code county ID.

Pandell LandWorks 6.0.109

Released January 26, 2024

Bug Fixes

Agreements

  • Obligation Reminders handle custom one-time frequencies appropriately.

File Export Utility

  • FASB File Export no longer times out when run.

Pandell LandWorks 6.0.107

Released August 25, 2023

Enhancements

Agreements

  • If there is only one tract on the agreement, it auto-populates on the Operations tab.

Payments

  • If the “Show Past Due Payments” is not enabled, the “Payments Past Due” tab is hidden on the Check Writer.

Reporting and Forms

  • A Project search can be run using the Mailing List Report even when the PMM is not licensed.

Bug Fixes

Master Tracts

  • Users can run a Project Task Search and Master Tract Task search without breaking the Task Type drop-down for the Master Track Search.
  • An error is resolved in saving Master Tracts.

Reporting and Forms

  • The Payment Recommendations Report displays different date formats as set by the user.
  • The Legal Keys in the Municipality and Township forms display the appropriate municipal and town descriptions.

Other

  • Mass Change for Inactive Agreements appropriately calculates acres.
  • An Agreement Number can be successfully retrieved from the user interface when it exists in the database.

Pandell LandWorks 6.0.106

Released June 23, 2023

Enhancements

Project Management

  • The Select Task Model window has a default Work Order selected if there is only one available.
  • For an enabled Project Management Module, when a new project is created and saved, a Work Order is added as default and auto numbered as 1.

Reporting and Forms

  • A new Payment Recommendations Report replaces the old Payment Recommendations Spreadsheet Report.
  • The Refactor Mailing List report has the following updates:
    • A Project selection is not required to successfully run.
    • The Payors are shown appropriately on the Receivables tab.
    • All owners are displayed when run from the Master Tract search.

Bug Fixes

File Import Utility

  • The Updated Number in Owner Import Log is correct.
  • The Transform window shows appropriate row values.

Other

  • Users can sign in successfully and view multiple agreements on MapLink, even if they have associated responsible parties.
  • The Database upgrade completes successfully even if there is a large number of records.

Pandell LandWorks 6.0.105

Released April 28, 2023

Enhancements

Reporting and Forms

  • The Payment Recommendations and Payment Recommendations by Project reports replace the Ad Hoc Payment Recommendations report. These are new spreadsheet reports that run against the LandWorks transactional database instead of the LandWorks Data Warehouse. The reports are Excel spreadsheets that allow the user to sort, filter, and use the Excel sum functionality.
  • The Payments Due and Paid Summary spreadsheet reports now include a Payor and Payee Number column.

Bug Fixes

File Import Utility

  • The File Import Utility correctly handles the grantor row on the master tract.
  • The Provisions import no longer deletes an agreement suffix.
  • An error on the Payee History import job is resolved.
  • Removing the suffix on an agreement appropriately sets the value to NULL.
  • An error is resolved in the concatenation of fields that caused a blank owner number.
  • Copying Master Tract legal to an agreement no longer creates duplicate spatial IDs or resets the Map status.

Agreements

  • New remark rows are created for all tract operation rows when tracts are added to an agreement.
  • The Tract Cost / Area calculation remains the same after a save.
  • Obligation Reminders for Complete Obligations, which are assigned to inactive Responsible Parties, no longer causes a save error message.

Projects

  • The project area value is correctly handled on save and no longer rolls up.

Master Tract

  • Using the Master Track Classification appropriately links master tracts and agreements.

Reports

  • The Mailing List Report shows correct addresses.

Pandell LandWorks 6.0.104

Released February 17, 2023

Enhancements

Owners

  • The approval process for Owner Contact Remarks is now available with following features:
    • Users can request approval for Owner Contact Remarks.
    • Approvers can approve or decline Owner Contact Remarks.
    • Owner Contact Remarks can have the status of Approval Not Required, Unapproved, Sent for Approval, and Declined.
    • There are additional security permissions available for users to unlock and edit approved remarks.
    • A new Approvals Menu has two windows:
      • An Approve Contact Remarks window for an approver to approve or decline remarks.
      • A Decline Contact Remarks window for the remark owner to edit and resend remarks for approval.

Reporting and Forms

  • Two new reports display facility linkages: Facilities linked to Agreements and Facilities linked to Master Tracts.

Bug Fixes

Master Tracts

  • The Master Tract Operations tab loads with appropriate speed.
  • The Master Tract Linker operates correctly, and Smart Client no longer freezes.

Payments

  • Users can retrieve payment records for two companies without error.

Reporting and Forms

  • The Record Sheet report opens successfully.
  • The Project Summary spreadsheet populates the total annual payment and shows all relevant agreements.

Other

  • The code length allowed in the Chart of Accounts code table is the same length as in the Chart of Accounts configuration.
  • The code table has new validation that requires a Payment Use Type, which allows users to retrieve agreements by Payment Type.

Pandell LandWorks 6.0.103

Released November 23, 2022

Enhancements

Document Management System

  • Users can use a new API query to search Document IDs and delete document records.

Pandell LandWorks 6.0.102

Released October 28, 2022

Enhancements

Document Management System

  • Users can search for agreements by agreement name.

Bug Fixes

Document Management System

  • The no-encoding option can be applied to documents.

File Import Utility

  • Imports function correctly when importing rights held to the ownership row.
  • Tract Status errors are fixed.
  • Importing agreements and converting tracts to master tracts no longer generates an error.

File Export Utility

  • Clicking Add in the Change Value Transform window correctly adds the new row as selected.
  • Selecting Change Value, Transform displays the newly updated data when the FEU is closed and re-opened.

Master Tract

  • The Master Tract Grantor in the Link Wizard Ownership Row displays the correct data.

Reports

  • The Report Installer installs the correct Expiring Area Spreadsheet for Mining clients.

Other

  • The County Code value is updated for Ste. Genevieve County, MO.

Pandell LandWorks 6.0.101

Released September 16, 2022

Enhancements

Other

  • Outdated County Code values are updated.

Bug Fixes

File Import Utility

  • Master Tract status updates correctly.
  • An Agreement's Master Tract link job no longer fails.

Pandell LandWorks 6.0.100

Released August 05, 2022

Enhancements

File Import Utility

  • MT Import is requiring codes for some columns instead of allowing descriptions.

Other

  • New URL encoding options are available in the DMS runner. The "Legacy" option displays by default.
  • Bank Accounts can only be deleted if they are not in use in the system (for payments etc.).
  • GIS Toolset Configuration is consolidated into one place.

Bug Fixes

File Import Utility

  • Line Tract Number maps as expected.
  • Tax District data imports correctly.

Master Tract

  • The Primary Contact flag is mappable on the ownership table for the master tract import.
  • Master tract import handles selecting the Area Unit of Measure Description instead of Code.
  • Import of the master tract status functions correctly.
  • The master tract loader automatically applies the auto-number suffix.

Pandell LandWorks 6.0.99

Released July 08, 2022

Enhancements

Payments

  • Messages indicating multiple production payments are suppressed until either a recoupment or true-up is added.
  • Read-only users can view payment profiles.

Master Tract

  • Using the Master Tract link wizard, users have the option to select which legals/depths to copy from the Master Tract to an Agreement.

Bug Fixes

Master Tract

  • Searching in the Master Tract grid refreshes the Inactive Reasons field when a new search is applied.
  • The Tract-Owned flag defaults to "Y" for new grantors added to a Master Tract.

Other

  • Improved speed and efficiency is enabled for Task Model Layers.
  • Autonumbering references the Start Value found in the Autonumber Configuration for an Agreement.
  • The Agreements Record Sheets report generates in Chrome.

Pandell LandWorks 6.0.98

Released May 27, 2022

Enhancements

Payments

  • Check Writer has an enhancement for file export utility.
  • Payor bank account is no longer required for check writer.

Bug Fixes

File Import Utility

  • FIU respects the default mapping levels.

Master Tract

  • When creating an owner with an owner address using the master tract loader, an address type is hard coded to the owner.
  • Updating the Tract Status correctly triggers the Last Update Date/Name on the Master Tract Tracts tab.

Pandell LandWorks 6.0.97

Released May 06, 2022

Enhancements

Other

  • Contact Manager and Task Manager mobile apps are now removed.

Bug Fixes

Master Tract

  • The summary report no longer generates an error when a provision is not selected.

Pandell LandWorks 6.0.96

Released April 08, 2022

Enhancements

File Import Utility

  • Log entries are improved.

File Export Utility

  • A not-equals option is available in the change transform window.

Payments

  • The system validates that the sum of the payee amounts equals the payment amount, even when no account string is present.

Other

  • LandWorks data warehouse updates are optimized.

Bug Fixes

File Import Utility

  • Master Tract numbers greater than 15 Characters are no longer truncated during import.
  • Cost unit of measurement calculates after the agreement import.

Master Tracts

  • Creating a new Master Tract allows for a number length greater than 15 characters.
  • When Project Management is off, the Master Tract search does not display projects.
  • The label for the field on the Master Tract Legal Level Mapping Statistics report correctly displays Tracts to Include.

Payments

  • Payment Obligation upgrade tasks no longer cause timeout errors.

Pandell LandWorks 6.0.95

Released March 04, 2022

Enhancements

Other

  • Payment Obligations are removed.

Pandell LandWorks 6.0.94

Released February 04, 2022

Enhancements

File Import Utility

  • Consideration Costs load.
  • Tract Detail left and right row widths are improved.
  • The log output provides an agreement number in addition to agreement ID.

Bug Fixes

File Import Utility

  • Consideration Costs no longer disappear upon saving.
  • Logging messages are correctly written to file.
  • Delete flag functions correctly for the owner import.
  • Subdivision and Subdivision Lot are supported for import.
  • Duplicate master tract-owned operation rows on agreement and master tract imports are prohibited.

File Export Utility

  • Batch records create correctly for check writer.

Master Tract

  • Certain fields inside the Master Tract Maintenance Tracts tab correctly trigger the change tract detail function.
  • When adding a new production row to a new master tract, the row no longer disappears on save.

Payments

  • The bank drop down on the check writer works correctly.
  • Generating a new wind payment row correctly adds it to the profile spreadsheet.
  • Users can deselect the payments generated flag providing an agreement has prod payment on another tract.

Reports

  • The COA Verification report no longer overstates the allocation percent.

Other

  • For Coal, the Period End displayed in the Summary tab no longer includes time with the ending date.
  • The coal reporting date displays correctly.
  • Combining forms into one document no longer inserts a section break instead of a page break.
  • The Easement field no longer allows entry of 3 decimal places.
  • Owner auto numbering functions correctly.
  • Contact confidential remarks displays correctly even if the user who created the remark is removed.
  • The True Up process looks at the production start/end dates.
  • Gross Less Overlap Acres, found on forms, are displayed correctly for all agreements.

Pandell LandWorks 6.0.93

Released December 03, 2021

Bug Fixes

Agreements

  • The Agreement tracts tab no longer shows multiples of a facility when there is only one.

Reports

  • Excel reports no longer display decimal values as date/times.

Other

  • Lump Sum Frequency is removed from the Code Table.

Pandell LandWorks 6.0.92

Released October 15, 2021

Enhancements

File Export Utility

  • Payment custom values and payment variables are supported.

Other

  • Customer Support links display in the LandWorks Help menu.

Bug Fixes

Other

  • Auto numbering logic is no longer different for Master Tracts and Agreements.
  • When the latest payee history row for an owner is voided, the payee history button remains enabled in the owner search.

Pandell LandWorks 6.0.91

Released September 17, 2021

  • New Feature - Users can now access all our support site resources! Check out our manuals, tip sheets, and more!

Enhancements

Payments

  • Check writer only writes remarks with a type of "Pay" to the LW_PAYEE_HISTORY.

Other

  • A sort order is now available for the agreement type code table.
  • Users now have full access to the suppport site resources including FAQs, manuals, tip sheets, videos, and more. To access these resources, simply go to the Help menu in LandWorks!

Bug Fixes

Payments

  • Payment Obligation reminders are no longer emailed to inactive responsible parties.
  • On the Payments Due and Paid Spreadsheet, the Payment Due Date displays all of the months.
  • Receivable remarks are written to the payee history (when their remark type is not "Pay").

File Import Utility

  • FIU no longer freezes when a log location is not found.
  • Errors log correctly when a coal import fails.
  • Coal Production is changed to Mining Production.

File Export Utility

  • Spaces are no longer lost when a job is exported/imported.
  • An Agreement Change job correctly picks-up modified records.

Coal

  • Users can regenerate a payment when the payments generated flag is set.

Mining

  • Validation occurs for a project that is linked when selecting a coal seam.
  • Data sorts by descending date.

Other

  • Advance royalty and agreement participation are populated correctly and raw tons is correctly reduced.
  • When an effective date is entered for mass change owners, the interest type displays correctly on the new ownership row.

Pandell LandWorks 6.0.90

Released August 13, 2021

Enhancements

Other

  • Web applications will not perform a database upgrade if a version mismatch is identified.

Bug Fixes

File Import Utility

  • An error on the payee history is now resolved.

Coal

  • Configuration of the Payments Generated Date and Flag values are prohibited in the Mineral Production (summary).
  • Re-labeling attributes in the Mineral display works correctly.
  • Re-labeling the following fields in the Mineral display no longer re-labels them in the Details tab: Black Lung, AML, Coal Acre-Feet.
  • Changing the Other Fee label of the Mineral Display Detail and Mineral Display no longer also changes the Plant label.

Other

  • For User Security Roles with Agreement Search maintenance, the Mass Change role is no longer grayed out.

Pandell LandWorks 6.0.89

Released July 16, 2021

Bug Fixes

Payments

  • Users can only generate mining payments when profiles are attached.
  • New FASB transactions function correctly.

File Export Utility

  • The data job runs, even when agreements are on file as a deleted agreement.
  • Adding a receivable no longer triggers an agreement on the FASB File.

Master Tracts

  • The Master Tract Append Result search function works correctly.
  • Master Tract Mass Change is no longer grayed out when there is a Mass Change Assign Security Permission role assigned to the active user.

Project Management

  • If PMM is disabled, the Task Model search fields are inactive.

Other

  • Creating a user security role functions correctly.
  • Change tracking being turned off without deselecting the attributes functions correctly.

Pandell LandWorks 6.0.88

Released June 18, 2021

Enhancements

Payments

  • Sum tract data functionality is removed.

File Export Utility

  • The query selection window is suppressed on manual batch runs.

Master Tracts

  • The 100% cap on agreement participation for Coal is now removed.

Bug Fixes

Agreements

  • Tract Area Summaries are now correct for inactive agreements and tracts where calc acres are not selected - net and company net not calculated (Agreement-Only).
  • The Payment tab of agreements no longer generates an error when clearing out bank accounts.

File Export Utility

  • The email print notification option is removed from the schedule window.

File Import Utility

  • File location is once again accessible to users on a remote application.

Master Tracts

  • Email notifications for master tract tasks due work correctly.

Other

  • Creating and saving a new facility no longer causes the created-by to change from the user to "Not Set".
  • With inactive grantee rows for FASB, the internal company amount is no longer overstated.
  • Mining load no longer returns a SetTransaction error.
  • The named ranges for coal, IN_DETAIL_PLANT and IN_DETAIL_COAL_ACRE_FEET, pass correctly to the spreadsheet.

Pandell LandWorks 6.0.87

Released May 14, 2021

Enhancements

File Export Utility

  • Manual batch jobs use the query saved with the batch.
  • IFRS Payee Change: an Export button on the Payee tab calls the FEU.

Administration

  • Deletion is prevented for admin roles and users.

Other

  • Performance improvements are available across the system.

Bug Fixes

File Export Utility

  • Payor company codes are correctly referenced.
  • A Payment Description using a Delimiter Transform Job no longer throws an error.
  • LW_PAYEE_HISTORY.BANK_ACCOUNT_ID column link transform to LW_BANK_ACCOUNT.IBAN functions correctly.
  • Payee Change Event no longer repeats tables in the Data Source.

Pandell LandWorks 6.0.86

Released April 28, 2021

Bug Fixes

File Export Utility

  • The IFRS email sends correctly if no payees are found.

Reporting and Forms

  • The Tract number is available on forms.

Other

  • Mass Change Account Strings correctly update the Payee Split field.
  • Changes made to the Search Grid Column Defaults are correctly saved.

Pandell LandWorks 6.0.85

Released April 09, 2021

Enhancements

Payments

  • Invoice number and invoice date fields are available on the Payee tab.

File Export Utility

  • Invoice number and invoice date fields are available for FEU.
  • IFRS Vendor Information is enhanced.

Other

  • Address 1 and 2 have separate fields in the Data Warehouse.
  • The length of the IBAN field for bank accounts is increased.

Bug Fixes

Payments

  • Inactive owners are no longer pulled into the payee list on the payment tab when Get Owners is selected.

File Export Utility

  • Deleting an FEU job no longer causes Landworks to throw an error.

Other

  • The Next-In-Line Task Email notification no longer throws an exception.
  • The inner exception is corrected when using Mass Change Calculation Profiles.
  • An error no longer occurs when GIS is not licensed for certain Wind clients.

Pandell LandWorks 6.0.84

Released March 12, 2021

Enhancements

Reporting and Forms

  • Forms perform more efficiently.
  • A new Payment Recommendation report is available.

Payments

  • New Mining and Wind rules are in place for copying agreements with production payments.

Bug Fixes

Agreements

  • Opening and closing the Get Model on the Agreements, Provision tab, no longer causes the window to delay reopening.
  • Responsible Parties in the code table can be deactivated if they are assigned in a Agreement.

Master Tracts

  • Opening and closing the Get Model on the Master Tract and Projects Task tabs, no longer causes the window to delay reopening.

Payments

  • Payee and Account balancing routines correctly distributes pennies across multiple payees, starting with the largest.

Other

  • Users can override owner and owner address numbers.
  • String or binary data no longer generates a truncated error when saving changes to stage configuration.
  • The Sales Delete Message is changed to "LandWorks" instead of "Lpm".

Pandell LandWorks 6.0.83

Released February 09, 2021

Enhancements

Master Tracts

  • A Task Status field is available.
  • The Task, Priority search field is removed.
  • The Spatial Update Search fields are moved to the Spatial Search tab.
  • The Last Update and Spatial search fields are removed from the Changes tab.
  • The Task Model Status search option is available in the General Tab and Project Search, General Tab.
  • The Geographic tab label is changed to Legal.

Reporting and Forms

  • An Owner Contact report is available.

Other

  • DMS values that do not pass through the DMS call are no longer assigned a null value, but instead create a new document row as expected.
  • Project tasks have a new Task Status field.
  • The Task, Priority search field is removed from Project search.
  • The Override Date Field is hidden in Checkwriter.
  • The owner bank account field is increased in length.

Bug Fixes

Agreements

  • The Owner search criteria no longer clears when selecting another tab.

Payments

  • In the Payment Check Writer, selecting Show Past Due Payments correctly excludes Excluded Payments.
  • The Checkwriter Footer displays correct information.
  • When payment with a special handling are copied and changed, the withhold amount no longer reverts to $0.

Master Tracts

  • Tract Assignments on two sided agreement cross references save correctly.
  • In the Master Tract and Project Maint Task tabs, after de-selecting the checkbox and saving, the checkbox no longer re-selects and sends an email.

File Export Utility

  • Transform on document type to grab description functions correctly.
  • When owner addresses are added to a payment after payees are added, FEU can still grab the owner country.
  • The FEU file no longer outputs the invoice date for voided invoices instead of active invoices.
  • The FEU Invoice Date field in Payee History pulls the invoice date for the payment from Invoice History.

File Import Utility

  • Projects no longer error on payment classification imports.

Invoices

  • The Invoice Writer Search time-out error is resolved.
  • The Invoice Writer footer shows the correct results.

Reporting and Forms

  • Exhibit A Spreadsheet report no longer repeats rows.
  • The Invoice History form correctly runs from the invoice writer.
  • Forms display the tract number.

Other

  • Saved queries work after a refresh.
  • LandWorks allows display configuration changes to the Mineral Production/Mineral Detail Attributes.
  • Depth filters on dissection correctly filter on all tracts.
  • Users are no longer able to open multiple windows for the same owner.
  • European Date format no longer displays as US Date Format in Forms when the day is 1 through 12.
  • Multi select in search fields no longer shows last highlighted row, unless selected.

Pandell LandWorks 6.0.82

Released December 02, 2020

Enhancements

Agreements

  • The Spatial Tab of an agreement search displays rebranding for the choice of Polygon Source.

Payments

  • A routing number to depository dropdown is available in Payments and Receivables.
  • A routing number to payor bank account dropdown is available in Payments.
  • Payments display the latest invoice for a selected payee.

Reporting and Forms

  • The Reprint button is removed from the Invoice Register form.
  • VAT, VAT Amt, TMP columns are available in the Payments Due and Paid Report.

Invoices

  • Users can create invoices by Payor, Payee, and Agreement Number in the payment writer.

Other

  • An error message indicates when an owner doesn't have a primary address type.
  • A warning indicates that 1099 Owners must have US Address.
  • The owner bank account relation flex fields are moved to UI.
  • Wind and mining template rows cannot be deleted once payments are generated.

Bug Fixes

Agreements

  • The Profile Name search field is no longer missing from the Agreement search.
  • When a tract is inactive, the gross and overlap acres are no longer editable.
  • The Last Update Date and Last Update By fields are removed from the Project search.
  • The Last Update Date and Last Update By fields are removed from the Owner search.
  • Owner search grid columns are relabeled.
  • Agreements no longer fail when there are more than 2100 records in a Project search.
  • Linking Agreements to Cross Reference in Mass Change is correctly uniform on the Agreement Level.
  • Spatial filters correctly filter Agreement search results based on Legal selection.
  • The "Polygon Source" criteria no longer disregards the mapping level specified by "Check Mapping Status at" for an Agreement search.

Master Tracts

  • Correct validation messages display for a Master Tract number if a user tries to set the number length to 26 and still add a suffix.
  • Wheelage is changed to Other Production.
  • The Cross Reference All tract number count correctly adds-up.
  • State/County for Master Tract/Project Search Documents correctly re label when the selected country is Canada.
  • Project References are no longer missing.

File Export Utility

  • FEU handles payee reference data that looks like a date as a direct copy of that date.
  • Formatted Legals are found in the FEU file.
  • Change Value Transform Fields no longer crash on a save.
  • Tract Numbers are correctly copied for Documents and Legals.

Payments

  • The next payment due date calculates correctly.
  • The Payee fields display correct values in the Payments Due and Paid Spreadsheet.
  • Generating wind payments no longer requires multiple saves.

Reporting and Forms

  • The Agreement Summary report shows all facilities from the Agreement.
  • The Master Tract Summary report no longer generates a 500 error.
  • The Owner Mailing List report is removed from the Report Tester tool.
  • When selecting Print All Record Sheets, on the Record Sheet report screen, the report no longer generates a 500 error.
  • Keys are in place for the Agreement Conveyance Table in forms.
  • Save as File Type correctly populates in Excel reports.
  • Forms run from the reports window after checks are printed.
  • Detailed Obligation Due Report- Facility are only listed for agreements with a facility.

Invoices

  • When viewing an invoice, the Save label is changed to Save to File.
  • The Invoice Writer correctly pulls in payments.
  • The Invoice Writer correctly pulls in perpetual payments.
  • The Check Amount Label on the View Invoice Window is changed to Net Amt.

Other

  • Selecting the Restore System Defaults button no longer generates an error.
  • The last update date and last update by date are now hidden in Program Options.
  • Stage Change email notifications are sent to the correct users.
  • The DMS token works as intended for Hosted Clients.
  • A warning message displays when the 1099 flag is selected in Owner Maintenance when the owner does not have an address on file.
  • Users can edit Subject and Message for Obligation, Payment, and Void Payment notifications.

Pandell LandWorks 6.0.81

Released September 25, 2020

Enhancements

Agreements

  • The spatial update date and update by fields are moved to the Spatial tab in an agreement search.
  • The system does not auto-add a revenue owner when adding a cost share owner.

Master Tracts

  • Updates to the Master Tract Link Wizard:
    • Operations link when linking additional agreements to a master tract.
    • Tract rows are removed from the wizard.
    • Master tract grantors are available in the conveyance table.
    • Sales points are not linked to agreements.
    • Agmt No. and MT No. are available in the header pane.
    • More information is available on display for the agreement documents.
    • MT-owned leasehold/term grantor rows are not displayed.

Other

  • Users can populate the Agreement Grantor and Grantee fields in the Document Management System.
  • New fields are added to the data wearhouse.

Bug Fixes

Master Tracts

  • Using the Create MT button copies over the Agmt Tract Gross Acres into the newly created MT.

File Export Utility

  • Fixed-width FEU files no longer ignore constants that are spaces.

Other

  • Searching for documents using "do not contain" correctly returns all results.
  • When selecting multiple facilities, remarks are disabled.

Pandell LandWorks 6.0.80

Released August 31, 2020

  • New Feature - LandWorks is pleased to offer a new Excel-based reporting framework!

Enhancements

Reporting and Forms

  • Create custom reports using our new Excel Reporting framework! Reports formatted using pivot tables are easily uploaded back to LandWorks as a new report, which your organization can use on a regular basis.

Bug Fixes

Agreements

  • Owner Contact Remark "Assigned To" user list excludes inactive users.
  • When the tract number is changed to "All", Agmt Cross Reference number counts remain correct.

Master Tracts

  • In the Link Wizard, when select all and complete links are chosen, users can still deselect options.

Link Tools

  • Vendor import job no longer fails on the state description.
  • Vendor import job no longer deletes records.

Reporting and Forms

  • Users can run reports (before processing) on a selected number of records in Checkwriter.

Pandell LandWorks 6.0.79

Released August 11, 2020

Enhancements

File Import Utility

  • The number of characters allowed for legal remarks is increased.
  • Users have the option to not change the payment recommendation on the payment tab when issuing a void.

Other

  • Kilovolts are available as a default unit of measure.

Bug Fixes

Payments

  • When escalating a payment with a special handling tax amount, the withholding is correctly subtracted after escalating.
  • Escalations no longer round down when they should be rounding up.
  • Payment accounts with multiple strings round pennies correctly.

Master Tracts

  • The create master tract button correctly links agreement operations to the master tract.
  • There are no longer hidden/incomplete owners on the master tract owners tab after linking to agreement.

File Import Utility

  • When a job using a header key or row number is exported/imported, the header key or row numbers no longer have to be re-entered.
  • Database import configuration correctly retrieves data.

Reporting and Forms

  • The line list report pulls the correct value for cost-per-rod.

Other

  • The expiring area spreadsheet generates with a provision.
  • Completing an existing task no longer sends a new task email.
  • The read only role no longer allows the ability to run forms as an editor role in LandWorks.
  • The read only role is visible in the role configuration screen.
  • A script no longer deletes the ACR payment type code.

Pandell LandWorks 6.0.78

Released July 17, 2020

Enhancements

Other

  • Escalation fields are available for indexed escalations.

Bug Fixes

Agreements

  • The Agreement link in an owner search correctly pulls active and inactive agreements.
  • The Agreement link in a project search correctly pulls back active and inactive agreements.
  • Searching for agreements by changes correctly returns results.
  • The Changes Made By and Date Changed fields/checkboxes are removed from the Agreement Search, Changes tab.
  • An Operations checkbox is added to the Agreement Search, Changes tab.

Master Tracts

  • The Tract filter on agreement maintenance correctly enables after selection of a first field.
  • In a facility search, the master tract link correctly retrieves inactive master tracts.
  • In a project search, the master tract link correctly retrieves inactive master tracts.
  • In an owner search, the master tract link correctly retrieves inactive master tracts.
  • Users can link a master tract to an agreement, and vise versa, if the agreement grantor isn't already on the master tract.

File Export Utility

  • The file export utility is no longer missing from deleted agreements.

Reporting and Forms

  • The task list report from the project search screen is no longer duplicating rows.
  • The record sheet report pulls in all legal entries.
  • The record sheet report displays grantors correctly.
  • The record sheet report pulls in all provisions.

Other

  • Users can delete a dashboard even if it is the only one made.
  • Dashboards only show at start up if designated to do so.
  • Inactivating a code in the code table no longer removes it from drop down in the search window.
  • Legals is no longer missing from the Map Type option for configuration.
  • Indexed checkbox, grid item, and payment forecast link are removed from escalations.
  • Auto-escalations is removed from the check writer.
  • AGMT_ID to LW_PAYMENT_ACCOUNTS, LW_DEPTH_DETAILS, LW_STATIONING is available in change tracking.
  • CAGMT_ID to LW_TRACT_LEVEL is available in change tracking.
  • Change tracking correctly grabs the second side of a 2-sided cross reference.
  • An escalation occurring to a payment correctly triggers a file change for FASB.

Pandell LandWorks 6.0.77

Released June 02, 2020

Enhancements

Master Tracts

  • The "Load Master Tract to LPM" button is renamed to "Load Master Tract to LandWorks".

File Export Utility

  • Account string segments are included in the export utility.

Other

  • Rebranding is seen in the Task Manager, and Contact Manager.
  • Icons are updated for Pandell LandWorks.
  • Type is available in the mass change escalations grid.
  • All depth column changes may be captured for re-dissection.

Bug Fixes

Payments

  • Copying a payment, correctly copies the address over to the historical payment.
  • The payment forecast no longer doubles for one time payments.
  • A FASB job correctly fires when the COA string is updated on an agreement payment.
  • The escalation stored procedure does not escalate for specific payment types.

Master Tracts

  • The locking error is resolved when copying master tracts.
  • The expiring area spreadsheet for master tracts no longer requires the provision type.

File Import Utility

  • Stage codes are correctly set on imported agreements.

File Export Utility

  • Payee addresses are placed in alphabetic order.
  • Schedule creep for jobs is addressed.

Reporting and Forms

  • The Obligation spreadsheet shows remarks on all frequencies for an obligation.

Other

  • Reminder emails display the correct dates.
  • The last update field updates correctly for changed agreements.
  • Default remark types are marked as such.
  • Login errors are written to the log file.
  • Effective dates for a responsible party are maintained when saving.
  • The Record sheet correctly displays tract information.
  • Mass change escalations no longer encounter errors when starting a transaction.
  • Escalate now doe not look at auto-escalations.
  • Scripts and calendar processes avoid using auto-escalations.
  • The default LW_ESCALATION.INDEXED_BASED_FLAG is set to Y.

Pandell LandWorks 6.0.76

Released April 13, 2020

  • New Feature - LandWorks displays new Pandell branding!

Enhancements

General

  • LandWorks has new branding:
    • The smart client icon is replaced by the Pandell LandWorks icon.
    • Windows display a Pandell footer.
    • References to LPM are replaced with LandWorks or Pandell.

File Export Utility

  • The Obligations table displays Agreement Change events.
  • Agreement Change events output all payee address information.

Other

  • Term and Term UOM fields are available in the Agreement tab.

Bug Fixes

Master Tracts

  • Expiring Area Spreadsheet launches and returns data.
  • Master Tract Doc file paths are manually editable.

File Import Utility

  • Linked Cost Owner displays in the ownership table on the agreement classification.

File Export Utility

  • Email Options are present inside the FEU Batch Schedule.

Reporting and Forms

  • The Report Tester works as expected when selecting Mining (MT, GIS) in report setup.
  • The Project Summary Spreadsheet launches and returns data.

Other

  • Agreement Obligation number count is consistent when the tract number is switched to All Tracts.
  • The Number count functions the same as the other Agreement Maintenance tab.
  • The Smart Client error message no longer displays sensitive information.
  • Users can select Well Data, Linear, Point, or Inactive, from code tables and save without any issues.
  • LandWorks Smart Client no longer runs a sync task when users log in.

Pandell LandWorks 6.0.75

Released March 26, 2020

Enhancements

File Import Utility

  • The column limit on imported files is increased from 150 to 250.

Other

  • Reminders for Owner Contact follow-up are available.

Bug Fixes

Master Tracts

  • The Document button (Document tab) correctly links the document.

File Import Utility

  • Remarks correctly import over to LandWorks.

Reporting and Forms

  • Legals in the Exhibit A Report sort in the correct order.
  • The Project name populates in the Acreage Summary by Tract Status widget.
  • Expiring Area Spreadsheet populates the Tract Overlap and Tract Gross Less Overlap Acres.

Other

  • Creating and saving a new Country/Meridian Relations in the State of Northern Gulf of Mexico no longer causes records to disappear from the code table.

Pandell LandWorks 6.0.74

Released March 10, 2020

Bug Fixes

Payments

  • Checkwriter correctly displays escalated amounts for indexed escalations.
  • Checkwriter no longer sets payments with indexed escalations back to the original amount after checks are printed.

Reporting and Forms

  • Date issues with Wind Record Sheets Reports are now fixed.
  • Acreage Summary by State Report includes agreements with no internal companies assigned.

Other

  • Agreement_Tract.Cod_Date is no longer missing from Data Warehouse.
  • When a new group code is added to the group code table, the screen set is locked down after the code is saved.

Pandell LandWorks 6.0.73

Released February 21, 2020

Bug Fixes

Payments

  • Production payment processes correctly stack rows in the spreadsheet report.

File Import Utility

  • The job correctly parses out the legals from the spreadsheet to the agreement.

Other

  • The LandWorks "Starts with" User Map option no longer throws an error upon launch.

Pandell LandWorks 6.0.72

Released February 07, 2020

Bug Fixes

Payments

  • Checkwriter processes payments correctly.

Reporting and Forms

  • Master Tracts and Project Adhoc Reports launch successfully.

Other

  • References to "LandWorks Inc" are replaced with "Pandell".
  • All tracts cross reference numbers and descriptions no longer change when updating tract names and numbers.

Pandell LandWorks 6.0.71

Released January 21, 2020

Bug Fixes

File Import Utility

  • There are no longer fewer columns in the INSERT statement than values specified in the VALUES clause.

Reporting and Forms

  • The error message "The given key was not present in the dictionary." no longer displays when launching forms.
  • Launching spreadsheet reports for On-Prem functions correctly.

Pandell LandWorks 6.0.70

Released January 09, 2020

Enhancements

File Import Utility

  • Payee History and FIU Transaction classifications are merged and FIU Transaction is no longer available.

Other

  • Data warehouse load time is optimized.
  • Document Management System (DMS) clears the document URL with a delete option.

Bug Fixes

Payments

  • Time out message after escalations is added back.
  • If payment is in a Calendar, the Pay Rec should is 'Approval Required'.

File Import Utility

  • Expiration date displays correctly on a tract after import.
  • Costs roll-up to the agreement level.
  • Updates made to handle EXCEPT, BELOW, or ABOVE.
  • Agreement Name displays correctly on the Agreement table.
  • If a facility does not exist, the log no longer indicates a successful import.
  • The Facility Not Found Message is an exception.
  • Wind and Sales Email Logs display correct line breaks.
  • FIU no longer throws the "Import Did Not complete successfully" error.

Reporting and Forms

  • When attempting to launch forms users no longer get an error message saying invalid report path.
  • Hosted clients can schedule Batch Reports.
  • Payment Due and Paid Sheet report no longer crashes when run as a batch report.
  • During report setup, built-in forms cannot be edited or deleted.

Wind

  • A list of Named Ranges displays correctly.

Other

  • Multiple payees no longer results in indexed escalations adding rounded pennies to the payee that does not have the largest percentage.
  • The FK Constraint on an Address ID (when defaulting owner name on conveyance table) is now fixed.
  • Splash screen options are removed from Configuration - Program Options - UI Options.

Pandell LandWorks 6.0.69

Released November 14, 2019

Enhancements

File Import Utility

  • Revenue Deck Import is now supported!

File Export Utility

  • FEU uses Owners from the Revenue Share tab.

Bug Fixes

Agreements

  • Creating a new agreement no longer generates an error.

File Import Utility

  • The county populates correctly upon import for legals.
  • Agreement imports no longer create too many legals.
  • Legal remarks display correctly.
  • The correct county code is used.

Reporting and Forms

  • The Record Sheet report generates data.
  • The Record Sheet report shows both of the two cross references.
  • The Acreage Summary by State report no longer throws a "500 error" upon generation.

Pandell LandWorks 6.0.68

Released October 24, 2019

  • New Feature - Deployment, configuration, and performance of reports is improved!
  • New Feature - The login screen has a new look!
  • New Feature - .Net Framework 4.8 compatibility is available!

Enhancements

Reporting and Forms

  • Reports are streamlined to improve deployment, configuration and performance.

Other

  • Additional database related checks prior to an installation / upgrade ensure the database is in good working order.
  • The login screen is redesigned.
  • LandWorks is compatible with .NET Framework 4.8.

Bug Fixes

Payments

  • Escalations for CheckWriter payments are supported.
  • The Escalations rounding issue with multiple payees and an odd original amount is now fixed.
  • The CheckWriter rounding issue with an odd original amount is now fixed.

File Import Utility

  • Mapping is available for obligation emails.
  • Importing documents functions correctly.
  • Agreement imports correctly convert from a character string for operations.
  • Legal Parse Routine Failures are corrected.

Other

  • Cross Reference data issues are resolved.

Pandell LandWorks 6.0.67

Released October 02, 2019

Enhancements

File Import Utility

  • The Change log outputs exceptions when email is not selected.
  • Only valid data connection options are shown.

Bug Fixes

File Export Utility

  • The Positional Parsing Transform is resolved.
  • The reference description error is now corrected.
  • The correct minimum pay is used when payee is on more than one prod payment for the agreement.

Other

  • The Tract spatial view owner (grantor) rule changes are correct.
  • Document Management System (DMS) APIs are accessible.
  • Document Management System (DMS) SOAP APIs are accessible.

Pandell LandWorks 6.0.66

Released September 18, 2019

Enhancements

Other

  • LW_IMPORT_SETUP_CONFIG.CONFIG_VALUE is updated to varchar(max).

Pandell LandWorks 6.0.65

Released September 04, 2019

Bug Fixes

General

  • MT Search - Task Tab and Project Search Task Status and Priority fields are no longer missing.
  • Admin account correctly prompts users to change password upon initial log-in.

Reporting and Forms

  • RATE_PER_UNIT is grabbed for True Ups.
  • Custom Report: Filtered Tract "Tract Acres by County" no longer overstates acreage.
  • On the Payment Batch Spreadsheet the Payment Amount total displays at the bottom of the worksheet.

Pandell LandWorks 6.0.64

Released August 28, 2019

Bug Fixes

General

  • In Configuration - Change Tracking, the scroll bar under Tracking Attributes displays correctly for Track All Changes.
  • Users receive email reminders.
  • When View Confidential Owner Contact Remarks security role is not selected the owners search screen still displays data.
  • ALLOCATED_SALES value is correct.
  • Updates are in place for LW_CODE_NAMED_RANGES.
  • The value LW_PRODUCTION_CHECK_DATA.GENERATED_UNITS is now a decimal of size 15,4.
  • ALLOCATED_SALES value is correct for True Ups.
  • TURBINE_COUNT is recognized for True Ups.
  • Newly entered formations are being committed to the database.
  • In the project search, there is no longer a value error when searching by survey / abstract where one value is null.

Master Tracts

  • In the master tract search, there is no longer a value error when searching by survey / abstract where one value is null.

Payments

  • The depository drop-down populates correctly for Agreement Payments.
  • When selecting projects for processing payments, users can select multiples at once.
  • The message in Agreement Payments is updated for when the named range is reserved for Wind.

Reporting and Forms

  • Close button is removed as it was only refreshing the window in Chrome, rather than closing it.
  • Read Only users can generate forms.

Agreements

  • In the agreement search, there is no longer a value error when searching by survey / abstract where one value is null.

Other

  • Spot A Point returns the same distance as Buffer tool.

Pandell LandWorks 6.0.63

Released July 31, 2019

Enhancements

Master Tracts

  • The default sorting order on the Wind Sale tab is changed from ascending to descending.
  • The default sorting order on the Wind Production tab is changed from ascending to descending.

Facilities

  • The default sorting order on the Production window is changed from ascending to descending.

DMS Runner

  • New DMS Service - Agreement exists.
  • New DMS Service - record changes.

Bug Fixes

Dashboards

  • Dashboard widgets are updated for Acreage Summary by State, Acreage Summary by Tract Status, and Active Agreements by Project Bar Charts.

Payments

  • Number of decimals for Payment output columns is changed from 3 to 2 to be consistent with the application.
  • Agreement Maintenance Payment tab no longer crashes when selecting a payee with a null name ID.
  • Payment History window sorts by due date.
  • Next payment due date now calculates correctly, even if at the end of the month.
  • Check writer timeout issues are addressed. Numerous checks print correctly in one run.
  • Agreement Payments no longer throw an LPM.NET error when clearing the payment type.

Reporting and Forms

  • Mapping Status Report - the Tract remarks correctly pull from each individual tract.
  • Record Sheet report - all legals are pulled when running on an agreement with multiple legals.
  • Record Sheets - launching reports no longer generates a 500 error.
  • The previous issues with certain reports opening with no or partial data, or generating a 500 error when created, are now fixed.

Agreements

  • Payment tab sorts correctly.

DMS Runner

  • The generated URL contains the agreement number.

Other

  • Chrome is supported, in addition to Internet Explorer.
  • Task Manager no longer crashes when editing a task.
  • Landworks Help launches correctly.
  • Tract Tab MapView Window Displays Preview and MapNow Buttons.
  • Saving owner name change functions correctly.

Pandell LandWorks 6.0.0

Released July 01, 2018

Enhancements

General

  • MT/Agmt Linking Wizard simplifies linking master tracts and agreements.
    • Streamlines linking into a single process.
    • Facilitates linking grantors/lessors, grantees/lessees, operations, documents, payments, and cross references.
    • Clear summary of desired linking provided before finalizing any changes.
  • Upgrade to LPM login gives users the option to start their LPM experience in the MapLink map or in the LPM land records data.
  • New Partner Invoicing Module facilitates invoicing partners for their share of payments.
    • All-new module provides the ability to allocate a share of any payment type to a tract and also divide that share among the lessees in the tract.
    • An invoice can then be generated to each lessee for their share of the payment.
    • LPM Receivables module can be used to track the payment of each invoice.
  • LandWorks Software Installer simplifies and automates the upgrade process.
  • LPM Search screens allow multi-select in drop-downs, enabling users to do combination searches without appending search results and also do exclusion searches, such as “all records in Texas except Grimes County”.

Check Register

  • Users can now search the Check Register by check number.

Code Tables

  • Code table entries can now be made inactive so that they cannot be selected in drop-downs on any new records.
  • Tract Status code table is split into Agreement Tract Status and Master Tract Status to enable users to separate the statuses of each type of tract.

Dashboards

  • My LPM provides users with at a glance status updates on the land rights and projects for which they are responsible in one easy-to-access dashboard.
    • This customizable dashboard can float outside of the main LPM window for easy reference.
    • Esri integration delivers live maps.
  • Dashboards can be configured with a browse widget to limit the widgets on the dashboard to a specific project.

Reporting and Forms

  • New Payments Due and Paid report shows all payments due for a date range and the Print Date if they were paid.
  • New standard Receivable Variance report shows receivables due, whether payment was received, and the difference between the expected amount and the amount received.
  • Master Tract and Project Task List reports now have columns for Task Remarks and Task Model.
  • Master Tract Line List report now has columns for Task Model and Task Model Status.
  • Master Tract Summary report now has columns for Task Model and Task Model Status.

Agreements

  • Agreement Grantor/Lessor and Grantee/Lessee fields now support manual entry or selection from Owner Maintenance of more than one owner. One owner will be designated as primary.
  • On the Payments or Receivables tab, users can now select from named ranges in a production profile when defining payment and receivable variables to reduce the chance of data entry error.

Master Tracts

  • A master tract Grantor/Lessor can be designated as the primary contact for that parcel of land.
  • Task Model Status allows users to see a high level view of where a tract is in a workflow if Project Management module is licensed.
  • Taxes and Assessments tabs are added to the Canadian Titles tab.

Facilities

  • New Facility Status Effective Date allows users to indicate the date that a facility status went into effect (such as the date a well became shut in).

Projects

  • Documents tab is added to Project Maintenance for non-Project Management module configurations.

Project Management Module

  • Users can now utilize all-new project budget tracking and reporting features.
    • Project Contacts tab is relabeled Team tab, allows both internal team members and external contacts to be added to a project.
      • Assign a Cost per Hour to team members to automatically calculate costs on tasks.
    • New Budget tab allows users to enter an approved project budget as well as forecast project budget and schedule using forecasting algorithms.
      • Task-based estimated costs and schedules roll up to the work order and project levels.
      • As work progresses on a project, real-time metrics and graphs show burn rate, actuals versus estimates, and projected cost and schedule.
    • Project Requests have been relabeled Work Orders.
    • New Task Model Linking Wizard for assigning a project and work order to task models.
  • Grantor is added as a column to the project Tasks tab to better distinguish the tract associated with the task.
  • Master tract tasks are now editable from the project Tasks tab.
  • Project Master Tracts tab is reorganized to provide more useful information about the master tracts and agreements linked to the project. The tree view has been replaced by a nested grid that shows each linked record and basic information, such as task model status of the tracts, agreement type of the agreements, etc.
  • All-new Task Model Status provides users with an overall status of where a tract is in a particular workflow. Task Model Statuses can be assigned to specific tasks in a model that represent major milestones; for example, when the task “Agreement recorded” is marked complete, the task model status could change to “ROW Acquired”.
    • Task Model Status summaries added to Master Tract Maintenance Tract tab and Project Maintenance Details tab.
    • Redesigned Project Maintenance Master Tracts tab that includes Task Model and Task Model Status.
    • Search Master Tracts and Projects with Task Model and Task Model Status criteria.
    • Reports and GIS symbology show both the last task completed (granular view) and the task model status (high level view) of tracts and projects.

Mass Change

  • Users can now add a facility to multiple agreements or master tracts using the Mass Change Facility window.
  • Mass Change Tasks window now includes Task Model Status fields.
  • New Mass Change Cross References option is added for agreements and master tracts.

Display Configuration

  • System administrators can define additional fields that are required to save a record. If a field is defined as required, LPM will display a message to the user that the field must be entered before the record can be saved.

Email Configuration

  • System notifications can be modified to use any email text and to pull in LPM values into the email subject and body using the Expression Builder.

DMS Runner

  • DMS Runner can link one document to multiple agreements, such as in the case of an assignment.
  • Multiple documents can be linked to a single master tract or project.
  • DMS Runner can create master tracts and projects if tract or project numbers are passed and those records don’t exist in LPM.

FEU/FIU

  • FEU is enhanced to export partner invoice details to a third-party accounts receivable module.
  • FEU now includes support for 2019 FASB lease accounting rule changes.