Create a view of the records within the service that needs to be batched. Note that the wizard also supports prompted views.
General Ledger Batches may be created using any filter available in the view, but are most commonly filtered based on the time period, such as a particular week, month, day or year. You can also filter the view to display records that have a BatchID Is Blank (that is, BatchID is NULL), which will return only records that have not yet beenbatched yetbeenbatched for the accounting system.
For Scheduled Transactions, you should onlybatchthose records shouldonlybatchthoserecords whose Scheduled Date is today or earlier (do not batch transactions dated in the future).
The wizard automatically filters out non-qualifying records that have already beenbatched. Also, for Orders, the wizard filters out orders that have not yet shipped, and for Payments, the wizard filters out payments whose Status is not Posted.
Note that the wizard only evaluates the records in the current view.
Note that the Batch wizard is not available for SQL based temporary views.
Launch the Batch wizard from the desired service.
To batch orders, select the GL Batch Export option from the More menu in the view's toolbar.
To batch payments, select the GL Batch Export option from the More menu in the view's toolbar.
To batch general ledger scheduled transactions, select the GL Batch Export option from the More menu in the view's toolbar.
Review the information on the Introduction screen and click Next to continue.
The Introduction screen provides an overview of the wizard process and explains that not all records in the view automatically qualify for inclusion in the general ledger batch.
Review the summary of the qualifying and excluded records grouped by currency typeand click Next to continue.
The grid on this page displays the general ledger batches that will be created based on the data in the view.
The records are grouped together based on the record's currency and the functional currency for the organization specified on that record. For example, US Dollar and Euro orders taken by a US Dollar organization are divided into two batches: US Dollar (US Dollar) and Euro (US Dollar).
To show the specific records that are included in and excluded from each currency's general ledger batch, place the cursor over the Details cell for a particular row to display a gray box. Then, click the gray box to open another double click the row you want to review to open the Batch Detail dialog.
The Details Batch Detail dialog includes two tabs: The Records In Batch tab lists all records qualifying for the general ledger batch. The Excluded Records tab lists all records excluded from the general ledger batch (because they have been included in a previous batch or for some other reason).
The records listed on these two tabs are those in the view from which the wizard was initiated.
When batching orders, only shipped orders can be batched.
When batching payments, authorized credit card payments verified by a merchant account cannot be batched until they are captured using the ePayment Capture wizard so they appear in the Excluded Records list. See "Using the ePayment Capture Wizard" on page 140 in the for more information. Note that refund credit card payments can be batched once authorized (they do not require a capture process first) so they appear in the Records In Batch list.
Review the list of records and click OK to return to the the X in the top-right corner of the dialog to return to the main wizard screen.
Click Next to continue.
When batching Scheduled Transactions records, a screen will appear prompted you to click Next if prompted to to expand all pending Scheduled Transaction Groups.
The wizard displays a summary of the Batches records it will create. If you want to regenerate GL entries prior to generating a batch, place a check mark in the Regenerate EntriesGL box.
The Regenerate Entries GL option should only be selected if changes have been made to the GL accounts for affected products or payment types since the earliest Order Ship Date or Payment Date included in the general ledger batch.
The system automatically generates GL entries when orders are shipped and when payments are created. Unnecessarily regenerating the GL Entries increases the wizard's processing time.
Note that the Regenerate Entries option is not available for (or applicable to) Scheduled Transactions.
Click Next to continue.
The wizard generates the GL Batches and displays a summary of the batch's information, including the total debit and credit amount included in the batch.
To review the details of the summarized GL entries for each general ledger batch, place the cursor over the Details cell for a particular row to display a gray box. Then, click the gray box to open another dialogdouble click a row to view the Batch GL Summary entries.
On the
Details
Batch Summary GL Entries dialog, the wizard reports the total amount debited or credited for each GL account included in the batch. Thus, the results are one entry for the accounts receivable GL account, one entry for the sales account, and so on.
Also, for batches in a foreign currency (that is batches where the currency does not match the specified Functional Currency), the wizard reports the Weighted Average Spot Rate used to convert the foreign currency into the appropriate functional currency. See "Weight Spot Changes" in the for more information.
After reviewing the entries, click
OK
the X in the top-right corner to return to the
main
wizard
screen
.
Associate the batch with an Open Accounting Period in the Accounting Periodfield.
By default, the wizard will select the Open accounting period with the lowest ID whose date range includes the batch's effective date. See "Accounting Periods Service" on page 198. for more details.You can also search for an Accounting Period by placing the cursor in the cell in a particular row to bring up the Find Accounting Period Record dialog where you can enter the name or the ID of the Accounting Period you want to associated the batch with.
Ifat a later date, it is determined that the batch is associated with the wrong Accounting Period, you can modify the batch's Accounting Period affiliation at any time by running the Update Accounting Period entity bulk operation from a Batches list view. (By default, only members of the Accounting and Administrators groups can see and execute this entity bulk operation.)
See the "Accounting Periods Service" in the for more details.
Place a check mark in the ApprovalIs Approved box for each general ledger batch you want to approve and click Nextto continue.
You must approve at least one batch to complete the wizard.
Modify the default name Review the records to batch and click Next to continue.
Modify the File Name, Effective Date, File Type, and whether or not to Include Accounting Period Data in the Export Fieldof the Batches record,as needed, and click Finish to complete the wizard.
The system automatically defaults the GL batch name to include both the name of the general ledger batch type (Orders, Payments, or Scheduled Transactions), the name of the currency in parentheses , and and the date on which the general ledger batch was created.
The
wizard displays the set of Batches records it created. Double-click on a record to export the batch's information to a file that can be imported into your organization's accounting system.
If you choose not to export the file at this time, you can always export the file later by opening the appropriate record in the Batches service.
See for more information on creating a batch export file.
When finished, click OK to close the wizard.
default File Type is defined on the Batches entity. See the below for more details.
To modify the batch, double click the row to bring up the Export Batch dialog and modify the File Name, Effective Data and File Type as needed. You can also check the Include Accounting Period Data in Export File if you want to include this information as well in the export.
Make sure to place check in the first column of the rows in which you want to export and click Finish to complete the wizard.
If you choose not to export the file at this time, you can always export the file later by opening the appropriate record in the Batches service.
See for more information on creating a batch export file.
Note Concerning Default Export Type
_DefaultExportTypeIn the Export Batch dialog, the default Save as type is tab delimited (.txt). However, an administrator can modify this default value by modifying the configurable attribute found on the Batches entity. Below is a description of the attribute:
DefaultExportType: The Batch Export save dialog can save a batch file in two formats: CSV or Tab‐delimited. While you can save a particular file in either format, this attribute determines which format is selected by default. A value of CSV sets the default to the comma separated value (CSV) type. A value of TXT sets the default to the tab‐delimited type.
Auitabspage
id
3
title
Desktop Interface
Follow these steps to run the Batch wizard to create a General Ledger Batch through the Aptify Desktop interface:
Create a view of the records within the service that needs to be batched. Note that the wizard also supports prompted views.
General Ledger Batches may be created using any filter available in the view, but are most commonly filtered based on the time period, such as a particular week, month, day or year. You can also filter the view to display records that have a BatchID Is Blank (that is, BatchID is NULL), which will return only records that have not yet been batched beenbatched for the accounting system.
For Scheduled Transactions, you should only batch those onlybatchthose records whose Scheduled Date is today or earlier (do not batch transactions dated in the future).
The wizard automatically filters out non-qualifying records that have already been batchedbeenbatched. Also, for Orders, the wizard filters out orders that have not yet shipped, and for Payments, the wizard filters out payments whose Status is not Posted.
Note that the wizard only evaluates the records in the current view.
Note that the Batch wizard is not available for SQL based temporary views.
Launch the Batch wizard from the desired service.
To batch orders, either click the Create Order Batch icon in the view toolbar or right-click within the view and Orders Options > Create Order Batch.
To batch payments, either click the Create Payment Batch icon in the view toolbar or right-click within the view and select Payments Options > Create Payments Batch.
To batch general ledger scheduled transactions, either click the Create Scheduled Transaction Batch icon in the view toolbar or right-click within the view and select Scheduled Transactions Options > Create Scheduled Transactions Batch. Launch Batch Wizard
Review the information on the Welcome page and click Next to continue.
The Welcome page provides an overview of the wizard process and explains that not all records in the view automatically qualify for inclusion in the general ledger batch.pgfId-1027131Aptify Batch Wizard Welcome PagepgfId-1002762
pgfId-1020163Review the summary of the qualifying and excluded records grouped by currency type and click Next to continue.pgfId-1036311
The grid on this page displays the general ledger batches that will be created based on the data in the view.pgfId-1042579
The records are grouped together based on the record's currency and the functional currency for the organization specified on that record. For example, US Dollar and Euro orders taken by a US Dollar organization are divided into two batches: US Dollar (US Dollar) and Euro (US Dollar).pgfId-1033249Choosing Records to BatchpgfId-1040755pgfId-1039219
To show the specific records that are included in and excluded from each currency's general ledger batch, place the cursor over the Details cell for a particular row to display a gray box. Then, click the gray box to open another dialog.pgfId-1036106
The Details dialog includes two tabs: The Records In Batch tab lists all records qualifying for the general ledger batch. The Excluded Records tab lists all records excluded from the general ledger batch (because they have been included in a previous batch or for some other reason).pgfId-1036321
The records listed on these two tabs are those in the view from which the wizard was initiated.pgfId-1041971
When batching orders, only shipped orders can be batched.pgfId-1041895
When batching payments, authorized credit card payments verified by a merchant account cannot be batched until they are captured using the ePayment Capture wizard so they appear in the Excluded Records list. See "Using the ePayment Capture Wizard" on page 140 for more information. Note that refund credit card payments can be batched once authorized (they do not require a capture process first) so they appear in the Records In Batch list.pgfId-1036322
Review the list of records and click OK to return to the main wizard screen.pgfId-1033257Batch Detail DialogpgfId-1033260
pgfId-1011659When batching Scheduled Transactions records, click Next if prompted to expand all pending Scheduled Transaction Groups.pgfId-1033265Expanding Scheduled TransactionspgfId-1033268
pgfId-1027356The wizard displays a summary of the Batches records it will create. If you want to regenerate GL entries prior to generating a batch, place a check mark in the Regenerate Entries box.
pgfId-1036514The Regenerate Entries option should only be selected if changes have been made to the GL accounts for affected products or payment types since the earliest Order Ship Date or Payment Date included in the general ledger batch.pgfId-1036610
The system automatically generates GL entries when orders are shipped and when payments are created. Unnecessarily regenerating the GL Entries increases the wizard's processing time.pgfId-1039844
Note that the Regenerate Entries option is not available for (or applicable to) Scheduled Transactions.pgfId-1033273Generating GL EntriespgfId-1033276
pgfId-999055Click Next to continue.pgfId-1036663
The wizard generates the GL Batches and displays a summary of the batch's information, including the total debit and credit amount included in the batch.pgfId-1033281Reviewing Details of GL Summary EntriespgfId-1033284pgfId-1036748
To review the details of the summarized GL entries for each general ledger batch, place the cursor over the Details cell for a particular row to display a gray box. Then, click the gray box to open another dialog.pgfId-1036890
On the Details dialog, the wizard reports the total amount debited or credited for each GL account included in the batch. Thus, the results are one entry for the accounts receivable GL account, one entry for the sales account, and so on.pgfId-1036943 Also, for batches in a foreign currency (that is batches where the currency does not match the specified Functional Currency), the wizard reports the Weighted Average Spot Rate used to convert the foreign currency into the appropriate functional currency. See for more information.pgfId-1036891 After reviewing the entries, click OK to return to the main wizard screen.pgfId-1036892GL Account SummariespgfId-1033292
pgfId-999062Associate the batch with an Open Accounting Period in the Accounting Period field.pgfId-1053331
By default, the wizard will select the Open accounting period with the lowest ID whose date range includes the batch's effective date. See "Accounting Periods Service" on page 198. for more details.pgfId-1053482
If at Ifat a later date, it is determined that the batch is associated with the wrong Accounting Period, you can modify the batch's Accounting Period affiliation at any time by running the Update Accounting Period entity bulk operation from a Batches list view. (By default, only members of the Accounting and Administrators groups can see and execute this entity bulk operation.)pgfId-1053277
Place a check mark in the Approval box for each general ledger batch you want to approve and click Next to continue.pgfId-1036939
You must approve at least one batch to complete the wizard.pgfId-1036930
Modify the default name of the Batches record, as needed, and click Finish to complete the wizard.pgfId-1036997
The system automatically defaults the GL batch name to include both the name of the general ledger batch type (Orders, Payments, or Scheduled Transactions), the name of the currency in parentheses,and the date on which the general ledger batch was created.pgfId-1033297Creating the Batches RecordpgfId-1033300
pgfId-1016241The wizard displays the set of Batches records it created. Double-click on a record to export the batch's information to a file that can be imported into your organization's accounting system.pgfId-1037012
If you choose not to export the file at this time, you can always export the file later by opening the appropriate record in the Batches service.pgfId-1037024
See for more information on creating a batch export file.pgfId-1037027