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/11/01 14:13] triinp [4. Fine tuning] |
en:or_aru_reskontro [2022/11/01 15:59] triinp [5.2 Running Nettings forecast from Purchase Ledger] |
||
---|---|---|---|
Line 4: | Line 4: | ||
===== 1. Filters and filter options ===== | ===== 1. Filters and filter options ===== | ||
- | |||
*** Supplier** – supplier code on document, will be filtered by chosen code. | *** Supplier** – supplier code on document, will be filtered by chosen code. | ||
Line 39: | Line 38: | ||
***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:triinp20221031-155336.png}} | {{:et:triinp20221031-155336.png}} | ||
- | |||
===== 3. Links ===== | ===== 3. Links ===== | ||
- | |||
***Invoice number** – Opens purchase invoice. | ***Invoice number** – Opens purchase invoice. | ||
Line 53: | Line 50: | ||
{{:et:triinp20221031-155829.png}} | {{:et:triinp20221031-155829.png}} | ||
- | |||
- | Picture (1) | ||
***Setting** {{:et:peenh22lestus_ikoon.png?|}} - possibility to choose personal settings | ***Setting** {{:et:peenh22lestus_ikoon.png?|}} - possibility to choose personal settings | ||
Line 60: | Line 55: | ||
***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:triinp20221101-141353.png}} | ||
- | Picture (2) | + | |
{{:et:triinp20221101-140929.png}} | {{:et:triinp20221101-140929.png}} | ||
- | {{:et:pl3.png?|}} | + | {{:et:triinp20221101-141649.png}} |
- | {{:et:pl3_1.png?|}} | + | |
- | + | ||
- | Picture (3) | + | |
===== 5. Samples ===== | ===== 5. Samples ===== | ||
Line 74: | Line 65: | ||
__//**5.1.1 Purchase Ledger regular report with currency option **//__ | __//**5.1.1 Purchase Ledger regular report with currency option **//__ | ||
- | {{:et:triinp20221031-160125.png}} | + | {{:et:triinp20221101-143007.png}} |
- | Picture (4) | ||
__//**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“ | ||
Line 82: | Line 72: | ||
{{:et:triinp20221031-160305.png}} | {{:et:triinp20221031-160305.png}} | ||
- | Picture (5) | ||
__//**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:triinp20221031-160443.png}} | + | {{:et:triinp20221101-142655.png}} |
- | Picture (6) | ||
__//**5.1.4 Show Object „LADU“ (warehouse) overdue invoices **//__ | __//**5.1.4 Show Object „LADU“ (warehouse) overdue invoices **//__ | ||
Line 94: | Line 82: | ||
{{:et:triinp20221031-160807.png}} | {{:et:triinp20221031-160807.png}} | ||
- | Picture (7) | ||
+ | ====5.2 Nettings forecast report from the Purchase Ledger ==== | ||
+ | |||
+ | It is possible to start a [[et/fin_aru_tasaennustus#tasaarveldusennustuse_kaeivitamine_ostureskontro_aruandest|tasaarveldusennustus]] from the purchase ledger report. | ||