Introduction
To process transactions through your Purchasing System, first set up your Supplier Master Records. As you engage with new Suppliers, record their details in the system. As these records contain static information, such as contact details, you can update them, as necessary.
Prerequisite information tables
The Supplier Creation and Maintenance Program has a selection of prerequisite information tables:
- Currencies
- Tax
- General Ledger Codes
- Bank Accounts
Creating and Editing Supplier Accounts
To add a new Supplier, go to AP > Suppliers > New Supplier. Complete the required fields, referring to the relevant section in this article and clock Save.
To edit Supplier details, go to Purchases > Suppliers. In the grid, click on the Supplier code, make any edits and click Save.
See:
Add Edit Supplier Accounts (4.1) - AIQ Academy
Account Details
The highlighted fields come from the Defaults Table, but you can override them by selecting different values.
In Supplier Account complete the following:
- Code: This can comprise alpha and numeric characters with no spaces or special characters. If you leave it blank, the system will automatically create a code.
- Currency Code: Supplier Accounts can only have one currency. If Supplier Invoices are in multiple currencies, set up a Supplier Account for each currency. You cannot change the currency code once you begin adding transactions against the account.
- Bank GL Account: This is your default bank account for making payments to this Supplier. You can change it in Payments and Allocations, but not in Bulk Payments.
- Account On Hold: Set this if you have a problem with the Supplier. You will not be able to process the deliveries for previously raised orders.
Account Settings
The highlighted fields come from the Defaults Table, but you can override them by selecting different values. However, once you have added transactions against the account, you can no longer override GL Account or Control GL Account.
In Account Settings complete the following:
- GL Account: Specify a default General Ledger Account (Cost Account) to post purchases from the Supplier. You can override the GL Account during transactions. Batch Purchase Order Invoicing uses this default appears while Item Invoices use the Item defaults.
- Control GL Code: Use a selection of these if you are separating Creditors by type. This cannot be changed when posting a Purchase Invoice or after a transaction is entered against the account.
- Delivery Settings (Ship via/Priority): The Delivery Settings contain all the entries you set up in the Codes Tables. You can add new entries to any of these tables from here.
- Account Dimensions (Area, Account Group, BI Code): These enable a summary analysis of Purchase data. These fields are optional. Purchase Analysis Reports and the Excel Add-in tool can use these dimensions as selected criteria. BI Code can be overridden at transaction stage.
- Order Required: This is optional. It flags the account as Order Required. This means that this Supplier must enter a Purchase Order before invoices can be processed in the system.
- Exclude from Approval: This is optional. It flags orders and invoices as Exclude from Approval. Exclude from Approval means that the Supplier bypasses the approval process.
See:
Finance Settings
The highlighted fields come from the Defaults Table, but you can override them by selecting different values:
In Finance Settings, complete the following:
Bank Details
- Enter the Supplier bank details for use in Bulk Payments. If you have Create New Supplier access, you can enter the Supplier Bank Details. However, you need to be an Admin user to change them thereafter.
Payment Details & Credit Terms
- Credit Terms: Credit Terms come from the Codes Table. They determine when an invoice is due for payment. Suggest Payments in the Supplier Payment Manager uses the Credit Terms and invoice date to suggest invoices to include in a payment run.
- Credit Limit: This is the maximum amount of credit the Supplier provides. This is checked during order and invoice processing.
- Payment Method: This is the format of a file of payments for transactions to a Supplier. It comes from the Codes Table and EDI File Type. To use this facility, contact your system provider. They can specify your format if it is not already available.
Pricing & Discount Settings
- Discount: This is the discount amount the Supplier extends. It is in decimal format, for example, 15% is 0.15.
- Franchise: This is only relevant when setting up Franchisor/Franchisees.
Tax Settings
- Default Tax Code: This tax code is the default in Supplier Batch Invoicing. You can override this code during the transaction entry stage.
- Use Tax Code: Tick this box to use the foregoing tax code and rate, even for product-related invoices. You can still override it during transaction entry.
- Contractor Tax Code: You can enter the Contractors Tax Code for reference purposes and then use it in a report.
Contacts
To add a new contact:
- Click on New Contact and fill in the required information. Use Set Primary Contact to set a default contact for sending Supplier Purchase Orders or Supplier Statements.
- Click Save.
Notes
To add a new Note:
- Click on Add New Note and complete the Note.
- Click Save. The note is saved with the name of the author and the creation date.
See:
Adding Attachments and Notes to Transactions and Master Records
Custom Fields
Supplier records can have up to ten custom fields. For full details on custom fields, see Adding Customised Fields to Master Records.
- Click on New Custom Field.
- Complete with the appropriate details.
- Click Save.
See:
Attaching Documents to a Supplier Account
You can attach documents, images, and other objects to the Supplier’s Master Record, such as:
- Terms and Conditions
- References
- Letters of Credit
- Voice Mail
Click on the paper clip symbol displayed next to Attach Document.
See:
Adding Attachments and Notes to Transactions and Master Records
Supplier Listing Grid
Go to AP > Suppliers.
The listing grid lets you:
- Add new or maintain existing Supplier accounts
- View or edit supplier transactions
- Attach or view supplier related documents
- Maintain or view supplier notes