whsinfo

sap-sdk

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.

Public Properties

 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