Selecting General Ledger Integration Options for Accounts Payable

Sage 300 ERP

Home > Setting Up Accounts Payable > Integration with General Ledger > Selecting General Ledger Integration Options for Accounts Payable

Selecting General Ledger Integration Options for Accounts Payable

You use the A/P G/L Integration screen to select options that govern how Accounts Payable interacts with General Ledger, including when and how to create G/L batches and the type of information to send to General Ledger with posted transactions.

  • Make sure no one else is using Accounts Payable when you change options.

    Important! You can update some information while others are using Accounts Payable (such as the payables department phone number and contact person), but most options can be changed only if no one else is using the system.

  • Become familiar with the G/L integration options you want to change before you make any changes. For more information, see A/P G/L Integration Screen.

To change G/L integration options:

  1. Open Accounts Payable > A/P Setup > G/L Integration.

  2. Use the Integration tab to change options that determine how and when to process general ledger batches.
  3. Use the Transactions tab to change the information that is included with general ledger transactions. More...

    To edit information for a G/L transaction field:

    1. Either double click the field for the particular transaction header or detail, or select the field, and then click Open.

      The G/L Integration Detail screen appears, showing the transaction type and the G/L transaction field you selected on the Transactions tab. Use this screen to specify information from Accounts Payable transactions to use in G/L transactions.

    2. Specify information for the selected G/L transaction field, as follows:

      1. Select a character to separate segments of information. (The separator is used only if you assign more than one segment. The default separator is a hyphen.)
      2. To assign one or more segments to the selected transaction field, select the segment(s) from the Choose Segments From List, then click Include. More...

        You can assign a maximum of five segments to a G/L Transaction field, providing the combination does not exceed 60 characters. If the assigned information exceeds this number of characters (including separators), it is truncated when the transaction is posted.

        If you use Project and Job Costing, the names you chose for contract levels also appear (for example, Contract, Project, and Category).

    3. With the G/L Integration Detail screen open, you can edit information for other Accounts Payable transaction types, as follows:

      1. Select the transaction type or transaction detail type from the Transaction Type field.
      2. Select the G/L transaction field to which you are assigning information.
      3. In the Segment Separator field, select the symbol to use between information segments.
      4. Assign segments to include from Accounts Payable transactions, as described in the preceding instructions.
    4. When you have finished editing reference and description fields, click Save, and then click Close to return to the Transactions tab.
  4. When you are satisfied with your choices for G/L integration, click Save, and then click Close.
  • Print the G/L Integration report by clicking File > Print on the G/L Integration screen or by using the G/L Integration icon in the A/P Setup Reports folder.

Related Topics IconRelated Topics