{"id":4541,"date":"2017-04-10T06:19:06","date_gmt":"2017-04-10T06:19:06","guid":{"rendered":"http:\/\/www.erplybooks.com\/?page_id=4541\/"},"modified":"2024-03-13T10:06:40","modified_gmt":"2024-03-13T10:06:40","slug":"pangavaljavotte-kohandamine-erply-booksis","status":"publish","type":"page","link":"https:\/\/www.erplybooks.com\/et\/juhendid\/pangavaljavotte-kohandamine-erply-booksis\/","title":{"rendered":"Pangav\u00e4ljav\u00f5tte kohandamine"},"content":{"rendered":"

Ehita pangaimport<\/h1>\n

 <\/p>\n

Pangaimpordi ehitamine ERPLY Booksi poolt on tasuline teenus ja selle minimaalne hind on 99 eur + KM.<\/b><\/p>\n

Pangaimpordi ehitamiseks kirjuta meile support@erplybooks.com<\/b><\/p>\n

 <\/p>\n

ERPLY Booksis on v\u00f5imalik ehitada ise pangaimport. See on vajalik, sest k\u00f5ikide pankade v\u00e4ljav\u00f5tte failid on erineva struktuuriga ning selle seadistuse all saab iga panga faili jaoks \u00e4ra kirjeldada faili sisu, m\u00e4\u00e4rates andmete j\u00e4rjekorrad. Kui pangav\u00e4ljav\u00f5te on \u00e4ra seadistatud, saab seda kasutada pangaimpordis, et muuta lihtsamaks maksete ja laekumiste sidumine arvetega ERPLY Booksis.\u00a0<\/span><\/p>\n

 <\/p>\n

 <\/p>\n

Pangaimpordi ehitamine<\/h2>\n

 <\/p>\n

Pangaimpordi ehitamise mooduli leiad, kui avad <\/span>\u2018\u2019S\u00e4tted -> \u00dcldised S\u00e4tted\u2019\u2019<\/b> ning otsid \u00fcles<\/span> \u2018\u2019Ehita pangaimport\u2019\u2019<\/b>. Moodul on n\u00e4idatud j\u00e4rgmisel pildil:\u00a0<\/span><\/p>\n

 <\/p>\n

\"\"<\/p>\n

 <\/p>\n

Kui vajutad sinisele <\/span>\u2018\u2019Halda\u2019\u2019<\/b> nupule, avaneb aken, kus tuleb t\u00e4ita v\u00e4ljad panga v\u00e4ljav\u00f5tte kohta:\u00a0<\/span><\/p>\n

 <\/p>\n

\"\"<\/p>\n

 <\/p>\n

Selle aknas tuleb sisestada j\u00e4rgnevad andmed:<\/span><\/p>\n

    \n
  • Nimi<\/b>: siia kirjutage panga nimi mille v\u00e4ljav\u00f5tet te seadistate, see ilmub hiljem pangaimpordi vahekaardile, kui hakkate valima, millise panga faili te \u00fcles laete. Alumisel pildil on n\u00e4ide Pagaimpordi tehes (M\u00fc\u00fck\/Ost -> Pangaimport -> Vali fail) ja valides Swedbank:\u00a0<\/span><\/li>\n<\/ul>\n

     <\/p>\n

    \"\"<\/p>\n

     <\/p>\n

      \n
    • Kas andmed algavad esimesest reast? <\/b>: Olenevalt pangast v\u00f5ivad failis andmed hakata kohe esimeselt realt, kuid see ei pruugi nii olla. Selles lahtris tuleb valida JAH v\u00f5i EI.\u00a0<\/span><\/li>\n
    • Kodeering <\/b>: kui seda ei tea, siis sellesse lahtrisse kirjutada UTF-8. Notepad++ programmis on faili kodeering n\u00e4htav.\u00a0<\/span><\/li>\n
    • Kuup\u00e4evaformaat:<\/b> hetkel on meil kuup\u00e4ev JAVA kuup\u00e4eva formaadis. Formaat on dd\/MM\/yyyy ehk siis n\u00e4iteks 03\/01\/2022.\u00a0<\/span><\/li>\n
    • Failieraldaja:<\/b> v\u00f5imalikud variandid on \u201c,\u201d, \u201c;\u201d, \u201c|\u201d<\/span><\/li>\n<\/ul>\n

      J\u00e4rgneval pildil on toodud kaks erinevat n\u00e4ited failieraldaja kohta. LHV v\u00e4\u00e4rtpaberite puhul kasutatakse failieraldajat ”;<\/strong>” ja TransferWISE puhul ”,<\/strong>”.<\/p>\n

       <\/p>\n

      \"\"<\/p>\n

       <\/p>\n

        \n
      • J\u00e4rjekord:<\/b>\u00a0 siia tuleb panna kirja pangav\u00e4ljav\u00f5tte failis olevate veergude j\u00e4rjekord<\/span><\/li>\n<\/ul>\n

        Pangav\u00e4ljav\u00f5tte faili j\u00e4rjekorra lahtrisse tuleb kirjutada info t\u00e4pselt sellises j\u00e4rjekorras nagu see failis on.\u00a0<\/span><\/p>\n

        N\u00e4iteks kui CSV failis on info veergudes sellises j\u00e4rjekorras:\u00a0<\/span><\/p>\n

        \u2018\u2019Acc name\u2019\u2019, \u2018\u2019Account number\u2019\u2019, \u2018\u2019Bank name\u2019\u2019, \u2018\u2019Currency\u2019\u2019, \u2018\u2019Country\u2019\u2019, \u2018\u2019BIC\u2019\u2019, \u2018\u2019IBAN\u2019\u2019, \u2018\u2019Account status\u2019\u2019, \u2018\u2019Account type\u2019\u2019, \u2018\u2019Bank reference\u2019\u2019, \u2018\u2019Additional narrative\u2019\u2019, \u2018\u2019Customer reference\u2019\u2019, \u2018\u2019TRN type\u2019\u2019, \u2018\u2019Value date (dd\/mm\/yyyy)\u2019\u2019, \u2018\u2019Credit amount\u2019\u2019, \u2018\u2019Debit amount\u2019\u2019, \u2018\u2019Balance\u2019\u2019, \u2018\u2019Time\u2019\u2019, \u2018\u2019Post date\u2019\u2019<\/span><\/p>\n

        Tuleks see j\u00e4rjekorra lahtrisse kirja panna j\u00e4rgnevalt:\u00a0<\/span><\/p>\n

        other|other|other|currency|other|other|other|other|other|description|description|description|other|date|creditSum|debitSumdivide-1%|other|other|other\u00a0<\/span><\/p>\n

        P\u00f5hjus, miks j\u00e4rjekorras on kirjutatud \u2018\u2019debitSumdivide-1%\u2019\u2019 tuleneb sellest, et ERPLY Booksis ei tohi pangaimpordis olla \u00fchtegi negatiivset v\u00e4\u00e4rtust. K\u00f5ik summad peavad olema positiivse v\u00e4\u00e4rtusega ning samuti peab olema eraldatud, kas tegemist on deebetiga v\u00f5i kreeditiga. Selle p\u00f5hjal kuvab hiljem Books v\u00e4\u00e4rtuse ise miinuse v\u00f5i pluss m\u00e4rgiga.\u00a0<\/span><\/p>\n

        \u00a0Seega \u2018\u2019debitSumdivide-1%\u2019\u2019 oli vajalik, sest antud n\u00e4ite pangav\u00e4ljav\u00f5ttes oli kreeditsumma veerus negatiivsed v\u00e4\u00e4rtused ja et saada need positiivseteks v\u00e4\u00e4rtusteks, tuleb need jagada l\u00e4bi -1ga.\u00a0<\/span><\/p>\n

        Minimaalne info, mida meil on vaja teada makse kohta, on summa ja kuup\u00e4ev. Kui need on olemas, siis saab makse ette valmistada ja kasutaja saab vajadusel ise m\u00e4\u00e4rata, kuhu makse l\u00e4heb. Booksis on v\u00f5imalik soovi korral seadistada ka rohkema informatsiooniga pangav\u00e4ljav\u00f5tteid.\u00a0<\/span><\/p>\n

         <\/p>\n

        Pangav\u00e4ljav\u00f5tte veergude informatsioon<\/h2>\n

         <\/p>\n

        ERPLY Books toetab j\u00e4rgnevat pangav\u00e4ljav\u00f5tte veergudes olevat informatsiooni:\u00a0<\/span><\/p>\n

          \n
        • amount<\/strong> – makse summa<\/span><\/li>\n
        • fee<\/strong> – n\u00e4iteks panga teenustasu<\/span><\/li>\n<\/ul>\n

          Kui kogu makse on n\u00e4iteks 100\u20ac, aga sellest on vahendustasu 1\u20ac, seega tehakse 2 makset 100\u20ac ja -1\u20ac. Kui fee on eraldi, siis tehakse sellest kulust eraldi rida.\u00a0<\/span>Panga teenustasusid v\u00f5ib olla mitu ja iga fee kohta tehakse eraldi rida.\u00a0<\/span><\/p>\n

            \n
          • creditSum<\/strong> – kreeditsumma\u00a0<\/span><\/li>\n
          • name<\/strong> – tehingu vastaspoole nimi, kellele maksti v\u00f5i kes maksis minu ettev\u00f5ttele. Kui on mitu nime, siis lisatakse need sidekriipsuga.\u00a0<\/span><\/li>\n
          • invoiceNumber<\/strong> – faili import v\u00f5imaldab kasutada igasuguste laekumiste importi, seega on v\u00f5imalik lisada eraldi veergu ka arvenumber.\u00a0<\/span><\/li>\n
          • remitterId<\/strong> – kui on olemas ettev\u00f5tte registrikood v\u00f5i isikukood<\/span><\/li>\n
          • description<\/strong> – tehingu kirjeldus, sinna saab lisada ka mitu descriptionit ja iga uus kirjeldus liidetakse eelmisele kirjeldusele juurde.\u00a0<\/span><\/li>\n
          • debit<\/strong> – see on eristamaks, kas tegu sisse v\u00f5i v\u00e4ljaminekuga, sest pankades ei ole see standartne.<\/span><\/li>\n<\/ul>\n

            Pangav\u00e4ljav\u00f5tetes on tehingud kirjeldatud v\u00e4ga erinevalt – paljud pangad panevad tehingud kas miinuse v\u00f5i pluss m\u00e4rgiga, osad pangad panevad k\u00f5ik tehingud positiivse summana, aga eristavad deebeti v\u00f5i kreeditina. On ka v\u00f5imalus, et pangad panevad tehingu plussi v\u00f5i miinusega ja eraldi ka veel kas see on deebet v\u00f5i kreedit tehing.Seega on \u2018\u2019debit\u2019\u2019 v\u00f5imalikud v\u00e4\u00e4rtused vastavalt sellele, kuidas on kirjeldatud. Saab m\u00e4\u00e4rata ka erandeid nt debit=D v\u00f5i debit=d. Kui j\u00e4tta lihtsalt \u2018\u2019debit\u2019\u2019, siis ta otsib v\u00e4\u00e4rtust \u2018\u2019D\u2019\u2019 v\u00f5i \u2018\u2019d\u2019\u2019.\u00a0<\/span><\/p>\n

              \n
            • date<\/strong> – kuup\u00e4ev<\/span><\/li>\n
            • check<\/strong> – USA-s on levinud t\u0161eki kasutamine, seega v\u00f5ib USA pangav\u00e4ljav\u00f5tete formaadis esineda ka t\u0161eki numbri veerg. T\u0161eki p\u00f5him\u00f5te on see, et v\u00e4ljaandja annab makse teostajale kohustuse maksta makse saajale kindla summa raha, tavaliselt on makse teostajaks pank.\u00a0<\/span><\/li>\n
            • id<\/strong> -see on panga arhiveerimistunnus. <\/span><\/li>\n<\/ul>\n

              Igal tehingul on pangas unikaalne id ja selle j\u00e4rgi tunneme \u00e4ra, kas tehing olemas v\u00f5i mitte. Kui puudub identifitseerimistunnus, siis pole v\u00f5imalik tuvastada, kas see tehing (ehk siis makse v\u00f5i laekumine) on juba olemas v\u00f5i mitte. Identifitseerimistunnus aitab v\u00e4ltida topelt laekumisi\/makseid. Oluline on CSV faili enne Booksi importimist mitte avada, sest CSV faili avamisel muudab tabelarvutusprogramm k\u00f5ik ahriveerimistunnused \u00fchesugusteks ning seet\u00f5ttu pole v\u00f5imalik raamatupidamistarkvaral eristada kas makse\/ laekumine on uus v\u00f5i on see juba varasemalt imporditud.\u00a0<\/span><\/p>\n

                \n
              • currency<\/strong> – kui pangav\u00e4ljav\u00f5ttes on m\u00e4rgitud valuuta, siis saab selle lisada –\u00a0 meie toetame standardses ISO-3 formaadis kirjutatud valuutat ( nt EUR, USD jne), valuuta veerusei tohi olla valuutam\u00e4rk (nt \u20ac,$), sest seda Books ei toeta. Kui valuutat m\u00e4rgitud pole, siis lisatakse peamises valuutas, mis on \u00fcldiste s\u00e4tete all m\u00e4\u00e4ratud (<\/span>S\u00e4tted -> \u00dcldised s\u00e4tted<\/b>)<\/span><\/li>\n
              • ref<\/strong> – viitenumber<\/span><\/li>\n<\/ul>\n

                 <\/p>\n

                \"\"<\/p>\n

                 <\/p>\n

                 <\/p>\n

                 <\/p>\n

                 <\/p>\n

                 <\/p>\n

                 <\/p>\n

                <\/h2>\n

                Pangaimpordi ehitamise erijuhud<\/h2>\n

                Pangaimpordi ehitajale saab anda v\u00e4ga palju erinevaid reegleid ette:<\/p>\n

                  \n
                • Saab ehitada pangaimpordi olukorras, kus pangav\u00e4ljav\u00f5te pole mitte CSV formaadis vaid XML formaadis -> saab \u00f6elda stiilis, et nimi v\u00f5tab sealt, mis j\u00e4rgneb <NAME> kuni <\/NAME><\/li>\n
                • Saab ehitada pangaimpordi olukorras, kus pangav\u00e4ljav\u00f5te pole mitte CSV ega XML formaadis vaid hoopis fikseeritud pikkustes. Ehk siis stiilis nimi on 11s t\u00e4hem\u00e4rk kuni 38s t\u00e4hem\u00e4rk.<\/li>\n
                • Saab ehitada pangaimpordi selliselt, et iga rea juures kontrollib, mis veerust millist v\u00e4\u00e4rtust v\u00f5tta<\/li>\n<\/ul>\n

                  Reegel n\u00e4eb v\u00e4lja umbes selline:<\/p>\n

                  date|other|other|other|currency|amount|other|other|other|id|other|name|other|other|other|other|description|other|conditions=6>0,4=Express Checkout Payment,date,other,other,other,currency,amount,other,other,other,id,other,other,other,other,other,other,descAndName,other;6<0,4=Express Checkout Payment,date,other,other,other,currency,amount,other,other,other,id,other,name,other,other,other,other,description,other;4=Account Hold for Open Authorization,date,other,other,description,currency,amount,other,other,other,id,other,other,other,other,other,other,name,other;4=Cancellation of Hold for Dispute Resolution,date,other,other,description,currency,amount,other,other,other,id,other,name,other,other,other,other,other,description;4=Chargeback,17=BLANK,date,other,other,description,currency,amount,other,other,other,id,other,name,other,other,other,other,other,other;4=Chargeback,17=NOTBLANK,date,other,other,description,currency,amount,other,other,other,id,other,other,other,other,other,other,name,other;4=Dispute Fee,date,other,other,description,currency,amount,other,other,other,id,other,name,other,other,other,other,other,description;4=General Currency Conversion,date,other,other,description,currency,amount,other,other,other,id,other,name,other,other,other,other,other,description;4=Hold on Balance for Dispute Investigation,date,other,other,description,currency,amount,other,other,other,id,other,name,other,other,other,other,other,other;4=Payment Refund,date,other,other,description,currency,amount,other,other,other,id,other,name,other,other,other,other,other,description;4=Payment Reversal,date,other,other,description,currency,amount,other,other,other,id,other,name,other,other,other,other,other,description;4=Website Payment,17=BLANK,date,other,other,description,currency,amount,other,other,other,id,other,name,other,other,other,other,other,other;4=Website Payment,17=NOTBLANK,date,other,other,description,currency,amount,other,other,other,id,other,name,other,other,other,other,descAndName,other<\/p>\n

                  Kui reeglis on \u201cconditions\u201d, siis k\u00f5ik sellele eelnev, on vaikimisi pangav\u00e4ljav\u00f5tte formaat. K\u00f5ik sellele j\u00e4rgnev on erandid.<\/p>\n

                  K\u00f5ik eelnev on eraldatud \u201c|\u201d, k\u00f5ik j\u00e4rgnev \u201c;\u201d ja \u201c,\u201d.<\/p>\n

                  Valikuv\u00f5imalus on ehitatud \u00fcles loogikale, et \u00fcks valikuv\u00f5imalus sisaldab esmalt kontrolle, millele rida vastama peab ja seej\u00e4rel j\u00e4rjekord kuidas andmeid v\u00f5tta. Ehk siis:
                  \n6>0,4=Express Checkout Payment,date,other,other,other,currency,amount,other,other,other,id,other,other,other,other,other,other,descAndName,other;<\/p>\n

                  6>0 -> see t\u00e4hendab, et kuuenda veeru v\u00e4\u00e4rtus peab olema number ja suurem kui 0.
                  \n4=Express Checkout Payment -> see t\u00e4hendab, et neljanda veeru v\u00e4\u00e4rtus peab v\u00f5rduma \u201cExpress Checkout Payment\u201d<\/p>\n

                  Sealt edasi on j\u00e4rjekord. Ehk siis \u201cdate\u201d on esimeses veerus.<\/p>\n

                  Lisav\u00f5imalused:<\/p>\n

                    \n
                  • BLANK – lahtri sisu peab olema t\u00fchi<\/li>\n
                  • NOTBLANK – lahtri sisu ei tohi olla t\u00fchi<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

                    Ehita pangaimport   Pangaimpordi ehitamine ERPLY Booksi poolt on tasuline teenus ja selle minimaalne hind on 99 eur + KM. Pangaimpordi ehitamiseks kirjuta meile support@erplybooks.com   ERPLY Booksis on v\u00f5imalik ehitada ise pangaimport. See on vajalik, sest k\u00f5ikide pankade v\u00e4ljav\u00f5tte failid on erineva struktuuriga ning selle seadistuse all saab iga panga faili jaoks \u00e4ra kirjeldada […]<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":3312,"menu_order":12,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"off","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[456],"tags":[726,725,724],"class_list":["post-4541","page","type-page","status-publish","hentry","category-pank","tag-kohandamine","tag-panagavaljavote","tag-pank"],"_links":{"self":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/4541","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/comments?post=4541"}],"version-history":[{"count":0,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/4541\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/pages\/3312"}],"wp:attachment":[{"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/media?parent=4541"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/categories?post=4541"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.erplybooks.com\/et\/wp-json\/wp\/v2\/tags?post=4541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}