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 | ||
|
en:mr_aru_reskontro [2022/11/01 12:56] triinp [4. Fine tuning] |
en:mr_aru_reskontro [2023/04/14 09:53] (current) triinp [1. Filters and filter options] |
||
|---|---|---|---|
| Line 15: | 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. Character to search empty field works. |
| ***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). | ***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). | ||
| Line 60: | 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===== | ||
| Line 84: | Line 86: | ||
| - | __** 5.1.1.Sales Ledger regular report with currency option:**__ | + | === 5.1.1. Sales Ledger regular report with currency option === |
| {{:et:triinp20221101-121049.png}} \\ | {{:et:triinp20221101-121049.png}} \\ | ||
| Picture(5) | Picture(5) | ||
| - | __**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“ | + | === 5.1.2. Show only SEK and USD invoices === |
| + | |||
| + | For this separate currency codes with commas without space „SEK,USD“. If you want to see only USD invoices then write „USD“ | ||
| {{:et:triinp20221101-121440.png}} \\ | {{:et:triinp20221101-121440.png}} \\ | ||
| Line 95: | Line 100: | ||
| :!: Filtering with "comma" works also with Customer salesman/Invoice salesman. | :!: Filtering with "comma" works also with Customer salesman/Invoice salesman. | ||
| - | __**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“ | + | === 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:triinp20221101-121607.png}} \\ | {{:et:triinp20221101-121607.png}} \\ | ||
| Picture(7) | Picture(7) | ||
| - | :!: Filtering with exclusion mark "!" and "comma" works also with Customer salesman/Invoice salesman. | + | :!: Filtering with exclusion mark "!" works also with option Customer salesman/Invoice salesman. |
| - | __**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. | ||
| {{:et:triinp20221101-122703.png}} \\ | {{: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. | + | === 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. | ||
| {{:et:triinp20221101-123010.png}} \\ | {{:et:triinp20221101-123010.png}} \\ | ||
| 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. | ||
| + | |||
| + | {{:et:triinp20221209-115203.png}} | ||
| + | Picture (10) | ||
| ==== 5.2. Using the customer's internal comment ==== | ==== 5.2. Using the customer's internal comment ==== | ||
| 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", etc.…). You can now see such information directly from the sales ledger. | 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:**__ \\ | + | === 5.2.1. Add a customer debt comment to sales ledgers === |
| {{:et:triinp20221101-124225.png}}\\ | {{:et:triinp20221101-124225.png}}\\ | ||
| - | Picture (10) | + | Picture (11) |
| Also visible when grouped by customers. | Also visible when grouped by customers. | ||
| {{:et:triinp20221101-124349.png}}\\ | {{:et:triinp20221101-124349.png}}\\ | ||
| - | Picture (11) \\ | + | 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. | ||
| {{:et:jane20210901-204030.png}} | {{:et:jane20210901-204030.png}} | ||
| - | Picture (12) | + | Picture (13) |
| - | __**5.2.2. The customer's internal comment can be viewed without the possibility to change it**__ | + | ===5.2.2. The customer's internal comment can be viewed without the possibility to change it=== |
| {{:et:triinp20221101-124837.png}} | {{:et:triinp20221101-124837.png}} | ||
| - | Picture (13) | + | 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. | ||
| + | {{:et:triinp20221101-131101.png}} | ||
| + | Picture (15) | ||
