Excel Add-In for MYOB

Build 24.0.9062

BuildLineItems

Build Lines

Columns

Name Type References Description
RowID [KEY] String Sequence of the entry within the inventory journal set.
RowVersion String Number value that changes upon a record update, can be used for change control but does does not preserve a date or a time.
AccountDisplayID String Account code format includes separator ie 1-1100
AccountName String Account name belonging to the account record
AccountUID String Unique guid identifier belonging to the account for the item adjustment
AccountURI String Uniform resource identifier associated with the account object
Amount String Dollar amount assigned to the item (Quantity * UnitCost = Amount).
ItemName String Name assigned to the item.
ItemNumber String Number assigned to the item.
ItemUID String Unique identifier for item in the form of a guid
ItemURI String Uniform resource identifier associated with the item object.
LocationName String Name assigned to the location.
LocationUID String Unique identifier for location in the form of a guid.
LocationURI String Uniform resource identifier associated with the location object
Memo String Memo text describing the transaction line
UnitCost Double Unit cost assigned to the item/items, if left blank on POST will default to AverageCost.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062