How to change G/L integration options in Sage 300 Accounts Payable

Steps

  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.
To edit information for a G/L transaction field:
a. 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.
 
b. Specify information for the selected G/L transaction field, as follows:
i. 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.)

ii. To assign one or more segments to the selected transaction field, select the segment(s) from the Choose Segments From List, then click Include.

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).
 
c. With the G/L Integration Detail screen open, you can edit information for other Accounts Payable transaction types, as follows:

i. Select the transaction type or transaction detail type from the Transaction Type field.

ii. Select the G/L transaction field to which you are assigning information.

iii. In the Segment Separator field, select the symbol to use between information segments.

iv. Assign segments to include from Accounts Payable transactions, as described in the preceding instructions.

d. 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.

After selecting G/L Integration options

  • 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.

Support

If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.