Versions Compared

Key

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

Overview

Excerpt

Aging is the determined period of time that starts once a product is received in an inventory. For pricing, this is of utmost importance due to the fact that as products age, the lower price they will have. Komet allows keeping track of it from several screens.

How the Aging is Calculate?

Once an arrival date is assigned to an in-transit product, their aging will start running.

Ui text box
sizemedium

Current Date - Arrival Date

For instance, if the current date is January 28th but the arrival date was previously set for January 25th (a date in the past), the age of that specific product would be three (3). 

On

Anchor
topofpage
topofpage

Excerpt

In this article, you will learn how Aging works and how to set the Arrival Date for a product.

Tip

User Roles: Admin, Inventory, Procurement Manager, Procurement User and Sales Manager.

Table of Contents

Table of Contents
minLevel1
maxLevel3
outlinefalse
excludeTable of Contents
typelist
printablefalse

Arrival Date

Knowing the arrival date of a product is crucial because it helps us accurately calculate its age. The arrival date of a product refers to the day it is expected to enter the inventory.

For example, let's take a look at the following tables:

Today

Arrival date product

Aging (In days)

January 18

January 15 (a date in the past)

3 days

If the current date is January 18, and the arrival date you had set for the product is January 15 (it arrived a few days ago), its age would be three days since that's the difference between the two dates.

Today

Arrival date product

Aging (In days)

January 18

January 22 (a date in the future)

-4 days

But on the other hand, if the current date is

February 1st

January 28, and the arrival date

of a given product was set for February 5th (a date in the future

you set is February 5 (it still needs to arrive), the age of that

specific

product would be

minus

negative four (-4)

.

Color Indicators

The system colors the product lines, based on their aging. This is visible from the Inventory Summary>>Inventory in boxes screen.

Aging ValueMeaningColor Indicator0The product arrived today. The arrival date of the product is equal to today's date No color<0The product has not arrived yet. As a result, products will have negative aging.No color>0<5The product has an aging value between 1 and 4 days.Yellow>4<10The product has an aging value between 5 and 9 days. Green>10The product has an aging value of 10 days - onwards. Red

How to Set the Arrival Date

  • The arrival date can be set from the Staging Area. For more information read Setting the Arrival Date in the Staging Area.
  • In multilocation companies,  the system allows setting

    days since aging or deterioration starts counting from the moment of arrival.

    Info

    Once an arrival date is assigned to an in-transit product, their aging will start running.

    Image Added

    Back to top


    Different options to set up the Arrival date

    The system allows you to specify the arrival date of your products from different locations:

    • Set the arrival date from the Staging Area. To learn more, read https://kometsales.atlassian.net/wiki/spaces/KB/pages/3341586/Set+the+Arrival+Date+from+the+Staging+Area.

    • Set the arrival date of hard goods in the Inventory summary.
      Go to Inventory > Inventory Summary > Manage hard goods inventory > select the Edit option from the Actions column for the specific product line.

    • In multilocation companies, the system allows you to set a different arrival date per location (even if they are associated with the same AWB).

    Remember authorized
    • Authorized users can

    also
    • set the arrival date from

    the
    • the AWB Summary.

    For
    • To learn more

    information, please read the section Establishing and Changing in Tracking AWBs
    • .

    To set
    • Set the arrival date of hard goods

    , go to Inventory>>Inventory Summary>>Hard goods inventory. Click
    • .
      Go to Inventory > Inventory Summary > Manage hard goods inventory > click on Receive Purchase Order (or click on

    edit
    • Edit for a given product line).
      You will be able to set the arrival date of the Purchase Order where the hard

    good belongs
    • goods belong.

            Image Removed

    Aging for Inventory in Units and Hard Goods

    Currently, keeping track of the respective aging for Inventory in Units is not permitted by the system. Although, the system does allow to visualize the arrival date for the hard goods inventory.

    Maximum Aging for Inventory Products

    By default, the maximum aging of the products displayed in the inventory screen is 180. Therefore, products with greater aging will be hidden. This value can be changed from the product setup screen. For further information about this option, reaHow to Set Up a Max Age for Inventory Products.

    Aging from sales screens

    The aging is not always visible for salespeople, this could be hidden through the Inventory Options>>Hide Sensitive Data. Additional to this, there is a setting per user that allows restricting the visualization of the aging from the sales screens. The setting is named Hide Sensitive Data on Sales Screens

    Aging

    Aging implies that when you receive a product in inventory, it begins to deteriorate, causing its price to decrease over time.

    Komet enables you to track product aging across multiple screens.

    Color Indicators

    The system colors product lines based on their age. You can view these in the following options within the Inventory tab:

    • Inventory Summary section > Inventory in boxes

    • Inventory Summary section > Inventory in units (When the arrival date and unit age settings are enabled).

    Info

    Only admin users can enable the setting named Show arrival date and aging that will allow users to see it from the Inventory in Units.

    |Aging Value

    Meaning

    Color Indicator

    Negative number of days

    The product has not arrived yet.

    No color

    0 days

    The product arrived today. The arrival date of the product is equal to today's date.

    No color

    Between 1 and 4 days.

    Product aging value from its arrival date.

    Yellow

    Between 5 and 9 days.

    Product aging value from its arrival date.

    Green

    10 days or more.

    Product aging value from its arrival date.

    Red

    Back to top


    Maximum Aging

    The system has the maximum aging set by default in the Inventory Products and in the E-commerce as follows:

    • Products displayed in the Inventory tab have a maximum aging of 180; therefore, the system hides products with greater aging.
      You can change this value from the product setup screen. To learn more, read Set the Max Age for Products in your Inventory.

    • E-commerce displays products with a maximum aging of 30. Nevertheless, companies can set different maximum age restrictions per product, category, customer, or company. To learn more, read How to Set Up the Max Age for the E-commerce Products.

    Back to top


    Additional Aging information

    Aging from the Sales screen

    Some viewing restrictions may stop displaying the product's Aging on the sales screen. To fix this, you must adjust the user-specific setting named Hide Sensitive Data in Inventory Options. To learn more, read Hide Sensitive Data on Sales Screen.

    Automatic Sell Fast Option

    There is a setting that allows to mark items with a lightning bolt icon, so the sales team is aware that those items need to be sold as soon as possible.

    For further information about this, please read Enabling Panel
    titleRelated Articles

    Max Age for E-commerce Products

    By default, the maximum age to display products in E-commerce, is 30. However, companies can set up a different maximum age restriction per product, category, customer, or even per company. For further information about this, please read How to Set Up the Max Age for the E-commerce Products.

    Image AddedImage Added

    Back to top


    Filter by label (Content by label)
    showLabelsfalse
    showSpace
    max
    false
    5
    sort
    title
    title
    Related Articles
    cqllabel in (
    "staging-area",
    "aging" , "arrival-date-staging-area" , "arrival-date-
    staging
    per-
    area
    location" )
    labelsstaging-area
    We've encountered an issue exporting this macro. Please try exporting this page again later.