This shows you the differences between two versions of the page.
|
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 | + | Using DI Server or DI API to post an inventory transfer transaction in SAP Business One requires some additional configuration as described |
| ===== 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 |
| - | - If using Versago as the source this would be the vgoRecNum value. | + | - 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. | - This value does not need to be mapped but could be used as a comment. | ||
| - | - A unique value must be provided to a use as a break point at the “Stock Transfer Lines” level. | + | - A unique value must be provided to use as a breakpoint |
| - | - This value is unique for each set of bin movement | + | - This value is unique for each set of bin movement |
| - 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 | + | - The Bin Allocations transaction |
| ==== 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 same, they 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: | ||
| </ | </ | ||
| - | against | + | Against |
| ===== Other Notes ===== | ===== Other Notes ===== | ||