{"id":14077,"date":"2020-11-13T11:02:30","date_gmt":"2020-11-13T04:02:30","guid":{"rendered":"http:\/\/help.sme2021.misa.local\/?post_type=ht_kb&#038;p=14077"},"modified":"2022-06-21T16:40:54","modified_gmt":"2022-06-21T09:40:54","slug":"copy-du-lieu-tu-excel-vao-chung-tu","status":"publish","type":"ht_kb","link":"https:\/\/helpsme.misa.vn\/2022\/kb\/copy-du-lieu-tu-excel-vao-chung-tu\/","title":{"rendered":"Copy d\u1eef li\u1ec7u t\u1eeb excel v\u00e0o ch\u1ee9ng t\u1eeb"},"content":{"rendered":"<p><span style=\"font-size: 14pt;\"><strong>1. N\u1ed9i dung<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px; text-align: justify;\">Cho ph\u00e9p copy tr\u1ef1c ti\u1ebfp t\u1eebng c\u1ed9t d\u1eef li\u1ec7u tr\u00ean Excel \u0111\u1ec3 d\u00e1n v\u00e0o giao di\u1ec7n nh\u1eadp li\u1ec7u, gi\u00fap nh\u1eadp li\u1ec7u nhanh ch\u00f3ng m\u00e0 kh\u00f4ng ph\u1ea3i t\u1ea1o file nh\u1eadp kh\u1ea9u t\u1eeb Excel.<\/p>\n<p style=\"padding-left: 40px;\">Ch\u01b0\u01a1ng tr\u00ecnh \u0111\u00e1p \u1ee9ng copy d\u1eef li\u1ec7u t\u1eeb excel tr\u00ean c\u00e1c ch\u1ee9ng t\u1eeb sau:<\/p>\n<table style=\"height: 312px; width: 747px;\">\n<tbody>\n<tr style=\"height: 22px;\">\n<td style=\"height: 22px; width: 146.684px; text-align: center;\"><strong>Ph\u00e2n h\u1ec7 Mua h\u00e0ng<\/strong><\/td>\n<td style=\"height: 22px; width: 147.118px; text-align: center;\"><strong>Ph\u00e2n h\u1ec7 B\u00e1n h\u00e0ng<\/strong><\/td>\n<td style=\"width: 141.354px; text-align: center;\"><strong>Ph\u00e2n h\u1ec7 ng\u00e2n s\u00e1ch<\/strong><\/td>\n<td style=\"width: 141.389px; text-align: center;\"><strong>Ph\u00e2n h\u1ec7 kho<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 22px;\">\n<td style=\"height: 22px; width: 146.684px;\">1. \u0110\u01a1n mua h\u00e0ng<br \/>\n2. H\u1ee3p \u0111\u1ed3ng mua h\u00e0ng<br \/>\n3. Ch\u1ee9ng t\u1eeb mua h\u00e0ng ho\u00e1<br \/>\n4. Ch\u1ee9ng t\u1eeb mua h\u00e0ng ho\u00e1 nhi\u1ec1u ho\u00e1 \u0111\u01a1n<br \/>\n5. Ch\u1ee9ng t\u1eeb mua d\u1ecbch v\u1ee5<br \/>\n6. Ch\u1ee9ng t\u1eeb tr\u1ea3 l\u1ea1i h\u00e0ng mua<br \/>\n7. Ch\u1ee9ng t\u1eeb gi\u1ea3m gi\u00e1 h\u00e0ng mua<\/td>\n<td style=\"height: 22px; width: 147.118px;\">1. B\u00e1o gi\u00e1<br \/>\n2. \u0110\u01a1n \u0111\u1eb7t h\u00e0ng<br \/>\n3. Ch\u1ee9ng t\u1eeb b\u00e1n h\u00e0ng<br \/>\n4. Ho\u00e1 \u0111\u01a1n &amp; h\u00f3a \u0111\u01a1n \u0111i\u1ec1u ch\u1ec9nh<br \/>\n5. Ch\u1ee9ng t\u1eeb gi\u1ea3m gi\u00e1 h\u00e0ng b\u00e1n<br \/>\n6. Ch\u1ee9ng t\u1eeb tr\u1ea3 l\u1ea1i h\u00e0ng b\u00e1n<\/td>\n<td style=\"width: 141.354px;\">1. L\u1eadp d\u1ef1 to\u00e1n ng\u00e2n s\u00e1ch<\/td>\n<td style=\"width: 141.389px;\">1. Phi\u1ebfu nh\u1eadp kho<br \/>\n2. Phi\u1ebfu xu\u1ea5t kho<br \/>\n3. Phi\u1ebfu chuy\u1ec3n kho<br \/>\n4. L\u1ec7nh s\u1ea3n xu\u1ea5t<br \/>\n5. L\u1ec7nh l\u1eafp r\u00e1p, th\u00e1o d\u1ee1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-size: 14pt;\"><strong>2. H\u01b0\u1edbng d\u1eabn<\/strong><\/span><\/p>\n<p>Ch\u1ee9c n\u0103ng copy d\u1eef li\u1ec7u t\u1eeb excel \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 40px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14249\" src=\"https:\/\/helpsme.misa.vn\/2022\/wp-content\/uploads\/2020\/11\/copyexcel.gif\" alt=\"\" width=\"1420\" height=\"1000\" \/><\/p>\n<p><em><strong>L\u01b0u \u00fd:<\/strong><\/em><\/p>\n<ul>\n<li><em>Ch\u1ec9 c\u00f3 th\u1ec3 copy \u0111\u01b0\u1ee3c t\u1eebng c\u1ed9t, kh\u00f4ng th\u1ec3 copy nhi\u1ec1u c\u1ed9t c\u00f9ng l\u00fac. C\u00e1c c\u1ed9t c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c ch\u1ee9c n\u0103ng copy t\u1eeb excel bao g\u1ed3m: <strong>M\u00e3 h\u00e0ng; T\u00ean h\u00e0ng; \u0110\u01a1n v\u1ecb t\u00ednh; \u0110\u01a1n gi\u00e1; S\u1ed1 l\u01b0\u1ee3ng; Ti\u1ec1n chi\u1ebft kh\u1ea5u; T\u1ef7 l\u1ec7 chi\u1ebft kh\u1ea5u; % thu\u1ebf su\u1ea5t GTGT, Tr\u01b0\u1eddng m\u1edf r\u1ed9ng.<\/strong><\/em><\/li>\n<li><em>Sau khi copy c\u1ed9t\u00a0<strong>M\u00e3 h\u00e0ng\u00a0<\/strong>ho\u1eb7c c\u1ed9t\u00a0<strong>T\u00ean h\u00e0ng<\/strong>, n\u1ebfu tr\u00f9ng v\u1edbi m\u1eb7t h\u00e0ng \u0111\u00e3 c\u00f3 trong danh m\u1ee5c, ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd t\u1ef1 \u0111\u1ed9ng nh\u1eadn di\u1ec7n v\u00e0 \u0111i\u1ec1n c\u00e1c th\u00f4ng tin c\u00f2n l\u1ea1i nh\u01b0 T\u00ean h\u00e0ng\/M\u00e3 h\u00e0ng\/\u0110VT\/\u0110\u01a1n gi\u00e1&#8230;<\/em><\/li>\n<li><em>N\u1ebfu\u00a0<strong>M\u00e3 h\u00e0ng\/T\u00ean h\u00e0ng <\/strong>ch\u01b0a c\u00f3 trong danh m\u1ee5c, K\u1ebf to\u00e1n ph\u1ea3i t\u1ef1 ch\u1ecdn l\u1ea1i m\u00e3 h\u00e0ng \u0111\u00e3 c\u00f3 ho\u1eb7c t\u1ea1o m\u1edbi m\u00e3 h\u00e0ng.<\/em><\/li>\n<li><em>N\u1ebfu g\u1eb7p l\u1ed7i \u0111\u1ecbnh d\u1ea1ng s\u1ed1 khi copy d\u1eef li\u1ec7u t\u1eeb excel v\u00e0o c\u1ed9t ph\u1ea7n m\u1ec1m.Tham kh\u1ea3o h\u01b0\u1edbng d\u1eabn kh\u1eafc ph\u1ee5c <a href=\"https:\/\/helpsme.misa.vn\/2022\/kb\/loi-dinh-dang-so-khi-sao-chep-nhieu-dong-excel-vao-cot-tren-giao-dien-lap-chung-tu\/\" target=\"_blank\" rel=\"noopener\">T\u1ea1i \u0111\u00e2y<\/a><\/em><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>1. N\u1ed9i dung Cho ph\u00e9p copy tr\u1ef1c ti\u1ebfp t\u1eebng c\u1ed9t d\u1eef li\u1ec7u tr\u00ean Excel \u0111\u1ec3 d\u00e1n v\u00e0o giao di\u1ec7n nh\u1eadp li\u1ec7u, gi\u00fap nh\u1eadp li\u1ec7u nhanh ch\u00f3ng m\u00e0 kh\u00f4ng ph\u1ea3i t\u1ea1o file nh\u1eadp kh\u1ea9u t\u1eeb Excel. Ch\u01b0\u01a1ng tr\u00ecnh \u0111\u00e1p \u1ee9ng copy d\u1eef li\u1ec7u t\u1eeb excel tr\u00ean c\u00e1c ch\u1ee9ng t\u1eeb sau: Ph\u00e2n&#8230;<\/p>\n","protected":false},"author":133,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[2566],"ht-kb-tag":[],"class_list":["post-14077","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-huong-dan-4__khac"],"_links":{"self":[{"href":"https:\/\/helpsme.misa.vn\/2022\/wp-json\/wp\/v2\/ht-kb\/14077","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpsme.misa.vn\/2022\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/helpsme.misa.vn\/2022\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2022\/wp-json\/wp\/v2\/users\/133"}],"replies":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2022\/wp-json\/wp\/v2\/comments?post=14077"}],"version-history":[{"count":20,"href":"https:\/\/helpsme.misa.vn\/2022\/wp-json\/wp\/v2\/ht-kb\/14077\/revisions"}],"predecessor-version":[{"id":26246,"href":"https:\/\/helpsme.misa.vn\/2022\/wp-json\/wp\/v2\/ht-kb\/14077\/revisions\/26246"}],"wp:attachment":[{"href":"https:\/\/helpsme.misa.vn\/2022\/wp-json\/wp\/v2\/media?parent=14077"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2022\/wp-json\/wp\/v2\/ht-kb-category?post=14077"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2022\/wp-json\/wp\/v2\/ht-kb-tag?post=14077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}