Creditors List

To edit (ie. add payments), view or report on a creditor or a group of creditors, filter the available creditors using the Creditors list.

To access the Creditors list select the Creditors icon in either one of these ways:

Some fields provide hyperlink access to view associated information. Hovering the cursor over the wording to the left of the field will display the label name in blue if it is hyperlinked. Click on the label and select the option to View. Vend# – will open the cardfile of the code entered here.

Field	Explanation
Vend#	Vendor's card code.
As of	Enter a specific as of date, if desired.
Terms	Produce a list based on terms of payment, eg. COD, Net 7 days, etc.
Date Due>	Date due is after the date entered here.
Date Due<	Date due is before the date entered here.
Groups	Select any cardfile groups for filtering.
Contact	Contact name from the cardfile.
Name	The vendor's name.
Aged By	Choices are: by Invoice Date or by Due Date. The list can also display all vendors, regardless of whether they have a balance or not. This is great for sending out newsletters, and increasing sales. To use this feature, select All Creditors and click Run.

Jim2 includes a hyperlink from the vendor's cardfile straight to their creditor record – this hyperlink can be accessed by hovering over the Vend# link in a purchase order, then choosing View Creditor.

When finishing a purchase order, Jim2 also provides access to the current creditor's balance.

Sorting, searching and grouping are available as per other lists in Jim2. Select the column header in the grid, then drag it to the Group By area to group.

Use this list to locate a certain vendor or group of vendors by using the filters in the top section of the form.

Balance Filter	Explanation
Balance	In the drop down list choose from one of the six options here:
	Balance <> 0	Creditors with a balance greater or less than 0.
	Balance > 0	Creditors with a balance greater than 0.
	Balance < 0	Creditors with a balance less than 0.
	Unallocated	Creditors with unallocated credits, ie. credits not applied to invoices.
	All Creditors	View all creditors, whether they are owed money or not.
	Overdue	Creditors with overdue invoices not yet paid.
Balance 1 Month checkbox	Select creditors who are still owed after 30 days but less than 60 days.
Balance 2 Months checkbox	Select creditors who are still owed after 60 days but less than 90 days.
Balance 3 Months + checkbox	Select creditors who are still owed after 90 days or more.

Grid result groups

Not all columns are showing here

Any vendors who are marked as inactive in their cardfile will be displayed in this list with the text in a grey colour (ie. greyed-out).

Total in Creditors List that is coloured green indicates there are unallocated credits.

Amounts coloured red indicate they are overdue.

Fields in the list:

Fields	Explanation
Code	The vendor's card code.
Name	The vendor's name.
Total	The vendor's total balance.
Current	The current balance.
1 Month	The 30 days balance.
2 Months	The 60 days balance.
3 Months +	The 90 days and over balance.
Follow Up	The follow-up date of any notes that may have been entered for this creditor.
Terms	The trading terms for each listed vendor.
Credit Limit	This field displays any credit limit imposed by the vendor, if set up in the vendor's cardfile. This will display in red if the limit has been exceeded.
Overdue	Boxes in this column are automatically ticked by Jim2 if there are any overdue invoices.
Amount Overdue	Any overdue amount appears in this column.
Branch/SubBranch/GL Dept	These columns only appear if Branches are in use.

For those creditors listed, the Total column will show any unallocated credits (shown in green text within the list). Also, the bottom of the list shows the total $ amount for several columns of the list.

If user security allows it, right click within the list grid, select Export Data and save the list information as an XLSX file.

Right Click Option

Function

View

View the highlighted object.

Edit

This will bring up the Creditor in Edit mode.

View CardFile

View the highlighted cardfile.

Export Data

Exports data from the grid to a spreadsheet file.

Print the list.

Print Preview

Preview how the list will be printed. Within this area you can change the orientation of the page. For instance, if there are more columns than will fit on a portrait page, change it to landscape.

Copy Cell

Copy the highlighted cell.

Copy Row

Copy the entire highlighted row.

Copy All

Copy all, which can then be pasted into a spreadsheet

Show Find panel

Opens the Find panel:

The Find panel will remain in a pinned list but will disappear from an unpinned list on log off.

Grid Columns...

Allows adding more columns. Also allows removal of columns. Select the column to add, then drag it to the position required in the columns within the grid. To remove, click and drag to the Grid Columns... window, or drag down away from the header area.

There are a number of other useful right click options, all self explanatory. Grid Columns... allows to add further columns to the grid.