{"id":23715,"date":"2026-11-04T11:03:20","date_gmt":"2026-11-04T04:03:20","guid":{"rendered":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/?post_type=ht_kb&#038;p=23715"},"modified":"2026-11-04T14:03:03","modified_gmt":"2026-11-04T07:03:03","slug":"thiet-lap-va-su-dung-mau-xuat-khau-du-lieu-tren-amis-tien-luong","status":"publish","type":"ht_kb","link":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/kb\/thiet-lap-va-su-dung-mau-xuat-khau-du-lieu-tren-amis-tien-luong\/","title":{"rendered":"Thi\u1ebft l\u1eadp v\u00e0 s\u1eed d\u1ee5ng m\u1eabu xu\u1ea5t kh\u1ea9u d\u1eef li\u1ec7u tr\u00ean AMIS Ti\u1ec1n l\u01b0\u01a1ng"},"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<p><strong>M\u1ee5c \u0111\u00edch:<\/strong> Gi\u00fap HR l\u01b0u l\u1ea1i c\u00e1c m\u1eabu xu\u1ea5t kh\u1ea9u v\u1edbi nh\u1eefng c\u1ed9t th\u00f4ng tin th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng \u0111\u1ec3 \u00e1p d\u1ee5ng cho c\u00e1c b\u1ea3ng l\u01b0\u01a1ng kh\u00e1c nhau, kh\u00f4ng c\u1ea7n l\u1ef1a ch\u1ecdn l\u1ea1i c\u00e1c c\u1ed9t m\u1ed7i l\u1ea7n xu\u1ea5t kh\u1ea9u. Qua \u0111\u00f3, ti\u1ebft ki\u1ec7m th\u1eddi gian, h\u1ea1n ch\u1ebf sai s\u00f3t v\u00e0 \u0111\u1ea3m b\u1ea3o d\u1eef li\u1ec7u xu\u1ea5t kh\u1ea9u th\u1ed1ng nh\u1ea5t.<\/p>\n<p><strong>N\u1ed9i dung h\u01b0\u1edbng d\u1eabn bao g\u1ed3m:<\/strong><\/p>\n<ul data-spread=\"false\">\n<li>T\u1ea1o v\u00e0 l\u01b0u m\u1eabu xu\u1ea5t kh\u1ea9u d\u1eef li\u1ec7u.<\/li>\n<li>S\u1eed d\u1ee5ng m\u1eabu \u0111\u00e3 l\u01b0u \u0111\u1ec3 xu\u1ea5t kh\u1ea9u d\u1eef li\u1ec7u.<\/li>\n<li>Ch\u1ec9nh s\u1eeda, x\u00f3a m\u1eabu xu\u1ea5t kh\u1ea9u.<\/li>\n<\/ul>\n<p><strong>\u0110\u1ed1i t\u01b0\u1ee3ng \u00e1p d\u1ee5ng:<\/strong> HR, nh\u00e2n s\u1ef1 ph\u1ee5 tr\u00e1ch t\u00ednh l\u01b0\u01a1ng.<\/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><b>2. H\u01b0\u01a1\u0301ng d\u00e2\u0303n th\u1ef1c hi\u1ec7n<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p data-pm-slice=\"1 1 &#091;&#093;\">T\u00ednh n\u0103ng <strong>Xu\u1ea5t kh\u1ea9u theo m\u1eabu<\/strong> \u00e1p d\u1ee5ng cho c\u00e1c lo\u1ea1i b\u1ea3ng d\u1eef li\u1ec7u sau tr\u00ean AMIS Ti\u1ec1n l\u01b0\u01a1ng:<\/p>\n<ul data-spread=\"false\">\n<li>B\u1ea3ng l\u01b0\u01a1ng.<\/li>\n<li>B\u1ea3ng t\u1ed5ng h\u1ee3p l\u01b0\u01a1ng.<\/li>\n<li>B\u1ea3ng ph\u00e2n b\u1ed5 l\u01b0\u01a1ng.<\/li>\n<li>B\u1ea3ng thu\u1ebf.<\/li>\n<li>B\u1ea3ng chi tr\u1ea3 l\u01b0\u01a1ng.<\/li>\n<\/ul>\n<p>C\u00e1c m\u1eabu xu\u1ea5t kh\u1ea9u \u0111\u01b0\u1ee3c l\u01b0u theo t\u1eebng lo\u1ea1i b\u1ea3ng v\u00e0 t\u1eebng ng\u01b0\u1eddi d\u00f9ng, gi\u00fap anh\/ch\u1ecb s\u1eed d\u1ee5ng l\u1ea1i trong nh\u1eefng l\u1ea7n xu\u1ea5t kh\u1ea9u ti\u1ebfp theo.<\/p>\n<h4 data-pm-slice=\"1 1 &#091;&#093;\"><strong>2.1. T\u1ea1o v\u00e0 l\u01b0u m\u1eabu xu\u1ea5t kh\u1ea9u<\/strong><\/h4>\n<p>Khi th\u01b0\u1eddng xuy\u00ean c\u1ea7n xu\u1ea5t kh\u1ea9u b\u1ea3ng l\u01b0\u01a1ng v\u1edbi c\u00f9ng m\u1ed9t s\u1ed1 c\u1ed9t th\u00f4ng tin, ch\u1eb3ng h\u1ea1n \u0111\u1ec3 in, \u0111\u1ed1i chi\u1ebfu ho\u1eb7c tr\u00ecnh k\u00fd, HR c\u00f3 th\u1ec3 t\u1ea1o m\u1eabu xu\u1ea5t kh\u1ea9u \u0111\u1ec3 s\u1eed d\u1ee5ng l\u1ea1i cho nh\u1eefng l\u1ea7n ti\u1ebfp theo. \u0110\u1ec3 th\u1ef1c hi\u1ec7n, anh\/ch\u1ecb l\u00e0m nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Tr\u00ean <strong>AMIS Ti\u1ec1n l\u01b0\u01a1ng<\/strong>, m\u1edf d\u1eef li\u1ec7u c\u1ea7n xu\u1ea5t kh\u1ea9u <em>(v\u00ed d\u1ee5: v\u00e0o ph\u00e2n h\u1ec7<strong> T\u00ednh l\u01b0\u01a1ng<\/strong>\\ ch\u1ecdn <strong>B\u1ea3ng l\u01b0\u01a1ng<\/strong>)<\/em>\\ ch\u1ecdn <strong>Xu\u1ea5t kh\u1ea9u<\/strong>\\ t\u1ea1i m\u1ee5c <strong>Xu\u1ea5t kh\u1ea9u theo m\u1eabu<\/strong>, ch\u1ecdn <strong>Th\u00eam m\u1eabu<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-23721 aligncenter\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2026\/11\/Danh-sach-_-Chi-tiet-_-Xuat-khau.png\" alt=\"\" width=\"5464\" height=\"2744\" \/><\/p>\n<p data-pm-slice=\"1 3 &#091;&#093;\"><strong>B\u01b0\u1edbc 2:<\/strong> T\u1ea1i c\u1eeda s\u1ed5 <strong>Th\u00eam m\u1eabu<\/strong>, anh\/ch\u1ecb khai b\u00e1o c\u00e1c th\u00f4ng tin:<\/p>\n<ul data-spread=\"false\">\n<li><strong>T\u00ean m\u1eabu:<\/strong> Nh\u1eadp t\u00ean \u0111\u1ec3 d\u1ec5 d\u00e0ng nh\u1eadn bi\u1ebft khi s\u1eed d\u1ee5ng.<\/li>\n<li><strong>\u0110\u1ecbnh d\u1ea1ng t\u1ec7p xu\u1ea5t kh\u1ea9u:<\/strong> Ch\u1ecdn <strong>Excel<\/strong> ho\u1eb7c <strong>PDF<\/strong>.<\/li>\n<li><strong>Danh s\u00e1ch c\u00e1c c\u1ed9t:<\/strong> T\u00edch ch\u1ecdn nh\u1eefng c\u1ed9t c\u1ea7n xu\u1ea5t kh\u1ea9u. Anh\/ch\u1ecb c\u00f3 th\u1ec3 k\u00e9o th\u1ea3 \u0111\u1ec3 thay \u0111\u1ed5i th\u1ee9 t\u1ef1 c\u00e1c c\u1ed9t theo nhu c\u1ea7u.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"size-full wp-image-23723 aligncenter\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2026\/11\/Danh-sach-_-Chi-tiet-_-Xuat-khau-_-Them-mau.png\" alt=\"\" width=\"5460\" height=\"2760\" \/><\/p>\n<p>Ri\u00eang \u0111\u1ed1i v\u1edbi <strong>B\u1ea3ng l\u01b0\u01a1ng<\/strong>, anh\/ch\u1ecb c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp th\u00eam:<\/p>\n<ul data-spread=\"false\">\n<li><strong>Xu\u1ea5t kh\u1ea9u to\u00e0n b\u1ed9 d\u1eef li\u1ec7u t\u00ednh l\u01b0\u01a1ng:<\/strong> T\u00edch ch\u1ecdn n\u1ebfu mu\u1ed1n xu\u1ea5t kh\u1ea9u \u0111\u1ea7y \u0111\u1ee7 d\u1eef li\u1ec7u t\u00ednh l\u01b0\u01a1ng.<\/li>\n<li><strong>Hi\u1ec3n th\u1ecb ch\u00fa th\u00edch v\u1ec1 c\u00f4ng th\u1ee9c t\u00ednh:<\/strong> T\u00edch ch\u1ecdn n\u1ebfu mu\u1ed1n xu\u1ea5t kh\u1ea9u k\u00e8m ch\u00fa th\u00edch c\u00f4ng th\u1ee9c.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"size-full wp-image-23725 aligncenter\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2026\/11\/Danh-sach-_-Chi-tiet-_-Xuat-khau-_-Them-mau-1.png\" alt=\"\" width=\"5460\" height=\"2760\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n <strong>L\u01b0u<\/strong> \u0111\u1ec3 ho\u00e0n t\u1ea5t. M\u1eabu v\u1eeba t\u1ea1o s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong danh s\u00e1ch <strong>Xu\u1ea5t kh\u1ea9u theo m\u1eabu<\/strong> \u0111\u1ec3 s\u1eed d\u1ee5ng cho c\u00e1c l\u1ea7n xu\u1ea5t kh\u1ea9u ti\u1ebfp theo.<\/p>\n<h4 data-pm-slice=\"1 3 &#091;&#093;\"><strong>2.2. S\u1eed d\u1ee5ng m\u1eabu \u0111\u00e3 l\u01b0u \u0111\u1ec3 xu\u1ea5t kh\u1ea9u d\u1eef li\u1ec7u<\/strong><\/h4>\n<p>Sau khi t\u1ea1o m\u1eabu, anh\/ch\u1ecb c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng l\u1ea1i m\u1eabu n\u00e0y m\u00e0 kh\u00f4ng c\u1ea7n thi\u1ebft l\u1eadp l\u1ea1i \u0111\u1ecbnh d\u1ea1ng t\u1ec7p, danh s\u00e1ch v\u00e0 th\u1ee9 t\u1ef1 c\u00e1c c\u1ed9t.<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Tr\u00ean b\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n xu\u1ea5t kh\u1ea9u, ch\u1ecdn <strong>Xu\u1ea5t kh\u1ea9u<\/strong>\\ Ch\u1ecdn m\u1eabu \u0111\u00e3 l\u01b0u trong danh s\u00e1ch. H\u1ec7 th\u1ed1ng t\u1ef1 \u0111\u1ed9ng \u00e1p d\u1ee5ng c\u00e1c thi\u1ebft l\u1eadp theo m\u1eabu \u0111\u00e3 ch\u1ecdn.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-23727 aligncenter\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2026\/11\/2026-11-04_10-36-28.png\" alt=\"\" width=\"1919\" height=\"655\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n <strong>Xu\u1ea5t kh\u1ea9u<\/strong> \u0111\u1ec3 t\u1ea3i t\u1ec7p d\u1eef li\u1ec7u v\u1ec1 thi\u1ebft b\u1ecb.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-23729 aligncenter\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2026\/11\/2026-11-04_10-37-38.png\" alt=\"\" width=\"518\" height=\"604\" \/><\/p>\n<p><strong>L\u01b0u \u00fd:<\/strong> N\u1ebfu b\u1ea3ng d\u1eef li\u1ec7u hi\u1ec7n t\u1ea1i kh\u00f4ng c\u00f3 m\u1ed9t s\u1ed1 c\u1ed9t \u0111\u00e3 thi\u1ebft l\u1eadp trong m\u1eabu, h\u1ec7 th\u1ed1ng s\u1ebd hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o \u0111\u1ec3 anh\/ch\u1ecb ki\u1ec3m tra tr\u01b0\u1edbc khi ti\u1ebfp t\u1ee5c. Khi xu\u1ea5t kh\u1ea9u, c\u00e1c c\u1ed9t kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ec3 tr\u1ed1ng.<\/p>\n<h4><strong>2.3. Ch\u1ec9nh s\u1eeda ho\u1eb7c x\u00f3a m\u1eabu xu\u1ea5t kh\u1ea9u<\/strong><\/h4>\n<p>Trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng, anh\/ch\u1ecb c\u00f3 th\u1ec3 thay \u0111\u1ed5i ho\u1eb7c x\u00f3a c\u00e1c m\u1eabu xu\u1ea5t kh\u1ea9u \u0111\u00e3 l\u01b0u.<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Tr\u00ean b\u1ea3ng d\u1eef li\u1ec7u, ch\u1ecdn <strong>Xu\u1ea5t kh\u1ea9u.<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> T\u1ea1i m\u1ee5c Xu\u1ea5t kh\u1ea9u theo m\u1eabu, anh\/ch\u1ecb c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n:<\/p>\n<ul data-spread=\"false\">\n<li>Nh\u1ea5n v\u00e0o <em><strong>bi\u1ec3u t\u01b0\u1ee3ng c\u00e2y b\u00fat <\/strong><\/em>\u0111\u1ec3 <strong>S\u1eeda:<\/strong> C\u1eadp nh\u1eadt t\u00ean m\u1eabu, \u0111\u1ecbnh d\u1ea1ng t\u1ec7p, danh s\u00e1ch ho\u1eb7c th\u1ee9 t\u1ef1 c\u00e1c c\u1ed9t. Nh\u1ea5n <strong>L\u01b0u<\/strong> \u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/li>\n<li>Nh\u1ea5n v\u00e0o <strong><em>bi\u1ec3u t\u01b0\u1ee3ng th\u00f9ng r\u00e1c <\/em><\/strong>\u0111\u1ec3 <strong>X\u00f3a:<\/strong> Nh\u1ea5n <strong>X\u00f3a<\/strong> v\u00e0 x\u00e1c nh\u1eadn \u0111\u1ec3 x\u00f3a m\u1eabu kh\u00f4ng c\u00f2n s\u1eed d\u1ee5ng.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"size-full wp-image-23731 aligncenter\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2026\/11\/Danh-sach-_-Chi-tiet-_-Xuat-khau-1.png\" alt=\"\" width=\"5464\" height=\"2744\" \/><\/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>3. L\u01b0u \u00fd<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul>\n<li>M\u1eabu xu\u1ea5t kh\u1ea9u \u0111\u01b0\u1ee3c l\u01b0u theo t\u1eebng ng\u01b0\u1eddi d\u00f9ng v\u00e0 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng l\u1ea1i tr\u00ean c\u00e1c b\u1ea3ng l\u01b0\u01a1ng c\u00f9ng lo\u1ea1i.<\/li>\n<li>T\u00ednh n\u0103ng \u00e1p d\u1ee5ng cho <strong>B\u1ea3ng l\u01b0\u01a1ng, B\u1ea3ng t\u1ed5ng h\u1ee3p l\u01b0\u01a1ng, B\u1ea3ng ph\u00e2n b\u1ed5 l\u01b0\u01a1ng, B\u1ea3ng thu\u1ebf v\u00e0 B\u1ea3ng chi tr\u1ea3 l\u01b0\u01a1ng<\/strong>.<\/li>\n<li>Khi s\u1eed d\u1ee5ng m\u1eabu tr\u00ean b\u1ea3ng l\u01b0\u01a1ng c\u00f3 c\u00e1c c\u1ed9t th\u00f4ng tin kh\u00e1c nhau, anh\/ch\u1ecb n\u00ean ki\u1ec3m tra d\u1eef li\u1ec7u xu\u1ea5t kh\u1ea9u \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u s\u1eed d\u1ee5ng.<\/li>\n<\/ul>\n<\/div><\/div>\n<\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp;<\/p>\n","protected":false},"author":141,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[317],"ht-kb-tag":[],"class_list":["post-23715","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-r75-phat-hanh-ngay-05-11-2026"],"_links":{"self":[{"href":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/23715","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/users\/141"}],"replies":[{"embeddable":true,"href":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/comments?post=23715"}],"version-history":[{"count":3,"href":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/23715\/revisions"}],"predecessor-version":[{"id":23739,"href":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/23715\/revisions\/23739"}],"wp:attachment":[{"href":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/media?parent=23715"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb-category?post=23715"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb-tag?post=23715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}