SAP,Business,One,Data,Import,I computer SAP Business One Data Import: Items and Prices overview for
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
If you are SB1 consultant, you probably know how to import databy filling Excel templates for such objects as Item, Price, Warehouse QTY. This is very popular method, however try todo more complex integration logic: you need to discontinue old items andreplace them with new items, where you need to take the price from old item andassociate it with the new replacement. Something like this is definitely possible in Excel, if you are able toprogram Excel Database connection and query. Well, try something more complex when you have variable item classesand for each class price update has unique formulae. In this small publication we do not agitateyou to purchase additional third party tools, such as iBolt or do SAP BusinessOne SDK integration programming we will be explaining how to do complex dataimport in SAP Business One Workbench 1. ODBC source. ODBC is a way more flexible, comparing to Excel template based CSVfiles. If you choose ODBC connection you can create SQL View as the base and this SQL view in turn could be of heterogeneousnature (pulling data from Microsoft SQL Server 2000, Oracle, Pervasive SQL,Ctree, Microsoft Access database, tab delimited text file to give you the idea) 2. SQL DTS Package method. Assuming that we are taking ODBC route you candecide to mark records, already integrated by update script, which could bepart of MS SQL Server DTS package 3. SB1 2007A Data Transfer Workbenchlimitations. Please, note that currentlySAP doesnt support batch file and data integration scheduling, however if youare using CSV files batch file should work fine 4. Items and Pricelist. We recommend you to try the followingapproach create SQL View, which returns data in the same format as Exceltemplate for oItem object. Please, payspecial attention to field names they should coincide with the names in Exceltemplate (however you do not have to provide all the field names only requiredand important in your SAP B1 inventory module). Item Price is dependant object to the Item in Item import cluster
SAP,Business,One,Data,Import,I