Shortcut Keys in Accpac

The computer mouse simplifies the way you navigate through a computer screen by pointing and clicking on the screen. However, as using your mouse is not necessarily the most efficient way to select and open items on your screen. Sage Accpac ERP simplifies the data entry task by incorporating this feature.

In Sage ERP (Accpac), there are a handful of useful shortcut keys that you can use to save time to navigate through the screens. To see how the shortcut keys can be used in Sage Accpac ERP, let us use the O/E Order Entry screen as an example.

You can use the following shortcut keys to navigate through the orders:

o  Page Up – Go to the first (top) record in a list.

o  Page Down – Go to the last (bottom) record in a list.

o  Ctrl/Page Up - Go to the first record in a Finder list.

o  Ctrl/Page Down – Go to the last record in a Finder list.

Now let us see how shortcut keys can be used in the Order Detail grid highlighted in red:

o  Ctrl/Tab – Move out of a grid or list to the button or field following the grid or list.

o  Ctrl/Shift/Tab – Move out of a grid or list to the button or field directly above the grid or list.

o  Home – Go to the first entry in a list.

o  End – Go to the last entry in a list.

o  Up Arrow/Down Arrow – Go up or down one line in a grid.

o  Tab or Enter – Go to the next column.

o  SHIFT + TAB or SHIFT + ENTER – Go the previous column.

o  F9 – If you select any of the line items and press this key, you can drill down on the line item.

o   F5 - If you have the cursor inserted in any field that has a Finder icon (the one with the magnifying glass icon), you can activate the Finder search function by pressing the F5 key.

o   CCalculator – If you select any of the columns related to quantity, amount and press Shift+ key, a calculator appears where the required calculations can be done.

o   Tab Key – The tab key can be used to navigate from one tab to another.

o   Navigation Keys – There are following four navigation keys in Accpac:

First, Previous, Next and Last

First: To go to the first record from the finder list

Previous: To go to the Previous record from the finder list

Next: To go to the Next record from the finder list

Last: To go to the Last record from the finder list

CREATE RECURRING ENTRIES IN GL

Recurring Entries in GL is used to set up journal entries for transactions that occur on a periodic basis. Setting up a recurring entry is similar to recording a journal entry, except that the Recurring Entry form contains additional fields for identification.

To Setup Recurring Entries:

1.       In the GL Setup folder, click Recurring Entries icon

2.       In the entry screen, enter the unique recurring entry code which should represent the type of entry created; maximum 16 characters.

3.       In the Entry description field, enter the suitable description e.g. ‘Recurring batch for Nov 2012 Salary Liability.’

4.       In the schedule field, select the schedule an appropriate schedule such as Monthly.

The scheduling defines the frequency and the day on which the recurring transactions will be         processed.

5.       In the start date field, enter the first processing date for the entry e.g. ‘10/19/2012’.

6.       In the Expiration type, there are two options:

1.       No Expiration date

2.       Specific date

If you select Specific date, you must specify an expiration date in the field that appears.

When an expiration date is specified, the entry is included in the recurring entry batch only if the expiration date is later than the run date.

7.       The Last Run Date field displays the last date this entry was included in the recurring batch.

8.       The Last maintained field displays the last date when this record was changed.

9.       In the description, enter the description for the recurring entry e.g. ‘Recurring batch for Nov 2012 Salary Liability for Greytrix Employees.’

10.   Complete the remaining fields the same way a typical journal entry is created.

Create Recurring Entries Batch:

Select the Create Recurring Entries Batch icon from GL Periodic Processing. The Create Recurring Entries Batch form appears:

1.       Enter a date in the Run Date field if the recurring entries are being created manually in the Create Recurring Entries Batch form. The run date determines which recurring entries are due to be processed. It includes all entries up to the date specified.

2.       Enter the From and To Recurring Entry Codes. For e.g. ‘If a new batch is to be created for salary to Greytrix employees for the month of November, then the code that is already created as a recurring entry for the monthly salary should be selected in the From and To criteria.’

3.       The selection criteria Method has the following three options:

1.       Default - When this method is selected, the batch will be appended to an open batch if both batches have the same run date; otherwise, a new batch is created.

2.       Create a new batch – When this method is selected, a new batch is created.

3.       Add to an existing batch - When this method is selected, a Finder field appears. Click the Finder to select an existing open batch to add this batch to

4.       Run Process.

After creating a recurring entry batch:

• Print the Batch Listing and, if necessary, edit the batch using the Journal Entry form.

• Post the recurring entry batch.

                                                                                                                                                      

Exporting Data to Excel

                                                            

The best approach to work with Export in Accpac is by entering a sample transaction directly via the user interface (UI) and then exporting it using Accpac Export in the format you require, such as Excel or CSV or ODBC. The exported file can then be used to prepare your data for import.

Data can be exported for all the masters, setups.

To Export the data from Accpac go to the required screen and following path:

File optionsà Export

Once clicked on Export, it will open a new screen where the user has to select the type of file format in which data should be exported.

Also select the File Location path where the exported file will be saved. Once the path is selected, it displays the various detail sheets that will be exported.

There are several features available while exporting the data as mentioned below:

Ø  The user can export only required columns in the sheet by selecting them. This would help to reduce the file size.

Ø  There is a Set Criteria feature, where the user can set the various criteria’s for export

For Ex, If the user wants to export only some specific data from the system say, if there are Stock and non stock items imported in the system but if it is required to export only the stock item, then click Set criteria, select stock item column from columns dropdown, click on Add, it will be added in the field criteria column, click on the first cell, a dropdown will appear, select Yes from dropdown, click Ok and export. This would export only the stock items in the sheet.

The same procedure applies for other column criteria.

Ø  There is a Save Script option which allows saving the Set criteria script at a specific location, so that the next time when the user wants to export the sheet with the same set criteria, the script can be loaded from the path where it was saved using the Load Script button.