{"id":36936,"date":"2026-02-18T07:59:35","date_gmt":"2026-02-18T07:59:35","guid":{"rendered":"https:\/\/www.erplybooks.com\/?page_id=36936"},"modified":"2026-06-18T06:48:45","modified_gmt":"2026-06-18T06:48:45","slug":"automaatne-pangasaldo-kinnitamine-reconciliation","status":"publish","type":"page","link":"https:\/\/www.erplybooks.com\/et\/automaatne-pangasaldo-kinnitamine-reconciliation\/","title":{"rendered":"Automaatne pangasaldo kinnitamine (reconciliation)"},"content":{"rendered":"<h1><b>Automaatne pangasaldo kinnitamine (reconciliation)<\/b><\/h1>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Kui klient teeb e-poes ostu pangaga, tekib sama tehing <\/span><b>kahes kohas<\/b><span style=\"font-weight: 400;\">: ERPLY laos (tellimus + laekumine) ja ERPLY Booksis (pangatehing pangast). Need tuleb omavahel \u00e4ra siduda kuna vastasel juhul tekib topeltkirje.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Tehingute seostatakse <\/span><span style=\"font-weight: 400;\">3 parameetri alusel:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Kuup\u00e4ev <\/b><span style=\"font-weight: 400;\">&#8211; Kuup\u00e4evad peavad kattuma v\u00f5i j\u00e4\u00e4ma lubatud vahemikku<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Summa <\/b><span style=\"font-weight: 400;\">&#8211; sidumise puhul peab summa klappima 100%<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Kirjeldus <\/b><span style=\"font-weight: 400;\">&#8211; kirjelduses peab esinema eelseadistatud eesliide (nt VT-) koos unikaalse koodiga<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Antud seadistuse lisamiseks tuleb ERPLY Booksis lisada globaalne atribuut:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Kirjuta pealehe otsingusse <\/span><b>\u201cGlobaalsed Atribuudid\u201d<\/b><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Avanenud aknas tuleb lisada uus atribuut vajutades \u201c<\/span><b>+ Lisa<\/b><span style=\"font-weight: 400;\">\u201d:\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Nimi: <\/span><b>GLOBAL_BANK_IMPORT_AND_RECONCILE; <\/b><span style=\"font-weight: 400;\">V\u00e4\u00e4rtus: <\/span><b>true<\/b><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">J\u00e4rgnevalt tuleb seadistada lisatabelid, mis aitavad leida sobivaid tehinguid:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">\u00d5ige <\/span><b>kirjelduse <\/b><span style=\"font-weight: 400;\">\u00a0leidmiseks kasutatakse <\/span><b>ALT. Value<\/b><span style=\"font-weight: 400;\"> ja <\/span><b>Value2<\/b><span style=\"font-weight: 400;\"> veergu.\u00a0<\/span>\n<ul>\n<li><b>(Alt. )Value<\/b><span style=\"font-weight: 400;\"> &#8211; otsib pangatehingu kirjelduses eesliidet Booksis (nt ID.VT-&#8230;..)<\/span><\/li>\n<li><b>(Alt. )Value2 <\/b><span style=\"font-weight: 400;\">&#8211; otsib kirjeldust ERPLY laost (nt VT-&#8230;&#8230;)<\/span><\/li>\n<\/ul>\n<\/li>\n<li aria-level=\"1\"><b>Int Number<\/b><span style=\"font-weight: 400;\"> veeru number m\u00e4\u00e4rab kui pikk kirjeldus peab eesliidele j\u00e4rgnevalt sisaldama. See v\u00e4ldib vigu, kus kirjeldus sisaldab eesliidet, kuid puudub piisavalt pikk kirjeldus. Nt kui <\/span><b>Int Number==5<\/b><span style=\"font-weight: 400;\">, siis VT-\u201d<\/span><b>123456<\/b><span style=\"font-weight: 400;\">\u201d sobib, kuid VT-\u201d<\/span><b>12345<\/b><span style=\"font-weight: 400;\">\u201d juba mitte.<\/span><\/li>\n<\/ul>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Atribuudi salvestamiseks vajuta: <\/span><b>Salvesta<\/b><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Lisaks on v\u00f5imalik luua ka sama nimetusega atribuute, kuid teiste lisatabelite v\u00e4\u00e4rtustega. See on vajalik n\u00e4iteks kui kirjelduses kasutatakse erinevaid eesliiteid.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-36937\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/02\/1-2.png\" alt=\"\" width=\"1216\" height=\"236\" srcset=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/02\/1-2.png 1216w, https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/02\/1-2-980x190.png 980w, https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/02\/1-2-480x93.png 480w\" sizes=\"auto, (min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1216px, 100vw\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">S\u00f5ltuvalt sellest, kuidas raha pangakontole j\u00f5uab, on kaks erinevat stsenaariumit:<\/span><\/p>\n<p>&nbsp;<\/p>\n<h2><b>Otse pangatehingu sidumine<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Pangatehing saabub otse pangakontole ja j\u00f5uab kiiresti ERPLY Booksi. S\u00fcsteem seob ERPLY lao tehingu ja Booksi pangatehingu automaatselt. Raamatupidajal ei ole vaja protsessi k\u00e4sitsi sekkuda.<\/span><\/p>\n<h2><\/h2>\n<h2><b>Sidumine l\u00e4bi viitlaekumise<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Kasutatakse siis, kui raha ei j\u00f5ua kohe pangakontole, vaid l\u00e4bib alguses viitlaekumise konto. See on sarnane poes kaardimaksega: pood saab raha k\u00e4tte alles j\u00e4rgmisel p\u00e4eval, mitte kohe.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Selle teostamiseks tuleb eelnevalt k\u00e4sitletud atribuutidile lisada:<\/span><\/p>\n<ul>\n<li><b>(Alt. )Value8 <\/b><span style=\"font-weight: 400;\">veeru tabelisse: <\/span><b>true<\/b><\/li>\n<li aria-level=\"1\"><span style=\"font-weight: 400;\">Samuti v\u00f5ib<\/span><b> Int Number2 <\/b><span style=\"font-weight: 400;\">veerus sisestada p\u00e4evade arvu, mis m\u00e4\u00e4rab, kui hilja v\u00f5ib viitlaekumise tehing s\u00fcsteemi j\u00f5uda. N\u00e4iteks kui Int Number2==4, siis reede \u00f5htul (nt kell 23:55) tehtud \u00fclekanne v\u00f5ib pangast saabuda veel esmasp\u00e4eval ja sidumine \u00f5nnestub.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">NB! Selle teostamiseks tuleb kindlasti seadetes (<\/span><b>S\u00e4tted \u2192 \u00dcldised s\u00e4tted\u2192 Kinnita pangaimpordis seda kontot<\/b><span style=\"font-weight: 400;\">) m\u00e4\u00e4rata viitlaekumise konto.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-36943\" src=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/02\/2.png\" alt=\"\" width=\"900\" height=\"499\" srcset=\"https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/02\/2.png 900w, https:\/\/www.erplybooks.com\/wp-content\/uploads\/2026\/02\/2-480x266.png 480w\" sizes=\"auto, (min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 900px, 100vw\" \/><\/p>\n<h3><\/h3>\n<h3><b>Protsessi k\u00e4ik<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Viitlaekumise sidumine p\u00f5hineb <\/span><a href=\"https:\/\/www.erplybooks.com\/et\/juhendid\/kaarditerminali-maksete-kinnitamine-pangas\/\"><span style=\"font-weight: 400;\">kaarditerminali maksete kinnitamise<\/span><\/a><span style=\"font-weight: 400;\"> loogikal, kuid toimib \u00fcks-\u00fchele meetodil ehk iga pangatehing seotakse t\u00e4pselt \u00fche tehinguga.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Kui pangatehing saabub, kontrollib s\u00fcsteem automaatselt k\u00f5iki kinnitamata tehinguid ning otsib vastet kolme parameetri alusel: kirjeldus (eesliide + ID), summa (100% klappimine) ja kuup\u00e4ev (Int Number2 vahemikus). Leides vaste, teeb s\u00fcsteem tagatoas kaks toimingut:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Loob uue laekumise kreeditkirjega viitlaekumise kontole\u00a0 raha liigub viitlaekumiselt pangakontole<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Seob pangatehingu automaatselt vastava ootel tehinguga ehk tehing saab staatuse <\/span><b>Korras == jah<\/b><\/li>\n<\/ul>\n<h3><b>K\u00e4sitsi kinnitamine<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Kui automaatne sidumine ei leia l\u00e4inud l\u00e4bi(nt kirjeldus ei sisalda eesliidet v\u00f5i kuup\u00e4ev \u00fcletab Int Number2 vahemiku), saab tehingud siduda k\u00e4sitsi:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Mine <\/span><b>\u201eM\u00fc\u00fck&#8221; \/ \u201eOst&#8221; \u2192 \u201ePangaimport&#8221;<\/b><span style=\"font-weight: 400;\"> ja leia tehing mille staatus on Korras == ei (not reconciled).<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Tee tehingul <\/span><b>paremklikk<\/b><span style=\"font-weight: 400;\"> ja vali <\/span><b>\u201eOtsi ootel makseid&#8221;<\/b><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Vali avanenud nimekirjast sobiv ootel tehing ja vajuta <\/span><b>\u201eVali&#8221; <\/b><span style=\"font-weight: 400;\">ja <\/span><b>\u201cJah\u201d<\/b><span style=\"font-weight: 400;\">. Summa peab klapima 100%.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00fcsteem teeb kreeditkirje viitlaekumise kontole ja tehingule ilmub veerus\u00a0 Korras == jah ehk viitlaekumise ts\u00fckkel on l\u00f5petatud.<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Automaatne pangasaldo kinnitamine (reconciliation) &nbsp; Kui klient teeb e-poes ostu pangaga, tekib sama tehing kahes kohas: ERPLY laos (tellimus + laekumine) ja ERPLY Booksis (pangatehing pangast). Need tuleb omavahel \u00e4ra siduda kuna vastasel juhul tekib topeltkirje. Tehingute seostatakse 3 parameetri alusel: Kuup\u00e4ev &#8211; Kuup\u00e4evad peavad kattuma v\u00f5i j\u00e4\u00e4ma lubatud vahemikku Summa &#8211; sidumise puhul peab [&hellip;]<\/p>\n","protected":false},"author":28,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[],"tags":[],"class_list":["post-36936","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/36936","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/comments?post=36936"}],"version-history":[{"count":0,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/36936\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/media?parent=36936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/categories?post=36936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/tags?post=36936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}