Skip to main content

Working with lists

Every module opens on a list of its records, for example the Purchase Order List. All lists work the same way.

Transaction list

How to search a list​

  1. Set the filters at the top. Transaction lists usually have Branch, Trans. Date and Transaction Status.
  2. Click Search.

For Trans. Date, click the date box to open the calendar. Pick a start and end date, or choose a quick range on the left (Today, Yesterday, Last 7 Days, This Month and so on), then click OK.

Date range picker

More filters

Click the 🔍 (Filters) icon in the toolbar for all available filters. If you have the General › System Wide › Configure Express Filter permission, you can also click the 🔍 next to the list title (Edit Express Filter) to choose which filters appear at the top of the list.

The list toolbar​

IconNameWhat it does
⊕Add New TransactionOpens a new, blank record.
🔍FiltersOpens all search filters.
⟳RefreshReloads the list.
🔧Column SettingsShows, hides and resizes columns.
✎▾Bulk EditChanges a field (for example Requested By or Remarks) on all selected records at once.
Sort BySorts the list by a column, Ascending or Descending.
🧹Clear Undelivered TransactionsCloses approved transactions whose remaining quantities will never be delivered.
🖨▾PrintPrints the selected records using a printout template.
▾Import ExcelCreates records from an Excel file.
▾Export Excel / Export DetailDownloads the list (one row per record) or the details (one row per product) to Excel.
⋮Bulk ActionRuns For Approval, Approve, Decline, Revert or Delete on all selected records.

You see only the icons you have permission to use.

How to act on several records at once​

  1. Tick the boxes on the left of the rows you want. Tick the box in the header to select every row on the page.
  2. Click ⋮ (Bulk Action) and choose the action.
  3. If some records couldn't be processed, click View Error Logs to see why.

What the row colours mean​

If your company turns on Transaction List: Apply row color based on Transaction Status (in Settings), each row is coloured by its status:

Colour settingUsed for
DraftSaved, not yet submitted
For ApprovalWaiting for approval
DeclinedRejected
DeletedDeleted
No Inbound/Outbound/Payment/CollectionApproved, but nothing received, delivered, paid or collected yet
Incomplete Inbound/Outbound/Payment/CollectionApproved and partly received, delivered, paid or collected
Complete Inbound/Outbound/Payment/CollectionApproved and fully received, delivered, paid or collected

Your administrator picks the actual colours.

Totals and paging​

The bottom of the list shows Total Rows and the totals for the rows found (for example Total Amount and Total Qty). Use Previous / Next, or type a page number, to move between pages. The box on the left sets how many rows appear per page.

Settings that affect all screens​

Your administrator can change these in Settings (see About settings). Click a section to see the choices.

Generic Settings › Company Info

Generic Settings › Display

Generic Settings › Product

Generic Settings › Purchase and Other Payment

Generic Settings › Sales and Other Income

Generic Settings › Security

Generic Settings › Stock Transferring

Generic Settings › Transaction Setting