Differences

This shows you the differences between two versions of the page.

--- en:or_aru_reskontro [2022/10/31 16:01] – [5.1 Filtering options] triinp
+++ en:or_aru_reskontro [2023/03/10 09:56] (current) – [3. Links] triinp
@@ Line 4: / Line 4: @@
 ===== 1. Filters and filter options =====
   *** 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.
 {{:et:triinp20221031-155336.png}}
 ===== 3. Links =====
   ***Invoice number** – Opens purchase invoice.
@@ Line 49: / Line 46: @@
   ***To Pay** – Opens invoice balance.
   ***Prepayment** – Opens supplier´s prepayment list.
+  ***Balance** - opens supplier`s periodic statement with the data of the last 2 months
+  ***Payment schedule** - the invoice payment schedule opens
 ===== 4. Fine tuning =====
 {{:et:triinp20221031-155829.png}}
-Picture (1)
   ***Setting** {{:et:peenh22lestus_ikoon.png?|}} - possibility to choose personal settings
   ***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
+{{:et:triinp20221101-141353.png}}
-{{:et:pl2.png?|}}
+{{:et:triinp20221101-140929.png}}
+{{:et:triinp20221101-141649.png}}
-Picture (2)
+===== 5. Samples =====
-{{:et:pl3.png?|}}
+====5.1 Filtering options====
-{{:et:pl3_1.png?|}}
-Picture (3)
+=== 5.1.1 Purchase Ledger regular report with currency option ===
+{{:et:triinp20221101-143007.png}}
-===== 5. Samples =====
-====5.1 Filtering options====
+=== 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:triinp20221031-160305.png}}
-__//**5.1.1 Purchase Ledger regular report with currency option **//__
+=== 5.1.3 Don’t show EUR and SEK purchase invoices ===
-{{:et:triinp20221031-160125.png}}
+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“
-Picture (4)
+{{:et:triinp20221101-142655.png}}
-__//**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?|}}
+=== 5.1.4 Show Object „LADU“ (warehouse) overdue invoices ===
-Picture (5)
+{{:et:triinp20221031-160807.png}}
-__//**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?|}}
+=== 5.1.5 Overlaps are possible ===
-Picture (6)
+Works with filter Total - suppliers. Only suppliers with both debt and prepayment can be filtered out.
-__//**5.1.4 Show Object „LADU“ (warehouse) overdue invoices **//__
+{{:et:triinp20221209-135934.png}}
-{{:et:pl7.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.