Understand consignment revenue

The Revenue action on the Consignment page aggregates revenue data by customer for a consignment line. Each record represents a customer on the consignment line and shows revenue across three stages: Unposted (open orders), Shipped (shipped but not invoiced), and Invoiced (fully posted). Within each stage, revenue is split into gross, discount, and net, and total fields show the sum across all stages.

On the Consignment Revenue page, you can view the following fields:

Field	Description
Source No.	Specifies the customer number.
Gross Revenue (Unposted)	Specifies the gross revenue from unposted sales orders for this customer. This value is based on consignment detail lines of type Revenue with subtype Expected from unposted sales documents.
Discount (Unposted)	Specifies the sales discount from unposted sales orders for this customer. This value is aggregated from the Discount Value (indirect) field value on consignment detail lines.
Net Revenue (Unposted)	Specifies the net revenue from unposted sales orders for this customer. This value is calculated as Gross Revenue (Unposted) field value minus Discount (Unposted) field value.
Gross Revenue (Shipped)	Specifies the gross revenue from shipped but not yet invoiced sales for this customer. This value is aggregated from consignment detail lines of type Revenue with subtype Expected from posted shipment documents.
Discount (Shipped)	Specifies the sales discount from shipped but not yet invoiced sales for this customer. This value is aggregated from the Discount Value (indirect) field value on consignment detail lines.
Net Revenue (Shipped)	Specifies the net revenue from shipped but not yet invoiced sales for this customer. This value is calculated as Gross Revenue (Shipped) field value minus Discount (Shipped) field value.
Gross Revenue (Invoiced)	Specifies the gross revenue from invoiced sales for this customer. This value is aggregated from consignment detail lines of type Revenue with subtype Actual from posted invoice documents.
Discount (Invoiced)	Specifies the sales discount from invoiced sales for this customer. This value is aggregated from the Discount Value (indirect) field value on consignment detail lines.
Net Revenue (Invoiced)	Specifies the net revenue from invoiced sales for this customer. This value is calculated as Gross Revenue (Invoiced) field value minus Discount (Invoiced) field value.
Source Name	Specifies the source name associated with the Source No. field value.
Gross Revenue (Total)	Specifies the total gross revenue for this customer. This value is calculated as follows: Gross Revenue (Unposted) + Gross Revenue (Shipped) + Gross Revenue (Invoiced).
Discount (Total)	Specifies the total sales discount for this customer. This value is calculated as follows: Discount (Unposted) + Discount (Shipped) + Discount (Invoiced).
Net Revenue (Total)	Specifies the total net revenue for this customer. This value is calculated as follows: Net Revenue (Unposted) + Net Revenue (Shipped) + Net Revenue (Invoiced).

The Revenue Details action on the Consignment Revenue page provides detailed revenue information for individual entries, such as sales orders and posted sales invoices.