{"id":19961,"date":"2026-05-07T08:38:49","date_gmt":"2026-05-07T01:38:49","guid":{"rendered":"\/amis-tien-luong\/?post_type=ht_kb&#038;p=19961"},"modified":"2026-05-07T10:50:52","modified_gmt":"2026-05-07T03:50:52","slug":"luong-san-pham-huong-dan-thiet-lap-bang-tong-hop-va-tinh-luong-theo-san-pham-tren-amis-tien-luong","status":"publish","type":"ht_kb","link":"\/amis-tien-luong\/kb\/luong-san-pham-huong-dan-thiet-lap-bang-tong-hop-va-tinh-luong-theo-san-pham-tren-amis-tien-luong\/","title":{"rendered":"L\u01b0\u01a1ng s\u1ea3n ph\u1ea9m &#8211; H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp b\u1ea3ng t\u1ed5ng h\u1ee3p v\u00e0 t\u00ednh l\u01b0\u01a1ng theo s\u1ea3n ph\u1ea9m 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>:&#8221;<strong>L\u01b0\u01a1ng s\u1ea3n ph\u1ea9m&#8221;<\/strong> l\u00e0 h\u00ecnh th\u1ee9c tr\u1ea3 l\u01b0\u01a1ng d\u1ef1a tr\u00ean s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m ho\u00e0n th\u00e0nh c\u1ee7a t\u1eebng c\u00e1 nh\u00e2n trong doanh nghi\u1ec7p s\u1ea3n xu\u1ea5t. Vi\u1ec7c s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m gi\u00fap anh\/ch\u1ecb d\u1ec5 d\u00e0ng t\u1ea1o b\u1ea3ng t\u1ed5ng h\u1ee3p s\u1ea3n ph\u1ea9m theo ng\u00e0y, th\u00e1ng, nh\u1eadp d\u1eef li\u1ec7u nhanh t\u1eeb file Excel v\u00e0 t\u1ef1 \u0111\u1ed9ng t\u00ednh l\u01b0\u01a1ng d\u1ef1a tr\u00ean s\u1ed1 li\u1ec7u \u0111\u00e3 nh\u1eadp.<\/p>\n<p><strong>N\u1ed9i dung:\u00a0<\/strong><\/p>\n<ul>\n<li>H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp b\u1ea3ng t\u1ed5ng h\u1ee3p s\u1ea3n ph\u1ea9m v\u00e0 t\u1ef1 \u0111\u1ed9ng t\u00ednh l\u01b0\u01a1ng s\u1ea3n ph\u1ea9m tr\u00ean AMIS Ti\u1ec1n l\u01b0\u01a1ng.<\/li>\n<\/ul>\n<p><strong>Ph\u1ea1m vi \u00e1p d\u1ee5ng<\/strong>: Nh\u00e2n s\u1ef1, qu\u1ea3n l\u00fd, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng.<br \/>\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\u1edbng d\u1eabn th\u1ef1c hi\u1ec7n<br \/>\n<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p>Khi anh\/ch\u1ecb mu\u1ed1n t\u00ednh l\u01b0\u01a1ng s\u1ea3n ph\u1ea9m c\u1ee7a c\u00f4ng nh\u00e2n trong doanh nghi\u1ec7p, AMIS Ti\u1ec1n l\u01b0\u01a1ng h\u1ed7 tr\u1ee3 anh\/ch\u1ecb thi\u1ebft l\u1eadp b\u1ea3ng t\u1ed5ng h\u1ee3p danh m\u1ee5c s\u1ea3n ph\u1ea9m v\u00e0 t\u1ef1 \u0111\u1ed9ng t\u00ednh l\u01b0\u01a1ng theo s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m ho\u00e0n th\u00e0nh c\u1ee7a t\u1eebng c\u00e1 nh\u00e2n trong doanh nghi\u1ec7p.<\/p>\n<p><em>V\u00ed d\u1ee5: Doanh nghi\u1ec7p s\u1ea3n xu\u1ea5t A s\u1ea3n xu\u1ea5t \u00e1o ph\u00f4ng, k\u1ebf to\u00e1n s\u1ebd t\u00ednh l\u01b0\u01a1ng cho c\u00f4ng nh\u00e2n d\u1ef1a tr\u00ean s\u1ea3n ph\u1ea9m \u00e1o ph\u00f4ng\/th\u00e1ng. \u0110\u1ec3 t\u00ednh l\u01b0\u01a1ng cho c\u00f4ng nh\u00e2n d\u1ef1a theo s\u1ea3n ph\u1ea9m\/th\u00e1ng, anh\/ch\u1ecb th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:\u00a0<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 1: Khai b\u00e1o danh m\u1ee5c s\u1ea3n ph\u1ea9m\/c\u00f4ng \u0111o\u1ea1n.<\/strong><\/p>\n<p>Tr\u00ean <strong>AMIS Ti\u1ec1n l\u01b0\u01a1ng<\/strong>, v\u00e0o ph\u00e2n h\u1ec7 <strong>D\u1eef li\u1ec7u t\u00ednh l\u01b0\u01a1ng<\/strong>\\ch\u1ecdn<strong> S\u1ea3n ph\u1ea9m<\/strong>\\ch\u1ecdn <strong>Danh m\u1ee5c s\u1ea3n ph\u1ea9m\/c\u00f4ng \u0111o\u1ea1n.<br \/>\n<\/strong><\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-19967 aligncenter\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2026\/05\/2026-05-06_16-05-37.png\" alt=\"\" width=\"1920\" height=\"537\" \/><\/p>\n<p>Ti\u1ebfp theo, anh ch\u1ecb \u0111i\u1ec1n \u0111\u1ea7y \u0111\u1ee7 c\u00e1c th\u00f4ng tin sau:<\/p>\n<ul>\n<li><strong>T\u00ean s\u1ea3n ph\u1ea9m<\/strong><\/li>\n<li><strong>M\u00e3 s\u1ea3n ph\u1ea9m\u00a0<\/strong><\/li>\n<li>Ngo\u00e0i ra nh\u1eefng th\u00f4ng tin v\u1ec1 <strong>\u0110\u01a1n gi\u00e1, H\u1ec7 s\u1ed1, M\u00f4 t\u1ea3<\/strong> s\u1ebd kh\u00f4ng b\u1eaft bu\u1ed9c ph\u1ea3i \u0111i\u1ec1n, t\u00f9y ch\u1ec9nh theo nhu c\u1ea7u.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"size-full wp-image-19975 aligncenter\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2026\/05\/2026-05-06_16-12-57-1.png\" alt=\"\" width=\"1920\" height=\"736\" \/><\/p>\n<p><strong>L\u01b0u \u00fd:<\/strong> Ngo\u00e0i ra, n\u1ebfu doanh nghi\u1ec7p c\u1ee7a anh\/ch\u1ecb t\u00ednh l\u01b0\u01a1ng s\u1ea3n ph\u1ea9m d\u1ef1a tr\u00ean t\u1eebng c\u00f4ng \u0111o\u1ea1n s\u1ea3n xu\u1ea5t, ch\u1ecdn m\u1ee5c <strong>C\u00f4ng \u0111o\u1ea1n<\/strong> \u0111\u1ec3 thi\u1ebft l\u1eadp<br \/>\n<img decoding=\"async\" class=\"size-full wp-image-19971 aligncenter\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2026\/05\/2026-05-06_16-18-20.png\" alt=\"\" width=\"1920\" height=\"625\" \/><\/p>\n<p>Sau khi \u0111\u00e3 thi\u1ebft l\u1eadp xong danh m\u1ee5c s\u1ea3n ph\u1ea9m\/c\u00f4ng \u0111o\u1ea1n, nh\u1ea5n <strong>L\u01b0u<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 2: T\u1ea1o b\u1ea3ng t\u1ed5ng h\u1ee3p s\u1ea3n ph\u1ea9m<br \/>\n<\/strong><\/p>\n<p>Trong ph\u00e2n h\u1ec7 D\u1eef li\u1ec7u t\u00ednh l\u01b0\u01a1ng, ch\u1ecdn <strong>Th\u00eam m\u1edbi<\/strong> \u0111\u1ec3 t\u1ea1o B\u1ea3ng t\u1ed5ng h\u1ee3p s\u1ea3n ph\u1ea9m theo d\u1eef li\u1ec7u v\u1ec1 s\u1ea3n ph\u1ea9m v\u1eeba t\u1ea1o\\nh\u1ea5n <strong>L\u01b0u.<br \/>\n<\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-20001\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2026\/05\/Screenshot_14.png\" alt=\"\" width=\"1919\" height=\"959\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3: Thi\u1ebft l\u1eadp t\u00ednh l\u01b0\u01a1ng theo s\u1ea3n ph\u1ea9m\u00a0<\/strong><\/p>\n<p>Truy c\u1eadp v\u00e0o ph\u00e2n h\u1ec7 <strong>T\u00ednh l\u01b0\u01a1ng<\/strong>\\ch\u1ecdn <strong>B\u1ea3ng l\u01b0\u01a1ng<\/strong>\\t\u1ea1i giao di\u1ec7n Th\u00eam b\u1ea3ng l\u01b0\u01a1ng, anh\/ch\u1ecb thi\u1ebft l\u1eadp c\u00e1c th\u00f4ng tin sau:<\/p>\n<ul>\n<li><strong>Lo\u1ea1i b\u1ea3ng l\u01b0\u01a1ng: <\/strong>c\u00f3 th\u1ec3 ch\u1ecdn<strong> B\u1ea3ng l\u01b0\u01a1ng chi ti\u1ebft<\/strong> (n\u1ebfu \u0111\u01a1n v\u1ecb c\u00f3 nghi\u1ec7p v\u1ee5 t\u00ednh l\u01b0\u01a1ng nhi\u1ec1u l\u1ea7n trong 1 th\u00e1ng) ho\u1eb7c <strong>B\u1ea3ng l\u01b0\u01a1ng t\u1ed5ng h\u1ee3p.<\/strong><\/li>\n<li><strong>K\u1ef3 l\u01b0\u01a1ng<\/strong><\/li>\n<li><strong>\u0110\u01a1n v\u1ecb \u00e1p d\u1ee5ng<\/strong><\/li>\n<li><strong>V\u1ecb tr\u00ed \u00e1p d\u1ee5ng<\/strong><\/li>\n<li><strong>T\u00ednh ch\u1ea5t lao \u0111\u1ed9ng:<\/strong><\/li>\n<li><strong>T\u00ean b\u1ea3ng l\u01b0\u01a1ng<\/strong><\/li>\n<li><strong>D\u1eef li\u1ec7u t\u00ednh l\u01b0\u01a1ng<\/strong>: t\u1ea1i m\u1ee5c n\u00e0y, anh\/ch\u1ecb ch\u1ecdn <strong>Th\u00eam d\u1eef li\u1ec7u<\/strong>\\ch\u1ecdn <strong><strong>S\u1ea3n ph\u1ea9m<\/strong><\/strong><\/li>\n<\/ul>\n<p>Sau \u0111\u00f3 nh\u1ea5n<strong> L\u01b0u<\/strong>, ph\u1ea7n m\u1ec1m s\u1ebd t\u1ef1 \u0111\u1ed9ng l\u1eadp B\u1ea3ng l\u01b0\u01a1ng theo s\u1ea3n ph\u1ea9m d\u1ef1a tr\u00ean c\u00e1c d\u1eef li\u1ec7u \u0111\u00e3 thi\u1ebft l\u00e2p.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-19985 aligncenter\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2026\/05\/Screenshot-2026-05-07-082810.png\" alt=\"\" width=\"1913\" height=\"853\" \/><\/p>\n<p><em><strong>L\u01b0u \u00fd:<\/strong> Th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng s\u1ea3n ph\u1ea9m, c\u1ea7n c\u00e0i \u0111\u1eb7t c\u00f4ng th\u1ee9c, v\u00ed d\u1ee5 &#8220;=SO_SAN_PHAM_THUC_TE*DON_GIA_SAN_PHAM&#8221;, ph\u1ea7n m\u1ec1m t\u1ef1 t\u00ednh theo \u0111\u01a1n gi\u00e1 c\u1ee7a t\u1eebng lo\u1ea1i s\u1ea3n ph\u1ea9m \u0111\u00e3 khai b\u00e1o trong danh m\u1ee5c.<\/em><\/p>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":141,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[144],"ht-kb-tag":[],"class_list":["post-19961","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-tinh-luong-vai-tro-hr"],"_links":{"self":[{"href":"\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/19961","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/amis-tien-luong\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/amis-tien-luong\/wp-json\/wp\/v2\/users\/141"}],"replies":[{"embeddable":true,"href":"\/amis-tien-luong\/wp-json\/wp\/v2\/comments?post=19961"}],"version-history":[{"count":4,"href":"\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/19961\/revisions"}],"predecessor-version":[{"id":20005,"href":"\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/19961\/revisions\/20005"}],"wp:attachment":[{"href":"\/amis-tien-luong\/wp-json\/wp\/v2\/media?parent=19961"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb-category?post=19961"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb-tag?post=19961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}