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:50] – [1. Filters and filter options] jane | en:mr_aru_reskontro [2022/11/01 13:19] – 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. | ||
+ | ***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. | ***Sorted by** - report can be sorted by conditions in the options - Customer code, Customer name, Invoice No, Invoice Time, Invoice due date. | ||
- | =====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 | ||
- | | + | {{: |
- | {{:et:myygireskontro_pilt2.png?|}} | + | Picture(3) |
- | Pilt(2) | + | |
+ | {{:et:triinp20221101-120515.png}} | ||
+ | {{: | ||
+ | Picture(4) | ||
- | {{: | + | ***Customer data field with invoice receiver e-mail** - add the invoice receiver’s e-mail |
- | Pilt(3) | + | |
+ | ***Currency** - EUR (default) | ||
- | ***Kliendi lisaväli**, | + | =====5. Examples===== |
- | | + | ====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:**__ | ||
+ | {{: | ||
+ | Picture(5) | ||
- | 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, |
- | | + | |
- | Pilt(4) | + | |
- | __//**5.1.2 Näita ainult SEK ja USD arved**// | + | {{: |
- | Kui soov näha ainult USD arveid siis kirjuta " | + | Picture(6) |
- | {{:et:jane: | + | :!: Filtering with " |
- | Pilt(5) | + | |
- | " | + | __**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, |
- | __//**5.1.3 Ära näita EUR ja SEK arved**// | + | {{: |
+ | Picture(7) | ||
- | {{:et:jane: | + | :!: Filtering with exclusion mark " |
- | Pilt(6) | + | |
- | + | ||
- | " | + | |
- | __//**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. | ||
+ | |||
+ | {{: | ||
+ | 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 (10) | ||
+ | |||
+ | Also visible when grouped by customers. | ||
+ | {{: | ||
+ | Picture (11) \\ | ||
+ | :!: If there is no change option, the user does not have the right to change the client card. | ||
+ | {{: | ||
+ | Picture (12) | ||
+ | |||
+ | __**5.2.2. The customer' | ||
+ | |||
+ | {{: | ||
+ | |||
+ | |||
+ | ==== 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. | ||
+ | |||
+ | {{: | ||
- | __//**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