TaiRox Productivity Tools: Enhancing Efficiency in Sage 300 ERP

 
Connect.
 
Learn.
 
Grow.
 
Productivity Tools and
Deferred Revenue
Productivity Tools
TaiRox Productivity Tools
Development Partner for Sage 300 ERP
Development Team has over 80 years of experience
collectively
The CEO is a Co-founder of the original Accpac
development company and has 30 years of experience
Over 100 tools, to improve productivity in Sage 300
ERP
All products have been rewritten for V2016, are
compatible with V2017 and are SDK
TaiRox is available to do Customisations written in the
SDK
TaiRox Productivity Tools
What’s New
Smart Finders that Launch Google Maps
Extended Tools 
– Update Only 
– you can now just
update a description or name and leave the remainder
of the record the same
GL Toolkit / User Management 
Full SOX UM 
- User
Reports
AR Toolkit / Extended Customers 
-  optionally enforce
Country, State and Province codes
AP Toolkit / Extended Vendors 
-  optionally enforce
Country, State and Province codes
TaiRox Productivity Tools
What’s New
IC Toolkit / Extended Items 
- New Smart Finder –
choose to see only Active items
IC Toolkit / Extended Items - 
Items in Use button –
a
report of where that item is in use to avoid integrity
issues if item is deleted (checks all core and known 3
rd
party modules – will display a report if unknown 3
rd
party modules are present)
PO Toolkit / Extended PO Entry 
- Drop Ship 
– pick a
ship to address then choose multiple lines to drop ship
PO Toolkit / 
Extended Receipt Entry 
– ability to re-sort
the PO lines when doing receiving
TaiRox Productivity Tools
What’s New
OE Toolkit / Extended Order Entry 
– Launch Google
Maps 
from the Smart Finder
OE Toolkit / Extended Order Entry  - 
Order Margin
Entry grid includes 4 additional columns:
Margin Percent
  
- Markup Percent
Margin Amount
  
- Most Recent Unit
Cost (based on PO Rec)
Click on 
Margin button 
to see overall margin on that
order
TaiRox Productivity Tools
What’s New
OE Toolkit / Extended Order Entry
Order from History button  
 
Margin columns 
added to this screen
Order from Sales History 
(extra tab on Order from
History screen)
OE Toolkit / Extended Shipment Entry
Item Finder  - 
Settings
 - Control the columns that
are displayed (up to 50) in the item finder
TaiRox Productivity Tools
What’s New
 OE Toolkit - Sale History Inquiry
Displays Most Recent 
Cost
, Or Most Recent 
Price
charged to a Specific Customer or any Customer
Filter by Item Number, Customer Number or
Location
Sort by Customer, Item, Sales Person, any of these 3
plus Transaction Date
Displays information based on a Users Permissions
Drilldown capabilities including to TaiRox Vendor
Inquiry
Drag and drop columns on report to change display
order
Optional Field Manager
New in 2017
Installs like a windows program (can also be launched
from Sage 300 desktop)
Connects to SQL database
Delete Optional Fields 
Selected Optional Fields are
deleted from all tables
Option to Delete the Optional field from Common
Services
If the Optional field is in use by a 3
rd
 party product
the deletion will not take place
Note- this is only for Master File and Set up Tables
NOT for Transaction tables
Optional Field Manager
New in 2017
Add Optional Field Values 
Will populate a default
value for a new Optional field
 
Note – this will not override any existing values – it will
ONLY add a value to empty optional fields
When you choose an optional field to populate a list of
all tables that have that Optional field will be displayed
Note- this is only for Master File and Set up Tables
NOT for Transaction tables
TaiRox Productivity Tools
Productivity Tools for Sage 300:
Multi Company Tools
General Ledger Tools
Accounts Receivable Tools
Accounts Payable Tools
Inventory Control Tools
Order Entry Tools
Purchase Order Tools
Payroll Tools
TaiRox Productivity Tools
Multi Company Tools for Sage 300:
Extended products allow you to maintain records in 1
company and copy changes across multiple companies
Extended GL Accounts (*)
Extended Customers (*)
Store multiple contacts or email address’ per customer
Extended Vendors (*)
Store multiple contacts or email address’ per vendor
Extended Fiscal Calendar (*)
New 2014 – Extended Create New Year (*)
Extended Inventory Items (*)
TaiRox Productivity Tools
General Ledger Tools for Sage 300:
Extended GL Accounts (*)
Accounting Status 
- Displays un-posted batches &
Un-transferred sub-ledger transactions with drilldown
Extended Fiscal Calendar (*)
New 2014 – Extended Create New Year (*)
Set Recurring Dates 
- Change the last run date for GL
recurring entries
User Management 
- Permissions Report  / Copy or
Remove User Settings
Lite version of SOX User Management
TaiRox Productivity Tools
Accounts Receivable Tools for Sage 300:
Extended Customers (*)
Mass Billing 
Creates an AR Invoice Batch or Credit Note Batch
Option to Select Customer(s)
Select an Item, UOM & Price to bill
Drill down to Customers
Mail Merge (*)
Integrates Sage 300 ERP with Microsoft Word’s mail
merge
AP Vendors, AR Customers, IC Items US & CDN Payroll
Employees
TaiRox Productivity Tools
Accounts Payable Tools for Sage 300:
Extended Vendors (*)
Maintain vendor across multiple companies
Store multiple contacts per vendor
Mail Merge (*)
Integrates Sage 300 ERP with Microsoft Word’s mail
merge
AP Vendors, AR Customers, IC Items US & CDN
Payroll Employees
Optional fields
TaiRox Productivity Tools
Inventory Control Tools for Sage 300:
Extended Inventory Items (*)
Insert Items, Update Items or both– from Source Co. to
Target Co.
Segment filtering and substitution (Category, Style, Colour,
Model, Series)
Stock Reorder (*)
Create Requisitions or PO’s based on Minimum stock
levels
Mail Merge (*)
Fix Item Valuation Errors
Data Repair tool for IC errors identified via Data Integrity
TaiRox Productivity Tools
Order Entry Tools for Sage 300:
Extended Order Entry
Extended Shipment Entry
Invoice Shipments 
- Invoice multiple Shipments in
one step
New 2014 – will now consolidate multiple shipments
into one invoice
Ship Orders 
- 
Ship
 multiple orders or 
Invoice
 multiple
orders in 1 step
TaiRox Productivity Tools
Order Entry Tools for Sage 300:
Update Orders  
- Change details on multiple Orders or
Quotes in one step
When components of a Kit, BOM or ship date change
Delete Orders 
- Delete multiple orders at the same time
Complete Orders 
- Complete multiple orders at the same
time
Checks for Data Integrity issues and produces an error
msg
Delete Quotes 
- Delete quotes that will never become an
order
Checks for Data Integrity issues and produces an error
msg
TaiRox Productivity Tools
Extended Order Entry 
for Sage 300:
Icon can be saved in Order Entry folder
Replaces standard OE screen with additional buttons
Order from History 
Generate a new order from previous orders
Drill down to view previous orders
Choose items to include on new order  - Multiple
previous orders can be combined into one new order
Create Purchase Orders 
Generate a new Purchase Order from Orders
TaiRox Productivity Tools
Extended Shipment Entry 
for Sage 300:
Icon can be saved in Order Entry folder
Replaces standard screen with an extra finder button to
select items for shipment
Additional information:
Price, Quantity in One Location, Quantities in All
Locations, & Comments
Find items by:
Number, Desc., Category, Acct Set, Structure Code,
Status
TaiRox Productivity Tools
Order Entry with Quantities
 
for Sage 300:
Stand Alone – Not included in Productivity Tools ($395)
Displays Item Quantity information from a separate
database
ODBC connection to external database
SQL query used to get data
Drill down capability
Installs on start menu but a shortcut can be set up in OE
2 areas showing item quantities - Quantities within Sage 300
ERP & External source Quantities (below Post Button)
TaiRox Productivity Tools
Purchase Order Tools for Sage 300:
Extended PO Entry
Stock Reorder (*) Create RQN or PO’s based on Minimum
stock levels
Update Purchase Orders 
- Change details on multiple PO’s
in one step
Delete Purchase Orders 
- Delete multiple PO’s in one step
Complete Purchase Orders 
- Complete multiple PO’s at the
same time
Complete Zero Receipts 
- Completes Zero Receipts
without having to do adjustments
TaiRox Productivity Tools
Extended PO Entry 
for Sage 300:
Replaces standard PO screen with additional
button/info
Purchase from History
Generate a new PO from a previous PO
Select by Item or by vendor what to include on new
Purchase Order
Drill down to view previous purchase orders
Quantities
Displays item quantities at the bottom of the screen
(one location and all locations)
TaiRox Productivity Tools
Payroll Tools for Sage 300:
Sync Timecards 
- Synchronises data between Sage
Timecards and Employee table
HRMS updates Employee record => Sync Timecards
updates the timecard from the Employee Record
Data that can be updated:
Rate of Pay, Distribution code, Workers Comp,
Overtime…
By Range of Employees, Range of Timecards, Date
Range, Category
Mail Merge (*)
Integrates Sage 300 ERP with Microsoft Word’s mail
merge
Revenue and Expense Deferrals
Revenue & Expense Deferrals
Deferral = recognition of Revenue or Expense AFTER
cash has been received
Unearned Revenue 
(Received $ for services not yet
performed- sits on books as liability)
As services are performed you recognise
Revenue
Prepaid Expense 
(Payment for goods/services not
yet received- sits on books as asset)
As goods/services received you recognise
Expense
Revenue & Expense Deferrals
 
Revenue & Expense Deferrals
Deferral Methods
Straight-Line
Declining Balance
Manual - Manually create a recognition schedule
Deferment Periods
Calendar / Fiscal  Year
Calendar / Fiscal Quarter
Calendar Month
Fiscal Period
Week
Revenue & Expense Deferrals
Preconfigured for OE, AR & GL but can be configured
for any SDK module
All processing logic based on the GL module
Optional Fields used to identify transactions
Supports DB Dump/DB Load, Integrity Check &
Security
Revenue & Expense Deferrals
Reports
Audit Log Report - Deferral/Recognitions created
during processing
Revenue Flash - What’s been recognised & what
remains
Deferred Revenue - Aging of unrecognised amounts
Recognition Table - Recognition table
Transactions on Hold - Recognitions that have been
delayed
 
Thank You
Thank You
Nancy Lavery
Robert Lavery & Associates
nlavery@cogeco.ca
Presenter Information
Slide Note
Embed
Share

Enhance productivity and efficiency in Sage 300 ERP with TaiRox Productivity Tools. With over 100 tools tailored for V2016 and V2017 compatibility, TaiRox offers smart finders, extended tools, and new features like Google Maps integration, GL toolkit for user management, AR toolkit, and more. Stay updated with extended items, PO and receipt entries, and OE toolkit features. Experience a seamless workflow with TaiRox's expertise and customization capabilities, empowering businesses to connect, learn, and grow.


Uploaded on Sep 12, 2024 | 0 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. Connect. Learn.Grow.

  2. Productivity Tools and Deferred Revenue Nancy Lavery Connect. Learn. Grow. Connect. Learn. Grow. #BAASSConnect17 #BAASSConnect17

  3. Productivity Tools

  4. TaiRox Productivity Tools Development Partner for Sage 300 ERP Development Team has over 80 years of experience collectively The CEO is a Co-founder of the original Accpac development company and has 30 years of experience Over 100 tools, to improve productivity in Sage 300 ERP All products have been rewritten for V2016, are compatible with V2017 and are SDK TaiRox is available to do Customisations written in the SDK

  5. TaiRox Productivity Tools What s New Smart Finders that Launch Google Maps Extended Tools Update Only you can now just update a description or name and leave the remainder of the record the same GL Toolkit / User Management Full SOX UM - User Reports AR Toolkit / Extended Customers - optionally enforce Country, State and Province codes AP Toolkit / Extended Vendors - optionally enforce Country, State and Province codes

  6. TaiRox Productivity Tools What s New IC Toolkit / Extended Items - New Smart Finder choose to see only Active items IC Toolkit / Extended Items - Items in Use button a report of where that item is in use to avoid integrity issues if item is deleted (checks all core and known 3rd party modules will display a report if unknown 3rd party modules are present) PO Toolkit / Extended PO Entry - Drop Ship pick a ship to address then choose multiple lines to drop ship PO Toolkit / Extended Receipt Entry ability to re-sort the PO lines when doing receiving

  7. TaiRox Productivity Tools What s New OE Toolkit / Extended Order Entry Launch Google Maps from the Smart Finder OE Toolkit / Extended Order Entry - Order Margin Entry grid includes 4 additional columns: Margin Percent Margin Amount Cost (based on PO Rec) Click on Margin button to see overall margin on that order - Markup Percent - Most Recent Unit

  8. TaiRox Productivity Tools What s New OE Toolkit / Extended Order Entry Order from History button Margin columns added to this screen Order from Sales History (extra tab on Order from History screen) OE Toolkit / Extended Shipment Entry Item Finder - Settings - Control the columns that are displayed (up to 50) in the item finder

  9. TaiRox Productivity Tools What s New OE Toolkit - Sale History Inquiry Displays Most Recent Cost, Or Most Recent Price charged to a Specific Customer or any Customer Filter by Item Number, Customer Number or Location Sort by Customer, Item, Sales Person, any of these 3 plus Transaction Date Displays information based on a Users Permissions Drilldown capabilities including to TaiRox Vendor Inquiry Drag and drop columns on report to change display order

  10. Optional Field Manager New in 2017 Installs like a windows program (can also be launched from Sage 300 desktop) Connects to SQL database Delete Optional Fields Selected Optional Fields are deleted from all tables Option to Delete the Optional field from Common Services If the Optional field is in use by a 3rd party product the deletion will not take place Note- this is only for Master File and Set up Tables NOT for Transaction tables

  11. Optional Field Manager New in 2017 Add Optional Field Values Will populate a default value for a new Optional field Note this will not override any existing values it will ONLY add a value to empty optional fields When you choose an optional field to populate a list of all tables that have that Optional field will be displayed Note- this is only for Master File and Set up Tables NOT for Transaction tables

  12. TaiRox Productivity Tools Productivity Tools for Sage 300: Multi Company Tools General Ledger Tools Accounts Receivable Tools Accounts Payable Tools Inventory Control Tools Order Entry Tools Purchase Order Tools Payroll Tools

  13. TaiRox Productivity Tools Multi Company Tools for Sage 300: Extended products allow you to maintain records in 1 company and copy changes across multiple companies Extended GL Accounts (*) Extended Customers (*) Store multiple contacts or email address per customer Extended Vendors (*) Store multiple contacts or email address per vendor Extended Fiscal Calendar (*) New 2014 Extended Create New Year (*) Extended Inventory Items (*)

  14. TaiRox Productivity Tools General Ledger Tools for Sage 300: Extended GL Accounts (*) Accounting Status - Displays un-posted batches & Un-transferred sub-ledger transactions with drilldown Extended Fiscal Calendar (*) New 2014 Extended Create New Year (*) Set Recurring Dates - Change the last run date for GL recurring entries User Management - Permissions Report / Copy or Remove User Settings Lite version of SOX User Management

  15. TaiRox Productivity Tools Accounts Receivable Tools for Sage 300: Extended Customers (*) Mass Billing Creates an AR Invoice Batch or Credit Note Batch Option to Select Customer(s) Select an Item, UOM & Price to bill Drill down to Customers Mail Merge (*) Integrates Sage 300 ERP with Microsoft Word s mail merge AP Vendors, AR Customers, IC Items US & CDN Payroll Employees

  16. TaiRox Productivity Tools Accounts Payable Tools for Sage 300: Extended Vendors (*) Maintain vendor across multiple companies Store multiple contacts per vendor Mail Merge (*) Integrates Sage 300 ERP with Microsoft Word s mail merge AP Vendors, AR Customers, IC Items US & CDN Payroll Employees Optional fields

  17. TaiRox Productivity Tools Inventory Control Tools for Sage 300: Extended Inventory Items (*) Insert Items, Update Items or both from Source Co. to Target Co. Segment filtering and substitution (Category, Style, Colour, Model, Series) Stock Reorder (*) Create Requisitions or PO s based on Minimum stock levels Mail Merge (*) Fix Item Valuation Errors Data Repair tool for IC errors identified via Data Integrity

  18. TaiRox Productivity Tools Order Entry Tools for Sage 300: Extended Order Entry Extended Shipment Entry Invoice Shipments - Invoice multiple Shipments in one step New 2014 will now consolidate multiple shipments into one invoice Ship Orders - Ship multiple orders or Invoice multiple orders in 1 step

  19. TaiRox Productivity Tools Order Entry Tools for Sage 300: Update Orders - Change details on multiple Orders or Quotes in one step When components of a Kit, BOM or ship date change Delete Orders - Delete multiple orders at the same time Complete Orders - Complete multiple orders at the same time Checks for Data Integrity issues and produces an error msg Delete Quotes - Delete quotes that will never become an order Checks for Data Integrity issues and produces an error msg

  20. TaiRox Productivity Tools Extended Order Entry for Sage 300: Icon can be saved in Order Entry folder Replaces standard OE screen with additional buttons Order from History Generate a new order from previous orders Drill down to view previous orders Choose items to include on new order - Multiple previous orders can be combined into one new order Create Purchase Orders Generate a new Purchase Order from Orders

  21. TaiRox Productivity Tools Extended Shipment Entry for Sage 300: Icon can be saved in Order Entry folder Replaces standard screen with an extra finder button to select items for shipment Additional information: Price, Quantity in One Location, Quantities in All Locations, & Comments Find items by: Number, Desc., Category, Acct Set, Structure Code, Status

  22. TaiRox Productivity Tools Order Entry with Quantitiesfor Sage 300: Stand Alone Not included in Productivity Tools ($395) Displays Item Quantity information from a separate database ODBC connection to external database SQL query used to get data Drill down capability Installs on start menu but a shortcut can be set up in OE 2 areas showing item quantities - Quantities within Sage 300 ERP & External source Quantities (below Post Button)

  23. TaiRox Productivity Tools Purchase Order Tools for Sage 300: Extended PO Entry Stock Reorder (*) Create RQN or PO s based on Minimum stock levels Update Purchase Orders - Change details on multiple PO s in one step Delete Purchase Orders - Delete multiple PO s in one step Complete Purchase Orders - Complete multiple PO s at the same time Complete Zero Receipts - Completes Zero Receipts without having to do adjustments

  24. TaiRox Productivity Tools Extended PO Entry for Sage 300: Replaces standard PO screen with additional button/info Purchase from History Generate a new PO from a previous PO Select by Item or by vendor what to include on new Purchase Order Drill down to view previous purchase orders Quantities Displays item quantities at the bottom of the screen (one location and all locations)

  25. TaiRox Productivity Tools Payroll Tools for Sage 300: Sync Timecards - Synchronises data between Sage Timecards and Employee table HRMS updates Employee record => Sync Timecards updates the timecard from the Employee Record Data that can be updated: Rate of Pay, Distribution code, Workers Comp, Overtime By Range of Employees, Range of Timecards, Date Range, Category Mail Merge (*) Integrates Sage 300 ERP with Microsoft Word s mail merge

  26. Revenue and Expense Deferrals

  27. Revenue & Expense Deferrals Deferral = recognition of Revenue or Expense AFTER cash has been received Unearned Revenue (Received $ for services not yet performed- sits on books as liability) As services are performed you recognise Revenue Prepaid Expense (Payment for goods/services not yet received- sits on books as asset) As goods/services received you recognise Expense

  28. Revenue & Expense Deferrals

  29. Revenue & Expense Deferrals Deferral Methods Straight-Line Declining Balance Manual - Manually create a recognition schedule Deferment Periods Calendar / Fiscal Year Calendar / Fiscal Quarter Calendar Month Fiscal Period Week

  30. Revenue & Expense Deferrals Preconfigured for OE, AR & GL but can be configured for any SDK module All processing logic based on the GL module Optional Fields used to identify transactions Supports DB Dump/DB Load, Integrity Check & Security

  31. Revenue & Expense Deferrals Reports Audit Log Report - Deferral/Recognitions created during processing Revenue Flash - What s been recognised & what remains Deferred Revenue - Aging of unrecognised amounts Recognition Table - Recognition table Transactions on Hold - Recognitions that have been delayed

  32. Thank You Presenter Information Presenter Information Nancy Lavery Robert Lavery & Associates nlavery@cogeco.ca

Related


More Related Content

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