Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

AnchorpgfId-1003600pgfId-1003600If the user did not create the general ledger (GL) export file during the wizard process, the file may be exported from the Batches service at a later point in time.

Follow these steps:

...

  1. 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. AnchorpgfId-1057435pgfId-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. AnchorpgfId-1057436pgfId-1057436
  • When generating a GL batch export file, users can include Accounting Period data in that file, if desired. AnchorpgfId-1057663pgfId-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. AnchorpgfId-1057936
pgfId-1057936 If this option is not selected, the accounting period is not included. AnchorpgfId-1058044
pgfId-1058044 Note: By default, the Include Accounting Period Data in Export File box is note checked. If you want to have this option checked by default, an administrator can set the Batches entity's IncludeAccountingPeriod entity attribute from 0 to 1. <add this to a note macro>

  1. AnchorpgfId-1057407pgfId-1057407Verify 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. AnchorpgfId-1033329pgfId-1033329 Anchor4069440694 Batches Record GL Entries Tab AnchorpgfId-1033332pgfId-1033332anchorpgfId-1011314pgfId-1011314
  2. 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). AnchorpgfId-1038200pgfId-1038200
  3. When prompted, modify the Effective Date for the batch, if necessary. Click OK to continue. AnchorpgfId-1038220pgfId-1038220 Change Effective Date AnchorpgfId-1038253pgfId-1038253   AnchorpgfId-999390pgfId-999390  
  4. 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.

    AnchorpgfId-1033337pgfId-1033337 Anchor6032760327

     Saving the GL Entries File

    AnchorpgfId-1033340pgfId-1033340   AnchorpgfId-999395pgfId-999395 AnchorpgfId-1047984pgfId-1047984

      

    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>

    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:

    Anchor
    pgfId-1048262
    AnchorpgfId-1047944pgfId-1047944
  5. Select Save .

AnchorpgfId-1041205pgfId-1041205If you selected an existing batch file that already appears in the specified location, choose from the following options when prompted:

...

  • pgfId-1041206Yes: Appends the batch information to the current file. AnchorpgfId-1041207pgfId-1041207
  • No: Overwrites the current file with the batch information. AnchorpgfId-1041208pgfId-1041208
  • Cancel: Cancels the current export option. AnchorpgfId-1041240pgfId-1041240 Export Batch Options AnchorpgfId-1041317pgfId-1041317  

...

  •   
  1. 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. AnchorpgfId-1038361pgfId-1038361 Batch Export Confirmation AnchorpgfId-1038379pgfId-1038379