Musick International LogoWhat's New At Musick International, Inc.


    FixIT Professional

Version 6.6.0
2019
November
2018

Compatible with
Sage 300 2019 (v6.6A)


FixIT Professional
will repair Sage 300  data integrity problems. FixIT is designed to identify and repair or remove data corruption. User friendly, no knowledge of database layout/structure required. It is Guaranteed to repair your data.

Download FixIT Professional today and take charge of your accounting data.  Click here to Download

    Compatibility
 

Sage 300 2016

  • Compatible with Sage 300 2019  version 6.6A
    (AP, AR, BK, GL, IC, OE, PO, PJC, PR & TX)
  • New US and Canadian Payroll v7.3 compatibility
  • Updated for Sage 2018 v6.5 Product Update 3
  • FixIT locate database screen defaults to Microsoft SQL Server
  • Purge AP, Purge AR and Purge Bank upgraded to 2019 compatibility
  • Updated FixIT PinPoints to v6.6


    Enhancements
  • 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.
    Features
  • "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 Pro 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 for v6.6

  • Batch Status Script - update the status of AP, AR and GL batches listing
  • AP Delete Invoices - allows removal of specific AP unpaid invoices
  • AR Delete Invoices - remove specific AR unpaid invoices by ranges
  • 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 Pro 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
  • UP Earnings - payroll missing earnings/deductions from year to date information
    PinPoints v6.6
  • AR Clear Statements - this Pinpoint clears ALL statements in Accounts Receivable. AR version 6.0A through 6.6A
  • AR Reset Statement Date - this Pinpoint modifies AR Statements and sets them to a prior date. AR version 6.0A through 6.6A
  • Bank No Entries -Bank entries not displaying. Bank entries are not posted, but not 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 - correrct Day End error - "Cannot find OESHCD" for OE version  6.0 - v6.6
  • PO Clear History - Error RecordNotFound - 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



Over 25 years of data repair experience is only a click away.

Purchase Price: $1595     Upgrade Price: $675

Price List    Download