|
|
 |
       |
|
This page contains various "utility" downloads that we are making available at no-charge. If you have any questions, please contact us.
Contents
- Microsoft Excel 2000 - Macro for PRMS GL Accounts
- Microsoft Excel 2000 - Macro for AS/400 Negative Numbers
- PRMS V9.X QDDSSRC for How to access the Text file
- PRMS V9.X QDDSSRC for How to access the Cost file
Microsoft Excel 2000 - Macro for CA-PRMS GL Accounts
This macro is used with downloaded CA-PRMS files, GLTRANxx and GLSUMxx that include the fields: ORGNO, MAJOR, SUB. This macro will create and format a new account number field (column) in your Excel spreadsheet for sorting, subtotaling, and readability. The account number is formatted as 9999999-99999-999.
Suggestion: Place this macro in your PERSONAL.XLS file in the XLSTART folder for common access to all of your Excel spreadsheets.
Formats: GLAccount.ZIP (8 k)
Last updated: September 27, 1999.
Microsoft Excel 2000 - Macro for AS/400 Negative
Numbers
Use this macro to convert an AS/400 negative number to a PC negative number. This macro is critical to the utilization of downloaded AS/400 spool files or screen copies into an Excel spreadsheet. In the AS/400, negative numbers appear with the sign to the right of the number, i.e., 10-. To Excel, this is a text string that cannot be used in a calculation. This macro converts the text to a recognizable PC negative number, i.e., -10.
Suggestion: Place this macro in your PERSONAL.XLS file in the XLSTART folder for common access to all of your Excel spreadsheets.
Formats: NegNumbers.ZIP (8 k)
Last updated: September 27, 1999.
CA-PRMS V9.0 QDDSSRC for How to access the Text file
This logical file definition shows how to access the Product Description that was once in the Product Master, but is now in the Text Master. After downloading the ZIP file to your PC, unzip into TXT, FDF, and TTO files. Use these files to upload the file into an AS/400 DDS source file where it can be compiled.
Formats: ZMSPMLJ2.ZIP (2 k)
Last updated: April 17, 2000.
CA-PRMS V9.0 QDDSSRC for How to access the Cost file
This logical file definition shows how to access the Product Costs that were once in the Product Master, but is now in the new Cost file. After downloading the ZIP file to your PC, unzip into TXT, FDF, and TTO files. Use these files to upload the file into an AS/400 DDS source file where it can be compiled.
Formats: ZPCPML21.ZIP (2 k)
Last updated: April 17, 2000.