{"id":6342,"date":"2022-01-10T13:44:05","date_gmt":"2022-01-10T12:44:05","guid":{"rendered":"https:\/\/teneg.pl\/its\/?p=6342"},"modified":"2025-01-16T12:16:18","modified_gmt":"2025-01-16T11:16:18","slug":"automatyczne-wyliczanie-kursu-walut-w-elektronicznym-obiegu-dokumentow-dms","status":"publish","type":"post","link":"https:\/\/teneg.pl\/its\/automatyczne-wyliczanie-kursu-walut-w-elektronicznym-obiegu-dokumentow-dms\/","title":{"rendered":"Automatyczne wyliczanie kursu walut w Elektronicznym Obiegu Dokument\u00f3w (DMS)."},"content":{"rendered":"<div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"max-width:1144px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:0px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-text fusion-text-1\"><p>Cz\u0119stym scenariuszem wyst\u0119puj\u0105cym w firmach jest otrzymywanie faktur w walucie obcej, kt\u00f3re nale\u017cy przeprocesowa\u0107 w elektronicznym obiegu dokument\u00f3w (DMS) .<\/p>\n<p>W takim przypadku do\u015b\u0107 istotn\u0105 informacj\u0105, kt\u00f3ra powinna si\u0119 znale\u017a\u0107 na karcie obiegu jest kurs danej waluty.\u00a0 Comarch DMS obs\u0142uguje taki scenariusz.<\/p>\n<p>Aby zrealizowa\u0107 opisany powy\u017cej przyk\u0142ad potrzebujemy kilku sk\u0142adnik\u00f3w:<\/p>\n<p>1.Danych dotycz\u0105cych waluty w programie ERP:<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-medium wp-image-6343\" src=\"https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz111-300x175.png\" alt=\"\" width=\"300\" height=\"175\" srcset=\"https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz111-200x117.png 200w, https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz111-300x175.png 300w, https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz111-400x233.png 400w, https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz111-600x350.png 600w, https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz111.png 756w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>2. Odpowiednich kontrolek na karcie obiegu:<\/p>\n<ul>\n<li>daty wystawienia dokumentu,<\/li>\n<li>waluty,<\/li>\n<li>kontrolki wynikowej, w kt\u00f3rej b\u0119dzie prezentowany kurs.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-medium wp-image-6344\" src=\"https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz222-300x91.jpg\" alt=\"\" width=\"300\" height=\"91\" srcset=\"https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz222-200x61.jpg 200w, https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz222-300x91.jpg 300w, https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz222-400x122.jpg 400w, https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz222-600x183.jpg 600w, https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz222.jpg 756w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>3. Powi\u0105zania pomi\u0119dzy poszczeg\u00f3lnymi polami karty obiegu,<\/p>\n<p>4. Odpowiedniego zapytania SQL, kt\u00f3re zwr\u00f3ci nam dane w spos\u00f3b w\u0142a\u015bciwy, tj. z dnia poprzedzaj\u0105cego wystawienie dokumentu z godziny 12:00.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-medium wp-image-6345\" src=\"https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz333-300x149.jpg\" alt=\"\" width=\"300\" height=\"149\" srcset=\"https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz333-200x99.jpg 200w, https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz333-300x149.jpg 300w, https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz333-400x198.jpg 400w, https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz333-600x298.jpg 600w, https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz333.jpg 756w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>Kiedy wszystkie elementy zostan\u0105 skonfigurowane w spos\u00f3b w\u0142a\u015bciwy, kurs wy\u015bwietli si\u0119 automatycznie po wskazaniu daty wystawienia oraz waluty.<\/p>\n<p>Automatyczne uzupe\u0142nianie tych danych mo\u017cna r\u00f3wnie\u017c zaprogramowa\u0107 za pomoc\u0105 OCR.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-medium wp-image-6346\" src=\"https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz444-300x110.jpg\" alt=\"\" width=\"300\" height=\"110\" srcset=\"https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz444-200x73.jpg 200w, https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz444-300x110.jpg 300w, https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz444-400x147.jpg 400w, https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz444-600x220.jpg 600w, https:\/\/teneg.pl\/its\/wp-content\/uploads\/sites\/2\/2022\/01\/Obraz444.jpg 756w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":6347,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[91,6],"tags":[105,15,103],"class_list":["post-6342","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wdrozenia_systemow","category-wszystkie","tag-case-study","tag-comarch","tag-poradniki"],"_links":{"self":[{"href":"https:\/\/teneg.pl\/its\/wp-json\/wp\/v2\/posts\/6342","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teneg.pl\/its\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teneg.pl\/its\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teneg.pl\/its\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/teneg.pl\/its\/wp-json\/wp\/v2\/comments?post=6342"}],"version-history":[{"count":8,"href":"https:\/\/teneg.pl\/its\/wp-json\/wp\/v2\/posts\/6342\/revisions"}],"predecessor-version":[{"id":19033,"href":"https:\/\/teneg.pl\/its\/wp-json\/wp\/v2\/posts\/6342\/revisions\/19033"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teneg.pl\/its\/wp-json\/wp\/v2\/media\/6347"}],"wp:attachment":[{"href":"https:\/\/teneg.pl\/its\/wp-json\/wp\/v2\/media?parent=6342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teneg.pl\/its\/wp-json\/wp\/v2\/categories?post=6342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teneg.pl\/its\/wp-json\/wp\/v2\/tags?post=6342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}