Quick Tip: Simple Screen Customization

27 Sep

(reading time < 5 min)

You are probably aware that Sage 300 grids can be modified user-by-user to size, reorder or hide fields.  Place the cursor between two column heading and left-mouse-click-and-drag to change the width (see below).


Click and drag on a column header to move it to a new location.

Right click on a column header to hide it (or to restore a hidden column or column ordering).


Sage 300 also allows for simple screen customization to remove fields outside of the grids that are not needed or that you want to hide from some users.  This must be done as the Sage ADMIN user.  On the screen you wish to change choose “Customize…” from the File menu.


Click the New button next to the Working Profile drop-down to create a profile.  Later we will assign users to this profile.  The customize screen shows the list of controls available on the screen.  Clear the checkbox next to the fields you wish to hide.


Fortunately, the process is interactive.  When you clear a checkbox the control will disappear on the screen in the background so you can see whether you have selected the desired field(s).  Unfortunately, there is currently not a way to keep a field visible but make it read-only.


Once you have made your selections, save the profile.  Note: if this is a new profile, all fields will reappear at this point because the ADMIN user is not assigned to the profile.  Now go to Administrative Services and start “Assign UI Profiles.”  Insert a Sage User ID and select the profile.  Log in as the assigned user and open the customized screen to see the changes.


Note:  Users can be assigned to more than one profile for different screens.  It is possible to have multiple profiles for the same screen.  Users can also be assigned to more than one profile for the same screen although this is not recommended as it can be confusing and the profiles can work to cancel each other.

Quick Tip: Earlier Processing was not Completed

31 Mar

(reading time < 5 minutes)

When starting Sage 300 you may be prompted with the following, ominous-sounding message:


Despite the exclamation point icon, this is for information only and nearly always there is nothing to be concerned about.  This doesn’t mean it should be ignored forever but you don’t have to stop everything to deal with the message.

What’s going on? Sage keeps track of certain processes (imports, day end processing, check printing, etc.) so that, should they not finish, you can correct the issue and complete the process without starting over or restoring from backup (I’m thinking of my fellow ACCPAC Plus alumni).  When the process starts, a restart record is written and when it finishes the record is removed.  Upon startup, Sage 300 checks for these records and prompts the message above if one or more are found. You should review the restart maintenance periodically.  If the restart record file fills up you will not be able to continue with critical processes that rely on restart records.

How to get rid if the message.  As the message states you can go to Administrative Services | Restart Maintenance to review the restart records.  By default, only the ADMIN user can see this object but it can be granted to other users with the Security Groups and User Authorizations. Use the blue arrow buttons to “spin” through the file.  If you click the “next” button and nothing changes you are at the end of the file.


There are two types of records that you can see.  The first are harmless and can be safely deleted.  Shown below is an import record.  You can see the date and time that the record was created and the user who initiated the processes.  If I were to fix the error in the file and finish the import the record would go away on its own.  However I can safely delete it if I don’t care to continue the import.


Occasionally, I’ve seen a blank record.  These can also be safely deleted.

The second type should not be deleted without consultation.  Sometimes these records indicate serious problems.  Sometimes they just indicate normal processes that are still in progress.  Sometimes there are other records involved that would get stranded and cause additional problems if I were to delete the restart record.

Below is a record for AP check printing.  This record indicates that I’ve not completed the process.  When I finish, the record will be removed automatically.


If there was a problem with posting the check batch, I would know it by other messages within the check print/post process.  There may be multiple steps to correcting that problem.

Again, please do not delete these types of records without consultation.  If you have any questions about whether a record is safe to delete or not please contact us.

What Do I Need to Include in My Backup?

16 Mar

(reading time < 10 minutes – these few minutes can save you hundreds of dollars!)

In the last few weeks we’ve had a few clients (and us too) fall victim to different variants of an encryption virus. This virus encrypts files on your machine and leaves behind messages explaining how to pay to get the files back.

In more than one case, we are finding that critical files are not getting backed up!  In more than one case, the database was part of the backup job but no one was monitoring it to make sure the backup was actually finishing.

Obviously, the databases need to get backed up and the job needs to be monitored to make sure it is running every day.  This is not a set-it-and-forget-it thing.  Think about how much money it would take to reenter one day of work let alone a week or more.  There needs to be an offsite copy of the backup as well.  What if your server gets stolen (has happened)?

In addition to the databases there are a few critical files that need to get backed up as well. The easiest thing to do is backup the entire Shared Data Directory including sub-directories.  You can see where this is by going to Help | System Information.


In addition to critical folders, this folder (root) contains your license files and possibly some custom macro configuration files.  Here are the specific folders you need within the Shared Data Directory:

COMPANY – this folder contains mainly log and temporary information.  Not so critical.  Although it may contain some custom macro configuration files.

DATA – unless you are on the Pervasive.SQL database platform this folder is probably empty.  If you are, this folder probably contains you Pervasive.SQL databases although it is not required for them to be within this folder.

SITE – this folder has your company and user lists.  Very important!

USER – this folder contains all of your user customizations – shortcuts, column ordering, printer selections, etc.

CUSTOM – this folder is one we typically create (or have you create) to store all custom forms, reports and macros.  This folder represents a huge investment for your company.  It is not required that you have this folder but nearly all of you will have it.

Financial Reports – you may have a folder within the shared data directory or within the custom folder that contains your Financial Reporter specification files. Being Excel workbooks these are especially “tasty” to these virus programs.  However, you need to verify on your system where these files are.  I know of more that one client who stores these files outside of the Shared Data Directory.  This is fine.  Just make sure they are getting backed up.

Payroll, ACA, Aatrix Folders – if you run Payroll 7.2 you will have some folders related to form filing.

I recommend just getting the whole Shared Data Directory tree to be sure!  Also, many think about what to do in case of fire or earthquake.  You need to have a disaster plan for your server and your data.  This really is a case where “an ounce of prevention is worth a pound of cure.”

Quick Tip: Your Friend the Finder (Part 2)

16 Mar

(reading time < 10 minutes)


In Part 1 of this tip we talked about some of the basic features of the finder and the ability to Set Criteria for a complex search.

The finder, like any grid in Sage 300, can be customized by user.  You can change column sizes by dragging the line between column titles.  You can move a column by dragging its title to a new position.


You can hide a column by right-clicking the column title and choosing the Hide option.  You can also use the right-mouse click to restore a hidden column or to put everything back to defaults.


Here are some other things you can do with columns in the finder:

Add a Column – open the Settings menu and choose Columns… to see and select any of the available columns for this finder.  If this menu item is not active, please ask your ADMIN user to give you rights to the finder columns.

The columns window is divided into two panes.  Available columns are on the left and selected columns are on the right.  Use the Include/Exclude or All/None buttons to move columns between the two lists.  Use the Up/Down buttons on the right to order the selected columns.  Click OK to save your changes and return to the finder.

All selected columns are available in the Find By list.


Highlight a Column – you can highlight frequently referenced column in the finder.  Let’s say that we want to make the Order Reference column stand out.  Open the Settings menu and choose Color…  Select Order Reference from the Field menu.  Use the Text Color and Background Color buttons to select the column coloring.  I’ve chosen a light-yellow background below.


Click OK to return to the finder.  The column is now formatted.  You can format any of the columns and they don’t have to be the same.  Use Settings | Restore Color Default to put everything back


Export from the Finder – this is similar to exporting from other screens but the finder only exports the table to which it is attached.  For example, exporting from the Order Entry screens export order headers, details, optional fields, etc.  Exporting from the order number finder exports only the order headers.

Choose Export from the File menu of the finder to open the export screen.  Select the desired file type from the list and enter/browse for a file name.

Note: the Excel version really has to do with the type of export Sage is going to perform.  It doesn’t have very much to do with the actual version of Excel you are running.


Select the columns you would like to see in your export.  Selecting the top item (orders in my example) and then right-clicking it will allow you to select/unselect all columns.

Even though the finder may have been filtered, the export is not by default.  Use the Set Criteria button to filter the export.  See Part 1 of this tip for an explanation of the Set Criteria feature.

Use Save Script to have record the file type, name, columns selected and criteria filter for a future export.  It will as you for a file name under which to save this information.

Use Load Script to load a previously saved script file.  You’ll be able to edit the columns, criteria, etc. prior to exporting.  This allows you to build one or more export templates.

Click OK to begin the export.

See the Field Names – when you export, Sage uses the field names as the column titles.  For example “Order Number” shows as ORDNUMBER in the export file.  You can see these same titles in the finder if you like.  Select the Settings menu and choose Field Name as Column Heading.  Go back to the menu and click it again to return the column descriptions.

Quick Tip: Your Friend the Finder (Part 1)

8 Mar

(reading time < 10 minutes)


The finder is useful during data entry and it can also be very helpful for researching transactions.  Here are some tips to get the most out of this great tool.

F5 – Everyone knows you can click the finder button (the magnifying glass button) next to a field to open its finder.  You can also open the finder for the you are currently on with the F5 function key. If the field has a value in it, the finder list will open to the closest matching value.  So if you know your item number starts with STR you can enter this before opening the finder to immediately get to this part of the list.

Find By – You can search using any column shown in the finder.  Use the Find By drop down to select the column.  Depending upon the column you choose you can either do a “Starts with” or a “Contains” search, or you can select an operator.  Then enter the value you are searching for in the Filter box.


Go to Filter First – In conjunction with the F5 key this is probably the greatest time saver for data entry.  By default, when you open a finder the cursor is in the grid.  If you want to search for a value, you have to click on the filter box each time to enter a value.  With the Go to Filter First setting, the cursor is in the filter box when you open the finder ready for your search.  Use the Tab key to get from the filter box to the grid.


Enter – Once you have found the record you want there are three ways to select it.  You can click the Select button, you can double-click on the record (any column), or you can simply press the Enter key.

Auto Search – when this is checked the finder will begin searching for records when you have paused for a couple of seconds.  Depending on which field you are searching, the number of records in your database and network conditions the search could take a bit to return.  If you weren’t ready to search it can be frustrating to wait for it to finish.  If you uncheck this box, the finder will not search until you click the Find Now button.

Advanced tip: if you are frequently searching on a field like a description, an address field, or a name and the search takes a long time, ask us about creating an index on this field.  It can dramatically improve your searching speed.

Set Criteria – the Find By box only allows you to search one field at a time.  Use Set Criteria to search by multiple fields/values.


  1. Select a column
  2. Click Add
  3. Double click in the cell to add a value

Below I’ve added the Order Date to the grid and entered >= 1/1/2016.  I double-clicked again on the cell to show the entry screen – this is how to edit the values that have been entered.  This will show all orders this year and later.


Next I’ve added Order Type and Ship to State to the criteria.  This will return orders (no quotes, future orders or standing orders) this year or later to with a WA shipping state.


By filling in the next row I can have it search in Oregon as well.  Note:  I do need to repeat the date and order type values.  Otherwise I would get orders this year for WA and everything for OR.



  • Delete – clears the currently selected column from the grid.
  • Save – save the criteria.  Until you change or clear the criteria they will be applied whenever you open this finder.  If you don’t save it, the criteria will go away when you close the finder.
  • Clear – remove a cell, column, row or the entire criteria filter.
  • Edit – same thing as double-clicking on the currently selected cell.
  • Show Filter – see the criteria translated to its query form.  This is a way to double check the filter.
  • OK – returns to the finder and applies the filter whether you saved it or not.
  • Cancel – returns to finder without applying the filter.

Stay tuned for part 2 where we discuss the columns in the finder and exporting from the finder.

Quick Tip: How to Reverse a G/L Batch

1 Mar

(reading time < 5 minutes)

Sage 300 makes it very easy to reverse a posted G/L Batch (or Entry).  First open the posted batch that you would like to reverse.

GL Rev Batch1

Option 1: Reverse the entire batch

Click the Reverse button at the bottom of the screen.

GL Rev Batch2

The Create Reversing Batch screen will open.

GL Rev Batch3

  1. Select the Batch option
  2. Create a new batch by clicking the new/add button next to the batch number (you can use an already-existing, unposted batch if you like)
  3. Update the batch description if you choose – you can change this later
  4. Set the option for the entry descriptions if you like – you can change these later
  5. Click the process button

This will create a new, unposted batch with all of the entries reversed using the same period in which they were originally posted.  You can modify this batch as much as you like and post it when you are ready.


Option 2: Reverse an entry in the batch

Find the entry number that you would like to reverse within the batch.  Then click the Reverse button at the bottom of the screen.

GL Rev Batch2

The Create Reversing Batch screen will open.

GL Rev Batch4

  1. Select the Entry option
  2. Create a new batch by clicking the new/add button next to the batch number (you can use an already-existing, unposted batch if you like)
  3. Update the batch description if you choose – you can change this later
  4. Update the entry description if you like – you can change these later
  5. Click the process button

This will create a new, unposted batch with the entry you selected reversed using the same period in which it was originally posted.  You can modify this batch as much as you like and post it when you are ready.

Quick Tip: How to Add a New Account While Comparing to an Existing One

29 Feb

(reading time < 5 minutes)

Sage 300 allows you to open multiple copies of nearly every screen so you can open an existing account (or customer, item, vendor, order, etc.)  on one screen while entering a new account on another.

Multiple Copies1

To enable this feature right-click on the screen’s shortcut and choose Properties.

Multiple Copies2

Check the Start Multiple Copies checkbox then click OK.

Multiple Copies3

If that option is grayed out for you, ask your ADMIN to change your Administrative Services security permissions to enable the Customize Company Desktop right.  After that is done, log out of Sage 300 and log back in and you’ll be able to set the option for your shortcuts.

Multiple Copies4