Balances

Balance date i.e. date of the product-location balance. Previous day's date in the daily transfer. For historical balances the date of the balance.

Inventory location code (i.e. code for affected store, warehouse, etc.)

Item code (code for finished product or stock keeping unit)

Supported balance types are: BALANCE = Current physical stock level

Physical balance quantity in the location in base unit of measure (e.g. SKU, stock unit, piece, smallest possible unit). The quantity should define the stock that is available to be sold or consumed, ie. unrestricted use. It should include also quantity that may be reserved already to sales or consumption, those reservations should be sent as Open sales orders. Balance quantity should be always positive.

Value of the whole transaction in the location's currency (e.g. €, £, $). Value should always be positive as transaction quantity determines the direction of the transaction. Usually based on purchase price. Negative values are automatically converted to the positive absolute value of the inserted value.

If balances are sent multiple times during the day, indicates the time of the balance information, i.e. when it was fetched from source system