{"id":19333,"date":"2026-05-21T23:08:30","date_gmt":"2026-05-21T16:08:30","guid":{"rendered":"https:\/\/beup.space\/?p=19333"},"modified":"2026-05-21T23:08:32","modified_gmt":"2026-05-21T16:08:32","slug":"quan-ly-han-su-dung-ton-kho-fefo","status":"publish","type":"post","link":"https:\/\/beup.space\/en\/quan-ly-han-su-dung-ton-kho-fefo\/","title":{"rendered":"FEFO \u2014 ph\u01b0\u01a1ng ph\u00e1p qu\u1ea3n l\u00fd t\u1ed3n kho c\u1ee9u F&B v\u00e0 m\u1ef9 ph\u1ea9m kh\u1ecfi l\u1ed7 h\u00e0ng h\u1ebft h\u1ea1n"},"content":{"rendered":"

\u23f1 8 min read<\/p>\n

<\/p>\n

\n

Short answer:<\/strong> FEFO (First Expired First Out) l\u00e0 ph\u01b0\u01a1ng ph\u00e1p qu\u1ea3n l\u00fd h\u1ea1n s\u1eed d\u1ee5ng t\u1ed3n kho \u01b0u ti\u00ean xu\u1ea5t h\u00e0ng c\u00f3 h\u1ea1n g\u1ea7n nh\u1ea5t, b\u1ea5t k\u1ec3 th\u1ee9 t\u1ef1 nh\u1eadp. Kh\u00e1c v\u1edbi FIFO ch\u1ec9 x\u00e9t ng\u00e0y nh\u1eadp, FEFO x\u00e9t tr\u1ef1c ti\u1ebfp ng\u00e0y h\u1ebft h\u1ea1n c\u1ee7a t\u1eebng batch \u2014 \u0111\u00fang cho F&B, m\u1ef9 ph\u1ea9m, d\u01b0\u1ee3c ph\u1ea9m. Tri\u1ec3n khai c\u1ea7n 4 c\u1ed9t data t\u1ed1i thi\u1ec3u: SKU, batch number, expiry date, qty. Excel \u0111\u1ee7 d\u00f9ng cho d\u01b0\u1edbi 5.000 SKU.<\/p>\n<\/div>\n

Trong m\u1ed9t shop m\u1ef9 ph\u1ea9m 15 SKU \u1edf qu\u1eadn B\u00ecnh Th\u1ea1nh, k\u1ebf to\u00e1n ph\u00e1t hi\u1ec7n 28 tri\u1ec7u \u0111\u1ed3ng gi\u00e1 v\u1ed1n \u0111\u00e3 r\u1eddi kh\u1ecfi kho d\u01b0\u1edbi d\u1ea1ng h\u00e0ng ti\u00eau h\u1ee7y trong qu\u00fd v\u1eeba r\u1ed3i. Doanh s\u1ed1 t\u0103ng 18%, nh\u01b0ng l\u1ee3i nhu\u1eadn thu\u1ea7n \u0111i xu\u1ed1ng. Truy ng\u01b0\u1ee3c d\u00f2ng ti\u1ec1n: kh\u00f4ng ph\u1ea3i b\u00e1n \u1ebf. L\u00e0 xu\u1ea5t sai th\u1ee9 t\u1ef1. Nh\u00e2n vi\u00ean l\u1ea5y h\u00e0ng t\u1eeb k\u1ec7 tr\u00ean xu\u1ed1ng, kh\u00f4ng nh\u00ecn batch number. L\u00f4 v\u1ec1 sau l\u1ea1i \u0111\u01b0\u1ee3c b\u00e1n tr\u01b0\u1edbc; l\u00f4 v\u1ec1 tr\u01b0\u1edbc n\u1eb1m l\u1ea1i \u0111\u00e1y kho cho \u0111\u1ebfn khi h\u1ebft h\u1ea1n. M\u1ed9t quy t\u1eafc \u0111\u01a1n gi\u1ea3n \u2014 \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean FEFO \u2014 s\u1ebd \u0111\u00f3ng c\u00e1nh c\u1eeda n\u00e0y l\u1ea1i.<\/p>\n

\n

Article contents<\/p>\n

    \n
  1. L\u1ed7 v\u00ec h\u00e0ng h\u1ebft h\u1ea1n kh\u00f4ng ph\u1ea3i l\u1ed7 doanh s\u1ed1 \u2014 \u0111\u00f3 l\u00e0 l\u1ed7 quy tr\u00ecnh<\/a><\/li>\n
  2. FIFO kh\u00f4ng sai, nh\u01b0ng FIFO kh\u00f4ng \u0111\u1ee7 cho h\u00e0ng c\u00f3 h\u1ea1n<\/a><\/li>\n
  3. M\u1ecdi h\u1ec7 th\u1ed1ng FEFO ch\u1ea1y \u0111\u01b0\u1ee3c \u0111\u1ec1u c\u1ea7n 4 c\u1ed9t data t\u1ed1i thi\u1ec3u<\/a><\/li>\n
  4. Quy tr\u00ecnh 4 b\u01b0\u1edbc h\u1eb1ng ng\u00e0y: nh\u1eadn \u2192 c\u1ea3nh b\u00e1o \u2192 \u01b0u ti\u00ean \u2192 t\u00ednh l\u1ed7<\/a><\/li>\n
  5. Excel \u0111\u1ee7 cho d\u01b0\u1edbi 5.000 SKU \u2014 khi n\u00e0o c\u1ea7n l\u00ean ERP<\/a><\/li>\n<\/ol>\n<\/div>\n
    \n

    L\u1ed7 v\u00ec h\u00e0ng h\u1ebft h\u1ea1n kh\u00f4ng ph\u1ea3i l\u1ed7 doanh s\u1ed1 \u2014 \u0111\u00f3 l\u00e0 l\u1ed7 quy tr\u00ecnh<\/h2>\n

    Ph\u1ea7n l\u1edbn ch\u1ee7 shop F&B v\u00e0 m\u1ef9 ph\u1ea9m khi th\u1ea5y doanh s\u1ed1 t\u0103ng \u0111\u1ec1u cho r\u1eb1ng m\u1ecdi th\u1ee9 \u1ed5n. H\u1ecd nh\u00ecn b\u00e1o c\u00e1o P&L, th\u1ea5y margin gross v\u1eabn d\u01b0\u01a1ng, v\u00e0 b\u1ecf qua m\u1ed9t d\u00f2ng nh\u1ecf: write-off. Write-off l\u00e0 gi\u00e1 tr\u1ecb h\u00e0ng ph\u1ea3i h\u1ee7y v\u00ec h\u1ebft h\u1ea1n, h\u1ecfng, ho\u1eb7c l\u1ec7ch ti\u00eau chu\u1ea9n \u2014 s\u1ed1 \u0111\u00f3 \u00e2m th\u1ea7m \u0103n v\u00e0o l\u1ee3i nhu\u1eadn thu\u1ea7n v\u00e0 kh\u00f4ng xu\u1ea5t hi\u1ec7n tr\u00ean b\u00e1o doanh thu.<\/p>\n

    Theo kh\u1ea3o s\u00e1t c\u1ee7a ECR Community v\u1ec1 retail m\u1ea5t m\u00e1t h\u00e0ng h\u00f3a (2023), write-off do h\u1ebft h\u1ea1n chi\u1ebfm 5-15% gi\u00e1 tr\u1ecb t\u1ed3n kho trong c\u00e1c shop FMCG c\u00f3 m\u1eb7t h\u00e0ng nguy\u00ean li\u1ec7u t\u01b0\u01a1i, m\u1ef9 ph\u1ea9m ho\u1ea1t ch\u1ea5t, ho\u1eb7c d\u01b0\u1ee3c. Con s\u1ed1 \u0111\u00f3 cao h\u01a1n c\u1ea3 tr\u1ed9m c\u1eafp (1-3%) v\u00e0 l\u1ec7ch t\u1ed3n kho h\u1ec7 th\u1ed1ng (2-5%) c\u1ed9ng l\u1ea1i \u2014 nh\u01b0ng l\u1ea1i \u0111\u01b0\u1ee3c nh\u1eafc \u0111\u1ebfn \u00edt h\u01a1n nhi\u1ec1u trong c\u00e1c b\u00e1o c\u00e1o n\u1ed9i b\u1ed9 v\u00ec n\u00f3 kh\u00f4ng “th\u1ea5y \u0111\u01b0\u1ee3c” b\u1eb1ng m\u1eaft.<\/p>\n

    \u0110i\u1ec3m \u0111\u00e1ng ch\u00fa \u00fd: write-off do h\u1ebft h\u1ea1n kh\u00f4ng ph\u1ea3i l\u1ed7 v\u00ec b\u00e1n kh\u00f4ng h\u1ebft. \u0110\u00f3 l\u00e0 l\u1ed7 v\u00ec xu\u1ea5t sai th\u1ee9 t\u1ef1. Hai shop c\u00f9ng SKU mix, c\u00f9ng t\u1ed1c \u0111\u1ed9 b\u00e1n, m\u1ed9t shop xu\u1ea5t theo “l\u00f4 n\u00e0o d\u1ec5 l\u1ea5y” s\u1ebd l\u1ed7 g\u1ea5p 3-5 l\u1ea7n shop xu\u1ea5t theo nguy\u00ean t\u1eafc. S\u1ef1 kh\u00e1c bi\u1ec7t n\u1eb1m \u1edf quy tr\u00ecnh \u2014 kh\u00f4ng ph\u1ea3i \u1edf nh\u00e2n vi\u00ean, kh\u00f4ng ph\u1ea3i \u1edf th\u1ecb tr\u01b0\u1eddng.<\/p>\n

    \n

    FIFO kh\u00f4ng sai, nh\u01b0ng FIFO kh\u00f4ng \u0111\u1ee7 cho h\u00e0ng c\u00f3 h\u1ea1n<\/h2>\n
    \n

    FIFO<\/strong> (First In First Out) l\u00e0 ph\u01b0\u01a1ng ph\u00e1p xu\u1ea5t kho theo th\u1ee9 t\u1ef1 nh\u1eadp tr\u01b0\u1edbc xu\u1ea5t tr\u01b0\u1edbc. FEFO<\/strong> (First Expired First Out) l\u00e0 ph\u01b0\u01a1ng ph\u00e1p xu\u1ea5t kho theo th\u1ee9 t\u1ef1 h\u1ebft h\u1ea1n g\u1ea7n nh\u1ea5t tr\u01b0\u1edbc.<\/p>\n<\/div>\n

    FIFO l\u00e0 quy t\u1eafc k\u1ebf to\u00e1n chu\u1ea9n \u0111\u01b0\u1ee3c d\u1ea1y t\u1eeb gi\u00e1o tr\u00ecnh. Nh\u1eadp tr\u01b0\u1edbc th\u00ec xu\u1ea5t tr\u01b0\u1edbc \u2014 v\u1eeba \u0111\u00fang v\u1ec1 m\u1eb7t t\u00e0i ch\u00ednh (gi\u00e1 v\u1ed1n match d\u00f2ng ti\u1ec1n), v\u1eeba h\u1ee3p l\u00fd cho h\u00e0ng kh\u00f4ng c\u00f3 h\u1ea1n (g\u1ed7, kim lo\u1ea1i, thi\u1ebft b\u1ecb, v\u0103n ph\u00f2ng ph\u1ea9m). V\u1ea5n \u0111\u1ec1 l\u00e0 FIFO gi\u1ea3 \u0111\u1ecbnh m\u1ed9t \u0111i\u1ec1u ng\u1ea7m: l\u00f4 nh\u1eadp tr\u01b0\u1edbc th\u00ec h\u1ebft h\u1ea1n tr\u01b0\u1edbc. Gi\u1ea3 \u0111\u1ecbnh \u0111\u00f3 sai trong nhi\u1ec1u t\u00ecnh hu\u1ed1ng th\u1ef1c: nh\u00e0 cung c\u1ea5p x\u1ea3 t\u1ed3n n\u00ean l\u00f4 m\u1edbi v\u1ec1 c\u00f3 h\u1ea1n ng\u1eafn h\u01a1n l\u00f4 c\u0169; c\u00f9ng SKU nh\u01b0ng batch kh\u00e1c l\u1ea1i c\u00f3 shelf life kh\u00e1c nhau theo \u0111i\u1ec1u ki\u1ec7n kho; ho\u1eb7c \u0111\u1ee3t khuy\u1ebfn m\u00e3i d\u1ed3n v\u1ec1 m\u1ed9t lo\u1ea1t r\u1ed3i b\u00e1n theo nh\u1ecbp t\u1ef1 nhi\u00ean.<\/p>\n\n\n\n\n\n\n\n\n\n
    Criterion<\/th>\nFIFO<\/th>\nFEFO<\/th>\nConclusion<\/th>\n<\/tr>\n<\/thead>\n
    C\u01a1 s\u1edf xu\u1ea5t kho<\/td>\nNg\u00e0y nh\u1eadp<\/td>\nNg\u00e0y h\u1ebft h\u1ea1n<\/td>\nFEFO khi c\u00f3 batch + h\u1ea1n<\/td>\n<\/tr>\n
    Ph\u00f9 h\u1ee3p m\u1eb7t h\u00e0ng<\/td>\nKh\u00f4ng c\u00f3 h\u1ea1n<\/td>\nC\u00f3 h\u1ea1n<\/td>\nKh\u00e1c m\u1eb7t h\u00e0ng \u2192 kh\u00e1c rule<\/td>\n<\/tr>\n
    Data c\u1ea7n thi\u1ebft<\/td>\nSKU + ng\u00e0y nh\u1eadp<\/td>\nSKU + batch + expiry<\/td>\nFEFO c\u1ea7n th\u00eam 1 tr\u01b0\u1eddng<\/td>\n<\/tr>\n
    Ph\u00f2ng ng\u1eeba h\u1ebft h\u1ea1n<\/td>\nM\u1ed9t ph\u1ea7n<\/td>\nTr\u1ef1c ti\u1ebfp<\/td>\nFEFO m\u1ee5c ti\u00eau ch\u00ednh<\/td>\n<\/tr>\n
    \u0110\u00fang v\u1edbi k\u1ebf to\u00e1n gi\u00e1 v\u1ed1n<\/td>\nThere are<\/td>\nC\u00f3 (qua expiry mapping)<\/td>\nFEFO kh\u00f4ng thua FIFO<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    Summary:<\/strong> FEFO bao g\u1ed3m FIFO trong tr\u01b0\u1eddng h\u1ee3p l\u00f4 nh\u1eadp tr\u01b0\u1edbc c\u0169ng l\u00e0 l\u00f4 c\u00f3 h\u1ea1n g\u1ea7n nh\u1ea5t. Nh\u01b0ng FEFO x\u1eed l\u00fd \u0111\u00fang c\u1ea3 khi gi\u1ea3 \u0111\u1ecbnh \u0111\u00f3 sai. V\u1edbi m\u1eb7t h\u00e0ng c\u00f3 batch + h\u1ea1n s\u1eed d\u1ee5ng, m\u1eb7c \u0111\u1ecbnh n\u00ean l\u00e0 FEFO.<\/p>\n

    \n

    M\u1ecdi h\u1ec7 th\u1ed1ng FEFO ch\u1ea1y \u0111\u01b0\u1ee3c \u0111\u1ec1u c\u1ea7n 4 c\u1ed9t data t\u1ed1i thi\u1ec3u<\/h2>\n

    FEFO kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t ph\u1ea7n m\u1ec1m. \u0110\u00f3 l\u00e0 m\u1ed9t quy t\u1eafc g\u1eafn v\u00e0o c\u1ea5u tr\u00fac data t\u1ed3n kho. \u0110\u1ec3 v\u1eadn h\u00e0nh \u0111\u01b0\u1ee3c, m\u1ed7i record trong kho c\u1ea7n \u00edt nh\u1ea5t 4 tr\u01b0\u1eddng th\u00f4ng tin: SKU<\/strong> (m\u00e3 s\u1ea3n ph\u1ea9m, kh\u00f4ng thay \u0111\u1ed5i qua c\u00e1c l\u00f4); batch number<\/strong> (m\u00e3 l\u00f4, do nh\u00e0 s\u1ea3n xu\u1ea5t g\u00e1n, in tr\u00ean bao b\u00ec); expiry date<\/strong> (ng\u00e0y h\u1ebft h\u1ea1n c\u1ee5 th\u1ec3, kh\u00f4ng ph\u1ea3i shelf life ng\u00e0y t\u00ednh t\u1eeb s\u1ea3n xu\u1ea5t); v\u00e0 qty<\/strong> (s\u1ed1 l\u01b0\u1ee3ng c\u00f2n l\u1ea1i trong l\u00f4 \u0111\u00f3).<\/p>\n

    N\u1ebfu thi\u1ebfu b\u1ea5t k\u1ef3 tr\u01b0\u1eddng n\u00e0o trong 4 tr\u01b0\u1eddng, FEFO kh\u00f4ng ch\u1ea1y \u0111\u01b0\u1ee3c. Thi\u1ebfu batch number \u2014 kh\u00f4ng ph\u00e2n bi\u1ec7t \u0111\u01b0\u1ee3c l\u00f4. Thi\u1ebfu expiry \u2014 kh\u00f4ng s\u1eafp th\u1ee9 t\u1ef1 \u0111\u01b0\u1ee3c. Thi\u1ebfu qty per batch \u2014 kh\u00f4ng bi\u1ebft l\u00f4 n\u00e0o \u0111\u00e3 h\u1ebft. Trong th\u1ef1c t\u1ebf, nhi\u1ec1u shop nh\u1ecf ghi t\u1ed3n kho theo SKU duy nh\u1ea5t, g\u1ed9p t\u1ea5t c\u1ea3 l\u00f4 l\u1ea1i th\u00e0nh m\u1ed9t d\u00f2ng. \u0110\u00f3 l\u00e0 l\u00fd do FEFO kh\u00f4ng c\u00e0i l\u00ean \u0111\u01b0\u1ee3c h\u1ec7 th\u1ed1ng c\u1ee7a h\u1ecd, kh\u00f4ng ph\u1ea3i v\u00ec h\u1ecd thi\u1ebfu ph\u1ea7n m\u1ec1m.<\/p>\n

    B\u01b0\u1edbc \u0111\u1ea7u ti\u00ean kh\u00f4ng ph\u1ea3i mua c\u00f4ng c\u1ee5, m\u00e0 l\u00e0 ph\u00e2n t\u00e1ch l\u00f4 \u2014 \u0111\u1ea3m b\u1ea3o t\u1eeb l\u00fac nh\u1eadp h\u00e0ng, m\u1ed7i l\u00f4 \u0111\u01b0\u1ee3c g\u00e1n batch + expiry \u0111\u1ed9c l\u1eadp, d\u00f9 SKU gi\u1ed1ng nhau. V\u1edbi c\u1ea5u tr\u00fac n\u00e0y, m\u1ed9t file Excel v\u1edbi 4 c\u1ed9t + c\u00f4ng th\u1ee9c sort theo expiry l\u00e0 \u0111\u1ee7 \u0111\u1ec3 b\u1eaft \u0111\u1ea7u.<\/p>\n

    \n

    Quy tr\u00ecnh 4 b\u01b0\u1edbc h\u1eb1ng ng\u00e0y: nh\u1eadn \u2192 c\u1ea3nh b\u00e1o \u2192 \u01b0u ti\u00ean \u2192 t\u00ednh l\u1ed7<\/h2>\n

    H\u1ec7 th\u1ed1ng data ch\u1ec9 c\u00f3 gi\u00e1 tr\u1ecb khi c\u00f3 quy tr\u00ecnh v\u1eadn h\u00e0nh k\u00e8m. FEFO trong th\u1ef1c t\u1ebf c\u1ea7n 4 h\u00e0nh \u0111\u1ed9ng h\u1eb1ng ng\u00e0y, kh\u00f4ng b\u01b0\u1edbc n\u00e0o skipped \u0111\u01b0\u1ee3c.<\/p>\n

    B\u01b0\u1edbc 1 \u2014 Nh\u1eadn h\u00e0ng c\u00f3 g\u00e1n batch.<\/strong> Khi h\u00e0ng v\u1ec1, nh\u00e2n vi\u00ean kho kh\u00f4ng ch\u1ec9 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng. M\u1ed7i th\u00f9ng ph\u1ea3i \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o h\u1ec7 th\u1ed1ng d\u01b0\u1edbi d\u1ea1ng m\u1ed9t record c\u00f3 SKU + batch number + expiry date ri\u00eang. 30 gi\u00e2y m\u1ed7i th\u00f9ng. N\u1ebfu b\u1ecf qua b\u01b0\u1edbc n\u00e0y, m\u1ecdi b\u01b0\u1edbc sau v\u00f4 ngh\u0129a \u2014 v\u00ec sau \u0111\u00f3 kh\u00f4ng c\u00e1ch n\u00e0o t\u00e1ch \u0111\u01b0\u1ee3c l\u00f4.<\/p>\n

    B\u01b0\u1edbc 2 \u2014 C\u1ea3nh b\u00e1o s\u1edbm theo 2 m\u1ed1c.<\/strong> L\u00f4 n\u00e0o c\u00f2n 30 ng\u00e0y tr\u01b0\u1edbc h\u1ebft h\u1ea1n \u2192 c\u1ea3nh b\u00e1o T-30 (t\u0103ng c\u01b0\u1eddng xu\u1ea5t). L\u00f4 n\u00e0o c\u00f2n 7 ng\u00e0y \u2192 c\u1ea3nh b\u00e1o T-7 (\u0111\u1ea9y m\u1ea1nh, c\u00f3 th\u1ec3 gi\u1ea3m gi\u00e1 \u0111\u1ec3 gi\u1ea3i ph\u00f3ng). C\u1ea3nh b\u00e1o ph\u1ea3i t\u1ef1 \u0111\u1ed9ng hi\u1ec3n th\u1ecb tr\u00ean dashboard m\u1ed7i s\u00e1ng, kh\u00f4ng ph\u1ea3i \u0111\u1ee3i cu\u1ed1i tu\u1ea7n ki\u1ec3m th\u1ee7 c\u00f4ng.<\/p>\n

    B\u01b0\u1edbc 3 \u2014 \u01afu ti\u00ean xu\u1ea5t theo expiry.<\/strong> Khi c\u00f3 \u0111\u01a1n, h\u1ec7 th\u1ed1ng ch\u1ec9 \u0111\u1ecbnh batch n\u00e0o l\u1ea5y tr\u01b0\u1edbc. Nh\u00e2n vi\u00ean kho kh\u00f4ng quy\u1ebft \u0111\u1ecbnh b\u1eb1ng m\u1eaft. Nguy\u00ean t\u1eafc: trong c\u00f9ng SKU, batch c\u00f3 expiry s\u1edbm nh\u1ea5t lu\u00f4n xu\u1ea5t tr\u01b0\u1edbc, k\u1ec3 c\u1ea3 khi n\u00f3 n\u1eb1m \u1edf v\u1ecb tr\u00ed kho kh\u00f3 v\u1edbi h\u01a1n.<\/p>\n

    B\u01b0\u1edbc 4 \u2014 T\u00ednh write-off \u0111\u1ecbnh k\u1ef3.<\/strong> M\u1ed7i th\u00e1ng t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb \u0111\u00e3 h\u1ee7y v\u00ec h\u1ebft h\u1ea1n. Con s\u1ed1 n\u00e0y l\u00e0 KPI v\u1eadn h\u00e0nh, kh\u00f4ng ph\u1ea3i s\u1ed1 t\u00e0i ch\u00ednh cu\u1ed1i n\u0103m. \u0110o n\u00f3 h\u00e0ng th\u00e1ng \u0111\u1ec3 th\u1ea5y quy tr\u00ecnh c\u00f3 c\u1ea3i thi\u1ec7n hay kh\u00f4ng. 4 b\u01b0\u1edbc n\u00e0y bi\u1ebfn FEFO t\u1eeb kh\u00e1i ni\u1ec7m s\u00e1ch gi\u00e1o khoa th\u00e0nh th\u00f3i quen v\u1eadn h\u00e0nh.<\/p>\n

    \n

    Excel \u0111\u1ee7 cho d\u01b0\u1edbi 5.000 SKU \u2014 khi n\u00e0o c\u1ea7n l\u00ean ERP<\/h2>\n

    Excel v\u00e0 Google Sheets ch\u1ea1y \u0111\u01b0\u1ee3c FEFO kh\u00e1 t\u1ed1t cho quy m\u00f4 v\u1eeba. V\u1edbi 4 tr\u01b0\u1eddng data + c\u00f4ng th\u1ee9c sort + conditional formatting cho c\u1ea3nh b\u00e1o T-30\/T-7, m\u1ed9t b\u1ea3ng t\u00ednh \u1ed5n \u0111\u1ecbnh c\u00f3 th\u1ec3 x\u1eed l\u00fd v\u00e0i ngh\u00ecn SKU v\u00e0 v\u00e0i ch\u1ee5c nh\u00e2n vi\u00ean nh\u1eadp li\u1ec7u d\u00f9ng chung. Quan tr\u1ecdng h\u01a1n: t\u01b0 duy quy tr\u00ecnh \u0111\u01b0\u1ee3c \u00e9p v\u00e0o c\u1ea5u tr\u00fac file ngay t\u1eeb \u0111\u1ea7u, ai m\u1edf file ra c\u0169ng ph\u1ea3i tu\u00e2n th\u1ee7.<\/p>\n

    Ranh gi\u1edbi: khi v\u01b0\u1ee3t 5.000 SKU active ho\u1eb7c 3 kho v\u1eadt l\u00fd, Excel b\u1eaft \u0111\u1ea7u ch\u1eadm. Sort 5.000 d\u00f2ng \u00d7 nhi\u1ec1u batch + conditional formatting n\u1eb7ng c\u00f3 th\u1ec3 l\u00e0m file load 10-30 gi\u00e2y m\u1ed7i l\u1ea7n m\u1edf. Concurrency c\u0169ng b\u1eaft \u0111\u1ea7u v\u1ee1: nhi\u1ec1u nh\u00e2n vi\u00ean c\u00f9ng s\u1eeda, version conflict xu\u1ea5t hi\u1ec7n. L\u00fac \u0111\u00f3 c\u1ea7n l\u00ean ERP c\u00f3 module inventory lot\/batch tracking \u2014 Odoo, Misa AMIS, ho\u1eb7c NetSuite t\u00f9y quy m\u00f4. Nh\u01b0ng k\u1ec3 c\u1ea3 khi l\u00ean ERP, c\u1ea5u tr\u00fac data + 4 b\u01b0\u1edbc quy tr\u00ecnh \u1edf tr\u00ean kh\u00f4ng thay \u0111\u1ed5i \u2014 ch\u1ec9 l\u00e0 chuy\u1ec3n t\u1eeb Excel sang database.<\/p>\n

    Excel kh\u00f4ng ph\u1ea3i v\u1ea5n \u0111\u1ec1. Quy tr\u00ecnh m\u1edbi l\u00e0 v\u1ea5n \u0111\u1ec1. Doanh nghi\u1ec7p ch\u01b0a c\u00f3 quy tr\u00ecnh FEFO tr\u00ean Excel th\u00ec l\u00ean ERP c\u0169ng kh\u00f4ng t\u1ef1 nhi\u00ean c\u00f3. Ng\u01b0\u1ee3c l\u1ea1i, doanh nghi\u1ec7p \u0111\u00e3 c\u00f3 quy tr\u00ecnh FEFO tr\u00ean Excel th\u00ec vi\u1ec7c migrate sang ERP sau n\u00e0y ch\u1ec9 l\u00e0 k\u1ef9 thu\u1eadt, kh\u00f4ng ph\u1ea3i x\u00e2y l\u1ea1i t\u01b0 duy.<\/p>\n

    \n
    \n

    Key takeaways<\/p>\n