V\u00e0o bi\u1ec3u t\u01b0\u1ee3ng\u00a0\u2699\ufe0f\u00a0<\/b>Thi\u1ebft l\u1eadp\\Danh m\u1ee5c<\/strong>, ch\u1ecdn danh m\u1ee5c c\u1ea7n th\u1ef1c hi\u1ec7n khai b\u00e1o (V\u00ed d\u1ee5: Kh\u00e1ch h\u00e0ng, nh\u00e0 cung c\u1ea5p, T\u00e0i s\u1ea3n c\u1ed1 \u0111\u1ecbnh, C\u00f4ng c\u1ee5 d\u1ee5ng c\u1ee5 \u2026.).<\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\n
Nh\u1ea5n m\u0169i t\u00ean c\u1ea1nh ch\u1ee9c n\u0103ng Th\u00eam<\/strong> ch\u1ecdn Nh\u1eadp kh\u1ea9u t\u1eeb excel.<\/strong><\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
B\u01b0\u1edbc 1: T\u1ea3i t\u1ec7p m\u1eabu excel & nh\u1eadp th\u00f4ng tin chi ti\u1ebft c\u1ea7n nh\u1eadp kh\u1ea9u<\/strong><\/p>\n
\n
Tr\u00ean giao di\u1ec7n “Nh\u1eadp kh\u1ea9u danh m\u1ee5c kh\u00e1ch h\u00e0ng, nh\u00e0 cung c\u1ea5p” ch\u1ecdn T\u1ea3i t\u1ec7p m\u1eabu c\u01a1 b\u1ea3n <\/strong>ho\u1eb7c T\u1ec7p m\u1eabu \u0111\u1ea7y \u0111\u1ee7<\/strong>.<\/strong><\/li>\n<\/ul>\n
\n
\n
\n
\n
T\u1ec7p m\u1eabu c\u01a1 b\u1ea3n<\/strong>: \u0111\u1ec3 nh\u1eadp nh\u1eefng th\u00f4ng tin c\u01a1 b\u1ea3n th\u01b0\u1eddng s\u1ebd hi\u1ec3n th\u1ecb tr\u00ean ch\u1ee9ng t\u1eeb ho\u1eb7c tr\u00ean b\u00e1o c\u00e1o.<\/li>\n
T\u1ec7p m\u1eabu \u0111\u1ea7y \u0111\u1ee7<\/strong>: \u0111\u1ec3 nh\u1eadp t\u1ea5t c\u1ea3 c\u00e1c th\u00f4ng tin khi khai b\u00e1o danh m\u1ee5c bao g\u1ed3m c\u1ea3 c\u00e1c tr\u01b0\u1eddng th\u00f4ng tin kh\u00f4ng b\u1eaft bu\u1ed9c.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div>\n
$\"\"$ <\/p>\n
\n
\n
\u0110i\u1ec1n \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin tr\u00ean file excel m\u1eabu c\u1ea7n nh\u1eadp kh\u1ea9u.<\/p>\n<\/li>\n<\/ul>\n
L\u01b0u \u00fd: C\u00e1c c\u1ed9t th\u00f4ng tin b\u1eaft bu\u1ed9c (th\u01b0\u1eddng c\u00f3 d\u1ea5u *) ph\u1ea3i \u0111\u01b0\u1ee3c \u0111i\u1ec1n th\u00f4ng tin v\u00e0 gh\u00e9p c\u1ed9t \u0111\u1ea7y \u0111\u1ee7 th\u00ec m\u1edbi th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c b\u01b0\u1edbc ti\u1ebfp theo.<\/strong><\/em><\/p>\n
B\u01b0\u1edbc 2: Ch\u1ecdn t\u1ec7p ngu\u1ed3n<\/b><\/p>\n
\n
Ch\u1ecdn file nh\u1eadp kh\u1ea9u t\u1eeb c\u00e1c file d\u1eef li\u1ec7u s\u1eb5n c\u00f3 tr\u00ean m\u00e1y t\u00ednh ho\u1eb7c file \u0111\u00e3 \u0111i\u1ec1n \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin \u1edf B\u01b0\u1edbc 1.<\/strong><\/li>\n
Ch\u1ecdn sheet c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp kh\u1ea9u v\u00e0 l\u1ef1a ch\u1ecdn d\u00f2ng b\u1eaft \u0111\u1ea7u l\u1ea5y d\u1eef li\u1ec7u.<\/li>\n
C\u00f3 3 l\u1ef1a ch\u1ecdn ph\u01b0\u01a1ng th\u1ee9c nh\u1eadp kh\u1ea9u th\u00f4ng tin:<\/li>\n<\/ul>\n
\n
\n
\n
Th\u00eam m\u1edbi:<\/strong> th\u00eam m\u1edbi c\u00e1c m\u00e3 trong danh m\u1ee5c VTHH, NCC, kh\u00e1ch h\u00e0ng\u2026<\/li>\n
C\u1eadp nh\u1eadt:<\/strong> c\u1eadp nh\u1eadt, b\u1ed5 sung th\u00eam c\u00e1c th\u00f4ng tin c\u1ee7a c\u00e1c m\u00e3 \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ea1o t\u1eeb tr\u01b0\u1edbc tr\u00ean danh m\u1ee5c.<\/li>\n
Ghi \u0111\u00e8:<\/strong> to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong h\u1ec7 th\u1ed1ng s\u1ebd \u0111\u01b0\u1ee3c thay th\u1ebf b\u1eb1ng d\u1eef li\u1ec7u trong t\u1ec7p nh\u1eadp kh\u1ea9u.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\n
Sau khi \u0111\u00e3 l\u1ef1a ch\u1ecdn xong, nh\u1ea5n\u00a0Ti\u1ebfp t\u1ee5c<\/strong> \u0111\u1ec3 chuy\u1ec3n qua B\u01b0\u1edbc 3.<\/strong><\/li>\n<\/ul>\n
B\u01b0\u1edbc 3: Gh\u00e9p d\u1eef li\u1ec7u<\/b><\/p>\n
\n
N\u1ebfu file nh\u1eadp kh\u1ea9u l\u00e0 file m\u1eabu ng\u1ea7m \u0111\u1ecbnh \u1edf B\u01b0\u1edbc 1<\/strong> h\u1ec7 th\u1ed1ng s\u1ebd t\u1ef1 \u0111\u1ed9ng gh\u00e9p c\u00e1c c\u1ed9t tr\u00ean t\u1ec7p d\u1eef li\u1ec7u v\u1edbi c\u1ed9t tr\u00ean tr\u00ean ph\u1ea7n m\u1ec1m.<\/li>\n
N\u1ebfu l\u00e0 File ri\u00eang c\u1ee7a \u0111\u01a1n v\u1ecb, h\u1ec7 th\u1ed1ng kh\u00f4ng gh\u00e9p \u0111\u01b0\u1ee3c c\u1ed9t ho\u1eb7c gh\u00e9p ch\u01b0a \u0111\u00fang th\u00ec anh\/ch\u1ecb c\u00f3 th\u1ec3 t\u1ef1 ch\u1ecdn l\u1ea1i c\u1ed9t cho ch\u00ednh x\u00e1c nh\u1ea5t C\u1ed9t tr\u00ean T\u1ec7p d\u1eef li\u1ec7u.<\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\n
Tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mong mu\u1ed1n l\u1ea5y th\u00eam ho\u1eb7c b\u1ecf b\u1edbt th\u00f4ng tin c\u00e1c m\u00e3 danh m\u1ee5c c\u1ea7n nh\u1eadp kh\u1ea9u th\u00ec c\u00f3 th\u1ec3 nh\u1ea5n \u1ea8n\/hi\u1ec7n th\u00f4ng tin<\/strong>. T\u00edch ch\u1ecdn v\u00e0o th\u00f4ng tin c\u1ea7n hi\u1ec3n th\u1ecb ho\u1eb7c b\u1ecf t\u00edch ch\u1ecdn n\u1ebfu mu\u1ed1n \u1ea9n th\u00f4ng tin \u0111\u00f3. Nh\u1ea5n \u0110\u1ed3ng \u00fd.<\/strong><\/li>\n
Sau \u0111\u00f3 nh\u1ea5n Ti\u1ebfp t\u1ee5c<\/strong> \u0111\u1ec3 chuy\u1ec3n sang B\u01b0\u1edbc 4.<\/strong><\/li>\n<\/ul>\n
B\u01b0\u1edbc 4: Ki\u1ec3m tra d\u1eef li\u1ec7u<\/b><\/p>\n
\n
Ph\u1ea7n m\u1ec1m ki\u1ec3m tra to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong c\u00e1c c\u1ed9t v\u1edbi d\u1eef li\u1ec7u \u0111\u00e3 t\u1ed3n t\u1ea1i tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh v\u00e0 hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o s\u1ed1 b\u1ea3n ghi h\u1ee3p l\u1ec7\/kh\u00f4ng h\u1ee3p l\u1ec7.<\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\n
Khi \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn:<\/li>\n<\/ul>\n
\n
\n
\n
Nh\u1ea5n\u00a0Nh\u1eadp d\u1eef li\u1ec7u<\/strong>: ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd b\u1ecf qua c\u00e1c m\u00e3 kh\u00f4ng h\u1ee3p l\u1ec7 v\u00e0 ch\u1ec9 nh\u1eadp l\u00ean h\u1ec7 th\u1ed1ng c\u00e1c m\u00e3 h\u1ee3p l\u1ec7.<\/li>\n
N\u1ebfu c\u00f3 d\u00f2ng\u00a0Kh\u00f4ng h\u1ee3p l\u1ec7<\/b>, b\u1ea1n nh\u1ea5n\u00a0T\u1ea3i t\u1ec7p ki\u1ec3m tra<\/b>\u00a0(ho\u1eb7c \u201cT\u1ea3i file k\u1ebft qu\u1ea3\u201d) \u0111\u1ec3 xem chi ti\u1ebft l\u1ed7i, sau \u0111\u00f3 s\u1eeda l\u1ea1i file Excel v\u00e0 quay l\u1ea1i B\u01b0\u1edbc 1<\/strong> \u0111\u1ec3 t\u1ea3i t\u1ec7p l\u00ean l\u1ea1i.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
B\u01b0\u1edbc 5: K\u1ebft qu\u1ea3 nh\u1eadp kh\u1ea9u<\/strong><\/p>\n
\n
Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 c\u00e1c m\u00e3 \u0111\u00e3 nh\u1eadp kh\u1ea9u th\u00e0nh c\u00f4ng ho\u1eb7c kh\u00f4ng th\u00e0nh c\u00f4ng d\u1ef1a theo k\u1ebft qu\u1ea3 ki\u1ec3m tra \u1edf B\u01b0\u1edbc 3.<\/strong><\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\n
Nh\u1ea5n\u00a0\u0110\u00f3ng\u00a0<\/strong>ho\u1eb7c nh\u1ea5n bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u\u00a0X<\/strong>\u00a0\u0111\u1ec3 ho\u00e0n th\u00e0nh nh\u1eadp kh\u1ea9u danh m\u1ee5c.<\/li>\n<\/ul>\n<\/div><\/div>\n
<\/span><\/p>\n
Tr\u01b0\u1eddng h\u1ee3p 2: Nh\u1eadp kh\u1ea9u s\u1ed1 d\u01b0 ban \u0111\u1ea7u t\u1eeb file excel<\/h4>\n
<\/div>
\n
\n
V\u00e0o\u00a0bi\u1ec3u t\u01b0\u1ee3ng\u00a0\u2699\ufe0f<\/b>\u00a0Thi\u1ebft l\u1eadp\\Nh\u1eadp s\u1ed1 d\u01b0 ban \u0111\u1ea7u.<\/strong><\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\n
Ch\u1ecdn lo\u1ea1i s\u1ed1 d\u01b0 c\u1ea7n nh\u1eadp kh\u1ea9u. V\u00ed d\u1ee5: Nh\u1eadp kh\u1ea9u s\u1ed1 d\u01b0 ban \u0111\u1ea7u cho t\u00e0i kho\u1ea3n.<\/em><\/li>\n
Tr\u00ean ch\u1ee9c n\u0103ng\u00a0Nh\u1eadp s\u1ed1 d\u01b0<\/strong>, ch\u1ecdn ti\u1ec7n \u00edch Nh\u1eadp kh\u1ea9u t\u1eeb Excel.<\/strong><\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
B\u01b0\u1edbc 1: T\u1ea3i t\u1ec7p m\u1eabu excel & nh\u1eadp th\u00f4ng tin chi ti\u1ebft c\u1ea7n nh\u1eadp kh\u1ea9u<\/strong><\/p>\n
\n
Tr\u00ean giao di\u1ec7n “Nh\u1eadp kh\u1ea9u s\u1ed1 d\u01b0 ban \u0111\u1ea7u cho t\u00e0i kho\u1ea3n” ch\u1ecdn T\u1ea3i t\u1ec7p m\u1eabu.<\/strong><\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\n
\u0110i\u1ec1n \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin tr\u00ean file excel c\u1ea7n nh\u1eadp kh\u1ea9u.<\/li>\n<\/ul>\n
B\u01b0\u1edbc 2: Ch\u1ecdn t\u1ec7p ngu\u1ed3n<\/strong><\/p>\n
\n
Ch\u1ecdn file nh\u1eadp kh\u1ea9u t\u1eeb c\u00e1c file d\u1eef li\u1ec7u s\u1eb5n c\u00f3 tr\u00ean m\u00e1y t\u00ednh ho\u1eb7c file \u0111\u00e3 \u0111i\u1ec1n \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin \u1edf B\u01b0\u1edbc 1.<\/strong><\/li>\n
Ch\u1ecdn sheet c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp kh\u1ea9u v\u00e0 l\u1ef1a ch\u1ecdn d\u00f2ng b\u1eaft \u0111\u1ea7u l\u1ea5y d\u1eef li\u1ec7u.<\/li>\n
C\u00f3 3 l\u1ef1a ch\u1ecdn ph\u01b0\u01a1ng th\u1ee9c nh\u1eadp kh\u1ea9u th\u00f4ng tin:<\/li>\n<\/ul>\n
\n
\n
\n
Th\u00eam m\u1edbi:<\/strong> th\u00eam m\u1edbi s\u1ed1 d\u01b0 ban \u0111\u1ea7u cho t\u00e0i kho\u1ea3n, CCDC, VTHH,…<\/li>\n
C\u1eadp nh\u1eadt:<\/strong> c\u1eadp nh\u1eadt, b\u1ed5 sung th\u00eam c\u00e1c th\u00f4ng tin c\u1ee7a c\u00e1c m\u00e3 \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ea1o t\u1eeb tr\u01b0\u1edbc tr\u00ean danh m\u1ee5c.<\/li>\n
Ghi \u0111\u00e8:<\/strong> to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong h\u1ec7 th\u1ed1ng s\u1ebd \u0111\u01b0\u1ee3c thay th\u1ebf b\u1eb1ng d\u1eef li\u1ec7u trong t\u1ec7p nh\u1eadp kh\u1ea9u.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\n
Sau khi \u0111\u00e3 l\u1ef1a ch\u1ecdn xong, nh\u1ea5n\u00a0Ti\u1ebfp t\u1ee5c<\/strong> \u0111\u1ec3 chuy\u1ec3n qua B\u01b0\u1edbc 3.<\/strong><\/li>\n<\/ul>\n
B\u01b0\u1edbc 3:<\/strong>\u00a0Gh\u00e9p d\u1eef li\u1ec7u<\/strong><\/p>\n
\n
N\u1ebfu file nh\u1eadp kh\u1ea9u l\u00e0 file m\u1eabu ng\u1ea7m \u0111\u1ecbnh \u1edf B\u01b0\u1edbc 1<\/strong> h\u1ec7 th\u1ed1ng s\u1ebd t\u1ef1 \u0111\u1ed9ng gh\u00e9p c\u00e1c c\u1ed9t tr\u00ean t\u1ec7p d\u1eef li\u1ec7u v\u1edbi c\u1ed9t tr\u00ean tr\u00ean ph\u1ea7n m\u1ec1m.<\/li>\n
N\u1ebfu l\u00e0 File ri\u00eang c\u1ee7a \u0111\u01a1n v\u1ecb, h\u1ec7 th\u1ed1ng kh\u00f4ng gh\u00e9p \u0111\u01b0\u1ee3c c\u1ed9t ho\u1eb7c gh\u00e9p ch\u01b0a \u0111\u00fang th\u00ec anh\/ch\u1ecb c\u00f3 th\u1ec3 t\u1ef1 ch\u1ecdn l\u1ea1i c\u1ed9t cho ch\u00ednh x\u00e1c nh\u1ea5t C\u1ed9t tr\u00ean T\u1ec7p d\u1eef li\u1ec7u.<\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\n
Tr\u01b0\u1eddng h\u1ee3p mu\u1ed1n l\u1ea5y th\u00eam ho\u1eb7c b\u1ecf b\u1edbt th\u00f4ng tin c\u1ea7n nh\u1eadp kh\u1ea9u th\u00ec c\u00f3 th\u1ec3 nh\u1ea5n \u1ea8n\/hi\u1ec7n th\u00f4ng tin<\/strong>. T\u00edch ch\u1ecdn v\u00e0o th\u00f4ng tin c\u1ea7n hi\u1ec3n th\u1ecb ho\u1eb7c b\u1ecf t\u00edch ch\u1ecdn n\u1ebfu mu\u1ed1n \u1ea9n th\u00f4ng tin \u0111\u00f3. Nh\u1ea5n \u0110\u1ed3ng \u00fd.<\/strong><\/li>\n
Sau \u0111\u00f3 nh\u1ea5n Ti\u1ebfp t\u1ee5c<\/strong> \u0111\u1ec3 chuy\u1ec3n sang B\u01b0\u1edbc 4.<\/strong><\/li>\n<\/ul>\n
B\u01b0\u1edbc 4:<\/strong>\u00a0Ki\u1ec3m tra d\u1eef li\u1ec7u<\/strong>:<\/p>\n
\n
Ph\u1ea7n m\u1ec1m s\u1ebd ki\u1ec3m tra to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong c\u00e1c c\u1ed9t v\u1edbi d\u1eef li\u1ec7u \u0111\u00e3 t\u1ed3n t\u1ea1i tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh v\u00e0 hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o s\u1ed1 b\u1ea3n ghi h\u1ee3p l\u1ec7\/kh\u00f4ng h\u1ee3p l\u1ec7.<\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\n
Khi \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn:<\/li>\n<\/ul>\n
\n
\n
\n
Nh\u1ea5n\u00a0Nh\u1eadp d\u1eef li\u1ec7u<\/strong>: ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd b\u1ecf qua c\u00e1c m\u00e3 kh\u00f4ng h\u1ee3p l\u1ec7 v\u00e0 ch\u1ec9 nh\u1eadp l\u00ean h\u1ec7 th\u1ed1ng c\u00e1c m\u00e3 h\u1ee3p l\u1ec7.<\/li>\n
Ki\u1ec3m tra th\u00f4ng tin chi ti\u1ebft l\u1ed7i tr\u00ean giao di\u1ec7n ho\u1eb7c nh\u1ea5n T\u1ea3i t\u1ec7p ki\u1ec3m tra<\/strong> \u0111\u1ec3 t\u1ea3i file k\u1ebft qu\u1ea3 v\u1ec1 m\u00e1y v\u00e0 ki\u1ec3m tra l\u1ea1i. Sau \u0111\u00f3 quay l\u1ea1i B\u01b0\u1edbc 1<\/strong> \u0111\u1ec3 c\u1eadp nh\u1eadt l\u1ea1i file nh\u1eadp kh\u1ea9u.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
B\u01b0\u1edbc 5:<\/b>\u00a0Th\u00f4ng b\u00e1o k\u1ebft qu\u1ea3 nh\u1eadp li\u1ec7u<\/strong><\/p>\n
\n
Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 c\u00e1c b\u1ea3n ghi \u0111\u00e3 nh\u1eadp kh\u1ea9u th\u00e0nh c\u00f4ng ho\u1eb7c kh\u00f4ng th\u00e0nh c\u00f4ng d\u1ef1a theo k\u1ebft qu\u1ea3 ki\u1ec3m tra \u1edf B\u01b0\u1edbc 4.<\/strong><\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\n
Nh\u1ea5n\u00a0\u0110\u00f3ng\u00a0<\/strong>ho\u1eb7c nh\u1ea5n bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u\u00a0X<\/strong> \u0111\u1ec3 ho\u00e0n th\u00e0nh nh\u1eadp kh\u1ea9u s\u1ed1 d\u01b0 ban \u0111\u1ea7u.<\/li>\n<\/ul>\n<\/div><\/div>\n
<\/span><\/p>\n
Tr\u01b0\u1eddng h\u1ee3p 3: Nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb t\u1eeb file excel<\/h4>\n
<\/div>
\n
\n
V\u00e0o bi\u1ec3u t\u01b0\u1ee3ng\u00a0\u2699\ufe0f\u00a0<\/b><\/strong>ch\u1ecdn\u00a0Ti\u1ec7n \u00edch\\Nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb.<\/strong><\/li>\n
Ch\u1ecdn ch\u1ee9ng t\u1eeb c\u1ea7n nh\u1eadp kh\u1ea9u<\/li>\n
V\u00ed d\u1ee5: Nh\u1eadp kh\u1ea9u Phi\u1ebfu chi.<\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
B\u01b0\u1edbc 1: Ch\u1ecdn t\u1ec7p ngu\u1ed3n (v\u00e0 t\u1ea3i file m\u1eabu)<\/strong><\/p>\n
\n
Ch\u1ecdn file nh\u1eadp kh\u1ea9u t\u1eeb c\u00e1c file d\u1eef li\u1ec7u s\u1eb5n c\u00f3 tr\u00ean m\u00e1y t\u00ednh ho\u1eb7c c\u00f3 th\u1ec3 t\u1ea3i file m\u1eabu v\u1ec1 \u0111\u1ec3 t\u1ea1o file d\u1eef li\u1ec7u nh\u1eadp kh\u1ea9u.<\/li>\n
Ch\u1ecdn sheet c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp kh\u1ea9u v\u00e0 l\u1ef1a ch\u1ecdn d\u00f2ng b\u1eaft \u0111\u1ea7u l\u1ea5y d\u1eef li\u1ec7u.<\/li>\n
C\u00f3 3 l\u1ef1a ch\u1ecdn ph\u01b0\u01a1ng th\u1ee9c nh\u1eadp kh\u1ea9u th\u00f4ng tin:<\/li>\n<\/ul>\n
\n
\n
\n
Th\u00eam m\u1edbi:<\/strong> th\u00eam m\u1edbi c\u00e1c ch\u1ee9ng t\u1eeb Phi\u1ebfu thu, phi\u1ebfu chi,…<\/li>\n
C\u1eadp nh\u1eadt:<\/strong> c\u1eadp nh\u1eadt, b\u1ed5 sung th\u00eam c\u00e1c th\u00f4ng tin c\u1ee7a c\u00e1c m\u00e3 \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ea1o t\u1eeb tr\u01b0\u1edbc tr\u00ean danh m\u1ee5c.<\/li>\n
Ghi \u0111\u00e8:<\/strong> to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong h\u1ec7 th\u1ed1ng s\u1ebd \u0111\u01b0\u1ee3c thay th\u1ebf b\u1eb1ng d\u1eef li\u1ec7u trong t\u1ec7p nh\u1eadp kh\u1ea9u.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\n
Sau khi \u0111\u00e3 l\u1ef1a ch\u1ecdn xong, nh\u1ea5n\u00a0Ti\u1ebfp t\u1ee5c<\/strong> \u0111\u1ec3 chuy\u1ec3n qua B\u01b0\u1edbc 2.<\/strong><\/li>\n<\/ul>\n
L\u01b0u \u00fd: \u0110\u1ed1i v\u1edbi ch\u1ee9ng t\u1eeb c\u00f3 nhi\u1ec1u d\u00f2ng h\u1ea1ch to\u00e1n: C\u00e1c c\u1ed9t th\u00f4ng tin chung (nh\u01b0 S\u1ed1 ch\u1ee9ng t\u1eeb, Ng\u00e0y ch\u1ee9ng t\u1eeb, Di\u1ec5n gi\u1ea3i chung\u2026) ph\u1ea3i nh\u1eadp gi\u1ed1ng h\u1ec7t nhau.<\/strong><\/em><\/p>\n
B\u01b0\u1edbc 2:<\/strong>\u00a0Gh\u00e9p d\u1eef li\u1ec7u<\/strong><\/p>\n
\n
H\u1ec7 th\u1ed1ng s\u1ebd t\u1ef1 \u0111\u1ed9ng gh\u00e9p c\u00e1c c\u1ed9t tr\u00ean t\u1ec7p d\u1eef li\u1ec7u v\u1edbi c\u1ed9t tr\u00ean tr\u00ean ph\u1ea7n m\u1ec1m<\/li>\n
N\u1ebfu h\u1ec7 th\u1ed1ng kh\u00f4ng gh\u00e9p \u0111\u01b0\u1ee3c c\u1ed9t ho\u1eb7c gh\u00e9p ch\u01b0a \u0111\u00fang th\u00ec anh\/ch\u1ecb c\u00f3 th\u1ec3 t\u1ef1 ch\u1ecdn l\u1ea1i c\u1ed9t cho ch\u00ednh x\u00e1c nh\u1ea5t. Nh\u1ea5n\u00a0Th\u1ef1c hi\u1ec7n.<\/strong><\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\n
Tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mong mu\u1ed1n l\u1ea5y th\u00eam ho\u1eb7c b\u1ecf b\u1edbt th\u00f4ng tin c\u1ea7n nh\u1eadp kh\u1ea9u th\u00ec c\u00f3 th\u1ec3 nh\u1ea5n \u1ea8n\/hi\u1ec7n th\u00f4ng tin<\/strong>. T\u00edch ch\u1ecdn v\u00e0o th\u00f4ng tin c\u1ea7n hi\u1ec3n th\u1ecb ho\u1eb7c b\u1ecf t\u00edch ch\u1ecdn n\u1ebfu mu\u1ed1n \u1ea9n th\u00f4ng tin \u0111\u00f3. Nh\u1ea5n \u0110\u1ed3ng \u00fd.<\/strong><\/li>\n
Sau \u0111\u00f3 nh\u1ea5n Ti\u1ebfp t\u1ee5c<\/strong> \u0111\u1ec3 chuy\u1ec3n sang B\u01b0\u1edbc 3.<\/strong><\/li>\n<\/ul>\n
B\u01b0\u1edbc 3:<\/strong>\u00a0Ki\u1ec3m tra d\u1eef li\u1ec7u<\/strong>:<\/p>\n
\n
Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd ki\u1ec3m tra to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong c\u00e1c c\u1ed9t v\u1edbi d\u1eef li\u1ec7u \u0111\u00e3 t\u1ed3n t\u1ea1i tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh v\u00e0 hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o s\u1ed1 b\u1ea3n ghi h\u1ee3p l\u1ec7\/kh\u00f4ng h\u1ee3p l\u1ec7 cho anh\/ch\u1ecb n\u1eafm \u0111\u01b0\u1ee3c:<\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\n
Khi \u0111\u00f3 anh\/ch\u1ecb c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn:<\/li>\n<\/ul>\n
\n
\n
\n
Nh\u1ea5n\u00a0Nh\u1eadp d\u1eef li\u1ec7u<\/strong>: ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd b\u1ecf qua c\u00e1c ch\u1ee9ng t\u1eeb kh\u00f4ng h\u1ee3p l\u1ec7 v\u00e0 ch\u1ec9 nh\u1eadp l\u00ean h\u1ec7 th\u1ed1ng c\u00e1c ch\u1ee9ng t\u1eeb h\u1ee3p l\u1ec7.<\/li>\n
Ki\u1ec3m tra th\u00f4ng tin chi ti\u1ebft l\u1ed7i tr\u00ean giao di\u1ec7n ho\u1eb7c nh\u1ea5n T\u1ea3i t\u1ec7p ki\u1ec3m tra<\/strong> \u0111\u1ec3 t\u1ea3i file k\u1ebft qu\u1ea3 v\u1ec1 m\u00e1y v\u00e0 ki\u1ec3m tra l\u1ea1i. Sau \u0111\u00f3 quay l\u1ea1i B\u01b0\u1edbc 1<\/strong> \u0111\u1ec3 c\u1eadp nh\u1eadt l\u1ea1i file nh\u1eadp kh\u1ea9u.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
B\u01b0\u1edbc 4:<\/strong>\u00a0Th\u00f4ng b\u00e1o k\u1ebft qu\u1ea3 nh\u1eadp li\u1ec7u<\/strong><\/p>\n
\n
Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 c\u00e1c ch\u1ee9ng t\u1eeb \u0111\u00e3 nh\u1eadp kh\u1ea9u th\u00e0nh c\u00f4ng ho\u1eb7c kh\u00f4ng th\u00e0nh c\u00f4ng d\u1ef1a theo k\u1ebft qu\u1ea3 ki\u1ec3m tra \u1edf B\u01b0\u1edbc 3.<\/strong><\/li>\n<\/ul>\n
$\"\"$ <\/p>\n
\n
Nh\u1ea5n\u00a0\u0110\u00f3ng\u00a0<\/strong>ho\u1eb7c nh\u1ea5n bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u\u00a0X<\/strong> \u0111\u1ec3 ho\u00e0n th\u00e0nh nh\u1eadp kh\u1ea9u ch\u1ee9ng t\u1eeb.<\/li>\n<\/ul>\n
L\u01b0u \u00fd:\u00a0<\/em>Sau khi nh\u1eadp kh\u1ea9u th\u00e0nh c\u00f4ng th\u00ec ch\u1ee9ng t\u1eeb s\u1ebd \u1edf tr\u1ea1ng th\u00e1i ch\u01b0a ghi s\u1ed5. Anh\/ch\u1ecb c\u1ea7n th\u1ef1c hi\u1ec7n ghi s\u1ed5 ch\u1ee9ng t\u1eeb \u0111\u1ec3 ghi nh\u1eadn b\u00fat to\u00e1n l\u00ean c\u00e1c b\u00e1o c\u00e1o, s\u1ed5 s\u00e1ch k\u1ebf to\u00e1n.<\/em><\/strong><\/p>\n<\/div><\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
1. T\u1ed5ng quan B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch nh\u1eadp kh\u1ea9u h\u00e0ng lo\u1ea1t d\u1eef li\u1ec7u (bao g\u1ed3m Danh m\u1ee5c, S\u1ed1 d\u01b0 ban \u0111\u1ea7u, v\u00e0 Ch\u1ee9ng t\u1eeb) t\u1eeb file Excel v\u00e0o ph\u1ea7n m\u1ec1m MISA iHOS K\u1ebf To\u00e1n, gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c nh\u1eadp li\u1ec7u. 2. C\u00e1ch thao…<\/p>\n","protected":false},"author":20,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"ub_ctt_via":"","footnotes":""},"ht-kb-category":[194],"ht-kb-tag":[],"class_list":["post-23725","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-cau-hoi-thuong-gap-chung"],"_links":{"self":[{"href":"\/ke-toan\/wp-json\/wp\/v2\/ht-kb\/23725","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/ke-toan\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/ke-toan\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/ke-toan\/wp-json\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"\/ke-toan\/wp-json\/wp\/v2\/comments?post=23725"}],"version-history":[{"count":6,"href":"\/ke-toan\/wp-json\/wp\/v2\/ht-kb\/23725\/revisions"}],"predecessor-version":[{"id":75573,"href":"\/ke-toan\/wp-json\/wp\/v2\/ht-kb\/23725\/revisions\/75573"}],"wp:attachment":[{"href":"\/ke-toan\/wp-json\/wp\/v2\/media?parent=23725"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/ke-toan\/wp-json\/wp\/v2\/ht-kb-category?post=23725"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/ke-toan\/wp-json\/wp\/v2\/ht-kb-tag?post=23725"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}