bw2:inventory_transfers_with_bins

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

bw2:inventory_transfers_with_bins [2020/12/15 12:25]
akoehler created
bw2:inventory_transfers_with_bins [2021/02/11 09:59] (current)
akoehler
Line 1: Line 1:
 ====== SAP Business One Inventory Transfer with Bins ====== ====== 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 in this page.+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 ===== ===== Basic Approach =====
   - A record for each From/To combination is needed, including cases where the From and To warehouses are different.   - 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.     - 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.     - The total quantity of the “to” bins must equal the “from” quantity.
-  - A value must be provided to use as a break point at the “Stock Transfer” document level. +  - 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.+    - If using Versago as the sourcethis would be the vgoRecNum value.
     - This value does not need to be mapped but could be used as a comment.     - 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 break point at the “Stock Transfer Lines” level. +  - 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 transaction.+    - 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.     - 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 occur for each record passed into the processing.+  - The Bin Allocations transaction occurs for each record passed into the processing.
  
 ==== Sample (Simple) Input Query ==== ==== Sample (Simple) Input Query ====
Line 29: Line 29:
 ==== Mapping Sample Images ==== ==== Mapping Sample Images ====
  
-{{:bw:sbo_invxfer_bins1.png?400|}}+{{ :bw2:bizweaverbintransfer1.png |}}
  
 “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. “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.+If the From and To warehouses are the samethey can be mapped here instead of at the Stock Transfer Lines level.
  
-{{:bw:sbo_invxfer_bins2.png?400|}}+{{ :bw2:bizweaverbintransfer2.png |}}
  
 “BaseLineNum” in this example is simply a value used for testing. See comments in the Basic Approach section above. “BaseLineNum” in this example is simply a value used for testing. See comments in the Basic Approach section above.
Line 41: Line 41:
 From and To warehouses do not need to be mapped here is mapped at the Stock Transfer level. From and To warehouses do not need to be mapped here is mapped at the Stock Transfer level.
  
-{{:bw:sbo_invxfer_bins3.png?400|}}+{{ :bw2:bizweaverbintransfer3.png |}}
  
 “BinAbsEntry” can be obtained by using the following SQL query. “BinAbsEntry” can be obtained by using the following SQL query.
Line 49: Line 49:
 </code> </code>
  
-against the target company database.+Against the target company database.
  
 ===== Other Notes ===== ===== Other Notes =====
bw2/inventory_transfers_with_bins.1608053153.txt.gz · Last modified: 2020/12/15 12:25 by akoehler