whsinfo (^1) is a child object of the Items object that represents the items in the warehouse. This object is part of the Inventory and Production module. This object enables you to add an item to the warehouse.
Example: Lock an item warehouse
// Row from OWHS (you must read it before
setvar=my_row=11
// from item
setvar=my_itemcode=FP
declare=myitem=ue_api_sbo
myitem=getbusinessobject=oitems
myitem=getbykey=<my_itemcode>
myitem=whsinfo=SetCurrentLine=<my_row>
myitem=whsinfo=locked=Y
myitem=update
destroy=myitem
Example: Add warehouse to an item
setvar=my_itemcode=FP
declare=myitem=ue_api_sbo
myitem=getbusinessobject=oitems
myitem=getbykey=<my_itemcode>
myitem=whsinfo=warehousecode=01
myitem=whsinfo=add
myitem=whsinfo=whscode=02
Source table: OITW.
Public Methods
Add |
Adds a record to the object table in SAP Business One company database. |
SetCurrentLine |
Sets the active row to a specified row number. |
Committed |
Returns the quantity of items committed to customers. |
|
CostAccount |
Sets or returns the cost-of-sale of an item. Length: 15 characters. |
|
CostInflationAccount |
Sets or returns this warehouse G/L decrease account. (field name: DecresGlAc). Length: 15 characters. |
|
CostInflationOffsetAccount |
Sets or returns this warehouse cost inflation account. (field name: CostRvlAct). Length: 15 characters. |
|
Count |
Returns the total rows in the ItemWarehouseInfo object. |
|
Counted |
Returns the current number of the counted items in stock. |
|
CountedQuantity |
Sets or returns the counted inventory quantity. |
|
DecreasingAccount |
Sets or returns the inventory decreasing. Length: 15 characters. |
|
EUExpensesAccount |
Sets or returns the total expenses inside the European Union. Length: 15 characters. |
|
EUPurchaseCreditAcc |
Sets or returns the G/L account associated to the EU Purchase Credit Account. (field name: APCMEUAct). Length: 15 characters. |
|
EURevenuesAccount |
Sets or returns the total revenue inside the European Union. Length: 15 characters. |
|
ExchangeRateDifferencesAcct |
Sets or returns the G/L account associated to the Exchange Rate Differences Account. (field name: ExchangeAc). Length: 15 characters. |
|
ExemptedCredits |
Sets or returns the G/L account associated to the Tax Exempt Credits account. (field name: ARCMExpAct). Length: 15 characters. |
|
ExemptIncomeAcc |
Sets or returns the exempt revenue. Length: 15 characters. |
|
ExpenseClearingAct |
Sets or returns the G/L account associated with Expenses clearing Account. (field name: ExpClrAct). Length: 15 characters. |
|
ExpenseOffsettingAccount |
Sets or returns the G/L account associated to the Expense Offset Account. (field name: ExpOfstAct). Length: 15 characters. This is a Foreign Key to the ChartOfAccounts Object. |
|
ExpensesAccount |
Sets or returns the expenses account. Length: 15 characters. |
|
ForeignExpensAcc |
Sets or returns the total expenses outside the European Union. Length: 15 characters. |
|
ForeignPurchaseCreditAcc |
Sets or returns the G/L account associated to the Foreign Purchase Credit Account. (field name: APCMFrnAct). Length: 15 characters. |
|
ForeignRevenueAcc |
Sets or returns the total revenue outside the European Union. Length: 15 characters. |
|
GLDecreaseAcct |
Sets or returns this warehouse G/L decrease account. (field name: DecresGlAc). Length: 15 characters. |
|
GLIncreaseAcct |
Sets or returns this warehouse PA return account. (field name: PAReturnAc). Length: 15 characters. |
|
GoodsClearingAcct |
Sets or returns the G/L account associated to the Goods Clearing Account. (field name: BalanceAcc). Length: 15 characters. |
|
IncreasingAccount |
Sets or returns the inventory increasing. Length: 15 characters. |
|
InStock |
Returns the items quantity in the warehouse. |
|
InventoryAccount |
Sets or returns the inventory account. Length: 15 characters. |
|
ItemCycleCount |
Returns the ItemCycleCount object. |
|
Locked |
Sets or returns a valid value of BoYesNoEnum type that specifies whether or not the item is locked entry or exit in the warehouse. |
|
MaximalStock |
Sets or returns the maximum allowed quantity of an item in the warehouse. |
|
MinimalOrder |
Sets or returns the minimum allowed quantity of an order. |
|
MinimalStock |
Sets or returns the minimum allowed quantity of an item in the warehouse. |
|
NegativeInventoryAdjustmentAccount |
Sets or returns the G/L account associated to the Negative Inventory Adjustment. (field name: NegStckAct). Length: 15 characters. This is a Foreign Key to the ChartOfAccounts Object. |
|
Ordered |
Returns the quantity of items ordered from vendors. |
|
PAReturnAcct |
Sets or returns this warehouse PA return acct. (field name: PAReturnAc). Length: 15 characters. |
|
PriceDifferenceAcc |
Sets or returns the price difference between the invoice and the shipping document. Length: 15 characters. |
|
PurchaseAcct |
Sets or returns the G/L account associated to the Purchase Account. (field name: PurchaseAc). Length: 15 characters. |
|
PurchaseCreditAcc |
Sets or returns the G/L account associated to the Purchase Credit Account. (field name: APCMAct). Length: 15 characters. |
|
PurchaseOffsetAcct |
Sets or returns this warehouse purchase offset account. (field name: PurchOfsAc). Length: 15 characters. |
|
ReturningAccount |
Sets or returns the inventory returned to the vendor. Length: 15 characters. |
|
RevenuesAccount |
Sets or returns the total revenue. Length: 15 characters. |
|
SalesCreditAcc |
Sets or returns the G/L account associated to the Sales Credit Account. (field name: ARCMAct). Length: 15 characters. |
|
SalesCreditEUAcc |
Sets or returns the G/L account associated to the Sales Credit EU Account. (field name: ARCMEUAct). Length: 15 characters. |
|
SalesCreditForeignAcc |
Sets or returns the G/L account associated to the Sales Credit Foreign Acct. (field name: ARCMFrnAct). Length: 15 characters. |
|
ShippedGoodsAccount |
Sets or returns this warehouse Shipped Goods Account. (field name: ShpdGdsAct). Length: 15 characters. |
|
StandardAveragePrice |
Sets or returns the Item Cost. (field name: AvgPrice). |
|
StockInflationAdjustAccount |
Sets or returns this warehouse stock inflation adjust account. (field name: StokRvlAct). Length: 15 characters. |
|
StockInflationOffsetAccount |
Sets or returns this warehouse stock inflation offset account. (field name: StkOffsAct). Length: 15 characters. |
|
TransferAccount |
Sets or returns the transfer account number. Length: 15 characters. |
|
UserFields |
Returns the UserFields object. Fill "Userfield" information related with WhsInfo of Items object with BeasScript.
|
|
VarienceAccount |
Sets or returns the variance between the actual price and the standard price. Length: 15 characters. |
|
VATInRevenueAccount |
Sets or returns this warehouse VAT in revenue account. (field name: VatRevAct). Length: 15 characters. |
|
WarehouseCode |
Sets or returns the warehouse code. Mandatory property. Length: 8 characters. (field name: whscode) |
|
WasCounted |
Returns a valid value of BoYesNoEnum type that specifies whether or not the inventory was counted. |
|
WipAccount |
Sets or returns the G/L account associated to the WIP Material Account. (field name: WipAcct). Length: 15 characters. |
|
WipVarianceAccount |
Sets or returns the G/L account associated to Work In Progress (WIP) differences. That is, the account for posting differences between the value of the row material (before production) and the value of the complete product (after production). (field name: WipVarAcct). Length: 15 characters. |
(^1) Quelle: SAP Business One SDK