Anchor
Follow these steps:
...
- Open the appropriate general ledger batch record from the Batches service to begin the export process.
...
- All of the standard header information including name, general ledger batch type, who started the general ledger batch, who approved the general ledger batch, date started, effective date, and currency type is displayed on this record.
Anchor pgfId-1057435 pgfId-1057435 - Each of the records included in the general ledger batch is displayed in the list on the Orders tab if it is a general ledger batch of orders, on the Payments tab if it is a general ledger batch of payment records, or on the Scheduled Transactions tab if it is a general ledger batch of scheduled transaction records.
Anchor pgfId-1057436 pgfId-1057436 - When generating a GL batch export file, users can include Accounting Period data in that file, if desired.
pgfId-1057663Anchor pgfId-1057663
In the Export Batch prompt, select the include Accounting Period Data in Export File option to include a batch's Accounting Period ID and the Accounting Period Name. pgfId-1057936 Anchor
Anchor pgfId-1057407 pgfId-1057407 Verify the GL account information on the GL Entries tab. This tab displays the general ledger account information, including a description and a list of the Debit and Credit account entries.Anchor pgfId-1033329 pgfId-1033329 Anchor 40694 40694 Batches Record GL Entries TabAnchor pgfId-1033332 pgfId-1033332 anchorpgfId-1011314 pgfId-1011314 - Export the general ledger batch into a file that can be used by an external GL accounting system by clicking the Export Batch button (circled in the figure above).
Anchor pgfId-1038200 pgfId-1038200 - When prompted, modify the Effective Date for the batch, if necessary. Click OK to continue.
Anchor pgfId-1038220 pgfId-1038220 Change Effective DateAnchor pgfId-1038253 pgfId-1038253 Anchor pgfId-999390 pgfId-999390 In the Save As dialog box, choose the directory location for the export destination. The name is automatically generated, but may be modified for clarity.
Anchor pgfId-1033337 pgfId-1033337 Anchor 60327 60327 Saving the GL Entries File
Anchor pgfId-1033340 pgfId-1033340 Anchor pgfId-999395 pgfId-999395 Anchor pgfId-1047984 pgfId-1047984 Note Concerning Default Export Type: In the Save As dialog, the default Save as type is tab delimiter (.txt). However, an administrator can modify this default value by modifying the configurable attribute found on the Batch entity. Below is a description of the attribute:
pgfId-1048262Anchor pgfId-1048262 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.
<add this to a note macro, including the title>Anchor pgfId-1047944 pgfId-1047944 - Select Save .
Anchor
...
pgfId-1041206 Yes: Appends the batch information to the current file.Anchor pgfId-1041207 pgfId-1041207- No: Overwrites the current file with the batch information.
Anchor pgfId-1041208 pgfId-1041208 - Cancel: Cancels the current export option.
Anchor pgfId-1041240 pgfId-1041240 Export Batch OptionsAnchor pgfId-1041317 pgfId-1041317
...
- After selecting Save, a dialog box displays stating the location and file name of where the General Ledger entries have been written. Click OK to close the message.
Anchor pgfId-1038361 pgfId-1038361 Batch Export ConfirmationAnchor pgfId-1038379 pgfId-1038379