POS SYSTEM RAU SHOPS, GROCERIES AND SERVICE CENTERS FROM EXCEL Nrog Siv Barcodes: 7 Kauj Ruam

2024 Tus sau: John Day | [email protected]. Kawg hloov kho: 2024-01-30 09:27

Kuv qhia nrog cov blog no rau koj li cas los tsim lub POS yooj yim (taw tes ntawm kev muag khoom) cov kab ke rau cov khw muag khoom me me thiab cov chaw pabcuam. Nrog rau txoj hauv kev no koj tuaj yeem tswj hwm cov chaw hauv qab no yam tsis muaj software tshwj xeeb lossis khoom siv kim. v Tshaj tawm daim nqi muag khoom siv tus lej bar v Tswj kev yuav khoom v Tswj cov khoom lag luam v Hnub kawg thiab hli xaus cov khoom seem v Kev muag txhua hnub v Kev yuav khoom txhua hnub MS Excel POS system tshiab hloov tshiab muaj nyob hauv www.wygworld.com

Kauj ruam 1: Tsim phau ntawv ua haujlwm

Koj xav tau kev paub me ntsis txog excel macro los ua qhov yooj yim no, Txwv tsis pub koj tuaj yeem rub cov ntawv qub qub los ntawm kuv lub xaib ntawm no.

LOS YOG Tshiab Version rub tawm ntawm no. Ua ntej tsim phau ntawv ua haujlwm zoo nrog 6 daim ntawv ua haujlwm raws li qhov no: 1. Nqi 2. Pur 3. Muas 4. Muag Khoom 5. Tshuav nyiaj tshuav 6. Teeb tsa

Kauj ruam 2: Tsim Nplooj Ntawv Teeb

Tom ntej: Tsim cov nplooj ntawv teeb tsa nrog cov npe no thiab teeb tsa koj cov khoom lag luam. Qeb: yam khoom qeb Code: Tsim cov cai tshwj xeeb rau koj txhua yam khoom. Qhov no yuav tsum yog tus lej tshwj xeeb tsis muaj rau txhua yam khoom thiab siv qhov no los tsim cov lej barcodes. Exp: Raws li qhov no, nqa tag nrho cov khoom lag luam khoom lag luam & tsim cov cai thiab hloov daim ntawv nrog qhib qhib, pur.price thiab Seles tus nqi. Koj yuav tsum muab tus nqi yuav khoom raug thiab tus nqi muag khoom vim tias thaum koj tawm daim nqi, tus nqi yuav tuaj ntawm daim ntawv no. Qhib qhov nyiaj tshuav yuav txuas nrog daim ntawv tshuav nyiaj hauv tuam txhab. Bar code tsim: koj tuaj yeem tsim bar code nrog koj cov lej khoom, siv tus tsim barcode online lossis koj tuaj yeem rub tawm software barcode los ua nws.

Kauj Ruam 3: Tsim Daim Ntawv Tshuav Nyiaj Txiag:

Tsim daim ntawv no nrog cov npe hauv qab no: Luam cov mis no rau txhua kab thiab theej muab tshuaj txhuam rau hauv qab: Code: = YOG (teeb tsa! $ B $ 3: $ B $ 323 "", teeb tsa! $ B $ 3: $ B $ 323, "") Nqe lus piav qhia: = YOG (teeb tsa! $ C $ 3: $ C $ 323 "", teeb tsa! $ C $ 3: $ C $ 323, "") Qhib Tshuav: = SUM (IF (B3 = teeb tsa! $ B $ 3: $ B $ 1021, teeb tsa ! $ D $ 3: $ D $ 1021)) Kev yuav khoom: = SUM (IF (B3 = kev yuav khoom! $ B $ 2: $ B $ 2005, kev yuav! $ D $ 2: $ D $ 2005)) Muag: = SUM (IF (B3 = muag khoom) ! $ H $ 2: $ H $ 2551, muag! $ J $ 2: $ J $ 2551)) Tshuag: =+D3+E3-F3

Kauj Ruam 4: Tsim Daim Ntawv Sau Npe:

Tsim cov ntawv raws li hom ntawv no thiab muab cov lej hauv qab no rau txhua kab thiab tsim cov lej nrog cov lej hauv qab no. Kab: = YOG (C5 = "", "", B4+1) Code: Tsim cov npe kab txuas nrog teeb tsa nplooj nplooj ntawv cov npe khoom thiab npe. thaum koj txuas tus lej nyeem kab ntawv nrog cov lej cim kab cim cov ntsiab lus yuav pib xaiv. Nqe lus piav qhia: = I4 Qty: kab ntawv no koj yuav tsum nkag mus rau tus kheej raws li cov neeg yuav khoom qty. Nqe: = YOG (E4 = "", "", VLOOKUP (C4, al, 5, 0)*E4) ** macro for Save bill Tsim ib lub pob hu ua Txuag nqi thiab luam qhov chaws no: Koj tuaj yeem rub daim ntawv no rau kuv ntaub ntawv. Sub Dayendsales () '' Dayendsales Macro '' Sheets ("Tsales"). Xaiv Kab ("G: G"). Xaiv Selection. Insert Shift: = xlToRight, CopyOrigin: = xlFormatFromLeftOrAbove Range ("E2: E255"). Xaiv Selection.copy Range ("G2"). Xaiv Selection. PasteSpecial Paste: = xlPasteValues, Ua Haujlwm: = xlNone, SkipBlanks _: = Cuav, Hloov: = Cov Ntawv Cuav ("muag"). Xaiv Range ("B3: D1572"). Select Application. CutCopyMode = False Selection. ClearContents Range ("D3"). Xaiv End Sub Sub DayendPurchases () '' DayendPurchases Macro 'Sheets ("Tpurchase"). Xaiv Kab ("F: F"). Xaiv Selection. Insert Ua haujlwm: = xlToRight, CopyOrigin: = xlFormatFromLeftOrAbove Range ("D2: D643"). Xaiv Selection.copy Range ("F2"). Xaiv Selection. PasteSpecial Paste: = xlPasteValues, Ua Haujlwm: = xlNone, SkipBlanks _: Tsis raug,: = Cuav Application. CutCopyMode = Cov Ntawv Cuav ("kev yuav khoom"). Xaiv Range ("C3: D625"). Xaiv Selection. ClearContents Range ("E3"). Xaiv End Sub Sub SaveBill () '' SaveBill Macro 'Thov. Khiav "'khw muag khoom tswj.xls'! Luam" Application. Run "'khw muag khoom tswj.xls'! SaleReplace" End Sub Sub HnubEnd () '' DayEnd Macro End Sub

Kauj Ruam 5: Tsim Cov Ntawv Pur:

raws li hom ntawv no.

Kauj Ruam 6: Tam sim no Tsim Kev Yuav thiab Muag Cov Ntaub Ntawv Txuag Nplooj Ntawv Nrog Cov Qauv no:

Tam sim no tsim Kev Yuav thiab muag cov ntaub ntawv khaws nplooj ntawv nrog hom ntawv no:

Kauj Ruam 7: Macro Code Koj Yuav Luam Kuv Daim Ntawv

Macro code koj tuaj yeem luam kuv daim ntawv. Tom qab txhua tus qauv thiab cov lej tsim koj tuaj yeem ua haujlwm rau lub system. Thaum koj khaws daim nqi, cov ntsiab lus yuav khaws cia muag cov ntaub ntawv thiab nws yuav hloov kho cov khoom muag. Qhov kawg ntawm lub hlis khaws cov ntaub ntawv raws li lub npe tshiab thiab rho tawm cov ntaub ntawv qub ntawm kev muag thiab yuav cov ntaub ntawv ua haujlwm. Ua ntej rho tawm, luam daim ntawv kaw cov khoom seem rau teeb tsa nplooj qhib qhib kab sib luag. Koj tuaj yeem rub tawm Cov ntawv qub qub ua kuv li blog

lossis Hloov tshiab ua daim ntawv Txuas no