Fast Solutions for Sage 300 Performance Enhancement

 
TaiRox Fast Products
 
Don Thomson, CEO, Accpac Founder
 
Fast TaiRox Products
 
Install Check
Fast DBTools
Fast Clear History
Fast Data Integrity
Copy Company
 
Install Check & Support Issues
Install Check
 
Problem: Sage 300 hangs or crashes, sometimes
 
Cause: Overly aggressive anti-malware program has
quarantined APADV.DLL
 
 
Install Check
 
Fast DBTools
 
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
 
Fast Clear History – How Fast?
 
I/C and O/E: Sage 300 doesn’t use the database layer
A/R and A/P: Sage 300 does use the database layer, somewhat
Fast Clear History
 
Fast Clear History Notes
 
Fast Data Integrity
 
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”
 
Copy Company
 
Copy Company Tech Notes
 
Uses Sage 300 Objects
Insures the result is valid
Requires 2 Lanpaks in early versions of Sage 300
 
Audit Logger, Orchid Extender
Programs that sub-class Sage 300 views
 
Use Copy Company in a Clean Environment!
Problems? Run TaiRox Install Check
 
Download Rates
 
Download Rates Tech Notes
 
Government RSS Feeds
Bank of Canada, US Fed, Reserve Bank of Australia
GBP to EUR is constructed from 2 CAD/USD/AUD rates
No historical rates are provided
Rates are available at a specific time of day (usually)
Commercial Feeds
Currencylayer, 
Oanda
 (
no longer supported
)
Historical rates are provided
Free Feeds
Yahoo!, Google 
(
no longer supported
)
Rates are “rates of the moment”, not for a specific day
Scheduled Task – 
plan time carefully for occasional outages!
 
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
 
Automate G/L Consolidation
 
SOX User Management
 
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
Slide Note
Embed
Share

Explore TaiRox Fast Products, including Fast DBTools for faster database operations, Fast Clear History for efficient data management, Fast Data Integrity for error prevention, and more. Learn how to address common installation and support issues for optimal functionality.


Uploaded on Sep 12, 2024 | 1 Views


Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

E N D

Presentation Transcript


  1. TaiRox Fast Products Don Thomson, CEO, Accpac Founder

  2. Fast TaiRox Products Install Check Fast DBTools Fast Clear History Fast Data Integrity Copy Company

  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 How Fast? I/C and O/E: Sage 300 doesn t use the database layer A/R and A/P: Sage 300 does use the database layer, somewhat

  9. Fast Clear History

  10. Fast Clear History Notes

  11. Fast Data Integrity

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

  13. Copy Company

  14. Copy Company Tech Notes Uses Sage 300 Objects Insures the result is valid Requires 2 Lanpaks in early versions of Sage 300 Audit Logger, Orchid Extender Programs that sub-class Sage 300 views Use Copy Company in a Clean Environment! Problems? Run TaiRox Install Check

  15. Download Rates

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

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

  18. Automate G/L Consolidation

  19. SOX User Management

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

More Related Content

giItT1WQy@!-/#giItT1WQy@!-/#giItT1WQy@!-/#