Importing/Exporting - Purchases Fields

Purchases Fields - Item

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

Field

Description and Character Limits

^Co./Last Name

When importing, must match a preexisting card in the AccountEdge company file. If a company name (no first name), 50 characters, alphanumeric. If a last name, 30 characters, alphanumeric.
NOTE:  To match a preexisting card designated as "Individual," MYOB AccountEdge requires both the last and first names.

First Name

20 characters, alphanumeric.

Addr 1
  - Line 1
  - Line 2
  - Line 3
  - Line 4

Total Address field (lines 1 through 4) cannot exceed 255 characters, alphanumeric.

Purchase #

8 characters, alphanumeric

Date

10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.

Vendor Invoice #

20 characters, alphanumeric

Ship Via

20 characters, alphanumeric

Delivery Status

P=To be Printed
E=To be Emailed
B=To be Printed & Emailed
A=Already Printed or Sent
If field is blank, it will be set to P=To be Printed

*Item Number

30 characters, alphanumeric. Must match an preexisting item in your MYOB AccountEdge company file.

Quantity

10 characters, numeric - allows 3 decimal places and decimal point.

Description

255 characters, alphanumeric

Price

11 characters, numeric, including 3 decimal places

Discount

10 characters, numeric, including 2 decimal places

Total

15 characters (including 2 decimal places) from Dollars amount field. If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals.
NOTE:  Importing and exporting currency amounts.

Job

15 characters, alphanumeric. When importing, must match a preexisting job number in the MYOB AccountEdge company file.

Comment

255 characters, alphanumeric

Journal Memo

255 characters, alphanumeric

Shipping Date

10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.

Tax Code

3 characters, alphanumeric. When importing, must match a preexisting tax code in the Tax Code List.

Tax Amount

15 characters (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals.
NOTE:  Importing and exporting currency amounts

Import Duty Amount

15 characters (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals.
NOTE:  Importing and exporting currency amounts

Freight Amount

15 characters (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals.
NOTE:  Importing and exporting currency amounts

Freight Tax Code

3 characters, alphanumeric. Must match a preexisting tax code in the Tax Code List.

Freight Tax Amount

15 characters (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals.
NOTE:  Importing and exporting currency amounts

Freight Import Duty Amount

15 characters (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals.
NOTE:  Importing and exporting currency amounts

Purchase Status

1 character. Letter "O" indicates the purchase is an order; Q indicates the purchase is a quote. Any other character or no character indicates the purchase is a bill.

Currency Code

3 characters, alphabetical; one code per sale/purchase. When importing, must match a preexisting currency code in the Currency List. Must match customer/vendor currency code.

Exchange Rate

11 digits, including 6 decimal places. If blank, current exchange rate substituted.

Terms
  - Payment is Due

1 character, numeric. Use one of these codes to indicate when payment is due:
0 - COD
1 - Prepaid
2 - In a Given # of Days
3 - On a Day of the Month
4 - # of days after EOM
5 - Day of Month after EOM

  - Discount Days

3 characters, numeric; based on Payment is Due code:

If code 0, 1, 2 or 4 indicates when payment is due, use a number of days from 0-999.

If code 3 or 5 indicates when payment is due, use a date from 1-31. (EOM=31)

  - Balance Due Days

3 characters, numeric; based on Payment is Due code:

If code 0, 1, 2 or 4 indicates when payment is due, use a number of days from 0-999.

If code 3 or 5 indicates when payment is due, use a date from 1-31. (EOM=31)

   - % Discount

2 numeric characters to the left of a decimal point and 2 numeric characters to the right of the decimal point (example: 00.10).

Amount Paid

15 characters (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals.
NOTE:  Importing and exporting currency amounts

Category

15 characters, alphanumeric

Order

10 characters, numeric - allows 3 decimal places and decimal point.

Received

10 characters, numeric - allows 3 decimal places and decimal point.

Billed

10 characters, numeric - allows 3 decimal places and decimal point. When importing, billed quantity cannot exceed the Received quantity or the Ordered quantity.

Location ID

10 characters, alphanumeric.

Note: Importing locations on inventory adjustments, sales or purchases

^Card ID

15 characters, alphanumeric. Must be a unique ID.

Note: When you select Card ID in the Identify Card by field, *None is equivalent to no entry in the field.

^Record ID

10 numeric characters

The Record ID is an internal number within the MYOB AccountEdge company file.

^Conditional Fields: When importing, one or more fields must contain valid entries for matching fields in the company file.

*Required Field: When importing, this field must have a valid matching import field.

Field	Description and Character Limits
^Co./Last Name	When importing, must match a preexisting card in the AccountEdge company file. If a company name (no first name), 50 characters, alphanumeric. If a last name, 30 characters, alphanumeric. NOTE: To match a preexisting card designated as "Individual," MYOB AccountEdge requires both the last and first names.
First Name	20 characters, alphanumeric.
Addr 1 - Line 1 - Line 2 - Line 3 - Line 4	Total Address field (lines 1 through 4) cannot exceed 255 characters, alphanumeric.
Purchase #	8 characters, alphanumeric
Date	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.
Vendor Invoice #	20 characters, alphanumeric
Ship Via	20 characters, alphanumeric
Delivery Status	P=To be Printed E=To be Emailed B=To be Printed & Emailed A=Already Printed or Sent If field is blank, it will be set to P=To be Printed
*Item Number	30 characters, alphanumeric. Must match an preexisting item in your MYOB AccountEdge company file.
Quantity	10 characters, numeric - allows 3 decimal places and decimal point.
Description	255 characters, alphanumeric
Price	11 characters, numeric, including 3 decimal places
Discount	10 characters, numeric, including 2 decimal places
Total	15 characters (including 2 decimal places) from Dollars amount field. If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals. *NOTE:* Importing and exporting currency amounts.
Job	15 characters, alphanumeric. When importing, must match a preexisting job number in the MYOB AccountEdge company file.
Comment	255 characters, alphanumeric
Journal Memo	255 characters, alphanumeric
Shipping Date	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.
Tax Code	3 characters, alphanumeric. When importing, must match a preexisting tax code in the Tax Code List.
Tax Amount	15 characters (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals. *NOTE:* Importing and exporting currency amounts
Import Duty Amount	15 characters (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals. *NOTE:* Importing and exporting currency amounts
Freight Amount	15 characters (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals. *NOTE:* Importing and exporting currency amounts
Freight Tax Code	3 characters, alphanumeric. Must match a preexisting tax code in the Tax Code List.
Freight Tax Amount	15 characters (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals. *NOTE:* Importing and exporting currency amounts
Freight Import Duty Amount	15 characters (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals. *NOTE:* Importing and exporting currency amounts
Purchase Status	1 character. Letter "O" indicates the purchase is an order; Q indicates the purchase is a quote. Any other character or no character indicates the purchase is a bill.
Currency Code	3 characters, alphabetical; one code per sale/purchase. When importing, must match a preexisting currency code in the Currency List. Must match customer/vendor currency code.
Exchange Rate	11 digits, including 6 decimal places. If blank, current exchange rate substituted.
Terms - Payment is Due	1 character, numeric. Use one of these codes to indicate when payment is due: 0 - COD 1 - Prepaid 2 - In a Given # of Days 3 - On a Day of the Month 4 - # of days after EOM 5 - Day of Month after EOM
- Discount Days	3 characters, numeric; based on Payment is Due code: If code 0, 1, 2 or 4 indicates when payment is due, use a number of days from 0-999. If code 3 or 5 indicates when payment is due, use a date from 1-31. (EOM=31)
- Balance Due Days	3 characters, numeric; based on Payment is Due code: If code 0, 1, 2 or 4 indicates when payment is due, use a number of days from 0-999. If code 3 or 5 indicates when payment is due, use a date from 1-31. (EOM=31)
- % Discount	2 numeric characters to the left of a decimal point and 2 numeric characters to the right of the decimal point (example: 00.10).
Amount Paid	15 characters (including 2 decimal places). If more than 2 decimals, MYOB AccountEdge rounds to 2 decimals. *NOTE:* Importing and exporting currency amounts
Category	15 characters, alphanumeric
Order	10 characters, numeric - allows 3 decimal places and decimal point.
Received	10 characters, numeric - allows 3 decimal places and decimal point.
Billed	10 characters, numeric - allows 3 decimal places and decimal point. When importing, billed quantity cannot exceed the Received quantity or the Ordered quantity.
Location ID	10 characters, alphanumeric. Note: Importing locations on inventory adjustments, sales or purchases
^Card ID	15 characters, alphanumeric. Must be a unique ID. Note: When you select Card ID in the Identify Card by field, *None is equivalent to no entry in the field.
^Record ID	10 numeric characters The Record ID is an internal number within the MYOB AccountEdge company file.