2020 Kitchens Module Data Settings

This page covers the Data Processing Configure options for the 2020 Kitchen Module.

 

  1. Run the XpressPOS Options & Settings program from the All Programs Menu. The XpressPOS Options and Settings run command is under the Saberis XpressPOS menu item.

  2. On the Options & Settings form, select the Kitchen Button on the left.

  3. Then Select the Configure button as shown below.

 

 



Starting with XpressPOS V.8.5, changes have been made to the "Set-up" of 2020 in order to run XpressPOS. Please see "XpressPOS 8.5.0 New Features".

  1. General Tab: Added to the General Tab is the "Reconfigure 2020 for XpressPOS" function.

    Reconfigure 2020:
    This function will set-up the necessary files in the 2020 Queue folder so that the Application Integration report on the 2020 Reports Menu will have the correct preferences, and that XpressPOS by Saberis will appear in the "Program" box for the RUN command.

    Whenever a new version of 2020 is added to a computer with an existing XpressPOS setup, then the "Configure" button must be selected.





    One or both of the following messages will appear. One for pre 2020 V.10 and one for 2020 V.10 or later.





Apply a sort order: XpressPOS provides the ability to sort the items from the 2020 XML file. There is no clear logic to the order of the items in the XML file. All of the design catalog's floor items come first, followed by all the wall items. The items seem to be in a left to right order on each wall, however, the walls do not come in any logical order.

By applying a sort order, you can arrange items by product type order. Click on Configure to access the Sort Sequence Utility (see below).

 


Use the Edit button to change the sort sequence number. Pulls, Moldings, Toe Kicks, and Counter Tops that are specified under Accessories will sort with Accessories. To control the sort order of these items, they must be specified under Counter & Trims, or Styles, and Pricing for Pulls. The identification of the item type is dependent on the correct setting in the Vendor Catalog for the WCC (WhichCabinetCode) variable. If items do not appear to sort correctly in a specific catalog, it will be due to incorrect WCC settings.

NOTE: Moldings, Counter Tops, and Pulls from the 2020 Accessory list will appear under Accessories. To appear as Molding, it must be assigned under the Countertop and Trims function in 2020. Pulls must be set under Catalog Charges in the Styles & Pricing.

 

Allow multiple catalog processing: This is the recommended way to process 2020 orders.

XpressPOS calculates the selling price based on any, or all 2020 Rate Records, Catalog Charges, or Design Charges. See the Pricing Tab.

The only time you cannot process multiple catalogs is when they have a different selling factor AND you want to apply that factor  during the import process into the POS/ERP system instead of 2020. This is because most systems cannot recognize a change in the catalog in the import process.

If you apply a uniform "mark-up" on cost in the POS/ERP system, then you can use the multiple catalog process.

 

NOTE: If you leave the Room catalogs and Sample catalogs checked in the 2020 Application Integration form, XpressPOS can be set to skip them (see Catalog Tab).

Combine Like Items: This option will combine like items based on their 2020 User Code. Example: Three W3030 cabinets will be combined or "rolled-up" from three lines to one with a quantity of 3.

If a cabinet has an Attachments or Item Note, or has a dimension modification, it will NOT be combined with other cabinets.

Show Summary form:

 

Check the box (see #7) and this Process Summary form will appear every time you process an order from 2020.

 

This form allows the user to make temporary changes to many Options & Settings "on-the-fly". That is, for a specific order.

  1. Change the export file name: Edit this text box to whatever name you want including the file extension.

  2. Customer Number: If your POS/ERP system can process an imported order differently based on a customer number, you can set-up the customer number in 2020 Project Manager, or just enter it here.

  3. Store Number: If you are using the Store Number as part of the export file name, you can change it here for an order and the file name will change.

  4. Sales Person: If you are using the Sales Person as part of the export file name, you can change it here for an order and the file name will change.

  5. Cost Factor: The main use of the Summary form is to change the Cost Factor when the default cost factor does not apply to this order. Example: Normally you buy full vans, but on this order you are buying less than a truck load and the cost factor is different. You can also edit the selling factor and Default SKU.

  6. Cost and Selling Price: The Summary form also allows you to change the method of applying selling and cost factors. If you did not want to use the 2020 selling price, you could select the "Apply a selling factor" option, and edit the Selling Factor for each catalog in the Catalog Setting grid.

  7. Show this form: Uncheck this box to hide the Summary form.



Click Process to proceed.

 

 

  1. Configuring SKUs  This is a step-by-step process that XpressPOS carries out if you activate them by checking the boxes shown below. Normally you would only be checking one box, however, you can check more than one.

    The order shown is the order that XpressPOS follows to process the SKUs.

Product Code: Check this and XpressPOS will send the 2020 User Code to the POS/ERP system. Systems that can handle "invalid skus" and treat them as "special orders" will usually use this option.

SKU Mapped from Catalog:  If you use a Default SKU for "special orders" and want a different one for each vendor or catalog group, this is the option you need. Check this box and then set-up the Default SKUs under the Catalog Tab.

SKU mapped from Rate Code: If a separate SKU is wanted in the POS system for not only each catalog, but also for each catalog/customer type, you can set-up rate codes in 2020 (Catalog Charges in 2020). The User Code field (Rate Code) that you set in 2020 is used as the SKU by XpressPOS.

 

Default SKU: If none of the three options are checked, then the Default SKU is used. Change this sample SKU, "2020sku" to your default Kitchen SKU.

 

 

TIP for inventory stock: Do you stock Cabinets, Moldings, or Hardware and want to have XpressPOS create the inventory SKUs for them? Saberis can provide, on an annual subscription basis, inventory SKUs for selected product lines such as Aristokraft and Merillat, or selected items in a catalog. Call us at 800-387-7963 or email us at sales@saberis.com

  1. Configuring Description:

    XpressPOS allows the building of the description that will be imported into the POS system.

It is worth noting the following about 2020 catalog "standards":

  • Most catalog developers use User Code formulas. What this means is that if a dimension is changed, or the description is edited, the user code will be changed by 2020 according to the formula for that item. A B30 edited to 29 1/4 inches could become B293624. If you want to retain the original code, you may be able to use the Manufacture Code instead. This code does not change if dimensions are edited.
     

  • A word of caution about the Manufacture Code: Although in many vendor catalogs the User Code and Manufacture code are the same, this is not always true. Some vendors use this field for other purposes.

Description Options:

  1. Use Word Wrap - As descriptions get longer, truncated descriptions occur. Most POS systems are limited to 32 characters of imported description data. Word Wrap will create comment lines with the overflow.

    Word Wrap is usually mandatory if the "Roll Attachments into their Parent" option is used (see Attachment Tab). Uncheck this box for BisTrack or any system using the Saberis Standard XML export file settings.
     

  2. Add Item Notes - This option will insert any 2020 item notes as comment lines to the item.
     

  3. Include Catalog Name - XpressPOS will create a comment line at the top of the file with the 2020 eight character catalog name. It can be used to visually check if the latest catalog was used for the design.
     

  4. Include Price Level - Similar to option 3 above, except that the comment line will contain the price level description. It can be used to visually check that the correct price level was used in 2020 for the selected door style.
     

  5. Include Styles and Options - A comment line will be added for all the Styles and Options set in the 2020 Catalog Styles tab. Door and Drawer pulls are the exception. The pulls will appear as accessory line items and are not treated as "Global" options.
     

  6. Use Phrase Mapping - This processing option can be used to reduce the length of descriptions. This process is performed on the final description after all other description options are performed.



    To add Phrases,  click on Configure and then on Add.




    In the Source box, enter the phrase you want to change or eliminate. Then in the Target box, enter the replacement phrase, or leave it blank if you want to eliminate the phrase.



 

  1. Configuring Pricing

  1. First, apply your cost factor if you want the item cost to be included in the file for your POS system. The actual cost factor is entered on the Catalog Tab for each catalog.
     

  2. Selling Price should, in most cases, be set to "Use 2020 Pricing". No matter what 2020 method you use to set the selling price in 2020, XpressPOS will process all the discounts and apply them to each line item.

    There is no need to apply a selling factor when importing the order into the POS system. This is very important if you are using Multiple Catalog Processing from 2020.
     

  3. Item pricing is the XpressPOS default setting. However, parent pricing option is available. This option will "roll-up" all attachment pricing into the parent cabinet pricing and leave the Attachments as comment lines.

    TIP: If any of your vendor catalogs have negative pricing such as "Remove Doors -50%", XpressPOS will send an item to your POS/ERP system with a negative price and cost. Most systems cannot handle this. It is recommended that you use Parent pricing.
     

  4. Apply up charges is recommended for most users. XpressPOS applies all door, drawer, and premium up charges (construction and finish up charges) to the applicable line items. Therefore you get the real total price and cost values.

 

  1. Configuring Attachments

Attachment Processing

  1. Remove Attachments from their parent: Many vendor's 2020 catalogs have Attachments that are not installed. They are shipped separately.

    To have these items appear as accessories sorted at the bottom of the order, check this option box and click on Configure.

    In the Attachment List Utility (see below), select ADD and enter the attachment User Code (product code) as shown in the List Utility Add/Edit form example for ROLLOUT.
     

  2. Delete Attachments from list: Some attachments are not part of the order. This can happen if a vendor has graphic items in the catalog. An example would be sinks. These items can be set-up to be deleted on all orders.

    If you see "GRAPHIC" or "IMAGE ONLY" items on the order, add their User Codes to the list for deletion.

    Another use of this feature is to reduce the number of comment lines. If there are a lot of "Finished End" attachments that may not be necessary to show in the invoice or receiving documents, then delete them. Make sure you turn on "Parent Pricing".
     

  3. Roll Attachments into parent: This will eliminate all attachment records and add the User Code of the Attachment to the parent description.

    You will get parent pricing, and you should probably uncheck the description box in the "Build Description" option.

    Also, make sure you have Word Wrap on since descriptions will start to get long. 


Additional Processing

  1. Add a Prefix: If you are displaying Attachments as separate records, you may want to add a prefix to the description to make it more readable in the POS system.
     

  2. Add dimensional comments: If a cabinet's width, height, depth, or width2 is modified in 2020, XpressPOS can add a comment line to the cabinet. Example:

    W=29 1/2, H=36, D=24
     

  3. Add finish side comments: For those catalogs that use the 2020 automatic finished side feature, XpressPOS can add comment records. Example:

    Finish Side = LEFT


The Attachment List Utility pops up when the Configure button is selected.

Example of an attachment that is to be moved to a stand alone accessory.

 

Example of adding an item to be removed as an Attachment and re-classified as a stand alone Accessory.


 

Example of an Attachment that is to be deleted.

 

 

  1. Configuring Catalogs:

XpressPOS has its own catalog list. The catalogs in XpressPOS can be considered as Product Lines. Options for these catalogs can be set once. When a new 2020 Catalog is released by the Vendor, it is mapped to the same XpressPOS catalog.

A simple example is Aristokraft. They have three 2020 Catalogs, AOK_TR93, AOK_SE93, and AOK_PS93. If all three have the same cost factor, then you would set-up an XpressPOS catalog called AOK, or whatever you prefer. Now you map all three catalogs to AOK. The common setting for Cost Factor and Default SKU (if needed) will only have to be set once.

Now, when new catalogs arrive, all that is needed is to map them to AOK, or Edit the 2020 Catalog from 93 to the new number.

First, you must set-up all the current XpressPOS catalogs and map the 2020 catalogs to them.

Please note that we refer to 2020 catalogs and XpressPOS catalogs differently. An XpressPOS catalog can represent many 2020 catalogs.

  1. Step-by-Step Setup of Catalogs:
    Click on Add Catalog.
     

 

  1. Enter a name for the XpressPOS catalog or product line. EX: AOK or ARISTOKRAFT.

 

  1. For systems requiring a default SKU, enter your POS system's SKU for the product line.
     

  2. Enter the Cost Factor for the catalog (up to 4 decimals). Please note that if there are two 2020 catalogs for the same vendor, they must have different cost factors.

    Leave the cost factor at 1 if you have it set in the 2020 "Rate Records", or if the POS system is applying the cost factor.
     

  3. Leave the selling factor at 1.
     

  4. Click on Configure to map the 2020 catalogs to their respective XpressPOS catalogs.
     

  1. Click on Add to map a 2020 catalog to the XpressPOS catalog.

  1. Enter the 2020 catalog name in the Source box. Then enter the XpressPOS catalog name in the Target box. The Target catalog name MUST have been entered in the XpressPOS catalog list in step 2.

    Click OK and add another catalog if necessary.



     

  2. When all catalogs have been entered, click Close in the mapping utility.

 

 

Catalog Processing:

To eliminate the need to uncheck catalogs in the 2020 Application Integration form, it is recommended that both Remove Room and Sample Catalog Items be checked.

They should only be unchecked if you use any of these to price out countertops or hardware.  If you do use Sample F for countertop pricing, it is recommended that you rename it in the 2020 Catalog Tools.