Business View ibvSalesByCategoryCCY

Description

This view shows the fees postings that correspond to the invoices, credit notes and write offs by period, date, client and categorisation for the current calender year.

The basic figures are VAT inclusive, but the VAT amount is available within the view.

Since this view is steered by the presence of postings, after any aggregation there will be no rows present for accounts and/or period combinations that have no postings present. The absence of an expected row should be taken as the figures being zero.

 

For use by

This view is to be used by those users wanted access to the fees postings.

 

Columns

This view inherits columns from the view:

- ibvClientCategorisation

Year

Fees posting year

Period

Fees posting period in year

Posting

The unique posting number in the period (to support logical primary keys for reporting services).

Date

Posting date

CalendarYear

Calendar year independent of the period structure on ledger

CalendarMonth

Calendar month (1 = Jan, 2 = Feb etc)

Type

The posting type (invoice, credit note etc).

PostTypeDesc

Posting type in human readable form

AffectsWIP

'Y' if the posting affects the WIP

Amount

Posting amount (credit negative)

Matched

Current amount matched (same sign convention)

Outstanding

Current amount outstanding (unmatched) (same sign convention)

VAT

Amount of VAT (same sign convention, but note that this reflects what the user said and, if cash accounting this will appear on both the invoice and the receipt).

NumVATPostings

The number of separate VAT postings associated with the Fees posting.

HighestVATRate

The highest VAT rate associated with the Fees posting.

Reference1

Reference 1 from the posting

Reference2

Reference 2 from the posting

CrossReference

Cross reference from the posting

Narrative

User narrative from the posting