Procedure documentationCreating Notas Fiscais with MS Excel Upload

 

To manually create notas fiscais with many line items more easily, you can upload import data in a special view of the Nota Fiscal Writer from an MS Excel file.

Note Note

This functionality is currently only available for notas fiscais for imports, that is for a nota fiscal of type import with CFOP for import and import ADI.

End of the note.

Prerequisites

You have made the necessary Customizing settings in Customizing for Cross-Application Components under Start of the navigation path General Application Functions Next navigation step Nota fiscal Next navigation step NF Document Maintenance Next navigation step Define MS Excel Layouts for Dat Upload End of the navigation path. For more information about these Customizing settings, see the system documentation for the Customizing activity in the IMG structure.

Procedure

  1. Run the J1B1N_IMP transaction.

  2. On the initial screen, enter the nota fiscal type, the organizational data, and ICMS/IPI information. For more details about these entries, see Creating Notas Fiscais.

  3. In the MS Excel Upload group box, browse to the location of the MS Excel file on your hard drive.

  4. Select the layout for this MS Excel file. Note that you can only select from layouts that have been recorded in your Customizing.

  5. Enter the rows in the file where the import data to be uploaded (not column header data!) starts and ends.

  6. Choose Continue.

    The system uploads the data from the MS Excel file and fills the fields on the following screens that have been mapped to the columns in this MS Excel layout in Customizing. On the Import Data tab page, the system lists the document IDs for the import documents, if available.

    Note Note

    You can also enter in the MS Excel new columns for assigning specific tax types. In this case, after uploading the MS Excel, the system overwrites the customizing by the value you have added in the MS Excel file.

    End of the note.

  7. Enter all other relevant data.

  8. Save your entries.

Result

The system automatically creates a print request for the nota fiscal according to the rules defined for the nota fiscal form. You can then print the nota fiscal if needed.