{"id":20951,"date":"2022-05-17T09:03:55","date_gmt":"2022-05-17T02:03:55","guid":{"rendered":"http:\/\/helpact.misa.vn\/?post_type=ht_kb&#038;p=20951"},"modified":"2025-12-02T08:58:00","modified_gmt":"2025-12-02T01:58:00","slug":"cho-phep-sao-chep-tung-cot-du-lieu-tu-file-excel-de-dan-vao-giao-dien-nhap-lieu-tren-phan-he-kho","status":"publish","type":"ht_kb","link":"http:\/\/helpasp.misa.vn\/accounting\/kb\/cho-phep-sao-chep-tung-cot-du-lieu-tu-file-excel-de-dan-vao-giao-dien-nhap-lieu-tren-phan-he-kho\/","title":{"rendered":"Cho ph\u00e9p sao ch\u00e9p t\u1eebng c\u1ed9t d\u1eef li\u1ec7u t\u1eeb file excel \u0111\u1ec3 d\u00e1n v\u00e0o giao di\u1ec7n nh\u1eadp li\u1ec7u tr\u00ean ph\u00e2n h\u1ec7 B\u00e1n h\u00e0ng v\u00e0 ph\u00e2n h\u1ec7 Kho"},"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>H\u01b0\u1edbng d\u1eabn c\u00e1ch sao ch\u00e9p t\u1eebng c\u1ed9t d\u1eef li\u1ec7u t\u1eeb file Excel \u0111\u1ec3 d\u00e1n v\u00e0o giao di\u1ec7n nh\u1eadp li\u1ec7u tr\u00ean ph\u00e2n h\u1ec7 B\u00e1n h\u00e0ng v\u00e0 Kho, gi\u00fap ng\u01b0\u1eddi d\u00f9ng thu\u1eadn ti\u1ec7n h\u01a1n trong qu\u00e1 tr\u00ecnh th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c.<\/p>\n<p><strong>N\u1ed9i dung:<\/strong> Gi\u1edbi thi\u1ec7u t\u00ednh n\u0103ng sao ch\u00e9p c\u1ed9t d\u1eef li\u1ec7u t\u1eeb Excel v\u00e0o ph\u1ea7n m\u1ec1m v\u00e0 ph\u1ea1m vi \u00e1p d\u1ee5ng tr\u00ean c\u00e1c ch\u1ee9ng t\u1eeb thu\u1ed9c ph\u00e2n h\u1ec7 B\u00e1n h\u00e0ng v\u00e0 Kho<\/p>\n<p><strong>Ph\u1ea1m vi \u00e1p d\u1ee5ng<\/strong>: K\u1ebf to\u00e1n b\u00e1n h\u00e0ng, K\u1ebf to\u00e1n kho, Qu\u1ea3n l\u00fd kho<\/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. Chi ti\u1ebft thay \u0111\u1ed5i<\/strong><\/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 R33:<\/strong> Ch\u01b0\u01a1ng tr\u00ecnh ch\u01b0a \u0111\u00e1p \u1ee9ng vi\u1ec7c sao ch\u00e9p c\u00e1c c\u1ed9t d\u1eef li\u1ec7u t\u1eeb file Excel ngo\u00e0i ph\u1ea7n m\u1ec1m \u0111\u1ec3 d\u00e1n v\u00e0o c\u00e1c ch\u1ee9ng t\u1eeb nh\u1eadp, xu\u1ea5t, chuy\u1ec3n kho tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh ho\u1eb7c d\u1eef li\u1ec7u l\u1ea5y t\u1eeb b\u00ean ngo\u00e0i ph\u1ea7n m\u1ec1m kh\u00f4ng t\u1ef1 \u0111\u1ed9ng t\u00e1ch ra \u0111\u01b0\u1ee3c t\u1eebng d\u00f2ng ch\u1ee9ng t\u1eeb ri\u00eang bi\u1ec7t. <strong>V\u00ed d\u1ee5:<\/strong> Khi sao ch\u00e9p tr\u00ean file Excel l\u00e0 10 m\u00e3 VTHH t\u01b0\u01a1ng \u1ee9ng v\u1edbi 10 d\u00f2ng th\u00ec khi d\u00e1n v\u00e0o ch\u1ee9ng t\u1eeb, 10 m\u00e3 VTHH \u0111\u00f3 l\u1ea1i d\u1ed3n v\u00e0o 1 \u00f4 \u0111\u1ea7u ti\u00ean tr\u00ean ch\u1ee9ng t\u1eeb, khi\u1ebfn ng\u01b0\u1eddi d\u00f9ng m\u1ea5t th\u1eddi gian v\u00e0 kh\u00f4ng thu\u1eadn ti\u1ec7n khi t\u1ea1o ch\u1ee9ng t\u1eeb.<\/li>\n<li><strong>T\u1eeb phi\u00ean b\u1ea3n R33 tr\u1edf \u0111i:<\/strong>\n<ul>\n<li>Ch\u01b0\u01a1ng tr\u00ecnh cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng sao ch\u00e9p t\u1eebng c\u1ed9t d\u1eef li\u1ec7u t\u1eeb file Excel \u0111\u1ec3 d\u00e1n v\u00e0o giao di\u1ec7n nh\u1eadp li\u1ec7u, gi\u00fap ng\u01b0\u1eddi d\u00f9ng ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 thu\u1eadn ti\u1ec7n h\u01a1n khi l\u1eadp ch\u1ee9ng t\u1eeb.<\/li>\n<li>Ph\u1ea1m vi c\u00e1c ch\u1ee9ng t\u1eeb \u0111\u00e1p \u1ee9ng trong phi\u00ean b\u1ea3n R33:\n<ul>\n<li>Ph\u00e2n h\u1ec7 <strong>B\u00e1n h\u00e0ng<\/strong>: Ch\u1ee9ng t\u1eeb gi\u1ea3m gi\u00e1 h\u00e0ng b\u00e1n, tr\u1ea3 l\u1ea1i h\u00e0ng b\u00e1n.<\/li>\n<li>Ph\u00e2n h\u1ec7 <strong>Kho<\/strong>: Phi\u1ebfu nh\u1eadp kho.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div><\/div>\n<\/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":[3488],"ht-kb-tag":[],"class_list":["post-20951","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-r33"],"_links":{"self":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/20951","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=20951"}],"version-history":[{"count":4,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/20951\/revisions"}],"predecessor-version":[{"id":40823,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb\/20951\/revisions\/40823"}],"wp:attachment":[{"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/media?parent=20951"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb-category?post=20951"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"http:\/\/helpasp.misa.vn\/accounting\/wp-json\/wp\/v2\/ht-kb-tag?post=20951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}