Base System Utilities

CZMM, Customer / Zip Code Master Maintenance

Added Country field to the program to allow users to enter dealers for other countries.

Faxing and Emailing Reports

Emailing & Faxing Reports On Demand

GRTM, Generic Report Transmit Maintenance

Set up any report to transmit on demand.

UTFH, Email/Fax History Inquiry/Purge

View and purge transmitted documents.

 

GRTM, Generic Report Transmit Maintenance

New program used to set up and transmit reports on demand.

ILPM, Plant Code Maintenance

Added new Default Mfg Receiving Area field and Default Mfg Receiving Bin field. When entries are made in these fields, then this stock area and bin location will be used as the default for all items for work order receipts with program MRFE, Finished Goods Receipts Entry, and co-product receipts with program MRMR, Work Order Co-Product Receipts.

*     If no default receiving location is entered, the default stock location for the item is used.

*     The receiving location should have the OE Ship flag set to off in program ILMM, Location Master Maintenance.

Removed Confirm Order field from the Batch Shipping Tab. Program OESB, Sales Order Batch Shipping, uses the Shipped Order Status pop-list to determine whether to confirm the orders.

Added new Ship Priority Method option. This pop-list determines in what order the sales orders will be shipped. Choices are:

*     Order Number Sequence: The sales order numbers will be shipped in order.

*     Ship Date Sequence: The orders with the oldest estimated ship date will ship first in order of the ship complete only flag and then order number.

*     Order Date Sequence: The orders with the oldest order dates will ship first in order of the ship complete only flag and then order number.

*     This pop-list works with the Mode of Operation pop-list. For Fully Shipped on All Lines and Partially Shipped modes, the system will check the inventory for the orders in either estimated ship date sequence, sales order number sequence, or order date sequence.

 

MUEW, Windows Menu File Exports

Removed Local Output Directory. Replaced it with Oracle Named Directory. Both web mode and client server mode export to Oracle named directories now. Enter the Oracle named directory to which the "nf" files will be exported. You can double click to see a list of values of the Oracle named directories and their directory path.

The default is the directory path from the NF_FILE_DIR parameter in program MURM, Initialization Parameter Maintenance, which should contain the name of an Oracle named directory. If the parameter does not exist, the default NF_FILE_DIR Oracle named directory is used.

Removed the following nf file definitions from program:

*     Program/Table Cross Reference nf_prx

*     Program/Column Cross Reference nf_clx

*     Wizards    nf_wiz

*     Foreign Key Definitions  nf_fkey

 

MUIW, Windows Menu File Uploads

Removed Local Input Directory. Replaced it with Oracle Named Directory. Both web mode and client server mode import from Oracle named directories now. Enter the Oracle named directory from which the "nf" files will be imported. You can double click to see a list of values of the Oracle named directories and their directory path.

The default is the directory path from the NF_FILE_DIR parameter in program MURM, Initialization Parameter Maintenance, which should contain the name of an Oracle named directory. If the parameter does not exist, the default NF_FILE_DIR Oracle named directory is used.

Removed the following nf file definitions from program:

*     Program/Table Cross Reference nf_prx

*     Program/Column Cross Reference nf_clx

*     Wizards    nf_wiz

*     Foreign Key Definitions  nf_fkey

 

MUJM, Menu and Job Parameter Maintenance

 

Displays jobstream entries in same colors as the application menu.

*     Black designates menus.

*     Red designates reports and jobstreams with reports as the first entry.

*     Green designates SQL processes and jobstreams.

*     Blue designates maintenance, transaction, and inquiry screens.

*     Purple designates web applications, Xephr applications, and other entries that do not fall under the other four colors.

New Type: 70 - Menu Option allows you to run another program as if you had typed that program name in at the menu. For example, the FAGJ menu option runs program GLGJ, Move Generic GL Interface Journal Transactions, but FAGJ is included on the menu for Fixed Assets.

Added the ability to pass drill down keys and values from the program name fields on the Menu Definitions and Job Definitions Tabs. List the drill down key and its desired value after the program name. For example, the FAGJ menu option is set up with the program name: glgj JOURNAL_TYPE=ASSETS .

New [Insert Seq Gap] button. Press this button to insert a gap in the jobstream sequence before this sequence. This sequence and those after it will be renumbered by 1.

Entries in this program are color coded based on their function:

*     Black designates Menus and SQL Processes.

*     Red designates Reports.

*     Blue designates Maintenance, Transaction, and Inquiry Screens.

Default Report Parameters for Jobstreams

Reports can be set up so that report parameters default in the parameter form. There are two ways to do this.

*     If there is no job stream for the report, the parameters are listed after the program name in the Prog Name field on the Program Definitions Tab or the Job Definitions Tab.

*     If there is a job stream for the report, the parameters are listed in the Job Args field of the job sequence that runs the report itself on the Job Definitions Tab.

Rules:

*     Arguments must be separated by commas.

*     If the argument matches a drill down key for the report in program UTKM, Maintain Drill Down Keys, the drill down key will also be set.

*     If the argument does not match a drill down key in program UTKM, Maintain Drill Down Keys, the parameter will be set, but if the parameter doesn't actually exist on the report, you will receive an error when the report is run.

*     Standard date substitution variable can be entered in the list or arguments in order to have the report date parameters automatically default when the report is run.

Standard Date Substitution Variables

All substitution variables are based on the current system date and must be surrounded by the carat character ^

*     ^EOM^ -- last day of current fiscal period

*     ^FOM^ -- first day of current fiscal period

*     ^EOY^ -- last day of current fiscal year

*     ^FOY^ -- first day of current fiscal year

*     ^LEOM^ -- last day of previous fiscal period

*     ^LFOM^ -- first day of previous fiscal period

*     ^LEOY^ -- last day of previous fiscal year

*     ^LFOY^ -- first day of previous fiscal year

*     ^SYSDATE^ -- current system date

Days can be added or subtracted from system date in the variable. For example: ^SYSDATE-1^

Custom substitution variables can be set up. Contact your NDS Project Manager for more information.

Examples:

Program APGL, Detail AP to GL Distribution Detail Report, has LODATE and HIDATE parameters in program UTKM, Maintain Drill Down Keys.

*     To have the report always run for the month to date, the Job Arg field for the report on the Job Definitions Tab could be set to

LODATE=^FOM^, HIDATE=^SYSDATE^

*     If there is no job stream then the Prog Name could be set to:

apgl LODATE=^FOM^, HIDATE=^SYSDATE^

Program PMLBD, Labor Detail Time Report, has STARTEMPNO, ENDEMPNO, STARTDATE, and ENDDATE parameters in program UTKM, Maintain Drill Down Keys.

*     A special menu option for an employee could be set up to run the report and default the parameters to meet that employee's needs.

In the Prog Name field for the menu option on the Job Definitions Tab, the following could be entered:

pmlbd STARTEMPNO=ME, ENDEMPNO=ME, STARTDATE=^SYSDATE-7^ ENDDATE=^SYSDATE^

Prospect Upload Parameter Setup

Some setup is required in this program for program PUTM - Prospect Upload & Template Maintenance.

PUTM_START_IN_DIR: This parameter is the default server directory for reading prospect upload files in program PUTM - Prospect Upload & Template Maintenance. If null, then the value from the UTL_FILE_DIR parameter in this program will be used..

*     Valid value is the Oracle named directory on the server where the files can be found.

MURM, Initialization Parameter Maintenance

 

New Planning Parameters

ICPM_MODE: This parameter determines if the users can modify both the manufacturing enterprise and plant planning parameters in program ICPM, Inventory Planning Data Maintenance.

*     Valid values are A or P. When set to A, the user is an administrative user and can modify both the manufacturing enterprise and plant planning parameters in program ICPM, Inventory Planning Data Maintenance. When set to P, the user is a plant user and can view the manufacturing enterprise planning parameters, but can only modify the plant planning parameters.

New Purchasing Parameters

PDQM_DUE_DATE: This parameter determines whether the purchase order due date will be forced to match the current promise date when the current promise date is changed in program PDQM, PO Detail Quick Maintenance.

*     Valid values are Y or N. When set to Y, the due dates will be forced to match the current promise date. When set to N, the due date will not change when the current promise date is updated.

New Sales Order Entry Parameters

OE_REMOVE_FREIGHT: This parameter is used to determine whether the freight costs and charges will be cleared when a change is made in the sales order entry programs that would potentially affect freight calculation. This parameter is generally used by customers doing their own estimated freight. The changes that could potentially affect freight include changing the order terms or ship via code, adding or deleting line items, and changing item quantities.

*     Valid values are Y or N. When set to N, freight charges and costs are not cleared when the changes are made. When set to Y, freight charges and costs are cleared when the changes are made.

OEHR_EXCLUDE_STATUS: This parameter determines the list of order statuses to exclude from the query, separated by commas. This parameter is used in conjunction with the Exclude Hold Codes and Query List of Hold Codes list. This parameter corresponds with the Exclude Status field. If an entry is made for this parameter, those entries will be displayed in the Exclude Status field and that field will not allow updates. If this parameter's value is left blank, then entries can be made into the Exclude Status field.

If an entry is made for this parameter and either the OEHR_EXCLUDE_HOLD parameter or the OEHR_INCLUDE_HOLD parameter, then only orders with that status and hold codes will be affected.

*     For example, if you wanted to exclude hold code 'Z' but only for quotes, you would enter Z for the OEHR_EXCLUDE_HOLD parameter and Q for the OEHR_EXCLUDE_STATUS parameter. Status 'O' orders that were assigned the 'Z' hold code would still display.

If you wanted to exclude an order status for all but a few specific hold codes, then you would enter the list of hold codes for the OEHR_INCLUDE_HOLD parameter, and enter for the OEHR_EXCLUDE_STATUS parameter.

*     For example, to display only 'Z' hold codes for quotes, you would enter Q for the OEHR_EXCLUDE_STATUS parameter and Z for the OEHR_INCLUDE_HOLD parameter.

*     Valid values are any of the valid sales order statuses. For example: Q, I

Open order status values include:
Q - Quotation
I - Incomplete
O - Complete
J - Confirmed-Incomplete.

OEXP_PHONE_LOOKUP: This parameter determines whether when the user presses the 'F9' key on the keyboard when in the Contact Phone field, the system will open the customer lookup based on phone number or will open a list of values of contacts.

*     Valid values are Y or N. When set to Y, when the F9 is pressed in the contact phone field, the system will open the lookup screen that looks the customer up based on phone number entered. When set to N, the list of values will open.

New Sales Order Acknowledgment Print Parameters

AUTO_ACK_OQEM: This parameter determines whether when there is an automatic drill down set up in program OQEM, Sales Order Quotation Entry/Maintenance, to print sales order acknowledgements, the sales order acknowledgement will be printed when the sales quotation is converted to a sales order.

*     Valid values are Y or N. When set to Y, then the sales order acknowledgement will be printed when the sales order is converted to a sales order. When set to N, the print acknowledgment flag is set to off for the sales quotation before it is converted or saved as won, and the sales order acknowledgment will not be printed.

Modified System Parameters

NF File Directory

NF_FILE_DIR: This parameter determines the Oracle named directory where the nf files exist on the application server when program MUIW, Windows Menu File Uploads, and program MUEW, Windows Menu File Exports, are run. Previously was only used for web mode, but now is used for both client server and web mode installations.

New Vendor Parameters

Vendor Hidden Fields

VEMM_HIDDEN_FIELDS: This parameter determines whether the fields containing sensitive information are displayed in program VEMM, Vendor Master Maintenance, for the user. These fields include:

Bank Routing No
Vendor (Bank)
Acct No
Vendor Acct Ref

*     Valid values are Y or N. When set to Y, the user will be able to see the values in the fields. When set to N, the data will be concealed as asterisks ****.

New Work Order Parameters

ULEM_SHOW_ENTRIES: This parameter determines the default values of the Show Current Day Entries flag in program ULEM, Universal Labor Entry. When this flag is set to on, the displayed time entries with errors are limited to those for the current day. Otherwise all time entries with errors will be displayed.

*     Valid values are Y or N. When set to Y, the flag is set to on automatically. When set to N, the flag is set to off automatically.

ULEM_WO_CLOSE: This parameter determines whether the work order will be closed automatically when the last operation is entered in program ULEM, Universal Labor Entry. The work order will be closed if the following conditions are met:

*     The ULEM_WO_MRFE parameter is set to Y in this program.

*     This parameter is set to S or C.

*     The quantity complete + the quantity scrapped >+ quantity ordered.

*     The labor is being reported against the final operation.

*     Valid values are: S, C, A, or N.

S (Silent) - Close the work order silently when the labor is stopped.

C (Conditional) - Close the work order silently when the labor is stopped, if possible. If the work order cannot be closed silently, ask the user if they want to close the work order short.

A (Ask) - Do not auto-close the work order. Always ask the user if they want to close the work order.

N (No)- Do not auto-close the work order, and do not ask the user.

ULEM_WO_MRFE: This parameter determines whether when the operation is the final operation and the item is non-controlled, the finished receipt transaction is done automatically.

*     Valid values are Y or N. When set to Y, the finished receipt transaction is done automatically. When set to N, the finished receipt must be completed with program MRFE, Finished Goods Receipts Entry.

WO_OPER_VISIBILITY: This parameter determines the default setting of the Downstream Operation Visibility pop-list in program WOEM, Work Order Entry/Maintenance. The setting of this pop-list is used in custom dispatching to determine whether the operations for this work order are visible to the work center for the next operation. The setting of this pop-list is also used in program ULEM, Universal Labor Entry, to determine whether the work order operation can be reported against on the Work Orders Tab.

*     Valid values are O, U, or A.

When set to O, the pop-list will default to Operation Completed. When the pop-list is set to Operation Completed, the operation must be complete to be visible to the next work center. For labor reporting with program ULEM, Universal Labor Entry, the previous operation must be marked complete for the operation to have labor reported.

When set to U, the pop-list will default to Units Good. When the pop-list is set to Units Good, operations with units good reported are visible to the work center for the next operation. For labor reporting with program ULEM, Universal Labor Entry, the previous operation must have units good reported against it and the current operation's units good + units scrapped cannot exceed the previous operation's units good for the operation to have labor reported.

When set to A, the pop-list will default to All Operations. When this pop-list is set to All Operations, then any operation can have labor reported in program ULEM, Universal Labor Entry.

WO_QTY_ADJUST: This parameter determines whether when labor is being reported for operation sequences other than the first operation sequence, the work order quantity ordered will be decremented when the labor detail record is created and quantity was scrapped. Units scrapped in the first operation will not affect order quantity.

*     Valid values are Y or N. When set to Y, the work order quantity ordered will be decremented by the quantity scrapped reported for operation sequences other than the first. When set to N, the work order quantity ordered will be not be affected.

WO_REL_FFLUSH_ALL: This parameter determines whether the operations with manual issue non-controlled components will be pre-issued to work orders when the work order is released. This parameter overrides the standard options for manual component material issues.

*     Valid values are Y or N. When set to Y, all operations with manual issue components and null operations on the bill of material will be pre-issued to work order.

 

NAWM, Wizard Definitions Maintenance

Program is Obsolete.

NAWZ, NAWZ - The Wizard of NDS

Program is Obsolete.

Oracle Initialization Parameters and Setup for NDS

Parameters have changed for the 7.5.3 and 8.1 releases of NDS Applications.

QREF, Program/Table Cross Reference

Program is Obsolete.

SPBM, Bank Code Maintenance

Removed the restriction that the currency code entered must be the same currency code as that assigned to financial enterprise in which the bank record is entered when the Account Type pop-list is set to Company or Both.

The cash account entered must have the same currency as the bank, however.

See also: Accounts Payable and Alternate Currencies

Account distribution codes can be entered in this GL Cash Account field.

The GL Cash Account entered here is only used if no default CASH template is set up in program GPTM, Posting Template Maintenance.

UTFK, Verify Foreign Key Relationships

Program is Obsolete.

UTIR, Windows Registry Maintenance

Program is Obsolete.

UTXP, Cross Reference Program to Table Listing

Program is Obsolete.

UTXT, Cross Reference Table to Programs Listing

Program is Obsolete.