en:or_aru_reskontro
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:or_aru_reskontro [2022/11/01 15:58] triinp [5.2 Running Nettings forecast from Purchase Ledger] |
en:or_aru_reskontro [2023/03/10 09:56] (current) triinp [3. Links] |
||
|---|---|---|---|
| Line 46: | Line 46: | ||
| ***To Pay** – Opens invoice balance. | ***To Pay** – Opens invoice balance. | ||
| ***Prepayment** – Opens supplier´s prepayment list. | ***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 ===== | ===== 4. Fine tuning ===== | ||
| Line 63: | Line 65: | ||
| ====5.1 Filtering options==== | ====5.1 Filtering options==== | ||
| - | __//**5.1.1 Purchase Ledger regular report with currency option **//__ | + | === 5.1.1 Purchase Ledger regular report with currency option === |
| {{:et:triinp20221101-143007.png}} | {{:et:triinp20221101-143007.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“ | + | === 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}} | {{:et:triinp20221031-160305.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“ | + | === 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:triinp20221101-142655.png}} | {{:et:triinp20221101-142655.png}} | ||
| - | __//**5.1.4 Show Object „LADU“ (warehouse) overdue invoices **//__ | + | === 5.1.4 Show Object „LADU“ (warehouse) overdue invoices === |
| {{:et:triinp20221031-160807.png}} | {{:et:triinp20221031-160807.png}} | ||
| - | ====5.2 Running Nettings forecast from Purchase Ledger ==== | + | === 5.1.5 Overlaps are possible === |
| + | |||
| + | Works with filter Total - suppliers. Only suppliers with both debt and prepayment can be filtered out. | ||
| + | |||
| + | {{:et:triinp20221209-135934.png}} | ||
| + | |||
| + | |||
| + | ====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. | It is possible to start a [[et/fin_aru_tasaennustus#tasaarveldusennustuse_kaeivitamine_ostureskontro_aruandest|tasaarveldusennustus]] from the purchase ledger report. | ||
