Importing and exporting

Inventory Adjustments Fields

View a list of all types of fields: Field descriptions for importing and exporting

Field	Description and Character Limits
Journal Number	8 characters, alphanumeric
Date	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as separator between months, days and years.
Memo	255 characters, alphanumeric.
*Item Number	30 characters, alphanumeric. Must be a valid, preexisting MYOB Premier Accounting item number that is marked I Inventory.
Location	10 characters, alphanumeric. Note: Importing locations on inventory adjustments, sales or purchases
Quantity	11 characters plus 3 decimal places. If more than 3 decimal places, MYOB Premier Accounting rounds to 3 decimal places.
Unit Cost	11 characters plus 4 decimal places. If more than 4 decimal places, MYOB Premier Accounting rounds to 4 decimal places.
*Amount	13 characters plus 2 decimal places. If more than 2 decimal places, MYOB Premier Accounting rounds to 2 decimal places. NOTE:  Importing and exporting currency amounts
Account #	5 characters, numeric. Must be valid, preexisting MYOB Premier Accounting account number. May have an optional non-numeric separator between the first digit and the last 4 digits (example:  1-1234).
Job	15 characters, alphanumeric. Must match preexisting job number in the Premier Accounting company file.
Allocation Memo	255 characters, alphanumeric
Category	15 characters, alphanumeric

*Required Field:  When importing, these fields must have valid matching import fields.