Aantar

Aantar Books

Add/Edit Multiple List Entries

Change many customers, vendors or items at once in a spreadsheet-style grid, add customers and vendors in bulk, or paste them from Excel.

Where: Lists ▸ Add/Edit Multiple List Entries…

Add/Edit Multiple List Entries shows your customers, vendors or items as a spreadsheet. Change any cell in place, add new customers or vendors at the bottom, or copy rows from Excel and paste them in. Save Changes saves every row you touched at once.

Opening it

Lists ▸ Add/Edit Multiple List Entries…. It opens in a window of its own; Esc closes it and takes you back to where you opened it from. It needs permission for the Customer Centre.

The controls

Control What it does
Customers / Vendors / Items Which list to show. Switching with unsaved changes asks Discard your changes? (Keep editing or Discard).
Search… Shows only rows containing the text. Changed rows stay visible.
Add Row Adds a blank row at the bottom (customers and vendors only).
Paste from Excel Adds a row for each line copied from Excel (customers and vendors only).
Customize Columns Chooses more columns to show. See Customize Columns.
Save Changes (N) Saves the N changed and new rows.

The grid has a scroll bar down its right-hand edge and one across its foot, shown all the time. Drag them (or use the mouse wheel, and Shift with the wheel to go sideways) to reach rows and columns that do not fit in the window. The bar down the right stays at the edge of the window however far across you have scrolled.

The count at the bottom shows how many rows there are and how many are changed. A changed row is tinted with a pencil icon, a new row has a "new" icon, and a row that could not be saved is red with an error icon — point at it to read why.

The columns

List Columns
Customers Name, Company, E-mail, Phone, Address, City, Province/State, Postal Code, Country, Tax No., Terms (days), Credit Limit
Vendors Company, Contact, E-mail, Phone, Address, City, Province/State, Postal Code, Country, Tax No., Terms (days)
Items Item Name, Variation (read-only), SKU, Sales Price, Cost, Reorder Pt

These columns are always shown. Customize Columns adds more.

Customize Columns

You can add more of each list's fields to the grid. Choose Customize Columns: the dialog names the columns that are always shown, and has a tick box for each column you can add. Tick the ones you want and choose OK. The added columns appear after the others.

List Columns you can add
Customers First Name, Last Name, Address 2, Landline, GST No., PST No., Customer Type, Price Level, Status, ID, Title, Middle Name, Alt. Phone, Ship To, Custom Field 1 to 4
Vendors First Name, Last Name, Address 2, Landline, GST No., PST No., Vendor Type, Status, ID, Title, Middle Name, Alt. Phone, Ship To, Custom Field 1 to 4
Items Description, Category, Unit, Tax, HSN Code, Customs Duty %, Reorder Qty, Lead Time (days), Weight, Brand, Active, Custom Field 1 to 4

The column picker scrolls when a list has more columns than fit. An ID already used by another customer or vendor is refused, and a customs duty rate, reorder quantity or lead time that is not a number is refused, with the reason on the row.

The columns you choose are remembered on this computer, separately for each list.

Customer Type, Vendor Type, Price Level, Status, Category, Unit and Tax are drop-downs: choose the entry, or — for none. Only this company's own types, price levels, categories, units and taxes are offered.

  • Changing an item's Tax here also updates its price with tax, as the item form does.
  • An item always keeps a unit: choosing — under Unit leaves the unit as it was.

Change entries, step by step

  1. Choose Customers, Vendors or Items.
  2. Find the rows with Search… if the list is long.
  3. Click into cells and type the new values.
  4. Choose Save Changes.

Aantar Books reports N of M saved. Rows in red were not saved; fix them and save again.

Add customers or vendors from Excel

  1. In Excel, arrange the columns in the same order as the grid (for vendors: Company, Contact, E-mail, Phone, Address, City, Province/State, Postal Code, Country, Tax No., Terms (days)), followed by any columns you added with Customize Columns, in the order they are shown.
  2. Copy the rows. A first row of headings is fine; it is skipped. In a drop-down column (Customer Type, Vendor Type, Price Level, Status), type the entry's name as it appears in the list; a name that does not match is left blank.
  3. Choose Paste from Excel. Aantar Books says N row(s) pasted — check them, then Save Changes.
  4. Check the new rows and choose Save Changes.

If there is nothing on the clipboard: Nothing to paste — copy rows in Excel first, columns in the order shown here.

New items cannot be added here: New items are added on the item form; this list edits the ones there.

Rules and messages

Message What to do
A new row needs a name. Type a name (or a company for a vendor).
… is already on the list. That customer or vendor already exists.
… is not an e-mail address. Correct the email.
Pay term number has to be a number. / Credit limit has to be a number. Type a number.
A name cannot be blank. Keep a name on existing rows.
A price has to be a number, not below zero. / A cost has to be a number, not below zero. Correct the figure.
An SKU cannot be blank. / SKU … is already another item's. Each item needs its own SKU.
An item name cannot be blank. Type the item's name.

Notes:

  • A new customer or vendor made here gets only the fields in the grid, including any you added with Customize Columns. Open their record afterwards to check the province (which decides the tax on customer orders) and add any other details.
  • Changing an item's Item Name renames the item, including all its variations. Changing Sales Price updates the price including tax too.
  • The grid shows up to 5,000 rows per list.

Permissions

Editing customers, vendors or items here needs the same rights as editing them on their own forms.

Note: Add/Edit Multiple List Entries works for customers, vendors and items, including pasting from Excel and Customize Columns.

Related articles

Something unclear or out of date? Write to support@aantar.com and name this page.