{"id":46345,"date":"2026-04-07T15:02:04","date_gmt":"2026-04-07T08:02:04","guid":{"rendered":"https:\/\/qltshelp.misa.vn\/?post_type=ht_kb&p=46345"},"modified":"2026-04-07T16:47:09","modified_gmt":"2026-04-07T09:47:09","slug":"lam-the-nao-de-xuat-file-excel-bao-cao-tscd-day-du-thong-tin-ten-tai-san-phong-ban-nam-san-xuat-nuoc-san-xuat-seri-model-gia-tri-nguoi-su-dung","status":"publish","type":"ht_kb","link":"\/tai-san\/knowledge-base\/lam-the-nao-de-xuat-file-excel-bao-cao-tscd-day-du-thong-tin-ten-tai-san-phong-ban-nam-san-xuat-nuoc-san-xuat-seri-model-gia-tri-nguoi-su-dung\/","title":{"rendered":"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 xu\u1ea5t file Excel b\u00e1o c\u00e1o TSC\u0110 \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin (t\u00ean t\u00e0i s\u1ea3n, ph\u00f2ng ban, n\u0103m s\u1ea3n xu\u1ea5t, n\u01b0\u1edbc s\u1ea3n xu\u1ea5t, seri, model, gi\u00e1 tr\u1ecb, ng\u01b0\u1eddi s\u1eed d\u1ee5ng\u2026)?"},"content":{"rendered":"

1. T\u1ed5ng quan<\/h3>\n
Tr\u01b0\u1eddng h\u1ee3p anh\/ch\u1ecb c\u00f3 nhu c\u1ea7u xu\u1ea5t file Excel b\u00e1o c\u00e1o TSC\u0110<\/strong> c\u00f3 \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin nh\u01b0 t\u00ean t\u00e0i s\u1ea3n, ph\u00f2ng ban\/b\u1ed9 ph\u1eadn s\u1eed d\u1ee5ng, ng\u01b0\u1eddi s\u1eed d\u1ee5ng, n\u01a1i s\u1eed d\u1ee5ng, s\u1ed1 seri, model, lo\u1ea1i t\u00e0i s\u1ea3n, gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i, s\u1ed1 li\u1ec7u ki\u1ec3m k\u00ea\u2026<\/em> \u0111\u1ec3 ph\u1ee5c v\u1ee5 theo d\u00f5i v\u00e0 l\u00e0m b\u00e1o c\u00e1o.<\/p>\n
Tuy nhi\u00ean, kh\u00f4ng ph\u1ea3i b\u00e1o c\u00e1o n\u00e0o tr\u00ean ph\u1ea7n m\u1ec1m c\u0169ng hi\u1ec3n th\u1ecb \u0111\u1ea7y \u0111\u1ee7 c\u00e1c th\u00f4ng tin nh\u01b0 t\u00ean t\u00e0i s\u1ea3n, ng\u01b0\u1eddi s\u1eed d\u1ee5ng, b\u1ed9 ph\u1eadn s\u1eed d\u1ee5ng, seri, model, s\u1ed1 l\u01b0\u1ee3ng, gi\u00e1 tr\u1ecb, th\u1eeba thi\u1ebfu ki\u1ec3m k\u00ea<\/strong>, n\u00ean anh\/ch\u1ecb c\u00f3 th\u1ec3 g\u1eb7p kh\u00f3 kh\u0103n khi l\u1ef1a ch\u1ecdn \u0111\u00fang m\u1eabu b\u00e1o c\u00e1o.<\/p>\n
B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn anh\/ch\u1ecb:<\/p>\n
\n
Ch\u1ecdn \u0111\u00fang b\u00e1o c\u00e1o c\u00f3 \u0111\u1ea7y \u0111\u1ee7 c\u00e1c th\u00f4ng tin nh\u01b0 ph\u00f2ng ban, lo\u1ea1i t\u00e0i s\u1ea3n, t\u00ean t\u00e0i s\u1ea3n, s\u1ed1 hi\u1ec7u, n\u0103m s\u1ea3n xu\u1ea5t, n\u01b0\u1edbc s\u1ea3n xu\u1ea5t, nh\u00e3n hi\u1ec7u, s\u1ed1 seri, model, ngu\u1ed3n h\u00ecnh th\u00e0nh, n\u0103m s\u1eed d\u1ee5ng, di\u1ec7n t\u00edch, th\u1ec3 t\u00edch, ng\u01b0\u1eddi s\u1eed d\u1ee5ng, n\u01a1i s\u1eed d\u1ee5ng, s\u1ed1 l\u01b0\u1ee3ng, th\u00e0nh ti\u1ec1n, gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i, s\u1ed1 li\u1ec7u ki\u1ec3m k\u00ea (th\u1eeba\/thi\u1ebfu), \u0111\u1ec1 ngh\u1ecb thanh l\u00fd, thi\u1ebft b\u1ecb y t\u1ebf\u2026<\/strong><\/li>\n
C\u00e1ch in v\u00e0 xu\u1ea5t file Excel t\u1eeb b\u00e1o c\u00e1o<\/li>\n<\/ul>\n
3. C\u00e1ch in b\u00e1o c\u00e1o<\/h3>\n
\u0110\u1ec3 in M\u1eabu s\u1ed1 BCKT05 \u2013 B\u00e1o c\u00e1o ki\u1ec3m k\u00ea TSC\u0110, anh\/ch\u1ecb th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/p>\n
B\u01b0\u1edbc 1:<\/strong>\u00a0Anh\/ch\u1ecb v\u00e0o menu\u00a0T\u00e0i s\u1ea3n\\ ki\u1ec3m k\u00ea\\ l\u1eadp ch\u1ee9ng t\u1eeb ki\u1ec3m k\u00ea<\/strong>\u00a0t\u00e0i s\u1ea3n\u00a0t\u1ea1i \u0111\u00e2y.<\/a><\/p>\n
B\u01b0\u1edbc 2:<\/strong> In m\u1eabu s\u1ed1 BCKT05 trong menu B\u00e1o c\u00e1o: <\/strong>V\u00e0o\u00a0B\u00e1o c\u00e1o\\B\u00e1o c\u00e1o theo ch\u1ebf \u0111\u1ed9 k\u1ebf to\u00e1n<\/strong>\\ch\u1ecdn\u00a0M\u1eabu s\u1ed1 BCKT05 \u2013 B\u00e1o c\u00e1o ki\u1ec3m k\u00ea TSC\u0110.<\/strong><\/p>\n
$\"\"$ <\/strong><\/p>\n
B\u01b0\u1edbc 3:<\/strong>\u00a0Khai b\u00e1o tham s\u1ed1 b\u00e1o c\u00e1o:<\/p>\n
\n
\u00d4 tham s\u1ed1\u00a0K\u1ef3 b\u00e1o c\u00e1o\u00a0<\/strong>h\u1ed7 tr\u1ee3 nhi\u1ec1u l\u1ef1a ch\u1ecdn: ch\u1ecdn nhanh theo th\u00e1ng, qu\u00fd, n\u0103m ho\u1eb7c t\u1ef1 x\u00e1c \u0111\u1ecbnh k\u1ef3 b\u00e1o c\u00e1o b\u1eb1ng c\u00e1ch nh\u1eadp\u00a0\u201cT\u1eeb ng\u00e0y \u2013 \u0110\u1ebfn ng\u00e0y\u201d.<\/strong><\/li>\n
Ch\u1ecdn\u00a0B\u1ed9 ph\u1eadn s\u1eed d\u1ee5ng:<\/strong>\n
\n
\n
Ch\u1ecdn\u00a0\u201cT\u1ea5t c\u1ea3\u201d<\/strong>\u00a0\u0111\u1ec3 xem t\u00e0i s\u1ea3n \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y chi ti\u1ebft theo t\u1eebng b\u1ed9 ph\u1eadn s\u1eed d\u1ee5ng.<\/p>\n<\/li>\n
\n
Ch\u1ecdn\u00a0ph\u00f2ng ban c\u1ee5 th\u1ec3<\/strong>\u00a0n\u1ebfu ch\u1ec9 mu\u1ed1n theo d\u00f5i t\u00e0i s\u1ea3n thu\u1ed9c ph\u00f2ng ban \u0111\u00f3.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n
T\u00f9y ch\u1ec9nh in:<\/strong>\n
\n
Hi\u1ec3n th\u1ecb m\u1ed7i b\u1ed9 ph\u1eadn s\u1eed d\u1ee5ng l\u00e0 m\u1ed9t b\u00e1o c\u00e1o:<\/strong>\u00a0T\u00edch ch\u1ecdn n\u1ebfu mu\u1ed1n th\u1ec3 hi\u1ec7n m\u1ed7i ph\u00f2ng ban l\u00e0 m\u1ed9t b\u00e1o c\u00e1o.<\/li>\n
Hi\u1ec3n th\u1ecb chi ti\u1ebft t\u1eebng t\u00e0i s\u1ea3n theo l\u00f4:<\/strong>\u00a0T\u00edch ch\u1ecdn n\u1ebfu mu\u1ed1n th\u1ec3 hi\u1ec7n chi ti\u1ebft t\u1eebng t\u00e0i s\u1ea3n trong l\u00f4 t\u00e0i s\u1ea3n.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
B\u01b0\u1edbc 4:<\/strong>\u00a0Nh\u1ea5n\u00a0\u0110\u1ed3ng \u00fd<\/strong>\u00a0\u0111\u1ec3 xem b\u00e1o c\u00e1o.<\/p>\n
$\"\"$ <\/p>\n
B\u01b0\u1edbc 5:<\/strong> Xu\u1ea5t file Excel \u0111\u1ec3 c\u00f3 \u0111\u1ee7 th\u00f4ng tin chi ti\u1ebft c\u1ee7a t\u00e0i s\u1ea3n: Ch\u1ecdn T\u1ea3i t\u1ec7p<\/strong> (g\u00f3c tr\u00ean c\u00f9ng tay ph\u1ea3i)\\ nh\u1ea5n T\u1ec7p MS Excel (d\u1ea1ng d\u1eef li\u1ec7u) \u0111\u1ec3 xu\u1ea5t kh\u1ea9u b\u00e1o c\u00e1o ra d\u1ea1ng excel.<\/strong><\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
1. T\u1ed5ng quan Tr\u01b0\u1eddng h\u1ee3p anh\/ch\u1ecb c\u00f3 nhu c\u1ea7u xu\u1ea5t file Excel b\u00e1o c\u00e1o TSC\u0110 c\u00f3 \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin nh\u01b0 t\u00ean t\u00e0i s\u1ea3n, ph\u00f2ng ban\/b\u1ed9 ph\u1eadn s\u1eed d\u1ee5ng, ng\u01b0\u1eddi s\u1eed d\u1ee5ng, n\u01a1i s\u1eed d\u1ee5ng, s\u1ed1 seri, model, lo\u1ea1i t\u00e0i s\u1ea3n, gi\u00e1 tr\u1ecb c\u00f2n l\u1ea1i, s\u1ed1 li\u1ec7u ki\u1ec3m k\u00ea\u2026 \u0111\u1ec3…<\/p>\n","protected":false},"author":121,"template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[178],"ht-kb-tag":[],"class_list":["post-46345","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-bao-cao-cau-hoi-thuong-gap"],"_links":{"self":[{"href":"\/tai-san\/wp-json\/wp\/v2\/ht-kb\/46345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/tai-san\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/tai-san\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/tai-san\/wp-json\/wp\/v2\/users\/121"}],"version-history":[{"count":2,"href":"\/tai-san\/wp-json\/wp\/v2\/ht-kb\/46345\/revisions"}],"predecessor-version":[{"id":46469,"href":"\/tai-san\/wp-json\/wp\/v2\/ht-kb\/46345\/revisions\/46469"}],"wp:attachment":[{"href":"\/tai-san\/wp-json\/wp\/v2\/media?parent=46345"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/tai-san\/wp-json\/wp\/v2\/ht-kb-category?post=46345"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/tai-san\/wp-json\/wp\/v2\/ht-kb-tag?post=46345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}