Archive for Import/Export

SAP Business One – How to Import AR Invoices, and then Import Applied Cash Receipts

Thanks to Don Shields for this overview on how to properly import Accounts Receivable (AR)  Invoices and then applied Accounts Receivable (AR) Cash Receipts into SAP Business One using the the Data Transfer Workbench ( DTW ). Templates: (RECOMMEND TAB DELIMITED TEXT FILES FOR IMPORTS with no text identifier, stay away from .csv) Make sure [...]

SAP Business One Importing Data from Excel

A very helpful tool to be able to create/edit large quantities of items in the Item master data is to generate an excel file with the information and then import it through the tool that SBO has for it. Since the documentation is rather poor, I’m not sure how to use all of the options, [...]