Adjustment
Return, update, create and delete inventory adjustment journals
Date Released: Dec 2013 Date Updated: Jan 2022
Please note: While accessibility via the API is available to both AccountRight and new Essentials files. Not all features will be displayed in Product for new Essentials or the AccountRight Browser.
The elements list below details information for Adjustment. To view the descriptions for the elements you can either hover any attribute to reveal details or click here to show all details inline.
Items shown with are required when posting or puting data
Items shown with are read-only elements
Attribute Details
- UID GUID (36)
- Unique guid identifier created for an inventory adjustment journal.
ONLY required for updating an existing inventory adjustment journal.
NOT required when creating a new inventory adjustment journal. - InventoryJournalNumberString (13)
- Inventory journal number, if left null when posting a number will automatically be assigned and incremented based upon last recorded
- DateDateTime
- Transaction date entry, format YYYY-MM-DD HH:MM:SS { 'Date': '2013-12-04 13:33:02' }
- IsYearEndAdjustment Boolean
- True indicates the transaction is a YearEndAdjustment
False indicates the transaction is not a YearEndAdjustment - Memo String (255)
- Memo text assigned to the inventory journal adjustment.
- Lines []
- An array of line item information
-
- RowIDInteger
- Sequence of the entry within the inventory journal set.
REQUIRED only when passing the RowVersion for updating an existing inventory adjustment line. - QuantityDecimal (13.6)
- The quantity of items to be adjusted.
- UnitCostDecimal (13.6)
- Unit cost assigned to the item/items, if left blank on POST will default to AverageCost.
- AmountDecimal (13.6)
- Dollar amount assigned to the item (Quantity * UnitCost = Amount).
- Item
- The following set of information pulls through details for an Item
- UIDGuid (36)
- Foreign Key: Unique identifier for item in the form of a guid, Note: same as the UID above.
- NumberString (30)
- Number assigned to the item.
- NameString (30)
- Name assigned to the item.
- URIString
- Uniform resource identifier associated with the item object.
- Account
- The following set of information pulls through the details for an account
-
- UIDGUID (36)
- Foreign Key: Unique guid identifier belonging to the account for the item adjustment
- Name String (60)
- Account name belonging to the account record
- DisplayID String (6)
- Account code format includes separator ie 1-1100 { 'DisplayID': '5-1100' }
- URI String
- Uniform resource identifier associated with the account object
- Job
- The following set of information pulls through details for jobs
-
- UID GUID (36)
- Foreign Key: Unique guid identifier belonging to the job for this line of the inventory journal entry
- Number String (30)
- Number assigned to the job
- Name String (30)
- Name assigned to the job
- URI String
- Uniform resource identifier associated with the job object
- MemoString (1000)
- Memo text describing the transaction line,
- Location
- The following set of information pulls through details for the item associated location./li>
- UIDGuid (36)
- Foreign Key: Unique identifier for location in the form of a guid.
- IdentifierString (10)
- Identifier assigned to the location.
- NameString (30)
- Name assigned to the location.
- URIString
- Uniform resource identifier associated with the location object.
- RowVersion String
- ONLY required on PUT for updating an existing inventory adjustment line.
NOT required when creating a new inventory adjustment journal.
- Category
- The following outlines category information for the inventory adjustment journal.
-
- UID GUID (36)
- Foreign Key: Unique guid identifier belonging to the category assigned to the inventory journal.
- Name String (30)
- Name of the category
- DisplayID String (15)
- Display id for the category
- URI String
- Uniform resource identifier associated with the category object
- URI String
- Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web
- 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.
ONLY required for updating an existing inventory adjustment journal.
NOT required when creating a new inventory adjustment journal.
Paging: default page size is set to 400 with a maximum of 1000 results.
Example json GET response
- {
- "UID" : "10f623a6-1638-4970-afd5-0394191bf015",
- "InventoryJournalNumber" : "IJ000001",
- "Date" : "2013-12-10T19:00:59.043",
- "IsYearEndAdjustment" : false,
- "Memo" : "Inventory Adjustment; Item 120",
- "Lines" : [
- "RowID" : 69,
- "Quantity" : 5,
- "UnitCost" : 45.392406,
- "Amount" : 226.96,
- "Item" : {
- "UID" : "d5ab0fd1-3bf4-4230-bbaf-90b26ea9afda",
- "Number" : "120",
- "Name" : "Cooler Filter Large",
- "URI" : "{cf_uri}/Inventory/Item/d5ab0fd1-3bf4-4230-bbaf-90b26ea9afda"
- },
- "Account" : {
- "UID" : "2e653a1a-dafe-4e81-a553-f9a56ed3d105",
- "Name" : "Inventory Adjustment",
- "DisplayID" : "5-2200",
- "URI" : "{cf_uri}/GeneralLedger/Account/2e653a1a-dafe-4e81-a553-f9a56ed3d105"
- },
- "Job" : null,
- "Memo" : "IJ Item 120",
- "Location" : {
- "UID" : "04ad68a3-91f5-4739-8b83-13f86ecd2e33",
- "Identifier" : "Location1",
- "Name" : "Primary Location",
- "URI" : "{cf_uri}"
- },
- "RowVersion" : "-4065061613655293952"
- }
- ],
- "Category" : {
- "UID" : "b211a2a3-0be9-477c-940e-1c8bac139cf1",
- "Name" : "Melbourne",
- "DisplayID" : "CAT101",
- "URI" : "{cf_uri}/GeneralLedger/Category/b211a2a3-0be9-477c-940e-1c8bac139cf1"
- },
- "URI" : "{cf_uri}/Inventory/Adjustment/10f623a6-1638-4970-afd5-0394191bf015",
- "RowVersion" : "-4281234395769077760"
- }