x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 4 replies
  • Subscribers 51 subscribers
  • Views 749 views
  • Users 0 members are here
Browse Forums
Announcements
68
topics
93
replies
Customization and Integration
262
topics
822
replies
Financials, Projects, and Administration
382
topics
843
replies
General Discussion
327
topics
836
replies
Installation and Technical Issues
335
topics
1k
replies
Manufacturing, Distribution, and Applications
341
topics
696
replies
Reporting and Analytics
123
topics
480
replies
@Steve

Turn on the dataporter button for all users

SOLVED
Posted By

Is there a way to set all users preferences to show dataporter? 

Is this an option? 
UPDATE tsmUser SET ShowDataPorterOnToolbar = 1

  • +1
    verified answer

    That should work.

  • +1 in reply to Darrick
    verified answer

    Thank you.

  • +1
    verified answer

    The button doesn't have to be displayed on the toolbar to invoke DataPorter, you simply press Alt-F7 for DataPorter Excel Add-in and Alt-F8 for the mapping UI. Not all forms are mapped for DataPorter by Sage out of the box and the mapping may not be updated current to your version, so you may need to save changes to the mapping or logic. Also, the default mapping does not include controls added by source code or Customizer changes.

    The forms that have basic mapping by Sage include the following tasks.

    TaskID Module Task
    67174402 Accounts Payable Recurring Voucher Maintenance
    67174401 Accounts Payable Vendor Maintenance
    67502190 Accounts Payable View / Edit Vouchers
    67436554 Accounts Payable Voucher Entry
    83952612 Accounts Receivable Customer Maintenance
    84219765 Accounts Receivable Invoice Entry
    83951676 Accounts Receivable Recurring Invoice Maintenance
    83957623 Accounts Receivable Salesperson Maintenance
    151390000 Cash Management Bank Transaction Entry
    33619970 Common Information Non-Stock Items Maintenance
    33619977 Common Information Postal Code Setup
    50399184 General Ledger Account Maintenance
    50403234 General Ledger Account Segment Setup
    50401194 General Ledger Allocation Maintenance
    50663388 General Ledger Journal Transaction Entry
    50398204 General Ledger Natural Account Maintenance
    50401204 General Ledger Recurring Journal Maintenance
    117770000 Inventory Management Enter Physical Counts
    117506178 Inventory Management Item Maintenance
    117506138 Inventory Management Maintain Item Classes
    117833818 Inventory Management Transaction Entry
    319160389 Project Accounting Project Estimate Maintenance
    319160330 Project Accounting Project Maintenance
    319160390 Project Accounting Project Timesheet Entry
    318832775 Project Accounting Resource Maintenance
    184942742 Purchase Order Enter Purchase Order
    134611094 Sales Order Enter Sales Orders and Quotes
    134283516 Sales Order Maintain Blanket Sales Orders

*Community Hub is the new name for Sage City