{"id":6203,"date":"2025-09-24T15:46:39","date_gmt":"2025-09-24T12:46:39","guid":{"rendered":"https:\/\/wiki.alldevice.com\/?post_type=docs&#038;p=6203"},"modified":"2026-02-25T09:11:35","modified_gmt":"2026-02-25T06:11:35","password":"","slug":"kkk-varuosade-mahakandmine","status":"publish","type":"docs","link":"https:\/\/wiki.alldevice.com\/et\/d\/kkk-varuosade-mahakandmine","title":{"rendered":"Kuidas varuosi maha kanda (Laoseisu v\u00e4hendamine)"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Kui tuleb ette olukord kus on vaja laoseisu v\u00e4hendada t\u00f6\u00f6k\u00e4su v\u00e4liselt, saab seda teha varuosade mahakandmise teel. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mahakandmise teostamiseks vajuta \u00fcleval nupuribal nupule \u201eVaruosad\u201c ning avanenud tabeli p\u00e4ises paremal paiknevale nupule \u201eLaoliikumine\u201c &#8230;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"102\" src=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-25-1024x102.png\" alt=\"\" class=\"wp-image-6627\" srcset=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-25-1024x102.png 1024w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-25-300x30.png 300w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-25-768x76.png 768w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-25-1536x153.png 1536w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-25-360x36.png 360w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-25.png 1829w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&#8230; ning sealt omakorda \u201eMahakandmine\u201c.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"102\" src=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-26-1024x102.png\" alt=\"\" class=\"wp-image-6630\" srcset=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-26-1024x102.png 1024w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-26-300x30.png 300w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-26-768x76.png 768w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-26-1536x153.png 1536w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-26-360x36.png 360w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-26.png 1829w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">L\u00fchema otseteena v\u00f5id ka klikkida nupuribal \u201eVaruosad\u201c nupu paremal k\u00fcljel olevale \u201cnool alla\u201d ikoonile ning avanenud kontekstimen\u00fc\u00fcst vali \u201eMahakandmine\u201c<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"753\" height=\"259\" src=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-27.png\" alt=\"\" class=\"wp-image-6633\" srcset=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-27.png 753w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-27-300x103.png 300w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-27-360x124.png 360w\" sizes=\"auto, (max-width: 753px) 100vw, 753px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Avanenud aknas t\u00e4ida esmalt kommentaari v\u00e4li. See pole k\u00fcll kohustuslik aga on m\u00f5istlik j\u00e4tta kommentaar, miks j\u00e4rgnevad varuosad maha kannad. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Vali ladu, millest soovid varuosi maha kanda ning seej\u00e4rel lisa tooted.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Toodete lisamiseks v\u00f5id kasutada v\u00f6\u00f6tkoodi lugejat. Selleks veendu, et kursor vilgub EAN lahtris. Skaneeri triipkood ning toode lisatakse nimekirja. Iga uus sama toote skaneerimine suurendab kogust \u00fche v\u00f5rra. Kui soovid sama toodet maha kanda j\u00e4rgmisest laos, vaheta lao nimetus ning loe triipkood.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Teine v\u00f5imalus on kasutada varuosa koodi v\u00f5i nimetuse otsingut. Sisesta fragment nimest ning sulle pakutakse leitud vasted. Vali nende hulgast \u00f5ige ning kliki sellele. <\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>NB!<\/strong> Pea meeles, et otsing leiab ainult valitud laos olevaid tooteid. Laost saab maha kanda ainult positiivse kogusega tooteid ja maksimaalselt nimetatud koguses.<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">Kolmas v\u00f5imalus on kasutada nuppu &#8220;Leia toode&#8221; ning avanenud aknast leida \u00f5ige toode.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"148\" src=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-28-1024x148.png\" alt=\"\" class=\"wp-image-6638\" srcset=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-28-1024x148.png 1024w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-28-300x43.png 300w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-28-768x111.png 768w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-28-1536x222.png 1536w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-28-360x52.png 360w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/09\/image-28.png 1829w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kui maha kantavate toodete nimekiri on pikem, v\u00f5ib toodete sisestamiseks kasutada XLS tabeli import. Selleks ekspordi esmalt varuosade tabel ning eemalda tulbast &#8220;Laos_PIS&#8221; k\u00f5ik kogused. Peale seda sisesta soovitud ridadele mahakandmisele minev kogus negatiivse v\u00e4\u00e4rtusena.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pea meeles, et tabelis olevaid ridu, mille kogus on null v\u00f5i positiivne ignoreeritakse ning neid ei lisata tabelisse. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kui soovid sama varuosa maha kanda erinevatest ladudest, pead iga lao jaoks koostama eraldi tabeli ning enne j\u00e4rgmise tabeli importimist vahetama lao nimetuse. <\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>NB! <\/strong>Kui failis on maha kantavaks koguseks -10 aga reaalselt on valitud laos ainult 3tk siis muudetakse kogus kolmeks.<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">Kui on vaja teostada samaaegselt mahakandmine ja kauba lattu v\u00f5tmine, v\u00f5ite kasutada m\u00f5lemal pool sama tabelit. Maha kantavad tooted m\u00e4rgitakse negatiivse kogusega ning juurde ostetavad positiivse kogusega.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"> Laoseisu suurendamise kohta saad lugeda <a href=\"\/et\/d\/kkk-varuosad-laoseisu-suurendamine\">SIIT<\/a><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>NB!<\/strong> Enne mahakandmise teostamist kontrolli hoolega, et k\u00f5ik andmed oleks korrektsed. Juba sisestatud dokumenti enam tagasi v\u00f5tta (kustutada) ei saa.<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">Kui k\u00f5ik soovitud tooted on nimekirja lisatud, vajuta \u00fcleval paremal paiknevale nupule &#8220;Teosta mahakandmine&#8221;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kui tuleb ette olukord kus on vaja laoseisu v\u00e4hendada t\u00f6\u00f6k\u00e4su v\u00e4liselt, saab seda teha varuosade mahakandmise teel. Mahakandmise teostamiseks vajuta [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"bd_labels":[],"footnotes":""},"doc_category":[194],"doc_tag":[204,223,48],"class_list":["post-6203","docs","type-docs","status-publish","hentry","doc_category-kkk-varuosad","doc_tag-ean","doc_tag-laoliikumised","doc_tag-varuosad"],"year_month":"2026-05","word_count":386,"total_views":"156","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Veiko Kelk","author_nicename":"veiko","author_url":"https:\/\/wiki.alldevice.com\/et\/archives\/author\/veiko"},"doc_category_info":[{"term_name":"Varuosad","term_url":"https:\/\/wiki.alldevice.com\/et\/dc\/kkk-varuosad"}],"doc_tag_info":[{"term_name":"EAN","term_url":"https:\/\/wiki.alldevice.com\/et\/dt\/ean"},{"term_name":"Laoliikumised","term_url":"https:\/\/wiki.alldevice.com\/et\/dt\/laoliikumised"},{"term_name":"Varuosad","term_url":"https:\/\/wiki.alldevice.com\/et\/dt\/varuosad"}],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/wiki.alldevice.com\/et\/wp-json\/wp\/v2\/docs\/6203","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wiki.alldevice.com\/et\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/wiki.alldevice.com\/et\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/wiki.alldevice.com\/et\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/wiki.alldevice.com\/et\/wp-json\/wp\/v2\/comments?post=6203"}],"version-history":[{"count":1,"href":"https:\/\/wiki.alldevice.com\/et\/wp-json\/wp\/v2\/docs\/6203\/revisions"}],"predecessor-version":[{"id":8851,"href":"https:\/\/wiki.alldevice.com\/et\/wp-json\/wp\/v2\/docs\/6203\/revisions\/8851"}],"wp:attachment":[{"href":"https:\/\/wiki.alldevice.com\/et\/wp-json\/wp\/v2\/media?parent=6203"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/wiki.alldevice.com\/et\/wp-json\/wp\/v2\/doc_category?post=6203"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/wiki.alldevice.com\/et\/wp-json\/wp\/v2\/doc_tag?post=6203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}