Andrew Karasev, Alba Spectrum LLC, help@albaspectrum.com, http://www.albaspectrum.com, 1-866-528-0577 , subdivision of M2-D2, SAP Business One VAR and Reseller in Illinois, Georgia, South Carolina, California, Texas. Please visit our info portal Pegas Planet: http://www.pegasplanet.com. Local Service in Chicago, Atlanta, San Diego, Los Angeles, Orange County, Houston. We also have SAP Business One Software Development Factory and SB1 Technical Support Call Center, serving USA country side businesses and internationally: Canada, Brazil. Illinois practice: Naperville, Aurora, Plainfield, Marseilles, Ottawa, DeKalb, Springfield, Oakbrook, Glenn Ellyn, Wheaton, Bolingbrook, Romeoville, Lisle, Melrose Park, Brookfield. San Diego and LA practice: Rancho Bernardo, Oceanside, Poway, Long Beach, Irvine, Mission Viejo, San Marcos, Carlsbad, La Jolla, Escondido. Houston Practice: Dallas, Galveston, Sugar Land, Pearland, Katy, Pasadena, Rosenberg, League City, Galena Park
Sap B1 ERP is on the rise in gaining its ERP and MRP for small and mid-size businesses market share. This publication should help you in your next accounting software selection, as well as in deciding on who will be your SB1 VAR or Reseller and Implementation Partner. When you are in software selection phase you should see SAP Business One presentation and in this demo you should identify which functionality fits your business processes and where you might need modifications. We will give you highlights on SAP B1 software development and programming, plus integrations
1. First, if you are programmer, please know that in SB1 you can only do select statement, but you can not modify or insert data into SAP B1 tables directly, as you probably did with your legacy ERP application, such as Great Plains, for example. SAP Business One installation controls your direct database access in order to prevent possible data integrity problems
2. SAP Business One SDK programming. Your SAP B1 customization partner should give you custom logic estimation. Modification should be programmed in SB1 Software Development Kit. SDK programming should be entrusted into certified SB1 SDK developer hands, and SDK is available for SAP Business One Certified VAR. Programming itself could be done either in VB or C# in Visual Studio .Net. If your SB1 implementation crosses US borders, then you should know that your custom module should be separately compiled for A and B versions (where version B is international). Plus you should be aware about future SAP Business One customization upgrade cost – as custom code will need to be verified and recompiled in the new version. Current SB1 version is 2007A and B. If you are upgrading from 2005, you will need to recompile it
3. SB1 Workbench and Integration methods. If you got it working with Excel templates and this is OK for you, then the following paragraph should be skipped. However if you do not like Excel way, you should consider ODBC queries instead, where you can go and try advanced SQL scripting: select, union, group by, having clauses for example
- Related Videos
- Related Articles
- Ask / Related Q&A




The Right Price of Nintendo DS Games
By: Manish Sharma | 10/07/2009I was very happy when I learned The Price is Right came to the Nintendo DS. No one consider The Price is Right at the beginning of the Nintendo DS - judge, but for you.
Crosswords DS - Nintendo DS Games
By: Manish Sharma | 10/07/2009Why? Because I can solve the puzzles without using a crossword puzzle dictionary. The crossword puzzles in this game, at least on the easy levels, won't drive you nuts. If you're interested in Nintendo DS top games for word lovers, you might want to give this a try.
Small business CRM
By: Paul | 10/07/2009Unlike the big organizations, small businesses have different customers, different rules to abide with hence different needs and here is when the need of a Small Business CRM is felt.
CRM Software Solution- The new breakthrough
By: Paul | 10/07/2009A new approach to build and retain customer base and business known as CRM Application (Customer Relationship Management) has taken the world by storm. A completely new industry has emerged in the past few years.
Four Common Questions about Computer Animation
By: Benicio Brown | 10/07/2009This article answers four common questions that people ask regarding computer animation. What is computer animation?, What is the difference between computer animation and traditional animation?, Why are there so many computer animation programs?, and What is the right computer animation software for me? Answers are written in a concise non-technical style.
Great Plains Support: Chicago, San Diego Dynamics GP Partner Newsflash
By: Andrew Karasev | 09/07/2009If you have Microsoft Dynamics GP, formerly known as Great Plains Dynamics, eEnterprise, or even Great Plains Accounting for DOS and Windows, regardless of the version, please read your local and nationwide ERP and MRP support highlights.
Best Windows Registry Fixer
By: Ricky Lim | 09/07/2009Many satisfied users have accepted that among many registry clean up programs RegCure is definitely the best registry fixer. You will also find other registry fixers like the Registry TuneUp, RegSweep, Error Smart, Registry Easy, Registry Fix, etc., and each one is equipped with features so that the registry troubles can be fixed.
Proper time and attendance management for efficient workforce planning
By: Pooja Rai | 09/07/2009A proper workforce planning schedule ensures that the organization has access to a workforce that has the desired skills and competencies needed for its future growth. This process involves planning for the future while keeping in mind the goal and objectives of that organization.
Great Plains Support: Chicago, San Diego Dynamics GP Partner Newsflash
By: Andrew Karasev | 09/07/2009 | SoftwareIf you have Microsoft Dynamics GP, formerly known as Great Plains Dynamics, eEnterprise, or even Great Plains Accounting for DOS and Windows, regardless of the version, please read your local and nationwide ERP and MRP support highlights.
Dynamics GP ecommerce programming: eConnect, Dexterity, SQL Scripts
By: Andrew Karasev | 08/07/2009 | SoftwareIf you already have Microsoft Dynamics GP, formerly known as Great Plains Dynamics, implemented in your company, and you also have established and in-house supported ecommerce application, it is natural next step to automate integration.
Dynamics GP Sales Forms Modification in Report Writer notes
By: Andrew Karasev | 07/07/2009 | SoftwareIf you have Microsoft Dynamics GP ERP, formerly known as Great Plains Dynamics and eEnterprise, implemented in your organization, it is often the case that you need custom reports, especially Sales Invoice, Order, Return, Backorder, Quote
Dynamics GP Partner San Diego, Chicago Newsflash: Version Upgrade Checklist
By: Andrew Karasev | 06/07/2009 | SoftwareMicrosoft Dynamics GP, formerly known as Great Plains Dynamics and eEnterprise, could be purchased and supported via Dynamics GP Partners channel. The specific of partner channel service dictates the rule of having Dynamics GP VAR of record at any particular time.
Dynamics GP Supply Chain Management Notes
By: Andrew Karasev | 05/07/2009 | SoftwareMicrosoft Dynamics GP, formerly known as Great Plains Dynamics and eEnterprise, has good selection of native modules: SOP, POP, Inventory Control, Purchase Configurator, plus you could find various Add-ons or custom modules, supported by Dynamics GP ISV partners
Dynamics GP in Retail Business: Implementation and Integration Notes
By: Andrew Karasev | 04/07/2009 | SoftwareIf you are at the point of decision on Microsoft Dynamics GP, formerly known as Great Plains Dynamics, implementation for Retailer with multiple retail stores, we would like to describe “solutions”, which could be deployed in your organization.
Dynamics GP Logistics and Barcode Add-ons notes
By: Andrew Karasev | 03/07/2009 | SoftwareIf you have Microsoft Dynamics GP, formerly known as Great Plains Dynamics and eEnterprise, implemented in your organization and the next phase in your ERP and MRP developing is Logistics, Warehouse Management, Consignment
Dynamics GP Warehouse Management and Barcode Solution Notes
By: Andrew Karasev | 02/07/2009 | SoftwareSupply Chain Management automation, including Warehouse Management, Inventory Control with Batch Mode or Real Time Barcoding, Consignment, Shipping and Receiving, Trucks Scheduling, Rentals and Warranty Contracts – these business processes are often too unique for hoping to get all the standard functionality through Dynamics GP ISV channel Add-Ons