Need more info or you couldn't find what you were looking for, let us know by sending an email to: support@dancik.com.

Additional CMS Information

Supported Transactions

CMS License Keys

Working With Accounts Payable Invoices received via CMS

Master Attributes File

Product Type Material Classification Codes for 832_-_Price_Catalog

Supported Transactions

Home Depot

ASCII Character Chart

ASCII stands for “American Standard Code for Information Interchange”. It is the character set that is used in PCs and most other small computers. (The other big standard is IBM's EBCDIC character set, which is used in IBM minis and mainframes). The table below lists all of the characters in the character set, along with their decimal, binary and hexadecimal number equivalents, so you can also use it as a conversion chart:

Note:   ASCII characters 0 to 31 are control characters, not printed characters. They are represented using short forms in the “Char” column. The “Code” column represents the keystrokes usually used to generate the character on a standard “enhanced” PC keyboard.

CMS License Keys

In order to retrieve license keys from Dancik, you need to supply Dancik support with the following:

Host Name and Domain Name

Both settings are accessed by entering CFGTCP on a command line to access the Configure TCP/IP screen.

Select option 12 - Change TCP/IP domain information. The Host name and Domain Name are displayed on this screen.

Partner IDs 

A listing of Partner IDs can be viewed via the AS/400 CMS menu.

To get to the screen shown above follow one of these paths:

•   On the Traditional menu system

—   From the Data Processing menu, access CMS via option 14.

—   Select option 2- Schedule Automatic Processing.

—   Press F6=Search.

•   On the Dancik Menu system

—   Access the CMS menu (CMS)

—   Select option 20 - Schedule Automatic Processing & Maintain Global Settings

—   Press F6=Search.

Partner IDs are established using the Partner section of the Administration on the CMS web interface.

Note:  For information on the setting contained in the Partner dialog box, refer to Adding Partners.

Working With Accounts Payable Invoices received via CMS

Option 12 Inbound CMS Voucher Maintenance on the AP Entry menu allows you to “move” inbound invoices from your supplier(s) to a specific workstation for editing and posting.

Ideally all invoices associated with a “shipment/manifest” should be moved, you will notice in the top portion of the screen you may enter a “manifest” number to tag all invoices at once for movement.

Pressing Enter performs the workstation assignment (they may now be edited from that workstation using option 2).

When invoices are moved, the system calculates variances and prints an AP Reconciliation report. Variances are posted to GL account maintained in the A/P & G/L Defaults Maintenance File.

If you do not want to post your batch, use the “R” feature via option 12 Inbound CMS Voucher Maintenance to restore the invoices from the workstation and place them back into this screen to process later. When the invoices are posted they are cleared from the screen. Invoices can not be moved to a workstation which already has an active batch, and restoring invoices clears that workstation. Variances are recalculated each time invoices are moved to a workstation.

Finally, GL accounts may be linked to specific charges on supplier's invoices via system x-ref tables XXXAPDEF and XXXAPDEFDR.

As with any EDI transaction, only discrete charges correctly identified on the supplier invoices are mapped to specific general ledger accounts. CMS is capable of associating invoice charges to specific GL accounts as illustrated in table 5-1 on page 5-9 of CMS documentation, but these charges must be discreetly identified on the supplier invoice.

Master Attributes File

The Master Attributes File Maintenance Program is accessed via option 11 on page 2 of the System Settings Menu. This file allows internal and external users (Internet, showroom, office) to run searches or queries based on specific file attributes and their values. Although the Master Attributes File can be used to define attributes related to multiple files, it is now available only for defining item (product) attributes. For this reason, this feature may be referred to as “Item Attributes” throughout this release. The Item Attributes File is a collection of user-defined fields that can be integrated into the Item File and item search functionality. Examples of item attributes are TEXTURE, ROOMS, and COLOR. Examples of values for these attributes are SMOOTH, ROUGH, KITCHEN, BATHROOM, BLUE, YELLOW. You can submit a query for all SMOOTH, BLUE tiles that is appropriate for a BATHROOM. All the items that have those attribute values are included in this listing.

Different information is needed for different products. For example, attributes could include “Commercial Versus Residential,” “Rooms To Use Product In,” “Degree Of Shade Variation,” “Texture,” “Style,” “Look,” “Matching Paint Chips,” or “Fiber”. You can limit certain attribute information to certain cost centers and manufacturers.

You can run a report from the Item File Listing that prints all the attributes for each item. The path to this report is as follows:

• From the main menu, access option 3 - Listings and Reports

• Option 1 - Master File Listings

• Option 2 - List Item File

• You will run through a series of screens that allow you to pick the report parameters and

• customize the report.

• When you get to a screen that allows you to print only the report or the report and item

• labels, select Print Report only

• The next screen allows you to include item attributes on the report.

The Master Attributes File is maintained using option 31 on the System Settings Menu (SET). When option 31 - Master Attributes File Maintenance is selected, the following screen displays:

The screen above will have an empty list of master file attributes when you first display it. Use F1 to create attributes. Reference type IT (for items) is the only valid type at this time.

In the example above, several item attributes have been defined. Once defined, you can use the Item File Maintenance Program to assign attributes to specific items. In effect, item attributes are user-defined extensions to the Item File, which are used for product searching.

The screen above utilizes the following fields:

The following screen displays when you press F1 to create a new master file attribute.

The above screen is used to define a new item attribute. It utilizes the following fields.

F13 (Work With Attribute Values) Screen 

This screen displays attribute values already established, and allows you to create (add), delete and update attribute values. Attribute values are the values that you have designated as valid for that attribute. If you enter “Y” for “Use Validation Checking”, then you can only enter one of these values into the Item Master file for this attribute. Use F1 to create new attribute values.

F14 (Include/Omit Cost Centers) Screen

This screen allows you to limit an attribute to certain items based on cost center. For example, you can specify cost centers that should be omitted, and items with those cost centers will not be associated with this attribute. You can specify cost centers that should be included, and only items with those cost centers will be associated with this attribute. You cannot mix “I” and “O” entries on the same screen. The screen must be set up as “include only these cost centers” or “omit these cost center & include all other”. Press F1 to add cost center restrictions on this screen.The F16 screen, to omit or include manufacturers, works exactly like the screen above.

Product Type / Material Classification Codes for 832 - Price Catalog

The material classification is a seven-character code, defined as follows:

• Characters 1-3 (Mandatory) - General Classification (Carpet, Wood, etc)

• Characters 4-6 (Optional) - Sub-Classification if relevant and available

• Character 7 (Optional) - Flag for Commercial versus Residential (C or R)

It is understood that not all systems and participants will classify materials the same or even have the necessary classifications available for this process. Therefore, we have made these classifications as simple to comply with as possible. We have included code “UNC” for “Unclassified”, for any trading partners that can not send a proper classification. The sub-class “SAM” for samples and “MIS” for miscellaneous/other is applicable to all categories.