{"id":115,"date":"2019-07-14T05:03:27","date_gmt":"2019-07-14T05:03:27","guid":{"rendered":"http:\/\/support.unicommerce.com\/?p=1"},"modified":"2022-11-17T23:04:51","modified_gmt":"2022-11-17T17:34:51","slug":"implement-fifo-in-your-system","status":"publish","type":"ht_kb","link":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/","title":{"rendered":"Implement FIFO In Your System"},"content":{"rendered":"

FIFO<\/strong><\/p>\n

The First-In, First-Out (FIFO) method of inventory valuation is a cost flow assumption that the first goods purchased are also the first goods sold. In most companies, this assumption closely matches the actual flow of goods, and so is considered the most theoretically correct inventory valuation method.<\/p>\n

To begin with this Feature, you need to define few parameters (like Shelf life, Expirable, Threshold) in your system while some system configurations will be done by internal teams* themselves:<\/p>\n

*Changes to be done internally:<\/p>\n

Configure Item-level traceability for client and in General settings keep Allow multiple ageing dates on a single shelf as NO.<\/p>\n

Please note: If you mark a product \u201cExpirable\u201d, you have to mandatorily mention its \u201cShelf Life\u201d<\/p>\n

Shelf Life:<\/strong> It is the total time for which an item is consumable or saleable. It is defined in the number of days.<\/p>\n

Threshold<\/strong>: The remaining life of a product is calculated with the help of the threshold (which is given in percentage) as defined while creating the product subcategory.<\/p>\n

<\/p>\n

<\/p>\n

<\/p>\n

 <\/p>\n

While inward an expirable product during GRN, you have to mandatorily record its \u201cManufacturing Date\u201d<\/p>\n

<\/p>\n

On the basis of Manufacturing date the system will calculate its remaining shelf life and if it is below the defined threshold or freshness, then the system prompts the user and moves the item to QC Rejected state. (How to set the threshold or Freshness is discussed in the next article.)<\/p>\n

When is the Freshness of an Expirable product checked?<\/p>\n

There are many events when the Product freshness is validated and the system takes required actions. These are while receiving the goods against a PO, Invoicing the goods of an order and while receiving the Returned Items.<\/p>\n

Before going there let us understand that with the help of an example. Say, while in-warding an item on 2 Oct 2017, the system asks for its Manufacturing date and the date 30Sept 2017 is given. The system then checks the freshness percentage or threshold at GRN, say it is 80%, which means it is allowed to be received in first 80 days. The system will allow receiving and placing it at the warehouse. If the threshold at Invoice is set to 50% and the product is packed and invoiced on 15 Dec 2017, the system checks and finds that the item was \u201cAbout to expire\u201d on 19 Nov 2017 and the date it expires is on 10 Jan 2017. Thus it will reject the item to be billed or invoiced on 15 Nov 2017. Similar process will be followed at the time of receiving returns. On the date of 10 Jan 2017 the item will be marked \u201cExpired.\u201d<\/p>\n

The Freshness Percentage or threshold for any product can be set at its Sub-category level.<\/p>\n

On the Path Products > Categories, click any category name.<\/p>\n

<\/p>\n

<\/p>\n

\n

 <\/p>\n

Let us focus each event separately now:<\/strong><\/p>\n

1. At GRN While in-warding a product item, if the product is found to be Expired\/About to expire, the system will prompt you and move it to QC Rejected state.<\/p>\n

2. At Invoice If the Order contains one item which is Expired\/About to Expire, then<\/p>\n

\u2022 The Item status is marked as \u201cBad-Expired\u201d or \u201cBad-About to Expire\u201d.<\/p>\n

\u2022 The Product Inventory type is marked to Bad.<\/p>\n

\u2022 The Sale Order item returns to \u201cCreated\u201d state and is open for re-allocation of inventory. This item can now be included in a fresh pick list.<\/p>\n

The Inventory count of bad inventory increases by 1, while the Blocked Inventory count decreases by 1<\/p>\n

If the Order contains more than one items, and only one of the items is found to be Expired\/About to Expire, then<\/p>\n

\u2022 Split the order for expired\/About to Expire product items and good items.<\/p>\n

\u2022 The same process for a single Expired\/About to Expire item as explained above will be followed.<\/p>\n

3. At receiving Returns While receiving the Returned items, the system will check the item shelf life, and if it is found to be Expired\/ About to Expire, then<\/p>\n

\u00a0\u2022 The Item status is marked \u201cExpired\u201d or \u201cAbout to Expire\u201d<\/p>\n

\u2022 The item inventory type and Inventory Status is set to \u201cBad\u201d.<\/p>\n

\u2022 The count of Bad inventory is increased by 1.<\/p>\n

Auto- Ageing Mode<\/p>\n

The Expired\/About to Expire Items must be made non-saleable. Apart from the events discussed in this document, there can be items which are lying in the warehouse, under \u201cGood inventory\u201d while their shelf life has been completed, in other words, the shelf life\/ freshness percentage is below the defined value. The system will check all such items on a recurrent basis every 24-hours. All such items will be marked as Bad-Expired or Bad- About to Expire. (Expired means that the shelf life of the item has been exhausted. About to Expire means that the Shelf life of the item is remaining but the Freshness threshold has been reached.)<\/p>\n

The specifics are:<\/p>\n

\u2022 All the items whose Life at Invoice or Freshness threshold at Invoicing is completed will be marked Bad-About to Expire.<\/p>\n

\u2022 Those items whose shelf life has exhausted will be marked Bad-Expired.<\/p>\n

\u2022 The inventory type for all the Expired or To be Expired items is marked as \u201cBad\u201d<\/p>\n

\u2022 For all the items which are set \u201cBad – About to Expire\u201d an RTV (Return To Vendor) has to be initiated.<\/p>\n

\u2022 The Bad-Expired items are the own warehouses\u2019 liability.<\/p>\n","protected":false},"excerpt":{"rendered":"

FIFO The First-In, First-Out (FIFO) method of inventory valuation is a cost flow assumption that the first goods purchased are also the first goods sold. In most companies, this assumption closely matches the actual flow of goods, and so is considered the most theoretically correct inventory valuation method. To begin…<\/p>\n","protected":false},"author":3,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_eb_attr":""},"ht-kb-category":[4],"ht-kb-tag":[],"yoast_head":"\nImplement FIFO In Your System - Unicommerce Support Portal<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Implement FIFO In Your System - Unicommerce Support Portal\" \/>\n<meta property=\"og:description\" content=\"FIFO The First-In, First-Out (FIFO) method of inventory valuation is a cost flow assumption that the first goods purchased are also the first goods sold. In most companies, this assumption closely matches the actual flow of goods, and so is considered the most theoretically correct inventory valuation method. To begin...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/\" \/>\n<meta property=\"og:site_name\" content=\"Unicommerce Support Portal\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-17T17:34:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/lh5.googleusercontent.com\/eK9K7tiE5HoIwzYUWTzloSKRPTCrxtBCkb0RcyjfBynKJcHpOsZNCphspteSKNUK-Md7ktYV76yaTaA8ISd8Wq-PKNpym-DFlDfc3eJs0Vy-M3f_tx3ls7O93ZP--9tFvlC6HnFZfKejWrlwofOWhXuQxp1IDrwbBBXkKOPRIaZ8jVaf0IElyF7dmNqE\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/\",\"url\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/\",\"name\":\"Implement FIFO In Your System - Unicommerce Support Portal\",\"isPartOf\":{\"@id\":\"https:\/\/support.unicommerce.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/lh5.googleusercontent.com\/eK9K7tiE5HoIwzYUWTzloSKRPTCrxtBCkb0RcyjfBynKJcHpOsZNCphspteSKNUK-Md7ktYV76yaTaA8ISd8Wq-PKNpym-DFlDfc3eJs0Vy-M3f_tx3ls7O93ZP--9tFvlC6HnFZfKejWrlwofOWhXuQxp1IDrwbBBXkKOPRIaZ8jVaf0IElyF7dmNqE\",\"datePublished\":\"2019-07-14T05:03:27+00:00\",\"dateModified\":\"2022-11-17T17:34:51+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/#primaryimage\",\"url\":\"https:\/\/lh5.googleusercontent.com\/eK9K7tiE5HoIwzYUWTzloSKRPTCrxtBCkb0RcyjfBynKJcHpOsZNCphspteSKNUK-Md7ktYV76yaTaA8ISd8Wq-PKNpym-DFlDfc3eJs0Vy-M3f_tx3ls7O93ZP--9tFvlC6HnFZfKejWrlwofOWhXuQxp1IDrwbBBXkKOPRIaZ8jVaf0IElyF7dmNqE\",\"contentUrl\":\"https:\/\/lh5.googleusercontent.com\/eK9K7tiE5HoIwzYUWTzloSKRPTCrxtBCkb0RcyjfBynKJcHpOsZNCphspteSKNUK-Md7ktYV76yaTaA8ISd8Wq-PKNpym-DFlDfc3eJs0Vy-M3f_tx3ls7O93ZP--9tFvlC6HnFZfKejWrlwofOWhXuQxp1IDrwbBBXkKOPRIaZ8jVaf0IElyF7dmNqE\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/support.unicommerce.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Articles\",\"item\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Implement FIFO In Your System\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/support.unicommerce.com\/#website\",\"url\":\"https:\/\/support.unicommerce.com\/\",\"name\":\"Unicommerce Support Portal\",\"description\":\"Know more about Uniware\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/support.unicommerce.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Implement FIFO In Your System - Unicommerce Support Portal","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/","og_locale":"en_US","og_type":"article","og_title":"Implement FIFO In Your System - Unicommerce Support Portal","og_description":"FIFO The First-In, First-Out (FIFO) method of inventory valuation is a cost flow assumption that the first goods purchased are also the first goods sold. In most companies, this assumption closely matches the actual flow of goods, and so is considered the most theoretically correct inventory valuation method. To begin...","og_url":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/","og_site_name":"Unicommerce Support Portal","article_modified_time":"2022-11-17T17:34:51+00:00","og_image":[{"url":"https:\/\/lh5.googleusercontent.com\/eK9K7tiE5HoIwzYUWTzloSKRPTCrxtBCkb0RcyjfBynKJcHpOsZNCphspteSKNUK-Md7ktYV76yaTaA8ISd8Wq-PKNpym-DFlDfc3eJs0Vy-M3f_tx3ls7O93ZP--9tFvlC6HnFZfKejWrlwofOWhXuQxp1IDrwbBBXkKOPRIaZ8jVaf0IElyF7dmNqE"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/","url":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/","name":"Implement FIFO In Your System - Unicommerce Support Portal","isPartOf":{"@id":"https:\/\/support.unicommerce.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/#primaryimage"},"image":{"@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/#primaryimage"},"thumbnailUrl":"https:\/\/lh5.googleusercontent.com\/eK9K7tiE5HoIwzYUWTzloSKRPTCrxtBCkb0RcyjfBynKJcHpOsZNCphspteSKNUK-Md7ktYV76yaTaA8ISd8Wq-PKNpym-DFlDfc3eJs0Vy-M3f_tx3ls7O93ZP--9tFvlC6HnFZfKejWrlwofOWhXuQxp1IDrwbBBXkKOPRIaZ8jVaf0IElyF7dmNqE","datePublished":"2019-07-14T05:03:27+00:00","dateModified":"2022-11-17T17:34:51+00:00","breadcrumb":{"@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/#primaryimage","url":"https:\/\/lh5.googleusercontent.com\/eK9K7tiE5HoIwzYUWTzloSKRPTCrxtBCkb0RcyjfBynKJcHpOsZNCphspteSKNUK-Md7ktYV76yaTaA8ISd8Wq-PKNpym-DFlDfc3eJs0Vy-M3f_tx3ls7O93ZP--9tFvlC6HnFZfKejWrlwofOWhXuQxp1IDrwbBBXkKOPRIaZ8jVaf0IElyF7dmNqE","contentUrl":"https:\/\/lh5.googleusercontent.com\/eK9K7tiE5HoIwzYUWTzloSKRPTCrxtBCkb0RcyjfBynKJcHpOsZNCphspteSKNUK-Md7ktYV76yaTaA8ISd8Wq-PKNpym-DFlDfc3eJs0Vy-M3f_tx3ls7O93ZP--9tFvlC6HnFZfKejWrlwofOWhXuQxp1IDrwbBBXkKOPRIaZ8jVaf0IElyF7dmNqE"},{"@type":"BreadcrumbList","@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/implement-fifo-in-your-system\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/support.unicommerce.com\/"},{"@type":"ListItem","position":2,"name":"Articles","item":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/"},{"@type":"ListItem","position":3,"name":"Implement FIFO In Your System"}]},{"@type":"WebSite","@id":"https:\/\/support.unicommerce.com\/#website","url":"https:\/\/support.unicommerce.com\/","name":"Unicommerce Support Portal","description":"Know more about Uniware","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/support.unicommerce.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/115"}],"collection":[{"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/comments?post=115"}],"version-history":[{"count":12,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/115\/revisions"}],"predecessor-version":[{"id":7318,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/115\/revisions\/7318"}],"wp:attachment":[{"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/media?parent=115"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb-category?post=115"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb-tag?post=115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}