Nic at 23:14, 2 April 2025

2025-04-02T23:14:25Z

← Older revision		Revision as of 18:14, 2 April 2025
Line 7:		Line 7:

	The following fields are available for the Items endpoint.		The following fields are available for the Items endpoint.

			;DataFile
			:A [[Field Type: Record\|record field]] that provides the [[Field: DataFile\|DataFile]] associated with the data.

	;UID		;UID

Nic at 11:54, 25 May 2022

2022-05-25T11:54:00Z

@@ Line 104: / Line 104: @@
 ;DefaultReceiveLocation
 :A [[Field Type: Record|record field]] provides the default [[MYOB Field: Locations|location]] for purchases.
 ;LastModified
@@ Line 197: / Line 201: @@
 ;QuantityOnHand
 :A [[Field Type: Decimal|decimal field]] that provides the quantity on hand total at this location.

Nic at 05:45, 22 September 2021

2021-09-22T05:45:57Z

← Older revision		Revision as of 00:45, 22 September 2021
Line 1:		Line 1:
	== Overview ==		== Overview ==

	The MYOB '''Items''' [[Endpoints\|endpoint]] allows you to access the list of inventory items within MYOB.		The MYOB '''Items''' [[MYOB Endpoints\|endpoint]] allows you to access the list of inventory items within MYOB.


	== Fields ==		== Fields ==
Line 216:		Line 217:

	:[[MYOB Endpoint: ItemPriceMatrix\|ItemPriceMatrix]]		:[[MYOB Endpoint: ItemPriceMatrix\|ItemPriceMatrix]]


			== Related Topics ==

			:[[MYOB Models]]
			:[[MYOB Endpoints]]

Nic: Created page with "== Overview == The MYOB '''Items''' endpoint allows you to access the list of inventory items within MYOB. == Fields == The following fields are available for..."

2021-09-16T06:25:38Z

Created page with "== Overview == The MYOB '''Items''' endpoint allows you to access the list of inventory items within MYOB. == Fields == The following fields are available for..."

New page

== Overview ==

The MYOB '''Items''' [[Endpoints|endpoint]] allows you to access the list of inventory items within MYOB.

== Fields ==

The following fields are available for the Items endpoint.

;UID
:A [[Field Type: GUID|GUID field]] representing the internal id of an item. This field can be used to link to other endpoints.

;Number
:A [[Field Type: Text|text field]] that provides the item number.

;Name
:A [[Field Type: Text|text field]] that provides the item name.

;IsActive
:A [[Field Type: Boolean|true/false value]] that indicates if the item is active and can be used on new transactions.

;Description
:A [[Field Type: Text|text field]] that provides the item description.

;UseDescription
:A [[Field Type: Boolean|true/false value]] that indicates if the description is displayed on the invoice instead of the item number.

;CustomList1
:A [[Field Type: Record|record field]] that stores the first [[MYOB Field: CustomList|custom list value]] selected for this item.

;CustomList2
:A [[Field Type: Record|record field]] that stores the second [[MYOB Field: CustomList|custom list value]] selected for this item.

;CustomList3
:A [[Field Type: Record|record field]] that stores the third [[MYOB Field: CustomList|custom list value]] selected for this item.

;CustomField1
:A [[Field Type: Record|record field]] that stores the first [[MYOB Field: CustomField|custom field value]] entered for this item.

;CustomField2
:A [[Field Type: Record|record field]] that stores the second [[MYOB Field: CustomField|custom field value]] entered for this item.

;CustomField3
:A [[Field Type: Record|record field]] that stores the third [[MYOB Field: CustomField|custom field value]] entered for this item.

;QuantityOnHand
:A [[Field Type: Decimal|decimal field]] that provides the quantity on hand total across all locations.

;QuantityCommitted
:A [[Field Type: Decimal|decimal field]] that provides the quantity commited (on pending sales order).

;QuantityOnOrder
:A [[Field Type: Decimal|decimal field]] that provides the quantity on order with the supplier.

;QuantityAvailable
:A [[Field Type: Decimal|decimal field]] that provides the total quantity available.
:This is calculated as the QuantityOnHand ''plus'' QuantityOnOrder ''less'' QuantityCommitted.

;AverageCost
:A [[Field Type: Decimal|decimal field]] that provides the average cost of the items on hand.

;CurrentValue
:A [[Field Type: Decimal|decimal field]] that provides the total value of the items on hand.

;BaseSellingPrice
:A [[Field Type: Decimal|decimal field]] that provides the base selling price of the item.

;IsBought
:A [[Field Type: Boolean|true/false value]] that indicates if the item can be purchased.

;IsSold
:A [[Field Type: Boolean|true/false value]] that indicates if the item can be sold.

;IsInventoried
:A [[Field Type: Boolean|true/false value]] that indicates if the item is inventoried.

;ExpenseAccount
:A [[Field Type: Record|record field]] that gives access to the [[MYOB Field: Accounts|account]] used on purchases.

;CostOfSalesAccount
:A [[Field Type: Record|record field]] that gives access to the [[MYOB Field: Accounts|account]] used as cost of sales.

;IncomeAccount
:A [[Field Type: Record|record field]] that gives access to the [[MYOB Field: Accounts|account]] used on sales.

;AssetAccount
:A [[Field Type: Record|record field]] that gives access to the [[MYOB Field: Accounts|account]] used to track inventory.

;BuyingDetails
:A [[Field Type: Record|record field]] provides additional details for items that can be bought.
:See [[#BuyingDetails Fields|BuyingDetails Fields]] for more information.

;SellingDetails
:A [[Field Type: Record|record field]] provides additional details for items that can be sold.
:See [[#SellingDetails Fields|SellingDetails Fields]] for more information.

;LocationDetails
:A [[Field Type: Table|table field]] provides additional details for companies that use multiple locations.
:See [[#LocationDetails Fields|LocationDetails Fields]] for more information.

;DefaultSellLocation
:A [[Field Type: Record|record field]] provides the default [[MYOB Field: Locations|location]] for sales.

;DefaultReceiveLocation
:A [[Field Type: Record|record field]] provides the default [[MYOB Field: Locations|location]] for purchases.

;LastModified
:A [[Field Type: DateTimeOffset|date time field]] that stores the last date and time this item was modified.

;PhotoURI
:A [[Field Type: Text|text field]] that stores a URL that can be used to access the photo associated with this item.

;RowVersion
:A [[Field Type: Row Version|row version field]].

== BuyingDetails Fields ==

The [[#Fields|BuyingDetails]] field contains the following sub-fields.

;LastPurchasePrice
:A [[Field Type: Decimal|decimal field]] that provides the last purchase price of the item.

;StandardCost
:A [[Field Type: Decimal|decimal field]] that provides the standard cost of the item as entered in MYOB.

;BuyingUnitOfMeasure
:A [[Field Type: Text|text field]] that indicates the unit of measure used on purchases.

;ItemsPerBuyingUnit
:A [[Field Type: Decimal|decimal field]] that provides the number of items per buying unit.

;TaxCode
:A [[Field Type: Record|record field]] provides the [[MYOB Field: TaxCodes|default tax code]] when purchasing this item.

;RestockingInformation
:A [[Field Type: Record|record field]] provides additional details for items that are inventoried.
:See [[#BuyingDetails.RestockingInformation Fields|BuyingDetails.RestockingInformation Fields]] for more information.

== BuyingDetails.RestockingInformation Fields ==

The [[#BuyingDetails Fields|BuyingDetails.RestockingInformation]] field contains the following sub-fields.

;MinimumLevelForRestockingAlert
:A [[Field Type: Decimal|decimal field]] that provides the minimum level quantity of items when MYOB will raise an alert.

;Supplier
:A [[Field Type: Record|record field]] provides the [[MYOB Field: Cards|default Supplier]] when purchasing this item.

;SupplierItemNumber
:A [[Field Type: Text|text field]] that indicates the item number used by the supplier.

;DefaultOrderQuantity
:A [[Field Type: Decimal|decimal field]] that provides the default quantity that will be ordered.

== SellingDetails Fields ==

The [[#Fields|SellingDetails]] field contains the following sub-fields.

;BaseSellingPrice
:A [[Field Type: Decimal|decimal field]] that provides the base selling price of the item for one unit.

;SellingUnitOfMeasure
:A [[Field Type: Text|text field]] that indicates the unit of measure used on sales.

;ItemsPerSellingUnit
:A [[Field Type: Decimal|decimal field]] that provides the number of items per selling unit.

;TaxCode
:A [[Field Type: Record|record field]] provides the [[MYOB Field: TaxCodes|default tax code]] when selling this item.

;IsTaxInclusive
:A [[Field Type: Boolean|true/false value]] that indicates if the '''BaseSellingPrice''' is tax inclusive.

;CalculateSalesTaxOn
:A [[Field Type: Text|text field]] that indicates if sales tax can be calculated.
:Possible values are:
:* '''ActualSellingPrice'''
:* '''BaseSellingPrice'''
:* '''LevelA'''
:* '''LevelB'''
:* '''LevelC'''
:* '''LevelD'''
:* '''LevelE'''
:* '''LevelF'''

== LocationDetails Fields ==

The [[#Fields|LocationDetails]] field contains the following sub-fields.

;Location
:A [[Field Type: Record|record field]] provides the [[MYOB Field: Locations|location]] for the associated quantity on hand.

;QuantityOnHand
:A [[Field Type: Decimal|decimal field]] that provides the quantity on hand total at this location.

== MYOB API ==

For a detailed run through of the endpoint, you can see the [https://developer.myob.com/api/accountright/v2/inventory/item/ MYOB API].

== Related Fields ==

:[[MYOB Field: Accounts|Accounts]]
:[[MYOB Field: Cards|Cards]]
:[[MYOB Field: CustomList|CustomList]]
:[[MYOB Field: CustomField|CustomField]]
:[[MYOB Field: Locations|Locations]]
:[[MYOB Field: TaxCodes|TaxCodes]]

== Related Endpoints==

:[[MYOB Endpoint: ItemPriceMatrix|ItemPriceMatrix]]

MYOB Endpoint: Items - Revision history

Nic at 23:14, 2 April 2025

Nic at 11:54, 25 May 2022

Nic at 05:45, 22 September 2021

Nic: Created page with "== Overview == The MYOB '''Items''' endpoint allows you to access the list of inventory items within MYOB. == Fields == The following fields are available for..."