Balance List (BL)

eManager sends a Balance List (BL) export to the WMS/ERP system to verify that the product quantity is correct.

The export will report quantity on three levels:

• Product - The total quantity in stock for a given product
• Batch - The quantity in stock for a given batch
• ProductLocation - The quantity stored at the given location

The sum of quantities from all batches and all product locations should each match the total quantity reported for the product.

Note: The Balance List (BL) export is triggered by a recurrent task called BalanceList. To enable this task and set the task schedule, contact Element Logic Support.

Data structure

The table below describes the Balance List (BL) data structure.

Field name	Type	Length	Mandatory	Description
TransactionId	Integer	32-bit	No	Unique identifier for transaction
ExtProductId	String	50	Yes	Unique identifier for the product
Quantity	Decimal	18,3	Yes	Total quantity in stock either in total, for the batch, or for the specific location
ExtLocationId	String	100	Yes	Unique identifier for the location
BatchId	String	50	No	Unique identifier for the product batch
ExpiryDate	String	50	No	Expiry date of the stored items, formatted as: yyyy.MM.dd

Examples

XML

<?xml version="1.0" encoding="utf-8"?>
<BalanceList xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <TransactionId>8500670</TransactionId>
  <Products>
    <Product>
      <Quantity>10.000</Quantity>
      <ExtProductId>192364204818</ExtProductId>
      <ExtId />
      <Batches>
        <Batch>
          <Quantity>8.000</Quantity>
          <BatchId>0</BatchId>
          <ProductLocations>
            <ProductLocation>
              <ExtLocationId>AS-17375-01-01</ExtLocationId>
              <Quantity>5.000</Quantity>
              <ExpiryDate />
            </ProductLocation>
            <ProductLocation>
              <ExtLocationId>AS-29416-01-01</ExtLocationId>
              <Quantity>3.000</Quantity>
              <ExpiryDate />
            </ProductLocation>
          </ProductLocations>
        </Batch>
        <Batch>
          <Quantity>2.000</Quantity>
          <BatchId>1</BatchId>
          <ProductLocations>
            <ProductLocation>
              <ExtLocationId>AS-17399-01-01</ExtLocationId>
              <Quantity>2.000</Quantity>
              <ExpiryDate>2022.01.01</ExpiryDate>
            </ProductLocation>
          </ProductLocations>
        </Batch>
      </Batches>
    </Product>
  </Products>
</BalanceList>