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 12:49] – [1. Filters and filter options] triinp | en:mr_aru_reskontro [2022/12/27 15:34] – [5.1.5. Date not added and currency selected] triinp | ||
---|---|---|---|
Line 68: | Line 68: | ||
***Excel sheet {{: | ***Excel sheet {{: | ||
***Save report {{: | ***Save report {{: | ||
- | ***Split label** - choices: numbers, days | ||
{{: | {{: | ||
Picture(3) | Picture(3) | ||
+ | ***Split label** - choices: numbers, days | ||
{{: | {{: | ||
{{: | {{: | ||
Picture(4) | 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 85: | Line 84: | ||
- | __** 5.1.1.Sales Ledger regular report with currency option:**__ | + | === 5.1.1. Sales Ledger regular report with currency option |
{{: | {{: | ||
Picture(5) | Picture(5) | ||
- | __**5.1.2. Show only SEK and USD invoices**__ – for this selection | + | === 5.1.2. Show only SEK and USD invoices |
+ | |||
+ | For this separate currency codes with commas without space „SEK, | ||
{{: | {{: | ||
Line 96: | Line 98: | ||
:!: Filtering with " | :!: Filtering with " | ||
- | __**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. Don’t show EUR and SEK invoices |
+ | |||
+ | For this selection use exclusion mark „!“ and add currency codes separated with commas. For example insert „!EUR, | ||
{{: | {{: | ||
Picture(7) | Picture(7) | ||
- | :!: Filtering with exclusion mark "!" and "comma" works also with Customer salesman/ | + | :!: Filtering with exclusion mark " |
- | __**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. | + | === 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. | ||
{{: | {{: | ||
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. | + | === 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) | Picture(9) | ||
+ | |||
+ | === 5.1.6 Overlaps are possible === | ||
+ | |||
+ | Works with filter Total - customers. Only customers with both debt and prepayment can be filtered out. | ||
+ | |||
+ | {{: | ||
==== 5.2. Using the customer' | ==== 5.2. Using the customer' | ||
Line 123: | Line 137: | ||
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 |
{{: | {{: | ||
Picture (10) | Picture (10) | ||
Line 134: | Line 149: | ||
Picture (12) | Picture (12) | ||
- | __**5.2.2. The customer' | + | ===5.2.2. The customer' |
{{: | {{: | ||
- | Picture (13) | ||
+ | ==== 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. | ||
+ | |||
+ | {{: | ||
en/mr_aru_reskontro.txt · Last modified: 2024/05/17 10:54 by vilja