์˜์–ดํ”„๋ž‘์Šค์–ด์ŠคํŽ˜์ธ์–ด

Ad


์˜จ์›์Šค ํŒŒ๋น„์ฝ˜

Windows์šฉ Excel-to-tally-ํ…œํ”Œ๋ฆฟ ๋‹ค์šด๋กœ๋“œ

๋ฌด๋ฃŒ๋กœ Excel-to-tally-templates Windows ์•ฑ์„ ๋‹ค์šด๋กœ๋“œํ•˜์—ฌ Ubuntu ์˜จ๋ผ์ธ, Fedora ์˜จ๋ผ์ธ ๋˜๋Š” Debian ์˜จ๋ผ์ธ์—์„œ Wine ์Šน๋ฆฌ ์˜จ๋ผ์ธ ์‹คํ–‰

์ด๊ฒƒ์€ Excel-to-tally-templates-v11-r1.0.zip์œผ๋กœ ์ตœ์‹  ๋ฆด๋ฆฌ์Šค๋ฅผ ๋‹ค์šด๋กœ๋“œํ•  ์ˆ˜ ์žˆ๋Š” Excel-to-tally-templates๋ผ๋Š” Windows ์•ฑ์ž…๋‹ˆ๋‹ค. ์›Œํฌ์Šคํ…Œ์ด์…˜์šฉ ๋ฌด๋ฃŒ ํ˜ธ์ŠคํŒ… ์ œ๊ณต์—…์ฒด OnWorks์—์„œ ์˜จ๋ผ์ธ์œผ๋กœ ์‹คํ–‰ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

๋ฌด๋ฃŒ๋กœ OnWorks์™€ ํ•จ๊ป˜ Excel-to-tally-templates๋ผ๋Š” ์•ฑ์„ ์˜จ๋ผ์ธ์œผ๋กœ ๋‹ค์šด๋กœ๋“œํ•˜์—ฌ ์‹คํ–‰ํ•˜์‹ญ์‹œ์˜ค.

์ด ์•ฑ์„ ์‹คํ–‰ํ•˜๋ ค๋ฉด ๋‹ค์Œ ์ง€์นจ์„ ๋”ฐ๋ฅด์„ธ์š”.

- 1. ์ด ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜์„ PC์— ๋‹ค์šด๋กœ๋“œํ–ˆ์Šต๋‹ˆ๋‹ค.

- 2. ํŒŒ์ผ ๊ด€๋ฆฌ์ž https://www.onworks.net/myfiles.php?username=XXXXX์— ์›ํ•˜๋Š” ์‚ฌ์šฉ์ž ์ด๋ฆ„์„ ์ž…๋ ฅํ•ฉ๋‹ˆ๋‹ค.

- 3. ์ด๋Ÿฌํ•œ ํŒŒ์ผ ๊ด€๋ฆฌ์ž์—์„œ ์ด ์‘์šฉ ํ”„๋กœ๊ทธ๋žจ์„ ์—…๋กœ๋“œํ•ฉ๋‹ˆ๋‹ค.

- 4. ์ด ์›น์‚ฌ์ดํŠธ์—์„œ ๋ชจ๋“  OS OnWorks ์˜จ๋ผ์ธ ์—๋ฎฌ๋ ˆ์ดํ„ฐ๋ฅผ ์‹œ์ž‘ํ•˜์ง€๋งŒ ๋” ๋‚˜์€ Windows ์˜จ๋ผ์ธ ์—๋ฎฌ๋ ˆ์ดํ„ฐ๋ฅผ ์‹œ์ž‘ํ•ฉ๋‹ˆ๋‹ค.

- 5. ๋ฐฉ๊ธˆ ์‹œ์ž‘ํ•œ OnWorks Windows OS์—์„œ ์›ํ•˜๋Š” ์‚ฌ์šฉ์ž ์ด๋ฆ„์œผ๋กœ ํŒŒ์ผ ๊ด€๋ฆฌ์ž https://www.onworks.net/myfiles.php?username=XXXXX๋กœ ์ด๋™ํ•ฉ๋‹ˆ๋‹ค.

- 6. ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜์„ ๋‹ค์šด๋กœ๋“œํ•˜์—ฌ ์„ค์น˜ํ•ฉ๋‹ˆ๋‹ค.

- 7. Linux ๋ฐฐํฌ ์†Œํ”„ํŠธ์›จ์–ด ์ €์žฅ์†Œ์—์„œ Wine์„ ๋‹ค์šด๋กœ๋“œํ•ฉ๋‹ˆ๋‹ค. ์„ค์น˜๊ฐ€ ์™„๋ฃŒ๋˜๋ฉด ์•ฑ์„ ๋‘ ๋ฒˆ ํด๋ฆญํ•˜์—ฌ Wine๊ณผ ํ•จ๊ป˜ ์‹คํ–‰ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ์ธ๊ธฐ ์žˆ๋Š” Windows ํ”„๋กœ๊ทธ๋žจ ๋ฐ ๊ฒŒ์ž„์„ ์„ค์น˜ํ•˜๋Š” ๋ฐ ๋„์›€์ด ๋˜๋Š” Wine์„ ํ†ตํ•œ ๋ฉ‹์ง„ ์ธํ„ฐํŽ˜์ด์Šค์ธ PlayOnLinux๋ฅผ ์‚ฌ์šฉํ•ด ๋ณผ ์ˆ˜๋„ ์žˆ์Šต๋‹ˆ๋‹ค.

Wine์€ Linux์—์„œ Windows ์†Œํ”„ํŠธ์›จ์–ด๋ฅผ ์‹คํ–‰ํ•˜๋Š” ๋ฐฉ๋ฒ•์ด์ง€๋งŒ Windows๊ฐ€ ํ•„์š”ํ•˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค. Wine์€ ๋ชจ๋“  Linux ๋ฐ์Šคํฌํƒ‘์—์„œ ์ง์ ‘ Windows ํ”„๋กœ๊ทธ๋žจ์„ ์‹คํ–‰ํ•  ์ˆ˜ ์žˆ๋Š” ์˜คํ”ˆ ์†Œ์Šค Windows ํ˜ธํ™˜์„ฑ ๊ณ„์ธต์ž…๋‹ˆ๋‹ค. ๋ณธ์งˆ์ ์œผ๋กœ Wine์€ Windows๊ฐ€ ํ•„์š”ํ•˜์ง€ ์•Š๊ณ  ๋ชจ๋“  Windows ์‘์šฉ ํ”„๋กœ๊ทธ๋žจ์„ ์‹คํ–‰ํ•  ์ˆ˜ ์žˆ๋„๋ก Windows๋ฅผ ์ฒ˜์Œ๋ถ€ํ„ฐ ์ถฉ๋ถ„ํžˆ ๋‹ค์‹œ ๊ตฌํ˜„ํ•˜๋ ค๊ณ  ํ•ฉ๋‹ˆ๋‹ค.

์Šคํฌ๋ฆฐ ์ƒท

Ad


Excel-to-tally-ํ…œํ”Œ๋ฆฟ


๊ธฐ์ˆ 

Excel์„ Tally ํ…œํ”Œ๋ฆฟ์œผ๋กœ ๋‹ค์šด๋กœ๋“œ

๋ฐ์ดํ„ฐ๋ฅผ Tally๋กœ ๊ฐ€์ ธ์˜ค๊ธฐ ์œ„ํ•ด udiMagic ์†Œํ”„ํŠธ์›จ์–ด์™€ ํ•จ๊ป˜ ์—ฌ๋Ÿฌ Excel ํ…œํ”Œ๋ฆฟ์ด ์ œ๊ณต๋˜์—ˆ์Šต๋‹ˆ๋‹ค. ์ด ํ”„๋กœ์ ํŠธ์—๋Š” ์ด์ „ ๋ฒ„์ „์˜ ํ…œํ”Œ๋ฆฟ์„ ํฌํ•จํ•œ ๋ชจ๋“  ์ตœ์‹  Excel ํ…œํ”Œ๋ฆฟ ํŒŒ์ผ์ด ํฌํ•จ๋˜์–ด ์žˆ์Šต๋‹ˆ๋‹ค.

Tally๋กœ ๋ฐ์ดํ„ฐ๋ฅผ ๊ฐ€์ ธ์˜ค๋Š” ๋‹จ๊ณ„
1. ํƒˆ๋ฆฌ ERP ์‹œ์ž‘ ๋ฐ ํšŒ์‚ฌ ๊ฐœ์„ค
2. udiMagic ์†Œํ”„ํŠธ์›จ์–ด ์‹œ์ž‘
3. Excel์—์„œ ์ง‘๊ณ„ํ•  ์˜ต์…˜์„ ์„ ํƒํ•ฉ๋‹ˆ๋‹ค.
4. ๋ฐ์ดํ„ฐ๋ฅผ Tally๋กœ ๊ฐ€์ ธ์˜ค๊ธฐ ์˜ต์…˜์„ ์„ ํƒํ•ฉ๋‹ˆ๋‹ค.
5. ์ฐพ์•„๋ณด๊ธฐ ๋ฒ„ํŠผ์„ ํด๋ฆญํ•˜๊ณ  udiMagic ๋ณ€ํ™˜๊ธฐ์™€ ํ•จ๊ป˜ ์ œ๊ณต๋˜๋Š” ํ‘œ์ค€ Excel ํ…œํ”Œ๋ฆฟ์„ ์„ ํƒํ•ฉ๋‹ˆ๋‹ค.
6. ์‹œ์ž‘ ๋ฒ„ํŠผ์„ ํด๋ฆญํ•ฉ๋‹ˆ๋‹ค.

์ด ์ €์žฅ์†Œ์—๋Š” Excel ํ…œํ”Œ๋ฆฟ๋งŒ ํฌํ•จ๋˜์–ด ์žˆ์Šต๋‹ˆ๋‹ค. udiMagic ์†Œํ”„ํŠธ์›จ์–ด๋Š” ๋ณ„๋„๋กœ ๋‹ค์šด๋กœ๋“œํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค. https://www.rtslink.com/downloads/ ์ด ํ…œํ”Œ๋ฆฟ์˜ ๋ฐ์ดํ„ฐ๋ฅผ Tally ERP 9๋กœ ๊ฐ€์ ธ์˜ต๋‹ˆ๋‹ค. udiMagic์˜ ๋ฐ๋ชจ ๋ฒ„์ „์€ ์ œํ•œ๋œ ๊ธฐ๊ฐ„ ๋™์•ˆ ๋ฌด๋ฃŒ๋กœ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

์—์„œ Excel to Tally์— ๋Œ€ํ•œ ๋ชจ๋“  ๊ฒƒ์„ ์ฝ์–ด๋ณด์‹ญ์‹œ์˜ค. https://www.rtslink.com



ํŠน์ง•

  • Excel์—์„œ ์ง‘๊ณ„
  • ์—‘์…€ ํ…œํ”Œ๋ฆฟ
  • ํƒˆ๋ฆฌ๋กœ ๊ฐ€์ ธ์˜ค๊ธฐ


์˜ค๋””์–ธ์Šค (Audience)

๊ณ ๊ธ‰ ์ตœ์ข… ์‚ฌ์šฉ์ž




์นดํ…Œ๊ณ ๋ฆฌ

ํšŒ๊ณ„

https://sourceforge.net/projects/excel-to-tally-templates/์—์„œ๋„ ๊ฐ€์ ธ์˜ฌ ์ˆ˜ ์žˆ๋Š” ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜์ž…๋‹ˆ๋‹ค. ๋ฌด๋ฃŒ ์šด์˜ ์ฒด์ œ ์ค‘ ํ•˜๋‚˜์—์„œ ๊ฐ€์žฅ ์‰ฌ์šด ๋ฐฉ๋ฒ•์œผ๋กœ ์˜จ๋ผ์ธ์œผ๋กœ ์‹คํ–‰ํ•˜๊ธฐ ์œ„ํ•ด OnWorks์—์„œ ํ˜ธ์ŠคํŒ…๋˜์—ˆ์Šต๋‹ˆ๋‹ค.


๋ฌด๋ฃŒ ์„œ๋ฒ„ ๋ฐ ์›Œํฌ์Šคํ…Œ์ด์…˜

Windows ๋ฐ Linux ์•ฑ ๋‹ค์šด๋กœ๋“œ

Linux ๋ช…๋ น

  • 1
    aa-ํด๋ฆญ ์ฟผ๋ฆฌ
    aa-ํด๋ฆญ ์ฟผ๋ฆฌ
    aa-clickquery - ์ฟผ๋ฆฌ ํ”„๋กœ๊ทธ๋žจ
    click-apparmor ์„ค๋ช…: ์ด ํ”„๋กœ๊ทธ๋žจ
    click-apparmor๋ฅผ ์ฟผ๋ฆฌํ•˜๋Š” ๋ฐ ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค.
    ์ •๋ณด. ์‚ฌ์šฉ๋ฒ•: aa-clickquery
    --ํด๋ฆญ-ํ”„๋ผ...
    aa-clickquery ์‹คํ–‰
  • 2
    aa-exec-ํด๋ฆญ
    aa-exec-ํด๋ฆญ
    aa-exec-click - ์‹คํ–‰ ํ”„๋กœ๊ทธ๋žจ
    ๊ฐ๊ธˆ๋œ ํŒจํ‚ค์ง€ ํด๋ฆญ
    ์„ค๋ช…: ์ด ํ”„๋กœ๊ทธ๋žจ์€ ๋‹ค์Œ๊ณผ ๊ฐ™์€ ์šฉ๋„๋กœ ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค.
    AppArmor์—์„œ ํด๋ฆญ ํŒจํ‚ค์ง€ ์‹คํ–‰
    ์ œํ•œ. ๋‚˜...
    aa-exec-click ์‹คํ–‰
  • 3
    ์ฝ”์–ด์„ผ๋“œmsg
    ์ฝ”์–ด์„ผ๋“œmsg
    coresendmsg - CORE API ๋ฉ”์‹œ์ง€ ๋ณด๋‚ด๊ธฐ
    ์ฝ”์–ด ๋ฐ๋ชฌ ๋ฐ๋ชฌ์œผ๋กœ ...
    coresendmsg ์‹คํ–‰
  • 4
    core_server
    core_server
    core_server - ๊ธฐ๋ณธ ์„œ๋ฒ„
    SpamBayes. ์„ค๋ช…: ํ˜„์žฌ ์„œ๋น„์Šค ์ค‘
    ์›น ์ธํ„ฐํŽ˜์ด์Šค๋งŒ. ์—ฐ๊ฒฐ
    ๋‹ค์–‘ํ•œ ํ”„๋กœํ† ์ฝœ์— ๋Œ€ํ•œ ๋ฆฌ์Šค๋„ˆ๋Š” ๋ฏธ์ •์ž…๋‹ˆ๋‹ค.
    ์ด๊ฑด ...
    core_server ์‹คํ–‰
  • 5
    Gappletviewer-4.8
    Gappletviewer-4.8
    gappletviewer - ์• ํ”Œ๋ฆฟ ๋กœ๋“œ ๋ฐ ์‹คํ–‰
    ...
    gappletviewer-4.8 ์‹คํ–‰
  • 6
    Gappletviewer-4.9
    Gappletviewer-4.9
    gappletviewer - ์• ํ”Œ๋ฆฟ ๋กœ๋“œ ๋ฐ ์‹คํ–‰
    ...
    gappletviewer-4.9 ์‹คํ–‰
  • ๋”ยป

Ad