Query for a data set

Let us specify the query data set.

  1. Select the BalanceOfMaterials.BalanceAndTurnovers virtual table as the data source.
  2. Select the following fields from this table (fig. 15.48):
    • Material
    • PropertySet 
    • QuantityOpeningBalance
    • QuantityReceipt
    • QuantityExpense
    • QuantityClosingBalance

    Fig. 15.48. Fields selected for the query
  3. Click the Unions/Aliases tab and set the aliases for the numeric fields by removing Quantity from their names (fig. 15.49).

    Fig. 15.49. Unions/aliases
  4. Click OK.

    This completes the query creation.