Balance Correction (BC)

eManager sends a Balance Correction (BC) export to correct the balance in the WMS/ERP system when one of the following occurs in eManager:

• An inventory count operation
• An inspection operation
• A pick deviation
• A zero count deviation

Data structure

The table below describes the Balance Correction (BC) data structure.

Field name	Type	Length	Mandatory	Description
TransactionId	Integer	32-bit	No	Unique transaction id for the file, is included in the file name. Used for traceability. Sequence number in eManager.
ExtProductId	String	50	Yes	Unique product id
Difference	Decimal	18,3	Yes	Difference of corrected quantity can be positive or negative.
ReasonCode	String	50	No	Reason for the change in inventory. Mapping from eManager's internal codes must be configured, otherwise the field will be blank.
BatchId	String	50	No	Batch id for product, no batch will always be "0"
LotNo	String	50	No	LotNo for product
Client	String	50	No
Owner	String	50	No
StockReservationKey	String	50	No
ExpiryDate	Date		No	in the format 2025.08.11 (yyyy.MM.dd)
CustomAllocationProperties	data		No	key/value dictionary of current custom allocation properties
FormerAllocationProperties	data		No	Will contain the former allocation properties, before the update causing the BC

Examples

XML

<?xml version="1.0" encoding="utf-8"?>
<BalanceCorrection xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <TransactionId>2239991</TransactionId>
    <ExtProductId>1001-dd3p-pWQ</ExtProductId>
    <BatchId>0</BatchId>
   	<LotNo>L-02</LotNo>
    <ExpiryDate>2025.08.11</ExpiryDate>
    <Difference>-10</Difference>
    <ReasonCode>Exernal correction</ReasonCode>
    <CustomAllocationProperties>
        <Item>
            <Key>
                <string>Color</string>
            </Key>
            <Value>
                <string>Blue</string>
            </Value>
        </Item>
    </CustomAllocationProperties>
    <FormerAllocationProperties>
        <BatchId>0</BatchId>
        <LotNo />
        <Client />
        <Owner />
        <StockReservationKey />
        <ExpiryDate />
        <CustomAllocationProperties />
    </FormerAllocationProperties>
</BalanceCorrection>