1 / 22

Technical Tools and Training Demos for Clean Operating Environment

Join Don Thomson, CEO of Copy Company, for technical demos, discussions, and training on fast and efficient technical tools. Learn about data integrity, SOX compliance, database management, and more. Discover effective solutions for optimizing your workflow. Don't miss out on this opportunity to enhance your technical skills!

lesterrobinson
Download Presentation

Technical Tools and Training Demos for Clean Operating Environment

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Pre-Conference TrainingDemos & DiscussionTechnical Tools Don Thomson, CEO

  2. Technical Demos & Discussions • Copy Company • A clean operating environment matters!!! • Fast DBTools • Making use of 2 CPUs, 8 cores • Download Rates • How to diagnose Windows Scheduled Tasks • Accounting matters!!! Time matters!!! • Fast Data Integrity • Integrity issues that matter (and ones that don’t) • SOX User Management • When propagation doesn’t work

  3. Technical Discussions • SOX Backup Enterprise • Getting data from here to there over unreliable connections • Time matters!!! • SOX Check Approval • Locking down Sage 300 functions • Fast Units of Measure Tool • What’s wrong with CI databases • Workstation Health Check • Designed to run from a memory stick • G/L Account Repair • Iterations!!!

  4. Copy Company

  5. Copy Company

  6. Workstation Health Check

  7. Copy Company Tech Notes • Uses Sage 300 Objects • Insures the result is valid • Requires 2 Lanpaks • Earlier Versions of Sage 300 • Memory Leaks and Garbage Collection Crashes • Audit Logger, View Extender • Programs that sub-class Sage 300 views • UniLauncher, Switcher, etc. • Copy Company uses lots of different objects • Use Copy Company in a Clean Environment! • A single version of Sage 300 • Problems? Run TaiRox Workstation Health Check

  8. Fast DBTools

  9. Fast DBTools Tech Notes • 3x to 4x faster DBLoads (larger databases) • Uses multiple CPU cores (threads) for faster DBDumps • DBDump any number of databases at once • Has a de-activate function • View large datasets without loading into a database • Provides a Sage 300 centric view of a SQL instance • Will DBDump in REC or CSV format • Recover unused database space with 1 click

  10. Download Rates

  11. Download Rates Tech Notes • Government RSS Feeds • Reserve Bank of Australia, Bank of Canada, US Fed • GBP to EUR is constructed from 2 AUD/CAD/USD rates • No historical rates are provided • Rates are available at a specific time of day (usually) • Commercial Feeds • Currencylayer, Oanda • Historical rates are provided • Free Feeds • Yahoo!, Google • Rates are “rates of the moment”, not for a specific day • Scheduled Task – plan time carefully for occasional outages!

  12. Download Rates Tech Notes • Download Rates uses Sage 300 Rate Types • There can be more than one rate for 2 currencies • Download Rates will adjust a rate by a percentage • To get a more accurate valuation of receivables or payables • Download Rates will store “spread” • The spread feature is usable when only set up 1 time • Non-ISO code is used in Sage 300 database? • Download Rates will re-map

  13. Fast Data Integrity

  14. Fast DIC Tech Notes • How much Faster? Think 6 hours in 6 minutes. • The larger the database, the fewer the errors => the larger the performance gain • How? Fast DIC only asks SQL Server for “bad” rows • Fast DIC checks all orphan and foreign key problems • Fast DIC checks all GLARAPICOE header/detail totals • Fast DIC does not check for “illegal characters”

  15. SOX User Management

  16. SOX User Management Tech Notes • The rights didn’t get copied? • SOX User Management called the propagate function • The propagate function was blocked and reported no errors • Run propagate from DB Setup to fix • What’s the difference between “All Users” and “Everyone”? • Desktop settings are stored in subdirectories of USER • When you create a folder on a desktop and tell Sage 300 it is for “All Users”, that setting is kept in a special subdirectory of USER, _EVERYONE

  17. SOX Backup Enterprise

  18. SOX Backup Enterprise Tech Notes • A backup job is not a disaster recovery test • DBDump format is about one-tenth the size of SQL backup • A scheduled task will back up any number of Sage 300 databases • Manage from 1 to 99 archives • Robust retry strategies copy data over unreliable connections

  19. Fast Units of Measure Tools

  20. G/L Account Repair

  21. SOX Check Approval

  22. Questions ?

More Related