Set Document Splitting Page

To access this page:

1. In Data Workbench, display the Data page.
2. Select Set Document Splitting in the page toolbar.

In this topic:

Edit Split Options Dialog

Use this feature to split line items in financial transactions such as a journal entries (FB50) when uploading more than 999 line items. The page lists all the transaction codes that have been configured to split the line items into separate documents.

	Icon	Description
	New	Click this to configure a new transaction code for line item splitting.
	Edit	Click this to Edit the line item split configuration for the selected transaction code.
	Delete	Deletes the line item splitting configuration for the selected transaction code.

Edit Split Options Dialog

Field	Description
Transaction Code	The transaction code for which you want to enable the split configuration.
Split at Line Item	The number of line items that you want to split the documents into.
Enabled	Check to apply the split configuration to uploads with the applicable transaction code.
Clearing Account Number	When the document is split, each document must be balanced, typically with a clearing account. Enter the clearing account number to use to balance the document during the split.
Amount Field Name	The field in the transaction that represents the amount field.
G/L Account Field Name	The field in the transaction that represents the G/L account.
Append Split Information	Check to append a sequential number to the end of a reference field.
Reference Field Name	The field where the split information (sequential number) will be appended.
Debit/Credit Field Name	The field name in the transaction that represent the Debit/Credit indicator.
Debit Indicator	The value that represents debit.  Usually S.
Credit Indicator	The value that represents credit.  Usually H.