{"id":20816,"date":"2022-05-10T11:55:25","date_gmt":"2022-05-10T04:55:25","guid":{"rendered":"http:\/\/helpact.misa.vn\/?post_type=ht_kb&#038;p=20816"},"modified":"2025-12-24T10:21:29","modified_gmt":"2025-12-24T03:21:29","slug":"khong-bat-buoc-nhap-ma-hang-khi-nhap-chung-tu-tu-excel","status":"publish","type":"ht_kb","link":"http:\/\/helpasp.misa.vn\/accounting\/kb\/khong-bat-buoc-nhap-ma-hang-khi-nhap-chung-tu-tu-excel\/","title":{"rendered":"Kh\u00f4ng b\u1eaft bu\u1ed9c nh\u1eadp m\u00e3 h\u00e0ng khi nh\u1eadp ch\u1ee9ng t\u1eeb t\u1eeb excel"},"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><b>1. T\u1ed5ng quan<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<b>M\u1ee5c \u0111\u00edch:<\/b> H\u01b0\u1edbng d\u1eabn v\u1ec1 t\u00ednh n\u0103ng cho ph\u00e9p b\u1ecf tr\u1ed1ng m\u00e3 h\u00e0ng khi nh\u1eadp ch\u1ee9ng t\u1eeb t\u1eeb excel, gi\u00fap ph\u1ea7n m\u1ec1m t\u1ef1 \u0111\u1ed9ng t\u00ecm ki\u1ebfm m\u00e3 h\u00e0ng ph\u00f9 h\u1ee3p, ti\u1ebft ki\u1ec7m th\u1eddi gian cho ng\u01b0\u1eddi d\u00f9ng khi m\u00e3 h\u00e0ng kh\u00f4ng c\u00f3 s\u1eb5n tr\u00ean file nh\u1eadp kh\u1ea9u.<br \/>\n<b>N\u1ed9i dung:<\/b><\/p>\n<ul>\n<li>Gi\u1edbi thi\u1ec7u t\u00ednh n\u0103ng nh\u1eadp ch\u1ee9ng t\u1eeb t\u1eeb excel kh\u00f4ng b\u1eaft bu\u1ed9c m\u00e3 h\u00e0ng.<\/li>\n<\/ul>\n<p><b>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/b> K\u1ebf to\u00e1n d\u1ecbch v\u1ee5, ng\u01b0\u1eddi nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb t\u1eeb excel <\/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><b>2. Chi ti\u1ebft thay \u0111\u1ed5i<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul style=\"list-style-type: disc;\">\n<li><strong>T\u1eeb tr\u01b0\u1edbc phi\u00ean b\u1ea3n RC9:\u00a0<\/strong>\n<ul>\n<li>\u0110\u1ed1i v\u1edbi c\u00e1c kh\u00e1ch h\u00e0ng c\u1ee7a KTDV c\u00f3 s\u1eed d\u1ee5ng c\u00e1c ph\u1ea7n m\u1ec1m b\u00e1n h\u00e0ng, d\u1eef li\u1ec7u b\u00e1n h\u00e0ng ph\u00e1t sinh s\u1ebd \u0111\u01b0\u1ee3c k\u1ebft xu\u1ea5t t\u1eeb ph\u1ea7n m\u1ec1m b\u00e1n h\u00e0ng ra excel \u0111\u1ec3 nh\u1eadp kh\u1ea9u v\u00e0o ASP K\u1ebf to\u00e1n \u0111\u1ec3 h\u1ea1ch to\u00e1n.<\/li>\n<li>Do tr\u00ean c\u00e1c ph\u1ea7n m\u1ec1m b\u00e1n h\u00e0ng ch\u1ec9 c\u00f3 t\u00ean h\u00e0ng ch\u1ee9 kh\u00f4ng c\u00f3 m\u00e3 h\u00e0ng. Do v\u1eady khi nh\u1eadp v\u00e0o ASP K\u1ebf to\u00e1n th\u00ec ng\u01b0\u1eddi s\u00f9ng s\u1ebd ph\u1ea3i t\u1ef1 x\u00e1c \u0111\u1ecbnh m\u00e3 h\u00e0ng \u0111\u1ec3 \u0111i\u1ec1n v\u00e0o file nh\u1eadp kh\u1ea9u. Vi\u1ec7c n\u00e0y g\u00e2y m\u1ea5t nhi\u1ec1u th\u1eddi gian cho KTDV.<\/li>\n<li>Ngo\u00e0i ra c\u0169ng c\u00f3 tr\u01b0\u1eddng h\u1ee3p m\u00e3 h\u00e0ng tr\u00ean d\u1eef li\u1ec7u n\u1ed9i b\u1ed9 kh\u00e1c v\u1edbi tr\u00ean d\u1eef li\u1ec7u thu\u1ebf n\u00ean khi t\u1eadn d\u1ee5ng d\u1eef li\u1ec7u n\u1ed9i b\u1ed9\u00a0 \u0111\u1ec3 nh\u1eadp kh\u1ea9u v\u00e0o d\u1eef li\u1ec7u thu\u1ebf th\u00ec KTDV ph\u1ea3i t\u1ef1 s\u1eeda l\u1ea1i m\u00e3 h\u00e0ng cho ph\u00f9 h\u1ee3p.<\/li>\n<\/ul>\n<\/li>\n<li><strong>T\u1eeb phi\u00ean b\u1ea3n RC9 tr\u1edf \u0111i:<\/strong>\n<ul>\n<li>Ch\u01b0\u01a1ng tr\u00ecnh kh\u00f4ng b\u1eaft bu\u1ed9c ng\u01b0\u1eddi d\u00f9ng ph\u1ea3i nh\u1eadp m\u00e3 h\u00e0ng khi nh\u1eadp ch\u1ee9ng t\u1eeb t\u1eeb excel.<\/li>\n<\/ul>\n<\/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<h3><strong>3. H\u01b0\u1edbng d\u1eabn tr\u00ean ph\u1ea7n m\u1ec1m<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p>V\u00ed d\u1ee5 <strong>Ch\u1ee9ng t\u1eeb mua h\u00e0ng<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0Ch\u1ecdn ph\u00e2n h\u1ec7 c\u1ea7n th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb, tr\u00ean giao di\u1ec7n danh s\u00e1ch ch\u1ecdn m\u0169i t\u00ean\u00a0<span data-sheets-root=\"1\">\u23f7<\/span>\u00a0ch\u1ee9c n\u0103ng\u00a0<strong>Th\u00eam,<\/strong>\u00a0ch\u1ecdn ti\u1ec7n \u00edch\u00a0<strong>Nh\u1eadp t\u1eeb excel<\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-24556\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2018\/12\/44.png\" sizes=\"auto, (max-width: 1271px) 100vw, 1271px\" srcset=\"\/accounting\/wp-content\/uploads\/2018\/12\/44.png 1271w, \/accounting\/wp-content\/uploads\/2018\/12\/44-768x286.png 768w, \/accounting\/wp-content\/uploads\/2018\/12\/44-50x19.png 50w, \/accounting\/wp-content\/uploads\/2018\/12\/44-60x22.png 60w, \/accounting\/wp-content\/uploads\/2018\/12\/44-100x37.png 100w\" alt=\"\" width=\"1271\" height=\"474\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong>\u00a0Ch\u01b0\u01a1ng tr\u00ecnh hi\u1ec3n th\u1ecb giao di\u1ec7n t\u01b0\u01a1ng t\u1ef1 nh\u01b0 nh\u1eadp kh\u1ea9u danh m\u1ee5c<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-24557\" src=\"https:\/\/helpasp.misa.vn\/accounting\/wp-content\/uploads\/2018\/12\/45.png\" sizes=\"auto, (max-width: 1262px) 100vw, 1262px\" srcset=\"\/accounting\/wp-content\/uploads\/2018\/12\/45.png 1262w, \/accounting\/wp-content\/uploads\/2018\/12\/45-768x329.png 768w, \/accounting\/wp-content\/uploads\/2018\/12\/45-50x21.png 50w, \/accounting\/wp-content\/uploads\/2018\/12\/45-60x26.png 60w, \/accounting\/wp-content\/uploads\/2018\/12\/45-100x43.png 100w\" alt=\"\" width=\"1262\" height=\"540\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3: Ch\u1ecdn t\u1ec7p ngu\u1ed3n:<\/strong><\/p>\n<ul>\n<li>Ch\u1ecdn \u0111\u00fang lo\u1ea1i ch\u1ee9ng t\u1eeb tr\u01b0\u1edbc khi ch\u1ecdn file d\u1eef li\u1ec7u ho\u1eb7c t\u1ea3i file m\u1eabu \u0111\u1ec3 tr\u00e1nh ph\u00e1t sinh l\u1ed7i \u1edf c\u00e1c b\u01b0\u1edbc sau do sai \u0111\u1ecbnh d\u1ea1ng, th\u00f4ng tin d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp kh\u1ea9u c\u1ee7a m\u1ed7i lo\u1ea1i ch\u1ee9ng t\u1eeb.<\/li>\n<li>Ch\u1ec9 nh\u1eadp kh\u1ea9u th\u00eam m\u1edbi ch\u1ee9ng t\u1eeb.<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 4:<\/strong>\u00a0<strong>Gh\u00e9p d\u1eef li\u1ec7u<\/strong>: T\u01b0\u01a1ng t\u1ef1 nh\u01b0 khi nh\u1eadp kh\u1ea9u danh m\u1ee5c c\u00f3 th\u1ec3 gh\u00e9p \u0111\u01b0\u1ee3c c\u00e1c c\u1ed9t d\u1eef li\u1ec7u tr\u00ean file nh\u1eadp kh\u1ea9u v\u00e0 tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh<\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong>\u00a0<strong>Ki\u1ec3m tra d\u1eef li\u1ec7u<\/strong>: Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 d\u1eef li\u1ec7u h\u1ee3p l\u1ec7 ho\u1eb7c kh\u00f4ng h\u1ee3p l\u1ec7 tr\u00ean file d\u1eef li\u1ec7u c\u00f3 th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh ho\u1eb7c ti\u1ebfn h\u00e0nh nh\u1eadp d\u1eef li\u1ec7u lu\u00f4n.<\/p>\n<p><strong>B\u01b0\u1edbc 6:<\/strong>\u00a0<strong>Th\u00f4ng b\u00e1o k\u1ebft qu\u1ea3 nh\u1eadp li\u1ec7u<\/strong><\/p>\n<p>Xem chi ti\u1ebft vi\u1ec7c nh\u1eadp ch\u1ee9ng t\u1eeb t\u1eeb excel theo h\u01b0\u1edbng d\u1eabn<a href=\"https:\/\/helpasp.misa.vn\/accounting\/kb\/html_10050000\/\" target=\"_blank\" rel=\"noopener\"><strong>\u00a0t\u1ea1i \u0111\u00e2y<\/strong><\/a>.<\/p>\n<p>&nbsp;<\/p>\n<\/div><\/div> <\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":115,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"ht-kb-category":[3487],"ht-kb-tag":[],"class_list":["post-20816","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-rc9-phat-hanh-ngay-12-05-2022"],"_links":{"self":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/20816","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\/115"}],"replies":[{"embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/comments?post=20816"}],"version-history":[{"count":4,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/20816\/revisions"}],"predecessor-version":[{"id":55185,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/20816\/revisions\/55185"}],"wp:attachment":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/media?parent=20816"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb-category?post=20816"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb-tag?post=20816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}