System-Wide Settings - Part 2 (Green Screen menu option SET 4)

This program contains system-wide or global (all companies) settings. These settings pertain to many different functions throughout the system. The System Wide Settings affect everyone, regardless of company or branch.

Field Name

Description/Instructions

Options for Language Code Settings

This setting allows our customers who are using the form overlay functionality (introduced in 2005) to change the language on the forms as needed. The available languages are English (the default), French, and Spanish. As of this point, only invoice form overlays are affected.

If you want to use the ability to change languages on your invoices, and other documents, enter a Y in the Do you want to control invoices by language code field.

Enter the default language in the What default language code would you like to use field. To display a listing of the available languages, enter a "?" and press Enter.

When invoices are run your default language is used unless another language code is found for specific customers, in the Billto File.

Options for Navigator

Items Detail Window - Hide P type special instructions for users without access to enter POs - Hides Purchasing notes from users who do not have access to enter POs.

  • Associated File - Item File - Purchasing notes are entered via the Special Instructions option.
  • Purchasing Notes are included in the Product Knowledge section of the Item Detail window; unless they have been flagged to not appear.

Allow invoicing by status code for direct ship orders - Enter "Y" to allow direct ship orders (DIR warehouse) to be invoiced by status code. This can help reduce time spent in invoicing for DIR orders. Works in conjunction with the Pull by Invoice window in Nav Invoicing.

Use the Populate Supplier Invoice Number as _______ or leave blank to default to INVmmddyy setting to create a default invoice number for DIR order invoices. The invoice number can consist of letters, numbers, and special characters.

Default Account Number for pricing within Item Search - Adds a Pricing Account drop down menu to the item Search results. This can provide the ability to search and see pricing by account while viewing the item search results.

Disregard User Warehouse Restriction in Navigator OM Search - This setting prevents the warehouse from being auto populated in the OM search filter. It was implemented in 2019 to implement a "combo search" that searches both retail and billto files to find orders for customers. Which makes it easier to search for customer accounts or retail customers in Navigator.

 

Field Name

Description/Instructions

Options for Navigator Agency Sales
This setting has to be activated via an Agency software key. Furthermore, both CRM and Agency Sales cannot be active at the same time on the same system.

Agency sales can be activated this setting. When activated, a new order option appears in Order Management called New Agency Order. The Agency Order workflow is similar to the direct ship order workflow. The order type is defaulted to S.

If Activate Agency Sales is not set to "Y" then none of the other options are available.

Omit Agency Sales From Invoice Register - This setting directs the system to include Agency Sale invoices on the invoice register. If the Agency Sales invoices are included:

  • Net/A.R = Total Commission and GP% = Total Commission / Gross * 100.
  • GP % is Calculated the same as normal except GP$ = Total commission.

Omit Agency Sales From Sales to GL Interface and Omit Agency Sales From AR to GL Interface - The daily GL executes these 2 interfaces to create temporary journal entries. If these settings are set to Y, the Daily GL omits Agency sales from the JEs created.

The default for all the options is "N".

For a complete write-up on Agency Sales click here.

For more information on Invoicing Agency Sales, refer to Invoicing in Navigator.

Options for Navigator File Management

The setting Default FM filter comparison operator allows for the establishment of a default comparison in the Navigator File Management Filters.

If anything is entered into the filter box, and the comparison box is blank, enter the Default FM Comparison.

Options for Night Jobs

Gives the option of setting the Back Up Option for night jobs.

  • Select the Backup Option For Night Jobs - Enter a 1 if you want to run back up before you perform night jobs, or 2 if you want to run back up after you perform night jobs. It is recommended to run back up after you run night jobs so that night jobs will be saved on you back up disk.

    Warehouse personnel can utilize all features on the Warehouse Menu starting approximately half way through Night Jobs. This reduces down time for warehouse night shifts by approximately 50%. If you set this option to perform backup before Night Jobs, the system performs as follows:

    • Automatically shuts all interactive user sessions.
    • Completes backup

    • Completes essential daily tasks such as updating daily statistics, updating AR, etc.

    • Reopens the system only to users assigned to Menu WH (Warehouse Functions) or INQ (Inventory Inquiry).

    • Completes unessential tasks and cleanup

    • Reopens the system to all users.

    When following the above procedures your night shift warehouse personnel should experience a consistent schedule of downtime versus uptime. The backup and restricted portion of Night Jobs should take a similar amount of time each night. However, there are two jobs that can affect this schedule. When you request to change item numbers (which causes all files to be read and reorganized) that program must run in a restrictive state. Therefore, downtime will be greater on nights when item changes are run. You should schedule item changes for weekend nights. End of Month close of Accounts Receivable must also run in a restrictive state. Therefore, warehouse personnel should be alerted when End of Month will be run.

  • Do not allow Navigator scheduled jobs to start between - Allows a system administrator to define a time range in which user defined Navigator jobs cannot be scheduled. This setting helps resolve customer issues that arose after the release of the Report Scheduling process and will also be used by other user defined schedule programs in Navigator such as GL, Installation Manager, and AR End of Month Scheduler.

  • Backorder consolidation active - Enter a "Y" to activate back order consolidation functionality. Order lines can be consolidated if:

    • the back order lines are from the same warehouse
    • and the same order
    • and are at the same order status
  • Consolidate backorder lines in the following status - Only Back Order lines at this status, at the same warehouse and on the same order, are consolidated. Order status codes are created via menu option SET 7.

A spool file report, BOCONSOLPR, is created showing all canceled and created lines.
Options for Online Payments

This option allows you to set the number of days until a Remittance Advice expires.

The remittance advice transactions in the AR Payments Tab in Navigator will be removed by night jobs after the expiration days established by this setting are passed. A zero or blank value denotes no expiration.

Options for Order acknowledgments

This is a series of options that control how Order acknowledgments print. You may specify the title of Order acknowledgments to be left as is, or be changed to "Sales Receipt" or a user-defined title. You may also choose to include detailed payment information, regarding the payments received that day against the order being printed.

Select a title for Order Acknowledgment - When you place an X by your choice and press Enter it is automatically inserted into the entry line to the right of option 4. Create your own title by entering it after option 4.

Show detailed payment information in body of Order Acknowledgment - To display payment information on the order acknowledgment, enter a Y. This payment information is limited to payment received on the day the acknowledgment is issued. However, the balance due includes all payments made to date.

Note: The detailed payment option relates only to systems with option 2 Cash Register Screen activated in the System Wide Settings.

Consolidate order lines w/same item, warehouse, serial#, and price? - Activating this setting by, entering a Y, combines order lines that are for the same item serial number, at the same price, and from the same warehouse. Instead of having multiple lines for the same item this setting combines all like information (same item, serial number warehouse, and price) into one line with a total quantity. The default is N.

  • Sidemarks present some tricky situations for splitting and then consolidating lines. Sidemarks are the lines that immediately following a detail line (line 0011 for 0010, or 0021 for 0020).

  • Note: A message line is NOT considered a sidemark if it has a dollar value.

  • Under the following conditions, split lines can be consolidated:

    • Lines that are split by ISO will be consolidated if the last line created by ISO has the sidemark - and the other lines have no sidemark. This is because when ISO creates multiple lines, users will press F6 and enter sidemarks after the last line.
    • Lines that are separated due to back order fill (where it takes more than one receipt/line to fill a single order line), will be consolidated if the original (back ordered) line has a sidemark and the new lines do not. This is because back order fill leaves the sidemarks on the original line(s).
    • Lines that are separated due to the use of the Split Line program (where the new lines are usually added to the bottom of the order), will be consolidated if the original line has a sidemark and the new lines do not. This is because the Split Line program leaves the sidemarks on the original line(s).
  • If the following conditions apply, lines cannot be consolidated:
    • the lines have different item numbers, warehouse, serial numbers, or unit prices.
    • the lines have different line-item ship dates.
    • one line is open, and one is canceled or invoiced.
    • if the two detail lines have 2 different sidemarks, they should not be consolidated. You can purposely keep lines from consolidating by entering different sidemarks.

Print Serial#s - If this option is set to Y, serial numbers are printed on the Order Acknowledgements.

Print Weight - If this option is set to Y, the total weight of the order is printed on the Order acknowledgement, broken down by in-stock items and back ordered items.

Number of copies for "L" (laser) form - This field allows you specify the number of copies of an Order Acknowledgement to print on a laser printer. If left blank, 1 is assumed.

Print Name & Address at top of laser form - This field lets you decide whether or not to include your company name and address at the top of the Order Acknowledgment form. Laser printed order acknowledgments, as designated by an L entry on the Control Panel, do not require preprinted forms and therefore are well suited for faxing and emailing. However, customers who want to use the laser acknowledgment format on a pre-printed form, may now turn off the address that prints at the top of the form, and use that space on the pre-printed form, for a logo.

Leave room for logo on top left of form - Leaves room at the top left of the form to allow for pre-printed information.

Print invoiced lines (as well as open lines) - Enter a Y to include both invoiced and open order lines. The default is N, which causes only open lines to print on an order acknowledgment.

Print separate subtotals for materials plus labor - Enter Y to print subtotals for material versus labor at the bottom of the order acknowledgment.

Status description - This option lets you change the "standard" status descriptions to better match your companies processes. If there are no entries the defaults, In-stock, On Order, In Stock, and Special are used.

When a value is entered for the Special setting, it appears as the status on Order Acknowledgment lines that have the Special Order option selected.

Status description for Direct Ship Orders - allows you to change the "standard" status descriptions to better match your companies processes. If there are no entries the default, Direct, is used. This functionality only works with laser printers (form code "L" in the Print Orders on setting on the Control Panel).

Options for Order Acknowledgments - Part 2

These settings give you control over what prints on an Order Acknowledgment.

Print REPRINT when request is from Order Change or Order Inquiry - When this option is activated, and an order acknowledgment is generated from either Order Change or Order Inquiry REPRINT is also printed.

Print "No ETA" in b/o date column if date is 2/22/22 - Enter a Y here to direct the system to print No ETA in the Back Order Date column instead of 2/22/22. A back order date of 2/22/22 indicates that there are no purchase orders or production schedules that can fill the order. If the setting is not activated, 2/22/22 prints as the date in the Back Order Date column.

Create header data file for third-party document programs - This setting provides the functionality to export order shipto information and order header message lines to a database file. This database file can then be accessed and manipulated by a third party document software.

Default spool file setting - The system, including Navigator, uses the Output Distribution System (ODS) to distribute documents.

This setting includes the following settings for a default spool file setting.

  • 1 - Leave as is- This leaves the spooled file in the output queue as though it had been manually printed.

  • 2 = Print- This sends the spooled file to the output queue in a *RELEASE status.

  • 3 = Hold - This sends the spooled file to the output queue in a *HOLD status.

  • 4 = Delete - This deletes the spooled file after it has been distributed.

  • blank - Leave - If you leave the setting blank, the Leave as is option is used.

Note: Prior to this setting being added, in 2014, the ODS Spool file default was "Leave as is". With the Leave as is option, the document goes into the ODS spool file where it can be accessed and printed, held or deleted.

Suppress line ship date from printing on Acknowledgments - When this setting is Y, the line level Ship Date is not displayed on the Order Acknowledgment. The column is blank.

Options for Order Entry "Duplicate Order Warnings"

This System-Wide Setting contains several settings and controls for alerting users when a customer orders an item that is already on any of the following open transactions for the same customer:

  • Open Order (from OPENPO file)

  • Unprocessed Order (from PENDING file)

  • Open Quote Management System quote. (from QUOTEDET file)

Whenever you make any changes to these settings, users must sign off the system and then sign back on for the changes to take effect. This is true for most system settings, because they are only accessed at the beginning of a user's session.

The basic functionality is as follows:

  • The system checks files, as selected in the System Wide Setting, for a match on customer account# and item.
  • If any matches (potential duplicates) are found, a window is displayed listing all of the potential duplicates, and allowing the following options to the user:
    • Ignore and proceed with entering the new order.
    • View any of the potential duplicates (which could be in the unprocessed orders, open orders, or Quote Mgmt System files).
    • Delete the order being keyed and switch to one of the displayed orders. This would delete all records on the current order, and load the Order Entry, Order Inquiry, or QMS program.

Business Case

Consider using this feature for the following reasons:

  • Display previously entered quotes, so that any special pricing can be used, thereby avoiding needless credit memos later.
  • Display orders that were already called in when contractors or installers are not aware if the orders were already placed.
  • Avoid rekeying an order that was already called in as a "hold".

Check for and issue "Duplicate Order Warnings" in Order Entry? - Enter a Y to activate the duplicate order warning feature.

Check for duplicate on 1st line of order (1) or on all lines (2), Check for duplicate orders in the Open Orders File?, Check for duplicate orders in the Unprocessed Orders File?, Check for duplicate orders in the Quote Management System File?- These fields allow you to direct this feature to check other parts of the system for duplicate orders and to only check the first line of an order or all the lines. The Open Order file contains only processed orders. Unprocessed orders consist of quotes and temporary holds. The Quote Management System is generally used for commercial jobs that may be assigned to multiple customers.

Check for duplicate order using just item#, or item# plus within % of quantity keyed - Enter a 1 to limit the duplicate order check to item numbers or a 2 to use a percentage of the order quantity. For example, if 050 is entered as the percentage and the quantity is 100.00, then the potential duplicates can only have qty between 50.00 and 150.00.

Customer Types for duplicate order check , Item Classes for duplicate order check - These fields let you narrow or broaden the order check by Customer Type or Item Class. If you include (I) customer types or item classes the system only checks for duplicate orders for the included entries.

If you omit (O) Customer Types and Item Classes, the system checks for duplicate orders for all customer types and item classes except the ones entered.

You may only need to check for duplicate orders for certain types of customers, such as contractors who may not know that the orders they are picking up were already called in.

You should omit classes of items that represent accessories or installation materials that are often on multiple orders. If you do not omit regularly ordered items, then the "duplicate order warning screen" may pop up too often and become a nuisance.

Options for Order Entry Date Required

This setting updates the Ship Date on the order header screen . The Ship Date controls when the order is required to be shipped or picked up.

This option provides you with three default date choices.

If you are using the Delivery System, the next available truck route delivery date for your customer displays automatically.

Ship Date is a required field in Order Entry. Therefore, if you set the default to "No Date", the user is prompted to enter a date.

Options for Order Entry Review Screen

Select a Fund option. The default setting is option 2.

Enter Y to show the 2nd line of the Item Description - To add to the detail of the Review Screen, you can choose the option to display the second line of the item file description. The default setting is N.

Enter Y to underline each line item on the review screen - To add to the ease of viewing the Review Screen, you can underline each line item. Each line, including the miscellaneous lines, will be underlined. The default setting is N.

Options for Order Entry U/M in Item File

This setting controls how the Item File Order Entry UM works. The default option is N, which forces the Order Entry UM field to equal the native pricing UM. Normally, you will want all orders, purchase orders, and invoices to be stored in the system with prices and costs in the native UM only. Then you may use various system tables to control the units of measure on printouts and documents.

If you enter Y in this option, the system allows the Order Entry program to accept an order in an alternate UM and store the price and cost in that UM without first converting it. This can cause confusion when viewing certain screens and reports, and has been known to inadvertently lead to keying errors. We recommend you enter Y for this option with caution and adequate training for all users.

Options for Order Hold

This set of parameters controls which orders are allowed to move into a processed state. This allows you to hold some orders that might need to be reviewed prior to the actual order creation.

This functionality only applies to non-interactive users; which basically encompasses Decor 24 and Channel Management Solutions (CMS) and the Armstrong Sales Portal. Orders entered by interactive users (i.e. orders are entered from a work station that is assigned work station ID) are not in scope at this time.

The System Wide Setting - Options for Order Hold Process activates this functionality globally.

Enter a Y in the setting Enable the Order Hold Process to activate the Conditional Order Release functionality.

Press F9=View/Set Parameters to see the parts of the system where orders can be entered that have had the Conditional Order Release Functionality activated.

Type - This field contains a reference to the type of user the rules are to be applied. At the current time, the only Type allowed is S = System ID. Additional values may be added in the future and may drive the logic for which user ID field in the customer order is to be used to drive this process.

User - This field contains the user initials for which the rules are to be applied. At this time the following user have been created:

  • D24 - !!
  • Armstrong Portal - !A
  • CMS - Operator Initials value as defined in CMS 20, F10 Global Set­tings.

Description - Enter a more detailed description of the user.

To update an existing entry, use the U - Update option.

Enter a "Y" in the Update New Record field to access the order hold parameters established for the user.

Here is how the order validation process works:

  • This validation process begins after the order message is received.
  • If an order does not meet or match any of the defined parameters it is to automatically be released and an Order Number created.
  • If an order meets or matches any of the defined parameters it is held/stopped.
  • If the order is held, it is available for viewing in CUS 15, CUS 16, or Navigator OM as an unprocessed Reference Number only.
  • The parameter or set of parameters that caused the order to be held are to be recorded in the Release Notepad of the order. Since an order only goes through this process once, all parameters are validated and any that are met are displayed.

Shipping Instructions provided - This setting only applies to Decor 24 users. It checks a specific part of Decor 24 (Shipping Instructions field, Message line 4) to see if shipping instructions have been added. All other applications use the parameter F6 Lines Contain Key Words.

Special Instructions provided - This setting only applies to Decor 24 users. It checks a specific part of Decor 24 (Shipping Instructions field, Message line 4) to see if shipping instructions have been added. All other applications use the parameter F6 Lines Contain Key Words.

Line in a Backorder status - Check status of all lines, hold order if any line is in "B" - Backorder status.

Roll and Cut of the same item are ordered - Check for lines containing the same item number. If they have the same item number, check the roll cut indicator. Hold the order if the roll cut indicator values are not the same.

Ship Via is other than default - Check the Bill To file for the order's account to determine whether the selected ship via matches the default value assigned to the account.

S/M line contains a price - Check the S/M line in a Customer Order for a $ character or a string in the format n.nn where n is a number from 0-9.

Ship Date or day not valid per default SV and TR entries - Ensure the shipto date is valid in relation to the Shipvia and Transfer entries.

Ship To Address was manually entered - Check the Order Pending File for Ship to Override set to YES.

Ship To Address is other than the default - This setting checks to see if the Shipto Address was changed to one other than the default entered in the Billto File.

Ship Date is in the past - This setting compares the ship date to the current days date. If the current days date is greater than the ship date, do not auto release the order.

The next several parameters have an Opt field on their left hand side. The Opt field is needed because these parameters have associated data values that have to be entered.

Ship Date is more than X days in the future - Enter a "U" in the Opt field to add the number of days. Add the current days date to the numerical value entered. Compare the result to the ship date to determine if it exceeds that value. '0' is an allowed value in this field.

Customer is part of a Chain - Do not auto release order if the Bill To File chain field for the account number on the order matches any value entered. When the order reference number is received, use the Company and Account number combination to search the Bill To file to determine if the chain listed in the screen is included in this parameter.

Customer is part of a Marketing Program - Do not auto release order if the marketing program code entered in this table is inlcuded in the account's Billto File.

Transfer Line with specific Warehouse and Manufacturer - Check each line on an order for Transfer lines. If found, check the To and From warehouse values and Manufacturer combinations to determine if the order should be held. You can use wild cards in all three fields. Use * as wild card value. You can enter values like RAL, R**, **L, etc.

Transfer Line with specific Warehouse and Item Class 1 - Check each line on an order for Transfer lines. If found, check the To and From warehouse values and Item Class 1 combinations to determine if the order should be held. You can use wild cards in all three fields. Use * as wild card value. You can enter values like RAL, R**, **L, etc.

Specific Header Warehouse and Ship Via combinations - Check the warehouse and ship via combinations to determine if the order should be held. You can use wild cards in all three fields. Use * as wild card value. You can enter values like RAL, R**, **L, etc. Examples

  • An entry of warehouse RAL and shipvia PU means hold all orders that have that warehouse and shipvia combination
  • An entry of *** as the warehouse and a shipvia of PU would mean hold all pickups regardless of warehouse.
  • An entry of warehouse RAL and a shipvia of *** means hold all orders from Header warehouse Raleigh regardless of ship via.

F6 lines contain key words - Check the F6 lines of an order for any words contained in the in the table accessed by entering a "U" in the Opt field. If a match is found the order is to be held. The entries in the this table are automatically display in an alphabetical order. When new entries are added and saved and the screen is exited, upon accessing the table again the enters are displayed in alphabetical order.

Options for Order Search

Enter a N to exclude orders with lines that have 0.00 charges.

Options for Order Status Code Changes

Whenever the Order/Shipping Status Update program (CUS 13) is used to update the status of an entire order or a single line to S (shipped) the current date can be automatically inserted into the Ship Date field, of that line, and of the header screen.

This functionality, working in conjunction with the Force Invoice Date = To Keyed Ship Date field in the AR and Credit Options portion of the Company Settings (SET 3), allows invoice dates to match the shipping date.

This system wide setting activates the ability to automatically change the ship date to today's date at the line or header level.

Click here for a complete write-up on this feature.

Options for Permanent Holds (Order Type=H)

Permanent Holds are holds (sometimes referred to as "reserves") that are processed orders with an Order Type of "H". Do not confuse permanent holds (which are processed orders) with temporary orders (which are unprocessed orders). These new settings enable you to automate various functions based upon this order type. The available functions enable you to (a) automatically send all permanent holds to the Credit Hold screen, (b) release permanent holds from either the Credit Hold screen or the Order Change screen by removing the "H", and (c) prevent release of permanent holds from the "pick pool" screen.

  • Send all Orders with Order Type=H to Credit Hold? - A Y entry here enables the system to use the credit hold functionality to hold the order until the H is removed. If this option is set to Y, all orders with Order Type H are sent to credit hold regardless of actual credit status of the account. The credit hold screen shows an "h" status indicating the order is type H.

  • Allow Release from Credit Hold if Order Type = H? - A Y entry signifies that the hold order may be released from the Credit Hold Screen, when its order type is H. An N entry prevents release of an H order from the credit hold screen.

  • Release Type H Orders From Credit Hold if Type H is Removed Via Order Change - A Y entry here allows for the removal of the order hold condition from the Order Change Header screen. In the Order Change program, if you enter N for this option, the orders may be released from the Credit Hold screen only. If you enter Y, then the removal of the Type H in Order Change also releases the order from Credit Hold.

  • If Type H, Do Not Allow Release From Pick Pool Screen - A Y entry here prevents a label from being printed from the pick label pool for an order on hold. All detail lines of orders with an order type of H display in a different color on the Print Labels to Ship detail screen (option 11 - Pick Labels Print Pool on the Warehouse Menu).

You can set or inquire about the shipping status of a detail line through the Open Order File/ Status Update screen. It is accessed via the F12 - Shipping Data/Status function key from the order entry/inquiry screens. To change the Order Type field, you must access the header through Order Change.

Strategy for use of Permanent Holds

The use of the order option H (Permanent Hold) can be an effective alternative to the use of comments or the "will advise" ship via code, when you want to hold an order while waiting for the information or approval. Order type H may be used for:

  • Job site deliveries that have incomplete addresses

  • Installation orders that are estimates, but require quantities to be confirmed

  • Any orders that cannot be released until additional information is obtained

Options for Pick Labels/Pick Pool

This setting enables you to automatically suppress pick labels or pick pool entries for certain types of orders. This is particularly important for "Credit and Re-bill" orders, in which the debit line is for billing purposes only, and should not be re-shipped. Credits do not automatically generate pick labels or entries in the pick pool. This feature is meant to manage debit order lines that should not be physically handled.

  • Suppress Pick Labels/Pick Pool if detail line credit code = - Identifies a credit code that will prevent an order detail line. When entering credit memo and rebill, as for a pricing correction, you create a credit line followed by a debit line with the correct price. This is done automatically by the Quick Credits feature. Quick Credits puts a credit code on both lines. If you do not use Quick Credits, you should manually key a credit code on both lines. Then, for example, you could suppress pick labels for the credit code you use for these credit/rebill lines.
  • Suppress Pick Labels/Pick Pool if Ship via code = - Identifies a ship via that will prevent an order detail line from printing pick labels and/or being placed in the pick pool. For example, if you use a special Ship Via code for "Billing Only", when no goods should be picked, then that code could be used to suppress picking.

  • Suppress Pick Labels/Pick Pool if Order Status Code = - This setting enables you to automatically suppress pick labels or pick pool entries for order lines at specific status lines.

  • Suppress Pick Labels/Pick Pool if Order is Credit Held and Remove Label Pool Record when printed from Order - These options give you control over what orders are sent to the label pool.

  • Send to Label Pool unless suppressed by another option - Sends label to pool when users end order with F1 in order entry or order change. The label will drop to the pool even if the order line was originally a transfer from a warehouse that didn't have the label pool options enabled and the transfer line has been shipped and received into a warehouse were the label pool feature is operational and that label is not in the pool.
  • Because it will print labels for order lines which may have transferred from one warehouse to another, the label will print for an order line at status (X,A,S,0,1,2,3,4,5,6,7,8,9) - however the program will not change the order line status from one of these values to an L.

Options for Pick List Edit

This option lets you customize the pick list edit document that may be sent to your warehouse by customer service personnel prior to officially processing an order. This enables you to generate documents unique to your operation. A good example of this feature's use is a "cuttings for approval" document that could be used for fabrics, carpet, and other items that need an approval of a sample before the order is shipped.

Long Title - This will be used as the heading on the upper left corner of the pick list edit. It can be 30 characters long and the default entry is Pick List Edit.

Short Title - Can be eight characters long. If the field is left blank (the default), the document will display "Edit".

Header Comment - This entry will be the first comment line on the printed pick list. This entry can be 30 characters and the default, if the field is left blank, is blank.

Detail Line Comment - This entry will be printed on all detail lines of the pick list edit, in the column just to the right of the quantity ordered. This entry can be eight characters and the default, if the field is left blank, is blank.

In the Override Settings for Company field, enter the company number that will use the override settings instead of the default settings.The pick list will display these fields, instead of the defaults, for the companies entered in the Default Settings for Company fields. This gives you the ability to have two schemes for using the pick list edits, depending upon the company.

These entries are visible from two places within the system. The label of the prompt that appears in a customer service order entry to print options, and on the pick list edit document itself.

If you have your pick list printer option set to "XX" in your warehouse file (for paperless picking), then pick list edits will be directed to your Control Panel Print Orders On printer. In this case, you may need to redirect these edits.

Navigator

These settings also effect unprocessed orders in Navigator. Click the option arrow to the left of an unprocessed order and select print.

Options for Pick Lists

This is a series of options that affect the way pick list documents are printed. You can choose to show the status code of each line item on pick lists, and to indicate which items should or should not be picked based upon the status codes.

If you want status codes to display on the pick list for each line, enter a Y in the Show Order Status Codes for Each Line Item? field.

Next, decide if you want to limit (I) the pick list to certain status codes or if there are status codes you want to omit (O) from the list. You can only choose to include or omit, not both. By limiting your pick lists to only include lines at certain status codes, or by omitting lines at certain status codes you are not actually removing the lines from printing. Rather, you are notating that only certain items should be picked based upon their status codes.

In the example of a pick list shown below, notice status code B items are labeled "not at status to pick".

In the example above, the status code of each line shows to the left of the area in which warehouse personnel indicate what they have picked. Any status that you designate to omit (or not include) shows as not at status to pick.

If you are using the bar code pick labels and the pick pool, printed pick lists are not needed. However, if you have not yet activated bar coding and the pick pool, these pick lists techniques can emulate some of the functions and controls of bar code labels and the pick pool.

The option Print area location as part of the location causes the warehouse area to print as part of the location when printing pick lists. This enhancement is for non-IWMS warehouses that use paper pick lists. It's OK if IWMS is active, but the program will not look at IWMS files.

Warehouse areas are created through the Warehouse Areas Table (SET 16). Areas are used to group locations in your warehouse into zones or areas. Each area can be assigned its own bar code printer and each area can be configured for the picking of the bar code labels.

Options for Price List

The system accesses prices based on the customer's price list for the item.

If there is no price for that customer's price list, the following occurs:

  • If this parameter is Y, pricing defaults to list price.

  • If this parameter is N, then the program will issue an error that "Price is not Found".

Associated Files

  • Billto File (FIL 1) - This setting works with Customer Pricing (as opposed to Item Pricing). Customer pricing is set in the Billto File via the Cust Price List# field.

The Cust Price List setting establishes the customer's default pricing level. You can create multiple pricing levels in your system and assign each customer a default level. For example, you might have a builder's price (B1) and a list price (LP) for each item. You would use LP pricing for cash (over the counter) sales and B1 pricing for builders.

You can establish exceptions to the default pricing levels for customers for particular items. This field only establishes a default price level that customers receive when they aren't eligible for any special deals.

Pricing within Order Entry

When an order is entered, the system performs the following:

  • It checks the account number tied to the order and then looks to see if that account number has a price list established.

  • If the customer has a specified price list, the system then checks to see if the item(s) being ordered are included in a price class.

Price classes are based on manufacturers. They included groups of items from the same manufacturer that your company prices identically for your customers.

Price Class should include an entry for each price list. For example price classes for the manufacturer SHASTA could include:

  • SHASTA LP - List prices. List prices are the base or standard prices
  • SHASTA BP - Includes builder prices for SHASTA products
  • SHASTA KD - Includes key dealer prices for SHASTA products.
  • If the items are not included in a price class:

  • List pricing is used. This occurs when the setting Use List Price (LP) as the default price list when customer's price list is not found is activated.
  • The error message "Price is not Found" appears. This occurs when the above setting is set to N.

Options for Pricing by Warehouse

Businesses with several warehouse locations can choose to assign pricing based upon the servicing warehouse, rather than a set price per customer regardless of the servicing warehouse. This system wide setting works in conjunction with the Warehouse Price List Cross Reference table.

Enter a Y in the Activate the Warehouse Price List Cross Reference Table setting. This allows the system to automatically change the price list, according to the Warehouse Price List Cross Reference table, when a header warehouse is changed during order entry.

Options for Printing A/R Statements

Lets you choose to print AR Statements on a laser printer, conventional forms, or overlays.

The field Enter option for printing A/R Statements can have one of the following values:

  • Blank

  • L - Laser Printer - With this option you can select the printer, default number of copies, and the printer drawer where the printer pull the paper for the statements.

  • O - Form Overlay When the new form code O is entered, additional options appear (as shown below).

    • For Overlay - This is where you enter the AR statement overlay and the library where it is located. ARSTOVL0 is the default AR statement overlay and DES12P is the default library where it is located. If there is no overlay specified, the default overly, ARSTOVL0, and library, DES12P, are used. When you first access this screen, these are the default entries.
    • Default Printer - The printer that is normally used to print AR statements.
  • Default # of Copies - Enter the standard number of AR statements you want printed. The default is 1.

  • Default Drawer - Enter drawer number that you want the printer to use for the AR statements. For example, drawer 2 might be set up for ledger size paper or three hole punched paper.

Options for Printing Price Savings on Customer Documents

This setting activates directs Navigator Order Management to automatically generate a message line that shows the customer how much they saved with any special pricing given them.

Multi-Unit orders are not included in this functionality.

  • Option A - Compares selling price to the list price (LP price record)

  • Option B - Compares selling price to the price list assigned to the customer in the customer's Billto file.

  • Blank - The setting is not activated.

Associated Files:

  • Customer Preferences File - The customer must be authorized to see pricing.

Options for Purchase Orders

This option allows you to choose the default file used to populate the payment terms and FOB code during purchase order entry. These defaults can be overridden during order entry.

Default File for Payment Terms on PO in Order Entry: - Enter a 1 to use the payment terms contained in the purchasing account (account 00001) in the Billto File. Enter a 2 to use the payment terms contained in the Supplier File.

Default File for FOB Code on PO in Order Entry - Enter a 1 to use the FOB code contained in the purchasing account (account 00001) of the Billto File. Enter a 2 to use the FOB code contained in the Supplier File.

Print Payment Terms on Purchase Orders? - Regardless of which file you get the payment terms from (Billto or Supplier) if you flag this option to Y, the payment terms will print on the purchase orders.

Update PO line ETA date with pre receipt date recvd - When adding or updating the date field on an inventory receipt the ETA field on the corresponding purchase order line will update accordingly. When the "date received" field is update the corresponding purchase order line is updated. The notepad of the purchase order is stamped with the date change, from and to, for the affected line and cross refer to the receipt number.

Activate Purchase Order Approval System? - This setting activates 3 options (PUR 21, 22, & 23) on the Purchasing Menu that set up a PO approval system. An approval ladder can be created for individual users and specific or all suppliers. When first entering a PO, the total amount is tested against the entries in the PO escalation ladder and is sent for approval if the amount is greater than what the user is allowed to approve themselves. We recommend that prior to activating the Purchase Order Approval System you build the PO Approval Escalation Ladder using menu option PUR 21.

In PO Approval System: Print POs at printer assigned to approver - Select a printer for printing POs.

Email Notifications On Change to Status? Branch Initials Cust Cont. - allows you to enter up to six status codes that if the PO/Special PO is changed to trigger an email. This functionality applies to regular purchase orders, special purchase orders and direct orders.

  • Enter the email recipient:
    • Branch - The branch where the purchase order was created. The branch email information comes from the Hold and Back Order Fill Contact Table (menu option SYS 921).
    • Initials - The operator who created the purchase order. The operator's email information comes from the Hold and Back Order Fill Contact Table (menu option SYS 921).

    • Customer Contact - This stakeholder entry only applies to special purchase orders. Order contacts are entered on customer orders. Regular POs are not tied to a customer order like special POs are.The customer contact email comes from the Phone Number File Maintenance (menu option SYS 802). The Phone number file can be set-up by Account or Supplier. The following settings must be made for an entry to be considered a cus­tomer contact and therefore receive an email:

      • It must be an "I" nternet type.

      • The EM AK (email acknowledgment) setting has to have a "Y".

Status - When a Purchase Order Line has its status changed to one of the statuses entered an email is sent out to the selected stakeholders; Branch, Person who created the PO, and/or Customer contact for special orders.

  • PO statuses are changed via the Cancel &/or Change Open Orders programs.

Options for Purchasing Discontinued Items

This series of settings allow you to prevent purchasing of discontinued items for regular POs, special orders, and direct shipments.

Discontinued items are identified by a past date in the Discontinued Date field and/or a policy code of DI in the Policies field of the Item File Profile screen.

For each of the three types of purchase order, enter up to four policy codes and a Y if you want to prevent purchase orders for items with a discontinue date prior to today.

Options for Recalculation of Order Date

If set to "N" (the default) the system process for recalculating order dates does not change.

If set to "Y" the order dates for backordered lines on customer orders do not get updated even if the rest of the order gets a date change.

Direct ship (warehouse = DIR), Purchase orders and any order lines with allocated inventory are not included in this functionality.

Options for Removal of Unprocessed Orders from the System

Enter the number of days to offset the Order Date when determining which allocations will be removed for unprocessed orders. (Default=1 Day) -You can specify the number of days until held inventory (for unprocessed orders) is automatically released by the system. If no entry is made in this field the setting is global and applied to all of the companies on your system. The global setting is for Night Jobs to automatically release holds, putting them back into available inventory, during the second night after the hold was placed, based on the order date on the order header. This field gives you more control and flexibility in handling inventory holds.

  • Enter the number of days to hold the inventory. You can make up to three entries. If you leave a space blank, the system defaults to one business day.

  • Enter up to ten company numbers for companies that use the inventory hold setting.

  • Three settings are available, so that each company on your system can be assigned to one of three settings.

Every night, Night Jobs retrieves the setting for each inventory temporary hold on the system. This setting is added to the Order Date of the header of the temporary hold, resulting in a "last date to hold." If the current date is past this "last date to hold," the hold is released, and inventory is made available.

Note  Orders that do not allocate inventory are not removed.

Note This feature can be used in conjunction with the Max Days Variance in Control Panel.

Send notifications a day prior to a hold expiring - Activating this option directs the system to check the Hold and Back Order Fill Contact Table for an email address related to the order by salesperson, operator, branch, or account contact. An email is then sent letting those concerned know that a held order is getting ready to be released and any held inventory is going to be allocated to other orders.

Allocate unallocated order lines from available stock after holds are expired? - Activating this option directs the system to use inventory released from expired orders to fill back orders.

Allocation sequence - Choose to fill back orders or held orders first.

Date to allocate by - The Order Entry Date is the effective date for allocating inventory. Truck routing programs use the Date Required (Ship Date) when planning delivery schedules.

F9 - Hold Expiration Table

This table, accessed by pressing F9, enables fine tuning of the expiration rules at a cost center and/or manufacturer level. If a match is found that pertains to a particular hold, the settings in this table override the existing expiration parameters set in the Enter the number of days to offset the Order Datewhen determining whichallocations will be removed for unprocessed orders fields.

Co# and Cost Center are mandatory. Manufacturer is optional. A blank manufacturer is interpreted as "all other manufacturers within the cost center"

The table is read as follows:

  • first see if a table entry exists for Co# + Cost Center + Mfgr

  • if not, check Co# + Cost Center + blank Mfgr

  • if not, use defaults set in the Enter the number of days to offset the Order Date when determining which allocations will be removed for unprocessed orders fields which are by company number.

Options for Reorder Reports

This option contains settings allow you to do the following:

  • Eliminate sales that are either below a certain margin (GP%) or sales that were marked with certain specified status codes.

  • Activate the Supplier Reorder Parameters File

  • Omit Special Order Lots (Lot#s S000-S999) from Reorder Reports

Omit Sales from Reorder Reports if GP% on invoice is less than and Omit Sales from Reorder Reports if GP% on invoice is less than and if Serial# has Status Codes - The elimination of these sales can reduce the usage and activity figures on the Reorder Reports, and therefore affect the "suggested reorder quantities" and the quantities on automatically generated replenishment purchase orders.

The business goal is NOT TO encourage or increase a reorder amount based on the sale of remnants, odd lots, and close-out (blow-out) material. This enhancement is meant to eliminate the potential problem of a flurry of low-margin "blow-out" sales triggering the same type of increased reorder qty as normal "full-margin" sales. Use this setting to eliminate sales that are either below a specified margin (GP%), or sales that were marked with certain specified status codes. The elimination of these sales reduces the usage and activity figures on the Reorder Reports, and therefore effect the "suggested reorder quantities" and the quantities on automatically generated replenishment purchase orders.

The first two settings remove sales that fall within their scope from any usage calculations on the Open Order Reports. Using these settings in combination allow for two different GP% to be checked:

  • a GP% that ALWAYS indicates a blow out,
  • and another GP% that is considered a "blow out" only when coupled with a particular serial number status code.

Activate the Supplier Reorder Parameters File - This file contains a table that can simplify the process of setting up reorder parameters, and eliminate the need for any parameters in the Product Line and Product Line by Warehouse file.

Use "Activity without Special Orders" during Reorder Reports and Activity - If this option is selected, the reorder reports omits any special order lot numbers and also excludes them from any calculations.

It is necessary to allow the system to accumulate data from the final production distribution before activating this feature. The expected date of reliable usage as early Q2 2020.

Use Activity Calculation in PUR 20 and Reorder Reports from End of Month Activity - If you include shades and lot numbers as part of your item numbers, activating this setting can help eliminate inconsistent results in your Suggested Reorder Quantity Calculations (menu option PUR 20). When this setting is activated, the system calculates activity using the item number minus the lot and shade information.

If not activated, the default, item numbers that include shade and lot information will not be included in assessing reorder requirements. The shade and lot number, if included as part of the item number, are the last four characters of the item number.

Include Inventory Adjustments to Component Items for Finished Goods in Usage Calculation - enables the user to include Light Manufacturing component items in usage calculations for reorder reports versions 7 and 8.

Options for Retail Price Tag/Label

This setting allows you to establish the price list to use on the Retail Price Labels. These labels show your price and can be attached to items such as area rugs, rolled good remnants, and odd lots of tile, and stone.

The system uses the list price entered as a default when establishing prices to print on the retail labels. If no price list is entered, the system automatically inserts "LP", list price, into the field.

Options for Rolled Goods

Use this setting to automatically assign roll pricing to an order line when the quantity ordered is greater than or equal to the average roll size within item packaging. This prevents you from having to manually change from cut to roll pricing during order entry or order change if the quantity ordered is greater than the average roll.

If order lines are back ordered, this setting will not impact back order fill logic.

If a pricing restriction is specified (e.g. via the "R" field on the order detail screen on the iSeries or in the Restriction Code field in Navigator's Order Management), that pricing restriction is enforced.

The settings Consolidate roll Lines w/same item, warehouse, & price on order acks and Consolidate roll Lines w/same item, warehouse, & price on invoices allows you to eliminate redundant lines on documents when a company would rather show only the total yardage sold rather than list each individual roll.

This functionality affects all Order Acknowledgments and/or Invoices EXCEPT for:

  • Order Acks Installation Documents (such as Installation Worksheet), because those documents must show roll details.

  • Any invoices customized for specific customers.

Activate these options with a "Y" to consolidate roll lines in all versions of the Order Acknowledgment and Invoice.

Notes:

  • Only consecutive lines with the same item#, same price, same UOM, and same ship date are consolidated

  • Comments (F6 lines) and sidemarks in the middle of lines breaks up the group. Sidemarks at the end or above all lines is fine.

  • Remember, that with rolled goods, you could wind up with some priced at cut price and others at roll. Must be same price to consolidate.

  • The consolidation also works on green screen Order Inquiry when displaying the inquiry uisng View #9.

Associated Files

  • Item File - Use the Packaging Class field to assign a packaging class to an item. Packaging can be entered specifically for an item by leaving this field blank and pressing F10. However, we highly recommend that you use Packaging Classes to save time and effort when multiple items share the same packaging information.
  • Packaging File - The Packaging File establishes packaging and conversion factors called packaging classes that can be assigned to groups of items. Items with identical packaging conversions can be assigned to the same packaging class, and when the packaging conversions change, only the Packaging File needs to be updated.

Options for Rollover Files

If your business generates more than 400,000 invoices or orders a year, you should consider activating this new and easy method of archiving. This process can essentially automate the archiving of your old orders and invoices.

This setting provides two options:

  • Activate Order Rollover File

  • Activate Invoice Rollover File

Activating either setting, for Orders and/or Invoices, directs the system to start real time archiving. What this means is that when a duplicate order number/invoice number is generated the older number, if it is closed, is moved from the "active" files to an Order Rollover File. These archived files are still available for searches and reports.

It is HIGHLY recommended that if you activate either of these settings you do not go back and deactivate them. If you activate and then deactivate the rollover system, the orders and/or invoices that were sent to the rollover files cannot be accessed when the rollover system is deactivated.

Decide if you want to create Audit files (OROAUDIT for orders and IROAUDIT for Invoices. These audit files were created to track each transaction that is moved to the rollover files.

The options are:

  • N - No audit report is produced (recommended).

  • Summary - Only shows Invoices/Orders that were replaced in the "active" files and archived to the Rollover File.

  • Detailed - Shows the orders/invoices that were archived in the Rollover File, as well as orders/invoices not moved to the Rollover File (i.e. orders/invoices that are not closed).

Options for Sales Portal Price Request

This setting contains options that allow you to control special pricing and price requests.

Minimum GP% for override price request - Enter the minimum amount, based on GP%, for a pricing override to be accepted.

Maximum number of days for the expiration date for promo - Enter the maximum number of days from the current date that the expiration date of the promo created may be in effect.

Price request promo program# edit mask - This option allows you to add a mask to the program numbers created by this process. The remaining characters after the edit mask will be populated by a revolving number wheel.

  • This allows you to identify and analyze special pricing requests that originate from the Sales Portal.

  • The program number will increment if a duplicate program number is found for the same account and item or price class criteria when the promo is created.

Price request default promo sub-type - Promo sub types allow you to further categorize the price request.  The values for this field are maintained in the System Tables Maintenance (SET 029) in the table PROMOSUBTP.

For example, use this code to categorize promotions that include rebates from manufacturers:

  • "C" for competitive pricing

  • "S" for Special Temporary Pricing with Rebates

  • Enter a "T" to identify the special pricing as being specific to the payment terms established in the Billto File for the customer.

Price request default promo class - Use this setting to include or omit promotions when printing price lists. For example, you can have promo classes that determine whether or not a promo should be included on a price list.

The available options are:

  • Blank / no class code - This setting ensures the promotion is inlcuded on price lists.

  • Class 1 = Omit From Printed Price Lists

The values for this field are maintained in the System Tables Maintenance (SET 029)in the table PROMOCLASS.

Options for Sales Tax

Print Customer Tax Identification#s for State or Province on Invoice - This setting causes the Customer's Tax Exemption number to print on the invoice if no tax was charged. The Tax Exemption number printed relates to the date of the invoice. Proper use of this feature ensures that during a tax audit all invoices will either show the tax that was charged or show the Tax Exemption number.

  • Option SYS 605 - Tax Exemptions By State/Province File Maintenance allows for customers to have multiple tax exemption numbers per state or province based on beginning and ending dates.

Print Customer Tax Identification#s for State or Province on Order acknowledgments - This setting causes the current (active) Customer's Tax Exemption number to print on an acknowledgement if no tax was charged. Today's date is used to lookup the correct tax exemption number.

Print description of assigned tax code on Invoices & Acks, even if tax amount = 0.00 - This setting causes the tax description (such as "Export No Tax") to print in cases when a tax code is assigned, but the tax rate is 0.00%.

Display tax codes and Tax Exemption# on the Order Entry Shipto Screen - This option causes the state and other tax codes to appear on the Shipto screen (below the Final Destination fields). Also, if an active Tax Exemption number was found for that state or province, then it displays as follows: XX Number (where XX is the state or province and Number is the Tax Exemption number).

Always make order non-taxable if Billto File has no tax codes - The Billto File (FIL 1) contains fields to enter two tax codes (State and Other, which could be used for local taxes). If both of these fields are empty, the order is automatically considered non-taxable. If this setting is activated and the Billto tax codes are blank, the order will remain non-taxable, regardless of the shipto, shipvia, and warehouse settings. However, the user can use F9 or manually override the tax fields in Order Entry. This ensures the Billto Record is the determining factor in whether order is tax vs non tax.

  • Setting is Activated - Stay non-taxed regardless of changes to shipto, shipvia (changes from "WC" to a "non-WC" as defined per Classification Codes - FIL 19), and warehouse settings.

  • Setting is Deactivated - Order will remain non-taxed until changes are made to shipto, shipvia (changes from “WC” to a “non-WC” as defined per Classification Codes - FIL 19), and warehouse settings.

Always respect user's F9 to override tax (regardless of other settings)- The F9 function key on the Order Header Screen lets you toggle between making an order taxable or non-taxable. Enter a Y in this setting to always respect the tax F9 override. If this flag is activated, then once an F9 is pressed the user is in control. The tax codes remain as is, after an F9, only subject to the user manually overriding them. After the F9, changes in Ship Via, Warehouse, Shipto, etc, will NOT affect the tax.

Use Case

The use case outlined below is supported when the existing settings above and the new Always make order non-taxable if Billto file has no tax codes is set to Y.

  1. Order is entered for a billto with no tax codes.
  2. Zip code entry is found but no updates are made to order header based on absence of codes in bill to file.
  3. Tax exempt table (SYS 605) is checked but not necessary based on no tax codes in billto file.
  4. Order is made taxable by pressing F9 toggle

This taxation rule override is honored in subsequent order changes even when auto recalculation logic is set to 'Y'

  1. Order is entered for a billto with tax codes.
  2. Zip code entry is found and codes are updated on order header based on presence of tax codes in bill-to file.
  3. Tax exempt table is checked and no exemptions are found.
  4. Order is made non-taxable by pressing F9 toggle.

Options for Salesperson Commission

This System Wide Setting contains options for:

  • assigning a salesperson to orders based on the settings for a "parent" or "child" item.

  • writing off sales commissions on unpaid invoices.

Assign salesperson based on parent or child item for a crossover item- allows you to use the parent or child item to calculate and show salesperson commissions on Commissions Reports. This option only applies to companies that do NOT assign a salesperson on the Order Header via the Billto File (FIL 1).

  • Crossover items are one or more item numbers that share the same inventory item in the XREF field of the item master. The two items have the same inventory but can have different item numbers and different descriptions. You can use crossover items to market the same product under multiple numbers and names. For example, two different customers can have exclusive sales rights to the same item. Both customers can place orders under their own assigned item numbers and descriptions, and receive all documents (pick lists, invoices, bar code labels) with their assigned item numbers and descriptions, even though the actual inventory is the same.
  • The item containing the inventory is known as the parent item. The child/dependant items have a value in the XREF field of the item master.
  • The following are some examples of how this setting can be used:
    • A product is marketed under two brands or programs, each with its own salespeople. In this case, assigning commissions by child item allows commissions to be paid to separate salespeople based on the number used on each invoice.
    • A product is sold under multiple brands/item numbers, but regardless of the brand you want the same salesperson to be credited. In this case, use the option to assign commission based on the parent item.

Disregard AR write-off (WZ) transactions if Invoice Date is before - This option allows you to enter a date written-off where invoices are not affected. This is important if you are changing your commission scheme and you want a clear cut-off date. Code WZ is the system assigned Accounts Receivable code for writing off an invoice.

Suppress write-off reports when no WZ transactions are found within criteria selection - Use this option to activate the negative commission functionality. Negative commissions calculations are based on the extended price of the invoice line items and not the invoice total. This ensures that any extra fees or charges such as taxes, delivery charges or fuel surcharges are not factored in.

Activate salesperson matrix file - The Salesperson Matrix can be used to report on the commissions earned by each salesperson associated with a sale.

Options for Serial# File Receipt Dates

This setting controls the updating of receipt dates onto inventory serial number records. These dates appear on the inventory serial number screens, and are used by ISO for inventory selection. There are two settings (Points if old (older than DAYS OLD in Item File) and Points per month old) on the first ISO screen that use receipt dates to assign points to inventory based on age.

The serial number receipt date is updated according to the rules described above in several different transactions within the system:

  • Receipts using pre-receipts (INB 5)

  • Receipts using immediate posting (INV 5)

  • Transfers received via Stock-to-Stock process (INB 8)

  • Transfers received via immediate posting (INV 9)

  • Transfers received as a result of status code updates in warehouse (WAR 5, IWMS)

Never update the receipt date for a new receipt, if item is received to an already existing serial# & location - This setting does not update the receipt date of inventory when the inventory is placed in a location with inventory of the same serial number. In effect, it does not reset the age of the inventory (both existing and new) that ISO uses to assess points.

Always update the receipt date for a new receipt, if item is received to an already existing serial# & location - This setting uses the last in first out (LIFO) model. If this setting is selected, existing and new inventory of the same serial number and location are updated to the date of the latest receipt.

Only update the receipt date for a new receipt if onhand is zero, when item is received to an already existing serial# & location - This setting is similar to the one above, except the receiving date for new receipts is only updated when there isn't any existing inventory with the same serial number in the location.

Options for Ship Date Update Logging

When this functionality is activated via the setting Enable Ship Date Update Logging, changes to an order’s ship date are logged into Navigator File Management.

With this setting activated, when a ship date is changed, at either the header or detail level, a log record is entered into the Date Request Change Log option in Navigator File Management.

For more information on the Date Request Change Log, click here.

Options for Ship Via Fields

This system wide setting contains the following settings:

  • Make Ship Via field mandatory in Order Entry - Makes the Ship Via field mandatory during order entry. The default is for this field to be activated.

  • Validate Ship Via field in Order Entry - If activated, this setting directs the system to validate the Ship via code against the Classification Codes File.

If either setting is activated and a problem occurs, i.e., no ship via code is entered or an invalid ship via code is entered, the following message displays: ERROR / Invalid Ship Via Code

Options for Shipping Charges Within Order Entry

This setting activates a pop up window within Order Entry and Order Change that displays shipping rates based on a variety of parameters. You can use the information to inform a customer of shipping costs or changes in shipping costs. When a rate is selected, the charge appears as a line on the order.

Enter a Y to activate the table. This ensures that during order entry the person entering the order has access to rate and freight information.

The following rounding options are available:

  • no rounding (default) - System will use the exact rates contained in the Shipping Charges pop up window.

  • round up to nearest dollar - Rounds prices up to the next dollar.

  • round up to nearest five dollars - Rounds prices up to the nearest five dollars. For example, a shipping rate of 13.46 would round up to 15 dollars.

These options control the application of surcharges which can allow you to recover costs such as rising fuel prices.

Add surcharge of __to all shipping charges - Enter the percentage of the shipping charges that you want to add as a surcharge.

I/O __ Ship Via Codes___or surcharge (blank = include all) - Enter the Ship Via codes that you want to include or exclude for the surcharge.

The system follows this flow to check for a surcharge and if needed to add it to the shipping charges:

  • If a surcharge percentage exists in the system-wide setting, then....

  • It sees if the ship via code is included.

  • If there is a percentage and a valid ship via, the surcharge gets added to the end of the shipping rate calculation.

  • For example, if the shipping charge was $100.00, and the surcharge % = 005.7500, then the surcharge is calculated as .057500 x 100.00 = $5.75, and is added to the shipping charge. The shipping charge will show as $105.75.

Options for Slabs

  • Support Allocation of Partial Slab within OM - This option activates the ability to allocate a partial slab within Navigator OM.

  • Inventory Split Variance Adjustment Code - This code helps you to track any size variances that might occur when slabs are split. This can help you track and keep your inventory value in balance.

  • Inventory Split Variance Threshold - This setting works in conjunction with the Inventory split adjustment code. Enter the minimum SF that can be ordered. Enter the max variance quantity allowed. Inventory splits beyond this quantity will be prevented.

  • Quantity under this is considered PC in Navigator OM..(dft = 15) - This is the smallest quantity that can be ordered in Navigator Order Management. If someone tries to order less than what is entered here they will receive an error message. If this setting is left blank, the default of 15 SF is used.

  • Allow Inventory Analysis on Slab items in Navigator OM - Inventory Analysis, as a part of Navigator Order Entry, allows you to select items (both serial numbered and rolled items) manually. This setting allows multiple slabs to be manually selected in Inventory Analysis.

Options for Special Charges

These settings activate the Special Charges feature for Invoices and COD orders.

The Special Charges functionality is similar to Minimum Order Charges except you can assign multiple charges to a single order and these charges are assessed on every invoice. For example, if a delivery of 5 rolls of carpet results in 3 invoices, each of the invoices can show a carpet freight related to the SY (or other specified special charge parameter). The special charge on the invoice is clearly labeled (i.e. Carpet Freight).

Special order charges can be quoted from within Order Entry and Order Change. This allows real time quotes to customers concerning estimated costs. Furthermore, these special charges work in conjunction with any applicable delivery or minimum charge fees. They do not replace any other applicable fees.

  • Activate Special Charges Table for Invoices - directs the invoicing programs to use the special charges files

  • Activate Special Charges Table for COD Orders? - directs COD Orders to include the special charges, similar to how the option works for delivery charges on COD orders. Use this option in a retail environment, so that order acknowledgments can include these charges.

Options for Special Orders

This setting enables you to automatically update customer special order status and dates, when the related special purchase order has it's status and/or ETA date updated.

Both options link a customer back order to its related special order purchase order. Special orders are created within order entry by keying "S" in the Lot# field, or they can be created automatically for items that are coded as "Special Order Only".

  • Update Special Order Line to status = __ when processed - automatically assigns a pre-determined status code to a processed special order. This can eliminate Customer Special Order lines from being changed after the purchase order has been created and placed with the supplier.

  • Update Order Status of Linked Back Order when P.O. Status is Changed? - Entering Y here ensures that when the status of your purchase order changes (i.e., the item is marked as confirmed or delayed) the customer's back order is also updated. For example, lines on a special order purchase order are updated from status "O" to status "K". The related lines on the related customer back order are also updated to status "K" automatically.
  • Update Ship Date of Linked Back Order when P.O. ETA Date is Changed? - This option enables you to sync any date changes on your purchase order to your customer's back order. For example, if the manufacturer informs you that the backordered item can be delivered earlier than expected the date changes you make to your purchase order are also reflected on your customer's back order. The customer back order is only updated until it is filled. Changes to the purchase order dates or status do not affect back orders once they are filled.

  • Block Creation of Special Order Purchase Orders for Held Orders - Activating this option directs the system to not create special order POs for customers orders that are in a held status. Customer orders that are in a held status have a "H" as the order type. When the order status is changed to a status other than "H", a special order PO may be created during Print Special Order Purchases (PUR 4) processes.

Note: This setting does not apply to orders that are on Credit Hold.

  • Limit Creation of Special Order POs to those added/changed today - If you activate this option (which in this case, activate means the setting is set to N), be aware that there is no date limitation on how far the system goes back to create special purchase orders. If, for whatever reason, special purchase orders were not printed, via one of the menu options or through night jobs, this setting will generate Special POs for any open special customer orders; regardless of the date. Then, depending on your system configuration, orders might be automatically placed with your suppliers. We recommend that the first time this setting is activated you run PUR 4 - Print Special Order Purchases. Then review the spoolfile to check on the special POs that were created. If the Special PO is not current, you can go into menu option PUR 11 Cancel &/or Change Open Orders &/or POs to cancel or void them.

  • Set Special Order PO Warehouse to Customer Order Header Warehouse or to Customer Order Detail Line Warehouse - The default is for special order purchase orders to print at the Order Header Warehouse. This setting allows you to direct the system to print at the Purchase Order Detail Warehouse. This setting was originally created to work with the Warehouse Stocking Matrix, but it can work without using the stocking matrix as well.
  • Enable Auto-creation of Special Order POs during order processing - If this setting is activated, Special Order POs are automatically created just like POs for regular orders. Prior to the introduction of this functionality in July 2017, special orders were generated by manually running menu option PUR 4 - Print Special Order Purchases. This functionality only applies to orders processed in Navigator.

  • Auto-distribute special orders via ODS to supplier - Activates the Automatic Distribution of Special Order POs via ODS.

  • Suppress distribution of PO when items have policy code - Use this setting to enter up to three item policy codes that disable automatic distribution. When enabled, if a special order PO is created for an item with one of these policy codes, the email distribution to the supplier is suppressed.

  • Update Special Order Line to status = > when PO is distributed - After special orders are distributed, they are automatically assigned the status entered here. This can help group, track and report on special orders.

    For more information on the Automatic Generation and Distribution of Special Order POs, click here.

Options for Special Terms Payment Plans

These settings activate the special payment plan for Floor Plan options and allow them to be used during Order Entry instead of regular payment terms.

Floor Plan allows for special financing arrangements that enable you to offer products to your customers at preferred terms, thereby increasing your presence with the customer. Floor Plan is normally associated with sales by manufacturers and distributors to retail stores. The basic theory behind the offering of a Floor Plan to a customer is that if the customer has more of your inventory on the floor, then he or she is more likely to sell more of your inventory.

To use a Floor Plan payment option instead of a regular payment plan, enter a Y in the field Activate the use of the Floor Plan Terms File for Payment Plans.

Auto-populate the regular payment terms code field with * , when an FP Terms is entered - ensures that when you enter a Floor Plan Payment option, that uses multiple payments, the regular payment terms field is flagged to whatever you designate here.

  • For example, if a an order is entered in Order Entry and a multiple payment Floor Plan option is used, then the regular payment terms code field (CD) auto-populates with a *.

Before Activating this Feature

Before using this feature, ensure the Retail Environment is turned off at the work stations that are able to assign floor plan terms. This is done via the control panel.

  1. Type CONTROL on a command line and press Enter.
  2. On the screen that appears, enter a password and select a control panel.
  3. Press F11 to proceed to the second page of settings. Set the Retail Environment field to N.

The use of special payment plans does not apply to the retail environment, because retail work stations are locked out of changing the terms fields, which we usually set to "Cash". However, these features may still be used by retailers, by accessing the order from a manager's work station that is not locked into the retail environment.

Options for Standard Orders

This setting activates the Multi-Unit functionality on a system wide basis.

Multi-unit functionality facilitates the needs of our customers who service large commercial business on multi-unit commercial and residential properties.

The option Check for and issue Duplicate Order Warnings in Navigator Multi Unit Order Entry for open orders and invoices __ from today's date allows you to enter the number of days you want the system to check for potential duplicate orders.

Options for Stock to Stock Transfer

This setting contains options that provide control over your stock-to-stock transfers, which are always entered using account number 2 (X00002).

Show additional interwarehouse freight in separate column on inventory registers - This setting affects the Receipts Update option (INB 5). If the setting is activated, it separates the freight, which then appears on the Transfer Report (RIV 7) in a separate column.

  • If set to "N", the Add'l Freight column is zero, and the additional freight is added into the total value column.
  • Additional freight is always broken out separately for customer transfers.

Allow override of material cost on Stock to Stock Transfer - Activating this option allows users to change the "Base" cost when receiving on menu option INB 1.

Allow override of freight cost on Stock to Stock Transfer - Activating this option allows users to change the "Freight" cost when receiving on menu option INB 1.

Associated Files

  • Item File - The Frt Key should be set to W, C, or U (weight, cubes, or units).
  • Inter Warehouse Freight Cost File (SET 8) - The Inter warehouse Freight Cost Table allows you to determine how much it costs to move items between warehouses (such costs will be added into the cost of the item and determine GP). Costs are listed by item class but are determined by weight, cube or unit. This table must have an entry that includes the sending and receiving warehouses and the associated costs.
  • Enter Receipts (pre-receive/no posting) - The Base Cost and Freight fields are affected.
  • User ID Control Panel (SET 2) - In order for a user to update costs, the field Allow User To Adjust Cost has to be activated.

Options for Taxes On Will Call Orders

This setting activates the Will Call Tax Table. This table allows tax codes to be dynamically changed based upon the Header Warehouse. For example, if a customer normally assigned to warehouse NYC will pick up at warehouse PHI, then this table can automatically change the tax rates from a will call tax rate PHI to a will call tax rate for out of county or out of state customers from NYC.

Place an Y in the Activate the Warehouse Will Call Tax Table field to activate the table. If activated, Order Entry uses the information contained in the Will Call Tax Table to assess taxes based on the business address of the customer as well as the address of the warehouse.

If this feature is not activated, Order Entry uses the tax codes as defined in the warehouse file for will call (customer pick-up) orders.

Options for Taxing Based Upon Shipto Address

This setting lets you activate the Tax by Zip Code Table. The Tax by Zip Code table allows you to establish taxes for a single zip code or a range of zip codes. If activated, the Tax by Zip Code table takes effect when the normal account shipto address is overridden.

For example, if a shipment is made to an address that is overridden while entering an order (such as a job site), there will not be any pre-assigned tax codes for the new address. This setting and table allows for automatic tax code assignment based upon the shipto zip code.

This setting works in conjunction with the Order Entry Shipto screen and the Final Destination State and Zip Code fields.

  • Activate the Tax by Zip Code Table? - Enter a Y to activate the Tax by Zip Code table.

Note   All the settings except Make order tax exempt if a current exemption is found in the Tax Exemptions By State/Province File are dependent on the first setting, Activate the Tax by Zip Code Table, being activated.

  • Make Zip Code Mandatory on Shipto Overrides? - Ensures the zip code must be entered on the Order Entry Shipto screen when you are overriding the shipto address. This option can work in conjunction with the next option to automatically populate the city and state when a zip code is entered.

  • Auto-fill State & City from Tax By Zip Table if Zip Code Found? - Activating this feature directs the system to automatically insert the state and city in the appropriate fields on the shipto screen. The city and state inserted are the ones associated with the zip code in the Tax by Zip Code Table. This only applies to Shipto Overrides.

  • Make order tax exempt if a current exemption is found in the Tax Exemptions By State/Province File - Entering a Y in this field ensures any tax exemptions created for a State/Province File are still used.

The last two options are intended for companies that use the Tax By Zip Code Table (FIL 43), and store tax exemption numbers in the Tax Exceptions File (SYS 605).

  • Always recalculate tax based upon zip when a shipto address is changed - If activated, this option ensures changes on the shipto screen (in Order Entry or Order Change) force a recalculation of the sales tax based on the new shipping information regardless of any prior settings.

  • Always recalculate tax based upon zip, even if no ship override, or shipto is unchanged - This option causes the tax to be calculated prior to displaying the shipto screen, even when no shipto change or shipto override is entered on the order header. This catches situations where the tax codes in the Billto File may not be as accurate as those related to the zip code of the Billto or the default shipto address.

Options for Transportation Planning

This setting works in conjunction with the option Transportation Planning (TRA 1).

These settings dictate a cutoff time and day before an email message is sent out alerting those concerned that updates have been made to a shipping manifest.

If the settings were set as:

  • Notify Cutoff Time?....... 12:30
  • Notify Cutoff # of Days?.. 01

When a change was made to a manifest anytime after 12:30, one day prior to the shipping date an email would automatically be sent to the recipients set up in option TRA 15.

A third setting, Show Telephone number, appointment date & time on BOL?, allows you to print a telephone number, appointment time, and warehouse information on a BOL.

BOLs are generated using menu option - Warehouse Shipping Reports.

The ability to print telephone number, appointment date and time only effects BOL formats 2 and 4. Format 2 is the default BOL that most companies use. It prints on a Non-Laser form that is usually a multi-part form. Format 4 is the BEAR format. It is the similar to format 2, but the SCAC code and the Bill of Lading number are barcoded.

Options for Valid AR/AP EOM Date Ranges

This option prevents the entry of an incorrect End-Of-Month date when closing out a month in either the AP or AR systems.

The defaults are automatically inserted into the fields. Using the default entries, an operator could not process AR EOM if the date entered was 10 days before or after today's date. Furthermore, if AP EOM is being run the date cannot be more than 10 days before today's date or 20 days after.

If an incorrect date is entered during EOM, that does not fit within the range of valid dates, an error message appears.

If the these System Wide Settings are left blank, the system will not perform the date check. It is highly recommended that you activate these settings.

Options for Vessel/Container System

Using this system wide setting you can change the default titles on the Vessel/Container Search and Inquiry Screen, and on related reports. The Vessel/Container Search and Inquiry Screen provides a quick and simple search through the vessel and container information on your system.

You can change the headings of two of the columns to more closely match your business terminology.

Changes made to the titles are reflected on all the programs that use either the L/C or the BOL fields for Vessel/Container management. The areas affected are as follows:

  • Vessel/Container Search and Inquiry
  • Detail line view of Order Inquiry for POs. (and archived version)
  • Update Order Status & Shipping Data program - F2 screen
  • Purchasing Spreadsheet (detailed version shows the L/C & BOL fields)
  • Open Orders By Vessel Report

The L/C# field is 14 characters long, and the B.L./Ctnr# field is 10 characters long. Many companies prefer using a full container number as their main tracking number, and many companies do not use L/Cs (letters of credit). Therefore, relabeling the L/C# as CONTAINER# (as shown above) may be of benefit to you.

The figure below shows the Vessel/Container Search and Inquiry Screen with the new titles.

Options to Enable Item Keyword Search

This system setting activates a keyword search. This functionality allows you to search on a single keyword or a combination of keywords. The search utilities a wide variety of item data throughout the system, including item description, manufacturer name, color, and pattern.

Entering a Y in the Enable Item Keyword Search field activates the keyword search option. Furthermore, it enables night jobs to rebuild the search file every night.

  • Rebuilding the item search file should be done during night jobs. The amount of time needed to rebuild the file varies depending on the amount of items in your system, but it can take several minutes. By rebuilding the item search file every night, you are assured that any new items are included as well as any updates.
  • Enable Enhanced "I" option - This setting activates a search functionality designed for serial numbered items. This includes items with uniquely sized serial numbers as well as items where the serial numbers are in inventory at the standard width as defined in the item master.

The actual search is performed via menu option Enhanced inventory search (INV 12).

  • Include Discontinued Items in Item Searches by Default - Enter a Y if you want to include discontinued items in the search. When a keyword search is performed, and discontinued items are included, those items are shown in reverse image. Discontinued Items are defined as items that have a date entered in the Date Discontinued field of the Item File (FIL 2).

    Notes on Discontinued Items

    • The Item Policy DI policy is NOT an indicator that the item IS discontinued, but more of an indicator that it is flag to become discontinued. Primarily for reporting purposes.
    • The true definition of a discontinued item is that the entered discontinued date has been reached or surpassed.
    • If a discontinued item has available inventory item searches will still list these items as "discontinued". With the exception, if they choose to have "discontinued items with inventory" included in the normal search. This can be set on in the SET 4 option, "Options to Enable Item Keyword Search".
  • Display total available inventory on main search? - This setting gives you three options concerning showing total available inventory. Enter an N to not display the total inventory, entering a Y shows the total available inventory from all warehouses regardless of business entity, stocking matrix, or company number, and a W only shows inventory from the users default warehouse as established on the Control Panel. Examples searches are shown below.

  • Activate multiple item selection from Order Entry & Order Change - This option, if activated, gives you the ability to insert multiple inventory selections into multi-line order entry by selecting the items from the keyword search results.

    • If you enter N, then the keyword search remains in the existing "single selection mode", where you can only enter "X" next to a single item, and that single item is returned into the order entry (or order change) program.
    • Enter a Y to activate "multiple selection mode", where you can enter "X" next to as many as 30 items on the search screen, and all of the selected items are returned into the order entry (or order change) program. The items appear on the Multi-Line Order Entry Screen (which is the same screen that is used for Bills Of Material, Related Items, and Kits). Quantities can then be assigned to the items as needed.

Search Results Display Option - Enter "1" to direct the keyword search results to show the "traditional" search; which shows only one description line for the item. Enter a "2" for an expanded search which includes additional information about the items.

  • Option 1 includes an F11 Fold/Unfold function key that includes the information shown if option 2 is selected. Option 2 simply shows it on the screen without having to use the F11 function key.

Options to suppress automatic recalculation of ship date

The system will automatically calculate the next available delivery date in accordance with customer delivery schedules.

If you do not want the system to automatically calculate a back order shipping date, you can use this system-wide setting Option to suppress automatic recalculation of ship dates.

  • Enter Y in either option to DISABLE the Automatic Recalculation of ship date during respective process (either manual or automatic back order fill).

  • The default value is N (or the field is Blank). This enables the system to automatically recalculate the dates.

Options to Suppress Printing of Invoices

Certain types of invoices, such as zero value invoices and invoices for EDI customers may not require printed versions, even though they need to be processed by the invoicing system. Eliminating certain invoices from printing saves you money by reducing postage, paper usage, and the costs associated with handling these invoices. This feature eliminates the need to print invoices and leave them on hold in a spool file, and then reprint them in accordance with the Customer Preference file.

The default for this screen is to leave all the values blank. For Y/N options the default is N.

If an invoice meets the print suppression criteria it will not print. An exception to this occurs in order entry. When entering in a 100% discount and an "L" is entered in the Where Extra Charge Shows field the invoice will not print if suppressing invoices when the Value of Zero field is set to Y. However, if an S is entered into the field the invoice will print.

Printing invoice copies from within Invoice Inquiry bypasses the options for suppressing invoices from printing.

The System Wide Settings for Invoice Suppression options have an "and/or" relationship. For example, the option Terms Code has six suppression codes. If an invoice has one of these codes, it will be suppressed from printing. If multiple options have invoice suppression entries, they operate under an "or" type relationship.

This system wide directs which invoices are printed using menu options IVC 4 (Printing Invoices) and IVC 12 (Printing Copies). The Invoice has: settings on the top part of the screen were designed for use with IVC 4. The setting Suppress Printing and ODS Distribution of Invoices if Total Amount of Invoice is between__ and __ is designed for use with IVC 12.

The settings are set-up like this because IVC 12 was introduced later than IVC 4 and is more sophisticated. The best practice is to run IVC 4 with option 3 to get invoice numbers assigned. Then go to IVC 12 with your invoice number range and print them.

Invoice has Terms Days - Enter the terms days value that should suppress an invoice from printing. For example, terms days 3 represents COD invoices.

Invoice has Terms Code - Enter the terms code(s) that should suppress an invoice from being printed.

Invoice has Split Code - Split codes are user-defined codes that enable you to organize invoices. These codes are one of the primary sort fields when a batch of invoices is created. When invoices are processed a split code can be entered to force it to the end, and then file or discard that invoice. It is often used for invoices that are created and stored, such as COD invoices or for EDI accounts. A split code can be assigned to an account in the Customer Preferences file or while invoicing.

Invoice has Company# - Suppresses the printing of any invoices particular to the specified company.

Invoice has Branch - Suppresses the printing of invoices particular to a specified company branch location. Up to five branches can be entered.

Invoice has Customer Type - Suppresses the printing of invoices particular to a customer type code, as specified in the Billto file.

Detail Line and Total Line Value of Zero - Enter "Y" to stop invoices with zero value from printing.

Suppress Printing and ODS Distribution of Invoices if - Allows you to disable the physical printing and/or the distribution of invoices via the Output Distribution System (ODS) if the invoice falls within the specified range.

Consider the following examples for the use of the Suppress ODS Distribution of Invoices if setting.

Example 1

The settings on this screen direct ODS to not send credit invoices, but send zero dollar invoices.

Example 2

These settings suppress the distribution of credit invoices and zero dollar invoices.

Example 3

These settings direct ODS to distribute credit invoices, but not zero dollar invoices.

Example 4

Use these settings to direct ODS to allow credits, but to suppress distribution of invoices that are less than $1.

Order Reason Code Settings for Order Entry and Order Change

Order Reason Codes give you the ability to further classify your orders. This setting gives you the option to make Order Reason Codes mandatory during order entry and order change. Making the Order Reason Codes mandatory can provide more details in order reporting.

Y in the Order Reason Code Required setting to make the entry of an Order Reason Code Mandatory during Order Entry and Order Change. If this setting is activated, the default reason code is pulled in from the Reason CD field in the Billto File; if one is assigned.

Use the setting, Companies that will NOT follow the above settings, to designate the companies where the use of Order Reason Codes is NOT mandatory.

Order Status Codes Changes in Order Entry

This setting enables you to list the order status codes that are valid within the Order Entry program. This option is ideal for indicating statuses such as "ready to pick" or "already taken at counter", right from the Order Entry program.

Enter the status codes that you want to be allowed within Order Entry. Codes Z and L are good examples of codes you might to enter. Code L is defined as "released for picking". Code Z is user-defined to mean "taken by customer at counter". Setting these codes within order entry can be used in conjunction with your settings for printing cash and carry labels, and for printing pick lists. Also refer to information about using the order status update feature within Order Entry.

The default setting is not to allow status codes to be entered within the Order Entry program.

It is recommended that you only allow a limited set of status codes to be updated within Order Entry, such as the L and Z codes described above. Do not allow the use of status codes in Order Entry that indicate processes that could not possibly have occurred at the time of Order Entry.

Packing List Consolidation Level & Print Options

Defines the level of detail appearing on the packing lists. If this option is left blank, packing lists show only lines with status codes S as being shipped, and show all other lines as "back ordered". If you are currently using packing lists, and want lines to show as shipped even if not as status S, enter status codes on this screen. If the new status codes parameter is filled in, packing lists can show lines other than those shipped and indicate whether or not each individual line was shipped. For example, if you enter S and A for this parameter, only S and A items are listed as shipped on packing lists, but items not status S or A can be listed on the packing list showing as back ordered. This option assists your customers in reconciling open items on their purchase orders to your packing lists.

  • Select the level: (L) Line (S) Serial (I) Item - Enter L, S, or I in this field to indicate the consolidation level for packing lists. The following levels are available:

    • L - Line Level. This is the default. All line items are printed in the sequence in which they appear on the order. This is the most detailed version. All message lines on the order also appear, except those with prefix codes that prevent printing on picking and packing lists.
    • S - Serial Number Level Consolidation. All detail lines with the same item and serial number are combined. For example, if multiple bin locations for the same item and serial number are on the order, they are added together and printed on one line.
    • I - Item Level Consolidation. All detail lines with the same item number are combined. For example, if multiple serial numbers or bin locations for the same item are on the order, they are added together and printed as one line.
    • Do not confuse this option with the Include/Omit parameters available when running packing lists. The Include/Omit parameters determine which lines appear on the packing list. This option controls how they appear, based on their status.
  • Do you want weight to print for each detail line? - Enter Y if you want to print the weight on each detail line, or N if you do not. This parameter applies to all versions of the packing list.

  • Do you want the second line of item description to print? - Enter Y if you want the second line of the item description to print, or N if you do not. This option applies only to level S or I packing lists. Detail level packing lists always show the second line of the item description.

  • Do you want to skip lines between detail lines? - Enter Y if you want to skip one line between detail lines or N if you do not. This causes the packing list to read easier, but contains fewer items per page.

  • Enter the number of default laser Packing Lists to print - lets you control how many default Packing Lists are printed per spooled file. If the setting is 1, only one packing list is printed. If the setting is 2, the original packing list is printed and a duplicate is also printed. The default setting is 2 which directs the system to print 2 packing lists per spooled file. There is a minimum of 1 Packing List and a maximum of 9 Packing Lists per spooled file copy.

  • Change order status to __ when packing slip prints from the warehouse shipping reports - This option lets you enter a new status code for an order/line when a packing list is printed from either the green screen (via menu option WAR 8) or Navigator (from the Warehouse Shipping Reports). This functionality can help to prevent packing lists from being printed multiple times. This functionality only works when a packing list is printed from the Warehouse Shipping Reports in either the green screen or Navigator. It will not work if the packing list is printed from within the order itself . If the setting is left blank, the default, then the order/line status remains at the current status. When a packing list is printed the order/line is automatically updated to reflect the new status. The order's notepad is also updated to note the change of order status.

  • Adhere to W* on message lines to not print them on Packing List - W* designates that a message line is for warehouse use. Enter a Y in this option to not print warehouse message lines on Packing Lists. The default setting is N.

  • Suppress printing Collect $ on Packing Lists - This setting hides prices. This setting was developed for COD accounts who often send in their customers to pick up the products.

  • Print barcode for customer's item number and Print barcode for quantity shipped - Packing list now contain the following fields in both plain text and barcode: PO Number Qty Shipped, Customer Item Number (which comes from the customer preferences file). This enables scanning of bar codes into the electronic warehouse management system, to receive material into inventory with a minimum of difficulty.

  • Enable Signature Capture on Packing List - Adds the ability to capture a signature at the order desk counter when a customer picks up a processed order. The signature is added to a packing list and saved as a PDF to a repository or displayed. Unprocessed orders are not affected by this update. This functionality is designed to work with Topaz model t-lbk462-hsb-r signature pad. For more information, refer to Signature Capture

  • Display Order SY Quantity - Enter Y to show the total SY for the entire order at the bottom of the packing list. If set to N, the SY is shown for each item on the order, but the SY is not totaled up.

Print Serial Number Tag Setting

This option controls the system-wide settings for serial number tags.

  • If Y is entered, serial number tags can be printed for non-rolled goods from the Receipts and Back Order Fill Menu.
  • If N is entered, serial number tags can only be printed for rolled goods.

Serial number tags are bar coded and can be printed on bar code labels or 8 1/2 x 11 laser paper. These tags can be used to label and track pallets, rolls, crates, and slabs.

Retail Customer File Options

This option contains the following four settings that control if and how retail names appear, and activate access to the retail customer file from certain applications.

The following forms, reports and inquiries are some of the programs affected.

Forms

Inquiries

Reports

  • Pick lists

  • Acknowledgements

  • Quotes

  • Pick list edits

  • Invoices

  • Transfer pick lists

  • Labels

  • Stock Card

  • Back Order Fill

  • Order Inquiry

  • Inventory Inquiry

  • Invoice Inquiry

  • Pre-Receipts and Back Order Fill

  • Open Order Reports

  • Auto-Print PO Date Change Report

  • Order Desk Cash Receipts Listing

  • Advance Deposits Listing

  • Commission Reports

  • Replace Billto Name with the Retail Customer Name on Screens/Reports - The Retail Customer File can provide an alternate billto address, as well as an alternate Shipto address. For example, when a Retail Customer File name is used within a generic account such as "Cash Sales", the billto name and address can be the retail customer instead of the generic account information. This technique also allows for a separate retail billto and shipto, each maintained in their respective files.

Some of the programs that are affected by this change are: Order Entry and Search, Allocation Swapping, Inventory Inquiry, Back Order Fill, Forms, Open Order Reports, and Order Inquiry.

  • Restrict to Company # - Enter the companies where you want the retail name to show. Entering no companies will allow retail name replacement for all companies. If you leave all company fields blank, the settings apply to all companies.

  • Allow Access to Retail Customer File from Order Inquiry Screen - Entering Y for this option activates a function key (F1) that can be used to access the Retail Customer File directly from the Order Inquiry screen. When the Retail Customer File is accessed from Order Inquiry, it extends your search capabilities to include finding orders based upon the retail customer's name, phone number, and address.
  • Allow Access to Retail Customer File from Billto Search Screen - Entering Y for this option activates a function key (F1) that can be used to access the Retail Customer File directly from the Billto Search screen.
  • Must you enter a value in the Email Address - This option makes the entry of an email address mandatory when creating a new Retail Customer account or updating an existing account. Retail customers are created via the Retail Customer File in both Navigator and in the green screen (menu option FIL 60).
Sales Portal Options

Restrict Order views in My Sales - If set to "N" the display of orders is not restricted. If set to "Y", the system compares the user's logon information to the following areas to see there is a match on the order s salesperson on the order; if there is a match the order/order line is displayed.

  • Limit to Salesperson - Salesperson ID and Salesperson Manager ID fields in the user s control panel (SET 32).
  • Salesperson file where Sales Manager is equal to Sales Manager in the user control panel
  • Salesperson relationship table (SET 28)

Restrict Order views in Customer Information - If set to "N" the display of orders is not restricted. If set to "Y", restrict the orders under the same guidelines as the setting Restrict Order views in My Sales.

Show GP% on Inventory Lookup - This option adds a GP% column to Sales Portal and Navigator Item Inquiries. By automatically calculating and showing the GP% errors can be reduced as opposed to manually calculating it.

Users have to be given permission to see costs via the Show Costs on Order setting on the Control User File Maintenance screen (SET 5, Option "U").

Default Send Pricelist Subject - Provides the ability to change the current global default, pre-populated subject line from " Dynamic Price List" to other wording. This eliminates users from having to change the subject each time a price list is sent and have it globally set to correct wording.

Enable Geolocation Functionality in Sales Portal - activates Activity Tracking and Geolocation /Contacts in Sales Portal and allows you to set the distance, in miles or KM, for customer lookup. For more information on Sales Activity and Geolocation in Sales Portal click Activity Tracking and Geolocations in Sales Portal.

Decimals are allowed (e.g. 150.50 miles).

Email for Geolocation Update Approvals - allows you to enter an email address for geolocation approvals.

Serial number assignment

Activates the automatic assignment of serial numbers in the receiving process.

Enter Y to activate the system's ability to assign serial numbers automatically in the Enter Receipts program. Activate the specific functions required, either in the Manufacturer file or the Product Line file. The system assigns default serial numbers or unique serial numbers, as specified in those files.

In order for this setting to work, a serial number range has to be entered in the Unavailable serial number ranges. If you do not have any unavailable serial number ranges that you need to define, you must at least enter all zeros.

Serial# Status Codes to be omitted by Reorder Reports

Omits certain inventory serial numbers from being counted in reorder reports, based on status codes.

  • Enter up to 16 serial number status codes to be omitted on Reorder Reports - Each serial number in the inventory system, for serialized items only, can be marked with a status code. Some status codes are system supplied, such as I - Being Inspected; L - Lost; # - In Suspense; M - Measured. Others are user defined. This table enables you to omit inventory, for purposes of determining reorder quantities, based upon the status code on the serial number. In the example above, any inventory that is status I, # or L will be omitted from the onhand and available inventory calculations when reorder reports are run.

  • Code - Enter a valid serial number status code.

  • Description - After pressing Enter, the description of the status code appears if it has been defined in the Order and Serial Number Status Codes table (SET 7).

Ship Date Options in D24/CMS for Customer Orders

 

Ship Date Options in EDI for Customer Orders

At least one, and only one, field for each setting is required.

  • If your order is a must ship complete you probably want the last available ship date since the last available proposed date will be the one that can ship all lines. This is the default.
  • For all other orders you might want first available. This is the default.

Status codes to trigger Auto Transfer Process

This option enables you to specify the status codes that should trigger the auto-transfer process. These parameters affect the Update Order Status and Shipping Data Program and the Warehouse Menu's Update Order Status Programs.

  • Enter up to 16 status codes that should trigger an Auto-Transfer - Enter the order status codes you want to use to trigger the auto-transfer process. These apply only to customer quick transfers entered by selecting stock on a customer order from a warehouse other than the one delivering the material. For example, if you use the status code A to indicate a transfer has arrived, you can enter it in this table to cause an auto transfer. When a user updates a transfer order to status A, the inventory is automatically adjusted into the destination warehouse.

  • Code - Enter up to 16 order status codes. Any of the codes entered here triggers the auto-transfer process.

  • Description - The descriptions from the order status code table appear after you press Enter.

  • Enter Y to print Audit Report for each Auto-Transfer - Enter Y to create a one page report for each auto-transfer processed. These reports are kept on hold in the user's spool file. Enter N to not create audit reports.

When any of the status codes listed on this screen are entered or scanned, the system takes the following actions:

  • The system checks that the order is a customer transfer order. No further action is taken if it is not a customer transfer order. The following steps are taken if it is a customer transfer order:

  • The material being ordered is assumed to have arrived at the destination warehouse. An actual stock-to-stock transfer is recorded, and the order now is allocated against the stock just transferred into the destination warehouse.
  • If the material was scanned into a new bin location, then that bin location is now shown on the order and the inventory. If no new bin location is specified, the program automatically assigns bin location Fxxx, where xxx is replaced by the originating warehouse. For example, FRAL is assigned to transfers "from Raleigh". This bin location scheme is applicable only to serial numbered items. The new bin location shows on all order inquiry and inventory screens. Scanning of the actual staging locations override this code.
  • If the item being transferred has a valid freight key code in the Item Master File, the Interwarehouse Freight Costs table is accessed. Additional costs are added to the cost of the transferred goods, both on the order and within inventory.
  • If the option Enter Y to print Audit Report for each Auto-Transfer, is activated then a transfer report is left on hold in the Print Spool File for all auto-transfers.
  • The order notepad is updated for each auto-transfer.

Transfer Filled Email: these settings trigger emails to be sent when a transfer has taken place based on status code change. Enter a Y in the Email setting to activate this functionality. When this setting is activated, the individuals listed in the Hold and Back Order Fill Contact Table (menu option SYS 921) will receive an email when an order gets at a status that triggers an auto transfer.

  • Attach Order PDF - Enter a Y to include a pdf copy of the order in the email.
  • Activate emails for contact of Order Acknowledgments- If this setting is activated, the Billto Phone number file is searched for individuals who are designated to get order acknowledgments via email.
  • Activate emails for Order Contact, if email address - Activate this setting to send an email to the order contact on the order header if the value is an email address.

Any additional text comes from the Additional Email Body Message configured for Back Order Fill emails.

Stock Card Date Options for Back Orders

This option controls how dates on the Stock Card Screen are set for back orders. The default option is O (order date).

The S (ship date) option sets the stock card date to be the ship date. If you use ISO as your primary method of order entry, the S option preserves the ship dates ISO assigns. If you often override back orders ship dates to dates such as 12/31/2005, then the S option may interfere with your ability to determine the sequence to fill the back orders.

The O option sets the stock card date to the order date causing the back orders to display in order date sequence, often referred to as "first come/first serve".

Unavailable serial number ranges

Specifies the ranges of serial numbers the system should bypass if the automatic serial number assignment is active. This setting is required if you are using the automatic assignment of serial numbers feature; activated by entries in the Manufacturer file or the Product Line file. Once activated, the receiving system assigns a unique six-digit serial number, based on these number ranges.

  • Beginning Serial Number - The next unique serial number that will be assigned in the receiving system. Unique serial numbers are assigned to items coded for this feature in the Manufacturer or Product Line files.

  • Unavailable Serial Number Ranges - Enter up to three ranges of serial numbers the system should skip when assigning unique serial numbers. This is helpful if you have manual preprinted serial number tags. Load the range of the preprinted serial numbers in these fields.

Validate Classification Codes & Cost Center in Item File

Restricts the entry of cost centers and item codes in the Item Master file, unless those codes are defined in the Cost Center and Classification files, respectively.

  • Validate classification or codes and cost center - Place an X in this field to validate the classification codes and cost center in the Item File. This causes the item file maintenance program to display an error message for codes not set up in the cost center or classification codes files.

Activating this option directs the system to perform the following:

  • prevent blank or invalid cost centers from being entered into the Item File.

  • prevent item classes from being entered into the Item File unless they have been set up in the Classification Codes File.

This option currently applies only to item classes 1, 2, 3, and the item trim classes.