Inventory Adjustment

Internal ID: inventoryadjustment

Supports Deleted Record Search

Fields

Internal ID	Type	nlapiSubmitField	Label	Required	Help
account	select	false	Adjustment Account	true	Select the appropriate account for inventory adjustments. Usually, this will be an expense account. For details on accounts, go to <_TABNAME=LIST_ACCOUNT_> > <_TASKCATEGORY=LIST_ACCOUNT_> > Chart of Accounts.
adjlocation	select	false	Adjustment Location	false	Select the location to associate with this adjustment transaction. Select New to enter a new location. Go to <_TABNAME=LIST_LOCATION_> > <_TASKCATEGORY=LIST_LOCATION_> > Locations for information on existing locations. Note: You can select locations for items on the adjustments subtab below.
class	select	false	Class	false	Select a class to associate with this transaction. To create a new class, select New. For details on existing classes, go to <_TABNAME=LIST_CLASS_> > <_TASKCATEGORY=LIST_CLASS_> > Classes.
createddate	datetime	false		false
customer	select	false	Customer	false	If this inventory adjustment is a project-related cost but is not specifically billed as a line item, select the appropriate customer or project. For example, when a caterer bills his or her customers a per person rate for a beer and wine bar, they can then enter an inventory adjustment to account for the actual number of bottles consumed.
customform	select	false	Custom Form	true
department	select	false	Department	false	Select a department to associate with this transaction. To create a new department, select New. For details on existing departments, go to <_TABNAME=LIST_DEPARTMENT_> > <_TASKCATEGORY=LIST_DEPARTMENT_> > Departments.
estimatedtotalvalue	currency	false	Estimated Total Value	false	This is the total value of the change in your inventory. When you submit the adjustment, the current cost is determined from your inventory database and your adjustment totals are updated.
externalid	text	false	ExternalId	false
lastmodifieddate	datetime	false		false
memo	text	true	Memo	false
postingperiod	select	false	Posting Period	false	Select the period you want to post this inventory adjustment to. If a period is closed, you cannot post to that period.
subsidiary	select	false	Subsidiary	true
trandate	date	false	Date	true	Today's date autofills as the date of this inventory adjustment. You can enter or choose another date.
tranid	text	false	Reference #	false	Enter an optional reference number for this inventory adjustment. Reference Numbers for inventory adjustments do not have to be consecutive. You can enter a maximum of 45 characters in this field.

Sublists

accountingbookdetail - Accounting Books

Internal ID	Type	Label	Required
accountingbook	select	Secondary Book	false
exchangerate	currency2	Exchange Rate	true

inventory - Adjustments

Internal ID	Type	Label	Required
adjustqtyby	float	Adjust Qty. By	true
class	select	Class	false
costingmethod	text		false
currency	text		false
currentvalue	currency	Current Value	false
department	select	Department	false
description	text	Description	false
exchangerate	float		false
inventorydetail	summary	Inventory Detail	false
item	select	Item	true
label	label	Exchange Rate	false
labelcurrency	label	Currency	false
labelfxunitcost	label	Unit Cost in Foreign Currency	false
line	text		false
location	select	Location	true
memo	text	Memo	false
newquantity	float	New Quantity	false
quantityonhand	float	Qty. On Hand	false
unitcost	currency2	Est. Unit Cost	false
units	select	Units	false

Tabs

Name	Label
adjustments	Adjustments
custom	Custom
history	History
workflow	Workflow

Search Data

Transaction