The B1 Tools Custom Importer module allows you to import CSV files right from inside Business One.
The Custom Import module comes with a property mapper with which allows you to create your own 'Import Templates'. This maps the columns in your CSV file to the properties on the Business One document header and lines.
Custom Importer is a module of B1 Tools.
Makes it much easier for users as it's simply another function in Business One.
Imports from a single .csv file so no need to set up multiple files with duplicated data.
Has a built-in mapper which makes it easy to map your file columns to Business One fields.
Define and save custom mapping templates and then re-use these to quickly import your data.
Do a test run of the import to validate your mapping and data.
Most objects types can easily be imported as Drafts.
Sales A/R:
Purchasing A/P:
Inventory:
Other
Note: Most transactions can also be imported as Drafts.
The B1 Tools Custom Importer is the easiest way to import sales and purchasing documents and Journal Entries from CSV files into Business One.
Get a 30 Day Trial by Downloading and Installing B1 Tools