en:mr_aru_reskontro
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
en:mr_aru_reskontro [2021/07/30 21:08] jane [4. Peenhäälestus] |
en:mr_aru_reskontro [2022/11/01 11:14] triinp [2. Choices] |
||
|---|---|---|---|
| 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 ===== | ||
| - | + | {{:et:triinp20221101-111052.png}} | |
| - | + | ||
| ***Customer** - Customer’s code on Document (invoice or proceeding). | ***Customer** - Customer’s code on Document (invoice or proceeding). | ||
| Line 19: | Line 15: | ||
| ***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,12001) and an account selection (for example, 12000:14000). |
| ***Time** - the time of report. | ***Time** - the time of report. | ||
| Line 35: | Line 31: | ||
| ***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. | ||
| Line 44: | Line 41: | ||
| ***Currency** - besides balance currency is added to the report. By the prepayment currency and currency together and compared to current rate. | ***Currency** - besides balance currency is added to the report. By the prepayment currency and currency together and compared to current rate. | ||
| ***Customer data** - report shows customers address, phone number, fax number and e-mail. | ***Customer data** - report shows customers address, phone number, fax number and e-mail. | ||
| - | ***Invoice project ** - report shows if the invoice has a project on row/rows. | + | ***Invoice project ** - the project in the invoice header is displayed. |
| + | ***Invoice object ** - the object in the invoice header is displayed. | ||
| + | ***D account** - Report shows debt account. | ||
| ***Orderer** - Report shows Orderer on the invoice. | ***Orderer** - Report shows Orderer on the invoice. | ||
| ***Show delivery name ** - report shows delivery name on the invoice. | ***Show delivery name ** - report shows delivery name on the invoice. | ||
| + | ***Edit** - can write and edit Customer internal comment. | ||
| + | :!: Write text (or edit text) and when leaving the cell with the mouse, click on the coloured surface of the report and the text will be saved. | ||
| + | |||
| + | |||
| + | {{:et:jane20210827-094742.png}} | ||
| =====3. Links===== | =====3. Links===== | ||
| Line 54: | Line 58: | ||
| ***To Pay ** - opens invoice balance | ***To Pay ** - opens invoice balance | ||
| ***Prepayment** - opens customer’s prepayment list | ***Prepayment** - opens customer’s prepayment list | ||
| - | =====4. Peenhäälestus===== | + | =====4. Fine tuning===== |
| - | {{:et:jane20210730-205145.png}} | + | {{:et:jane20210901-192411.png}} |
| Picture(1) | Picture(1) | ||
| ***Setting{{:et:peenh22lestus_ikoon.png?|}}** - possibility to choose personal settings. | ***Setting{{:et:peenh22lestus_ikoon.png?|}}** - possibility to choose personal settings. | ||
| - | |||
| ***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). | ***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. | ***Save report {{:et:aruanne_ikoon.png?|}}**(shortcut Alt+A) - save report to your own menu with selected name. | ||
| + | ***Split label** - choices: numbers, days | ||
| - | ***Split label** - choices: numbers, days | + | {{:et:jane20210901-192635.png}} \\ |
| - | {{:et:myygireskontro_pilt2.png?|}} | + | |
| Picture(2) | Picture(2) | ||
| - | {{:et:myygireskontro_pilt3.png.jpg?|}} | + | {{:et:jane20210901-193545.png}} |
| + | {{:et:jane20210901-193722.png}}\\ | ||
| Picture(3) | Picture(3) | ||
| Line 75: | Line 79: | ||
| ***Currency** - EUR (default) | ***Currency** - EUR (default) | ||
| - | =====5. Näited===== | + | =====5. Examples===== |
| - | ====5.1 Filtreeringute võimalused ==== | + | ====5.1 Filtering options ==== |
| - | 5.1.1 Müügireskontro algne aruanne valuuta valikuga: | + | 5.1.1 Sales Ledger regular report with currency option: |
| - | {{:et:jane:mr_valuutad_algfail.png|}} | + | {{:et:jane20210901-195802.png}} \\ |
| - | Pilt(4) | + | Picture(4) |
| - | __//**5.1.2 Näita ainult SEK ja USD arved**//__ - selleks kirjuta valuutade koodide nimekiri komadega "SEK,USD". | + | 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 USD arveid siis kirjuta "USD". | + | |
| - | {{:et:jane:mr_valuuta_sek_usd.png|}} | + | {{:et:jane20210901-200119.png}} \\ |
| - | Pilt(5) | + | Picture(5) |
| - | "Komaga" nimekirja filtreering töötab ka Müüja kliendikaartil/Müüja arvel valikuga. | + | :!: Filtering with "comma" works also with Customer salesman/Invoice salesman. |
| - | __//**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". | + | 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:mr_valuuta_valistus.png|}} | + | {{:et:jane20210901-200554.png}} \\ |
| - | Pilt(6) | + | Picture(6) |
| - | "!" märgiga välistuse filtreering töötab ka Müüja kliendikaartil/Müüja arvel valikuga. | + | :!: Filtering with exclusion mark "!" and "comma" works also with Customer salesman/Invoice salesman. |
| - | __//**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. |
| + | |||
| + | {{:et:jane20210901-201047.png}} \\ | ||
| + | Picture(7) | ||
| + | |||
| + | 5.1.5 __**Date not added and currency selection**__ – gives the report all the balance dividend between currencies and calculates prepayments with today’s currency rate, unpaid payments and balance. | ||
| + | |||
| + | {{:et:jane20210901-201247.png}} \\ | ||
| + | Picture(8) | ||
| + | |||
| + | |||
| + | ==== 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:jane20210916-154305.png}}\\ | ||
| + | Picture (9) | ||
| + | |||
| + | Also visible when grouped by customers. | ||
| + | {{:et:jane20210916-154515.png}}\\ | ||
| + | Picture (10) \\ | ||
| + | :!: If there is no change option, the user does not have the right to change the client card. | ||
| + | {{:et:jane20210901-204030.png}} | ||
| + | Picture (11) | ||
| + | |||
| + | 5.2.2. The customer's internal comment can be viewed without the possibility to change it. | ||
| + | |||
| + | {{:et:jane20210901-204444.png}} | ||
| + | Picture (12) | ||
| - | {{:et:jane20210706-184409.png}} | ||
| - | Pilt(7) | ||
| - | __//**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) | ||
