Differences

This shows you the differences between two versions of the page.

--- en:mr_aru_reskontro [2021/07/30 19:22]
jane created
+++ en:mr_aru_reskontro [2022/11/01 13:30]
triinp [5.1Filtering options]
@@ Line 1: / Line 1: @@
-FIXME **This page is not fully translated, yet. Please help completing the translation.**\\ //(remove this paragraph once the translation is finished)//
 ====== Sales Ledger ======
@@ Line 6: / Line 4: @@
 =====1. Filters and filter options =====
+{{:et:triinp20221101-124953.png}}
+Picture(1)
   ***Customer** - Customer’s code on Document (invoice or proceeding).
   ***Orderer** - Orderer’s code on Document (invoice or proceeding).
   ***Both**- Customer and Orderer both in the document (invoice or proceeding).
-\\
   ***Customer salesman** - invoices where customer is marked and whom client card has selected salesman.
   ***Invoice salesman  ** - shows invoices that have salesman marked  on Document.
@@ Line 19: / Line 16: @@
   ***Reg No** - Customer’s registration number.
   ***Class** - Customer’s class on the Document. Can be separated interval with colon. Also takes into account additional customer classes.
-  ***D account** - Customer’s debt account on the invoice (prepayment according to customer class or system settings).
+  ***D account** - Customer’s debt account on the invoice. The D account filter works with both a comma list (for example - 12000,12001) and an account selection (for example, 12000:14000).
-  ***Aeg** - mis hetkega on väljavõte.
+  ***Time** - the time of report.
-  ***Objekt** - Arvestatakse arveid, kus on peal valitud objekt.
+  ***Object** - invoices that have selected an object in Document.
-  ***EM konto** - kliendi ettemaksukonto.
+  ***PP account** - Customer’s prepayment account.
-  ***Staatus** - arve staatus.
+  ***Status** - Status of the invoice.
-  ***Seeria** - dokumendi numbriseeria.
+  ***Range** - Document range.
-  ***Jaga/kirjelda** - Jaotab aruande kokkuvõtte laekumata arvete summa ajalises lõikes laiali. Nt jaga 3×7 näitab maksetähtajast lähtudes oodatud laekumisi kolme möödunud ja kolme tulevase nädala jooksul.
+  ***Divide/Configure** - distributes report summary overdue invoices sum by the temporal matter. E.g., divide by 3 x 7 shows expected proceedings for the last three and the next three weeks, based on payment term.
-  ***Tüüp** - arve tüüp
+  ***Type** - invoice type
-  ***Valuuta** - saab valida näiteks "USD" valuutas tehtud arved.
+  ***Currency** - can be chosen currency e.g., invoices made with currency USD.
-  ***Kliendi lisaväli** - annab tulemuseks kliendid, kelle kaardil on olemas valitud lisaväli.
+  ***Customer Datafield** - shows customers, who have been added a data field on the client card
-  ***Kliendi lisaväli sisaldab** - otsib lisavälja sisu järgi.
+  ***Customer Datafield** includes - searches according to the data field content.
-  ***Kokku** - valikud klient, klass, asumaa, müüja, kliendihaldur, reg. number.
+  ***Total** - "total sums by" - Customer, Class, Country, Salesman, Account manager, Reg no.
-  ***Sorteeritud** - Aruannet saab sorteerida valikutes olevate tingimuste järgi.
+  ***Overlaps are possible** - with this option only lines with prepayment and balance remain in the Total view
+  ***Sorted by** - report can be sorted by conditions in the options - Customer code, Customer name, Invoice No, Invoice Time, Invoice due date.
-=====2. Valikud=====
+=====2. Choices=====
-  ***Ainult ettemaksuarveid** - kuvab arved millel on peal ettemaksu tunnuseda artiklid.
+  ***Only prepayment invoices ** - shows invoices that have been marked as prepayment on article.
-  ***Ainult ületähtaja**- näidatakse ainult neid laekumata arved, mis on üle tähtaja.
+  ***Only overdue ** - shows only these invoices that are unpaid and overdue.
-  ***Kande aja järgi** - aruannet vaadeldakse arve kande mitte arve aja järgi.
+  ***By Transaction time** - report shows invoices according to the invoice transaction time not invoice creating time.
-  ***Valuutas** - saldole lisaks näidatakse ka valuuta tulpa, ettemakse kursi kaupa ning lõpus valuutat kokku ja võrdluses hetkekursiga.
+  ***Currency** - besides balance currency is added to the report. By the prepayment currency and currency together and compared to current rate.
-  ***Jaga** - jaotab aruande kokkuvõtte laekumata arvete summa ajalises lõikes laiali. Nt jaga 3x7 näitab maksetähtajast lähtudes oodatud laekumisi kolme möödunud ja kolme tulevase nädala jooksul.
+  ***Customer data** - report shows customers address, phone number, fax number and e-mail.
-  ***Kliendiandmed** - näitab aruandes ka kliendi aadressi, telefoni, faksi ja e-maili.
+  ***Invoice project ** - the project in the invoice header is displayed.
-  ***Näita (lisavälja)** - kuvab valitud arve lisavälja sisu.
+  ***Invoice object ** - the object in the invoice header is displayed.
-  ***Arve projekt** - Näidatakse, kas arve real/ridadel on projekt.
+  ***D account** - Report shows debt account.
-  ***Tellija** - Näidatakse arvel tellijat.
+  ***Orderer** - Report shows Orderer on the invoice.
-  ***Näita nimi lähetusel** - Näidatakse lähetusel olev nimi.
+  ***Show delivery name ** - report shows delivery name on the invoice.
+  ***Edit** - can write and edit Customer internal comment.
+:!: Write the text (or edit the text), leave the cell with the mouse, click on the coloured surface of the report and the text will be saved.
-=====3. Lingid=====
+:!: If the right to change ´´customers´´ module is removed, the option to ´´edit´´ the sales ledger will disappear. If you have this right and the edit box is checked,
+can write a comment after the customer int comment in the report, which is saved automatically.
-  ***Arve number** - avab arve
+{{:et:jane20210827-094742.png}}
-  ***Kliendi kood** - avab kliendi kaardi
+=====3. Links=====
-  ***Tasuda** - avab arve saldo
-  ***Ettemaks** - avab kliendi ettemaksude nimekirja
-=====4. Peenhäälestus=====
+  ***Invoice No** - opens invoice
-{{:et:myygireskontro_peenh22lestus.png?2|}}
+  ***Customer code ** - opens customer card
-Pilt(1)
+  ***To Pay ** - opens invoice balance
+  ***Prepayment** - opens customer’s prepayment list
+=====4. Fine tuning=====
-  ***Seadistus{{:et:peenh22lestus_ikoon.png?|}}** - Võimalus valida oma personaalseid seadistusi.
+{{:et:triinp20221101-112859.png}}
+Picture(2)
-  ***Exceli tabel {{:et:excel_ikoon.png?|}}**(kiirkäsklus F12 või Alt+E) – valikud Hankija infoga (nagu aruandes), tabelina (võimaldab kombineerida aruande infot tulpades).
+  ***Setting{{:et:peenh22lestus_ikoon.png?|}}** - possibility to choose personal settings.
-  ***Salvesta aruanne {{:et:aruanne_ikoon.png?|}}**(kiirkäsklus Alt+A) – Salvesta aruanne kasutajamenüüsse enda valitud nimetusega.
+  ***Excel sheet {{:et:excel_ikoon.png?|}}**(shortcut F12 or Alt+E) – options: with customer information (same as on the screen), as table (allows to combine data from columns).
+  ***Save report {{:et:aruanne_ikoon.png?|}}**(shortcut Alt+A) - save report to your own menu with selected name.
-  ***Jaga tekst** - valikud: Numbrid, Päevad
+{{:et:triinp20221101-120834.png}} \\
-{{:et:myygireskontro_pilt2.png?|}}
+Picture(3)
-Pilt(2)
+  ***Split label** - choices: numbers, days
+{{:et:triinp20221101-120515.png}}
+{{:et:triinp20221101-120651.png}}\\
+Picture(4)
-{{:et:myygireskontro_pilt3.png.jpg?|}}
+  ***Customer data field with invoice receiver e-mail** - add the invoice receiver’s e-mail
-Pilt(3)
+  ***Customer datafields ** - choose 3,6,9 (amount of the data fields in the report)
+  ***Currency** - EUR (default)
-  ***Kliendi lisaväli**, kus on arve saaja meil
+=====5. Examples=====
-  ***Kliendi lisavälju** - valikud: 3,6,9 (lisaväljade arv aruandes)
+====5.1	Filtering options  ====
-  ***Jaga** sisaldab maksegraafikut - (ei ole arendatud)
-  ***Valuuta** - EUR (vaikimisi)
-=====5. Näited=====
-====5.1 Filtreeringute võimalused ====
+__** 5.1.1.Sales Ledger regular report with currency option:**__
+{{:et:triinp20221101-121049.png}} \\
+Picture(5)
-.1.1 Müügireskontro algne aruanne valuuta valikuga:
+__**5.1.2. Show only SEK and USD invoices**__ – for this selection separate currency codes with commas without space „SEK,USD“. If you want to see only USD invoices then write „USD“
- {{:et:jane:mr_valuutad_algfail.png|}}
-Pilt(4)
-__//**5.1.2 Näita ainult SEK ja USD arved**//__ - selleks kirjuta valuutade koodide nimekiri komadega "SEK,USD".
+{{:et:triinp20221101-121440.png}} \\
-Kui soov näha ainult USD arveid siis kirjuta "USD".
+Picture(6)
-{{:et:jane:mr_valuuta_sek_usd.png|}}
+:!: Filtering with "comma" works also with Customer salesman/Invoice salesman.
-Pilt(5)
-"Komaga" nimekirja filtreering töötab ka Müüja kliendikaartil/Müüja arvel valikuga.
+__**5.1.3. Don’t show EUR and SEK invoices**__ – for this selection use exclusion mark „!“ and add currency codes separated with commas. For example insert „!EUR,SEK“ and the report shows only USD invoices. If you want to exclude only SEK invoices, then insert „!SEK“
-__//**5.1.3 Ära näita EUR ja SEK arved**//__ - selleks kirjuta ette välistuse märk "!" ning valuutade koodide nimekiri komadega - "!EUR,SEK". Aruandes jäävad näha ainult USD arved. Kui soov välistada ainult SEK arveid, kirjuta "!SEK".
+{{:et:triinp20221101-121607.png}} \\
+Picture(7)
-{{:et:jane:mr_valuuta_valistus.png|}}
+:!: Filtering with exclusion mark "!" works also with Customer salesman/Invoice salesman.
-Pilt(6)
-"!" märgiga välistuse filtreering töötab ka Müüja kliendikaartil/Müüja arvel valikuga.
-__//**5.1.3 Kuupäev täidetud valuuta linnuke**//__ - annab all summad kokku valuutade kaupa ning arvutab kuupäeva kursiga ümber ka ettemaksud, laekumata summad ning saldod.
+__**5.1.4. Date added and Currency selected**__ – gives the report a balance divided between currencies and calculates prepayments with the currency rate, unpaid payments and balance.
-{{:et:jane20210706-184409.png}}
+{{:et:triinp20221101-122703.png}} \\
-Pilt(7)
+Picture(8)
+__**5.1.5.Date not added and currency selected**__ – gives the report all the balance dividend between currencies and calculates prepayments with today’s currency rate, unpaid payments and balance.
+{{:et:triinp20221101-123010.png}} \\
+Picture(9)
+==== 5.2. Using the customer's internal comment  ====
+The customer's internal comment field has been added to the sales ledgers. It can be used as needed.
+As an option, information on overdue invoices when customers are called or the customer's written answers to reminders are written here.
+Often, long-term debtors are the same customers to whom reminders are sent and calls are made every week. The answers are mostly the same - "we expect to receive a large order ourselves", etc.…). You can now see such information directly from the sales ledger.
+__**5.2.1. Add a customer debt comment to sales ledgers:**__  \\
+{{:et:triinp20221101-124225.png}}\\
+Picture (10)
+Also visible when grouped by customers.
+{{:et:triinp20221101-124349.png}}\\
+Picture (11) \\
+:!: If there is no change option, the user does not have the right to change the client card.
+{{:et:jane20210901-204030.png}}
+Picture (12)
+__**5.2.2. The customer's internal comment can be viewed without the possibility to change it**__
+{{:et:triinp20221101-124837.png}}
+==== 5.3 Payment schedule information ====
+If the invoice is received based on a payment schedule, the payment schedule note is added to the end of the invoice data.
+{{:et:triinp20221101-131101.png}}
-__//**5.1.4 Kuupäev täitmata valuuta linnuke**//__ - annab all summad kokku valuutade kaupa ning arvutab praeguse hetke kuupäeva kursiga ümber ka ettemaksud, laekumata summad ning saldod.
-{{:et:jane20210706-223221.png}}
-Pilt(8)

Directo help

User Tools

Site Tools

Differences

Page Tools