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 [2022/11/01 11:19] – [2. Choices] triinp | en:mr_aru_reskontro [2023/04/14 09:53] – [1. Filters and filter options] triinp | ||
---|---|---|---|
Line 4: | 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 14: | Line 15: | ||
***Account manager** - shows invoices that have account manager marked on Document. | ***Account manager** - shows invoices that have account manager marked on Document. | ||
***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. The D account filter works with both a comma list (for example - 12000, | ***D account** - Customer’s debt account on the invoice. The D account filter works with both a comma list (for example - 12000, | ||
Line 47: | Line 48: | ||
***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. | ***Edit** - can write and edit Customer internal comment. | ||
- | :!: Write text (or edit text) and when leaving | + | :!: 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. |
- | :!: If the right to edit ´´customers´´ is removed | + | :!: If the right to change |
- | can write a comment in the report, which is saved automatically. | + | can write a comment after the customer int comment in the report, which is saved automatically. |
{{: | {{: | ||
Line 59: | Line 60: | ||
***To Pay ** - opens invoice balance | ***To Pay ** - opens invoice balance | ||
***Prepayment** - opens customer’s prepayment list | ***Prepayment** - opens customer’s prepayment list | ||
+ | ***Balance** - opens customer`s periodic statement with the data of the last 2 months | ||
+ | ***Payment schedule** - the invoice payment schedule opens | ||
=====4. Fine tuning===== | =====4. Fine tuning===== | ||
- | {{:et:jane20210901-192411.png}} | + | {{:et:triinp20221101-112859.png}} |
- | Picture(1) | + | Picture(2) |
***Setting{{: | ***Setting{{: | ||
***Excel sheet {{: | ***Excel sheet {{: | ||
***Save report {{: | ***Save report {{: | ||
- | ***Split label** - choices: numbers, days | ||
- | {{:et:jane20210901-192635.png}} \\ | + | {{:et:triinp20221101-120834.png}} \\ |
- | Picture(2) | + | |
- | + | ||
- | {{: | + | |
- | {{: | + | |
Picture(3) | Picture(3) | ||
+ | ***Split label** - choices: numbers, days | ||
+ | {{: | ||
+ | {{: | ||
+ | Picture(4) | ||
- | ***Customer | + | ***Customer |
***Customer datafields ** - choose 3,6,9 (amount of the data fields in the report) | ***Customer datafields ** - choose 3,6,9 (amount of the data fields in the report) | ||
***Currency** - EUR (default) | ***Currency** - EUR (default) | ||
Line 84: | Line 86: | ||
- | 5.1.1 Sales Ledger regular report with currency option: | + | === 5.1.1. Sales Ledger regular report with currency option |
- | {{: | + | |
- | Picture(4) | + | |
- | 5.1.2 __**Show only SEK and USD invoices**__ – for this selection separate currency codes with commas without space „SEK, | + | {{:et:triinp20221101-121049.png}} \\ |
- | + | ||
- | {{:et:jane20210901-200119.png}} \\ | + | |
Picture(5) | Picture(5) | ||
- | :!: Filtering with " | + | === 5.1.2. Show only SEK and USD invoices === |
- | 5.1.3 __**Don’t show EUR and SEK invoices**__ – for this selection use exclusion mark „!“ and add currency codes separated | + | For this separate |
- | {{:et:jane20210901-200554.png}} \\ | + | {{:et:triinp20221101-121440.png}} \\ |
Picture(6) | Picture(6) | ||
- | :!: Filtering with exclusion mark " | + | :!: Filtering with " |
- | + | === 5.1.3. Don’t show EUR and SEK invoices === | |
- | 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}} \\ | + | For this selection use exclusion mark „!“ and add currency codes separated with commas. For example insert „!EUR, |
+ | |||
+ | {{:et:triinp20221101-121607.png}} \\ | ||
Picture(7) | Picture(7) | ||
- | 5.1.5 __**Date not added and currency selection**__ – gives the report all the balance dividend between currencies and calculates prepayments | + | :!: Filtering |
- | {{:et:jane20210901-201247.png}} \\ | + | |
+ | === 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:triinp20221101-122703.png}} \\ | ||
Picture(8) | 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.1.6 Overlaps are possible === | ||
+ | |||
+ | Works with filter Total - customers. Only customers with both debt and prepayment can be filtered out. | ||
+ | |||
+ | {{: | ||
+ | Picture (10) | ||
==== 5.2. Using the customer' | ==== 5.2. Using the customer' | ||
Line 122: | Line 140: | ||
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", | 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: \\ | + | === 5.2.1. Add a customer debt comment to sales ledgers |
- | {{:et:jane20210916-154305.png}}\\ | + | |
- | Picture (9) | + | {{:et:triinp20221101-124225.png}}\\ |
+ | Picture (11) | ||
Also visible when grouped by customers. | Also visible when grouped by customers. | ||
- | {{:et:jane20210916-154515.png}}\\ | + | {{:et:triinp20221101-124349.png}}\\ |
- | Picture (10) \\ | + | Picture (12) \\ |
:!: If there is no change option, the user does not have the right to change the client card. | :!: If there is no change option, the user does not have the right to change the client card. | ||
{{: | {{: | ||
- | Picture (11) | + | Picture (13) |
- | 5.2.2. The customer' | + | ===5.2.2. The customer' |
- | {{:et:jane20210901-204444.png}} | + | {{:et:triinp20221101-124837.png}} |
- | Picture (12) | + | Picture (14) |
+ | ==== 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. | ||
+ | {{: | ||
+ | Picture (15) | ||
en/mr_aru_reskontro.txt · Last modified: 2024/05/17 10:54 by vilja