Item Sales and Purchases Fields

Item Sales and Purchases Fields

Field

Sales or Purchases

Description and Character Limits

*Co./Last Name

Both

Must match a preexisting card in your MYOB software data file. If a company name (no first name), 50 characters, alphanumeric. If a last name, 30 characters, alphanumeric. (If the card is an individual, MYOB software matches the last name followed by a comma and a space, followed by the first name.)

First Name

Both

20 characters, alphanumeric.

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

Both

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

Invoice #

Sales

8 characters, alphanumeric

Purchase Order #

Purchases

8 characters, alphanumeric

Date

Both

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

Customer PO

Sales

20 characters, alphanumeric

Vendor Invoice #

Purchases

20 characters, alphanumeric

Ship Via

Both

20 characters, alphanumeric

Already Printed

Both

1 character. Any non-blank character signifies that the invoice and purchase order is already printed or sent.

*Item Number

Both

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

Quantity

Both

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

Description

Both

255 characters, alphanumeric

Price

Both

11 characters, numeric, including 3 decimal places

Discount

Both

10 characters, numeric, including 2 decimal places

Total

Both

Dollar amount field 15 characters (including dollar signs and negative signs).

Job

Both

5 characters, alphanumeric. Must match preexisting job number in your MYOB AccountEdge data file.

Comment

Both

255 characters, alphanumeric

Journal Memo

Both

255 characters, alphanumeric

Slsmn Last Name

Sales

31 characters, alphanumeric. Must match the name of an employee card in the MYOB AccountEdge data file.

Slsmn First Name

Sales

20 characters, alphanumeric.

Shipping Date

Both

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

Tax Code

Both

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

Tax Amount

Both

15 characters, numeric, including 2 decimal places

Import Duty Amount

Purchases

15 characters, numeric, including 2 decimal places

Freight Amount

Both

15 characters, numeric, including 2 decimal places

Freight Tax Code

Both

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

Freight Tax Amount

Both

15 characters, numeric, including 2 decimal places

Freight Import Duty Amount

Purchases

15 characters, numeric, including 2 decimal places

Sales Status

Sale

1 alphanumeric character. O indicates an order. Q indicates a quote. Any other character or blank indicates the sale is an invoice.

Purchase Status

Purchases

1 character. 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

Both

3 characters, alpha. One code per sale/purchase. Must match a preexisting currency code in the Currency List. Must match customer/vendor currency code.

Exchange Rate

Both

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

Terms – Payment is Due

Both

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

Both

3 characters, numeric
If you choose code 0, 1, 2 or 4 to indicate when payment is due, use a number of days from 0-999.
If you chose code 3 or 5 to indicate when payment is due, use a date from 1-31. (EOM=31)

- Balance Due Days

Both

3 characters, numeric
If you choose code 0, 1, 2 or 4 to indicate when payment is due, use a number of days from 0-999.
If you chose code 3 or 5 to indicate when payment is due, use a date from 1-31. (EOM=31)

% Discount

Both

2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point.

- % Monthly Charge

Sales

2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point.

Referral Source

Sales

20 characters, alphanumeric.

Amount Paid

Both

15 characters (including dollar sign, comma and negative sign). If no decimal entered, MYOB AccountEdge appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent.

Payment Method

Sales

20 characters, alphanumeric.

Payment Notes

Sales

255 characters, alphanumeric.

Name on Card

Sales

50 characters, alphanumeric. Only available for credit card and debit card methods of payment.

Card Number

Sales

25 characters, alphanumeric. Only available for credit card and debit card methods of payment.

Expiration Date

Sales

10 characters, alphanumeric. Only available for credit card and debit card methods of payment.

Authorization Number

Sales

255 characters, alphanumeric. Only available for credit card and debit card methods of payment.

*This is a required field for importing.

Field	Sales or Purchases	Description and Character Limits
*Co./Last Name	Both	Must match a preexisting card in your MYOB software data file. If a company name (no first name), 50 characters, alphanumeric. If a last name, 30 characters, alphanumeric. (If the card is an individual, MYOB software matches the last name followed by a comma and a space, followed by the first name.)
First Name	Both	20 characters, alphanumeric.
Addr 1 - Line 1 - Line 2 - Line 3 - Line 4	Both	Total Address field (lines 1 through 4) cannot exceed 255 characters, alphanumeric.
Invoice #	Sales	8 characters, alphanumeric
Purchase Order #	Purchases	8 characters, alphanumeric
Date	Both	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.
Customer PO	Sales	20 characters, alphanumeric
Vendor Invoice #	Purchases	20 characters, alphanumeric
Ship Via	Both	20 characters, alphanumeric
Already Printed	Both	1 character. Any non-blank character signifies that the invoice and purchase order is already printed or sent.
*Item Number	Both	30 characters, alphanumeric. Must match an preexisting item in your MYOB AccountEdge data file.
Quantity	Both	10 characters, numeric - allows 3 decimal places and decimal point.
Description	Both	255 characters, alphanumeric
Price	Both	11 characters, numeric, including 3 decimal places
Discount	Both	10 characters, numeric, including 2 decimal places
Total	Both	Dollar amount field 15 characters (including dollar signs and negative signs).
Job	Both	5 characters, alphanumeric. Must match preexisting job number in your MYOB AccountEdge data file.
Comment	Both	255 characters, alphanumeric
Journal Memo	Both	255 characters, alphanumeric
Slsmn Last Name	Sales	31 characters, alphanumeric. Must match the name of an employee card in the MYOB AccountEdge data file.
Slsmn First Name	Sales	20 characters, alphanumeric.
Shipping Date	Both	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.
Tax Code	Both	3 characters, alphanumeric. Must match a preexisting tax code in the Tax Code List.


Tax Amount	Both	15 characters, numeric, including 2 decimal places
Import Duty Amount	Purchases	15 characters, numeric, including 2 decimal places

Freight Amount	Both	15 characters, numeric, including 2 decimal places
Freight Tax Code	Both	3 characters, alphanumeric. Must match a preexisting tax code in the Tax Code List.
Freight Tax Amount	Both	15 characters, numeric, including 2 decimal places

Freight Import Duty Amount	Purchases	15 characters, numeric, including 2 decimal places


Sales Status	Sale	1 alphanumeric character. O indicates an order. Q indicates a quote. Any other character or blank indicates the sale is an invoice.
Purchase Status	Purchases	1 character. 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	Both	3 characters, alpha. One code per sale/purchase. Must match a preexisting currency code in the Currency List. Must match customer/vendor currency code.
Exchange Rate	Both	11 digits, including 6 decimal places. If blank, current exchange rate substituted.
Terms – Payment is Due	Both	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	Both	3 characters, numeric If you choose code 0, 1, 2 or 4 to indicate when payment is due, use a number of days from 0-999. If you chose code 3 or 5 to indicate when payment is due, use a date from 1-31. (EOM=31)
- Balance Due Days	Both	3 characters, numeric If you choose code 0, 1, 2 or 4 to indicate when payment is due, use a number of days from 0-999. If you chose code 3 or 5 to indicate when payment is due, use a date from 1-31. (EOM=31)
% Discount	Both	2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point.
- % Monthly Charge	Sales	2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point.
Referral Source	Sales	20 characters, alphanumeric.
Amount Paid	Both	15 characters (including dollar sign, comma and negative sign). If no decimal entered, MYOB AccountEdge appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent.
Payment Method	Sales	20 characters, alphanumeric.
Payment Notes	Sales	255 characters, alphanumeric.
Name on Card	Sales	50 characters, alphanumeric. Only available for credit card and debit card methods of payment.
Card Number	Sales	25 characters, alphanumeric. Only available for credit card and debit card methods of payment.
Expiration Date	Sales	10 characters, alphanumeric. Only available for credit card and debit card methods of payment.
Authorization Number	Sales	255 characters, alphanumeric. Only available for credit card and debit card methods of payment.