Client Software Downloads
Questions about our Software?? Click Here!
| Application | Description | Documentation |
|---|---|---|
| ITWCIP Invoice Reprint | ITWCIP Invoice Reprint | |
| TMA PRMS Physical Inventory | Works 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 Planning | Combines 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 Planning | Enhances 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 Analysis | Works 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 included |  |
| TMA PRMS General Ledger Viewer for OLDER WINDOWS VERSIONS | For 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 Viewer | Provides easy search for PRMS JE transactions. Views of Summary, Detail, and Trial Balance. Drill down from summary account balances to detail journal entries. | |
| TMA PRMS PO Vendor/Buyer Scorecards | Analysis 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. | |
| TMA PRMS Menu Master Security | Works 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 Purchases | Works 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 Control | Works with TMA's Source Management. Reviews of checked-out and checked-in source and object creation | |
| TMA PRMS Journal Entry Upload to GL | 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 WO Management | Facilitates 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 Workbench | Maintenance application allowing easy changes to management overrides and forecast parameters. Ability to upload Excel forecasts into PRMS forecast application | |
| TMA PRMS GL Journal Entry Audit | Works 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 Upload | Works 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 Audit | Works 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. | |
| TMA PRMS Customer Order Status | All 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. | |
| TMA Shipment Analysis | Extracts 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 Workbench | An 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 Analysis | Provide 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 Reconciliation | The 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 Upload | This application is used to upload a Customer Remittance Advice in an EXCEL format to PRMS in the form of an AR Cash Batch. Once created, the cash batch can be printed with PRMS option AR0040 Transaction Register, and maintained and viewed with the PRMS Cash Entry option, AR0015, prior to posting to Accounts Receivable. The application features both Corporate and Customer Mode processing. Mixed batches of customers are allowed. The application uses a pre-defined MAP of Excel Columns that includes comment fields to explain miscellaneous adjustments and chargebacks. Unknown invoices are moved to the AR comment field and automatically replaced with the next available AR adjustment number. The imported excel file is validated with all errors highlighted in the spreadsheet. Once validated, AR batches can be created. A transaction history file is created and viewable via a provided Excel Power Query. | TMA AR Cash Remittance User Guide
TMA AR Cash Remittance Upload History |
| TMA Rename File | This application can be used to clean-up and enhance photo or music file names for easier access and use. For files within a selected Folder, you can add a unique prefix or suffix to the file name, you can add sort and add a prefix, incremented number to a file name, or you can remove a music files song and disc prefix number. |
| Application | Description | Documentation/Videos |
|---|---|---|
| Agave Land Lease AppLand Lease | Application 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 LeaseV2 | System Upgrade Only | |
| Agave Land Lease AppLand LeaseV3 | System Upgrade + Changes for Lucid and AREA |
| Application | Description | Documentation/Videos |
|---|---|---|
| QEP OutlookSoft GL | Works with SAP Outlooksoft. Extracts GL summarized transactions into a CSV compatible file for importing into the Outlooksoft application | |
| QEP Emission Monitoring | Collects information on manufactured products and consumed material for analysis in Emissions monitoring. | |
| QEP Dalton Inventory Analysis | Works 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 Labels | Prints Pallet and Box labels used in shipping process. Works with SDQ type orders where labels can be printed by each store. | |
| QEP Supply Chain Workbench | Analysis 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 Print | Facilitates 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 Control | This 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 GL | Works 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 Invoices | Creates 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 Upload | Provides 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 Performance | This 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 Lab | Presents 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 Writer | Based 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 Audit | Custom 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 Build Tax Rates from CSV | This application will convert individual, state-specific CSV files into a consolidated Tax Rate file in PRMS. The CSV files are provided by the Tax Rate service company, AVALARA. When the application runs, it will add the files into the PRMS file, MSTRP100. Once the process is complete, return to PRMS and run program MS9817. MS9817 will use the rates in MSTRP100 to update the PRMS Tax File MSTXP100. |
| Application | Description | Documentation/Videos |
| ITWCIP Invoice Reprint | This is a new and improved version of the "Invoice Print" application. Invoice RE-Print can be used to print an invoice document using data from the Sales History file. This may be necessary when PRMS and Future/3 have purged invoice data from the standard invoice tables. The Sales History file is not purged and contains sales information going back to 2005. | |
| ITWCIP Invoices | Invoice Print can be used to print an invoice document using data from the Sales History file. This may be necessary when PRMS and Future/3 have purged invoice data from the standard invoice tables. The Sales History file is not purged and contains sales information going back to 2005. | |
| ITWCIP Corporate Inventory | Works 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 Inventory | Works 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 Review | This 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 Management | This 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 Analysis | A 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 Scorecards | This 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 Complaints | Record 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 Planning | Combines 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. | |
| ITWCIP SF0320 Scrap Adjustments Upload-Version 2 | Note: New Version published 12/16/2021. Similar to the SF9036 report, but this goes beyond a simple list of scrap adjustments. In this App, the same scrap adjustment list presented in a grid-view with report and Excel download options, but with a single button click, the app will adjust all WO scrap (via SF0320), and for any negative scrap adjustments, the app will also correct the WO/Operation start quantity. Features a new option for Pre-Inventory scrap write-off that compares PRMS to SPEDE where any differences can be selected for scrap write-off with a unique scrap code. | |
| ITWCIP MRD Capture Statistics | This is part of the Material Review Dashboard (MRD) series of applications. This NOT a WINDOWS FORM application, but an EXECUTABLE program that is intended to run from the server scheduler. The program captures snapshots of statistical data on the Press lines into the AS400 file, V84090.CIPMRD10, by Date/Time. The file can be used directly in an Excel Spreadsheet and is also used by the MRD Documentation App and the MRD Desktop App. | ITWCIP MRD Capture Statistics User Guide |
| ITWCIP MRD Snapshot Statistic Documents | This is part of the Material Review Dashboard (MRD) series of applications. This NOT a WINDOWS FORM application, but an EXECUTABLE program that is intended to run from the server scheduler. The program utilizes the snapshots of the MRD statistical data to generate reports used on the shop floor TV monitors. The program should be scheduled to run AFTER the MRD snapshot data capture program. | ITWCIP MRD Generate HTML DOCS User Guide |
| ITWCIP MRD Desktop Application | This is part of the Material Review Dashboard (MRD) series of applications. This is a Windows Desktop Application. The program utilizes the snapshots of the MRD statistical data to generate interactive form inquiries, statistical reports, and charts. |
| Application | Description | Documentation/Videos |
|---|---|---|
| ITW Shakeproof Planning Tools and Inventory Analysis | Initial 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 Version | Same 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. | |
| Christy Product Clean-up | Connects 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. | |
|---|---|---|
| Application | Description | Documentation/Videos |
| Rebates | Define 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 | |
| Commissions | Tracks sales and computes releated commissions earned. Imports payments by customer from Excel spreadsheets. | |
| General Ledger | Creates a rolling 12 month GL based on detail transaction journals | |
| Sales Trends | Tracks 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 Scorecards | Produces 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 Inquiry | Connects 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 Dataview | Presents 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 Upload into a Vendor-Specific Sales Table | Uploads 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 MLS Vendor Sales Upload to Common Vendor Sales Table | Uploads a Vendor's Sales detail from an Excel Spreadsheet to a Common Vendor Sales Detail table on the SQL server. Uses a user-maintained column mapping table to cross-reference each vendors customer spreadsheet to corresponding columns in the Common Table. Performs pre-validation for common data type errors and specifically for an existing cross-reference setup between the vendors customer and the internal customer. Provides before and after statistics on the SQL resulting table versus the Excel input. | |
| Christy SignaturePad | Signature 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. |