Supplier Field Descriptions for Importing Suppliers
This is a detail list of all the fields that can be imported into Dear Systems in relation to Suppliers and what they get used for by Dear Systems as well:
Required Fields
Each Supplier is identified by unique name.
| FIELD NAME | WHAT IS IT? |
|---|---|
| Name | Supplier name. Each supplier must have a unique name. |
| Currency | Supplier currency. A 3-character currency code. |
| PaymentTerm | Supplier payment term. Payment terms applied for all purchases from this supplier by default. |
| TaxRule | Supplier taxation rule. An active Tax rule applied for all purchases from this supplier by default. Product Purchase Tax Rule will override this setting. |
Optional Fields
You can fill in optional fields if you have them
| OPTIONAL FIELD | WHAT IS IT? |
|---|---|
| Status | Supplier status. Valid values are Active and Deprecated. If empty then Active is assumed. Deprecated suppliers are not visible in selection boxes and reporting. |
| AccountPayable | Account payable. Active account code or name from the chart of accounts to be used for transactions generated for all purchases from this supplier. Only special Account Payable accounts are valid for this field. If left blank the system will automatically pick a valid Account Payable account. |
| Carrier | Default Carrier that will be attached to the supplier. Carriers must be defined under Settings--> Reference Books --> Carriers. |
| Discount | Discount % applied to all lines in purchases from the supplier. A valid value is a 2 decimal places number in a range from 0 to 100. If left blank then the 0 value is assumed. |
| TaxNumber | Supplier taxation number. |
| AttributeSet | Name of the attribute set describing a set of supplier additional attributes. Can be set up in the Additional Attributes reference book. |
| AdditionalAttribute1 | Value of additional attribute 1 of the attribute set selected for the supplier. If the attribute set is not specified, the value of this field is ignored. |
| AdditionalAttribute2 | Value of additional attribute 2 of the attribute set selected for the supplier. If the attribute set is not specified, the value of this field is ignored. |
| AdditionalAttribute3 | Value of additional attribute 3 of the attribute set selected for the supplier. If the attribute set is not specified, the value of this field is ignored. |
| AdditionalAttribute4 | Value of additional attribute 4 of the attribute set selected for the supplier. If the attribute set is not specified, the value of this field is ignored. |
| AdditionalAttribute5 | Value of additional attribute 5 of the attribute set selected for the supplier. If the attribute set is not specified, the value of this field is ignored. |
| AdditionalAttribute6 | Value of additional attribute 6 of the attribute set selected for the supplier. If the attribute set is not specified, the value of this field is ignored. |
| AdditionalAttribute7 | Value of additional attribute 7 of the attribute set selected for the supplier. If the attribute set is not specified, the value of this field is ignored. |
| AdditionalAttribute8 | Value of additional attribute 8 of the attribute set selected for the supplier. If the attribute set is not specified, the value of this field is ignored. |
| AdditionalAttribute9 | Value of additional attribute 9 of the attribute set selected for the supplier. If the attribute set is not specified, the value of this field is ignored. |
| AdditionalAttribute10 | Value of additional attribute 10 of the attribute set selected for the supplier. If the attribute set is not specified, the value of this field is ignored. |
| Comments | A multiline comment describing the supplier. The value of this field is copied to the Notes area of every new purchase when the supplier is selected. |
| ContactName | Supplier contact name. If not specified, all supplier contact-related fields must be blank. Contact names must be unique for any given supplier. |
| Phone | Supplier contact phone number. |
| Fax | Supplier contact fax number. |
| Supplier contact e-mail address. Multiple e-mail addresses cannot be specified in this field. | |
| Website | Supplier contact website URL. |
| ContactComment | Additional comment describing supplier contact. |
| ContactDefault | Indicate if the supplier contact must be used by default for all sales to the supplier. Valid values are True and False. |
| ContactIncludeInEmail | Indicate if the contact email should be added to the CC field when emailing documents from DEAR to the supplier. Valid values are True and False. |