Adding SKU Items Training Guide

Downloadable version: PDF ICON (1)

In order to charge for items in ActionFlow, each item be registered in the SKU Items tab – this means there is a SKU Item assigned to a SKU class. Therefore, the first step to be able to charge for items in ActionFlow is creating SKU Classes.

Step 1- Create a SKU Class

Follow the steps below to add a new SKU Class:

    1. Click on the Administration tab on the top navigation bar. Once in the Administration Tab, locate the SKU Classes on the left side of the screen.
    2. Click the Green Plus sign to add a new SKU Class.
    3. Complete the key Class properties listed here. There are additional properties (described below) that may or may not apply to the class.
      • Class – the name of the group of SKU items
      • Type – how SKU classes are grouped
      • Sort – the order the class will appear on customer reports
      • Invnty? – whether or not the class is inventory
    4. Click on the Save button in the upper right-hand corner to save the SKU Class.
    newSKUClass

    SKU Class Properties

    This is a brief overview of the SKU Class Properties. 

    Property

    Description

    Class

    Name of the Class – this will define a group of SKU items

    Type

    The SKU classes are grouped into classes, and they fall into different Types. The different Types are listed in this dropdown

    Sort

    The Sort number defines how line items will be sorted in the area module and various reports

    Btn#

    Add buttons to the area module to quickly access a SKU class.

    Invnty?

    Track the SKU items in this class as Inventory items

    NonSer?

    Designate non-serialized inventory items that will not have a unique ID (ie. caulk, brackets, polishing pads, sinks, etc.)

    Sink?

    Designate the class as sinks for sink reports

    Invoice Accounting Mapping

    Maps classes in ActionFlow to the name in your item list in QuickBooks

    Inventory Accounting Mapping

    Map inventory to an item that is also an inventory part in QuickBooks.

    Group

    Define groups for the Span report

    MaterialWaste%

    Estimate how much material is wasted to calculate cost and margin

    Default Vendor

    Assign a default vendor for inventory classes

    Step 2- Add a SKU Item to a SKU Class

    Follow the steps below to add a new SKU Item:

      1. Select the SKU class to which it belongs.
      2. Once the SKU Class is highlighted blue, click on the green plus sign under the SKU Items Section.
      3. Fill out the information based on the columns above that you want to add. (The SKU, SKU Class and Unit are required columns)
      4. Click on the Save button in the upper right-hand corner.

        newSKUItem

    These are the columns for the SKU Items:

    • The SKU name uniquely identifies the line item and must not duplicate any other SKU name
    • The Class identifies the SKU Class
    • The Unit must be one of these values:
      1. Each - where the user will enter the quantity manually
      2. Finished Linear Foot - ActionFlow will calculate the quantity as the number of finished linear foot
      3. Slab - ActionFlow will determine the quantity based on the slab information entered
      4. SqFt - ActionFlow will calculate the quantity as the number of countertop square footage in the quote
      5. Total Linear Foot - ActionFlow will calculate the quantity as the number of total linear foot
    • The Length and Depth are where you enter the dimensions of slabs
    • The Unit Cost is where you enter the cost for purposes of calculating the margin on estimate
    • The Margin is where you override the margin for margin calculations.
    • The Aliases allows you to enter alias names for items. Multiple aliases should be separated by commas.
    • The Description is where you can enter a detail description
    • The next four columns define how items show up on the drawing of estimates.
    • The Image is where you enter the image that will be displayed on reports for this line item, and the buttons next to it allow you to add, delete and view the images for the line item
    • The Remnant determine how much of the value of a slab is carried over when a remnant is created
    • The Invoice Accounting Mapping allows you to map this item to an item in your accounting software
    • And the Default Category is used as part of the SKU Import function to automatically add the item to a category

             

    Step 3- Add a SKU Item to a CalcType

         Now that you have created a SKU Item, the next step is to add it to one or more CalcTypes. CalcTypes are essentially price lists where you set the amount to charge the customer for each SKU Item. Every SKU Item you want to charge for on your quote should appear as a SKU Item within one or more CalcTypes. To set the price, the SKU item must be moved to the right side of the screen, into the Cost Definitions grid. You can assign prices individually or you can create Categories. Categories can be used to group items that all have the same price point. For example, a color Category can be used to set the price of multiple colors at one time.

    Option 1- Adding SKU Items to the Cost Definition Grid (No Category)

    1. Select the name of the CalcType from the Name drop down box that you want to add the SKU Item to.
    2. Select the SKU Class for the SKU Item falls in to that you want to add. Click the SKU Class to highlight the field.

    3.  Highlight the selected SKU Items you would like to add to the Cost Definitions. (You can add multiple SKU Items by clicking on the items you would like to add while holding down the Control or Shift Key.

    4. Click on the ‘Add Selected SKUSs’ button under the Cost Definitions. This will add the SKU Item to the CalcType. Click on the Save button that is located on the top right-hand corner of your screen after you add the SKU(s).


    Option 2- Adding SKU Items to Categories and then to the Cost Definitions Grid

    4.  Instead of adding each SKU Item individually to a CalcType, you can instead add the SKU Items to a Category, and then add the Category to the CalcType. To create a Category, click on the SKU Class that you want to add the category to. Click on the Green Plus sign under Categories. The Class will autofill. Enter the Category and Unit.


    5.  Highlight the SKU Items you want to add to the Selected Category.   You can select multiple SKU’s to add at one time by clicking on the items you would like to add while holding down the Control or Shift Key. Make sure the Category you want to add to is highlighted blue. Click the ‘Add Selected SKU Items to Category’ button.

    6.  Click on the Category to highlight the column you want to add to the Cost Definitions. Then click on the Add Selected Categories button. This will move the Category to the Cost Definitions chart.

    Step 4- Add Pricing That You Will Charge the Customer

      You can set a price for individual SKU Items or for a Category using the same process once they are moved over to the Cost Definitions Grid.  You can set different prices for different CalcTypes.

    1. Enter the price you want to charge the customer into the UnitRevenue field. Once entered click on the Save button in the upper right-hand corner of your screen.

     

    There are other settings that you can change on the Cost Definitions Grid, which are described below:

    • The Material column allows you to define a charge than only applies when a certain material is selected. If the asterisk is showing, then the line item will apply for all materials.
    • The five columns starting with the Special column allow ActionFlow to perform special calculations in very specific situations and I won't go into detail on that here
    • The AltCalc checkbox is used to tell ActionFlow to include that Material line item in the Alternative Calculations grid. In those cases, you can enter a 'Slab Square Foot' amount to be used in those calculations.
    • The AutoAdd column tells ActionFlow to automatically add this line item to every calculation
    • The NotTaxed column tells ActionFlow to exclude this item from tax calculations
    • The Hidden column will hide this item from the Estimate reports
    • The Discontinued checkbox disabled the item from future calculations, while leaving it in for past calculations
    • The Option checkbox will cause the item to be added as an 'Optional' item
    • The Effective and End columns allow you to define certain periods where the item applies. So, if the price changed, you can enter an End Date and then create a new line for that item with the new price and the applicable Effective Date