Miscellaneous Sales and Purchases Fields

Miscellaneous 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.

Journal Number

Both

8 characters, alphanumeric.

Sale 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

Purchase

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

Date

Both

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

Memo

Both

255 characters, alphanumeric.

Slsmn Last Name

Sale

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

Slsmn First Name

Sale

30 characters, alphanumeric.

Referral Source

Sales

20 characters, alphanumeric.

Description

Both

255 characters, alphanumeric

*Account Number

Both

Must be valid, preexisting MYOB software account number. 5 characters, numeric. May (optionally) have a non-numeric separator between the first digit and the last 4 digits (for example, 1-1234).

*Amount

Both

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

Job

Both

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

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

Currency Code

Both

3 characters, alpha. One code per sale/purchase. Must match customer/vendor currency code. (If blank, currency code on customer/vendor card substituted.)

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

Sale

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

Amount Paid

Both

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

Payment Date

Both

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

Payment Method

Sales

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

Payment Notes

Sales

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

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

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.
Journal Number	Both	8 characters, alphanumeric.
Sale 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	Purchase	1 alphanumeric character. O indicates an order. Q indicates a quote. Any other character or blank indicates the purchase is a bill.
Date	Both	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.
Memo	Both	255 characters, alphanumeric.
Slsmn Last Name	Sale	31 characters, alphanumeric. Must match the name of an employee card in the MYOB software data file.
Slsmn First Name	Sale	30 characters, alphanumeric.
Referral Source	Sales	20 characters, alphanumeric.
Description	Both	255 characters, alphanumeric
*Account Number	Both	Must be valid, preexisting MYOB software account number. 5 characters, numeric. May (optionally) have a non-numeric separator between the first digit and the last 4 digits (for example, 1-1234).
*Amount	Both	15 characters (including dollar sign, comma and negative sign). If no decimal entered, MYOB Accounting Plus appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent.
Job	Both	5 characters, alphanumeric. Must match a preexisting job number in your MYOB software data file.
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
Currency Code	Both	3 characters, alpha. One code per sale/purchase. Must match customer/vendor currency code. (If blank, currency code on customer/vendor card substituted.)
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	Sale	2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point.
Amount Paid	Both	15 characters (including dollar sign, comma and negative sign). If no decimal entered, MYOB Accounting Plus appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent.
Payment Date	Both	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.
Payment Method	Sales	20 characters, alphanumeric. Only available for credit card and debit card methods of payment.
Payment Notes	Sales	255 characters, alphanumeric. Only available for credit card and debit card methods of payment.
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	Sales	255 characters, alphanumeric. Only available for credit card and debit card methods of payment.