Sage Administrative Assistant

Waste Resource Management

Houston (TX)

On-site

USD 65,000 - 90,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Waste Resource Management, Inc. in Houston, TX seeks a detail-oriented Sage 100 Administrator to maintain the Sage 100 ERP system, customer master data, and order flow. The role includes bulk data updates via VI and ensuring data integrity across ERP operations.

The ideal candidate will have deep Sage 100 module knowledge and a proven track record of resolving duplicate or stuck orders, with collaboration across Customer Service, Billing, and Logistics teams.

Qualifications

  • 2–3 years of hands-on Sage 100 administration.
  • Strong knowledge of AR, SO, and IM modules.
  • Data integrity focus with ability to audit and reconcile data.
  • Experience troubleshooting Providex/ProvideX data tables.

Responsibilities

  • Manage customer maintenance and master data in Sage 100.
  • Monitor order flow and resolve duplicate or stalled orders.
  • Design and run VI import/export jobs for bulk updates.
  • Generate reports using BI tools and Crystal Reports.

Skills

Attention to detail
Analytical skills
Data integrity

Tools

Sage 100
Visual Integrator (VI)
Crystal Reports
ProvideX

Job description

Welcome to Waste Resource Management (WRM)

At Waste Resource Management (WRM), we go beyond operating trucks—we are dedicated to environmental protection and delivering exceptional service. With a presence across Texas, Colorado, Florida, and Nevada, our affiliated companies—SouthWaste Disposal LLC, Silver City Processing, and McDonald Farms, Inc.—offer comprehensive solutions for liquid waste recycling and transportation.

Position Overview

We are seeking a detail-oriented Sage 100 Administrator to manage and maintain our Sage 100 ERP system. This role is responsible for maintaining customer master data, ensuring seamless order processing flow, resolving order anomalies (such as duplicate or stuck orders), and executing mass data updates via Sage 100 Visual Integrator (VI). The ideal candidate will have deep functional knowledge of Sage 100 modules and a proven track record of maintaining strict data integrity across ERP operations.

Key Responsibilities
1. Accounts Receivable & Customer Maintenance
  • Set up and maintain new and existing customer accounts in the Customer Maintenance module, ensuring correct credit limits, payment terms, salesperson assignments, tax schedules, and ship-to addresses.
  • Establish standard operating procedures (SOPs) for data entry to maintain consistency across customer master files.
  • Routinely audit customer files to identify, consolidate, and merge duplicate customer accounts.
2. Order Flow Management & Troubleshooting
  • Monitor open orders across the Sales Order (SO) and Accounts Receivable (AR) modules to detect missing, delayed, or stuck transactions.
  • Identify and eliminate duplicate orders prior to fulfillment and invoicing to prevent billing and inventory discrepancies.
  • Investigate and resolve order transmission errors between Sage 100 and external platforms (e.g., e-commerce, CRM, or portal integrations).
  • Collaborate directly with Customer Service, Billing, and Logistics teams to address order entry bottlenecks and data errors.
3. Visual Integrator (VI) & Mass Data Management
  • Design, build, test, and execute Visual Integrator (VI) import and export jobs to perform bulk updates to Customer Maintenance, Sales Orders, and price codes.
  • Validate source files (CSV, Excel, Text) and conduct dry runs in test companies prior to executing mass changes in live production files.
  • Maintain, optimize, and log existing VI job routines for regular batch processing.
  • Develop documentation for custom VI job logic, data mapping, and error handling.
4. System Administration & Reporting
  • Provide first-line user support for Sage 100 operational errors, data validation issues, and task permissions.
  • Assist in troubleshooting Providex/ProvideX data tables, file lockouts, or broken indexes when necessary.
  • Generate operational reports, data exports, and audit logs using Custom Lookup Views, Business Insights Explorer (BIE), or Crystal Reports.
Qualifications & Requirements
  • Sage 100 Experience: Minimum 2–3 years of hands‑on experience maintaining and administering Sage 100 (formerly MAS 90 / MAS 200).
  • Module Knowledge: In-depth knowledge of Sage 100 core modules, specifically:
    • Customer Maintenance / Accounts Receivable (AR)
    • Sales Order (SO)
    • Inventory Management (IM)
  • Data Integrity & Analytics: Strong analytical skills with high attention to detail for audit trails, duplicate detection, and missing order reconciliation.
  • Problem‑Solving: Proven ability to trace data flows and identify the root cause of sync failures or corrupted records.
Preferred Qualifications
  • Experience with Sage 100 Customizer (adding User-Defined Fields / UDFs and modifying user screens).
  • Familiarity with Crystal Reports for Sage 100 or SQL database structures (if running Sage 100 Premium).
  • Prior experience managing integrations between Sage 100 and third‑party portal/EDI/e‑commerce systems.
Equal Opportunity Employment

We are an equal opportunity employer, committed to equal treatment of all employees without regard to race, national origin, religion, gender, age, sexual orientation, veteran status

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sage 100 ERP Administrator & Data Integrity Specialist
Sage 100 ERP Administrator & Data Integrity Specialist

Waste Resource Management, Inc. • Houston (TX)

On-site
USD 65,000 - 90,000
Sage 100 ERP (MAS 90 / MAS 200) Support Analyst
Sage 100 ERP (MAS 90 / MAS 200) Support Analyst

Business Computer Associates, Inc. (BCA, Inc.) • Miami (FL)

On-site
USD 55,000 - 75,000
Consultant - Sage 100
Consultant - Sage 100

CBIZ • United States

On-site
USD 85,000 - 120,000
ACCOUNTING/IT LIAISON
ACCOUNTING/IT LIAISON

Mercer Valve Company, Inc. • Oklahoma City (OK)

On-site
USD 60,000 - 80,000
Experienced Inside Sales - Sage 100
Experienced Inside Sales - Sage 100

SWK Technologies, Inc. • Beaverton (OR)

On-site
USD 54,000 - 66,000
Sage Manufacturing Systems Analyst
Sage Manufacturing Systems Analyst

Iowa Ag • Sioux City (IA)

On-site
USD 85,000 - 110,000
Customer Service/Order Entry
Customer Service/Order Entry

Ques Industries, Inc. • Brook Park (OH)

On-site
USD 42,000 - 64,000
Remote Customer Account Manager – Sage 100 Focus
Remote Customer Account Manager – Sage 100 Focus

SWK Technologies, Inc. • Washington

Remote
USD 50,000 - 65,000
Health Care Plan
Retirement Plan
Life Insurance
+2
Accounts & Administrative Specialist
Accounts & Administrative Specialist

Prominox USA • Houston (TX)

On-site
USD 42,000 - 56,000
Remote Sage 100 Customer Account Manager
Remote Sage 100 Customer Account Manager

SWK Technologies, Inc. • Greensboro (NC)

Remote
USD 50,000 - 65,000
Health care plan
401(k) & IRA
Life Insurance
+2