Help Center>Journal Entry Solution Help

Split documents

If you have more line items than can be entered in a single journal through SAP, you can split the document (if this functionality has been enabled by your Journal Entry developer).

You need to know the name or number of an SAP reconciliation or offset account so that all the documents that result from a split can be balanced.

Important:
This first method will not work for FB60, FB65, FB70, or FB75, because those t-codes include amounts in the header. If you are using one of those t-codes, see Split documents for FB60, FB65, FB70, FB75.

Journal Entry cannot split a column-based document that contains multiple loops at the same level.

If you do not split the document, the results vary, depending on the mapping:

  • Cell-based: Journal Entry posts the number of rows that is specified in the script's document length setting.
  • Column-based: Journal Entry runs the entire document, even though it exceeds the document length. Any rows that exceed the SAP limit will not be posted.

Split document: Upload large documents

  1. Enter all of your data
  2. Validate your data.
    We recommend this step, because it ensures that your document balances prior to the split.
  3. To split your document, click the Split button on the Journal Entry ribbon.

    split button in the actions group

  4. Choose how you want to split the document:
    • Insert the split lines without changing the document balances. This means that you will have to balance the document manually.
    • Insert the split lines balancing the document, or autobalance, which means that Journal Entry will balance the document for you.

    For this example, I am choosing to autobalance the document.

  5. Provide the reconciliation account information (if it has not already been provided by the Journal Entry template developer). Then click OK.

  6. After the split, you can see that the split rows have been inserted and that an amount has been added to balance each document.

    First document:

    Second document:

  7. After the document has been split successfully, you can post the documents to SAP by clicking Post. The document links are returned in the Posting Result cell:

Split documents for FB60, FB65, FB70, FB75

  1. Enter all of your data
  2. Validate your data.

    We recommend this step, because it ensures that your document balances prior to the split

  3. To split your document, click the Split button on the Journal Entry ribbon.

  4. Choose how you want to split the document:
    • Insert the split lines without changing the document balances. This means that you will have to divide the header amount manually to balance the document. If your document contains tax amounts, choose this option.
    • Insert the split lines balancing the document, or auto balance, which means that Journal Entry will balance the document for you. The amount value in the split line will be equal to the sum of debit/credit amount of the other lines in that chunk.
  5. For this example, I am choosing to auto balance the document.

  6. Provide the reconciliation account information (if it has not already been provided by the Journal Entry template developer). Then click OK.
  7. Note that the split row is inserted above the data set to account for the header amounts in these transactions.

  8. After the split, your vendor line (first line item) will be updated to represent the new amount needed to balance the first document.

    The header rows inserted by the split will be added with the vendor and amount needed to balance the additional documents.

  9. After the document has been split successfully, you can post the documents to SAP. The document links are returned in the posting results cell.

    Splitting documents that are based on BAPIs

    After you split a document in a Journal Entry solution that is based on a BAPI, you need to manually update the Accounting Document Line Item numbers.