Sage 300 2025

• Compatible with Sage 300 2025  version 7.2A
  (AP, AR, BK, GL, IC, OE, PO, PJC, PR & TX)
• New US and Canadian Payroll Tax updates for 7.3 compatibility
• Updated for Sage 2018 v6.5 Product Update 7
• Updated for Sage 2019 v6.6 Product Update 8
• Updated for Sage 2020 v6.7 Product Update 8
• Updated for Sage 2021 v6.8 Product Update 8
• Updated for Sage 2022 v6.9 Product Update 6
• Updated for Sage 2023 v7.0 Product Update 4
• Updated for Sage 2024 v7.1
• Purge AP, Purge AR and Purge Bank upgraded to 2024 compatibility
• Updated FixIT PinPoints to Sage 2025 compatibility (v7.2A)

• FixIT System phase - new index validation for Microsoft SQL Server databases
• New Optional Field Validation phase
• FixIT Repair log - new output to FixITReport.txt in the reports folder
• Added reload database and applications after running "Remove Application"
• Fields type validation added to integrity phase
• Bank Services updated validation of Accounts Receivable and Payroll deposits
• Microsoft SQL Server database - create table to initialize field and key information
• Microsoft SQL Server database - Low Level Rebuild (read and recover)
• General Ledger - recreate posted transactions from posting journal detail
• Correct General Ledger Trial Balance Report when balance is incorrect by a small amount (rounding errors)
• Sage 300 data integrity error - "Item Valuation Mismatch"; FixIT will update either location details or item valuation.

• "Standardize Application" to synchronize fields, indexes and flags to Sage 300 defaults
• FixIT "PinPoint" will resolve specific data issues
• Reset "Database ID" after copying or renaming a database
• System Validation between data tables, system tables and the database
• Script tools - for specific modifications to the database; rebuild, purge and batch status
• "Remove Applications" is useful to remove applications that are not used
• Automatic notification of FixIT updates
• FixIT Editor allows modification of tables in Pervasive and Microsoft SQL Server databases
• Purge AP, AR and Bank by vendor, customer, bank code and date

    Scripts

• Batch Status Script - update the status of AP, AR and GL batches
• AP Delete Invoices - allows removal of specific AP unpaid invoices
• AR Delete Invoices - remove specific AR unpaid invoices by range
• Delete Bill of Materials
• Delete Order Entry Orders - easiest way to purge a specific order or historical data
• Delete Purchase Orders - easiest way to purge a specific order or historical data
• Export GL Posted Transactions
• FixIT Rebuild - easiest way to rebuild tables in Pervasive or Microsoft SQL Server
• Add Item Locations - add inventory control item locations for all items
• AP Find Invoice - locate AP invoices in open batches
• Payroll Earnings - payroll missing earnings/deductions from year to date information

• AR Clear Statements - this PinPoint clears ALL statements in Accounts Receivable. AR version 6.0A through 7.1A
• AR Reset Statement Date - this PinPoint modifies AR Statements and sets them to a prior date. AR version 6.0A through 7.1A
• Bank No Entries - Bank entries not displaying. Bank entries are not posted, but do not show in entry screen. Remove orphan bank entry transactions
• AP Vendor Balance - update vendor open invoice balance
• Correct AR Data Integrity Error - "The document should not have any supporting open document details."
• ICXLOT Quantity Ordered - repair quantity ordered for lot (reserved) from OE Orders
• National Account Set - assign National Account code in AR to any value, even if unpaid transactions exist
• National Account Stats - update National Accounts statistics
• OE Day End Error - correct Day End error - "Cannot find OESHCD"
• PO Clear History - Error Record Not Found - Reset Clear History Error - Record Not Found
• Update IC History Quantities and Costs - inserts one history record per item/location to correct History Report
• Update IC Not Costed Values - set location details - not costed fields to zero
• Update Project Job Cost costs - updates costs in contracts, projects and categories
• Update Project Job Cost quantities - updates quantities in contracts, projects and categories

     Find a complete list of available PinPoints here.

    Various Fixes

• FixIT Rebuild script to handle databases over 120 gigabytes
• Low level rebuild in Integrity Phase - data corruption caused table to be blank after rebuild
• Changed "Update of Table" to "Delete/Add" for Microsoft SQL Server
• Revised "Remove Applications" - GL chart of accounts is required
• GL Application Phase - skip check for missing transactions when consolidated
• Corrected run time Error 713. Class not registered. Removed reference to MsStdFmt.dll
• Pervasive tables that were not displaying in FixIT Rebuild Script screen was corrected
• AR Application Phase 3 - when schedule invoice amount is equal to amount due, then payment record is not required
• Reset application list on the Validate screen after running Remove Application
• FixIT dictionary for IC orphan phase validation updated

  Additional Utilities

• Fiscal Year End Change Utility
• Employee Number Change Utility
• Salesperson Code Change Utility
• Ship-To Location Change Utility
• Unit of Measure Change Utility
• PJC Contract Change Utility
• PJC Project Change Utility
• PJC Category Change Utility
• Distiller Utility
• Payroll Import Utility
• General Ledger Import Utility
• Bank Entry Import Utility
• Purge History Utility
• National Account Change Utility
• Currency Change Utility
• Customer Change Utility
• Unit of Measure Change Utility
• Bank Change Utility
• Price List Change Utility
• Credit Card ID Change Utility

    Included Free with DataCHECK

DataCHECK includes the ability to reset Database ID’s. After copying (not dump/load) a database to a new company ID, Sage will generate this error:

Click “Reset ID” to resolve this error and allow Sage to connect to the company database.

DataCHECK will also remove applications from the Sage 300 company database. From the "App Tools" screen, select the "Remove Application" tab, highlight the application to remove and click “Remove Application”. DataCHECK will do the rest by removing all references to the application.