Kev thau khoom los ntawm Excel hauv 1C: Cov Lus Qhia Ua Haujlwm

Twb tau ntev dhau los, cov kev pab cuam nrov tshaj plaws ntawm cov neeg ua hauj lwm, cov phiaj xwm kev lag luam, cov kws tshaj lij kev lag luam thiab cov thawj coj yog Annex 1c. Nws tsis yog tsuas yog muaj ntau yam kev teeb tsa rau ntau yam kev ua si, tab sis kuj hauv cheeb tsam kom muaj kev suav nyiaj txiag hauv ntau lub teb chaws ntawm lub ntiaj teb. Ntau thiab ntau cov lag luam tau pauv mus rau hauv cov kev pab cuam no. Tab sis cov txheej txheem rau kev hloov cov ntaub ntawv ntawm lwm cov kev pabcuam nyiaj txiag hauv 1C yog ib qho kev kawm ntev thiab tho txawv, uas siv qhov chaw. Yog tias tus neeg lag luam tau kaw cia siv Excel, tus txheej txheem hloov tuaj yeem yog automatic automated thiab nrawm.

Hloov cov ntaub ntawv los ntawm Excel rau 1c

Hloov cov ntaub ntawv los ntawm Excel hauv 1c yog qhov yuav tsum tsis txhob tsuas yog nyob ntawm thawj zaug ua haujlwm nrog txoj haujlwm no. Qee lub sij hawm nws los txog qhov xav tau ntawm qhov no thaum, nyob rau hauv chav kawm ntawm kev ua si, koj yuav tsum muab qee cov npe khaws cia hauv phau ntawv txheej txheem. Piv txwv li, yog tias koj xav tau pauv cov npe nqi lossis xaj los ntawm cov khw online. Nyob rau hauv rooj plaub thaum cov npe yog me me, ces lawv tuaj yeem tsav tau los ntawm manually, tab sis kuv yuav tsum ua li cas yog tias lawv muaj ntau pua yam khoom? Txhawm rau kom cov txheej txheem nrawm, koj tuaj yeem tsim qee cov nta ntxiv.

Yuav luag txhua hom ntaub ntawv yuav tsim nyog rau kev tsim nyog rub tawm:

• Sau npe ntawm nomenclature;
• Daim ntawv teev cov counterparties;
• Cov npe ntawm cov nqi;
• Daim ntawv teev cov xaj;
• Cov ntaub ntawv hais txog kev yuav khoom lossis muag khoom, thiab lwm yam.

Tam sim ntawd nws yuav tsum tau sau tseg tias nyob rau hauv 1c muaj tsis muaj cov cuab yeej ua tsim tau uas yuav tso cai rau koj hloov cov ntaub ntawv los ntawm Excel. Rau cov hom phiaj no, koj yuav tsum txuas ib qho kev ua yeeb yam sab nraud, uas yog cov ntaub ntawv hauv EPF hom.

Kev npaj cov ntaub ntawv

Peb yuav tau npaj cov ntaub ntawv hauv lub rooj excel nws tus kheej.

1. Txhua daim ntawv loaded hauv 1C yuav tsum yog kev sib txuam. Koj tsis tuaj yeem rub tawm yog tias muaj ntau hom ntaub ntawv hauv ib kem lossis ntawm tes, piv txwv li, tus neeg lub npe thiab nws tus lej xov tooj. Hauv qhov no, xws li ob chav ntaub ntawv yuav tsum tau sib cais rau hauv cov kab sib txawv.



2. Nws tsis raug tso cai kom muaj kev sib xyaw cov hlwb txawm nyob hauv cov lus qhia. Qhov no tuaj yeem ua rau tsis raug thaum muaj kev hloov pauv. Yog li ntawd, yog tias cov cell sib xyaw muaj, lawv yuav tsum muab faib.



3. Yog tias cov hauv paus rooj yog ua kom yooj yim li sai tau thiab tsis tau thov cov thev naus laus zis, piv txwv, ntxiv cov ntsiab lus kom ua kom ntau cov teeb meem ntawm cov kauj ruam ntxiv.



4. Nco ntsoov coj lub npe ntawm txhua qhov tseem ceeb rau ib hom. Tsis muaj kev cai tsis pub, piv txwv li, ib phaus uas tso tawm los ntawm cov ntaub ntawv sib txawv: "kg", "kilogram", "kg.". Qhov kev zov me nyuam yuav nkag siab lawv raws li cov nqi sib txawv, yog li koj yuav tsum xaiv ib txoj kev xaiv, thiab tus so yog tsau nyob rau hauv cov qauv no.



5. Nco ntsoov muaj cov cim tshwj xeeb. Cov ntsiab lus ntawm ib kem tuaj yeem ua si hauv lawv lub luag haujlwm, uas tsis rov ua dua rau lwm tus kab: tus lej them tus kheej, piv txwv, thiab lwm yam. Yog tias tsis muaj kem nyob rau hauv lub rooj uas twb muaj lawm nrog tus nqi zoo sib xws, koj tuaj yeem ntxiv ib kem ntxiv thiab tsim cov lej ntxiv thiab tsim cov lej ntxiv muaj. Qhov no tsim nyog txhawm rau txhawm rau txheeb xyuas cov ntaub ntawv nyob rau txhua kab sib cais, thiab tsis "sib xyaw ua ke" lawv ua ke.



6. Feem ntau cov ntaub ntawv ua haujlwm Excel cov ntaub ntawv tsis ua haujlwm nrog XLSX hom, tab sis tsuas yog nrog XLS hom. Yog li ntawd, yog tias peb cov ntaub ntawv muaj kev nthuav dav ntawm XLSX, tom qab ntawd nws yog qhov tsim nyog los hloov nws. Ua li no, mus rau "cov ntaub ntawv" tab thiab nyem rau ntawm "Tseg li" khawm.

   

   Tus cawm lub qhov rais qhib. Lub neej ntawd XLSX hom ntawv yuav tau teev nyob rau hauv "Cov Ntaub Ntawv Ntaub Ntawv". Peb hloov nws mus rau phau ntawv "Phau Ntawv Excel 97-2003" thiab nyem rau ntawm "Tseg" khawm.

   

   Tom qab ntawd, cov ntaub ntawv yuav tau txais kev cawm dim hauv hom kev xav tau.

Ntxiv rau cov kev ua thoob ntiaj teb rau kev npaj ntawm cov ntaub ntawv nyob rau hauv phau ntawv ntawm Excel, uas peb yuav siv, tab sis peb yuav tham txog nws tsuas yog hauv qab no.

Txuas Txuas Sab Nraud Bootloader

Txuas ib lub khau raj sab nraud nrog EPF txuas ntxiv rau Daim Ntawv Ntxiv 1C tuaj yeem yog ua ntej npaj cov ntaub ntawv Excel thiab tom qab. Qhov loj tshaj plaws yog kom pib cov txheej txheem ntawm kev ua Downloads ob ntawm cov kev npaj lub sijhawm no tau daws lawm.

Muaj ob peb sab nraud exile ntsiav tshuaj rau 1c, uas yog tsim los ntawm ntau tus neeg tsim khoom. Peb yuav xav txog qhov ua piv txwv uas siv cov cuab yeej rau kev ua cov ntaub ntawv "rub tawm cov ntaub ntawv los ntawm cov ntawv tabla" rau version 1c 8.3.

1. Tom qab cov ntaub ntawv nyob rau hauv hom Epf tau rub tawm thiab tau txais kev cawmdim ntawm lub hard disk ntawm lub khoos phis tawm, pib ua 1c program. Yog tias EPF cov ntaub ntawv tau ntim rau hauv cov archive, ces nws yuav tsum tau muab tshem tawm ntawm qhov ntawd. Nyob rau sab qaum kab rov tav kawg vaj huam sib luag, nias lub pob uas khiav cov ntawv qhia zaub mov. Hauv version 1C 8.3, nws tau nthuav tawm nyob rau hauv daim ntawv ntawm cov duab peb sab ncig uas sau rau hauv lub txiv kab ntxwv ntawm txoj kev ncig, lub kaum sab xis. Hauv cov npe uas tshwm sim, ua ntu zus mus dhau ntawm cov ntaub ntawv "" thiab "qhib".



2. Cov ntaub ntawv qhib qhov rais pib. Mus rau phau ntawv qhia ntawm nws qhov chaw, peb tau hais txog qhov khoom thiab nyem rau ntawm "Qhib" khawm.



3. Tom qab ntawd, lub bootloader yuav pib hauv 1C.

Tso cov ntaub ntawv "rub tawm cov ntaub ntawv los ntawm cov ntaub ntawv"

Chaw thau khoom cov ntaub ntawv

Ib qho ntawm cov ntaub ntawv tseem ceeb nrog cov 1C ua haujlwm yog cov npe khoom thiab cov kev pabcuam. Yog li ntawd, los piav qhia txog cov txheej txheem thauj khoom ntawm Excel, peb yuav ua kom pom tseeb txog qhov piv txwv ntawm kev hloov pauv ntawm cov hom ntaub ntawv no.

1. Rov qab mus rau lub qhov rais ua. Txij li thaum peb yuav thauj cov khoom lag luam, tom qab ntawd hauv "parameter mus rau" parameter, tus hloov yuav tsum tau sawv ntsug hauv "txoj hauj lwm. Txawm li cas los xij, nws yog li nruab los ntawm lub neej ntawd. Koj yuav tsum hloov nws tsuas yog thaum koj yuav hloov lwm cov ntaub ntawv hom: tabular ntu lossis cov ntaub ntawv sau npe. Tom ntej no, hauv qhov chaw "Saib ntawm cov npe" los ntawm nias ntawm lub pob uas cov teev tau piav qhia. Daim ntawv teev cia poob qis. Hauv nws, peb yuav tsum xaiv cov khoom "nomrlature".



2. Tom qab ntawd, lub handler cia li muab cov teb uas cov kev pab cuam siv nyob rau hauv daim ntawv ntawm phau ntawv teev npe. Nws yog ib qho yuav tsum tau nco ntsoov nco ntsoov tias nws tsis tas yuav sau txhua daim teb.



3. Tam sim no rov qhib ib daim ntawv pov thawj portable. Yog hais tias lub npe ntawm nws cov kab txawv ntawm lub npe ntawm 1C cov lus qhia chaw, uas muaj qhov tsim nyog, tom qab ntawd koj yuav tsum tau hloov dua tshiab rau cov npe yog li qub. Yog tias muaj cov kab hauv lub rooj rau uas tsis muaj ib qho piv rau hauv phau ntawv teev npe, lawv yuav tsum tau muab tshem tawm. Hauv peb kis, cov kab ntawv ntawd yog "ntau dua" thiab "tus nqi". Nws yuav tsum tau ntxiv tias kev txiav txim ntawm kab ntawv kab hauv cov ntaub ntawv yuav tsum nruj me ntsis coincide nrog ib tus neeg nthuav tawm. Yog tias rau qee cov kab uas tau tso tawm hauv lub bootloader koj tsis muaj cov ntaub ntawv, tom qab ntawd cov kab ntawv no tuaj yeem tso tau tas, tab sis cov lej ntawm cov ntaub ntawv uas yuav tsum ua kom sib cais. Txog kev yooj yim thiab nrawm ntawm kev kho kom raug, koj tuaj yeem thov cov tshwj xeeb tshwj xeeb ntawm Excel kom sai sai txav cov chaw los ntawm cov chaw.

   Tom qab cov kev ua no yog tsim tawm, nyem rau ntawm "Txuag" icon, uas yog sawv cev ua ib qho hluav taws xob disk nyob rau sab laug sab sauv ntawm lub qhov rais. Tom qab ntawd kaw cov ntaub ntawv los ntawm txhaj rau lub pob txheem kaw.



4. Rov qab mus rau 1c ua qhov rais. Nyem rau ntawm "Qhib" khawm, uas yog xwm fab xwm li daim nplaub tshev daj.



5. Cov ntaub ntawv qhib qhov rais pib. Mus rau hauv phau ntawv teev npe uas cov ntaub ntawv Excel nyob, uas peb xav tau. Lub neej ntawd cov ntaub ntawv xa cov zaub hloov pauv tau teeb tsa kom nthuav cov MxL. Txhawm rau qhia cov ntaub ntawv koj xav tau, nws yuav tsum tau rov kho nws mus rau txoj haujlwm "cov ntawv zoo". Tom qab ntawd, peb faib cov ntaub ntawv sau thiab nyem rau ntawm "Qhib" khawm.



6. Tom qab ntawd, cov ntsiab lus tau qhib hauv lub handler. Txhawm rau tshawb xyuas qhov tseeb ntawm sau rau cov ntaub ntawv, nyem rau ntawm "Sau tswj".



7. Raws li koj tuaj yeem pom, cov cuab yeej tswj tau los qhia rau peb tias qhov yuam kev tsis pom.



8. Tam sim no peb tsiv mus rau "Chaw" tab. Hauv "Tshawb nrhiav" peb muab tus zuam nyob rau hauv txoj kab uas txhua lub npe nkag mus hauv cov timerenclature yuav yog qhov tshwj xeeb. Feem ntau cov feem ntau rau qhov no siv cov teb "tsab xov xwm" lossis "lub npe". Nws yog qhov tsim nyog los ua kom thaum ntxiv txoj haujlwm tshiab rau cov npe, cov ntaub ntawv tsis tau muab.



9. Tom qab tag nrho cov ntaub ntawv tau tsim thiab chaw teeb tsa tau ua, koj tuaj yeem mus rau txoj cai rub tawm ncaj qha hauv cov ntawv qhia. Txhawm rau ua qhov no, nyem rau ntawm cov ntawv sau "Download tau ntaub ntawv".



10. Cov kauj vab khau raj yog ua. Tom qab ua tiav nws, koj tuaj yeem mus rau cov ntawv qhia nomenclllature thiab paub tseeb tias txhua cov ntaub ntawv tsim nyog tau ntxiv nyob ntawd.

Zaj Lus Qhia: Yuav ua li cas hloov cov kab hauv cov chaw hauv Excel

Peb traced cov txheej txheem rau ntxiv cov ntaub ntawv rau cov ntawv qhia nomenclature hauv qhov program 1C 8.3. Rau lwm cov phau ntawv siv thiab cov ntaub ntawv, lub rub tawm yuav tau nqa tawm ntawm tib lub ntsiab cai, tab sis nrog qee tus neeg siv yuav nkag siab txog nws tus kheej. Nws kuj yuav tsum tau sau tseg tias cov kev sib txawv ntawm peb tog neeg tuaj yeem sib txawv cov ntaub ntawv ntawm lub qhov rai uas nws tau muab kho, thiab tsuas yog tom qab ntawd nws tau txuas ntxiv rau 1C database.