> ## Documentation Index > Fetch the complete documentation index at: https://docs.bigcapital.app/llms.txt > Use this file to discover all available pages before exploring further. # Retrieves the inventory valuation sheet ## OpenAPI ````yaml api-reference/openapi.json get /api/reports/inventory-valuation openapi: 3.0.0 info: title: Bigcapital description: Financial accounting software version: '1.0' contact: {} servers: [] security: [] tags: [] paths: /api/reports/inventory-valuation: get: tags: - Reports summary: Retrieves the inventory valuation sheet operationId: InventoryValuationController_getInventoryValuationSheet parameters: - name: Authorization in: header description: >- Value must be 'Bearer ' where is an API key prefixed with 'bc_' or a JWT token. required: true schema: type: string example: Bearer bc_1234567890abcdef - name: organization-id in: header description: >- Required if Authorization is a JWT token. The organization ID to operate within. required: true schema: type: string - name: asDate required: false in: query description: The date for which the inventory valuation is requested schema: example: '2024-01-01T00:00:00.000Z' type: string - description: Number of decimal places to display required: false name: precision in: query schema: example: 2 type: number - description: Whether to divide the number by 1000 required: false name: divideOn1000 in: query schema: example: false type: boolean - description: Whether to show zero values required: false name: showZero in: query schema: type: boolean example: true - description: How to format money values required: false name: formatMoney in: query schema: example: total enum: - total - always - none type: string - description: How to format negative numbers required: false name: negativeFormat in: query schema: example: parentheses enum: - parentheses - mines type: string - name: noneTransactions required: false in: query description: Whether to exclude transactions schema: example: false type: boolean - name: noneZero required: false in: query description: Whether to exclude zero values schema: example: false type: boolean - name: onlyActive required: false in: query description: Whether to include only active items schema: type: boolean example: true - name: itemsIds required: false in: query description: Array of item IDs to filter schema: example: - 1 - 2 - 3 type: array items: type: number - name: warehousesIds required: false in: query description: Array of warehouse IDs to filter schema: example: - 10 - 20 type: array items: type: number - name: branchesIds required: false in: query description: Array of branch IDs to filter schema: example: - 100 - 200 type: array items: type: number - name: accept required: true in: header schema: type: string responses: '200': description: The inventory valuation sheet content: application/json: schema: $ref: '#/components/schemas/InventoryValuationResponseDto' application/json+table: schema: $ref: '#/components/schemas/InventoryValuationTableResponseDto' components: schemas: InventoryValuationResponseDto: type: object properties: query: description: Query parameters used to generate the report allOf: - $ref: '#/components/schemas/InventoryValuationQueryResponseDto' data: description: Inventory items valuation type: array items: $ref: '#/components/schemas/InventoryValuationItemDto' meta: description: Report metadata allOf: - $ref: '#/components/schemas/InventoryValuationMetaDto' required: - query - data - meta InventoryValuationTableResponseDto: type: object properties: table: description: Table data structure allOf: - $ref: '#/components/schemas/FinancialTableDataDto' query: description: Query parameters used to generate the report allOf: - $ref: '#/components/schemas/InventoryValuationQueryResponseDto' meta: description: Report metadata allOf: - $ref: '#/components/schemas/InventoryValuationMetaDto' required: - table - query - meta InventoryValuationQueryResponseDto: type: object properties: asDate: type: string description: As-of date numberFormat: description: Number format settings allOf: - $ref: '#/components/schemas/NumberFormatQueryDto' itemsIds: description: Item IDs to include type: array items: type: number noneZero: type: boolean description: Exclude zero quantity items required: - asDate - numberFormat - itemsIds - noneZero InventoryValuationItemDto: type: object properties: id: type: number description: Item ID name: type: string description: Item name code: type: string description: Item code type: type: string description: Item type quantityOnHand: type: number description: Quantity on hand averageCost: type: number description: Average cost totalValue: description: Total value allOf: - $ref: '#/components/schemas/FinancialReportTotalDto' assetAccountName: type: string description: Asset account name assetAccountCode: type: string description: Asset account code required: - id - name - code - type InventoryValuationMetaDto: type: object properties: organizationName: type: string description: Organization name baseCurrency: type: string description: Base currency code dateFormat: type: string description: Date format string isCostComputeRunning: type: boolean description: Whether cost computation is running sheetName: type: string description: Sheet name formattedAsDate: type: string description: Formatted as-of date formattedDateRange: type: string description: Formatted date range required: - organizationName - baseCurrency - dateFormat - isCostComputeRunning - sheetName - formattedAsDate - formattedDateRange FinancialTableDataDto: type: object properties: columns: description: Table column definitions type: array items: $ref: '#/components/schemas/FinancialTableColumnDto' rows: description: Table row data type: array items: $ref: '#/components/schemas/FinancialTableRowDto' required: - columns - rows NumberFormatQueryDto: type: object properties: precision: type: number description: Number of decimal places to display example: 2 divideOn1000: type: boolean description: Whether to divide the number by 1000 example: false showZero: type: boolean description: Whether to show zero values example: true formatMoney: type: string description: How to format money values example: total enum: - total - always - none negativeFormat: type: string description: How to format negative numbers example: parentheses enum: - parentheses - mines FinancialReportTotalDto: type: object properties: amount: type: number description: Numeric amount formattedAmount: type: string description: Formatted amount string currencyCode: type: string description: Currency code date: type: object description: Date associated with the total required: - amount - formattedAmount - currencyCode FinancialTableColumnDto: type: object properties: key: type: string description: Column key label: type: string description: Column header label cellIndex: type: number description: Cell position index children: description: Nested column definitions type: array items: $ref: '#/components/schemas/FinancialTableColumnDto' required: - key - label FinancialTableRowDto: type: object properties: cells: description: Cell data for this row type: array items: $ref: '#/components/schemas/FinancialTableCellDto' rowTypes: description: Row type classifications type: array items: type: string id: type: object description: Row identifier children: description: Child rows type: array items: $ref: '#/components/schemas/FinancialTableRowDto' required: - cells - rowTypes - id FinancialTableCellDto: type: object properties: key: type: string description: Cell key value: type: string description: Cell value required: - key - value ````