Differences

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

--- en:or_aru_reskontro [2022/06/17 23:17] – [1. Filters and filter options] jane
+++ 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 25: / Line 24: @@
 ===== 2. Choices =====
-{{:et:triinp20220608-101353.png}}
+{{:et:triinp20221031-155124.png}}
   ***Only overdue** –  Report shows only overdue purchase invoices.
@@ Line 35: / Line 34: @@
   ***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.
-{{:et:triinp20220608-101503.png}}
+{{:et:triinp20221031-155224.png}}
+  ***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.
-{{:et:triinp20220608-101639.png}}
+{{:et:triinp20221031-155336.png}}
 ===== 3. Links =====
   ***Invoice number** – Opens purchase invoice.
@@ Line 48: / 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:pl1.png?|}}
+{{: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:pl4.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.