en:or_aru_reskontro
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
en:or_aru_reskontro [2022/06/08 10:16] – [2. Choices] triinp | en:or_aru_reskontro [2022/12/27 15:53] – [5.1 Filtering options] triinp | ||
---|---|---|---|
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 13: | Line 12: | ||
- | ***Object** – shows purchase invoices with selected object. | + | ***Object** – shows purchase invoices with selected object, function |
***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 24: | ||
===== 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 34: | ||
***D account** - Report shows debt account. | ***D account** - Report shows debt account. | ||
***Total (Supplier/ | ***Total (Supplier/ | ||
- | {{: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. | ***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 ===== | ===== 3. Links ===== | ||
- | |||
***Invoice number** – Opens purchase invoice. | ***Invoice number** – Opens purchase invoice. | ||
Line 51: | Line 49: | ||
===== 4. Fine tuning ===== | ===== 4. Fine tuning ===== | ||
- | {{:et:pl1.png?|}} | + | {{:et:triinp20221031-155829.png}} |
- | + | ||
- | Picture (1) | + | |
***Setting** {{: | ***Setting** {{: | ||
***Excel sheet** | ***Excel sheet** | ||
***Save report ** {{: | ***Save report ** {{: | ||
+ | {{: | ||
- | {{:et:pl2.png?|}} | + | {{:et:triinp20221101-140929.png}} |
+ | {{: | ||
- | Picture (2) | + | ===== 5. Samples ===== |
- | {{:et:pl3.png?|}} | + | ====5.1 Filtering options==== |
- | {{: | + | |
- | Picture (3) | + | === 5.1.1 Purchase Ledger regular report with currency option === |
+ | {{: | ||
- | ===== 5. Samples ===== | ||
- | |||
- | ====5.1 Filtering options==== | ||
- | __//**5.1.1 Purchase Ledger regular report with currency option **//__ | + | === 5.1.2 Show only SEK and USD purchase invoices === |
- | {{:et:pl4.png?|}} | + | For this selection divide currency codes with commas „SEK, |
- | Picture (4) | + | {{: |
- | __//**5.1.2 Show only SEK and USD purchase invoices**// | ||
- | {{:et:pl5.png?|}} | + | === 5.1.3 Don’t show EUR and SEK purchase invoices === |
- | Picture (5) | + | For this selection mark exclusion mark „!“ and add currency codes seperated with commas „!EUR, |
- | __//**5.1.3 Don’t show EUR and SEK purchase invoices**// | + | {{: |
- | {{: | ||
- | Picture | + | === 5.1.4 Show Object „LADU“ |
- | __//**5.1.4 Show Object „LADU“ (warehouse) overdue invoices **//__ | + | {{: |
- | {{: | ||
- | Picture (7) | + | ====5.2 Nettings forecast report from the Purchase Ledger ==== |
+ | It is possible to start a [[et/ | ||
en/or_aru_reskontro.txt · Last modified: 2023/03/10 09:56 by triinp