Help Center>Step-by-Step Guides Help

FB70 multi-company, column-based

See an FB70 example workbook.

  1. Enter the relevant header data into the template (cells C2-J2 by default).
  2. Enter the relevant line item data into the template (columns U-AG), including the company code for each line item (column AG).

    The first line item will be the header account and amount that you are familiar with in SAP.

    • If you choose R (Invoice) as the business transaction, your first line item needs to be assigned posting key 01.
    • If you choose G (Credit Memo) as the business transaction, your first line item needs to be assigned posting key 11.

    line item details for fb70 including company code

    To add another document, type the header and line item information for that document starting on a row below the last line item of the previous document.

  3. In the Id Column, enter an H for each header item and a D for each line item.

    header and line item identifiers

  4. After all the relevant data has been entered, click the Validate button to verify that all required fields have been entered and that the document is balanced.

    validate button and balanced message

  5. After validating, click the Simulate button to test each line item against the header details in SAP.

    If you are not logged on to SAP, you will be prompted to log on.

    If no errors are returned a Success message, is displayed in the Simulate Log Column (column AH).

    simulate button with success message

    Important: If your document is large and you need to split it, please see Split documents for instructions.

  6. If the simulation is successful, you are ready to post, which you can do by clicking the Post button.

    After the journal entry is posted, the document link is returned in the Posting Result Column (column M):

    post button with document links