Get started

HTML Wrap

class	section group

HTML
<span data-swiftype-index="true">

HTML Wrap

class	col span_3_of_5

If deleting a record (like a card, stock item or account) isn't an option, you can make the record inactive. This is handy if you have records that you rarely use—for example, a card you created for a one-off sale, or an employee who's been temporarily suspended.

Inactivating records removes them from selection lists. Your list of records will be shorter and, consequently, selecting the record you need will be easier. You can still use an inactive record in transactions by manually entering the record name.

Card, item and account reports have a filtering option (when choosing what to show in the report) to include inactive records in your reports.

If you need to reactivate a terminated employee, see Reinstating an employee.

UI Expand

expanded	true
title	To inactivate (deactivate or reactivate ) a record

To

inactivate (

deactivate or reactivate

)

a record

Anchor
1087472
1087472
Display the list to which the record belongs. For example, if you are making changes to an account, display the Accounts List window; if you are changing an item, display the Items List window, and so on.
Locate the record you want to inactivate (or reactivate) and click the . To view inactive records, select the option Show inactive.
Click the zoom arrow ( ) next to itthe record. The record’s details appear.
If you are inactivating or reactivating a card, account, activity or item, click the Profile tab.
Select (or deselect) the Inactive [...] option.

UI Expand

title	To inactivate (deactivate or reactivate ) bulk records

To

inactivate (

deactivate or reactivate

)

bulk records

If you have lots of records to make inactive (deactivate or reactivate), doing it one at a time might can take a while. A quicker method way is to export the records, update the file in Microsoft Excel, then import it the updated information back into AccountRight.

Here's the basics of doing this. To learn more see Importing and exporting data.

Go to the File menu and choose

If you're unsure about this process, try it first using AccountRight's sample company file, Clearwater. It's only a sample company file so you can't break anything.

Let's take you through it.

UI Expand

title	1. Export your information

Export your information

In AccountRight, go to the File menu and choose Import/Export Assistant.

Choose Export Data and click Next.

Choose what

The Import and Export Assistant appears.
Select Export data then click Next.
In the Export field, select the type of information you want to export,

such as

like Cards, Items, Accounts

or Activities then click

, etc.
Click Next. The Format step appears.
Leave the

Format options at their default values and click Next.

default format options and click Next. The Select Fields step appears. The fields in the left panel are the fields you can export.
Choose the fields to export

(click

by clicking the field then

click

clicking Add

):

.

If exporting	export these fields
Cards	Card ID Co./Last Name First Name Card Status
Items	Item Number Item Name Inactive Item
Accounts	Account Number Account Name Inactive Account
Activities	Activity ID Activity Name Inactive Activity

Click

Click Export.

Open the export file in Excel. To be able to find your export file,

The Save As window appear.
Specify where you want to save the file. To keep it simple, save the file to your desktop and leave the default file name.
Click Save.

UI Expand

title	2. Update the information in Excel

Update the information in Excel

Once you've exported your information from AccountRight, you're ready to update it in Microsoft Excel.

Here's how to do it:

Open Microsoft Excel and go to File > Open.
In the Files of type field, select All Files(*.*)

when opening the file.

Image RemovedWhen

and then locate and open the exported text file. The Text Import Wizard appears.
In Step 1 of the Text Import Wizard, select the Delimited option, then click Next.
In Step 2 of the Text Import Wizard

appears, click

, select either the Tab or Comma option (depending on whether you selected to export the data as Tab or Comma separated), then click Next.
In Step 3 of the Text Import Wizard, click Next.
Click Finish. The file opens in Excel and shows your item or card fields as separate columns. The Card Status or Inactive Item column displays N for active records or Y for inactive records.
Set the Card Status or Inactive Item field to N (active) or Y (inactive) for each record as required.

Save the modified file as a Text (Tab delimited) (*.txt) file.

Import the file back into AccountRight. Before doing this, create a backup (in case the import doesn't work as expected, you'll be able to restore the backup).
When performing the import:

At the Format step, change the last option to Update existing data.

At the Match Fields step, click Auto Match.

Before importing

Don't change the column headings (AccountRight needs this information when you import the file in the next task).
When you finish editing, close the file and you'll be prompted to save. Click Yes to the message to save it as Text and continue using this format. This will ensure you can import the file back into your MYOB software as the same type of file it was exported as (tab or comma-separated).
Image Added

UI Expand

title	3. Import your changes

Import your changes

You should always backup your company file before importing. That way, it the import doesn't go to plan you can undo the whole thing by restoring the backup.

In AccountRight, go to the File menu and choose Import/Export Assistant. The Import and Export Assistant appears.
Select Import data then click Next.
In the Import field, select the type of information you're importing, like Cards, Items, Accounts, etc.
Click Browse,locate the file to import and click Open. This will be the file you updated in Excel.
Click Next. The Format step appears.
Leave the default format options as they are and select the Update existing data option. This will update the existing records in AccountRight.
Image Added
Click Next. The Match Fields step appears.
Click Auto Match. AccountRight will automatically match the fields in your import file with the correct fields in AccountRight.
Click Next.
If you haven't already, click Back up to back up your company file

(in case you want to undo your imported changes).

After importing, your chosen records will have updated.

. You'll need this if the import doesn't go to plan.
Click Import. Your data is imported and your records will be updated. If you have a large file, this could take some time.
When the import is finished, an import log is created. It's a text file that includes details of any issues with the import data. If you get an error, see the Import error log topic for tips on how to fix issues.

Didn't go to plan? Restore the backup you created before the import, work out what went wrong, and try again.

HTML
</span>

HTML Wrap

width	15%
class	col span_1_of_5

HTML Wrap

float	left
class	col span_1_of_5

Panelbox

name	green
title	Related topics

HTML Wrap

class	sidebarlinks

Changing a record

Deleting a record

Importing and exporting data

Back up your company file

Restore your company file

Reinstating an employee

Page tree

Versions Compared

Old Version 17

New Version Current

Key

To

deactivate or reactivate

a record

To

deactivate or reactivate

bulk records

Export your information

Update the information in Excel

Import your changes

Was this information helpful?

Why not?

How would you improve this topic?

Thanks! Anything you'd like to add?

Get started

Company file

Work with others

Banking

Emails & printing

Items

Employees (AU)

Suppliers

Customers

Reporting

EOFY

Tips & tricks