TaiRox Product Overview Demonstrations - PowerPoint PPT Presentation

hank
tairox product overview demonstrations n.
Skip this Video
Loading SlideShow in 5 Seconds..
TaiRox Product Overview Demonstrations PowerPoint Presentation
Download Presentation
TaiRox Product Overview Demonstrations

play fullscreen
1 / 27
Download Presentation
TaiRox Product Overview Demonstrations
152 Views
Download Presentation

TaiRox Product Overview Demonstrations

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. TaiRox Product OverviewDemonstrations Don Thomson, CEO

  2. Product Overview • Install Check • Fast DBTools • Fast Clear History • Copy Company • Download Rates • Fast Data Integrity • SOX User Management • SOX Backup Enterprise

  3. Install Check & Support Issues

  4. Install Check • Problem: Sage 300 hangs or crashes, sometimes • Cause: Overly aggressive anti-malware program has quarantined APADV.DLL

  5. Install Check

  6. Fast DBTools

  7. Fast DBTools 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 • Detects changes to Sage 300 databases • Stores collation changes

  8. Fast Clear History

  9. Fast Clear History Notes • Same as Sage 300 + unprinted posting journals • I/C and O/E don’t use database layer • A/R and A/P use the database layer somewhat • Can use Sage 300 Clear History and TaiRox Clear History • Different Business Model

  10. Copy Company

  11. Copy Company Tech Notes • Uses Sage 300 Objects • Insures the result is valid • Requires 2 Lanpaks in early versions of Sage 300 • 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! • Problems? Run TaiRox Install Check

  12. Download Rates

  13. 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!

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

  15. Fast Data Integrity

  16. Fast DIC Tech Notes • How much Faster? Think 6 hours in 6 minutes. • Most performance boost for large databases with few errors • How? Fast DIC only asks SQL Server for “bad” rows • Fast DIC checks: • All orphan and foreign key problems • All GLARAPICOE header/detail totals • Missing required optional fields • Fast DIC does not check for “illegal characters”

  17. SOX User Management

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

  19. SOX Backup Enterprise

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

  21. Optional Field Manager

  22. Find Out More at www.tairox.com

  23. TaiRox Web Site Notes • Videos • Handouts • User Guides • Productivity Tools – Demo Guide • Productivity Tools – Changes Since January • Productivity Tools – Demonstration Data • Copy Company – Demonstration Data • Customizations

  24. Development Strategies • “Lean” Development • Fast to market, etc. • Add hundreds of features per year • “Fair” Funding • End users in need pay 20% of development costs • Everybody else gets it for free • A Customization Framework • Install script, logging, permissions, data activation, error recovery • User guide, testing, no forced upgrade, source repository

  25. Select Audit Records

  26. Questions ?