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


    FixIT Professional

Version 6.4.0
2017
Release date November 2016

Compatible with
Sage 300 2017 (v6.4)


FixIT Professional
will repair Sage 300 (ERP/Accpac) 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. 

    Compatibility
 

Sage 300 2016

  • Compatible with Sage 300 2017 (ERP /Accpac) version 6.4
    (AP, AR, BK, GL, IC, OE, PO, PJC, PR & TX)
  • New US and Canadian Payroll v7.3 compatibility
  • Updated for Sage 2016 v6.3 Product Update 1
  • FixIT locate database screen defaults to Microsoft SQL Server
  • Purge AP, Purge AR and Purge Bank upgraded to 2017 compatibility
  • Updated FixIT PinPoints to v6.4


    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.4

  • 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.4
  • AR Clear Statements - this Pinpoint clears ALL statements in Accounts Receivable. AR version 5.4A through 6.4A
  • AR Reset Statement Date - this Pinpoint modifies AR Statements and sets them to a prior date. AR version 5.4A through 6.4A
  • 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.4
  • 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

 Like Us On Facebook

Subscribe to Musick Notes Newsletter