Using voucher report

Voucher report gives a detailed overview of vouchers within the system.

Extend

You can extend the voucherLogs parameter to get a detailed overview of logs and events related to the voucher. The number of reminders is also available here. Add

extend=voucherLogs

to your request

By extending on voucherType, you will get information regarding the type of voucher in this report including the accounting type. Add

extend=voucherType

to your request

Extend can also be used to see what attachments are related to the voucher, what carriers are linked to the voucher, and any crossings on this voucher.

extend=attachments

extend=carriers

extend=crossings

Tips: If you want to see if there are attachments, but you don't want the file contents, you can use

extend=attachmentsShallow

Required filter on voucher year

All requests to this endpoint must have a filter on the voucher year field, due to server limitations. An example of such a filter is:

filter[voucherYear][EQ]=2022

Ledger filter

The option for a quick filter on ledger types allows you to search through specific ledgers for the voucher you need. The available values are "ledger", "generalLedger", "customerLedger", and "supplierLedger." Example:

ledgerFilter[EQ]=generalLedger

Category filter

This filter will allow you to get results based on voucher category. The available values for this are "voucher", "budgett", or "both" Example:

categoryFilter[EQ]=both

Voucher report
Property	Description
id	The database id of this voucher report
accountingPeriod	The accounting period 1, 2, 3, 4, 5, 6, 7, 12, 13 24 or 25.
accountNumber	The account number, customer or supplier, See Register -> AccountChart
accountName	The name of the general ledger account, customer or supplier.
accountType	The type of account this voucher is reporting on. Enum: account, customer, supplier
amountGross	The gross amount.
amountNetto	The net amount.
attachments	List of file attachments. Valid filetypes are png, tiff, jpg, jpeg, bmp and pdf. All of the graphic formats are converted to pdf. The default is that this field is not returned in output without being specified in extends.
carriers	List of carriers. Carrier ids when creating voucher. Only allowed carriers that have usedInAccounting = true in the CarrierType. See Carrier and CarrierType. The default is that this field is not returned in output without being specified in extends.
currencyRestAmount	Currency Similar to restAmount.
currencyGross	The total amount in currency if currency code is used.
currencyRate	Currency rate can have up to 5 decimal places. Enter the exchange rate as 1 of foreign currency against 1 NOK.
currencyCode	If the currency is not NOK, then insert currency code here.
description	Description of the voucher
dueDate	Invoice due date.
kid	Identification number for the payment.
ledgerState	Enum: blank, partCrossed, crossed, locked.
lineNumber	The line of the voucher this voucher report is from
lockVoucher	If the voucher is locked from editing
name	Name of account/customer or supplier.
payType	Nullable enum. Used to store the payment type as Cash, Invoice, AutoPay, PayCard, CreditCard and Currency. Only used in order/invoice
quantity1	This field has an optional name in Duett and can, for example be used for the amount of timber bought/sold.
quantity2	See quantity1
refNumber	Reference number eg: journal number.
reminderDate	Date to send warning of unpaid amount
reminderState	Enum: blank, reminder1, reminder2, collectionNext, collectionSent, collection, sentToCollectionPartner, settledCollectionPartner.
reminderStop
restAmount	The amount left to pay
taxCode	Tax code is generation-driven, so tax code has to be selected with voucher date. This is the 'Key' in TaxCode. If automatedVATHandling is set to false, the only valid taxCodes are null, 0, 1, 3, 4, 5, 6, 7, 8, 10, 21, 23, 25, 26, 27, 28, 31, 33, 35, 36, 91, 93. If the automatedVATHandling is set to true, the api choose the taxCode that is defined on the account. See Register -> taxCodes
voucherCategory	The category that this voucher is in. This can be voucher, budgett, or both.
voucherDate	The date of the voucher
voucherLogs	Extending the voucherLogs will show you a history of edits to the voucher.
voucherNumber	Identification number of the voucher in Duett web/win
voucherType	0 to 199. This is the 'Key' in VoucherType. See Register -> voucherTypes
voucherYear	The accounting year of the voucher

Notes

Voucher report returns different values depending on the type of ledger or category that is selected by the filter.

For invoice vouchers, the original invoices that the report is referencing can be found as attachments

It is recommended to do paging the user when there are large amounts of data (using a combination of filter[take] and filter[skip]) to speed up requests