SAP Business One Inventory Transfer with Bins
Using DI Server or DI API to post an inventory transfer transaction in SAP Business One requires some additional configuration as described on this page.
Basic Approach
A record for each From/To combination is needed, including cases where the From and To warehouses are different.
A From/To combination could be one “from” bin and multiple “to” bins.
The total quantity of the “to” bins must equal the “from” quantity.
A value must be provided to use as a breakpoint at the “Stock Transfer” document level.
If using Versago as the source, this would be the vgoRecNum value.
This value does not need to be mapped but could be used as a comment.
A unique value must be provided to use as a breakpoint at the “Stock Transfer Lines” level.
This value is unique for each set of bin movement transactions.
This value could be the ItemCode if that is unique enough, or you may need to assign your own break value.
The Bin Allocations transaction occurs for each record passed into the processing.
SELECT
0 AS [DocNum], 'A00001' AS [ItemCode], 1 AS [Quantity],2 AS [BinAbs],'05' AS [Warehouse], 2 AS [BinActType], 1 AS [BaseLineNum]
UNION ALL
SELECT
0 AS [DocNum], 'A00001' AS [ItemCode], 1 AS [Quantity],3 AS [BinAbs],'05' AS [Warehouse], 1 AS [BinActType], 1 AS [BaseLineNum]
BinActType 2 = From Bin
BinActType 1 = To Bin
Mapping Sample Images
“DocNum’’ is simply a value used for testing. See comments in the Basic Approach section above. Other values such as Comments can be mapped as needed.
If the From and To warehouses are the same, they can be mapped here instead of at the Stock Transfer Lines level.
“BaseLineNum” in this example is simply a value used for testing. See comments in the Basic Approach section above.
From and To warehouses do not need to be mapped here is mapped at the Stock Transfer level.
“BinAbsEntry” can be obtained by using the following SQL query.
SELECT * FROM OBIN
Against the target company database.
Other Notes
The target bin should either not have any restrictions, or the source item must match any restrictions that are in place.
The target bin should not be identified as a Receiving bin.