Suppliers Reference

Suppliers are those companies or individuals that organisations purchase goods or services from. An unlimited number of Suppliers can be added to a database. Provision is made to add multiple contact people to supplier records and specify their positions. Documents and correspondence are always sent to a Contact Person linked to a supplier.

Suppliers can be added to any menu (e.g. Main Menu > Office > Suppliers).

Settings

These settings relate to Supplier records and transactions.

General Settings

Navigation Example

Main Menu > Setup > Settings > General (tab)

Note

The defaults are the values for new databases, new users and new Transaction Types. Your database may have different values.

Setting Description Default
Accounting > Setup Supplier Age AnalysisAn Edit field to select all the Transaction Types that should appear on the Supplier Age Analysis (e.g. Supplier Invoices, Supplier Debit Notes, and for Work in Progress: Purchase Orders).Not applicable
Accounting > Setup Supplier Summary
  • Select the Transaction Types that should appear on the Activity graph (Account tab) on the Supplier Summary.
  • All the transactions that involve suppliers are automatically displayed on the transactions tab and no setup is required for that.
Not applicable
Supplier Payments > Transaction Type – Accruals – Foreign Currency PaymentsProvides a dropdown list of all the Transaction Types for you to select the one used to record foreign currency payments.Not set
Supplier Payments – Transaction Type – Supplier DiscountsProvides a dropdown list of all the Transaction Types for you to select the one used to record Supplier Discounts.Not set
Supplier Payments – Transaction Type – Supplier PaymentsProvides a dropdown list of all the Transaction Types for you to select the one used to record Supplier Payments.Not set

Transaction Settings

Navigation Example

Main Menu > Setup > Settings > Transactions (tab)

Info

The following settings can be added to these Transaction Types.

Supplier Payments (SP)

Setting Description Default
Accounting > Set Transaction Complete when allocatedCheckbox. If checked, once the payment amount is fully allocated the Status of the transaction is automatically set to Complete.Unchecked
Transactions > Supplier Payments (SP) > Enable 'Clear Overpayment' function in LedgerCheckbox. If checked, you can automatically create an entry to clear an overpayment.Unchecked

Supplier Payments – Forex 1 (SPFX1)

Setting Description Default
Accounting > Set Transaction Complete when allocatedCheckbox. If checked, once the payment amount is fully allocated the Status of the transaction is automatically set to Complete.Unchecked

Supplier Payments – Forex 2 (SPFX2)

Setting Description Default
Transactions > Enable 'Record Foreign Exchange Loss' function in LedgerCheckbox. If checked, foreign exchange losses can be recorded automatically.Unchecked

Supplier Invoices

Setting Description Default
Supplier Payments > Transaction used for Supplier InvoicesCheckbox. If checked, the transaction is used.Unchecked
Transactions > Caption for Due DateField for you to enter a caption (e.g. Payment Due). If no caption is entered, the field is suppressed.Blank
Transactions > Default: Set Due Date from Credit TermsCheckbox. If checked, the supplier's terms set the due date.Unchecked
Transactions > Enable 'Discount Outstanding' function in LedgerCheckbox. If checked, the function is enabled.Unchecked
Transactions > Enable 'Record Foreign Exchange Gain' function in LedgerCheckbox. If checked, the function is enabled.Unchecked
Transactions > Enable Procurement/PurchasingCheckbox. If checked, the function is enabled.Unchecked

Transaction Access Settings

Navigation Example

Main Menu > Setup > Settings > Users (tab)

  • Access is needed for all the Transaction Types that affect supplier accounts.
  • Access is set in the Transaction Access column per selected user.
  • Access can also be set in bulk using Actions (button) > Batch Update.
  • Modules can be added or removed by using Actions (button) > Add/Remove Modules. Removing a module also removes the user's access.
  • The Access options are:
    • View: 
      • None: You have no access and cannot receive access for any of the other options.
      • All: You can view all transactions.
      • Own (Rep): You can view transactions if you were selected as the rep on the transaction. This access does not apply to supplier transactions.
      • Admin: You can view all the transactions and change the statuses.
    • New: If checked, you can create transactions. Having access to copy transactions overrides this setting.
    • Edit: If checked, you can edit transactions.
    • Delete: If checked, you can delete transactions.
    • Est (Form only): Applies to estimates. Only view the form, and not the profit margins.
    • Status (Up only): Only move a transaction forward (e.g. change the status from Pending to Active, but not from Active to Pending). Users with Admin rights can change the status regardless of this setting.

User Settings

Navigation Example

Main Menu > Setup > Settings > Users (tab)

Setting Description Default
Accounting > Supplier Age Analysis – Access AllowedCheckbox. If checked, access is allowed.Unchecked
General > Supplier Payments – Access AllowedOptions are:
  • None: No access is allowed.
  • User: You can view and edit the supplier payments.
  • Full Access: You have access including all the context menu functions.
None
General > Supplier Summary – Access AllowedOptions are:
  • None: No access is allowed.
  • Limited: You can view the supplier summary, except the Account and Transactions tabs.
  • Full Access: You have access to all the context menu functions.
Full Access
Setups > Suppliers – Access AllowedCheckbox. If checked, access is allowed.Unchecked
Setups > Suppliers Accounting – Access AllowedCheckbox. If checked, access is allowed.Unchecked

List View

Buttons Explained

Button Description
ViewGenerates a list of Suppliers based on the selected filters.
NewCreates a Supplier Record.
ActionsAllows changes to all the selected records:
  • Batch Update: Changes all the selected records when Update (button) is clicked. The options are:
    • Status: Changes the Status to the one selected from the dropdown list.
    • Terms: Changes the Terms to the one selected from the dropdown list.
    • Credit Limit: Changes the Credit Limit to the one selected from the dropdown list.
    • Category: Changes the Category to the one selected from the dropdown list.
    • VAT Type: Changes the VAT Type to the one selected from the dropdown list.
    • Region: Changes the Region to the one selected from the dropdown list.
    • Entities: Changes the allocated Entity to the one selected on the dropdown list. Only applies if more than one Entity was created.
    • Groups: Adds or removes the selected group.
  • Format: Formats the names so each word starts with a capital letter.
OutputDisplays the allocated templates, or a message that no templates are linked.
Menu
  • Reset Data Filter: Resets all the data filters.
  • Settings
    • Edit Categories: Interface to create or edit categories.
    • Edit Regions: Interface to create or edit regions.
    • Edit Positions: Interface to create or edit job positions.
    • Edit Groups: Interface to create or edit groups.
  • Export
    • Email Excel
    • Export Grid
  • Layout & Grids
    • Save
    • Save (All Users)
    • Restore Default (All Users)

Filters Explained

Filter Description
CategoryFilters the data to include All or only a specific Category.
RegionFilters the data to include All or only a specific Region.
GroupDropdown list of groups. Shows only records matching the selected Group unless All is chosen.

Fields Explained

Field Description
Field Chooser (*)Add or remove columns.
IDThe system-generated number allocated to the entry.
RIDThe system-generated number allocated to the entry.
StatusThe status of the supplier record.
NameThe supplier's name.
CodeThe supplier's code (account number).
CategoryThe category allocated to the supplier.
RegionThe supplier's region
TermsThe supplier's terms.
GroupsThe groups allocated to the supplier.
TelephoneThe supplier's phone number.
WebsiteThe supplier's website URL.
Credit LimitThe supplier's credit limit.
VAT TypeThe supplier's VAT Type.
VAT No.The supplier's VAT registration number.
Vendor No.The supplier's vendor number.
CurrencyThe supplier's currency.
Bank NameThe supplier's bank details: Bank Name.
Bank Branch NoThe supplier's bank details: Branch Code.
Bank Account NoThe supplier's bank details: Account Number.
Bank SWIFT CodeThe bank's international clearing code.
Created byThe user who created the entry.
CreatedThe date on which the entry was created.
Updated byThe name of the user who last updated the transaction.
UpdatedThe date on which the transaction was last Updated.
MenuClick the button or right-click a supplier for these options:
  • Open Supplier: Opens the supplier record for editing.
  • Delete Supplier: Deletes the supplier record if it is not used in any transactions or linked to any service tickets.
  • View Supplier Summary: Displays the supplier summary.

Edit View

Buttons Explained

Button Description
ArrowsArrows to scroll through supplier records.
OutputDisplays any Output Templates, or a message that there are none.
NewCreates a Supplier Record.
DeleteDeletes the record if it is not used.
SaveSaves the changes (greyed out if there are no changes).
Menu
  • View Supplier Summary: Displays a summary of the supplier's transactions and activity as specified under General Settings.
  • View Changelog: Displays a note with a summary of all the changes.
  • Layout & Grids
    • Save
    • Save (All Users)
    • Restore Default (All Users)

Fields Explained

Field Description
NameEnter the Trade Name of the supplier.
CategoryA dropdown list of categories from which to select one.
RegionA dropdown list of regions from which to select one.
WebsiteEnter the website URL.
TelephoneEnter the telephone number.
GroupsAn interface to add groups to the supplier.
Postal AddressEnter the postal address.
Street Address (Default)Enter the street address.
NoteEnter a note.
Contacts (tab)
  • Options to add contacts and to specify contact people for the supplier.
  • An Add Contact button opens a form to type in the necessary contact details.
  • The first contact added becomes the supplier's account contact (Contact on the Accounting tab).
Accounting (tab)Options to provide the following information:
  • Status: A dropdown list of statuses to select one.
  • Contact: Select the contact who should receive the invoices.
  • Contact (Statements): Select the contact who should receive the statements.
  • Code: Generate a code (click the three dots (...)) or enter a code.
  • Vendor No.: Enter a vendor number.
  • Reg No.: Enter a registration number.
  • VAT Type: A dropdown list of VAT Types from which to select one.
  • VAT No.: Enter the supplier's VAT Registration Number.
  • Currency: A dropdown list of currencies to select one.
  • Credit Terms: A dropdown list of credit terms to select one.
  • Credit limit: Enter the supplier's credit limit.
  • Bank Detail:
    • Bank: Enter the name of the supplier's bank.
    • Branch No: Enter the bank's branch number or code.
    • Account No: Enter the account number.
    • SWIFT Code: Enter the bank's international clearing code.
  • Supplier Payments > Discount: Enter the settlement discount that is received on supplier payments.
  • Warning (Display on Transactions): Enter a warning that appears on transactions.
Attachments (tab)Options to add attachments which can be uploaded files or URLs. An Add Attachment button opens an interface from which a file can be uploaded, or URL inserted.

Categories

Suppliers can be linked to Categories (e.g. hospitality, manufacturing).

  • Categories are created from Supplier List View > Menu (button) > Edit Categories.

Regions

Suppliers can be linked to Regions.

  • Regions are created from Supplier List View > Menu (button) > Edit Regions.

Positions (Job Descriptions)

  • Positions can be created to specify the positions held by Supplier's Contact staff (e.g. Manager, Bookkeeper).
  • Positions are created from Supplier List View > Menu (button) > Edit Positions.

Groups

Suppliers can be grouped.

  • Groups are created from Supplier List View > Menu (button) > Edit Groups.

Report an issue with this page

For more useful feedback, select the text on the page you're reporting about, then click Feedback again — or continue without selecting anything.