{"id":31643,"date":"2024-06-12T13:34:19","date_gmt":"2024-06-12T06:34:19","guid":{"rendered":"http:\/\/helpasp.misa.vn\/accounting\/?post_type=ht_kb&#038;p=31643"},"modified":"2025-12-05T08:56:47","modified_gmt":"2025-12-05T01:56:47","slug":"lam-the-nao-khi-nhap-khau-danh-muc-so-du-chung-tu-tu-file-excel-vao-phan-mem-bao-loi-khong-hop-le","status":"publish","type":"ht_kb","link":"http:\/\/helpasp.misa.vn\/accounting\/kb\/lam-the-nao-khi-nhap-khau-danh-muc-so-du-chung-tu-tu-file-excel-vao-phan-mem-bao-loi-khong-hop-le\/","title":{"rendered":"L\u00e0m th\u1ebf n\u00e0o khi nh\u1eadp kh\u1ea9u Danh m\u1ee5c, S\u1ed1 d\u01b0, Ch\u1ee9ng t\u1eeb t\u1eeb file excel v\u00e0o ph\u1ea7n m\u1ec1m b\u00e1o l\u1ed7i kh\u00f4ng h\u1ee3p l\u1ec7?"},"content":{"rendered":"<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><strong>1. T\u1ed5ng quan<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn<\/strong> x\u1eed l\u00fd c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi nh\u1eadp kh\u1ea9u danh m\u1ee5c, s\u1ed1 d\u01b0, ch\u1ee9ng t\u1eeb t\u1eeb file Excel v\u00e0o ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n, gi\u00fap \u0111\u1ea3m b\u1ea3o qu\u00e1 tr\u00ecnh nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u di\u1ec5n ra ch\u00ednh x\u00e1c v\u00e0 hi\u1ec7u qu\u1ea3.<\/p>\n<p><strong>N\u1ed9i dung b\u00e0i vi\u1ebft<\/strong> bao g\u1ed3m c\u00e1c bi\u1ec3u hi\u1ec7n l\u1ed7i, nguy\u00ean nh\u00e2n v\u00e0 gi\u1ea3i ph\u00e1p cho t\u1eebng tr\u01b0\u1eddng h\u1ee3p khi nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb, danh m\u1ee5c, c\u0169ng nh\u01b0 c\u00e1c tr\u01b0\u1eddng h\u1ee3p kh\u00e1c li\u00ean quan.<\/p>\n<p><strong>Ph\u1ea1m vi \u0111\u00e1p \u1ee9ng:<\/strong> \u00c1p d\u1ee5ng cho ng\u01b0\u1eddi d\u00f9ng th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u Excel v\u00e0o ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n MISA, ph\u00f9 h\u1ee3p v\u1edbi c\u00e1c b\u1ed9 ph\u1eadn k\u1ebf to\u00e1n, qu\u1ea3n tr\u1ecb d\u1eef li\u1ec7u v\u00e0 c\u00e1c phi\u00ean b\u1ea3n ph\u1ea7n m\u1ec1m h\u1ed7 tr\u1ee3 ch\u1ee9c n\u0103ng nh\u1eadp kh\u1ea9u.<\/p>\n<p><strong>Bi\u1ec3u hi\u1ec7n:<\/strong> Khi <a href=\"https:\/\/helpasp.misa.vn\/accounting\/kb\/html_10050000\/\" target=\"_blank\" rel=\"noopener\">nh\u1eadp kh\u1ea9u c\u00e1c Danh m\u1ee5c, S\u1ed1 d\u01b0, Ch\u1ee9ng t\u1eeb t\u1eeb file excel v\u00e0o ph\u1ea7n m\u1ec1m<\/a>, t\u1edbi b\u01b0\u1edbc ki\u1ec3m tra d\u1eef li\u1ec7u t\u1ea1i c\u1ed9t t\u00ecnh tr\u1ea1ng th\u1ea5y c\u00f3 b\u00e1o l\u1ed7i <strong>Kh\u00f4ng h\u1ee3p l\u1ec7<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-31645\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/KHLE1.png\" alt=\"\" width=\"1024\" height=\"225\" srcset=\"\/accounting\/wp-content\/uploads\/2024\/06\/KHLE1.png 1024w, \/accounting\/wp-content\/uploads\/2024\/06\/KHLE1-768x169.png 768w, \/accounting\/wp-content\/uploads\/2024\/06\/KHLE1-50x11.png 50w, \/accounting\/wp-content\/uploads\/2024\/06\/KHLE1-60x13.png 60w, \/accounting\/wp-content\/uploads\/2024\/06\/KHLE1-100x22.png 100w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><strong>2. C\u00e1ch x\u1eed l\u00fd<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 100%;\"><\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h4><strong>2.1 Nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb<\/strong><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><span style=\"color: #0000ff;\"><strong>Tr\u01b0\u1eddng h\u1ee3p 1: M\u00e3 h\u00e0ng, M\u00e3 kh\u00e1ch h\u00e0ng, M\u00e3 nh\u00e0 cung c\u1ea5p,&#8230; kh\u00f4ng c\u00f3 trong danh m\u1ee5c<\/strong><\/span><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-31647\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/KHLE2.png\" alt=\"\" width=\"1077\" height=\"511\" srcset=\"\/accounting\/wp-content\/uploads\/2024\/06\/KHLE2.png 1077w, \/accounting\/wp-content\/uploads\/2024\/06\/KHLE2-768x364.png 768w, \/accounting\/wp-content\/uploads\/2024\/06\/KHLE2-50x24.png 50w, \/accounting\/wp-content\/uploads\/2024\/06\/KHLE2-60x28.png 60w, \/accounting\/wp-content\/uploads\/2024\/06\/KHLE2-100x47.png 100w\" sizes=\"(max-width: 1077px) 100vw, 1077px\" \/><\/p>\n<ul>\n<li><strong>Nguy\u00ean nh\u00e2n 1:<\/strong> Do <b>gh\u00e9p nh\u1ea7m c\u1ed9t M\u00e3 kh\u00e1ch h\u00e0ng v\u1edbi c\u1ed9t T\u00ean kh\u00e1ch h\u00e0ng <\/b>tr\u00ean file excel<\/li>\n<li><strong>Gi\u1ea3i ph\u00e1p<\/strong>: T\u1ea1i b\u01b0\u1edbc <strong>Gh\u00e9p c\u1ed9t tr\u00ean ph\u1ea7n m\u1ec1m v\u1edbi c\u1ed9t tr\u00ean t\u1ec7p d\u1eef li\u1ec7u<\/strong>, ki\u1ec3m tra <strong>c\u1ed9t tr\u00ean ph\u1ea7n m\u1ec1m v\u00e0 c\u1ed9t tr\u00ean t\u1ec7p d\u1eef li\u1ec7u<\/strong> ph\u1ea7n M\u00e3 kh\u00e1ch h\u00e0ng v\u00e0 T\u00ean kh\u00e1ch h\u00e0ng xem \u0111\u00e3 gh\u00e9p \u0111\u00fang ch\u01b0a.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-31649\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/KHLE3.png\" alt=\"\" width=\"1340\" height=\"490\" srcset=\"\/accounting\/wp-content\/uploads\/2024\/06\/KHLE3.png 1340w, \/accounting\/wp-content\/uploads\/2024\/06\/KHLE3-768x281.png 768w, \/accounting\/wp-content\/uploads\/2024\/06\/KHLE3-50x18.png 50w, \/accounting\/wp-content\/uploads\/2024\/06\/KHLE3-60x22.png 60w, \/accounting\/wp-content\/uploads\/2024\/06\/KHLE3-100x37.png 100w\" sizes=\"(max-width: 1340px) 100vw, 1340px\" \/><\/p>\n<ul>\n<li><strong>Nguy\u00ean nh\u00e2n 2:<\/strong> Do <strong>M\u00e3<\/strong> c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng \u0111\u00f3 ch\u01b0a c\u00f3 khai b\u00e1o trong Danh m\u1ee5c<\/li>\n<li style=\"text-align: justify;\"><strong>Gi\u1ea3i ph\u00e1p:<\/strong> Ki\u1ec3m tra l\u1ea1i M\u00e3 \u0111\u1ed1i t\u01b0\u1ee3ng m\u00e0 ph\u1ea7n m\u1ec1m \u0111ang b\u00e1o l\u1ed7i \u0111\u00e3 c\u00f3 trong Danh m\u1ee5c hay ch\u01b0a, n\u1ebfu ch\u01b0a th\u00ec b\u1ed5 sung v\u00e0o tr\u01b0\u1edbc.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"color: #0000ff;\">V\u00ed d\u1ee5: V\u1edbi c\u1ea3nh b\u00e1o &#8221; M\u00e3 kh\u00e1ch h\u00e0ng &lt;VANLONG&gt; kh\u00f4ng c\u00f3 trong danh m\u1ee5c =&gt; Ki\u1ec3m tra nh\u01b0 sau:<\/span><\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> V\u00e0o m\u1ee5c <strong>Ti\u1ec7n \u00edch v\u00e0 thi\u1ebft l\u1eadp\\ T\u1ea5t c\u1ea3 danh m\u1ee5c\\ Kh\u00e1ch h\u00e0ng<\/strong><\/p>\n<ol>\n<li style=\"list-style-type: none;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-31659\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL1.png\" alt=\"\" width=\"1438\" height=\"454\" srcset=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL1.png 1438w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL1-768x242.png 768w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL1-50x16.png 50w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL1-60x19.png 60w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL1-100x32.png 100w\" sizes=\"(max-width: 1438px) 100vw, 1438px\" \/><\/li>\n<\/ol>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>G\u00f5 <strong>M\u00e3 kh\u00e1ch h\u00e0ng<\/strong> \u0111\u00f3 v\u00e0o \u00f4 <strong>T\u00ecm ki\u1ebfm<\/strong><\/p>\n<ol>\n<li style=\"list-style-type: none;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-31661\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL2.png\" alt=\"\" width=\"1212\" height=\"421\" srcset=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL2.png 1212w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL2-768x267.png 768w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL2-50x17.png 50w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL2-60x21.png 60w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL2-100x35.png 100w\" sizes=\"(max-width: 1212px) 100vw, 1212px\" \/>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"text-align: justify;\"><strong>N\u1ebfu kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u:<\/strong> c\u1ea7n <a href=\"https:\/\/helpasp.misa.vn\/accounting\/kb\/html_11070100\/\" target=\"_blank\" rel=\"noopener\">khai b\u00e1o Kh\u00e1ch h\u00e0ng<\/a> n\u00e0y v\u00e0o danh m\u1ee5c tr\u01b0\u1edbc, sau \u0111\u00f3 nh\u1eadp kh\u1ea9u l\u1ea1i.<\/li>\n<li><strong>N\u1ebfu \u0111\u00e3 c\u00f3 d\u1eef li\u1ec7u:<\/strong> ki\u1ec3m tra m\u1ed9t s\u1ed1 gi\u1ea3i ph\u00e1p sau:\n<ul style=\"list-style-type: square;\">\n<li style=\"text-align: justify;\">Tr\u00ean file Excel, ki\u1ec3m tra l\u1ea1i M\u00e3 \u0111\u00f3 c\u00f3 b\u1ecb d\u1ea5u c\u00e1ch tr\u1eafng kh\u00f4ng th\u00ec b\u1ecf d\u1ea5u c\u00e1ch tr\u1ed1ng.<\/li>\n<li style=\"text-align: justify;\">C\u00f3 th\u1ec3 file Excel \u0111\u00f3 l\u1ed7i =&gt; T\u1ea3i l\u1ea1i file <strong>excel m\u1eabu<\/strong>, nh\u1eadp l\u1ea1i d\u1eef li\u1ec7u v\u00e0o excel, sau \u0111\u00f3 nh\u1eadp kh\u1ea9u Excel v\u00e0o ph\u1ea7n m\u1ec1m.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p><span style=\"color: #0000ff;\"><strong>Tr\u01b0\u1eddng h\u1ee3p 2: &lt;S\u1ed1 h\u00f3a \u0111\u01a1n&gt; kh\u00f4ng \u0111\u01b0\u1ee3c b\u1ecf tr\u1ed1ng<\/strong><\/span><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-31667\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL3.png\" alt=\"\" width=\"1536\" height=\"437\" srcset=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL3.png 1536w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL3-768x219.png 768w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL3-50x14.png 50w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL3-60x17.png 60w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL3-100x28.png 100w\" sizes=\"(max-width: 1536px) 100vw, 1536px\" \/><\/p>\n<ul>\n<li><strong>Nguy\u00ean nh\u00e2n: <\/strong>Do b\u01b0\u1edbc <strong>Gh\u00e9p d\u1eef li\u1ec7u<\/strong> tr\u00ean ph\u1ea7n m\u1ec1m th\u00ec \u0111ang <strong>b\u1ecb \u1ea9n c\u1ed9t S\u1ed1 h\u00f3a \u0111\u01a1n<\/strong>.<\/li>\n<li><strong>Gi\u1ea3i ph\u00e1p:<\/strong>\n<ul style=\"list-style-type: square;\">\n<li style=\"text-align: justify;\">V\u00e0o <strong>ti\u1ec7n \u00edch v\u00e0 thi\u1ebft l\u1eadp\\T\u00f9y ch\u1ecdn\\T\u00f9y ch\u1ecdn chung<\/strong><\/li>\n<li style=\"text-align: justify;\">M\u1ee5c <strong>Qu\u1ea3n l\u00fd h\u00f3a \u0111\u01a1n <\/strong>nh\u1ea5n h\u00ecnh \u270e \u0111\u1ec3 s\u1eeda<\/li>\n<li style=\"text-align: justify;\">D\u00f2ng <strong>S\u1eed d\u1ee5ng d\u1ecbch v\u1ee5 h\u00f3a \u0111\u01a1n \u0111i\u1ec7n t\u1eed MeInvoice.vn <\/strong>ch\u1ecdn <strong>Kh\u00f4ng \\ <\/strong>nh\u1ea5n <strong>C\u1ea5t<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-31669\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/4.gif\" alt=\"\" width=\"1596\" height=\"836\" \/><\/p>\n<ul style=\"list-style-type: square;\">\n<li style=\"text-align: justify;\">Sau \u0111\u00f3 nh\u1eadp kh\u1ea9u Excel l\u1ea1i. T\u1ea1i b\u01b0\u1edbc <strong>Gh\u00e9p d\u1eef li\u1ec7u<\/strong>, v\u00e0o m\u1ee5c <strong>\u1ea8n hi\u1ec7n th\u00f4ng tin <\/strong>t\u00edch hi\u1ec3n th\u1ecb <strong>c\u1ed9t S\u1ed1 h\u00f3a \u0111\u01a1n, K\u00fd hi\u1ec7u, M\u1eabu s\u1ed1<\/strong>nh\u1ea5n <strong>\u0110\u1ed3ng \u00fd <\/strong>v\u00e0 nh\u1ea5n <strong>Ti\u1ebfp t\u1ee5c<\/strong> \u0111\u1ec3 ki\u1ec3m tra.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-31671\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/5.gif\" alt=\"\" width=\"1596\" height=\"840\" \/><\/li>\n<\/ul>\n<p><span style=\"color: #0000ff;\"><strong>Tr\u01b0\u1eddng h\u1ee3p 3: \u0110\u01a1n v\u1ecb t\u00ednh &lt;&#8230;&gt; kh\u00f4ng ph\u1ea3i l\u00e0 \u0110\u01a1n v\u1ecb t\u00ednh c\u1ee7a m\u1eb7t h\u00e0ng &lt;&#8230;&gt;<\/strong><\/span><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-31673\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL4.png\" alt=\"\" width=\"1211\" height=\"292\" srcset=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL4.png 1211w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL4-768x185.png 768w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL4-50x12.png 50w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL4-60x14.png 60w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL4-100x24.png 100w\" sizes=\"(max-width: 1211px) 100vw, 1211px\" \/><\/p>\n<ul>\n<li><strong>Nguy\u00ean nh\u00e2n:<\/strong> Do \u0110\u01a1n v\u1ecb t\u00ednh c\u1ee7a m\u00e3 h\u00e0ng n\u00e0y t\u1ea1i danh m\u1ee5c V\u1eadt t\u01b0 h\u00e0ng h\u00f3a tr\u00ean ph\u1ea7n m\u1ec1m l\u00e0 <strong>ch\u01b0a c\u00f3<\/strong> ho\u1eb7c <strong>\u0111\u00e3 c\u00f3 nh\u01b0ng kh\u00e1c<\/strong> v\u1edbi \u0110VT \u0111ang nh\u1eadp tr\u00ean Excel.<\/li>\n<\/ul>\n<p><span style=\"color: #0000ff;\">V\u00ed d\u1ee5: M\u1eb7t h\u00e0ng \u00c1o s\u01a1 mi nam, tr\u00ean danh m\u1ee5c VTHH khai b\u00e1o \u0110VT l\u00e0 C\u00e1i, nh\u01b0ng tr\u00ean Excel l\u1ea1i nh\u1eadp l\u00e0 Chi\u1ebfc<\/span><br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-31675\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL5.png\" alt=\"\" width=\"1079\" height=\"579\" srcset=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL5.png 1079w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL5-768x412.png 768w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL5-50x27.png 50w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL5-60x32.png 60w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL5-100x54.png 100w\" sizes=\"(max-width: 1079px) 100vw, 1079px\" \/><\/p>\n<ul>\n<li><strong>Gi\u1ea3i ph\u00e1p:<\/strong> Ki\u1ec3m tra l\u1ea1i \u0110\u01a1n v\u1ecb t\u00ednh v\u00e0 nh\u1eadp l\u1ea1i cho kh\u1edbp, sau \u0111\u00f3 nh\u1eadp kh\u1ea9u l\u1ea1i Excel.<\/li>\n<\/ul>\n<p><span style=\"color: #0000ff;\"><strong><span style=\"font-family: inherit; font-size: inherit;\">Tr\u01b0\u1eddng h\u1ee3p 4: L\u1ed7i li\u00ean quan \u0111\u1ebfn d\u00f2ng &lt;&#8230;&gt;<\/span><\/strong><\/span><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-31677\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL6.png\" alt=\"\" width=\"979\" height=\"283\" srcset=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL6.png 979w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL6-768x222.png 768w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL6-50x14.png 50w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL6-60x17.png 60w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL6-100x29.png 100w\" sizes=\"(max-width: 979px) 100vw, 979px\" \/><\/p>\n<p><strong>Nguy\u00ean nh\u00e2n:<\/strong> Do d\u00f2ng li\u00ean quan \u0111ang b\u1ecb l\u1ed7i. V\u00ed d\u1ee5 nh\u01b0 h\u00ecnh tr\u00ean: do d\u00f2ng s\u1ed1 9 \u0111ang b\u1ecb l\u1ed7i =&gt; v\u00ec v\u1eady ch\u1ec9 c\u1ea7n ch\u1ec9nh l\u1ed7i d\u00f2ng s\u1ed1 9, th\u00ec d\u00f2ng 10 s\u1ebd nh\u1eadp kh\u1ea9u \u0111\u01b0\u1ee3c.<\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong> L\u1ecdc c\u00e2u b\u00e1o l\u1ed7i d\u00f2ng &lt;\u2026&gt; t\u01b0\u01a1ng \u1ee9ng \u0111\u1ec3 ki\u1ec3m tra v\u00e0 x\u1eed l\u00fd t\u1ea1i d\u00f2ng \u0111\u00f3.<\/p>\n<p><span style=\"color: #0000ff;\"><strong><span style=\"font-family: inherit; font-size: inherit;\">Tr\u01b0\u1eddng h\u1ee3p 5:<\/span><\/strong><strong>\u00a0S\u1ed1 ch\u1ee9ng t\u1eeb \u0111\u00e3 t\u1ed3n t\u1ea1i tr\u00ean ph\u1ea7n m\u1ec1m<\/strong><\/span><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-31679\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL7.png\" alt=\"\" width=\"768\" height=\"196\" srcset=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL7.png 768w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL7-50x13.png 50w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL7-60x15.png 60w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL7-100x26.png 100w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Nguy\u00ean nh\u00e2n<\/strong>: Do tr\u00ean d\u1eef li\u1ec7u n\u00e0y \u0111\u00e3 t\u1ed3n t\u1ea1i s\u1ed1 ch\u1ee9ng t\u1eeb \u0111ang nh\u1eadp kh\u1ea9u n\u00ean s\u1ebd kh\u00f4ng th\u1ec3 ti\u1ebfp t\u1ee5c nh\u1eadp kh\u1ea9u th\u00eam m\u1edbi v\u00e0o ph\u1ea7n m\u1ec1m.<\/p>\n<p style=\"text-align: justify;\"><strong>Gi\u1ea3i ph\u00e1p<\/strong>:<\/p>\n<ul>\n<li style=\"text-align: justify;\">Tr\u00ean d\u1eef li\u1ec7u, th\u1ef1c hi\u1ec7n t\u00ecm ch\u1ee9ng t\u1eeb theo h\u01b0\u1edbng d\u1eabn <a href=\"https:\/\/helpasp.misa.vn\/accounting\/kb\/cai-tien-chuc-nang-tim-kiem-chung-tu-tim-kiem-nang-cao-theo-nhieu-dieu-kien\/\" target=\"_blank\" rel=\"noopener\">t\u1ea1i \u0111\u00e2y<\/a><\/li>\n<li style=\"text-align: justify;\">V\u1edbi k\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm ch\u1ee9ng t\u1eeb c\u1ee7a ph\u1ea7n m\u1ec1m:\n<ul style=\"list-style-type: square;\">\n<li><strong>N\u1ebfu s\u1ed1 ch\u1ee9ng t\u1eeb \u0111\u00f3 \u0111\u00fang:<\/strong> s\u1eeda l\u1ea1i s\u1ed1 ch\u1ee9ng t\u1eeb tr\u00ean file Excel th\u00e0nh s\u1ed1 kh\u00e1c =&gt; \u0111\u1ec3 kh\u00f4ng tr\u00f9ng v\u1edbi s\u1ed1 ch\u1ee9ng t\u1eeb \u0111\u00e3 t\u1ed3n t\u1ea1i tr\u00ean ph\u1ea7n m\u1ec1m, sau \u0111\u00f3 nh\u1eadp kh\u1ea9u l\u1ea1i<\/li>\n<li><strong>N\u1ebfu s\u1ed1 ch\u1ee9ng t\u1eeb \u0111\u00f3 sai:<\/strong> x\u00f3a ch\u1ee9ng t\u1eeb sai \u0111\u00f3 tr\u00ean ph\u1ea7n m\u1ec1m, r\u1ed3i nh\u1eadp kh\u1ea9u l\u1ea1i<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong><span style=\"color: #0000ff;\">Tr\u01b0\u1eddng h\u1ee3p 6: TK&#8230; l\u00e0 T\u00e0i kho\u1ea3n t\u1ed5ng h\u1ee3p. B\u1ea1n vui l\u00f2ng nh\u1eadp t\u00e0i kho\u1ea3n chi ti\u1ebft<\/span><\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-31683 size-full\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL8.png\" alt=\"\" width=\"1393\" height=\"336\" srcset=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL8.png 1393w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL8-768x185.png 768w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL8-50x12.png 50w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL8-60x14.png 60w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL8-100x24.png 100w\" sizes=\"(max-width: 1393px) 100vw, 1393px\" \/><\/p>\n<ul>\n<li><strong>Nguy\u00ean nh\u00e2n:<\/strong> Do tr\u00ean excel, \u0111ang nh\u1eadp T\u00e0i kho\u1ea3n t\u1ed5ng h\u1ee3p, nh\u01b0ng H\u1ec7 th\u1ed1ng t\u00e0i kho\u1ea3n tr\u00ean ph\u1ea7n m\u1ec1m th\u00ec t\u00e0i kho\u1ea3n n\u00e0y c\u00f3 t\u00e0i kho\u1ea3n c\u1ea5p con<\/li>\n<li><strong>Gi\u1ea3i ph\u00e1p: <\/strong>V\u00ed d\u1ee5 tr\u00ean Excel, c\u1ed9t TK doanh thu \u0111ang nh\u1eadp l\u00e0 511.<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> V\u00e0o m\u1ee5c<strong> ti\u1ec7n \u00edch v\u00e0 thi\u1ebft l\u1eadp\\T\u1ea5t c\u1ea3 danh m\u1ee5c\\H\u1ec7 th\u1ed1ng t\u00e0i kho\u1ea3n<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> T\u00ecm \u0111\u1ebfn t\u00e0i kho\u1ea3n 511 v\u00e0 ki\u1ec3m tra:<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"list-style-type: none;\">\n<ul style=\"list-style-type: square;\">\n<li>N\u1ebfu <strong>c\u00f3<\/strong> t\u00e0i kho\u1ea3n con: c\u1ea7n nh\u1eadp tr\u00ean excel \u0111\u00fang c\u00e1c t\u00e0i kho\u1ea3n con n\u00e0y<\/li>\n<li>N\u1ebfu <strong>kh\u00f4ng c\u00f3<\/strong> t\u00e0i kho\u1ea3n con: ki\u1ec3m tra l\u1ea1i tr\u00ean excel \u0111\u00e3 nh\u1eadp \u0111\u00fang s\u1ed1 t\u00e0i kho\u1ea3n con nh\u01b0 tr\u00ean ph\u1ea7n m\u1ec1m hay ch\u01b0a<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-31681\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL9.png\" alt=\"\" width=\"1493\" height=\"526\" srcset=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL9.png 1493w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL9-768x271.png 768w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL9-50x18.png 50w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL9-60x21.png 60w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL9-100x35.png 100w\" sizes=\"(max-width: 1493px) 100vw, 1493px\" \/><br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-31685\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL10.png\" alt=\"\" width=\"884\" height=\"503\" srcset=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL10.png 884w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL10-768x437.png 768w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL10-50x28.png 50w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL10-60x34.png 60w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL10-100x57.png 100w\" sizes=\"(max-width: 884px) 100vw, 884px\" \/><\/p>\n<p><span style=\"color: #0000ff;\"><strong>Tr\u01b0\u1eddng h\u1ee3p 7: \u0110\u01a1n v\u1ecb &lt;&#8230;&gt; kh\u00f4ng c\u00f3 trong danh m\u1ee5c<\/strong><\/span><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-31687\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL11.png\" alt=\"\" width=\"1000\" height=\"257\" srcset=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL11.png 1000w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL11-768x197.png 768w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL11-50x13.png 50w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL11-60x15.png 60w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL11-100x26.png 100w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/p>\n<p><strong>Nguy\u00ean nh\u00e2n:\u00a0<\/strong><\/p>\n<ul>\n<li>Tr\u00ean file m\u1eabu Excel c\u00f3 khai b\u00e1o th\u00f4ng tin t\u1ea1i c\u1ed9t <strong>\u0110\u01a1n v\u1ecb<\/strong>, nh\u01b0ng \u0111i\u1ec1n th\u00f4ng tin <strong>T\u00ean<\/strong> \u0111\u01a1n v\u1ecb ch\u1ee9 <strong>kh\u00f4ng \u0111i\u1ec1n M\u00e3 <\/strong>\u0111\u01a1n v\u1ecb khi nh\u1eadp kh\u1ea9u s\u1ebd b\u00e1o l\u1ed7i. (L\u01b0u \u00fd ph\u1ea7n m\u1ec1m c\u0103n c\u1ee9 theo M\u00c3)<\/li>\n<li>Ho\u1eb7c trong danh s\u00e1ch ph\u00f2ng ban ch\u01b0a c\u00f3 m\u00e3 \u0111\u01a1n v\u1ecb n\u00e0y<\/li>\n<\/ul>\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong> V\u00e0o <strong>C\u01a1 c\u1ea5u t\u1ed5 ch\u1ee9c<\/strong> tr\u00ean d\u1eef li\u1ec7u ki\u1ec3m tra xem \u0111\u00e3 c\u00f3 M\u00e3 \u0111\u01a1n v\u1ecb n\u00e0y ch\u01b0a<\/p>\n<ul>\n<li>N\u1ebfu<strong> \u0111\u00e3 c\u00f3 M\u00e3 \u0111\u01a1n v\u1ecb \u0111\u00f3:<\/strong> nh\u1eadp tr\u00ean file Excel kh\u1edbp m\u00e3 \u0111\u01a1n v\u1ecb tr\u00ean ph\u1ea7n m\u1ec1m, r\u1ed3i nh\u1eadp kh\u1ea9u l\u1ea1i.<\/li>\n<li>N\u1ebfu <strong>ch\u01b0a c\u00f3 M\u00e3 \u0111\u01a1n v\u1ecb \u0111\u00f3:<\/strong>V\u00e0o\u00a0<strong>Ti\u1ec7n \u00edch v\u00e0 thi\u1ebft l\u1eadp\\T\u1ea5t c\u1ea3 danh m\u1ee5c\\C\u01a1 c\u1ea5u t\u1ed5 ch\u1ee9c\\Th\u00eam.<\/strong><\/li>\n<\/ul>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h4><strong>2.2 Nh\u1eadp kh\u1ea9u danh m\u1ee5c : Kh\u00e1ch h\u00e0ng, Nh\u00e0 cung c\u1ea5p, V\u1eadt t\u01b0 h\u00e0ng h\u00f3a,\u2026<\/strong><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><span style=\"color: #0000ff;\"><strong>Tr\u01b0\u1eddng h\u1ee3p 1: Kh\u00e1ch h\u00e0ng, Nh\u00e0 cung c\u1ea5p, V\u1eadt t\u01b0 h\u00e0ng h\u00f3a,&#8230; \u0111\u00e3 t\u1ed3n t\u1ea1i<\/strong><\/span><\/p>\n<p>V\u00ed d\u1ee5: Nh\u1eadp kh\u1ea9u danh m\u1ee5c Kh\u00e1ch h\u00e0ng t\u1eeb excel ph\u1ea7n m\u1ec1m c\u1ea3nh b\u00e1o kh\u00f4ng h\u1ee3p l\u1ec7 &#8220;<strong>Kh\u00e1ch h\u00e0ng &lt;\u2026&gt; \u0111\u00e3 t\u1ed3n t\u1ea1i<\/strong>\u201c<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-31701\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL12.png\" alt=\"\" width=\"924\" height=\"340\" srcset=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL12.png 924w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL12-768x283.png 768w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL12-50x18.png 50w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL12-60x22.png 60w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL12-100x37.png 100w\" sizes=\"(max-width: 924px) 100vw, 924px\" \/><\/p>\n<p><strong>Nguy\u00ean nh\u00e2n<\/strong>: Do <strong>M\u00e3<\/strong> c\u1ee7a Kh\u00e1ch h\u00e0ng n\u00e0y \u0111\u00e3 t\u1ed3n t\u1ea1i tr\u00ean d\u1eef li\u1ec7u (<em>L\u01b0u \u00fd l\u00e0 ph\u1ea7n m\u1ec1m c\u0103n c\u1ee9 theo M\u00c3, kh\u00f4ng c\u0103n c\u1ee9 theo T\u00ean<\/em>)<\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong> V\u00e0o <strong>Danh m\u1ee5c\\<\/strong><strong>\u0110\u1ed1i t\u01b0\u1ee3ng\\<\/strong><strong>Kh\u00e1ch h\u00e0ng<\/strong> ki\u1ec3m tra l\u1ea1i, n\u1ebfu \u0111\u00e3 c\u00f3 khai b\u00e1o th\u00ec kh\u00f4ng c\u1ea7n nh\u1eadp kh\u1ea9u th\u00eam m\u1edbi.<\/p>\n<p>*Ki\u1ec3m tra t\u01b0\u01a1ng t\u1ef1 \u0111\u1ed1i v\u1edbi c\u00e1c danh m\u1ee5c kh\u00e1c: V\u1eadt t\u01b0 h\u00e0ng h\u00f3a, Nh\u00e0 cung c\u1ea5p,\u2026<\/p>\n<p><span style=\"color: #0000ff;\"><strong>Tr\u01b0\u1eddng h\u1ee3p 2: Kh\u00f4ng th\u1ec3 thi\u1ebft l\u1eadp \u0111\u1ecbnh m\u1ee9c nguy\u00ean v\u1eadt li\u1ec7u cho v\u1eadt t\u01b0 h\u00e0ng h\u00f3a kh\u00f4ng ph\u1ea3i th\u00e0nh ph\u1ea9m<\/strong><\/span><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-31703\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL14.png\" alt=\"\" width=\"1085\" height=\"376\" srcset=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL14.png 1085w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL14-768x266.png 768w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL14-50x17.png 50w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL14-60x21.png 60w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL14-100x35.png 100w\" sizes=\"(max-width: 1085px) 100vw, 1085px\" \/><\/p>\n<ul style=\"list-style-type: disc;\">\n<li style=\"text-align: justify;\"><strong>Nguy\u00ean nh\u00e2n 1<\/strong>: X\u1ea3y ra khi nh\u1eadp kh\u1ea9u danh m\u1ee5c VTHH, tr\u00ean file Excel c\u00f3 c\u00e1c c\u1ed9t: <em>M\u00e3 Nguy\u00ean v\u1eadt li\u1ec7u, \u0110\u01a1n v\u1ecb t\u00ednh NVL, S\u1ed1 l\u01b0\u1ee3ng NVL, M\u00e3 kho\u1ea3n m\u1ee5c CP<\/em> (c\u00e1c c\u1ed9t c\u00f3 m\u00e0u t\u00edm) =&gt; c\u00e1c c\u1ed9t n\u00e0y d\u00f9ng \u0111\u1ec3 khai b\u00e1o \u0111\u1ecbnh m\u1ee9c Nguy\u00ean v\u1eadt li\u1ec7u cho Th\u00e0nh ph\u1ea9m v\u00e0 ch\u1ec9 d\u00f9ng khai b\u00e1o khi <strong>c\u1ed9t t\u00ednh ch\u1ea5t<\/strong> l\u00e0 <strong>Th\u00e0nh ph\u1ea9m<\/strong> th\u00ec m\u1edbi nh\u1eadp th\u00f4ng tin \u1edf \u0111\u00e2y, n\u1ebfu <strong>kh\u00e1c<\/strong> t\u00ednh ch\u1ea5t Th\u00e0nh ph\u1ea9m s\u1ebd b\u00e1o l\u1ed7i.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-31705\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL13.png\" alt=\"\" width=\"1169\" height=\"537\" srcset=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL13.png 1169w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL13-768x353.png 768w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL13-50x23.png 50w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL13-60x28.png 60w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL13-100x46.png 100w\" sizes=\"(max-width: 1169px) 100vw, 1169px\" \/><\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p:\u00a0<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\"><strong>N\u1ebfu nh\u1eadp kh\u1ea9u danh m\u1ee5c Th\u00e0nh ph\u1ea9m<\/strong>: tr\u00ean Excel, c\u1ed9t T\u00ednh ch\u1ea5t ph\u1ea3i ch\u1ecdn l\u00e0 <strong>Th\u00e0nh ph\u1ea9m<\/strong><\/li>\n<li style=\"text-align: justify;\"><strong>N\u1ebfu nh\u1eadp kh\u1ea9u danh m\u1ee5c <span style=\"text-decoration: underline;\">kh\u00f4ng ph\u1ea3i<\/span> Th\u00e0nh ph\u1ea9m<\/strong>: tr\u00ean Excel, b\u1ecf tr\u1ed1ng th\u00f4ng tin c\u00e1c c\u1ed9t: <em>M\u00e3 Nguy\u00ean v\u1eadt li\u1ec7u, \u0110\u01a1n v\u1ecb t\u00ednh NVL, S\u1ed1 l\u01b0\u1ee3ng NVL, M\u00e3 kho\u1ea3n m\u1ee5c CP<\/em><\/li>\n<\/ul>\n<ul style=\"list-style-type: disc;\">\n<li><strong>Nguy\u00ean nh\u00e2n 2<\/strong>: Do ch\u01b0a nh\u1eadp kh\u1ea9u <strong>M\u00e3 VTHH l\u00e0 nguy\u00ean v\u1eadt li\u1ec7u<\/strong> v\u00e0o danh m\u1ee5c tr\u01b0\u1edbc.<\/li>\n<\/ul>\n<p><strong>Gi\u1ea3i ph\u00e1p<\/strong>: Nh\u1eadp kh\u1ea9u danh m\u1ee5c M\u00e3 VTHH nguy\u00ean v\u1eadt li\u1ec7u v\u00e0o tr\u01b0\u1edbc, sau \u0111\u00f3 nh\u1eadp kh\u1ea9u danh m\u1ee5c M\u00e3 VTHH l\u00e0 Th\u00e0nh ph\u1ea9m k\u00e8m \u0110\u1ecbnh m\u1ee9c NVL.<\/p>\n<p><span style=\"color: #0000ff;\"><strong>Tr\u01b0\u1eddng h\u1ee3p 3: Nh\u00f3m Kh\u00e1ch h\u00e0ng, Nh\u00e0 cung c\u1ea5p, Nh\u00f3m VTHH &#8230; kh\u00f4ng c\u00f3 trong danh m\u1ee5c<\/strong><\/span><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-31707\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL15.png\" alt=\"\" width=\"1092\" height=\"363\" srcset=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL15.png 1092w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL15-768x255.png 768w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL15-50x17.png 50w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL15-60x20.png 60w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL15-100x33.png 100w\" sizes=\"(max-width: 1092px) 100vw, 1092px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Nguy\u00ean nh\u00e2n<\/strong>: Th\u01b0\u1eddng x\u1ea3y ra khi nh\u1eadp kh\u1ea9u danh m\u1ee5c <em>Kh\u00e1ch h\u00e0ng, Nh\u00e0 cung c\u1ea5p, VTHH.<\/em> N\u1ebfu c\u00f3 nh\u1eadp th\u00f4ng tin c\u1ed9t <em>M\u00e3 nh\u00f3m kh\u00e1ch h\u00e0ng, M\u00e3 nh\u00f3m nh\u00e0 cung c\u1ea5p hay M\u00e3 nh\u00f3m VTHH<\/em> th\u00ec <span style=\"color: #0000ff;\">m\u00e3 nh\u00f3m \u0111\u00f3 c\u1ea7n ph\u1ea3i \u0111\u01b0\u1ee3c khai b\u00e1o tr\u00ean danh m\u1ee5c tr\u01b0\u1edbc<\/span>.<\/p>\n<p style=\"text-align: justify;\"><strong>Gi\u1ea3i ph\u00e1p:\u00a0<\/strong>V\u00e0o <strong>Danh m\u1ee5c\\<\/strong><strong>\u0110\u1ed1i t\u01b0\u1ee3ng\\<\/strong><strong>Nh\u00f3m kh\u00e1ch h\u00e0ng, nh\u00e0 cung c\u1ea5p<\/strong> ki\u1ec3m tra xem tr\u00ean danh m\u1ee5c \u0111\u00e3 xem \u0111\u00e3 c\u00f3 nh\u00f3m Kh\u00e1ch h\u00e0ng, Nh\u00e0 cung c\u1ea5p \u0111\u00f3 ch\u01b0a:<\/p>\n<ul style=\"text-align: justify;\">\n<li><strong>N\u1ebfu ch\u01b0a c\u00f3:<\/strong> khai b\u00e1o b\u1ed5 sung nh\u00f3m \u0111\u00f3, r\u1ed3i nh\u1eadp kh\u1ea9u l\u1ea1i.<\/li>\n<li><strong>N\u1ebfu \u0111\u00e3 c\u00f3:<\/strong> tr\u00ean file Excel, \u0111i\u1ec1n \u0111\u00fang <strong>M\u00e3<\/strong> c\u1ee7a nh\u00f3m Kh\u00e1ch h\u00e0ng, Nh\u00e0 cung c\u1ea5p,&#8230;<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">*Ki\u1ec3m tra t\u01b0\u01a1ng t\u1ef1 \u0111\u1ed1i v\u1edbi tr\u01b0\u1eddng h\u1ee3p nh\u1eadp kh\u1ea9u Danh m\u1ee5c VTHH.<\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h4><strong>2.3 Tr\u01b0\u1eddng h\u1ee3p Kh\u00e1c<\/strong><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><span style=\"color: #0000ff;\"><strong>Kh\u00f4ng th\u1ec3 ti\u1ebfp t\u1ee5c nh\u1eadp kh\u1ea9u n\u1ebfu c\u00e1c c\u1ed9t b\u1eaft bu\u1ed9c kh\u00f4ng \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp c\u1ed9t t\u01b0\u01a1ng \u1ee9ng tr\u00ean t\u1ec7p excel. Xin vui l\u00f2ng ki\u1ec3m tra l\u1ea1i.<\/strong><\/span><\/p>\n<ul>\n<li><strong>Nguy\u00ean nh\u00e2n:<\/strong> Do t\u1ea1i d\u00f2ng \u0111\u00f3, c\u1ed9t <strong>Th\u00f4ng tin b\u1eaft bu\u1ed9c <\/strong>c\u00f3 t\u00edch v\u00e0o \u00f4, nh\u01b0ng <strong>C\u1ed9t tr\u00ean t\u1ec7p d\u1eef li\u1ec7u<\/strong> th\u00ec \u0111ang tr\u1ed1ng<\/li>\n<\/ul>\n<p>Th\u00f4ng tin b\u1eaft bu\u1ed9c tr\u00ean ph\u1ea7n m\u1ec1m c\u00f3 ngh\u0129a l\u00e0 c\u1ed9t th\u00f4ng tin n\u00e0y tr\u00ean file excel b\u1eaft bu\u1ed9c ph\u1ea3i nh\u1eadp \u0111\u1ea7y \u0111\u1ee7 t\u1ea5t c\u1ea3 c\u00e1c d\u00f2ng. Tr\u01b0\u1eddng h\u1ee3p th\u00f4ng tin kh\u00f4ng \u0111\u1ea7y \u0111\u1ee7 (d\u00f2ng c\u00f3 d\u00f2ng kh\u00f4ng), kh\u00f4ng t\u00edch v\u00e0o \u00f4 b\u1eaft bu\u1ed9c n\u00e0y, ch\u1ec9 c\u1ea7n gh\u00e9p \u0111\u00fang c\u1ed9t tr\u00ean t\u1ec7p d\u1eef li\u1ec7u ph\u1ea7n m\u1ec1m s\u1ebd nh\u1eadp kh\u1ea9u v\u00e0o. Khi t\u00edch v\u00e0o \u00f4 Th\u00f4ng tin b\u1eaft bu\u1ed9c n\u00e0y, b\u1eaft bu\u1ed9c ph\u1ea3i gh\u00e9p v\u1edbi c\u1ed9t \u0111\u00e3 c\u00f3 tr\u00ean t\u1ec7p d\u1eef li\u1ec7u.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-31709\" src=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL16.png\" alt=\"\" width=\"1235\" height=\"620\" srcset=\"\/accounting\/wp-content\/uploads\/2024\/06\/EXCEL16.png 1235w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL16-768x386.png 768w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL16-50x25.png 50w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL16-60x30.png 60w, \/accounting\/wp-content\/uploads\/2024\/06\/EXCEL16-100x50.png 100w\" sizes=\"(max-width: 1235px) 100vw, 1235px\" \/><\/p>\n<ul>\n<li><strong>Gi\u1ea3i ph\u00e1p: <\/strong>T\u1ea1i <strong>C\u1ed9t tr\u00ean t\u1ec7p d\u1eef li\u1ec7u,<\/strong> c\u1ea7n ch\u1ecdn l\u00ean th\u00f4ng tin ti\u00eau \u0111\u1ec1 c\u1ed9t c\u1ee7a Excel, sao cho t\u01b0\u01a1ng \u1ee9ng v\u1edbi C\u1ed9t tr\u00ean ph\u1ea7n m\u1ec1m, r\u1ed3i nh\u1eadp kh\u1ea9u l\u1ea1i.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":123,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"ht-kb-category":[2622],"ht-kb-tag":[],"class_list":["post-31643","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-khac-cau-hoi-thuong-gap-khi-bat-dau-su-dung"],"_links":{"self":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/31643","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/users\/123"}],"replies":[{"embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/comments?post=31643"}],"version-history":[{"count":6,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/31643\/revisions"}],"predecessor-version":[{"id":43559,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/31643\/revisions\/43559"}],"wp:attachment":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/media?parent=31643"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb-category?post=31643"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb-tag?post=31643"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}