User Tools

Site Tools



en:or_aru_reskontro

Differences

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

Link to this comparison view

Next revision
Previous revision
Next revision Both sides next revision
en:or_aru_reskontro [2021/11/10 13:00]
evelint created
en:or_aru_reskontro [2022/10/31 16:04]
triinp [5.1 Filtering options]
Line 13: Line 13:
  
  
-  ***Object** – shows purchase invoices with selected object.+  ***Object** – shows purchase invoices with selected object, function ​ exclusion mark  !OBJECT is added.
   ***PP account** – supplier prepayment account.   ***PP account** – supplier prepayment account.
   ***Divide/ Configure** – distributes the amount of unpaid purchase invoices over time. E.g divide by 3 x 7 shows expected payments for the previous three and the following three weeks, based on payment term.   ***Divide/ Configure** – distributes the amount of unpaid purchase invoices over time. E.g divide by 3 x 7 shows expected payments for the previous three and the following three weeks, based on payment term.
Line 25: Line 25:
 ===== 2. Choices =====  ===== 2. Choices ===== 
  
 +{{:​et:​triinp20221031-155124.png}}
  
   ***Only overdue** –  Report shows only overdue purchase invoices.   ***Only overdue** –  Report shows only overdue purchase invoices.
Line 30: Line 31:
   ***Currency** – in addition to the balance, the currency column, prepayments by exchange rate and currencies in total and compared to the current exchange rate are shown in report.   ***Currency** – in addition to the balance, the currency column, prepayments by exchange rate and currencies in total and compared to the current exchange rate are shown in report.
   ***Supplier Data** –  Report shows supplier information.   ***Supplier Data** –  Report shows supplier information.
-  ***Total (Supplier/​Country)** – 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. +  ​***Invoice project** - Report shows project related to the invoice. 
-  ***Sorted By** – Sorting options. First drop-down: Supplier sorts by supplier codes and name by supplier names. Second drop-drow is for sorting suppliers invoices by invoice number, invoice time or invoice due date.+  ***Invoice object** - Report shows object related to the invoice. 
 +  ***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:​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:​triinp20221031-155336.png}}
  
  
Line 45: Line 52:
 ===== 4. Fine tuning =====  ===== 4. Fine tuning ===== 
  
-{{:et:pl1.png?|}}+{{:et:triinp20221031-155829.png}}
  
 Picture (1) Picture (1)
Line 69: Line 76:
 __//**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 75: Line 82:
 __//**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 81: Line 88:
 __//**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:triinp20221031-160443.png}}
  
 Picture (6) Picture (6)
en/or_aru_reskontro.txt · Last modified: 2023/03/10 09:56 by triinp