Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Please use the below Supplier Import File for entering the data

Suppliers On-boarding.xls

Column NameOptional or
Required Content?
Comments
Supplier NameRequiredThis is supplier's company name
CurrencyOptionalPlease refer to Standards for Data spreadsheet
Company RegistrationOptional
NameRequiredThe supplier user's full name.
PasswordRequiredThis is required in order for suppliers to log in to Claritum
LanguageRequiredPlease refer to Standards for Data spreadsheet
TimezoneRequiredPlease refer to Standards for Data spreadsheet
User EmailRequiredThe supplier user's email address. This will also be a login id for a supplier user to access Claritum.
Telephone
This is supplier user's telephone number
Address: CompanyRequired Typically this would be 'Head Office' or 'Main Address' or
something similar. 
Address: StreetRequired
Address: CityRequired
Address: CountyRequired
Address: CountryRequired
Address: Post CodeRequired
Supplier TelephoneOptional


FaxOptional
NotesOptional

This can contain any information you like and will remain private to you
(i.e. the supplier is not able to see this information)

Nominal Ledger Code
This is only used in reporting or when exporting approved purchase invoices,
to assist in classifying different types of purchases.
Supplier CustomersRequired

This specifies which customers this supplier is allowed to be used with.

 If the supplier is allowed to work with all customers then this field should
contain the word '
Allotherwise this field can contain a comma-separated
list of the customer names. These must be an exact match to the customer
names already on the system.

 Unrecognised names will simply be ignored.

Accounting RefOptional

If your intention is to export approved purchase invoices from the system to
an external financial package (e.g. for accounts payable) then this field must
contain the ID or Reference of the corresponding supplier record on that system.

Operator CustomersRequired

Which customers this supplier user is allowed to be used in connection with.

 If this supplier user is allowed to work with all customers then this field should
contain the word 'All', otherwise this field can contain a comma-separated list
of the customer names. These must be an exact match to the customer
names already on the system.

Unrecognised names will simply be ignored.

...