Skip to Content
Sep 25, 2014 at 09:07 PM

Importing an Excel File with Quantities


We want to import an excel file into SAP B1. We will need to do this on a weekly basis.

How do we import it so that we can capture the following fields:

Scan number - 50 characters including special characters***

Description - 200 characters

Box number (scan 2) - 20 characters

Quantity - 10 characters (the ability to insert negative amounts)

We came across posts on how to import Excel files but none that mentioned special characters or quantities. Is it possible to overwrite pre-existing quantities?