Client Software Downloads

TMA Installation SupportQuestions about our Software??  Click Here!

TMA-Generic

ApplicationDescriptionDocumentation
TMA PRMS Physical InventoryWorks with resulting work file from TMA's PI/CY summary build. Provides tag detail and product summary analysis of counts-in-process and final counts in units and values.
TMA PRMS MRP PlanningCombines much of the PRMS Planning information into one application with quick drill-downs to relevant information. Search MRP Exception Messages and Suggested POR's. Drill-down to Demand Pegging, Lower-Level Availability, MPR Vertical Format, Forecast History, Demand History, PO and Work Order History. If authorized, allows user to create WO's direct from application.
TMA PRMS Customer Order PlanningEnhances Buy/Make to Order planning. Summarizes Customer Open Order Product demand by user-defined calendar periods, comparing to On-Hand Inventory, Open PO's and Open WO's. Based on user-entered cut-off date, determines shortages. If authorized, allows user to create WO's direct from application.
TMA PRMS Sales AnalysisWorks with TMA's Sales History File and APP. Multi-dimensional view of Sales by Customer, Product, Sales and Product attributes, and Date or Fiscal Period. Multiple filter options filters by dimension options plus choices of Sales, Credits, or Both, and Invoice Detail or Summary Sales. Drill-downs by Customer and Product and ability for user to create own drill-downs in Grid Views. Reports and Charts includedSales Analysis Video
TMA PRMS General Ledger Viewer for OLDER WINDOWS VERSIONSFor OLDER WINDOWS Versions -- PRMS GL Viewer. Same features as the standard version except it uses IBM OLEDB for connection to the AS400. Slower, but still works.
TMA PRMS General Ledger ViewerProvides easy search for PRMS JE transactions. Views of Summary, Detail, and Trial Balance. Drill down from summary account balances to detail journal entries.filmplay
TMA PRMS PO Vendor/Buyer ScorecardsAnalysis of Vendor Delivery performance comparing receipts to the Expected Date and a computed Due Date based on product lead-time. Categorizes receipts into On-Time, Early, and Late. Buyer Performance analysis looks at timeliness of order releases considering required date, lead-time, and work days. Categorizes PO releases into On-Time, Early, and Late. Fully supported with a variety of analytical report and charts, including trending.
How to Copy your macros to a Personal Macro Workbook


TMA Excel Macro Negative and Text Workbook
This is NOT an application, but an Excel Macro workbook that you can use with Downloaded iSeries files or converted iSeries Spoolfiles into Excel. One macro converts Excel cell values to text which is helpful when a column of downloaded iSeries data is mixed alphanumeric. This is very helpful when trying to use VLOOKUPS. The other macro converts negative numbers by flipping the negative sign from right to left so Excel will recongize the cell value as a negative (50.0- converts to -50.0). Instructions show how to imbed the macro into your start-up Excel Workbook.Excel Macro Video
TMA PRMS Menu Master SecurityWorks with TMA's Menu Master Manager. Provides various views to user and class access to PRMS option authority, including MS0800-User Profile screen-control flags. Maintainable authority direct from application
TMA Vendor Planned PurchasesWorks with TMA's auto-calendar creator to summarize MRP POR's into next 12 month's calendar by Product by Vendor. Generated report gives vendor future outlook on planned orders.
TMA Source and Object ControlWorks with TMA's Source Management. Reviews of checked-out and checked-in source and object creation
TMA PRMS Journal Entry Upload to GLOBSOLETE-REPLACE BY JEUPLOAD_V2 -- Reads Excel spreadsheet and uploads to PRMS General Ledger. Works with TMA's iSeries interface, and if TMA's Speedy GL Rebuild is installed, will also auto-update the GL Summary file.
TMA PRMS Journal Entry Upload to GL_Version 2** NEW ** JEUpload_V2 -- Reads Excel spreadsheet and uploads to PRMS General Ledger. Works with TMA's iSeries interface, and if TMA's Speedy GL Rebuild is installed, will also auto-update the GL Summary file. New Features include: Unlimited GL Company Definitions, Multiple Date Formats, Extended Spreadsheet Validation, XLS or XLSX Spreadsheets, Spreadsheet Setup and Validation Instructions in Help Menu. Note to Existing Users of Older Version--You will need to Re-Enter Preferences.
TMA PRMS WO ManagementFacilitates product reporting and material issues. Supports by-products and scrap reporting. Features to auto-complete Operations and related Outside PO Lines. Separate option to mass close selected Work Orders. Various inquiries and reports, including Label printing for generic and custom product tags.
TMA PRMS IM Forecast WorkbenchMaintenance application allowing easy changes to management overrides and forecast parameters. Ability to upload Excel forecasts into PRMS forecast application
TMA PRMS GL Journal Entry AuditWorks with TMA iSeries Journaling control over PRMS Journal Entry transactions. Provides various searches and views to deleted journals or before and after changes.
TMA Payroll UploadWorks with TMA Payroll Interface app that validates and sends approved upload to the PRMS General Ledger. Options to create accrual and reversing JE for payroll over split weeks. Graphics400 app selects payroll data from a CSV file (provided by 3rd party payroll company) and uploads the iSeries interface file.
TMA PRMS Vendor Master AuditWorks with TMA iSeries Journaling control over PRMS Vendor Master (MS0806) and Vendor Payment Data (AP0800). Provides various searches and views to master file changes, adds, deactivate, and reactivate. Also includes display of current vendor master information.filmplay
TMA PRMS Customer Order StatusAll information on Customer Orders from Order Header to Line Item detail. Initial filters by Warehouse, Dates, and Order Status. Initial Views by Days Chart, Order Summary, or Order Detail. Drill-down from Chart or Summary to Detail. filmplay
TMA Shipment AnalysisExtracts PRMS Shipment information by customer and range of Order Entry Dates. Calculates lapsed work days from time of Order Entry to time of Shipment. Date is presented in an interactive grid that computes average days on sorted and filtered information. Grid data can be exported to Excel. From Grid, available reports include summary and detail, with and without Barcharts.
TMA Accounts Receivable WorkbenchAn all-in-one, great replacement for the PRMS AR0005 AR Inquiry Option, AR0050 AR Trial Balance, and AR0060 AR Aged Report. More flexibility with aging criteria with up to six user-defined aging periods presenting data in charts and grids. More visibility with Grid views and drill-downs for corporate customers, customers, invoice summary, and invoice transaction detail. Choices include selection of only debit balances, credit balances or both and to Age by Due Date or Invoice Date. Grid views are user-customizable including grouping, filtering, sorting and layout options. One-Click Export of grid results to MS-Excel.
TMA Product Planning Review and Inventory AnalysisProvide a review of planning factors and the impact on inventory. Analysis of inventory includes daily and weekly usage and classification of inventory by Active, Slow-Moving, and Obsolete.
TMA AP Check ReconciliationThe AP Check Reconciliation application is an enhancement and replacement to the PRMS AP Check Reconciliation option. The application provides two methods for reconciling AP Checks. The first method is very similar to the PRMS option, but works within a configuration windows dataview. The dataview option offers a much easier point/click to clear and reset checks. The second method will clear checks by uploading from an Excel spreadsheet provided from your bank.
TMA AR Remittance UploadThis application reads, validates, and uploads an Excel spreadsheet to a PRMS AR Cash Batch File. Options include uploads by a single customer, a corporate customer, or mixed customers. To accommodate various spreadsheets formats, you can start with a default cross reference of spreadsheet columns by data type and then, overriding for a specific spreadsheet. In the upload process a workfile is first created on the AS400, then is converted to a PRMS AR Cash Batch file. There are options within the application to review the uploaded workfile, rejected records during the upload process, and the resulting AR Cash Batch file. Once uploaded, you have all normal Cash Batch related PRMS functions in AR0040, including printing the batch, deleting the batch, processing the batch, and in AR0015, editing specific entries within the batch.

Agave-Custom
ApplicationDescriptionDocumentation/Videos
Agave Land Lease AppLand LeaseApplication viewer of all Land Lease Information. Options to select specific company, and to limit initial view to specific leases by company. Eight different lease tables displayed in interactive grids. Information grid has drill-down to related information in 7 other tables. Within grid, can sort, filter, lock columns for fixed positions, hide/show columns, create grouping by one or more columns. Modified grid layouts can be saved. A saved layout can be designated as the startup-view. Grids can be exported to Excel. Reports are available for all lease data. Print color coded labels for related manual file system.
Agave Land Lease AppLand LeaseV2System Upgrade Only
Agave Land Lease AppLand LeaseV3System Upgrade + Changes for Lucid and AREA

QEP-Custom2
ApplicationDescriptionDocumentation/Videos
QEP OutlookSoft GLWorks with SAP Outlooksoft. Extracts GL summarized transactions into a CSV compatible file for importing into the Outlooksoft application
QEP Emission MonitoringCollects information on manufactured products and consumed material for analysis in Emissions monitoring.
QEP Dalton Inventory AnalysisWorks with PRMS Inventory and WMS SQL Inventory. Looks at customer orders by schedule date, comparing primary stocking location available inventory with report on shortages and availability in the WMS bulk locations
QEP Homelux Shipping LabelsPrints Pallet and Box labels used in shipping process. Works with SDQ type orders where labels can be printed by each store.
QEP Supply Chain WorkbenchAnalysis of On-Hand and projected inventory in Units and Values. Summary and detail presentation in monthly and weekly time periods of projected inventory. Detail includes forecasts, customer orders, PO's, WO's, and WO Issues to compute period projected inventory. Calculates turns and compares targeted periods. Reports and dashboards.
QEP PO/Receiver PrintFacilitates 3-way matching in accounts payable. Works with forms managment software to print archived signed purchase orders and the related PRMS receivers. AP can view PO's with outstanding receipts that have yet to be matched to invocies.
FedEx Shipping Interface Worked with FedEx. Supplied a DLL loaded on FexEx server that when a Customer Order is entered or scanned, looks up shipping information from the PRMS order and returns the informatoin back to FedEx for label printing.
QEP Indiana Log ControlThis is a stand-alone full-featured application to control inventory logs by serial number. Logs are tracked from receipt to location movement to consumption. Application provides multiple view in grids, charts, and reports. Provides summary information of receipts for entry into PRMS.
QEP Payroll Upload to PRMS GLWorks with TMA Payroll Interface app that validates and sends approved upload to the PRMS General Ledger. Options to create accrual and reversing JE for payroll over split weeks. Graphics400 app selects payroll data from a CSV file (provided by 3rd party payroll company) and uploads to the iSeries GL interface file.
QEP Vitrex InvoicesCreates a Proforma Invoice based on an existing PRMS Invoice. Allows user to remove lines in error and then reprint for submission to customer.
QEP AR Remittance UploadProvides a front-end interface to the PRMS Accounts Receivable Remittance Advice Processing feature. Use this application to browse to an EXCEL file representing a customers detail remittance, and then point to the specific columns for the invoice number and payment and upload. The contents of the spreadsheet will be validated and if no errors, the contents can be uploaded to the AS400 remittance work file. If errors do exist, they are highlighted in the spreadsheet that can also be opened for edited directly from within the application. The next step in the process is to trigger an AS400 job to process the uploaded remittance advice. Validated records to the customer/invoices in AR are accepted into the PRMS AR Batch Input file, rejected are sent to a Rejection file. The application includes options to view in a Grid, Report, or Export to Excel the uploaded remittance advices and the rejected payment records. Once added the PRMS AR Batch input file, the use can finalize processing in PRMS to post the remittance advice.
QEP PO Vendor PerformanceThis is a customized version of TMA Analysis of Vendor Delivery Performance and Buyer Order Performance. The standard version has been modified to analyze based on the Requested and Actual Shipping Dates rather than the actual Receipt Dates. An option to identify in-transit time by vendor has been added and factored into the overall lead-time to compute and separate the vendors responsible manufacture time vs transit time. Shipments are compared to the Expected Ship Date and a computed Ship Date based on product lead-time minus transit time. Categorizes receipts into On-Time, Early, and Late. Buyer Performance analysis looks at timeliness of order releases considering required ship date, lead-time, and work days. Categorizes PO releases into On-Time, Early, and Late. Fully supported with a variety of analytical report and charts, including trending.
QEP Adhesives LabPresents a variety of Excel Extracts, Dataviews, Reports, and Charts related to the Manufacture and Consumption of Adhesive products and related materials. The source of the data is directly from the PRMS Shop Floor Work Order application. The application information is real-time, in sync with the PRMS data updates. When viewing, choices include a date range of activity, parent part, component part, and work order.
QEP GL Report WriterBased on the PRMS GL Report Writer, this application extends the Report Writing capability to Crystal Reports using HelpSystems SEQUEL. This application gives the user access to the Validation Master for assigning Accounts to Report Rows and Columns, and to the GL Company Control where GL Companies can be assigned to report rows and columns.
QEP Vendor Master AuditCustom Version of TMA Vendor Master Audit for QEP. In addition to standard features, includes additional information for V92/V10 Additional Vendor Master fields, including separate views of the Bank Information form fields. The application requires the installation of TMA iSeries Journaling control over PRMS Vendor Master (MS0806) and Vendor Payment Data (AP0800), and Bank Information (MS0832). Provides various searches and views to master file changes, adds, deactivate, and reactivate. Also includes display of current vendor master information and Bank Information master.
QEP Change Sales Rep in Sales HistoryCorrect Region/Salesman in Sales History Table

CIP_CustomApps2
ApplicationDescriptionDocumentation/Videos
ITWCIP Corporate InventoryWorks with WMS, SPEDE application, and PRMS. Provides side-by-side comparison of Distribution inventory. Drill down from PRMS to related SPEDE inventory tags. Locations and serial number tracking. Options to monitor and analyze physical and cycle inventories.
ITWCIP WIP InventoryWorks with WMS, SPEDE application, and PRMS. Provides side-by-side comparison of Shop Floor WIP by Work Orders and Raw Material inventory. Drill down from PRMS to related SPEDE inventory tags. Locations and serial number tracking. Options to monitor and analyze physical and cycle inventories.
ITWCIP Product Planning ReviewThis is a customized version of the TMA app. Includes options to analyze inventory from saved history files and custom calculations for inventory classifications.
ITWCIP Work Order ManagementThis is a customized version of the TMA app. Includes integration between PRMS and the WMS SPEDE application, providing comparisons and drill-downs from PRMS to SPEDE tags.
ITWCIP Margin AnalysisA pop-up custom calculator for customer service to play what-if between margins and sell prices, interface to PRMS for variable and fixed costing.
ITWCIP PO Vendor/Buyer ScorecardsThis is a customized version of the TMA app. Includes integration between PRMS and the WMS SPEDE application. WIP/SPEDE Tags by Operation are used to determine the initial date the outside vendor received material and the completion date when the material was returned. Lead-Times and a LT Date are derived from the first and last WO process for that vendor.
ITWCIP Customer Quality ComplaintsRecord and Track Customer Quality Complaints. Includes options to link and cross-reference related documents, track historical sales by part number, track on-hand inventory by lot and location.
ITWCIP MRP PlanningCombines much of the PRMS Planning information into one application with quick drill-downs to relevant information. Search MRP Exception Messages and Suggested POR's. Generate a Customer Requirements Shortage Report. Drill-down to Demand Pegging, Lower-Level Availability, MPR Vertical Format, Forecast History, Demand History, PO and Work Order History.

Shakeproof_CustomApps
ApplicationDescriptionDocumentation/Videos
ITW Shakeproof Planning Tools and Inventory AnalysisInitial features of this application are to show customer requirements from Future/3, and to net against On-Hand Finished Inventory and WIP by expected date.
ITW Shakeproof Planning Tools and Inventory Analysis-OLEDB VersionSame as above Shakeproof Planning Tools and Inventory Analysis, EXCEPT, this version uses a slower connection method to the iSeries. Try this if you are experiencing difficulties with the original version.
ITW Shakeproof AR Remittance Upload from ExcelProvides a front-end interface to the PRMS Accounts Receivable Remittance Advice Processing feature. Use this application to browse to an EXCEL file representing a customers detail remittance, and then point to the specific columns for the invoice number and payment and upload. The contents of the spreadsheet will be validated and if no errors, the contents can be uploaded to the AS400 remittance work file. If errors do exist, they are highlighted in the spreadsheet that can also be opened for edited directly from within the application. The next step in the process is to trigger an AS400 job to process the uploaded remittance advice. Validated records to the customer/invoices in AR are accepted into the PRMS AR Batch Input file, rejected are sent to a Rejection file. The application includes options to view in a Grid, Report, or Export to Excel the uploaded remittance advices and the rejected payment records. Once added the PRMS AR Batch input file, the use can finalize processing in PRMS to post the remittance advice.

Christy-Custom
Christy Product Clean-upConnects to Sequel database product master with add-on table and columns for product classifications. Validates updates by product by type of classification, controlled by user setup of master tables and column relationships. Options for mass updates using filtered grid rows or from Excel. Data maintenance via interactive data grids for easy user customization, drill-downs, reports and exports to Excel. 
ApplicationDescriptionDocumentation/Videos
Christy RebatesDefine Rebate cards including level breaks and discounts by product group, product line, and product with exceptions within group. Prints rebate report showing earned discounts and required purchases to reach next level discount. Tracks rebate accruals and rebates paid
CommissionsTracks sales and computes releated commissions earned. Imports payments by customer from Excel spreadsheets.
General LedgerCreates a rolling 12 month GL based on detail transaction journals
Sales TrendsTracks and charts a rolling 12 months of sales categorized by customers, products, and product groups.
Sales Actual vs Budget Tracks and compares Actual period and YTD sales versus budget and Previous year. Reports, charts and export files for use in Crystal Reports.
Customer ScorecardsProduces a Customer Scorecard with analysis of top 10 product sales, bottom 10 product sales, and gains/losses in sales since last year. Charts and detail provided.
Christy Customer InquiryConnects to Sequel Eclipse Customer Master. Dataview and Report Options. Included pre-filter options to limit views by time, customer, and item. Options to work with production or development.
Christy MLS Zurn Sales DataviewPresents a dataview of Zurn Sales Detail with options for pre-filtering, exports to Excel, and pre-defined reports. Choose to run from production or development environment.
Christy MLS Vendor Sales UploadUploads a Vendor's Sales detail from an Excel Spreadsheet to the designated Syteline Sales Detail table on the SQL server. Provides before and after statistics on the SQL resulting table versus the Excel input. Select from multiple vendors with choice to upload to production or development environment.
Christy SignaturePadSignature Pad - Prompt for signature on Signing Pad with option to save to a designated folder path. The saved file name is linked to the related Shipper ID.
Christy TCE Sales Presents a dataview of TCE Sales Detail with options for pre-filtering, exports to Excel, and pre-defined reports.