﻿{"id":53337,"date":"2026-11-05T09:27:11","date_gmt":"2026-11-05T02:27:11","guid":{"rendered":"\/tai-san\/?post_type=ht_kb&#038;p=53337"},"modified":"2026-11-05T09:27:11","modified_gmt":"2026-11-05T02:27:11","slug":"mot-so-van-de-thuong-gap-khi-nhap-khau-danh-sach-tscd-tu-excel","status":"publish","type":"ht_kb","link":"\/tai-san\/knowledge-base\/mot-so-van-de-thuong-gap-khi-nhap-khau-danh-sach-tscd-tu-excel\/","title":{"rendered":"M\u1ed9t s\u1ed1 v\u1ea5n \u0111\u1ec1 th\u01b0\u1eddng g\u1eb7p khi Nh\u1eadp kh\u1ea9u danh s\u00e1ch TSC\u0110 t\u1eeb Excel"},"content":{"rendered":"<h3 id=\"1-tong-quan\"><b>1. T\u1ed5ng quan<\/b><\/h3>\n<p>B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn anh\/ch\u1ecb c\u00e1ch x\u1eed l\u00fd khi g\u1eb7p l\u1ed7i nh\u1eadp kh\u1ea9u th\u1ea5t b\u1ea1i khi <strong data-start=\"1152\" data-end=\"1201\">nh\u1eadp s\u1ed1 l\u01b0\u1ee3ng l\u1edbn t\u00e0i s\u1ea3n (TSC\u0110) <\/strong>v\u00e0o ph\u1ea7n m\u1ec1m b\u1eb1ng ch\u1ee9c n\u0103ng <strong data-start=\"1230\" data-end=\"1252\">nh\u1eadp kh\u1ea9u t\u1eeb Excel.<\/strong><\/p>\n<p class=\"PDq2pG_selectionAnchorContainer\" data-start=\"1354\" data-end=\"1380\">N\u1ed9i dung b\u00e0i vi\u1ebft bao g\u1ed3m:<\/p>\n<ul data-start=\"1383\" data-end=\"1578\">\n<li data-section-id=\"i6u8mv\" data-start=\"1383\" data-end=\"1444\">C\u00e1c v\u1ea5n \u0111\u1ec1 v\u00e0 l\u1ed7i sai th\u01b0\u1eddng g\u1eb7p khi Nh\u1eadp kh\u1ea9u danh s\u00e1ch TSC\u0110 t\u1eeb Excel.<\/li>\n<li data-section-id=\"i09sfg\" data-start=\"1447\" data-end=\"1516\">C\u00e1c l\u01b0u \u00fd khi nh\u1eadp file excel nh\u1eadp kh\u1ea9u t\u00e0i s\u1ea3n v\u00e0 c\u00e1ch x\u1eed l\u00fd l\u1ed7i theo t\u1eebng c\u1ea3nh b\u00e1o kh\u00e1c nhau.<\/li>\n<\/ul>\n<h3 id=\"2-cac-buoc-thuc-hien\"><b>2. V\u1ea5n \u0111\u1ec1 th\u01b0\u1eddng g\u1eb7p<\/b><\/h3>\n<h4 id=\"3-1-lam-the-nao-de-biet-da-hoan-thanh-nhap-khau-hay-chua-va-neu-co-loi-thi-tai-nguyen-nhan-loi-de-xem-va-sua-nhu-the-nao\">2.1. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 bi\u1ebft \u0111\u00e3 ho\u00e0n th\u00e0nh nh\u1eadp kh\u1ea9u hay ch\u01b0a v\u00e0 n\u1ebfu c\u00f3 l\u1ed7i th\u00ec t\u1ea3i nguy\u00ean nh\u00e2n l\u1ed7i \u0111\u1ec3 xem v\u00e0 s\u1eeda nh\u01b0 th\u1ebf n\u00e0o?<\/h4>\n<p data-start=\"235\" data-end=\"471\"><strong>Tr\u1ea3 l\u1eddi:<\/strong> Sau khi anh\/ch\u1ecb th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u, ph\u1ea7n m\u1ec1m s\u1ebd hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o <strong data-start=\"326\" data-end=\"426\">\u201c\u0110ang th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u. Qu\u00e1 tr\u00ecnh nh\u1eadp kh\u1ea9u c\u00f3 th\u1ec3 k\u00e9o d\u00e0i t\u00f9y thu\u1ed9c v\u00e0o dung l\u01b0\u1ee3ng d\u1eef li\u1ec7u\u2026\u201d<\/strong>, anh\/ch\u1ecb nh\u1ea5n <strong data-start=\"441\" data-end=\"449\">\u0110\u00f3ng<\/strong> \u0111\u1ec3 ti\u1ebfp t\u1ee5c l\u00e0m vi\u1ec7c.<\/p>\n<p data-start=\"473\" data-end=\"612\">Khi qu\u00e1 tr\u00ecnh nh\u1eadp kh\u1ea9u ho\u00e0n t\u1ea5t, anh\/ch\u1ecb nh\u1ea5n v\u00e0o <strong data-start=\"524\" data-end=\"591\">bi\u1ec3u t\u01b0\u1ee3ng Th\u00f4ng b\u00e1o (h\u00ecnh qu\u1ea3 chu\u00f4ng \u1edf g\u00f3c tr\u00ean c\u00f9ng b\u00ean ph\u1ea3i)<\/strong> \u0111\u1ec3 ki\u1ec3m tra k\u1ebft qu\u1ea3:<\/p>\n<ul>\n<li data-start=\"473\" data-end=\"612\">N\u1ebfu nh\u1eadp kh\u1ea9u <strong data-start=\"629\" data-end=\"643\">th\u00e0nh c\u00f4ng<\/strong>, ph\u1ea7n m\u1ec1m s\u1ebd hi\u1ec3n th\u1ecb <strong data-start=\"666\" data-end=\"696\">s\u1ed1 b\u1ea3n ghi nh\u1eadp th\u00e0nh c\u00f4ng<\/strong>. Anh\/ch\u1ecb \u0111\u1ed1i chi\u1ebfu s\u1ed1 n\u00e0y v\u1edbi <strong data-start=\"727\" data-end=\"768\">s\u1ed1 d\u00f2ng t\u00e0i s\u1ea3n\/CCDC trong file Excel<\/strong>; n\u1ebfu tr\u00f9ng kh\u1edbp th\u00ec d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c nh\u1eadp \u0111\u1ea7y \u0111\u1ee7.<\/li>\n<li data-start=\"473\" data-end=\"612\">N\u1ebfu c\u00f3 <strong data-start=\"827\" data-end=\"838\">b\u00e1o l\u1ed7i<\/strong>, ph\u1ea7n m\u1ec1m s\u1ebd hi\u1ec3n th\u1ecb <strong>s\u1ed1 d\u00f2ng kh\u00f4ng th\u00e0nh c\u00f4ng<\/strong> v\u00e0 hi\u1ec7n file <strong data-start=\"887\" data-end=\"908\">t\u1ea3i danh s\u00e1ch l\u1ed7i<\/strong> v\u1ec1 m\u00e1y. Anh\/ch\u1ecb m\u1edf file danh s\u00e1ch l\u1ed7i \u0111\u1ec3 xem <strong data-start=\"955\" data-end=\"981\">nguy\u00ean nh\u00e2n l\u1ed7i c\u1ee5 th\u1ec3<\/strong> (v\u00ed d\u1ee5: thi\u1ebfu th\u00f4ng tin, sai \u0111\u1ecbnh d\u1ea1ng\u2026), sau \u0111\u00f3 <strong data-start=\"1031\" data-end=\"1059\">ch\u1ec9nh s\u1eeda l\u1ea1i file Excel<\/strong> v\u00e0 th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u l\u1ea1i c\u00e1c d\u00f2ng b\u1ecb l\u1ed7i.<\/li>\n<\/ul>\n<h4 id=\"3-2-sau-khi-nhap-khau-xong-khong-thay-tai-san-ccdc-tren-danh-sach\">2.2. Sau khi nh\u1eadp kh\u1ea9u xong kh\u00f4ng th\u1ea5y t\u00e0i s\u1ea3n\/CCDC tr\u00ean danh s\u00e1ch?<\/h4>\n<p><strong>Tr\u1ea3 l\u1eddi:<\/strong> Sau khi nh\u1eadp kh\u1ea9u th\u00e0nh c\u00f4ng, tr\u1ea1ng th\u00e1i c\u1ee7a T\u00e0i s\u1ea3n l\u00e0 <strong>ch\u01b0a ghi t\u0103ng.\u00a0<\/strong>Anh\/ch\u1ecb c\u00f3 th\u1ec3 xem l\u1ea1i T\u00e0i s\u1ea3n \u0111\u00e3 nh\u1eadp kh\u1ea9u b\u1eb1ng c\u00e1ch l\u1ecdc theo tr\u1ea1ng th\u00e1i <strong>ch\u01b0a ghi t\u0103ng<\/strong>\u00a0tr\u00ean danh s\u00e1ch.<strong>\u00a0<\/strong>\u0110\u1ec3 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt l\u00ean b\u00e1o c\u00e1o anh\/ch\u1ecb th\u1ef1c hi\u1ec7n ghi t\u0103ng T\u00e0i s\u1ea3n theo h\u01b0\u1edbng d\u1eabn <a href=\"https:\/\/helpihos.misa.vn\/tai-san\/knowledge-base\/ghi-tang-tai-san\/\" target=\"_blank\" rel=\"noopener\">t\u1ea1i \u0111\u00e2y.<\/a><\/p>\n<h4 id=\"3-3-khong-nhap-duoc-cot-hien-trang-su-dung-tren-file-excel-thi-xu-ly-the-nao\">2.3. Kh\u00f4ng nh\u1eadp \u0111\u01b0\u1ee3c c\u1ed9t Hi\u1ec7n tr\u1ea1ng s\u1eed d\u1ee5ng tr\u00ean file Excel th\u00ec x\u1eed l\u00fd th\u1ebf n\u00e0o?<\/h4>\n<p><strong>Nguy\u00ean nh\u00e2n:<\/strong>\u00a0C\u1ed9t Hi\u1ec7n tr\u1ea1ng s\u1eed d\u1ee5ng tr\u00ean file Excel \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp t\u1ef1 \u0111\u1ed9ng theo <strong data-start=\"295\" data-end=\"315\">Ph\u00e2n lo\u1ea1i \u0111\u01a1n v\u1ecb<\/strong>. Tr\u01b0\u1eddng h\u1ee3p \u00f4 n\u00e0y kh\u00f4ng cho ph\u00e9p nh\u1eadp, nguy\u00ean nh\u00e2n l\u00e0 do <strong data-start=\"373\" data-end=\"417\">Ph\u00e2n lo\u1ea1i \u0111\u01a1n v\u1ecb \u0111ang ch\u1ecdn kh\u00f4ng ph\u00f9 h\u1ee3p<\/strong> v\u1edbi hi\u1ec7n tr\u1ea1ng s\u1eed d\u1ee5ng c\u1ea7n khai b\u00e1o.<\/p>\n<p data-start=\"456\" data-end=\"583\"><strong data-start=\"456\" data-end=\"471\">C\u00e1ch x\u1eed l\u00fd: <\/strong>Anh\/ch\u1ecb ki\u1ec3m tra v\u00e0 ch\u1ecdn l\u1ea1i <a href=\"https:\/\/helpihos.misa.vn\/tai-san\/knowledge-base\/thay-doi-lai-thong-tin-phan-loai-don-vi\/\" target=\"_blank\" rel=\"noopener\"><strong data-start=\"503\" data-end=\"523\">Ph\u00e2n lo\u1ea1i \u0111\u01a1n v\u1ecb<\/strong><\/a> ph\u00f9 h\u1ee3p, sau \u0111\u00f3 t\u1ea3i l\u1ea1i file m\u1eabu Excel \u0111\u1ec3 nh\u1eadp l\u1ea1i d\u1eef li\u1ec7u.<\/p>\n<p data-start=\"585\" data-end=\"829\"><strong data-start=\"585\" data-end=\"595\">V\u00ed d\u1ee5: <\/strong>Kh\u00f4ng nh\u1eadp \u0111\u01b0\u1ee3c hi\u1ec7n tr\u1ea1ng s\u1eed d\u1ee5ng H\u0110SN \u2013 kh\u00f4ng KD c\u00f3 th\u1ec3 do anh\/ch\u1ecb \u0111ang ch\u1ecdn Ph\u00e2n lo\u1ea1i \u0111\u01a1n v\u1ecb l\u00e0 Qu\u1ea3n l\u00fd nh\u00e0 n\u01b0\u1edbc. Anh\/ch\u1ecb c\u1ea7n ch\u1ecdn l\u1ea1i ph\u00e2n lo\u1ea1i \u0111\u01a1n v\u1ecb ph\u00f9 h\u1ee3p, r\u1ed3i t\u1ea3i l\u1ea1i file m\u1eabu Excel \u0111\u1ec3 nh\u1eadp \u0111\u00fang hi\u1ec7n tr\u1ea1ng s\u1eed d\u1ee5ng.<\/p>\n<h4 id=\"3-4-sap-nhap-cho-2-don-vi-khac-nhau-1-ben-nhap-ben-online-1-ben-offline-bay-gio-muon-chuyen-tai-san-da-nhap-offline-qua-online-thi-lam-the-nao\" data-start=\"585\" data-end=\"829\">2.4. S\u00e1p nh\u1eadp cho 2 \u0111\u01a1n v\u1ecb kh\u00e1c nhau, 1 b\u00ean nh\u1eadp b\u00ean online, 1 b\u00ean offline. B\u00e2y gi\u1edd<strong data-start=\"171\" data-end=\"223\"> mu\u1ed1n chuy\u1ec3n t\u00e0i s\u1ea3n \u0111\u00e3 nh\u1eadp offline qua online <\/strong>th\u00ec l\u00e0m th\u1ebf n\u00e0o?<\/h4>\n<p><strong>Tr\u1ea3 l\u1eddi:<\/strong> Anh\/ch\u1ecb th\u1ef1c hi\u1ec7n:<\/p>\n<ul>\n<li>Khai b\u00e1o l\u1ea1i t\u1eebng m\u00e3 TSC\u0110 theo h\u01b0\u1edbng d\u1eabn <a href=\"https:\/\/helpihos.misa.vn\/tai-san\/knowledge-base\/khai-bao-danh-sach-tai-san\/\">t\u1ea1i \u0111\u00e2y<\/a><\/li>\n<li>Nh\u1eadp kh\u1ea9u danh s\u00e1ch TSC\u0110 v\u00e0o ph\u1ea7n m\u1ec1m t\u00f9 file excel theo h\u01b0\u1edbng d\u1eabn <a href=\"https:\/\/helpihos.misa.vn\/tai-san\/knowledge-base\/nhap-khau-danh-sach-tai-san\/\">t\u1ea1i \u0111\u00e2y<\/a> (\u00e1p d\u1ee5ng cho tr\u01b0\u1eddng h\u1ee3p \u0111\u01a1n v\u1ecb s\u00e1p nh\u1eadp kh\u00f4ng theo d\u00f5i TSC\u0110 tr\u00ean ph\u1ea7n m\u1ec1m MISA)<\/li>\n<li>Ho\u1eb7c nh\u1eadp kh\u1ea9u danh s\u00e1ch TSC\u0110 t\u1eeb MIMOSA\/iHOS K\u1ebf to\u00e1n v\u00e0o iHOS T\u00e0i s\u1ea3n theo h\u01b0\u1edbng d\u1eabn <a href=\"https:\/\/helpihos.misa.vn\/tai-san\/knowledge-base\/toi-muon-chuyen-tai-san-tu-misa-mimosa-net-len-phan-mem-qlts-vn-thi-lam-the-nao\/\">t\u1ea1i \u0111\u00e2y<\/a><\/li>\n<\/ul>\n<h4 id=\"3-5-nhap-khau-tai-san-bao-loi-hien-trang-su-dung-khong-duoc-de-trong-phai-dien-nhu-the-nao\" data-start=\"585\" data-end=\"829\">2.5. Nh\u1eadp kh\u1ea9u t\u00e0i s\u1ea3n b\u00e1o l\u1ed7i \u201cHi\u1ec7n tr\u1ea1ng s\u1eed d\u1ee5ng kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1ec3 tr\u1ed1ng\u201d ph\u1ea3i \u0111i\u1ec1n nh\u01b0 th\u1ebf n\u00e0o?<\/h4>\n<p data-start=\"169\" data-end=\"324\"><strong data-start=\"169\" data-end=\"181\">Tr\u1ea3 l\u1eddi: <\/strong>Khi nh\u1eadp kh\u1ea9u t\u00e0i s\u1ea3n, ph\u1ea7n <strong data-start=\"212\" data-end=\"234\">Hi\u1ec7n tr\u1ea1ng s\u1eed d\u1ee5ng<\/strong> b\u1eaft bu\u1ed9c ph\u1ea3i khai b\u00e1o tr\u00ean file Excel. Anh\/ch\u1ecb \u0111i\u1ec1n th\u00f4ng tin hi\u1ec7n tr\u1ea1ng s\u1eed d\u1ee5ng tr\u00ean file excel nh\u01b0 sau:<\/p>\n<ul data-start=\"326\" data-end=\"708\">\n<li data-section-id=\"189k6az\" data-start=\"326\" data-end=\"534\">\n<p data-start=\"328\" data-end=\"534\"><strong data-start=\"328\" data-end=\"382\">C\u1ed9t BQ \u0111\u1ebfn BZ \u2013 Hi\u1ec7n tr\u1ea1ng s\u1eed d\u1ee5ng (\u0110\u1ea5t ho\u1eb7c Nh\u00e0):<\/strong><br data-start=\"382\" data-end=\"385\" \/><br \/>\n<br \/>\nNh\u1eadp <strong data-start=\"392\" data-end=\"418\">di\u1ec7n t\u00edch s\u1eed d\u1ee5ng (m\u00b2)<\/strong> t\u01b0\u01a1ng \u1ee9ng v\u1edbi t\u1eebng hi\u1ec7n tr\u1ea1ng s\u1eed d\u1ee5ng.<br data-start=\"457\" data-end=\"460\" data-is-only-node=\"\" \/><br \/>\n<br \/>\nL\u01b0u \u00fd: <strong data-start=\"469\" data-end=\"490\">\u201cS\u1eed d\u1ee5ng h\u1ed7n h\u1ee3p\u201d<\/strong> ch\u1ec9 \u00e1p d\u1ee5ng khi k\u00ea khai <strong data-start=\"515\" data-end=\"533\">t\u00e0i s\u1ea3n l\u00e0 Nh\u00e0<\/strong>.<\/p>\n<\/li>\n<li data-section-id=\"1r12xs1\" data-start=\"536\" data-end=\"708\">\n<p data-start=\"538\" data-end=\"708\"><strong data-start=\"538\" data-end=\"602\">C\u1ed9t DB \u0111\u1ebfn DG \u2013 Hi\u1ec7n tr\u1ea1ng s\u1eed d\u1ee5ng (\u00d4 t\u00f4 ho\u1eb7c T\u00e0i s\u1ea3n kh\u00e1c):<\/strong><br data-start=\"602\" data-end=\"605\" \/><br \/>\n<br \/>\nAnh\/ch\u1ecb <strong data-start=\"615\" data-end=\"631\">t\u00edch ch\u1eef \u201cx\u201d<\/strong> v\u00e0o c\u1ed9t hi\u1ec7n tr\u1ea1ng t\u01b0\u01a1ng \u1ee9ng n\u1ebfu t\u00e0i s\u1ea3n \u0111ang \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng theo m\u1ee5c \u0111\u00edch \u0111\u00f3.<\/p>\n<\/li>\n<\/ul>\n<p data-start=\"710\" data-end=\"856\" data-is-last-node=\"\" data-is-only-node=\"\">Sau khi \u0111i\u1ec1n \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin hi\u1ec7n tr\u1ea1ng s\u1eed d\u1ee5ng theo \u0111\u00fang lo\u1ea1i t\u00e0i s\u1ea3n, anh\/ch\u1ecb l\u01b0u file v\u00e0 th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u l\u1ea1i \u0111\u1ec3 h\u1ec7 th\u1ed1ng ghi nh\u1eadn d\u1eef li\u1ec7u.<\/p>\n<h4 id=\"3-6-lam-the-nao-khi-khong-dien-duoc-cot-nguyen-gia-tren-file-excel-nhap-khau-tscd\" data-start=\"710\" data-end=\"856\">2.6. L\u00e0m th\u1ebf n\u00e0o khi kh\u00f4ng \u0111i\u1ec1n \u0111\u01b0\u1ee3c c\u1ed9t nguy\u00ean gi\u00e1 tr\u00ean file excel nh\u1eadp kh\u1ea9u TSC\u0110?<\/h4>\n<p><strong>Nguy\u00ean nh\u00e2n:<\/strong> C\u1ed9t <strong>Nguy\u00ean gi\u00e1<\/strong> tr\u00ean file excel \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp \u0111\u1ec3 kh\u00f4ng nh\u1eadp tr\u1ef1c ti\u1ebfp, m\u00e0 l\u1ea5y t\u1ed5ng s\u1ed1 li\u1ec7u t\u1ea1i c\u00e1c c\u1ed9t ngu\u1ed3n h\u00ecnh th\u00e0nh chi ti\u1ebft b\u00ean c\u1ea1nh<em> (Ng\u00e2n s\u00e1ch Trung \u01b0\u01a1ng t\u1ef1 ch\u1ee7, Ng\u00e2n s\u00e1ch Trung \u01b0\u01a1ng kh\u00f4ng t\u1ef1 ch\u1ee7, Ngu\u1ed3n vi\u1ec7n tr\u1ee3, t\u00e0i tr\u1ee3, bi\u1ebfu t\u1eb7ng nh\u1ecf l\u1ebb, x\u00e3 h\u1ed9i h\u00f3a, Ng\u00e2n s\u00e1ch T\u1ec9nh t\u1ef1 ch\u1ee7, Ng\u00e2n s\u00e1ch T\u1ec9nh kh\u00f4ng t\u1ef1 ch\u1ee7, Ng\u00e2n s\u00e1ch Huy\u1ec7n t\u1ef1 ch\u1ee7, Ng\u00e2n s\u00e1ch Huy\u1ec7n kh\u00f4ng t\u1ef1 ch\u1ee7, Ph\u00ed, l\u1ec7 ph\u00ed \u0111\u1ec3 l\u1ea1i, Ngu\u1ed3n vi\u1ec7n tr\u1ee3, t\u00e0i tr\u1ee3, Ngu\u1ed3n kh\u00e1c, Ng\u00e2n s\u00e1ch, X\u00e3 t\u1ef1 ch\u1ee7, Ng\u00e2n s\u00e1ch X\u00e3 kh\u00f4ng t\u1ef1 ch\u1ee7, Qu\u1ef9 ph\u00fac l\u1ee3i, Qu\u1ef9 ph\u00e1t tri\u1ec3n ho\u1ea1t \u0111\u1ed9ng s\u1ef1 nghi\u1ec7p)<\/em><\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong> Anh\/ch\u1ecb x\u00e1c \u0111\u1ecbnh TSC\u0110 \u0111\u01b0\u1ee3c h\u00ecnh th\u00e0nh t\u1eeb ngu\u1ed3n n\u00e0o th\u00ec nh\u1eadp nguy\u00ean gi\u00e1 v\u00e0o c\u1ed9t ngu\u1ed3n t\u01b0\u01a1ng \u1ee9ng, sau khi nh\u1eadp, \u00f4 <strong>Nguy\u00ean gi\u00e1<\/strong> s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt theo.<\/p>\n<h4 id=\"3-7-toi-da-nhap-khau-tai-san-tu-excel-nhung-khi-vao-chuc-nang-ghi-tang-thi-khong-len-du-so-luong-tai-san-nhap-khau\">2.7. T\u00f4i \u0111\u00e3 nh\u1eadp kh\u1ea9u t\u00e0i s\u1ea3n t\u1eeb excel, nh\u01b0ng khi v\u00e0o ch\u1ee9c n\u0103ng ghi t\u0103ng th\u00ec kh\u00f4ng l\u00ean \u0111\u1ee7 s\u1ed1 l\u01b0\u1ee3ng t\u00e0i s\u1ea3n nh\u1eadp kh\u1ea9u?<\/h4>\n<p data-start=\"172\" data-end=\"247\"><strong>Nguy\u00ean nh\u00e2n:<\/strong> Do kh\u00e1c nhau v\u1ec1 <strong data-start=\"218\" data-end=\"234\">n\u0103m ghi t\u0103ng<\/strong> c\u1ee7a t\u00e0i s\u1ea3n:<\/p>\n<ul data-start=\"249\" data-end=\"615\">\n<li data-section-id=\"1he5daa\" data-start=\"249\" data-end=\"364\"><strong data-start=\"251\" data-end=\"284\">C\u00e1c t\u00e0i s\u1ea3n c\u00f3 n\u0103m ghi t\u0103ng thu\u1ed9c n\u0103m hi\u1ec7n t\u1ea1i:<\/strong> L\u00e0 t\u00e0i s\u1ea3n t\u0103ng m\u1edbi trong n\u0103m n\u00ean <strong data-start=\"321\" data-end=\"347\">c\u1ea7n th\u1ef1c hi\u1ec7n ghi t\u0103ng<\/strong> tr\u00ean ph\u1ea7n m\u1ec1m.<\/li>\n<li data-section-id=\"135b3cd\" data-start=\"365\" data-end=\"615\"><strong data-start=\"367\" data-end=\"389\">C\u00e1c t\u00e0i s\u1ea3n c\u00f2n l\u1ea1i<\/strong> c<strong>\u00f3 n\u0103m ghi t\u0103ng thu\u1ed9c n\u0103m tr\u01b0\u1edbc:<\/strong> L\u00e0 t\u00e0i s\u1ea3n anh\/ch\u1ecb b\u1ed5 sung do ki\u1ec3m k\u00ea v\u00e0 \u0111ang khai b\u00e1o, ghi t\u0103ng b\u00f9, \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh l\u00e0 <strong data-start=\"491\" data-end=\"509\">t\u00e0i s\u1ea3n \u0111\u1ea7u k\u1ef3<\/strong>, khi nh\u1eadp kh\u1ea9u ho\u00e0n th\u00e0nh, tr\u1ea1ng th\u00e1i l\u00e0 <strong>\u0110ang s\u1eed d\u1ee5ng<\/strong>, n\u00ean kh\u00f4ng hi\u1ec3n th\u1ecb trong danh s\u00e1ch c\u1ea7n ghi t\u0103ng n\u1eefa.<\/li>\n<\/ul>\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong> \u0110\u1ed1i v\u1edbi c\u00e1c t\u00e0i s\u1ea3n khai b\u00e1o, ghi t\u0103ng b\u00f9, \u0111\u1ec3 kh\u00f4ng \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn s\u1ed1 li\u1ec7u c\u1ee7a c\u00e1c n\u0103m tr\u01b0\u1edbc, anh\/ch\u1ecb c\u1ea7n s\u1eeda l\u1ea1i ng\u00e0y ghi t\u0103ng thu\u1ed9c n\u0103m hi\u1ec7n t\u1ea1i. Khi \u0111\u00f3 ch\u1ee9ng t\u1eeb Ghi t\u0103ng s\u1ebd hi\u1ec3n th\u1ecb c\u00e1c t\u00e0i s\u1ea3n n\u00e0y.\u00a0<\/p>\n<p>Anh\/ch\u1ecb tham kh\u1ea3o h\u01b0\u1edbng d\u1eabn khai b\u00e1o\/ghi t\u0103ng b\u00f9 t\u00e0i s\u1ea3n \u0111\u00fang nghi\u1ec7p v\u1ee5 <a href=\"https:\/\/helpihos.misa.vn\/tai-san\/knowledge-base\/don-vi-cua-toi-co-tai-san-da-su-dung-truoc-do-nhung-chua-duoc-ghi-tang-tren-phan-mem-toi-muon-khai-bao-bu-tai-san-thi-lam-nhu-the-nao\/\"><strong>t\u1ea1i \u0111\u00e2y<\/strong><\/a>.<\/p>\n<h4 id=\"3-7-toi-da-nhap-khau-tai-san-tu-excel-nhung-khi-vao-chuc-nang-ghi-tang-thi-khong-len-du-so-luong-tai-san-nhap-khau\">2.8. Nh\u1eadp kh\u1ea9u t\u00e0i s\u1ea3n b\u00e1o l\u1ed7i &#8220;Nguy\u00ean gi\u00e1 ph\u1ea3i b\u1eb1ng t\u1ed5ng Hao m\u00f2n\/kh\u1ea5u hao l\u0169y k\u1ebf v\u00e0 Gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i&#8221; th\u00ec ph\u1ea3i l\u00e0m sao?<\/h4>\n<p><strong>Nguy\u00ean nh\u00e2n:<\/strong><\/p>\n<p data-path-to-node=\"4,0,0\">T\u1ed5ng s\u1ed1 ti\u1ec1n c\u1ee7a c\u1ed9t <b data-path-to-node=\"4,0,0\" data-index-in-node=\"34\">Hao m\u00f2n\/kh\u1ea5u hao l\u0169y k\u1ebf<\/b> c\u1ed9ng v\u1edbi c\u1ed9t <b data-path-to-node=\"4,0,0\" data-index-in-node=\"71\">Gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i<\/b> kh\u00f4ng kh\u1edbp ch\u00ednh x\u00e1c v\u1edbi s\u1ed1 ti\u1ec1n \u1edf c\u1ed9t <b data-path-to-node=\"4,0,0\" data-index-in-node=\"126\">Nguy\u00ean gi\u00e1<\/b> tr\u00ean file Excel. L\u1ed7i n\u00e0y th\u01b0\u1eddng do 3 nguy\u00ean nh\u00e2n ch\u00ednh sau:<\/p>\n<ul>\n<li>C\u00f4ng th\u1ee9c t\u00ednh to\u00e1n c\u1ed9t &#8220;Gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i (*)&#8221; \u0111\u00e3 c\u00f3 h\u00e0m c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n s\u1eb5n. Tuy nhi\u00ean trong qu\u00e1 tr\u00ecnh nh\u1eadp s\u1ed1 li\u1ec7u v\u00e0o file excel th\u00ec anh\/ch\u1ecb \u0111ang nh\u1eadp tay\/nh\u1eadp th\u1ee7 c\u00f4ng lu\u00f4n c\u1ea3 c\u1ed9t Gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i n\u00e0y nh\u01b0ng s\u1ed1 li\u1ec7u ch\u01b0a \u0111\u00fang.<\/li>\n<li>Anh\/ch\u1ecb ch\u01b0a gh\u00e9p h\u1ebft c\u00e1c ngu\u1ed3n ng\u00e2n s\u00e1ch tr\u00ean t\u1ec7p nh\u1eadp kh\u1ea9u v\u1edbi ngu\u1ed3n ng\u00e2n s\u00e1ch trong danh m\u1ee5c. \u0110\u1ed1i v\u1edbi nguy\u00ean nh\u00e2n n\u00e0y th\u01b0\u1eddng s\u1ebd \u0111i k\u00e8m \u0111\u1ed3ng th\u1eddi c\u1ea3 c\u1ea3nh b\u00e1o &#8220;Kh\u00f4ng gh\u00e9p \u0111\u01b0\u1ee3c c\u00e1c c\u1ed9t ngu\u1ed3n v\u1edbi c\u00e1c ngu\u1ed3n trong ph\u1ea7n m\u1ec1m&#8221;.<\/li>\n<li>C\u00e1c s\u1ed1 li\u1ec7u Nguy\u00ean gi\u00e1, Hao m\u00f2n l\u0169y k\u1ebf, Kh\u1ea5u hao l\u0169y k\u1ebf, Gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i tr\u00ean file Excel c\u00f3 ch\u1ee9a c\u00e1c ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n \u1ea9n sau d\u1ea5u ph\u1ea9y (l\u00e0m tr\u00f2n hi\u1ec3n th\u1ecb nh\u01b0ng gi\u00e1 tr\u1ecb th\u1ef1c t\u1ebf b\u00ean trong b\u1ecb l\u1ec7ch l\u1ebb v\u00e0i \u0111\u1ed3ng).<\/li>\n<\/ul>\n<p data-path-to-node=\"4,1,0\"><b data-path-to-node=\"4,1,0\" data-index-in-node=\"0\">Gi\u1ea3i ph\u00e1p:<\/b><\/p>\n<ul>\n<li>\u0110\u1ea3m b\u1ea3o kh\u00f4ng nh\u1eadp th\u1ee7 c\u00f4ng s\u1ed1 li\u1ec7u v\u00e0o c\u1ed9t &#8220;<span class=\"math-inline\" data-math=\"Nguy\u00ean\\ gi\u00e1 = Hao\\ m\u00f2n\/kh\u1ea5u\\ hao\\ l\u0169y\\ k\u1ebf + Gi\u00e1\\ tr\u1ecb\\ c\u00f2n\\ l\u1ea1i\" data-index-in-node=\"19\">Gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i&#8221; m\u00e0 \u0111\u1ec3 cho c\u1ed9t n\u00e0y \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n theo c\u00f4ng th\u1ee9c<\/span>.<\/li>\n<li>T\u1ea1i b\u01b0\u1edbc Gh\u00e9p d\u1eef li\u1ec7u nh\u1eadp kh\u1ea9u, anh\/ch\u1ecb ki\u1ec3m tra v\u00e0 \u0111\u1ea3m b\u1ea3o t\u1ea1i m\u1ee5c &#8220;Ch\u1ecdn ngu\u1ed3n ng\u00e2n s\u00e1ch&#8221; th\u00ec t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t ngu\u1ed3n ng\u00e2n s\u00e1ch tr\u00ean t\u1ec7p nh\u1eadp kh\u1ea9u \u0111\u00e3 \u0111\u01b0\u1ee3c gh\u00e9p t\u01b0\u01a1ng \u1ee9ng v\u1edbi ngu\u1ed3n ng\u00e2n s\u00e1ch trong danh m\u1ee5c tr\u00ean ph\u1ea7n m\u1ec1m.<\/li>\n<li data-path-to-node=\"4,1,0\">Ki\u1ec3m tra l\u1ea1i c\u00e1c c\u1ed9t Nguy\u00ean gi\u00e1, Hao m\u00f2n l\u0169y k\u1ebf v\u00e0 Gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i. B\u00f4i \u0111en c\u00e1c c\u1ed9t n\u00e0y, sau \u0111\u00f3 t\u0103ng s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n l\u00ean (d\u00f9ng t\u00ednh n\u0103ng t\u0103ng ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n tr\u00ean Excel) \u0111\u1ec3 ki\u1ec3m tra xem c\u00f3 s\u1ed1 l\u1ebb n\u00e0o \u1edf ph\u00eda sau kh\u00f4ng. N\u1ebfu c\u00f3, anh\/ch\u1ecb h\u00e3y s\u1eeda l\u1ea1i th\u00e0nh s\u1ed1 nguy\u00ean cho kh\u1edbp.<\/li>\n<\/ul>\n<h4 id=\"3-7-toi-da-nhap-khau-tai-san-tu-excel-nhung-khi-vao-chuc-nang-ghi-tang-thi-khong-len-du-so-luong-tai-san-nhap-khau\">2.9. Nh\u1eadp kh\u1ea9u t\u00e0i s\u1ea3n b\u00e1o l\u1ed7i &#8220;Kh\u00f4ng gh\u00e9p \u0111\u01b0\u1ee3c c\u00e1c c\u1ed9t ngu\u1ed3n v\u1edbi c\u00e1c ngu\u1ed3n trong ph\u1ea7n m\u1ec1m&#8221; th\u00ec ph\u1ea3i l\u00e0m sao?<\/h4>\n<p><strong>Nguy\u00ean nh\u00e2n:\u00a0<\/strong>Do anh\/ch\u1ecb ch\u01b0a gh\u00e9p h\u1ebft c\u00e1c ngu\u1ed3n ng\u00e2n s\u00e1ch tr\u00ean t\u1ec7p nh\u1eadp kh\u1ea9u v\u1edbi ngu\u1ed3n ng\u00e2n s\u00e1ch trong danh m\u1ee5c.<\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong> T\u1ea1i b\u01b0\u1edbc Gh\u00e9p d\u1eef li\u1ec7u nh\u1eadp kh\u1ea9u, anh\/ch\u1ecb ki\u1ec3m tra v\u00e0 \u0111\u1ea3m b\u1ea3o t\u1ea1i m\u1ee5c &#8220;Ch\u1ecdn ngu\u1ed3n ng\u00e2n s\u00e1ch&#8221; th\u00ec t\u1ea5t c\u1ea3 c\u00e1c C\u1ed9t ngu\u1ed3n ng\u00e2n s\u00e1ch tr\u00ean t\u1ec7p nh\u1eadp kh\u1ea9u \u0111\u00e3 \u0111\u01b0\u1ee3c gh\u00e9p t\u01b0\u01a1ng \u1ee9ng v\u1edbi Ngu\u1ed3n ng\u00e2n s\u00e1ch trong danh m\u1ee5c tr\u00ean ph\u1ea7n m\u1ec1m.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. T\u1ed5ng quan B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn anh\/ch\u1ecb c\u00e1ch x\u1eed l\u00fd khi g\u1eb7p l\u1ed7i nh\u1eadp kh\u1ea9u th\u1ea5t b\u1ea1i khi nh\u1eadp s\u1ed1 l\u01b0\u1ee3ng l\u1edbn t\u00e0i s\u1ea3n (TSC\u0110) v\u00e0o ph\u1ea7n m\u1ec1m b\u1eb1ng ch\u1ee9c n\u0103ng nh\u1eadp kh\u1ea9u t\u1eeb Excel. N\u1ed9i dung b\u00e0i vi\u1ebft bao g\u1ed3m: C\u00e1c v\u1ea5n \u0111\u1ec1 v\u00e0 l\u1ed7i sai th\u01b0\u1eddng g\u1eb7p&#8230;<\/p>\n","protected":false},"author":169,"template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[],"ht-kb-tag":[],"class_list":["post-53337","ht_kb","type-ht_kb","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"\/tai-san\/wp-json\/wp\/v2\/ht-kb\/53337","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/tai-san\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/tai-san\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/tai-san\/wp-json\/wp\/v2\/users\/169"}],"version-history":[{"count":1,"href":"\/tai-san\/wp-json\/wp\/v2\/ht-kb\/53337\/revisions"}],"predecessor-version":[{"id":53339,"href":"\/tai-san\/wp-json\/wp\/v2\/ht-kb\/53337\/revisions\/53339"}],"wp:attachment":[{"href":"\/tai-san\/wp-json\/wp\/v2\/media?parent=53337"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/tai-san\/wp-json\/wp\/v2\/ht-kb-category?post=53337"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/tai-san\/wp-json\/wp\/v2\/ht-kb-tag?post=53337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}