This is an old revision of the document!
Using DI Server or DI API to post an inventory transfer transaction in SAP Business One requires some additional configuration as described in this page.
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
“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.