Function documentationBatch Importing

 

You can automate and simplify the processing of multiple bill of exchange documents by using the batch import function. Batch import lets you process large volumes of bill of exchange documents with one action; thus enables you to work quickly and efficiently by minimizing manual processing.

You download an Excel template file from the Work Center and maintain all the master data for the bill of exchange document in this Excel file. When you upload the file the system, the systems checks to see if a duplicate bill of exchange ID number exists; if so, an error message displays.

Prerequisites

  • The bill of exchange documents have the status Draft or Created

  • You are logged into the SAP system with the user role Cashier or Treasury Manager

Activities

  1. From the Bill of Exchange Management home page, choose one of the following options:

    • Start of the navigation path Bill of Exchange Receivable Next navigation step Create Batch BoE Receivable from Excel End of the navigation path

    • Start of the navigation path Bill of Exchange Payable Next navigation step Create Batch BoE Payable from Excel End of the navigation path

  2. If you do not have the bill of exchange batch import template file, then you need to download it. Click the Download Excel Template link and save the file to your hard drive.

    The bill of exchange master data is maintained in this Excel file.

    The Counting Overview page displays

  3. Enter master data in the Excel file and save it

  4. On the Batch Import Bills of Exchange page, click Import

  5. Locate the Excel file using the Browse function and then click Upload

    The bills of exchange are listed under the Batch Import Bill of Exchange panel.

  6. Click Save

Example

Mary has received over fifty bill of exchange receivable documents that need to be created in the system. Creating each of them in the system would take at least one full day. Rather than individually creating the bill of exchange document one at a time, she maintains the master data in an Excel sheet. One hour later, she uploads the template, along with he data, in the system. The system creates multiple documents based on the data in the template. The batch import function has helped her work quickly and efficiently. She now has time to move on to other tasks.

More Information

You can add customizing fields and additional logic checks when doing batch import in Customizing for Financial Accounting (New) under Start of the navigation path Financial Accounting Global Settings (New) Next navigation step Country-Specific Settings Next navigation step China > Bill of Exchange Management Next navigation step Business Add-Ins (BAdIs) Next navigation step BAdI: Batch Import End of the navigation path.