PT Sterling Tulus Cemerlang
www.sterling-team.com

Whatsapp
+62-877-8655-5055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower Level 30
Jl Jend. Sudirman No. 45-46
Jakarta 12930 – Indonesia

500+ FREE Tips SAP Business One for you to Become SAP B1 Super User from Sterling Tulus Cemerlang (STEM)

Import Business Partner Data from Excel

SAP Business One Tips - SAP Gold Partner Indonesia - Upload with Excel Format to SAP Business One



There are many options to upload data to SAP Business One, you can use Copy Table feature, use Data Transfer Workbench, and also use Microsoft Excel.

It will be easier if you using Microsoft Excel, that because you must be already have a prepared data on excel format (.XLS or .XLSX), right? You don’t need to make another format for upload process to SAP Business One.

Also read:

This is how to do:

  1. Make sure that your data on all column already sorted correctly
  2. You can’t use any header, so delete it first.
  3. That will be better if your excel format is .TXT (text file)
  4. Then, logon to SAP Business One
  5. Choose menu Administration > Data Import/Export

  6. Choose Data Import > Import from Excel
  7. On Import from Excel window, choose Data Type to Import: Business Partner
    Select your file from browse button.
  8. Choose and match your column position from your file with column in object
    Example:
    On your .xls file, you have 2 columns, Column A filled with BP Code, and Column B filled with BP Name.
  9. Choose your Import Method, you can choose base on your own preference, commonly, a lot of people use “Add New Records and Update Existing Records“.

Also read:

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang
More details about SAP Business One,
email to: sales-enquiry@sterling-team.com or call +6221-5806336 or wa +6287786555055

, , ,