en:mr_aru_reskontro
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
en:mr_aru_reskontro [2021/07/30 19:45] – [1. Filters and filter options] jane | en:mr_aru_reskontro [2022/11/01 12:11] – [5.1Filtering options] triinp | ||
---|---|---|---|
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 ====== | ====== Sales Ledger ====== | ||
Line 6: | Line 4: | ||
=====1. Filters and filter options ===== | =====1. Filters and filter options ===== | ||
- | + | {{: | |
- | + | Picture(1) | |
***Customer** - Customer’s code on Document (invoice or proceeding). | ***Customer** - Customer’s code on Document (invoice or proceeding). | ||
Line 19: | Line 16: | ||
***Reg No** - Customer’s registration number. | ***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. | ***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. | + | ***D account** - Customer’s debt account on the invoice. The D account filter works with both a comma list (for example - 12000, |
***Time** - the time of report. | ***Time** - the time of report. | ||
Line 35: | Line 32: | ||
***Total** - "total sums by" - Customer, Class, Country, Salesman, Account manager, Reg no. | ***Total** - "total sums by" - Customer, Class, Country, Salesman, Account manager, Reg no. | ||
- | ***Sorted by** - report can be sorted by conditions in the options. | + | |
+ | | ||
- | =====2. | + | =====2. |
- | ***Ainult ettemaksuarveid** - kuvab arved millel | + | ***Only prepayment invoices |
- | ***Ainult ületähtaja**- näidatakse ainult neid laekumata arved, mis on üle tähtaja. | + | ***Only 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 |
- | ***Näita (lisavälja)** - kuvab valitud arve lisavälja sisu. | + | ***Invoice object |
- | ***Arve projekt** - Näidatakse, | + | ***D account** - Report shows debt account. |
- | ***Tellija** - Näidatakse arvel tellijat. | + | ***Orderer** - Report shows Orderer |
- | ***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** | + | {{: |
- | | + | =====3. Links===== |
- | ***Tasuda** - avab arve saldo | + | |
- | ***Ettemaks** - avab kliendi ettemaksude nimekirja | + | |
- | =====4. | + | ***Invoice No** - opens invoice |
- | {{: | + | ***Customer code ** - opens customer card |
- | Pilt(1) | + | ***To Pay ** - opens invoice balance |
+ | ***Prepayment** - opens customer’s prepayment list | ||
+ | =====4. | ||
- | ***Seadistus{{:et:peenh22lestus_ikoon.png?|}}** - Võimalus valida oma personaalseid seadistusi. | + | {{:et:triinp20221101-112859.png}} |
+ | Picture(2) | ||
- | ***Exceli tabel {{: | + | ***Setting{{: |
- | ***Salvesta aruanne | + | ***Excel sheet {{: |
+ | ***Save report | ||
+ | ***Split label** - choices: numbers, days | ||
- | ***Jaga tekst** - valikud: Numbrid, Päevad | + | {{:et:triinp20221101-120834.png}} |
- | {{:et:myygireskontro_pilt2.png?|}} | + | Picture(3) |
- | Pilt(2) | + | |
- | {{:et:myygireskontro_pilt3.png.jpg?|}} | + | {{:et:triinp20221101-120515.png}} |
- | Pilt(3) | + | {{: |
+ | Picture(4) | ||
- | ***Kliendi lisaväli**, kus on arve saaja meil | + | ***Customer datafield |
- | ***Kliendi lisavälju** - valikud: | + | ***Customer datafields |
- | ***Jaga** sisaldab maksegraafikut - (ei ole arendatud) | + | ***Currency** - EUR (default) |
- | ***Valuuta** - EUR (vaikimisi) | + | |
- | =====5. | + | =====5. |
- | ====5.1 | + | ====5.1 Filtering options |
- | 5.1.1 Müügireskontro algne aruanne valuuta valikuga: | + | 5.1.1 Sales Ledger regular report with currency option: |
- | | + | {{:et:triinp20221101-121049.png}} |
- | Pilt(4) | + | Picture(5) |
- | __//**5.1.2 Näita ainult | + | 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“ |
- | Kui soov näha ainult | + | |
- | {{:et:jane: | + | {{:et:jane20210901-200119.png}} |
- | Pilt(5) | + | Picture(6) |
- | "Komaga" | + | :!: Filtering with "comma" |
- | __//**5.1.3 Ära näita | + | 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“ |
- | {{:et:jane: | + | {{:et:jane20210901-200554.png}} |
- | Pilt(6) | + | Picture(7) |
- | " | + | :!: Filtering with exclusion mark " |
- | __//**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 selection**__ – gives the report a balance divided between currencies and calculates prepayments with the currency rate, unpaid payments and balance. |
+ | |||
+ | {{: | ||
+ | Picture(8) | ||
+ | |||
+ | 5.1.5 __**Date not added and currency selection**__ – gives the report | ||
+ | |||
+ | {{: | ||
+ | Picture(9) | ||
+ | |||
+ | |||
+ | ==== 5.2. Using the customer' | ||
+ | |||
+ | The customer' | ||
+ | |||
+ | As an option, information on overdue invoices when customers are called or the customer' | ||
+ | |||
+ | 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", | ||
+ | |||
+ | 5.2.1. Add a customer debt comment to sales ledgers: \\ | ||
+ | {{: | ||
+ | Picture (9) | ||
+ | |||
+ | Also visible when grouped by customers. | ||
+ | {{: | ||
+ | Picture (10) \\ | ||
+ | :!: If there is no change option, the user does not have the right to change the client card. | ||
+ | {{: | ||
+ | Picture (11) | ||
+ | |||
+ | 5.2.2. The customer' | ||
+ | |||
+ | {{: | ||
+ | Picture (12) | ||
- | {{: | ||
- | Pilt(7) | ||
- | __//**5.1.4 Kuupäev täitmata valuuta linnuke**// | ||
- | |||
- | {{: | ||
- | Pilt(8) | ||
en/mr_aru_reskontro.txt · Last modified: 2024/05/17 10:54 by vilja