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:or_aru_reskontro [2022/10/31 14:02] triinp [2. Choices] |
en:or_aru_reskontro [2022/11/01 14:26] triinp [5.1 Filtering options] |
||
---|---|---|---|
Line 25: | Line 25: | ||
===== 2. Choices ===== | ===== 2. Choices ===== | ||
- | {{:et:triinp20220608-101353.png}} | + | {{:et:triinp20221031-155124.png}} |
***Only overdue** – Report shows only overdue purchase invoices. | ***Only overdue** – Report shows only overdue purchase invoices. | ||
Line 35: | Line 35: | ||
***D account** - Report shows debt account. | ***D account** - Report shows debt account. | ||
***Total (Supplier/Country/Class)** – Supplier - shows total amount of unpaid invoices, prepayment and current balance by supplier. Country - shows total amount of unpaid invoices, prepayment and current balance by country. Vendors without a country are displayed together without the country code. Class - shows total amount of unpaid invoices, prepayment and current balance by class. | ***Total (Supplier/Country/Class)** – Supplier - shows total amount of unpaid invoices, prepayment and current balance by supplier. Country - shows total amount of unpaid invoices, prepayment and current balance by country. Vendors without a country are displayed together without the country code. Class - shows total amount of unpaid invoices, prepayment and current balance by class. | ||
- | {{:et:triinp20220608-101503.png}} | + | {{:et:triinp20221031-155224.png}} |
- | ***Overlaps are possible** - only lines with prepayment and balance remain in the Total view with this option | + | ***Overlaps are possible** - with this option only lines with prepayment and balance remain in the Total view |
***Sorted By** – Sorting options. First drop-down: Supplier sorts by supplier codes and name by supplier names. Second drop-down is for sorting suppliers invoices by invoice number, invoice time or invoice due date. | ***Sorted By** – Sorting options. First drop-down: Supplier sorts by supplier codes and name by supplier names. Second drop-down is for sorting suppliers invoices by invoice number, invoice time or invoice due date. | ||
- | {{:et:triinp20220608-101639.png}} | + | {{:et:triinp20221031-155336.png}} |
Line 52: | Line 52: | ||
===== 4. Fine tuning ===== | ===== 4. Fine tuning ===== | ||
- | {{:et:pl1.png?|}} | + | {{:et:triinp20221031-155829.png}} |
Picture (1) | Picture (1) | ||
Line 59: | Line 59: | ||
***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 | ||
- | + | {{:et:triinp20221101-141353.png}} | |
- | {{:et:pl2.png?|}} | + | |
Picture (2) | Picture (2) | ||
- | + | {{:et:triinp20221101-140929.png}} | |
- | {{:et:pl3.png?|}} | + | {{:et:triinp20221101-141649.png}} |
- | {{:et:pl3_1.png?|}} | + | |
Picture (3) | Picture (3) | ||
Line 76: | Line 73: | ||
__//**5.1.1 Purchase Ledger regular report with currency option **//__ | __//**5.1.1 Purchase Ledger regular report with currency option **//__ | ||
- | {{:et:pl4.png?|}} | + | {{:et:triinp20221031-160125.png}} |
Picture (4) | Picture (4) | ||
Line 82: | Line 79: | ||
__//**5.1.2 Show only SEK and USD purchase invoices**//__ - for this selection divide currency codes with commas „SEK,USD“. If you want to see only USD invoices then wrote „USD“ | __//**5.1.2 Show only SEK and USD purchase invoices**//__ - for this selection divide currency codes with commas „SEK,USD“. If you want to see only USD invoices then wrote „USD“ | ||
- | {{:et:pl5.png?|}} | + | {{:et:triinp20221031-160305.png}} |
Picture (5) | Picture (5) | ||
Line 88: | Line 85: | ||
__//**5.1.3 Don’t show EUR and SEK purchase invoices**//__ – for this selection mark exclusion mark „!“ and add currency codes seperated with commas „!EUR,SEK“. Report shows only USD invoices. If you want exclude only SEK invoices, then wrote „!SEK“ | __//**5.1.3 Don’t show EUR and SEK purchase invoices**//__ – for this selection mark exclusion mark „!“ and add currency codes seperated with commas „!EUR,SEK“. Report shows only USD invoices. If you want exclude only SEK invoices, then wrote „!SEK“ | ||
- | {{:et:pl6.png?|}} | + | {{:et:triinp20221101-142655.png}} |
Picture (6) | Picture (6) | ||
Line 94: | Line 91: | ||
__//**5.1.4 Show Object „LADU“ (warehouse) overdue invoices **//__ | __//**5.1.4 Show Object „LADU“ (warehouse) overdue invoices **//__ | ||
- | {{:et:pl7.png?|}} | + | {{:et:triinp20221031-160807.png}} |
Picture (7) | Picture (7) |