packing 다운로드 맞춤엑셀 쿠키 7 page

카테고리

실시간 추천

상가 관리비 정산을 자동으로 하고 청구서를 뽑을수 있는 프로그램 요청 2024-11-21 coukeynew***

답변 완료 되었습니다.
지역주택조합 가입자 분담금 자동계산 프로그램 제작 요청 2024-11-19 ssispor***

답변 완료 되었습니다.
[견적요청] 청구서자동출력 프로그램 a4 2024-11-15 dbsal***

답변 완료 되었습니다.
업무문제를 요청에 맞춰 자동화 엑셀을 추천해 드립니다.
(0 / 300)

통합검색

'packing'검색에 대한 결과입니다.

맞춤제작 전문가 답변 검색결과 4,300건

계약관리 업무 자동화 맞춤 요청

pan style="font-size: 14.6667px;"> pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">1.업종 : IT 도소매pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;"> pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">2.예산 : 500만원 (공수에따라 변경 가능)pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;"> pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">3.제작 요청사항pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;"> 네트워크/보안 장비를 판매/서비스/유지보수하는 업체로pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;"> 계약유형에 따른 계약관리를 표준화 시키는것이 목표입니다.pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;"> pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;"> 기존 방식은 각 부서별,계약유형별 문서형식이 크고 작은 차이가 있어 통합에 문제가 있었으며pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;"> 파일 기반으로 정보를 공유하다 보니 정보유실,최신화 등의 문제가 있었습니다.pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;"> pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;"> 이를 개선하고자 pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;"> 각 사업별 거래처/상품/매입/매출 정보를 하나의 데이터베이스에 저장후 관리하고pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;"> 다수의 사용자가 등록 및 수정(서식 수정 불가)하는 방식으로 개발을 의뢰하려 합니다. pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">1)업무흐름 및 기존 업무방식pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;"> pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;"> 기존 계약관리업무는 신규 사업 발생시pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;"> pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;"> 1. 계약상세(거래처/물품/매입/매출/이익/기타 비용) 작성 --- 결제용 인쇄pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;"> 2. 계약추진보고서(계약상세내용 항목별 합계 및 기타사항 으로 구성) --- 결제용 인쇄pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;"> 3. 별도의 파일로 부서 월별 통계(실적보고용 수동계산) 및 계약목록을 통합하여 관리함pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">2)자동화하고 싶은 업무pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">*pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">1. 초기 접속시 계약 현황 시트에서 계약에 대한 통계 현황pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">2. 신규 계약상세내역을 등록하여 전체계약목록에 저장(DB화), pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">3. 계약상세내역을 계약추진보고서(보고용)로 자동 입력pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">4. 전체계약목록 등록된 목록을 검색하여 내용 확인 및 수정pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">5. 그 외 분류별 DB 등록(제조사,물품 DB 등)pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">그 외 추가 기능(향후 구현 예정)pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">재무부서에서 매입매출 여부 확인, 미수채권 계약 확인pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">기타 문의사항pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">1. 로컬 DB가 아닌 구글스프레드 시트 또는 클라우드 서버 사용 방식pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">2. 로컬 DB 구성의 경우 시스템 장애시 백업/복구 방법pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;"> pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">3. 맞춤요청 관련하여 오프라인 미팅 가능하시면 알려주세요pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;">
pan>
pan style="font-size: 14.6667px;"> pan>

경리 · 회계 > 업무자동화 | 조회 271 | 답변완료(1)

거래명세서 자동화 문의

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">1.업종 ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">: 건설품질연구원ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">(품질시험ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">)

ng=EN-US style="mso-fareast-font-family: 함초롬바탕">

pan class='search_bold'>pacpan>e prefix = "o" />

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">2.예산 ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">:

ng=EN-US style="mso-fareast-font-family: 함초롬바탕">

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">3.제작 요청사항

업체가 상당히 많아 거래명세서를 일일이 만들어야 하는 번거로움과 오래걸리는 시간때문에

자동화프로그램을 알아보던중에 알게되어 문의드립니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

ng=EN-US style="mso-fareast-font-family: 함초롬바탕">

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">1)업무흐름 및 기존 업무방식

시험 의뢰서를 받고 성적서가 나가면 월말에 업체별로 청구를 하여 수작업으로 업체별 거래명세서를 작성후 송부하고 잇습니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

거래명세서를 월말마다 업체별로 엑셀 필터후 수작업으로 건건히 복사ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">,붙여넣기로 작업을하였으나 양이 너무 많아 시간이 많이 소요되어 업체별 자동화 거래명세서 프로그램 문의 드립니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

샘플로 저희회사 양식 첨부합니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">2)자동화하고 싶은 업무

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">*업체별 거래명세서 자동화

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">*

ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">*

경리 · 회계 > 업무자동화 | 조회 2513 | 답변완료(1)

상가빌딩전용 관리비청구 프로그램개발
상가빌딩 관리사무소 세부내역 대장입니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

pan class='search_bold'>pacpan>e prefix = "o" />

ng=EN-US style="mso-fareast-font-family: 함초롬바탕">

관리비청구 프로그램을 쓰고있는데ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">. 너무 복잡하고 일이 많아서ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">. 엑셀폼으로 개발하고싶습니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

ng=EN-US style="mso-fareast-font-family: 함초롬바탕">

본내용이 보편적 상가빌딩의 항목이며ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 내용을 토대로 호실별ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 또는 상가ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">(그룹ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">)별로 고지서 출력까지 연동하고 싶습니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

ng=EN-US style="mso-fareast-font-family: 함초롬바탕">

고지서에서 전체 전기료ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 수도세ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 보험비가 나오며 상가별로 사용내역이 표기되면 좋을 것 같습니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

ng=EN-US style="mso-fareast-font-family: 함초롬바탕">

회사로고도 삽입되면 좋구요ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

ng=EN-US style="mso-fareast-font-family: 함초롬바탕">

본고지서는 납기후금액을 나타낼 수 있는 란도 있음 좋을 것 같습니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.(이자율ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">5%)

ng=EN-US style="mso-fareast-font-family: 함초롬바탕">

추가로 본고지서는 문자이미지 파일 및 출력 청구가 되며ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 대표계좌 또는 가상계좌번호란도 들어가야 할 것 같습니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

ng=EN-US style="mso-fareast-font-family: 함초롬바탕">

자동이체 ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">cms신청란과 전월 수납확인서도 삽입되면 좋을 것 같구ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">, 자체적으로 수납확인을 체크할 수 있는 란도 있어서 통합월별 종합납부현황페이도 있으면 좋을 것 같습니다ng=EN-US style="LETTER-SPACING: 0pt; mso-fareast-font-family: 함초롬바탕; mso-font-width: 100%; mso-text-raise: 0pt">.

경리 · 회계 > 업무자동화 | 조회 3363 | 답변완료(1)

[이벤트신청] 주문관리 엑셀프로그램 견적을 받고 싶습니다

pan style="font-size: 11pt;">

pan lang="EN-US" style="font-family: 돋움; letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-weight: bold; font-size: 11pt; color: rgb(51, 51, 51);">1.pan>pan style="font-family: 돋움; font-weight: bold; font-size: 11pt; color: rgb(51, 51, 51);">업종 pan>pan lang="EN-US" style="font-family: 돋움; letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt; font-weight: bold; font-size: 11pt; color: rgb(51, 51, 51);">: pan>pan style="font-family: 돋움; font-weight: bold; font-size: 11pt; color: rgb(51, 51, 51);">생산업pan>
pan>
pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;color:#333333;"> pan>
pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;color:#333333;">2.pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;font-weight:bold;font-size:11.0pt;color:#333333;">예산 pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;color:#333333;">: pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;font-weight:bold;font-size:11.0pt;color:#333333;">미정 pan>
pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;color:#333333;"> pan>
pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;color:#333333;">3.pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;font-weight:bold;font-size:11.0pt;color:#333333;">제작 요청사항pan>
pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;color:#333333;"> pan>
pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-weight:bold;font-size:11.0pt;color:#333333;">1)pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;font-weight:bold;font-size:11.0pt;color:#333333;">업무흐름 및 기존 업무방식pan>
pan style="font-family:돋움;mso-fareast-font-family:돋움;font-size:11.0pt;color:#333333;">의뢰인 인적사항 기재pan>
pan style="font-family:돋움;mso-fareast-font-family:돋움;font-size:11.0pt;color:#333333;">신품목에따른 생산일수pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;color:#333333;">(pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;font-size:11.0pt;color:#333333;">계절pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;color:#333333;">,pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;font-size:11.0pt;color:#333333;">절기 등에 따라 각각 입력저장pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;color:#333333;">) pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;font-size:11.0pt;color:#333333;">및 예상손실률pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;color:#333333;">, pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;font-size:11.0pt;color:#333333;">원가 입력pan>
pan style="font-family:돋움;mso-fareast-font-family:돋움;font-size:11.0pt;color:#333333;">품목에 따라 생산중 중간작업일수 지정pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;color:#333333;">(pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;font-size:11.0pt;color:#333333;">계절pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;color:#333333;">,pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;font-size:11.0pt;color:#333333;">절기 등에 따라 각각 입력저장pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;color:#333333;">)pan>
pan style="font-family:돋움;mso-fareast-font-family:돋움;font-size:11.0pt;color:#333333;">주문입력pan>
pan style="font-family:돋움;mso-fareast-font-family:돋움;font-size:11.0pt;color:#333333;">주문에 따른 출하량지정pan>
pan style="font-family:돋움;mso-fareast-font-family:돋움;font-size:11.0pt;color:#333333;">주문에 따른 가격지정pan>
pan style="font-family:돋움;mso-fareast-font-family:돋움;font-size:11.0pt;color:#333333;">재고수량 계산pan>
pan style="font-family:돋움;mso-fareast-font-family:돋움;font-size:11.0pt;color:#333333;">주문 및 작업시작일자pan>pan lang="EN-US" style="mso-fareast-font-family:돋움;font-family:돋움;mso-ascii-font-family:돋움;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;color:#333333;">, pan>pan style="font-family:돋움;mso-fareast-font-family:돋움;font-size:11.0pt;color:#333333;">중간작업일자 출력pan>
pan style="font-family:돋움;mso-fareast-font-family:돋움;font-size:11.0pt;color:#333333;">계산서 출력pan>
pan style="font-size: 11pt;">
ng>2)자동화하고 싶은 업무ng>

pan>
경리 · 회계 > 업무자동화 | 조회 1057 | 답변완료(2)

아파트(300세개) 관리 및 임대계약관리 르로그램

1.업종 : 아파트관리 및 임대 계약관리

2.예산 :

3.제작 요청사항

1)업무흐름 및 기존 업무방식



ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">1.단지관리ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">(단지정보등록ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">.동호생성ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">.세대검침환경등록ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">.공동동호관리ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">.입주단체등록ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">.연말정산기본등록 이용ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">pc 등록 ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">.과거데이터요청ng=EN-US style="FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">

ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">2.입주자

ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">   1)입주처리ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">(입주등록ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">,소유주변동처리ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">,관리예치금ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">(선수관리ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">),출입카드발급등록ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">)

ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">   2)전출처리ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">(장기수선충당금ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">,전출처리ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">,전입ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">/전출자현황ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">,중간정산서조회ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">)

ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">   3)조회관리ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">(단지현황ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">)

ng=EN-US style="FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt"> ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">3.검침

ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt"> 1)전기검침

ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">  2)수도검침

ng=EN-US style="FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">  ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">4)관리비 부과

ng=EN-US style="FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt"> ng=EN-US style="FONT-SIZE: 11pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">5)수납ng=EN-US style="FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">

ng=EN-US style="FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">4. 임대 계약관리

ng=EN-US style="FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt"> ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">1) 계약자 인적사항ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">(성명ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">, 생년월일ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">, 전화ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">, 가족사항 ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">)

ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕">ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">            2) 계약일ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">(계약기간ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">)

ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">             ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">3) 보증금납부

            ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">4) 입주시 시설상태ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">(사진ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">)

ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕">ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">             5) 퇴거시 시설상태ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">(사진ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">)

ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕">ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">             6) 계약서 전면ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">(사진ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">)

ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕">ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">             7) 계약만료 ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">2개월전 알림 문자 멧시지 기능

ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕">ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">             8) 각세대별 내역 검색기능ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">(입주 월별 일별 만료 ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">2개월전 겸색ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">)

ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕">ng=EN-US style="FONT-SIZE: 12pt; FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">             9) 특이사항 기록부

ng=EN-US style="FONT-FAMILY: 함초롬바탕; LETTER-SPACING: 0pt; mso-font-width: 100%; mso-text-raise: 0.0pt">

2)자동화하고 싶은 업무
*
*
*

경리 · 회계 > 업무자동화 | 조회 2604 | 답변완료(1)

PJT 입력 및 성과분석 엑셀

pan style="font-size: 11pt;">
pan style="font-size:11.0pt;font-family:돋움;mso-bidi-font-family: 굴림;color:#333333;mso-font-kernpan class='search_bold'>ingpan>:0pt">저희는 화학 원재료를 무역하는 업체입니다pan lang="EN-US">.pan>pan>
pan lang="EN-US" style="font-size:11.0pt;font-family:돋움; mso-bidi-font-family:굴림;color:#333333;mso-font-kernpan class='search_bold'>ingpan>:0pt"> pan>
pan style="font-size:11.0pt;font-family:돋움;mso-bidi-font-family: 굴림;color:#333333;mso-font-kernpan class='search_bold'>ingpan>:0pt">현재 영업pan lang="EN-US">, pan>구매pan lang="EN-US">, pan>물류pan lang="EN-US">, pan>재무부서가 함께 일하고 있지만 각각의 업무내용을 한 장표가 아닌 각각의 부서에서 엑셀로 관리하고 있어서 이것을 하나의 프로그램으로 통합하려고 합니다pan lang="EN-US">.pan>pan>
pan lang="EN-US" style="font-size:11.0pt;font-family:돋움; mso-bidi-font-family:굴림;color:#333333;mso-font-kernpan class='search_bold'>ingpan>:0pt"> pan>
pan style="font-size:11.0pt;font-family:돋움;mso-bidi-font-family: 굴림;color:#333333;mso-font-kernpan class='search_bold'>ingpan>:0pt">영업팀이 고객확보를 하면 구매팀이 이를 바탕으로 구매하며 물류팀이 배송관리 및 유통관리 등을 실시합니다pan lang="EN-US">. pan>pan>
pan lang="EN-US" style="font-size:11.0pt;font-family:돋움; mso-bidi-font-family:굴림;color:#333333;mso-font-kernpan class='search_bold'>ingpan>:0pt"> pan>
pan style="font-size:11.0pt;font-family:돋움;mso-bidi-font-family: 굴림;color:#333333;mso-font-kernpan class='search_bold'>ingpan>:0pt">영업pan lang="EN-US">, pan>구매pan lang="EN-US">, pan>물류pan lang="EN-US">, pan>재무부서에서 각각의 정보를 입력하면 종합성과 및 차트분석이 자동으로 완성되는 시스템을 구축하길 희망합니다pan lang="EN-US">.pan>pan>
pan lang="EN-US" style="font-size:11.0pt;font-family:돋움; mso-bidi-font-family:굴림;color:#333333;mso-font-kernpan class='search_bold'>ingpan>:0pt"> pan>
pan style="font-size:11.0pt;font-family:돋움;mso-bidi-font-family: 굴림;color:#333333;mso-font-kernpan class='search_bold'>ingpan>:0pt">관련 엑셀파일 첨부합니다pan lang="EN-US">.pan>pan>
pan lang="EN-US" style="font-size:11.0pt;font-family:돋움; mso-bidi-font-family:굴림;color:#333333;mso-font-kernpan class='search_bold'>ingpan>:0pt"> pan>

pan style="font-size:11.0pt;font-family:돋움; mso-bidi-font-family:굴림;color:#333333;mso-font-kernpan class='search_bold'>ingpan>:0pt">자동화하고 싶은 업무pan>pan lang="EN-US" style="font-size:11.0pt;font-family:돋움;mso-bidi-font-family:굴림; color:#333333;mso-font-kernpan class='search_bold'>ingpan>:0pt">
*pan>pan style="font-size:11.0pt;font-family:돋움;mso-bidi-font-family:굴림; color:#333333;mso-font-kernpan class='search_bold'>ingpan>:0pt">각 부서에서 업무내용 입력시 종합성과 및 차트분석이 자동으로 되길 희망pan lang="EN-US">
*pan>열람 권한부여가 가능했으면 좋겠습니다pan lang="EN-US">. (pan>영업은 영업만pan lang="EN-US"> / pan>구매는 영업pan lang="EN-US">,pan>구매만pan lang="EN-US"> / pan>물류는 영업pan lang="EN-US">,pan>구매pan lang="EN-US">,pan>물류만pan lang="EN-US"> / pan>재무는 영업pan lang="EN-US">, pan>구매pan lang="EN-US">, pan>물류pan lang="EN-US">, pan>재무 모두 열람 가능 등과 같이pan lang="EN-US">)
*pan>정해진 기간안에 구매pan lang="EN-US">, pan>오더pan lang="EN-US">, pan>수금 등이 됐는지 자동으로 파악된다면 좋겠습니다pan lang="EN-US">.pan>pan>
pan style="font-size:11.0pt;font-family:돋움;mso-bidi-font-family:굴림; color:#333333;mso-font-kernpan class='search_bold'>ingpan>:0pt">pan lang="EN-US">
pan>pan>
ace="돋움">위 내용을 프로그램이 아닌 엑셀 파일에 함수 등을 설정하여 제작이 가능한지 궁금합니다. 가능하다면 견적단가도 알려주시면 감사하겠습니다. 또한 일전에 위 내용과 동일하게 엑셀이 아닌 프로그램 제작을 의뢰했었는데 그때 요청사항과 유사한 데모 프로그램을 받아보고 싶습니다.
pan>
경리 · 회계 > 업무자동화 | 조회 2578 | 답변완료(2)

[이벤트신청]상가빌딩전용 관리비청구 프로그램개발
상가빌딩 관리사무소 세부내역 대장입니다ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">

관리비청구 프로그램을 쓰고있는데ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">. 너무 복잡하고 일이 많아서ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">. 엑셀폼으로 개발하고싶습니다ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">

본내용이 보편적 상가빌딩의 항목이며ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">, 내용을 토대로 호실별ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">, 또는 상가ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">(그룹ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">)별로 고지서 출력까지 연동하고 싶습니다ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">

고지서에서 전체 전기료ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">, 수도세ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">, 보험비가 나오며 상가별로 사용내역이 표기되면 좋을 것 같습니다ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">

회사로고도 삽입되면 좋구요ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">

본고지서는 납기후금액을 나타낼 수 있는 란도 있음 좋을 것 같습니다ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.(이자율ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">5%)

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">

추가로 본고지서는 문자이미지 파일 및 출력 청구가 되며ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">, 대표계좌 또는 가상계좌번호란도 들어가야 할 것 같습니다ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">

자동이체 ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">cmsng=EN-US style="mso-fareast-font-family: 함초롬바탕"> 신청란과 전월 수납확인서도 삽입되면 좋을 것 같구ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">, 자체적으로 수납확인을 체크할 수 있는 란도 있어서 통합월별 종합납부현황페이도 있으면 좋을 것 같습니다ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.

pan class='search_bold'>pacpan>e prefix = "o" />

경리 · 회계 > 업무자동화 | 조회 2610 | 답변완료(3)

교육 수료증을 출력하기 위한 엑셀 프로그램을 주문해 만들고자 합니다.

pan style="font-size: 11pt;">

pan style="font-size: 11pt; font-family: 함초롬바탕;">교육 수료증을 출력하기 위한 엑셀 프로그램을 주문해 만들고자 합니다pan>pan lang="EN-US" style="font-size: 11pt; letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>: 0pt;">.pan>
pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-size:11.0pt;">가능여부pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;">, pan>pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-size:11.0pt;">비용pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;">, pan>pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-size:11.0pt;">기간 등을 답변 주시면 감사하겠습니다pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;">.pan>

pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-size:11.0pt;">필요한 사항은 아래와 같습니다pan>

pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;">-pan>pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-size:11.0pt;">아래pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;">-pan>

pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-size:11.0pt;">관리자가 수강생 명단과 이력을 엑셀로 입력합니다pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;">.pan>
pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-size:11.0pt;">수강생은 웹상pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;">(pan>pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-size:11.0pt;">구글드라이브 등pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;">)pan>pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-size:11.0pt;">에 올려진 수강생 명단 파일에서 자신의 이름과 휴대전화 번호를 입력해 자신이 수강 받은 수료증을 pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;">PDF pan>pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-size:11.0pt;">파일로 출력합니다pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;">. pan>pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-size:11.0pt;">이때 수료증은 워터마크와 기관장의 직인 이미지가 들어가야 합니다pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;">.pan>

pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-size:11.0pt;">관리자는 엑셀로 된 수강생 명단을 보고 선택하여 수료증pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;">(PDF pan>pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-size:11.0pt;">파일pan>pan lang="EN-US" style="mso-fareast-font-family:함초롬바탕;mso-font-width:100%;letter-span class='search_bold'>pacpan>pan class='search_bold'>ingpan>:0pt;mso-text-raise:0pt;font-size:11.0pt;">)pan>pan style="font-family:함초롬바탕;mso-fareast-font-family:함초롬바탕;font-size:11.0pt;">을 대량 출력할 수 있습니다pan>
pan>
경리 · 회계 > 업무자동화 | 조회 1848 | 답변완료(3)

맞춤 제작 문의
안녕하세요

이00 입니다.

지금 저희 맞춤상품으로 제작되고 있는 것에서 요청사항이 있어서 알려드립니다.

pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt" lang="EN-US">(pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">유선상담내용중pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt"> pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">수정사항pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt" lang="EN-US">) pan>

pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt" lang="EN-US">1. pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">권한별로pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt"> pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">입출고기능제한pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt" lang="EN-US">(pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">간이로그인pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt" lang="EN-US">) pan>

pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt" lang="EN-US">2. pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">제품상단에pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt"> pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">메뉴바pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt"> pan>ace="굴림">pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">공통디자인적용pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt" lang="EN-US"> pan>

pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt" lang="EN-US">3. pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">검색시pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt"> pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">결과내용pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt"> pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">팝업으로pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt"> pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">띄우기pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt" lang="EN-US">(pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">상품코드pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt" lang="EN-US">o, pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">상품명pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt" lang="EN-US">x) pan>

pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt" lang="EN-US">4. [pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">상품별재고조회pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt" lang="EN-US">] pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">상품번호별이pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt"> pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">아니라pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt"> pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">제품별로pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt"> pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">현재고집계pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt" lang="EN-US"> + pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">제품별로pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt"> pan>ace="굴림">pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">입출고내역pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt" lang="EN-US"> pan>

pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt" lang="EN-US">5. [pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">상품별재고조회pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt" lang="EN-US">] pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">상품목록pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt"> pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">상단에pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt"> pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">넘버링pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt" lang="EN-US">MAX + pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">전상품현재고합산pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt"> pan>pan style="FONT-SIZE: 10pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial">ace="굴림">반영pan>pan style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt" lang="EN-US"> pan>

부탁드리겠습니다.

--------------------------------------------------------

고객님의 업체명과 담당자 성함, 연락처 등의 소중한 개인정보는
비공개로 수정해드렸습니다.
엑셀쿠키에서 내용접수하였으니, 확인후 답변드리겠습니다^^
--------------------------------------------------------

경리 · 회계 > 업무자동화 | 조회 2072 | 답변완료(1)

맞춤 제작 및 컨텐츠 추천 문의

1.업종 : 자동차부품 도소매 및 제조

2.예산 : 미정

3.제작 요청사항

1)업무흐름 및 기존 업무방식

* 업무 흐름

pan class='search_bold'>pacpan>pan class='search_bold'>ingpan>=0 cellPaddpan class='search_bold'>ingpan>=0> pan=11>

pan=11>ace="맑은 고딕">두가지 원단을 합지 타발가공하여 품질검사 (외관, 이물질) 후 자사 재고보관 및 물류대행 업체에게 출하관리 하는 상황
pan=5>ace="맑은 고딕">불량수량으로 인하여 실시간 재고 파악 불가