Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchortoptop

Excerpt
hiddentrue

Learn to work with Inventory Management

Panel
nameblue

On this page

Table of Contents
maxLevel2

Overview

Inventory management is used to handle physical goods stock in your company's warehouses and follow their movement in and out of your warehouses.  

Major features

  • Import new physical goods into warehouses
  • Move multiple items in, out or between warehouses
  • Distinguish traceable physical goods (aka installed items) through unique number. i.e serial number
  • Track the location where physical goods are stocked and who their supplier is
  • Track the customer location of traceable physical goods
  • Track inventory movements between warehouses and customers for installed items 
  • Keep a balance of physical goods in each warehouse
  • Handle sales of physical goods

Anchor
top
top

Excerpt
hiddentrue

Learn to work with Inventory Management


Panel
nameblue
id0

On this page

Table of Contents
maxLevel2

Overview

Inventory management is used to handle stock of physical goods and to supervise the movement of products that enter and leave a company's warehouses.

In CRM.COM, a warehouse represents the physical location where sold or rented hardware is stored.  A separate warehouse can be set up for each location from which hardware is retrieved.  Additional warehouses can be set up to represent locations where hardware is returned, in order to distinguish them from unused goods.


Inventory management functionality

  • Import new goods into warehouses.
  • Move multiple items in and out of warehouses or between warehouses at the same time.
  • Handle the sale of goods.
  • Keep a balance of goods in each warehouse.
  • Identify individual traceable physical goods (installed items) through a serial number.
  • Identify the supplier of goods. 
  • Track physical goods installed at a customer's location.
  • Track the movement of installed items between warehouses and customers. 


Setting Up Inventory Management

Info
iconfalse
Configuration > Foundation Application > Inventory Management

Warehouse Types

Warehouse types are used to group warehouses and assign them different functions. They Types are added in the inventory definition to designate the types of warehouses that installed items can be taken from, to be provided to a customer or moved to if the customer no longer needs themphysical goods are taken from and returned to. For example, one warehouse type (Sales) can be defined for use when selling physical goods directly from your a company's point of sale , and another when selling physical goods from a partner's point of sale or when renting physical (Rentals) when renting out goods. 

Installed Item Categories

Categories are used to classify installed items based on common attributes.

Anchor
definition
definition
Inventory definitions

Inventory Management Definition is used to define and management definitions control the movements movement of physical goods in and out of warehouses when that are taken from or returned to warehouses and that are sold or rented to customers through Jobs or Subscriptions. This is achieved by providing the warehouse types jobssubscriptions or direct sales.

Provide the type of the warehouse to be used in each event (addition or removal of physical goodssuch as 'For Adding' or 'For Removing') and assign a classification to each type, determining the type of sale that the physical goods of the warehouse will be available for. There are three types of sale:to determine whether the goods are rented or sold.

  • Rentals: Installed items are added to subscriptions and are not purchased by the customers. The goods must be returned when the subscription is terminated.
  • Direct Sales: Installed items are sold through jobs and are extracted from warehouses that belong to your business.  The customers get billed for the physical good through CRM.COM, and it does not have to be returned after the customer stops cooperating with the business.
  • Indirect ; the goods must be returned when the subscription is terminated.
  • Sales: Installed items are sold through jobs and are extracted from warehouses that belong to a business partner. The customers do not get billed for the physical good through CRM.COM, and it doesn't not have to be returned after the customer stops cooperating with the businessor direct sales; the goods do not have to be returned.  If the good is extracted from a proprietary warehouse, the customer is billed through CRM.COM; if the good is extracted from a warehouse that belongs to a partner, the customer is not billed through CRM.COM.

Definition fields

The table describes the sections of Inventory Management Definitions Data Entry page , and explains how the fields in the page are used.

 Mandatory   Configurable

Allowed Warehouses

For Adding

Determines

Define the Warehouse Types

that warehouses should be of, to allow adding physical goods to

from which physical goods can be added to subscriptions or jobs.

For each warehouse type specify its classification: Rented, Direct Sales, Indirect Sales

Specify the classification ('Rented', 'Sales') of each warehouse type.

For Adding During Replacement

Determines

Define the

 

Warehouse Types

that warehouses should be of, to allow adding physical goods to

from which physical goods can be added to subscriptions or jobs during a replacement

.

(i.e., when using the 'Swap Installed Item' action)

For

.

Specify the classification ('Rented', 'Sales') of each warehouse type

specify its classification: Rented, Direct Sales, Indirect Sales

.

For Removing

Determines

Define the

 

Warehouse Types

that warehouses, where

to which physical goods

will

can be returned

, should be of, when removing them If no warehouses of the default type are found for the same group then the system will check for warehouses in the rest of the defined type of the same classifications

when removed from subscriptions or jobs.

For each warehouse type specify its classification: Rented, Direct Sales, Indirect Sales

A default warehouse type must be set for each classification.

  • On returning a physical good, the system checks whether the good is rented, sold through your company or through a partner
  • Then it finds the respective warehouse type which is set as default for the classification (from the definition).
  • Once the default warehouse type is determined, the system checks to find the warehouse that matches the group of the user returning the good, and places the good in that warehouse.
  • Specify the classification ('Rented', 'Sales') of each warehouse type and define a default for each classification.

    Note
    titleSystem process for determining return warehouse
    1. Check whether the returned item was rented or sold (i.e., the classification of the warehouse the good was originally taken from).
    2. Retrieve the default warehouse type of the established classification from the inventory management definition.
    3. Retrieve warehouses of the established warehouse type, from the pool of available warehouses.
    4. Match the group that the user is currently logged in under, to one of the retrieved warehouses' 'Owned By Group', to identify the warehouse the good should be returned to.
    5. If no match is found in the default warehouse type (in step 2), then check other warehouse types of the same classification and return to step 3.


    For Removing During Replacement

    Determines the

    Define the   Warehouse Types

    that warehouses, where

    to which physical goods

    will

    can be returned

    , should be of, when removing them

    when removed from subscriptions or jobs during a replacement

    .

    (i.e., when using the 'Swap Installed Item

    )

    For each warehouse type specify its classification: Rented, Direct Sales, Indirect Sales

    A default warehouse type must be set

    ' action).

    Specify the classification ('Rented', 'Sales') of each warehouse type and define a default for each classification.

    1. On returning a physical good, the system checks whether the good is rented, sold through your company or through a partner
    2. Then it finds the respective warehouse type which is set as default for the classification (from the definition).
    3. Once the default warehouse type is determined, the system checks to find the warehouse that matches the group of the user returning the good, and places the good in that warehouse.
    4. If no warehouses of the default type are found for the same group then the system will check for warehouses in the rest of the defined type of the same classifications.
    Price PlansPrice Plans: Price

    Note
    titleSystem process for determining return warehouse
    1. Check whether the returned item was rented or sold (i.e., the classification of the warehouse the good was originally taken from).
    2. Retrieve the default warehouse type of the established classification from the inventory management definition.
    3. Retrieve warehouses of the established warehouse type, from the pool of available warehouses.
    4. Match the group that the user is currently logged in under, to one of the retrieved warehouses' 'Owned By Group', to identify the warehouse the good should be returned to.
    5. If no match is found in the default warehouse type (in step 2), then check other warehouse types of the same classification and return to step 3.


    Allowed Price Plans

    Define the price plans that will be used when selling physical goods to

    customer

    customers through the Quick Sales process (available through the

    Accounts Receivable

    accounts receivable).  Multiple

    Price Plans

    plans can be specified

    and the default one must be set in order

    .  Set a default to be used

    during

    automatically for Quick Sales

    automatically

    .

    Classification: For each selected price plan you can select the accounts receivable classification for which the price plan will be applied for

    Select Applicable Account Receivable Classifications for each selected price plan.

     

    Back to top

    Anchor
    warehouse
    warehouse
    Warehouses

    ...

    Info

    Foundation > Inventory Management > Manage Warehouses

    A warehouse is a storage place for physical goods. In CRM.COM physical goods.  Physical goods (traceable and non-traceable) reside are located in company warehouses from where they can be accessed and moved retrieved and transferred to customers or between other warehouses. 

    The table describes the sections of Warehouse Data Entry page , and explains how the fields in the page are used.

     Mandatory   Configurable

    Main Information

    Type

    : The type of the warehouse.

    Owned By Group: The group that owns the warehouse

    which

    automatically defaults to

    the group

    that of the logged-in user

    . Select a different group if required. Only users that have

    (can be changed). Only users with access to the specific group

    will be able to

    can view and

    use the

    move products in and out of the warehouse.

    Note

    The combination of the Warehouse Type and Owned By Group must be unique.

    On returning physical goods

    When a physical good is returned from a customer

    to one of your company's warehouses, is it based on the warehouse type and owned by group of the warehouses that the system will decide to

    , the system uses the combination of these two fields to determine which warehouse the good should be placed in.

    Refer to Inventory Definition for more information.

    Allow Negative Stock: Enable

    ,

    to allow

    removing

    the removal of non-traceable physical goods from a warehouse

    even if there is no stock available. This is not possible

    when the stock's quantity is not measurable.  

    E.g., if you have a non-traceable good in the system, such as milk, so that it can be added to an order of (traceable) coffee.

    Negative stock is not allowed when moving goods between warehouses.

    Balances

    The running

    stock

    balance of

    all physical goods which are

    stock kept in the

    specific

    warehouse.

    Click on the Quantity

    number

    of each product to view

    all

    the warehouse transactions that resulted in this balance.

    Click on the

    "

    Included In

    Bundles" number

    Bundles of each product to view the

    stock of this product across each bundle

    total quantity of the product that is included in bundles (as a component product).


    Related configuration areas

    The following modules are related to Inventory Management and to inventory management and may be configured for the Inventory Management module the inventory management module to operate at its full capacity.

    Manual LinkAreaDescription
    ProductsProducts

    Create the

    physical good

    products

    which

    that will be stocked in the warehouses or used to create

    Installed

    installed Items (

    instances of

    traceable physical goods).

     


    Back to top 

    Using Inventory Management

    Info

    Foundation > Inventory Management > Manage Warehouse Transactions

    Before we start explaining how you can manage your stock it is important to understand the The difference between traceable and nontraceable non-traceable physical goods is fundamental in stock management.

    Traceable physical goods are physical goods that can  can be traced through a unique identifier, which is usually a serial number. A usually a serial number.  In CRM.COM a traceable physical good (such as a modem with a serial number) is often referred to as an 'installed item in CRM.COM. For example, a modem with a unique serial number'. 

    Non-traceable physical goods are goods which are not traced to a single instance and are measured based on their quantity . For example, antennas. You care (such as antennas).  It is important to know how many antennas are left in your the warehouse but not the serial number of each and which specific antenna has been was sold to which a customer.

    Adding stock to a warehouse

    ...

    Once your warehouses are setup you are now ready to start adding stock to them. There are four ways by which stock can be added to a warehouse

    ...

    set up there are multiple ways to start adding stock:

    1. Create the installed items one by one and then use a 'stock Stock in warehouse transaction' to place the items in the warehouse . Can only be used for (traceable goods only).
    2. Create a stock 'Stock in warehouse transaction and ' and add multiple items to a specific warehouse (traceable and non-traceable goods to a specific warehouse).
    3. Create a 'stock Stock movement warehouse transaction and ' and move stock from one warehouse to another . Can be used for both (traceable and non-traceable goods).
    4. Remove an installed item that was previously rented or sold to a customer either because it is and then returned (no longer required by the subscription or because it was or swapped with a new item).  

    Removing stock from a warehouse

    ...

    Stock is removed from a warehouse because it is no longer usable, it is when sold or rented to customers, a customer or when moved to another warehouse or because it is no longer usable.

    1. Remove stock from a warehouse that is no longer functional (e.g., hardware that is outdated or broken) using a 'stock Stock out warehouse transaction' because it is no longer needed, such as outdated hardware or broken.
    2. Move stock from one warehouse to another using a 'stock Stock movement warehouse transaction'.
    3. Rent an installed item to a subscriber by adding it directly through subscriptions or through a jobor jobs
    4. Sell a (traceable or non-traceable) physical good to a customer through a jobSell a traceable or non-traceable physical good to a customer  or directly through a quick 'Quick sale'.

    Move stock between warehouses

    ...

    Stock can be easily moved between warehouses to assist in the logistics process. For example, you can have all stock imported to your , by using a 'Stock movement warehouse transaction'. You can import all stock to the main warehouse and then allot allocate goods to multiple warehouses. This is achieved by using a 'stock movement warehouse transaction'other warehouses from there.

    Back to top 

    Anchor
    installed
    installed
    Managing

    ...

    installed items

    ...

    Info

    Foundation > Inventory Management > Manage Installed Items

    Installed items are instances of traceable physical goods that can be traced through by their serial number. Installed items either belong to the business or to a customer (if purchased).  They can either be sold or rented to customers , either through subscriptions or jobs or sold through the 'quick sales' process.

    In order to create Several installed items in batch usecan be created in one flow by:

    • 'Managing Warehouse Transactions to create one or more installed items and move them to a Transactions' which also move the items to a specific warehouse.
    • 'Importing Installed Items via Utilities', a batch process used for importing to import multiple items from a file adds and add them to a specific Warehousewarehouse.
    Note

    Creating an installed item via from the installed item Installed Item Data Entry page does not place the item it in a warehouse. A Stock In Transaction must follow to transfer the Item to the correct Warehouse.

     

    ...

    A stock in transaction must be used for the transfer.

    Specify the criteria that match the item the installed item you are interested in , or click on NEW from the Actions Menu menu to create a new installed item. Proceed by providing Provide the mandatory information defined as defined in the table below, before you mandatory in the installed items table and SAVE.

    Image RemovedImage Added

    The table describes the sections of of the installed items Data Entry page , and explains how the fields in the page are used. Use  You can use the table filter to only view information available for all installed items or select a specific filteron the installed items you are interested it.

     Mandatory   Configurable

     
    Table filter
    columnAvailable for:
    Available for:
    Applies to Product
    id155239730964218ad608616a8dcc23844c3882dd7fd7b


    Provides information which is either by specific owned by a customer or is located . This information is calculated dynamically.

    Warranty Policy: A link to the applied warranty policy

    Warranty Expiration Date

    Warehouse Issue Date: The date the item was removed from a warehouseNagra Media Live Platform

    Displayed only if the

    is provisioned by Nagra Media Live

    The NUID of the associated Installed Item as specified in Installed Item Provisioning Parameters. The number of characters should not exceed 256.

    The Section is only available if the Product for the specific Item is provisioned by a Provider 'Allowed' Physical Good Products Provisioning Provider).
    View /wiki/spaces/WIP/pages/10008799 for more information.If parameters other than NUID are available, they can be added here added Installed Items via

    Applies to Product


    AllMain Information
    All

    Product*: The Product represented by the Installed Item. Only Physical Goods classified as Traceable : The installed item (only traceable physical goods can be selected).

    Serial Number*: The Serial Number of the Installed Item which uniquely identifies it: Unique identifier for the product.

    Alternative code*: The Alternative Code of the Installed Item.State: The state of the Installed Item

    The State of the item is updated through dedicated actions and can be 'Effective' (default) or 'Not Effective'. The state is set to 'Effective' by default; 'Non-Effective' Installed Items cannot be provided to customers.

    AllComponents
    All

    Physical Goods which goods that are grouped together to constitute Installed Item Bundles and are Installed Items themselves. They into one product also constitute installed items (bundle) and can be managed as such by the processes for individual standalone Installed Itemsitems.

    Info

    The Components Section section is available only if the Product that was specified in Main Information has where the Composition Method of the product is set to Bundle.


    All

    Ownership Information

    All Ownership status

    (Information generated by the system on the location of an installed item

    used

    on a

    subscription

    or stored in a warehouse

    )

    Ownership Status

    All

    Ownership Status: Determines whether the Installed Item is owned by Whether the company or customer owns the customerinstalled item, based depending on the business transactions that were applied on the Item. This Information is calculated dynamicallytransaction that was registered. The available values are the following:

    • Sold to Customer: The Installed Item was sold to the customer and is  (owned by the customer.)
    • Rented to Customer : The Installed Item was rented to the customer and is (owned by the company.)
    • Not in Warehouse: The Installed Item is  (not located in a 'Direct Sales', 'Rental' or 'Indirect Sales' Warehouse.any warehouse)
    • In Internal Warehouse: The Installed Item is  (located in a 'Direct Sales' or 'Rental' Warehouse.one of your company's warehouses)
    • In External Warehouse: The Installed Item is located in an 'Indirect Sales' Warehouse (located in a partner warehouse)
    • Owned by Customer (bought and owned by the customer).

    Ownership

    status

    Status:

    Sold to Customer

    Owner Account: The accounts receivable of the customer that bought the installed item.

    Delivered by  Job: The job (through which the installed item was sold)

    Sales Method: Information whether Whether the sale was sold took place through the company (Direct Sale) or through a partner (Indirect Sale).

    Invoice : Displays the invoice number of the sold physical good if its sales method is set to invoiced physical goods with a 'Direct Sale' and the item is already invoicedmethod.

    Stock Out Warehouse Transaction: The number of the transaction associated to the sold item.

    Performed Date: The date on which the job was registered and the item was sold (i.e. the creation date of the related job)

    Performed By: The user that who registered the job and sold the item (i.e. the user that created the related Job)

    Ownership statusStatus: Rented to Customer

    Used by Subscription : The number of the subscription using the installed item.

    Ownership statusStatus: In Internal Warehouse or
    In External Warehouse
    Located in Warehouse: The Warehouse that owns the Installed Item.Warehouse Owned By Group: Displays the Warehouse's Owned By Group if the Installed Item is located in a Warehouse.in Warehouse

    Warehouse Owned By Group

    AllChange History
    AllInstalled Items with Warranty

    Provides information Information on the changes that are applied on the following fields:modifications to the following fields including the user and date.

    • Serial Number
    • State
    • Location : moving from warehouse to (transfer between warehouse and subscription or job and vice versa)
    • Warranty : information (for items with warranty that have been removed from the customer

    The user that applied the change and the Date on which it took place are also logged and displayed.

    Installed Items with WarrantyWarranty Policy
    • removed from the customer).
    Installed Items with WarrantyWarranty Policy
    Installed Items with Warranty

    Warranty Policy 

    Warranty Expiration Date

    Warehouse Issue Date (on which the item was removed from the warehouse).

    Installed Items of product types with meter readingMeter Reading
    Installed Items of product types with meter reading

    Details of meter readings recorded for the installed item. The respective UDR and a total for all the readings are provided.

    Note

    Meter readings can only be added to an installed item through WEB API.


    Installed Item is provisioned by Nagra Media Live

    Nagra Media Live Platform Parameters

    Installed Item is provisioned by Nagra Media Live

    The Nagra Unique Identifier (NUID) of the item as specified in installed item provisioning parameters. Maximum number of characters: 256.

    Note

    Available if the product is specified as provisioned (i.e., defined in the allowed physical goods of the provider) by Nagra Media Live.

    Additional parameters can be added in this section.

    This information cannot be provided when creating items through Warehouse Transactions or /wiki/spaces/WIP/pages/10008286.


    Installed Item is provisioned by Nagra Media LiveNagraVision SMSgw Parameters

    • Paired Installed Item
    Note
    • NUID (Nagra Unique Identifier): This parameter is applicable only for items mapped as Cardless STBs.
    • VUA: A parameter provided by Nagra and applicable for items mapped as Cardless STBs (always read-only).
    Note

    Available if the product is specified as provisioned (i.e., defined in the

    allowed physical goods of the

    provider) by NagraVision SMSgw.

    This information cannot be

    provided when creating

    installed items through Warehouse Transactions or /wiki/spaces/WIP/pages/10008286.



    Installed Item is provisioned by VCAS OMI

    VCAS OMI Parameters

    Installed Item is provisioned by VCAS OMI

    DVB SMS Device ID : The SMS Device ID that is (used to identify the Installed Item item on the VCAS OMI DVB network.)

    Note

    This is applicable only Available if the Type of the Installed Item Product is included in theproduct is specified as provisioned (i.e., defined in the allowed physical goods of the provider) by VCAS OMI (DVB) Physical Goods mapping.

    This information cannot be added provided when creating Installed Items via installed items through Warehouse Transactions or /wiki/spaces/WIP/pages/10008286.

     


     

    Back to top 

    Anchor
    transactions
    transactions
    Managing

    ...

    warehouse transactions

    ...

    Info

    Foundation > Inventory Management > Manage Warehouse Transactions

    ...

    Use warehouse transactions to move stock from or to in and out of warehouses.

    Warehouse transactions can be manually created or they can be generated by the system, in case that the transaction is the result of a user's action, such as using are either created by the user or by the system following a user action (such as the 'Remove Installed Item' subscription action).

    There are three classifications types of warehouse transactions:

    • Stock In transaction will add stock to a warehouse
    • Stock Out will remove stock from a warehouse
    • A Stock Movement will move stock between warehouses

    Manual warehouse transactions can either be created through the respective Manage Warehouse Transactions Data Entry page or through Warehouse Data Entry page.

    ...

    • 'Stock in' adds stock
    • 'Stock out' removes stock
    • 'Stock movement' moves stock between warehouses.

    Warehouse transactions can be created by the user through the Manage Warehouse Transactions or the Warehouse Data Entry page.

    Image Added

    The table describes the sections of a Warehouse Transaction warehouse transaction Data Entry page , and explains how the fields in the page are used.

     Mandatory   Configurable

    Main Information

    Life

    Cycle State: The life cycle state of the transaction which denotes whether items are

    Cycle State indicates whether the items were successfully moved and the warehouse balance updated (Posted)

    ,

    or

    the movement is still pending (Draft).

    Click on SAVE to directly post a transaction or SAVE AS DRAFT to save without making actual changes to the stock balance, until goods are physically received and accounted for.

    For Stock In TransactionsFor Stock Out TransactionsFor Stock Movement Transactions
    Stock In Warehouse: The warehouse in which the goods will be moved to.Remove Stock from Warehouse: The warehouse from where goods will be removed.

    From Warehouse: The warehouse from where goods will be removed.

    To Warehouse: The Warehouse in which the stock will be moved.

    Batch Number: A reference number which is used

    whether the movement is still pending (Draft).

    Click on SAVE to post the transaction or SAVE AS DRAFT to save without affecting stock balance until goods are physically received and accounted for. 

    Warehouse that stock will be moved to or from.

    Batch Number: Used to keep track of multiple warehouse transactions made for the same batch.

    Supplier:

    Supplier

    A contact that provided the stock

    which should already be created as a contact information

    .

    Posted

    date: the date on which the transaction was posted

    date 

    Items to Stock In / Items to Stock Out / Items to Move

    A list of

    The physical goods that will be added, removed or

    moved

    transferred between warehouses.

    View the

    Refer to 'Adding

    Items

    items to warehouse transactions' for more information on

    how to add

    adding physical goods to a transaction through the Data Entry page.

    • Product: The physical good to be added.
    • Serial Number

    :  Only
    • (for traceable physical goods

    (as explained in
    • only, refer to 'Installed Items')

    .
    • Alternative Code
    : Only
    • (for traceable physical goods
    (as explained in
    • only, refer to 'Installed Items')
    .

    • Quantity
    : The quantity of the product
    • to be added to the stock
    . In case of
    • (always '1' for traceable physical goods
    the quantity is always 1
    • )
    • Unit
    Cost Amount: The cost of each good.Total Cost Amount: The total cost amount of the good, calculated using Unit cost and Quantity
    • Cost Amount
    • Total Cost Amount (Unit Cost * Quantity)
    • Components: The constituent products of bundle goods.

    Transaction Totals

    An aggregated quantity and total cost for each physical good included in the

    transactions

    transaction.

    If a product bundle is added

    then its

    the constituent components are counted as separate products.

    For example

    E.g., if an 'Installation Kit'

    product bundle

    is added, which

    is made up of

    has 2 Modems and 1 Decoder as components, then the

    following will be shown in the

    transaction totals will display:

    • 1 Installation Kit
    • 2 Modems
    • 1 Decoder

    Back to top 

    ...

    Posting a warehouse transaction

    ...

    You can create warehouse transactions Warehouse transactions can be created for received, removed or moved goods, but keep them open (Draft) until checked that all transferred goods and kept (open) in a 'Draft' state until all the goods have been physically accounted for. Not posting a warehouse transaction means that the goods will not be made

    Goods are always available to agents to use them yet (for stock out transactions but must be posted to be available for stock in and stock movement transactions) while they will still be available in the warehouse for using for stock-out transactions. In none of the three cases will the stock balance be amended. While the transaction is still draft you can make changes such as adding or removing goods from the transaction.
    Once all physical goods have been successfully acknowledged you can close (Post) the transactions to make the changes final and update the stock balance.

    To directly post the transaction use SAVE from the Actions menu when saving the transaction

    To create draft transactions use 'SAVE AS DRAFT'  from the Actions menu when saving the transaction

    To post the transaction once finalised, navigate to Manage Warehouse Transactions and go to the Data Entry page of the transaction you wish to post. From the Actions menu click on Actions > Post.. In either case, the stock balance remains unmodified.

    Goods can be added or removed from the transaction as long as it is in a 'Draft' state. Once all physical goods have been accounted for and the modifications finalized, the transaction can be closed (Posted) and the stock balance updated.

    Use SAVE from the Actions menu to post the transaction or SAVE AS DRAFT to keep it editable.

    To post the finalized transaction, go to Manage Warehouse Transactions, select the transaction and click Post from the Actions menu

    Anchor
    add_actions
    add_actions
    Adding items to a warehouse

    ...

    transaction

    ...

    Stock

    ...

    Out and

    ...

    stock Movement warehouse transactions

    Traceable installed items and non-traceable physical goods to can be selected and moved through the Manage Warehouse Transactions Data Entry page.

    Adding a single installed item (Traceable)

    ...

    item 

    1. In edit mode go to the Add Single Installed Item search box.Either run search box (in the Items to Stock out or Move section).

    2. Run quick search or open the search modal and search for the item to be moved.

    Adding multiple installed items (Traceable)items 

    1. Click on on the ADD MULTIPLE INSTALLED ITEMS link.

    2. Search for existing already installed items and select the ones to be included in the transaction , by checking the checkbox next to the installed item.

    3. Click on Click Select.

    Adding Physical Goods (Non-Traceable) physical goods 

    1. Go to to the Add Physical Goods section.

    2. Product Type: Select the product type of the product you want to include from the drop-down list.
    3. Product: Select the product from the drop-down listSelect the Product Type and the Product from the drop-down lists.
    4. Quantity: provide the number of Nonnon-Traceable traceable items to be be removed from the  the warehouse.

    Stock In Warehouse Transactions

    ...

    1.  

    Stock In warehouse transactions

    New traceable installed items and non-traceable physical goods or select from installed items that already exist in the systm but can be created - and installed items already present in the system that are not assigned to a specific warehouse can be selected and added - through the Manage Warehouse Transactions Data Entry page.

    Adding an existing installed item (Traceable)

    1. Enable Search for Existing Installed ItemIn the Installed Item search box, run .

    2. Run quick search or open the search modal and search for the item to be added in the Installed Item search box.

    3. The item is added in to the list of items below and you can provide unit cost can be provided.

    Adding non-traceable goods

    1. Product Type: Select the product type of the product you want to include from the drop-down list.
    2. Product: Select the product from Select the Product Type and the Product from the drop-down listlists.
    3. Quantity: provide the number of non-traceable items to be removed from the warehouse.
    4. Press Use Enter from the keyboard to add the items.
    5. The item is added in the list of items below and you can update the quantity and provide a unit cost

    Adding new installed items (Traceable)

    1. Product Type: Select the product type of the product you want to include from the drop-down list.Product: Select the product from the drop-down listlist and a quantity and unit cost can be provided.

    Adding new installed items 

    1. Select the Product Type and the Product from the drop-down lists.
    2. Serial Number: Provide the serial number unique identifier of the new item (alphanumeric)Press Enter from the keyboard to add.
    3. Use Enter to add the items.
    4. The item is added in to the list of items below and you can provide an and an alternative code and unit cost and unit cost can be provided. 
        
      If you don't provide an alternative code is not provided, then it is set equal to the serial number.

     


    Adding physical good bundles to a warehouse

    ...

    transaction

    ...

    Physical good bundles are goods products made up from of multiple components . When (traceable or non-traceable physical goods).  Additional information related to the components is required when adding a bundle to a warehouse transaction additional information related to the components is required. Components can either be traceable or non-traceable physical goods.
    Image RemovedImage Added

    Once the items are added in to the Items list (as explained see above) follow the steps below:

    ...

    click on COMPONENTS to view and set

    ...

    the

    ...

    applicable information. The following information is available:

    • Product: the component

    ...

    • set by the system, as defined in the product bundle components.
    • Serial Number: provide

    ...

    • the identifier for installed items components.
    • Alternative Code: provide an alternative code for installed items components

    ...

    • .  If none is set,

    ...

    • the

    ...

    • serial number is used. 
    • Quantity: 

    ...

    • Set as defined in the Product bundle settings if the product is non-traceable,

    ...

    • and to '1' if it is traceable

    ...

    • .
    • Unit Cost Amount
    • Total Cost Amount.

    Back to top 

    Anchor
    import
    import
    Importing installed items through the utility

    ...

    The fastest way to import stock in your into a warehouse is by using the 'Import Installed Items' utility which will add stock to your warehouses through external files, such as an excel and an external file. 

    Define settings applicable when importing installed items, installed item import settings in the utility definition. From the Actions menu click on Actions > Submit and proceed by selecting

    Click on Submit from the Actions menu and select the file with the installed items.

    The file must be prepared for import, and can have import in one of the following formats (templates can be used): 

    1. XML

    2. Excel
    3. CSV

    Templates can assist in the preparation of the file and ensure correct formatting.

    Image Removed

    Image Added

    The table describes the sections of Import Installed Items Transaction Data Entry page , and explains how the fields in the page are used.

     Mandatory   Configurable

    Input Settings
    Warehouse: The

    Warehouse in which the

    Installed Items

    installed items will be imported.

    Warehouse Transaction Life Cycle State: The

    life cycle

    state of the stock in warehouse transaction that will be created once the run is executed, which can be 'Posted' or 'Draft'.

    Note

    When a

    Run

    run is executed, a warehouse transaction is created and assigned the selected life cycle state. If the state is 'Draft', then the imported

    Installed Items are not available to

    items cannot be rented or sold.

    Supplier: The

    Contact Information

    contact information of the supplier that provided the stock.

    Installed Item Product:

    The Physical Good related to the items to be imported. Two options are available for selection:

    Select between USE SPECIFIC PRODUCT

    : A specific, traceable Physical Good must be defined.

    (traceable physical good) and USE PRODUCTS SPECIFIED IN IMPORT FILE

    : The Product specified in the import file will be used

    .

    Installed Item Category:

    The Category related to the items to be imported. Two options are available for selection:
  • USE SPECIFIC CATEGORY: A specific Category must be defined.
  • Select between USE SPECIFIC CATEGORY and USE CATEGORIES SPECIFIED IN IMPORT FILE

    : The Category specified in the import file will be used

    .

    Process Runs
    Displays the Runs that were executed for the specific definition. Each run includes the items that were processed. In the case of an error, its code and description
    is
    are displayed.

     


    Back to top 

    Anchor
    file
    file
    Preparing the import file

    1. Navigate to Import Installed Items and from the Definition

      's Data Entry page and click on ACTIONS > DOWNLOAD TEMPLATE. Chose between XMLExcelCSV to select 

      Data Entry page click on Actions > Download Template. 

      Note

      Download the template after you Save the definition and then click Submit.


    2. Select the type of template you wish to download (XMLExcel or CSV).
    3. The import file must be prepared according to the downloaded template. All three types of files include the fields defined in the table below:

      The code of the Category that will be related to the Installed Item.User Defined Field of type StringUser Defined Field of type Float

      NameDescription

      Type

      Serial Number

      The unique and mandatory Installed Item serial number.

       StringString

      Alternative Code 

      The unique and mandatory Installed Item alternative code.

       String

      String

      Unit Cost Amount

      The unit cost amount of the Installed Item.

      Number

      Product

      The alternative code of the Product that will be related to the Installed Item.

       String

      Category

      Number

      Product

      String

      Category

      String

      Notes

      Notes for each Installed Item.

      String

      Bundle Serial Number

      The `serial number of the Bundle Installed Item (for use if the Installed Item is created as a component to a Bundle Installed Item).

      String

      UDF String 1-8

      String

      UDF Float 1-4

      User Defined Field of type Float

      Number

      UDF Float 4

      Number

      UDF Date 1-4

      User Defined Field of type Date

      Date

      dd/mm/yyyyhhyyyy hh:mm


    Warning

    If a bundle good product is being imported, then the bundle installed item must be defined in the file before their its components.

    ...


    Import File Templates

    Anchor
    EXCEL
    EXCEL
    Excel

    The Excel file contains one column for each field that can be imported. The , with the headers in the first row includes the headers. An Excel template is provided during the import process
    Image Removed.  
    Image Added

    Anchor
    CSV
    CSV
    CSV

    The CSV file contains one column for each field that can be imported. The , with the headers in the first row includes the headers. A CSV  template is provided through the import process.
    Image Removed

    Image Added

    Anchor
    XML
    XML
    XML

    ...

    Traceable and non-traceable physical goods are imported into warehouses from where they can then be sold or rented to customers. 

    A clear view of the The stock balance of each product is available through a dedicated Stock Balance Summary page. From this the stock balance Summary page, from which the user can search for products by using products, product types or product families as filters. The displayed results provide display the collective sum of the product(s) from all Warehouses across warehouses as well as detailed information of on the Stock Balance stock balance in each Warehousewarehouse.

    Note
    In case the Product also belongs to a Product Bundle, the Balance of the Products includes the ones included in bundles and an additional balane is provided for items that are included in bundles

     

    ...

    If the product is offered as stand-alone and in a bundle, a total balance, and a balance for items included in bundles, is displayed.


    Applying business flows on inventory management


    Selling and renting physical goods

    ...

    Physical goods can be sold or rented to customers.

    Sold physical goods can belong in one of two classifications


    • Direct Sale : purchased by your company in which case CRM.COM will also bill the item
    • Indirect Sale: purchased through a partner, in which case the item won't be billed but simply added and used

    You can sell a good either by adding it to a billable job (direct or indirect sale) or by using 'quick sale' process (direct sale) from the accounts receivable

    Physical Goods can also be rented through subscriptions. In this case, the customers don't get billed for the item, which is returned once the subscription comes to an end. Warehouses from where such physical goods are taken are classified as:

    • Rental
    Different warehouses are used to extract the goods resulting from sales made directly or indirectly or rented and these are distinguished by their classification as defined in the inventory definitionsSelling goods through the company

    Goods are sold directly to the customer (not through a partner) by using:

    Goods sold directly to the customer are invoiced by CRM.COM and the account of the customer is debited.

    Selling goods through a partner 

    Selling goods through partners

    Goods are sold to the customer through a partner by using:

    Goods sold through partners are not invoiced by CRM.COM.

    Renting installed items to customers

    Installed items are rented to the customer through Subscriptions. (Free of charge by default)

    Rented goods are not invoiced by CRM.COM as the goods are returned to the company when a subscription is canceled.

    Back to top 

    Inventory Management Analytics

    Printouts

    ...

    A Printout displays all the information contained in a . It is Printouts are available through the Data Entry page in one of the following formats: HTML, XLS, CSV, RTF , PDFor PDF.  Refer to to Printouts for information on how they can be created, printed and sent.

    Warranty Policy Printout

    ...

    Printout 

    A warranty policy printout displays detailed information of on an installed item's warranty policy coverage in terms of duration and coverage reasoning.  The printout is available through Installed Items data entry Data Entry page and unlike other printouts, it is not available for sending by email.

    Image Removed

     Image Added


    Back to top 

    Inventory Management Business Examples

    Warehouse setup

    Panel
    nameblue
    titleCompany ZX warehouse setup

    Scenario

    Company ZX wants to set up different warehouses from where goods will be sold rented and returned to. Warehouses should be categorised based on the following:

    • Warehouses for goods sold directly from Company ZX.
    • Warehouses for goods sold by Company ZX partners.
    • Warehouses for goods rented to Subscribers.
    • Warehouses for goods that were sold directly from Company ZX and are returned once replaced through Warranty Policies.
    • Warehouses for goods that were sold by partners of Company ZX and are returned once replaced through Warranty Policies.
    • Goods rented to Subscribers, returned to Company ZX once the customer cancels their Subscription.

    Internal Sales Branch (Sales Branch 1) and Partner ZX (Partner 1) are two departments responsible for handling Physical Goods. Goods should be extracted from their original location and returned to the actual warehouse from where the came. Note that both Sales Branch 1 and Partner 1 can handle all Types of sales:

    • Direct
    • Indirect
    • Rentals
      For example, a new Subscriber registered from Partner 1 may select to rent or buy the Physical Good from Company ZX.

     

    CRM.COM Solution

  • Create the following Warehouse Types (refer to the instructions on Configuring Warehouse Types):
    1. Direct Sales WT
    2. Indirect Sales WT
    3. Rentals WT
    4. Returns of Direct Sales WT
    5. Returns of Indirect Sales WT
    6. Returns of Rentals WT
  • Set up the Inventory Management Definitions as follows (refer to the instructions on creating Inventory Management Definitions):

    For AddingFor Adding During ReplacementFor RemovingFor Removing During Replacement
    Warehouse TypeClassificationWarehouse TypeClassificationWarehouse TypeClassificationWarehouse TypeClassification

    Direct Sales WT

    Direct SalesDirect Sales WTDirect Sales

    Returns of Direct Sales WT

    Direct SalesReturns of Direct Sales WTDirect Sales

    Indirect Sales WT

    Indirect SalesIndirect Sales WTIndirect Sales

    Returns of Indirect Sales WT

    Indirect SalesReturns of Indirect Sales WTIndirect Sales

    Rentals WT

    RentalsRentals WTRentals

    Returns of Rentals WT

    RentalsReturns of Rentals WTRentals

     

     
  • Create one Warehouse per Warehouse Type owned by Sales Branch 1:
  • Direct Sales WT: Sales Branch 1 Direct Sales
  • Indirect Sales WT: Sales Branch 1 Indirect Sales
  • Rentals WT: Sales Branch 1 Rentals
  • Returns of Direct Sales WT: Sales Branch 1 Returns of Direct Sales
  • Returns of Indirect Sales WT: Sales Branch 1 Returns of Indirect Sales
  • Returns of Rentals WT: Sales Branch 1 Returns of Rentals
  • Create one Warehouse per Warehouse Type owned by Partner 1:
    1. Direct Sales WT: Partner 1 Direct Sales
    2. Indirect Sales WT: Partner 1 Indirect Sales
    3. Rentals WT: Partner 1 Rentals
    4. Returns of Direct Sales WT: Partner 1 Returns of Direct Sales
    5. Returns of Indirect Sales WT: Partner 1 Returns of Indirect Sales
    6. Returns of Rentals WT: Partner 1 Returns of Rentals
  •  

    Setting up warehouses 

    Panel
    namegreen
    id3

    Scenario 1

    Company ZX warehouse is used to control the location and quantity of all physical goods related to ZX subscriptions such as TV boxes, routers, and remote controls. Different warehouses are used for hardware sold by ZX partners.

    All hardware is initially imported into ZX's Main Warehouse and distributed to other warehouses from there.


    Warehouse Types

    Configure warehouse types as explained in the table below

    NameInformation
    Sales WTWarehouses that belong to Company ZX or partners and from where installed items will be sold. (Items from partner warehouses are not billed from CRM.COM).
    Rentals WTWarehouses that belong to Company ZX and from where installed items will be rented (not billed).

    Returns of Sales WT

    Warehouses that belong to Company ZX or partners and where installed items that were sold and are being replaced for free (through Warranties) will be returned.

    Returns of Rentals WT

    Warehouses that belong to Company ZX and where rented installed items will be returned.


    Inventory Management Definitions

    Configure the inventory management business definition as explained in the table below.

    For AddingFor Adding During ReplacementFor RemovingFor Removing during Replacement
    Warehouse TypeClassificationWarehouse TypeClassificationWarehouse TypeClassificationWarehouse TypeClassification

    Sales WT

    SalesSales WTSales

    Returns of Sales WT

    SalesReturns of Sales WTSales

    Rentals WT

    RentalsRentals WTRentals

    Returns of Rentals WT

    RentalsReturns of Rentals WTRentals


    Warehouses

    Create warehouses as explained in the table below, providing the respective group and warehouse type for each.

    Warehouse NameWarehouse TypeGroup (Sales Branch or Partner)
    SalesSales WTSales (Company ZX)
    Partner SalesSales WTSales Partner
    RentalsRentals WTSales (Company ZX)
    SBA Direct Sales ReturnsReturns of Sales WTSales (Company ZX)
    PBA Indirect Sales ReturnsReturns of Sales WTSales Partner
    SBA Rentals ReturnsReturns of Rentals WTSales (Company ZX)


    Configuration

    1. Create the following Products, classified as traceable physical goods:
      1. TV Boxes
      2. Routers
    2. Create the following Products, classified as non-traceable physical goods:
      1. Remote control


    Import installed items

    Create a new import for the installed items.

    1. In the import installed items definition provide the following information:
      1. Warehouse: Sales
      2. Warehouse transaction life cycle state: 'Posted'
      3. Installed item product: Use products specified in the import file (Check that the import file has the correct product codes).
      4. Schedule to 'Run Now' / run immediately.
    2. Save the definition and click Submit from the Actions menu.
      1. Create a file by downloading the import template and updating it and 'Add' it in the modal window.
    3. Once the import is complete all the items will be available in the Sales Warehouse.


    Create transaction to create Remote Controls

    Create a stock in warehouse transaction to 'create' the remote controls (non-traceable physical goods can only be 'created' through stock in warehouse transactions)

    1. Navigate to Direct Sales Warehouse and from the Actions menu select 'New Stock in transaction'
    2. Select Product Type 'Non-traceable physical good' and Product 'Company ZX Remote Control'.
    3. Input '10' as the Quantity and press 'Enter'.
    4. Save the transaction.


    Distribute boxes routers and remote controls to partner warehouse

    Create a stock movement warehouse transaction to move physical goods from the Company ZX warehouse to the partner's warehouse.

    1. Navigate to Direct Sales Warehouse and from the Actions menu select 'New Stock Movement Transaction'
    2. Define the 'To Warehouse' as 'Partner Sales'.
    3. Select Product Type 'Non-traceable physical good' and Product 'Company ZX Remote Control'.
    4. Input '10' as the Quantity and press 'Enter'.
    5. Click on 'Add Multiple Installed Items' and search for the items that were just imported.
    6. Select 3 boxes and 3 routers from the modal.
    7. Save the transaction.



    Creating installed items

    Panel
    nameblue
    id0
    titleSet up and create installed items

    Scenario 2

    Company ZX wants to set up Smartcards smartcards and Decoders as Traceable Physical Goods (Installed Items) so as decoders as traceable physical goods (installed items) in order to track them with a unique identifier, and cables and Remote Controls remote controls as Non-Traceable Physical Goods so as non-traceable physical goods, to only track their quantity. They need to be able to manually create single installed items, in order to correct errors that may be caused by batch importimporting all items together in one flow.


    CRM.COM Solution

    Configuration

    1. Create the following Products classified as Traceable Physical Goods traceable physical goods:
      1. Smartcards
      2. Decoders
    2. Create the following Products classified as Non-Traceable Physical Goodsnon-traceable physical goods:
      1. Cable
      2. Remote control

    User actions

    1. Create an Installed Iteminstalled item:
      1. Navigate to the Manage Installed Items page and create new installed items for smartcards and decoders by specifying their serial numbers.
    2. Move the items to a warehouse:
      1. Once the items are created, navigate go to Manage Warehouse Transactions.
      2. Create a new 'stock in' warehouse transaction.
        1. Select the warehouse they the items should be moved atto.
        2. Search for the installed items created in step Step 1.
        3. Save the transaction
    Use Stock In Transactions
        1. .


    Using stock in transactions to import new

    Cards

    cards and

    Boxes

    boxes in the

    System

    system

    Panel
    nameblue
    id0
    titleStock in Warehouse Transactions

    Scenario 3

    Company ZX wants to add in the system a new batch of smartcards and Set Top Boxes which set-top boxes that it received, into the system. They don't want to import them as there are only a few units and the agent must check each one individually as it is passed in the System (Alternatively, a Barcode entered. A barcode scanner could also be used to obtain the Serial Number)serial number.


    Solution

    1. Navigate to Manage Warehouse Transactions.
    2. Click on NEW > STOCK - IN TRANSACTION.
      1. Provide Enter the warehouse where the items should be placed.
      2. Provide the product type and the product.
      3. Provide the serial number of each card and Setset-Top Box (Barcode top box (a barcode scanner can be used here).
      4. Save the warehouse transaction. 
    3. Navigate to the Stock Balance screen and confirm that the Balance for balance of each Product product in the Warehouse warehouse has been updated accordingly.
    Movement of Items between Warehouses


    Moving items between warehouses

    Panel
    nameblue
    id0
    titleStock Movement Warehouse Transaction

    Scenario 4

    Company ZX imports all new Physical Goods physical goods into a Central Warehouse central warehouse for an initial stock-taking stocktaking and then distributes them to the other Warehouseswarehouses.

     



    Solution

    Use 'stock in' warehouse transactions (preferably for Nonnon-Traceable traceable physical goods) and the 'import installed items utility' (for traceable physical goods) to import all goods in the central warehouse. Use 'stock movement' warehouse transactions to move distribute the goods to the correct warehouseother warehouses.

      1. Import all
    Installed Items into Temp Warehouse using the Import Utility
      1. installed items into the temporary warehouse using the import utility.
      2. Import all
    Non-Traceable Physical Goods into Temp Warehouse using a Stock- In Warehouse Transaction
      1. non-traceable physical goods into the temporary warehouse using a stock in warehouse transaction.
      2. Navigate to
    Temp Warehouse
      1. the temporary warehouse.
      2. Click on ACTIONS > NEW STOCK MOVEMENT TRANSACTION.
        1. Specify the target warehouse that goods will be moved to.
        2. Specify the product type and the product
     of
        1. of the installed items that are being moved.
        Either type
              1. Type or scan the installed items.
            1. Specify the product type and the product of the non-traceable physical goods that are being moved.
              1. Specify the quantity of the non-traceable physical goods.
            2. Save the warehouse transaction.
          1. Check the stock balance to ensure that the correct traceable physical goods and quantities of non-traceable physical goods have been moved.


      Note
      titleNotes
      1. If you are using a previous release, view CRM.COM Release
      Changes
      1. Changes.
      2. Use the
      Inventory Management WEB
      1. API to create and manage
      Inventory Management
      1. inventory from an external system, such as a customer portal.
       View
      1.   Refer to Warehouses
      ,
      1. and Warehouse Transactions
      , and Warehouses
      1. WEB API for a
      complete
      1. comprehensive list of available actions
      available through the WEB API
      1. .

       


      Back to top 

      Glossary  Glossary  

      CRM.COM TermDefinition
      Accounts ReceivableA ledger of the financial transactions carried out between a company and its customers, such as invoices and payments.  The accounts receivable keeps a running balance of debits and credits and displays the amount a company is owed in exchange for goods supplied and services rendered.
      JobA small project initiated by the operator for customers, involving the delivery and billing of services, products, and activities. Customer requests and orders, such as that for a new subscription, can be initiated and registered through a job.
      Product bundleA combination of component products offered for sale as one product. Flexible product bundles have a variable selection of constituent products as components. Fixed product bundles have a fixed selection. 
      SubscriptionA selection of customer services billed on a recurring, usage or one-time basis.

       



       

      Panel
      namegrey
      id1

      Related Links

      Filter by label (Content by label)
      showLabelsfalse
      spacesV4Manualcom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@2d58f004
      showSpacefalse
      cqllabel = "global" and space = "V4Manual"
      labelsglobal

       


      Back to top