GET Reporting/V1/Stock/GetStockReconciliationReport?periodEndDateUtc={periodEndDateUtc}

Gets the Stock Reconciliation report data for given period date.

Request Information

URI Parameters

Name	Type	Description	Additional information
periodEndDateUtc	date	End Date of the requested Stock Period

Body Parameters

None.

Response Information

Resource Description

Collection of StockPeriodReconciliationItemDto

Name	Type	Additional information
StockPeriodID	integer	None.
SiteName	string	None.
ProductID	integer	None.
Product	string	None.
ProductType	string	None.
ProductGroup	string	None.
StocktakeCategory	string	None.
Unit	string	None.
ClosingNetCostPrice	decimal number	None.
OpeningQty	decimal number	None.
ExpClosingQty	decimal number	None.
ClosingQty	decimal number	None.
PreviousStockVarianceQty	decimal number	None.
StockVarianceQty	decimal number	None.
Rebate	decimal number	None.
QtySold	decimal number	None.
QtyUsed	decimal number	None.
QtyAutoUsed	decimal number	None.
QtyProduced	decimal number	None.
QtyShipped	decimal number	None.
QtyDelivered	decimal number	None.
QtyCredited	decimal number	None.
QtyWasted	decimal number	None.
QtyInbound	decimal number	None.
QtyOutbound	decimal number	None.
NetSales	decimal number	None.
ExpNetSales	decimal number	None.
NetCostOfSales	decimal number	None.
NetCostOfWastage	decimal number	None.
NetCostOfAutoUsage	decimal number	None.
NetCreditSubtotal	decimal number	None.
NetDeliverySubtotal	decimal number	None.
NetStockVarianceValue	decimal number	None.
NetStockValue	decimal number	None.
CostOfSalesMargin	decimal number	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "StockPeriodID": 1,
    "SiteName": "sample string 2",
    "ProductID": 3,
    "Product": "sample string 4",
    "ProductType": "sample string 5",
    "ProductGroup": "sample string 6",
    "StocktakeCategory": "sample string 7",
    "Unit": "sample string 8",
    "ClosingNetCostPrice": 9.0,
    "OpeningQty": 10.0,
    "ExpClosingQty": 11.0,
    "ClosingQty": 12.0,
    "PreviousStockVarianceQty": 1.0,
    "StockVarianceQty": 1.0,
    "Rebate": 13.0,
    "QtySold": 14.0,
    "QtyUsed": 15.0,
    "QtyAutoUsed": 16.0,
    "QtyProduced": 17.0,
    "QtyShipped": 18.0,
    "QtyDelivered": 19.0,
    "QtyCredited": 20.0,
    "QtyWasted": 21.0,
    "QtyInbound": 22.0,
    "QtyOutbound": 23.0,
    "NetSales": 24.0,
    "ExpNetSales": 25.0,
    "NetCostOfSales": 26.0,
    "NetCostOfWastage": 27.0,
    "NetCostOfAutoUsage": 144.0,
    "NetCreditSubtotal": 29.0,
    "NetDeliverySubtotal": 30.0,
    "NetStockVarianceValue": 9.0,
    "NetStockValue": 108.0,
    "CostOfSalesMargin": 159.0
  },
  {
    "StockPeriodID": 1,
    "SiteName": "sample string 2",
    "ProductID": 3,
    "Product": "sample string 4",
    "ProductType": "sample string 5",
    "ProductGroup": "sample string 6",
    "StocktakeCategory": "sample string 7",
    "Unit": "sample string 8",
    "ClosingNetCostPrice": 9.0,
    "OpeningQty": 10.0,
    "ExpClosingQty": 11.0,
    "ClosingQty": 12.0,
    "PreviousStockVarianceQty": 1.0,
    "StockVarianceQty": 1.0,
    "Rebate": 13.0,
    "QtySold": 14.0,
    "QtyUsed": 15.0,
    "QtyAutoUsed": 16.0,
    "QtyProduced": 17.0,
    "QtyShipped": 18.0,
    "QtyDelivered": 19.0,
    "QtyCredited": 20.0,
    "QtyWasted": 21.0,
    "QtyInbound": 22.0,
    "QtyOutbound": 23.0,
    "NetSales": 24.0,
    "ExpNetSales": 25.0,
    "NetCostOfSales": 26.0,
    "NetCostOfWastage": 27.0,
    "NetCostOfAutoUsage": 144.0,
    "NetCreditSubtotal": 29.0,
    "NetDeliverySubtotal": 30.0,
    "NetStockVarianceValue": 9.0,
    "NetStockValue": 108.0,
    "CostOfSalesMargin": 159.0
  }
]

application/xml, text/xml

Sample:

<ArrayOfStockPeriodReconciliationItemDto xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Tevalis.StockMid.Core.Models.StockPeriods.Dto">
  <StockPeriodReconciliationItemDto>
    <ClosingNetCostPrice>9</ClosingNetCostPrice>
    <ClosingQty>12</ClosingQty>
    <ExpClosingQty>11</ExpClosingQty>
    <ExpNetSales>25</ExpNetSales>
    <NetCostOfAutoUsage>144</NetCostOfAutoUsage>
    <NetCostOfSales>26</NetCostOfSales>
    <NetCostOfWastage>27</NetCostOfWastage>
    <NetCreditSubtotal>29</NetCreditSubtotal>
    <NetDeliverySubtotal>30</NetDeliverySubtotal>
    <NetSales>24</NetSales>
    <NetStockVarianceValue>9</NetStockVarianceValue>
    <OpeningQty>10</OpeningQty>
    <PreviousStockVarianceQty>1</PreviousStockVarianceQty>
    <Product>sample string 4</Product>
    <ProductGroup>sample string 6</ProductGroup>
    <ProductID>3</ProductID>
    <ProductType>sample string 5</ProductType>
    <QtyAutoUsed>16</QtyAutoUsed>
    <QtyCredited>20</QtyCredited>
    <QtyDelivered>19</QtyDelivered>
    <QtyInbound>22</QtyInbound>
    <QtyOutbound>23</QtyOutbound>
    <QtyProduced>17</QtyProduced>
    <QtyShipped>18</QtyShipped>
    <QtySold>14</QtySold>
    <QtyUsed>15</QtyUsed>
    <QtyWasted>21</QtyWasted>
    <Rebate>13</Rebate>
    <SiteName>sample string 2</SiteName>
    <StockPeriodID>1</StockPeriodID>
    <StocktakeCategory>sample string 7</StocktakeCategory>
    <Unit>sample string 8</Unit>
  </StockPeriodReconciliationItemDto>
  <StockPeriodReconciliationItemDto>
    <ClosingNetCostPrice>9</ClosingNetCostPrice>
    <ClosingQty>12</ClosingQty>
    <ExpClosingQty>11</ExpClosingQty>
    <ExpNetSales>25</ExpNetSales>
    <NetCostOfAutoUsage>144</NetCostOfAutoUsage>
    <NetCostOfSales>26</NetCostOfSales>
    <NetCostOfWastage>27</NetCostOfWastage>
    <NetCreditSubtotal>29</NetCreditSubtotal>
    <NetDeliverySubtotal>30</NetDeliverySubtotal>
    <NetSales>24</NetSales>
    <NetStockVarianceValue>9</NetStockVarianceValue>
    <OpeningQty>10</OpeningQty>
    <PreviousStockVarianceQty>1</PreviousStockVarianceQty>
    <Product>sample string 4</Product>
    <ProductGroup>sample string 6</ProductGroup>
    <ProductID>3</ProductID>
    <ProductType>sample string 5</ProductType>
    <QtyAutoUsed>16</QtyAutoUsed>
    <QtyCredited>20</QtyCredited>
    <QtyDelivered>19</QtyDelivered>
    <QtyInbound>22</QtyInbound>
    <QtyOutbound>23</QtyOutbound>
    <QtyProduced>17</QtyProduced>
    <QtyShipped>18</QtyShipped>
    <QtySold>14</QtySold>
    <QtyUsed>15</QtyUsed>
    <QtyWasted>21</QtyWasted>
    <Rebate>13</Rebate>
    <SiteName>sample string 2</SiteName>
    <StockPeriodID>1</StockPeriodID>
    <StocktakeCategory>sample string 7</StocktakeCategory>
    <Unit>sample string 8</Unit>
  </StockPeriodReconciliationItemDto>
</ArrayOfStockPeriodReconciliationItemDto>