Sage 300 2023

• Compatible with Sage 300 2022  version 7.0A
  (AP, AR, BK, GL, IC, OE, PO, PJC, PR & TX)
• New US and Canadian Tax version for 7.3
• Updated for Sage 2017 v6.4A Product Update 9
• 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 7
• Updated for Sage 2021 v6.8 Product Update 4
• Updated for Sage 2022 v6.9 Product Update 1
• FixIT locate database screen defaults to Microsoft SQL Server
• Purge AP, Purge AR and Purge Bank upgraded to 2022 compatibility
• Updated FixIT PinPoints to Sage 2022 compatibility (v7.0A)

• 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.0A
• AR Reset Statement Date - this PinPoint modifies AR Statements and sets them to a prior date. AR version 6.0A through 7.0A
• 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

    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