Sage Administrative Assistant

Waste Resource Management•Houston, TX

4d•$24 - $27

About The Position

Waste Resource Management (WRM) is seeking a detail-oriented Sage 100 Administrator to manage and maintain its Sage 100 ERP system. The role focuses on customer master data, order processing flow, resolving order anomalies such as duplicate or stuck orders, and bulk data updates using Sage 100 Visual Integrator (VI). The ideal candidate has in-depth functional knowledge of Sage 100 modules and a demonstrated ability to maintain data integrity across ERP operations. The administrator maintains customer accounts and data-entry procedures, audits customer files for duplicates, monitors and troubleshoots orders across Sales Order and Accounts Receivable, and investigates transmission errors between Sage 100 and external platforms. The role also designs, tests, and executes VI jobs, supports users with Sage 100 operational issues, and produces operational reports, data exports, and audit logs. It collaborates with Customer Service, Billing, and Logistics teams to address order-processing bottlenecks and data errors.

Requirements

At least 2–3 years of hands-on experience maintaining and administering Sage 100, formerly MAS 90 / MAS 200.
In-depth knowledge of Sage 100 Customer Maintenance and Accounts Receivable, Sales Order, and Inventory Management modules.
Strong analytical skills and attention to detail for audit trails, duplicate detection, and missing-order reconciliation.
Proven ability to trace data flows and identify root causes of synchronization failures or corrupted records.

Nice To Haves

Experience with Sage 100 Customizer, including adding User-Defined Fields and modifying user screens.
Familiarity with Crystal Reports for Sage 100 or SQL database structures if using Sage 100 Premium.
Prior experience managing integrations between Sage 100 and third-party portal, EDI, or e-commerce systems.

Responsibilities

Set up and maintain customer accounts, including credit limits, payment terms, salesperson assignments, tax schedules, and ship-to addresses.
Establish standard operating procedures for customer data entry.
Audit customer files and consolidate or merge duplicate customer accounts.
Monitor open orders across Sales Order and Accounts Receivable for missing, delayed, or stuck transactions.
Identify and eliminate duplicate orders before fulfillment and invoicing.
Investigate and resolve order transmission errors between Sage 100 and external platforms such as e-commerce, CRM, or portal integrations.
Collaborate with Customer Service, Billing, and Logistics to address order-entry bottlenecks and data errors.
Design, build, test, and execute Visual Integrator import and export jobs for bulk updates to Customer Maintenance, Sales Orders, and price codes.
Validate CSV, Excel, and text source files and conduct test-company dry runs before production updates.
Maintain, optimize, and log existing Visual Integrator job routines for regular batch processing.
Document custom Visual Integrator job logic, data mapping, and error handling.
Provide first-line user support for Sage 100 operational errors, data validation issues, and task permissions.
Assist with troubleshooting Providex/ProvideX data tables, file lockouts, and broken indexes when necessary.
Generate operational reports, data exports, and audit logs using Custom Lookup Views, Business Insights Explorer, or Crystal Reports.