2026-11-05

Sage 100 User Permissions: Who Should See Cost and Margin Data?

Cost and margin are visible in more places than most Sage 100 roles were designed for. Tighten one screen and the numbers can still surface somewhere else — often where nobody thought to look.

Sage 100 user permissions: who should see cost and margin data? It sounds like a Role Maintenance question — assign the right tasks, hide the sensitive screens, done. Teams who stop there often discover that cost was never only on those screens.

Sage 100 Permissions Start in Role Maintenance — They Do Not End There

Roles are assigned by company, task by task. In the Sage Community Hub, the recurring answer to permission questions is the same: access is enabled in Role Maintenance, then users are assigned roles by company code. Copy a role before broadening it, or everyone sharing it inherits access they were never meant to have — including inquiry screens that display cost.

A task you grant for one reason can carry cost with it. A role opened up so someone can maintain a vendor, run an inquiry, or print a register may also expose the numbers behind the transaction. The permission looks operational. The exposure is financial.

Where Sage 100 Cost and Margin Still Leak

Hub users asking about Sage 100 Premium learned a sharper lesson: Sage application permissions do not govern access outside the application in the same way. Reports run through Sage can reach data a role appears to restrict, and direct database or ODBC querying is managed separately — not by the role you carefully built inside Sage 100. So a user blocked from a cost screen may still see cost in a report, an export, or a query set up for another purpose.

Frequently Asked Questions

Who should see cost and margin in Sage 100? Only the roles that need those numbers to price, buy, or close — not every role that needs to touch the underlying order, item, or invoice.

Does hiding a Sage 100 task hide the cost data? Not by itself. Reports, exports, and external queries follow different access paths, and each one needs its own check.

What Loose Permissions Cost

Margin seen by the wrong eyes changes negotiations — with customers, with vendors, and inside your own team. It also weakens every control built on those numbers staying limited. By the time the leak is noticed, you rarely learn how far the figures travelled.

Check Every Path to Cost, Not Just the Screens

Our free Sage 100 Health Check reviews roles, module options, and the reporting paths around them — and finds where cost and margin are wider than you intended. Every Digit Masters consultant is a licensed U.S. CPA, and our support plans keep permissions tight as staff and roles change. Before cost shows up somewhere it should not, find every door that leads to it.

Related Services

This topic connects directly to our core service areas: Sage 100 Consulting, Sage 100 Support, and our free Sage 100 Health Check. Related reading: our purchase order three-way match post and our work order costing post. If you\'re working through a similar challenge, contact us for a free consultation.

Written by the Digit Masters Consulting Team

Our CPA-led consultants have over 35 years of combined experience implementing, supporting, and migrating Sage 100 and Sage 300 for manufacturers and wholesale distributors across Southern California and nationwide.

Ready to Optimize Your Sage ERP?

Speak with a CPA-led Sage consultant. Free initial consultation — English or Chinese.

Get a Free Consultation