카테고리
실시간 추천
-
(0 / 300)
통합검색
'dashboard'검색에 대한 결과입니다.
경영자동화 검색결과 30건
업무자동화 검색결과 836건
표준엑셀 검색결과 94건
-
생산품 check arch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>sheet 생산품 check arch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>sheet 표준엑셀 서식입니다.
맞춤제작 전문가 답변 검색결과 1,385건
-
매입,매출.현장노임,현장경비 일목요연하게 정리되게 부탁드립니다
ar
ch_bold'>ass=0 style="FONT-SIZE: 11pt; LETTER-SPACING: 0pt; LINE-HEIGHT: 120%; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt; mso-arch_bold'>ascii-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt">1.업종 : 건설업, 전기업
arch_bold'>ass=0 style="FONT-SIZE: 11pt; LETTER-SPACING: 0pt; LINE-HEIGHT: 120%; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt; mso-arch_bold'>ascii-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt">2.예산 :
arch_bold'>ass=0 style="FONT-SIZE: 11pt; LETTER-SPACING: 0pt; LINE-HEIGHT: 120%; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt; mso-arch_bold'>ascii-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt">3.제작 요청사항
arch_bold'>ass=0 style="FONT-SIZE: 11pt; LINE-HEIGHT: 120%; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">1)업무흐름 및 기존 업무방식
저희회사는 건설,전기업체입니다. 세금계산서는 본사건과 본사공사현장 매입, 매출세금계산서(면세포함)로 있으며 공사현장건은 비고란에 공사명을 일일이 기재하고있는중 입니다. 좀 더 쳬계화를 위해 공사현장에 투입되는 노임과. 경비도 함께arch_bold'>ass=0 style="FONT-SIZE: 11pt; LINE-HEIGHT: 120%; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">기록하여 일목요연하게 자동화하여 정리하고 싶습니다. 기존에 쓰고 있는
arch_bold'>ass=0 style="FONT-SIZE: 11pt; LETTER-SPACING: 0pt; LINE-HEIGHT: 120%; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt; mso-arch_bold'>ascii-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt">양식을 첨부해드립니다.
arch_bold'>ass=0 style="FONT-SIZE: 11pt; LINE-HEIGHT: 120%; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt">2)자동화하고 싶은 업무
*월별 매입,매출합계 현황(차트표함)
*현장별 매출, 매입세금계산서, 노임, 경비 합계를 일목요연하게 확인할 수 있음arch_bold'>ass=0 style="FONT-SIZE: 11pt; LETTER-SPACING: 0pt; LINE-HEIGHT: 120%; mso-pagination: none; mso-padding-alt: 0pt 0pt 0pt 0pt; mso-arch_bold'>ascii-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt">좋겠음(인쇄기능)
-
입출고 바코드 재고조사 견적문의드립니다
1.업종 :도소매
2.예산 :협의
3.제작 요청사항
1)업무흐름 및 기존 업무방식
파레트 위에 같은 제품이 아닌 혼재되어있어 상품을 찾을때 육안으로 찾아야되서 찾는데 시간이 오래걸리고 있습니다.
재고조사또한 파레트가 아닌 전체재고로 알고있고 수기로 조사하다보니 조사의 신뢰성이 낮은편입니다.
2)자동화하고 싶은 업무
arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder="0" cellpadding="0" cellspacing="0" width="997" style="arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-collapse: collapse;width:748pt">
arch_bold'>ass="xl64" width="72" style="height:132.0pt; width:54pt">비고사항 arch_bold'>ass="xl63" width="925" style="arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left:none;width:694pt">-상품에는 1박스 1제품 들어가 있고 겉면에는 1제품에 대한 바코드가 부착되어있음(박스에 대한 바코드가 아님) arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">-입고될때는 같은 바코드로도 여러박스가 입고됨 arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">-입고리스트 업로드(바코드번호와 수량)시 각 바코드별,수량별로 팔레트 위치 지정 (1순위-같은상품, 2순위-비어있는 팔레트) arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">-창고문앞에서 입고/출고 작업이 이루어질것이고 컴퓨터와 프린터 비치 arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">-팔레트에는 박스 사이즈별 담을수 있는 수량지정,사이즈 혼재가능하게(CBM으로 계산) arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">-팔레트 CBM 계산할수 있게 박스사이즈 업로드 가능 arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">-창고에는 와이파이가 안되어있어 스캐너<->핸드폰<->엑셀랑 통신가능해야함 arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">-선입선출이 이루어져야함(입고차수나 날짜로 구분) arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none"> arch_bold'>ass="xl63" style="arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left:none"> arch_bold'>ass="xl64" style="height:165.0pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none">입고 arch_bold'>ass="xl63" style="arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left:none">1.박스 바코드 스캔시 정해진 팔레트 위치와 모델명 스티커 출력(바코드출력 프린트와 용지구비되어 있음) arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">2.출력된 스티커를 상품에 부착 arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">3.붙어져있는 스티커를 보고 정해진곳으로 이동 arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">4.팔레트에 붙어있는 바코드 스캔후 박스 바코드 스캔하면 입고확정 arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">-2번에서 지정되어있는 위치나 바코드가 다르면 스캐너에서 오류표시 arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">-육안으로 스티커 확인후 맞는 위치로 가거나 스티커 부착오류시 오류 박스모아놓고 재출력후 정리 arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">-하역이 끝나면(엑셀에 하역 종료버튼) 업로드한 입고리스트와 최종스캔과 일치 확인 arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">-입고리스트와 최종스캔 불일치시 개별 팔레트 재고조사후 수동업데이트 arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">-입고가 끝나면(엑셀에 입고 종료버튼) 입고확정이 안되어있는 팔레트와 상품정보 엑셀에서 출력 arch_bold'>ass="xl65" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left:none">-입고확정 안되어있는 팔레트 재고조사후 수동업데이트 arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none"> arch_bold'>ass="xl63" style="arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left:none"> arch_bold'>ass="xl64" style="height:66.0pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none">출고 arch_bold'>ass="xl63" style="arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left:none">1.출고리스트 업로드(바코드번호와 수량)시 입고차순이 빠른순으로 상품명과 위치를 프린트로 출력 arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">2.팔레트에 있는 바코드 스캔후 박스 바코드 스캔하면 출고확정 arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">-1번에서 지정되어있는 위치나 바코드가 다르면 스캐너에서 오류표시 arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">-출고 마무리후 출고확정이 안되어있는 팔레트와 상품정보 엑셀에서 출력 arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none"> arch_bold'>ass="xl63" style="arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left:none"> arch_bold'>ass="xl66" style="arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-arch_bold'>ass='search_bold'>bottom:.5pt solid black; height:99.0pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none">재고조사 arch_bold'>ass="xl63" style="arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left:none">1.엑셀에서 재고조사 버튼을 누르면 재고조사 시작(파레트별,영역선택별,전체) arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">2.팔레트 바코드 스캔후 박스 바코드 스캔 arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">3.재고조사 완료버튼 누르면 불일치 팔레트와 제품명 출력 arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">4.실재고와 재고표와 육안으로 확인후 불일치시 수동업데이트 arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none">5.효율적 공간활용을 위한 팔레트 합치기 기능(같은 박스사이즈별로) arch_bold'>ass="xl63" style="height:16.5pt;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-top:none;arch_bold'>ass='search_bold'>boarch_bold'>ass='search_arch_bold'>ass='search_bold'>bold'>rder-left: none"> -출고후 입고과정을 거침
비효율적이거나 추가되야 되는부분 조언부탁드립니다.
KaKao ID 친구추가 : @coukey 
