Versions Compared

Key

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

Anchortoptop

Excerpt
hiddentrue

Learn to work with Inventory Management

...

nameblue

Anchor
top
top

Excerpt
hiddentrue

Learn to work with Inventory Management

Panel
nameblue
id0

On this page

Table of Contents
maxLevel2

...

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

Major features

...

 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 warehousesDistinguish warehouses at the same time.
  • Handle the sale of goods.
  • Keep a balance of goods in each warehouse.
  • Identify individual traceable physical goods (aka installed items) through unique  through a serial 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
  • 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 , another when selling physical goods from a partner's point of sale or when renting physical and another (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 ; 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 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.

...

Price Plans: Price
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 SalesSpecify 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 each warehouse type specify its classification: Rented, Direct Sales, Indirect Sales.

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

For Removing

Determines 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.

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

A default warehouse type must be set Specify the classification ('Rented', 'Sales') of each warehouse type and define a default 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.
  • 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

    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' action)

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

    A default warehouse type must be set .

    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 Plans

    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 Receivableaccounts 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 Select Applicable Account Receivable Classifications for each selected price plan you can select the accounts receivable classification for which the price plan will be applied for.

     

    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   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(can be changed). Only users that have 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 Quantitynumber of each product to view all the warehouse transactions that resulted in this balance.

    Click on the "Included In Bundles" number  of each product to view the stock of this product across each bundletotal 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

    ...

    > Manage Warehouse Transactions

    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   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 set up there are multiple ways to start adding stock to them. There are four ways by which stock can be added to a warehouse

    ...

    :

      which can be used Create installed items (one by one)
    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 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

    Available for:
    Table filter
    columnAvailable for:
    Applies to Product
    id155239730964218ad608616a8dcc23844c3882dd7fd7b
    Provides information which is either by specific owned by a customer or is located . This information is calculated dynamically. VCAS OMIVCAS OMI is provisioned by VCAS OMI

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

    This is applicable only if the Type of the Installed Item Product is included in the VCAS OMI (DVB) Physical Goods mapping 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.

    AllChange History
    All

    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
    • )
    • Warranty (for items removed from the customer).
    Installed Items with WarrantyWarranty Policy
    Installed Items with Warranty

    Warranty Policy: A link to the applied warranty policy

    Warranty Expiration Date

    Warehouse Issue Date: The date the item was removed from a warehouse 

    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 associated Installed Item item as specified in Installed Item Provisioning Parameters. The installed item provisioning parameters. Maximum number of characters should not exceed : 256.

    Note

    The Section is only available Available if the Product for the specific Item is provisioned by a Provider product is specified as provisioned (i.e., defined in the 'Allowed' Physical Good Products of the Provisioning Provider).
    View /wiki/spaces/WIP/pages/10008799 for more information.If parameters other than NUID are available, they can be added hereallowed physical goods of the provider) by Nagra Media Live.

    Additional parameters can be added in this section.

    This information cannot be added provided when creating Installed Items via 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.

     

     

    Back to top 

    ...

    Info

    Foundation > Inventory Management > Manage Warehouse Transactions

    Use warehouse transactions to move stock from or to 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 the 'Remove Installed Item' subscription action.

    There are three classifications 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.

    Image Removed

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

    ...

    Life Cycle State: The life cycle state of the transaction which denotes whether items are 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.

    ...

    Installed Item is provisioned by VCAS OMI

    VCAS OMI Parameters

    Installed Item is provisioned by VCAS OMI

    DVB SMS Device ID (used to identify the item on the VCAS OMI DVB network)

    Note

    Available if the product is specified as provisioned (i.e., defined in the allowed physical goods of the provider) by VCAS OMI (DVB).

    This information cannot be provided when creating 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 in and out of warehouses.

    Warehouse transactions 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 types of warehouse transactions:

    • '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 Data Entry page and explains how the fields in the page are used.

     Mandatory   Configurable

    A list of moved View the Items how to add
    Main Information

    Life Cycle State indicates whether the items were successfully moved and the warehouse balance updated (Posted) or 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 that provided the stock which should already be created as a contact informationA contact that provided the stock.

    Posted date: the date on which the transaction was posted 

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

    The physical goods that will be added, removed or

    transferred between warehouses.

    Refer to 'Adding

    items to warehouse transactions' for more information on

    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 1Unit Cost Amount: The cost of each good.)
    • Unit Cost Amount
    • Total Cost Amount : The total cost amount of the good, calculated using Unit cost and Quantity(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 transactionstransaction.

    If a product bundle is added then its the constituent components are counted as separate products. For exampleE.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 Single Installed Item 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 Select the Product Type and the Product from the drop-down listlists.
    4. Quantity: provide the number of Nonnon-Traceable traceable items to be be removed from the  the warehouse. 

    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 the drop-down listSelect the Product Type and the Product from the drop-down lists.
    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.
    2. Product: Select the product from the drop-down listis added to the list 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 RemovedImage 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:

      User Defined Field of type StringUser Defined Field of type FloatUser Defined Field of type Date

      NameDescription

      Type

      Serial Number

      The unique and mandatory Installed Item serial number.

       String

      Alternative Code 

      The unique and mandatory Installed Item alternative code.

       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

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

      String

      Notes

      Notes for each Installed Item.String

      Alternative Code 

      String

      Unit Cost Amount

      Number

      Product

      String

      Category

      String

      Notes

      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

      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

    ...

    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

    ...

    .

    ...

    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

    ...


    Selling 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

     

    Back to top 

    Inventory Management Business Examples

    Warehouse setup

    ...

    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

    ...

    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

     

    ...

    it is not available for sending by email.

    Image Added

     

    Back to top 

    Inventory Management Business Examples

    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.
      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
      labelsglobal
      cqllabel = "global" and space = "V4Manual"

       

      Back to top