Skip to content

StockItem

Jump to bottom
PatrickLane edited this page Nov 17, 2014 · 1 revision

Presentation of the StockItem data structures. StockItems are used by product documents.

Order

Order members

Name Type Description Constraints
Active Boolean Get/Set the active flag on the stock item. If a stock item is inactive it will not appear anymore on any stock listing and will not be available for use in product documents.
AuthorUserID String Get the identifier of the user who created the stock item.
AverageCost Decimal Get the item average cost.
  • Cannot be negative
    		•
    ClosingStockGLAccountCode String Get/Set the GL account code to use to post the closing stock movement during invoice posting.
  • Cannot be null
  • Cannot be empty
  • Cannot be more than 50 characters
  • Must be a Posting type account
    		•
    ClosingWorkInProgressGLAccountCode String Get/Set the GL account code to post the closing work in progress stock movement to during invoice posting.
  • Cannot be null
  • Cannot be empty
  • Cannot be more than 50 characters
  • Must be a Posting type account
    		•
    CreationDate DateTime Get the date at which the stock item was created.
    DefaultLocationID String Get/Set the default location for the stock item to be delivered in or out of.
  • Cannot be more than 50 characters long
    		•
    DefaultPurchasesGLAccountCode String Get/Set the default purchases nominal account to use during invoice posting.
  • Cannot be null
  • Cannot be empty
  • Cannot be more than 50 characters
  • Must be a Posting type account
    		•
    DefaultSalesGLAccountCode String Get/Set the default GL account code to use as a nominal account during invoice posting.
  • Cannot be null
  • Cannot be empty
  • Cannot be more than 50 characters
  • Must be a Posting type account
    		•
    Description String Get/Set the stock item description.
  • Cannot be null
  • Cannot be empty
  • Cannot be more than 250 characters
    		•
    ItemGroupID String Get/Set the item group unique identifier.
  • Cannot be more than 50 characters long
    		•
    ItemPrice Decimal Get/Set the standard item price.
  • Cannot be negative
    		•
    ItemPrice2 Decimal Get/Set the item price for price category 2.
  • Cannot be negative
    		•
    ItemPrice3 Decimal Get/Set the item price for price category 3.
  • Cannot be negative
    		•
    ItemPrice4 Decimal Get/Set the item price for price category 4.
  • Cannot be negative
    		•
    ItemPrice5 Decimal Get/Set the item price for price category 5.
  • Cannot be negative
    		•
    ItemPrice6 Decimal Get/Set the item price for price category 6.
  • Cannot be negative
    		•
    ItemPrice7 Decimal Get/Set the item price for price category 7.
  • Cannot be negative
    		•
    ItemPrice8 Decimal Get/Set the item price for price category 8.
  • Cannot be negative
    		•
    ItemSubGroupID String Get/Set the item sub-group unique identifier.
  • Cannot be more than 50 characters long
    		•
    ItemTypeID String Get/Set the item type: S for Service, P for Product.
  • Cannot be null
  • Cannot be empty
    		•
    OpeningStockGLAccountCode String Get/Set the GL account code to use to post the opening stock movement during invoice posting.
  • Cannot be null
  • Cannot be empty
  • Cannot be more than 50 characters
  • Must be a Posting type account
    		•
    OpeningWorkInProgressGLAccountCode String Get/Set the work in progress account to post the stock movement to during invoice posting.
  • Cannot be null
  • Cannot be empty
  • Cannot be more than 50 characters
  • Must be a Posting type account
    		•
    LastCost Decimal Get the last cost at which the stock item was bought.
    LastPurchaseDate DateTime Get the last date at which the stock item was purchased.
    LastSoldDate DateTime Get the last date at which the stock item was sold.
    Margin Decimal Get/Set the margin that must be made on the stock item. The value is in percentage: for a 10% margin, the value would be 0.1
  • Cannot be negative
    		•
    ReOrderLevel Decimal Get/Set the re-order on hand quantity threshold below which the stock item will appear on the re-order level report.
    StockItemID String Get the stock item unique identifier.
  • Cannot be null
  • Cannot be empty
  • Cannot be more than 50 characters long
    		•
    TaxCode String Get/Set the default tax code to use with the stock item.
  • Cannot be null
  • Cannot be empty
  • Cannot be more than 50 characters long
    		•
    UniversalResourceNumber String Get/Set the stock item universal resource number.
  • Cannot be more than 50 characters long
    		•
    UpdateOnHand Boolean Get/Set a flag indicating whether the system should keep track of how many stock items are on hand at all type or should ignore the stock movements on this item. If the flag is not set, no stock postings take place on the transaction table.
    UseMarginWarning Boolean Get/Set a flag indicating whether the user will be warned when trying to sell a product at a price which leads to a margin below the Margin setup for the stock item.

    AccountsIQ System

    Clone this wiki locally