Module#5: Processing Other Types of Batches and Budgeting Flashcards

1
Q

The General Ledger allows you to import and export files to and from Sage 300 and non‐Sage 300 applications.

A: True
B: False

A

A: True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which of the file types does Sage 300 allows you to import from, or export to

A: Microsoft Access
B: Microsoft Excel
C: DBase
D: CSV
E: XML
F: ODBC
G: All
A

G: All

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

When exporting data, you may have to create a file beforehand in the target application.

A: True
B: False

A

A: True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q
The General Ledger module enables you to export a 
\_\_\_\_\_\_\_\_\_\_\_\_\_\_ batch from your Sage 300 database to a non‐Sage 300 application, such as Microsoft Excel or Microsoft Access

A: General Ledger
B: Accounting
C: Transaction

A

B: Accounting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Which transaction batch can you can import into your Sage 300 database.

A: Batches that were previously exported by Sage 300
B: Batches that were created in non-sage 300 Programs
C: Both

A

C: Both

batches that were previously exported by Sage 300

batches that were created in non‐Sage 300 programs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is the only way to transfer batches created by non‐Sage 300 programs into Sage General Ledger.

A: Importing
B: Exporting
C: Exiting

A

A: Importing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

You can ______ an imported batch to a current batch or create a new batch.

A: Add
B: Subtract
C: Multiply

A

A: Add

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

A ________ entry is a journal entry that is processed regularly, such as the payment of rent or a monthly telephone bill.

A: Recurring
B: Ongoing
C: Continuous

A

A: Recurring

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

You set up recurring entries by opening the G/L Setup folder in the General Ledger, and opening the ___________ Entries form

A: G/L Recurring
B: Account Recurring
C: Bank Recurring

A

A: G/L Recurring

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

In which Order would you use to set up the recurring entry.

A: Add a schedule for the entry
B: Add a description to the entry
C: Enter a unique code

A

1: Enter a unique code
2: Add a description to the entry
3: Add a schedule for the entry

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

In the Schedule Code field at the top of the Schedules form, enter a unique code for the schedule. It can be up to ______ characters long.

A: 20
B: 16
C: 10

A

B: 16

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

A schedule must be ___________ to each recurring entry to specify when the entry is due to be processed.

A: Assigned
B: Locked on
C: Added

A

A: Assigned

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Define Specific User

A: Only the user you specify will be able to process the recurring entry
B: A User that creates all the folders
C: A User that specify’s which folders can be accessed
D: All

A

A: Only the user you specify will be able to process the recurring entry

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Define All Users

A: All Users will be able to process the recurring entry
B: All Users will be able to change entries
C: All Users will be able to fix schedules

A

A: All Users will be able to process the recurring entry

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Define No Users

A: Means No users can access
B: Means that recurring entries must be created manually.
C: Means that No users can create new folders

A

B: Means that recurring entries must be created manually.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

When you select either Specific User or All users, additional fields are added to the form, enabling you to indicate when to remind users and when to start the schedule.

A: True
B: False

A

A: True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

The reminder list doesn’t display information about each schedule, such as whether it has been processed and the scheduled due date.

A: True
B: False

A

B: False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

In the Recurring Periods section, you can select how often the recurring entry occurs.

A: True
B: False

A

A: True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

By default, recurring entries expire

A: True
B: False

A

B: False, they don’t expire

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

If you want the recurring entry to expire on a certain date, click the ___________ Type drop‐down arrow

A: Continuous
B: Expiration
C: Never Ending

A

B: Expiration

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

If you wish, you can enter an additional description of the recurring entry in the Description field. Then click Detail and enter all detail lines for the recurring entry in the Recurring Entry form.

A: True
B: False

A

A: True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

You can use the ___________ form to create a batch of recurring transactions. The batch can consist of a single recurring entry, or a range of recurring entries.

A: G/L Create Folders
B: G/L Create Recurring Entries Batch
C: G/L Create Files

A

B: G/L Create Recurring Entries Batch

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Default Method means

A: Batch will added to an open batch if the run dates are the same
B: New Batch will be created if run dates differ
C: Both

A

C: Both

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Creating a New Batch means that a new batch will be

A: Installed
B: Created
C: Designed

A

B: Created

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

Adding to an Existing Batch displays a new box where you can enter an __________ batch number to which the recurring entries will be added.

A: New
B: Existing
C: Closed

A

B: Existing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

To create and process the journal entry, click the _________ button.

A: Proceed
B: Process
C: Produce

A

B: Process

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

Auto allocation is a time‐saving feature of Sage 300.

A: True
B: False

A

A: True

28
Q

You can view posted batches in the __________ form, as long as the Show Posted and Deleted Batches box is checked.

A: G/L List
B: G/L Batch List
C: G/L Folder List

A

B: G/L Batch List

29
Q

If you are reversing the entire batch, you must choose:

A: Original – to keep the same entry descriptions as in the original batch
B: Original with Prefix – to keep the original descriptions and precede them with a prefix you enter
C: New – to enter new descriptions for each entry
D: All of the Above

A

D: All of the Above

30
Q

If you are reversing the whole batch, Sage will prompt you to confirm. Then a message window displays to let you know that the process is complete and the reverse batch has been created.

A: True
B: False

A

A: True

31
Q

There are three ways to display account information in Sage 300.

A: True
B: False

A

A: True

32
Q

A budget is typically used to provide a __________ of revenues and expenditures

A: Account
B: Forecast
C: Ledger

A

B: Forecast

33
Q

When are Budgets usually approved?

A: Start of the Fiscal Year
B: End of the Fiscal Year
C: Middle of the Fiscal Year

A

A: Start of the Fiscal Year

34
Q

What is the Default Budget Method?

A: Accrual Amount
B: Fixed Amount
C: Total Amount

A

B: Fixed Amount

35
Q

Define Fixed Amount

A: Used for All Fiscal Periods
B: Will Divide the Amount
C: Used for Most Fiscal Periods

A

A: Used for All Fiscal Periods

36
Q

Define Spread Amount

A: Spreads the Amount to other accounts
B: Will Divide the Amount by the number of fiscal periods
C: Will show different accounts

A

B: Will Divide the Amount by the number of fiscal periods

37
Q

Define Base, Percent Increase

A: Enters Base amount you specify for the first fiscal period
B: Increases amounts in subsequent periods by percentage entered in the increase Box
C: Both

A

C: Both

38
Q

Define Base, Amount Increase

A: Enters Base amount you specify for the first fiscal period
B: Increases amounts in subsequent periods by Amount entered in the increase Box
C: Both

A

C: Both

39
Q

What is the Inquiry Amount column?

A: Used to Display Comparison Data
B: Side by side with Budget Amounts
C: Both

A

C: Both

40
Q

Each fiscal set stores _______________ periods of accounting transaction summary data, depending upon whether the ledger uses twelve or thirteen fiscal periods

A: Twelve or Thirteen
B: Ten to Eleven
C: Thirteen to Fourteen

A

A: Twelve or Thirteen

41
Q

Define the Copy, As in Option

A: Option will copy the Exact Amounts in each period
B: Option will copy only what is selected
C: Option will copy everything

A

A: Option will copy the Exact Amounts in each period

42
Q

Define Copy, Percent Increase Option

A: Will increase the amounts in each period of the inquiry amount column by multiplying by a percentage you specify
B: Copies percentages and when right clicked on the percentage gives you options you can use
C: Copies selected percentages for the fiscal year and lets you decide different options

A

will increase the amounts in each period of the Inquiry Amount column by multiplying by a percentage you specify.

43
Q

Define Copy, Amount Increase Option

A: Will increase the amounts in each period of the inquiry amount column by multiplying by a percentage you specify
B: will increase the amounts in each period of the Inquiry Amount column by adding an amount you specify
C: Copies selected percentages for the fiscal year and lets you decide different options

A

B: will increase the amounts in each period of the Inquiry Amount column by adding an amount you specify.

44
Q

Define Copy, Prorated Spread Option will perform a weighted distribution of amounts based on:

A: the period amount in the Inquiry Amount column,
B: the sum of period amounts in all the Inquiry Amount fields, and
C: the amount you specify as the spread amount.
D: All

A

D: All

45
Q

Define Copy, Prorated Spread Option will perform a weighted distribution of amounts based on:

A: the period amount in the Inquiry Amount column,
B: the sum of period amounts in all the Inquiry Amount fields, and
C: the amount you specify as the spread amount.
D: All

A

D: All

46
Q

Which of the following file types can be imported to or exported from Sage 300?

A: Excel
B: XML
C: Access
D: All

A

D: All

47
Q

True or False: Importing is not the only way to transfer batches created by non-Sage 300 programs into Sage General Ledger.

A: True
B: False

A

B: False

48
Q

The General Ledger’s import and export features are found in the G/L Journal Entry form.

A: True
B: False

A

A: True

49
Q

True or False: Batches that were previously exported by Sage 300 and batches that were created in non-Sage 300 programs can be imported into a Sage 300 database.

A: True
B: False

A

A: True

50
Q

Recurring entries are set up in the G/L Recurring Entries
form.

A: True
B: False

A

A: True

51
Q

True or False: To create a batch of recurring transactions use the G/L Create Recurring Entries Batch form.

A: True
B: False

A

A: True

52
Q

A schedule must be assigned to each recurring entry to specify when the entry is due to be processed.

A: True
B: False

A

A: True

53
Q

True or False: The recurring entry batch can only consist of a single recurring entry.

A: True
B: False

A

False

54
Q

Allocation accounts can be viewed in the G/L Accounts form.

A: True
B: False

A

A: True

55
Q

True or False: The Auto-allocation feature enables the balances of accounts that have been set up as certain accounts to be allocated, or divided among other accounts, usually at a period-end.

A: True
B: False

A

A: True

56
Q

True or False: If your allocation accounts have balances, you cannot create an allocation batch that will automatically distribute and transfer those balances.

A: True
B: False

A

B: False

57
Q

The Reverse button is located in the G/L Journal Entry form.

A: True
B: False

A

A: True

58
Q

True or False: Once you have created a reversing batch, it can be viewed in the G/L Batch List form.

A: True
B: False

A

A: True

59
Q

You can lock your budget sets on the Posting tab of the G/L Options form.

A: True
B: False

A

A: True

60
Q
Once you have imported the transactions, you can:
A: Edit
B: Print
C: Post
D: All
A

D: All

61
Q

Using recurring entries saves

A: Data Entry Time
B: Reduces Errors
C: Both

A

C: Both

62
Q

When you select specific user mode, a _______ field is added to the form and you must enter or select a user ID.

A: Blank ID
B: User ID
C: New ID

A

B: User ID

63
Q

In the Frequency section, you can make more specific selections based on the recurring period chosen.

A: True
B: False

A

A: True

64
Q

You could also click Process directly from your Reminder List when you receive a reminder that a batch is due.

A: True
B: False

A

A: True

65
Q

Auto Allocation enables the balances of accounts that have been set up as Auto Allocation accounts to be allocated, or divided among other accounts, usually at a period‐end.

A: True
B: False

A

A: True

66
Q

Which can be accessed from the G/L Accounts folder:

A: Using the G/L Account History Inquiry form
B: Using the G/L Transaction History form
C: Using the G/L Fiscal Set Comparison form
D: All of the Above

A

D: All of the Above

67
Q

Where are the Define Copy, Percent Increase Option results copied into?

A: Corresponding periods of the budget Amount Column
B: On the Internet where employees can download them
C: On another drive for all employees

A

into the corresponding periods of the Budget Amount column.