In this blog, we will be looking on fetching the data from Sage 300 Views with BlkGet function using COMAPI in C# .Net. Sage 300 has many ways to read the records using CS0120 view by querying the database, opening and composing the Business Views. Reading of the data can be done one at a time using the Field Name or Field Index or getting the list of Field Values all together for the specified indexes.
The BlkGet method is effective as there is no need to read the single value at an instance of time and the whole set of values can be stored in an object at once.
New Stuff: How to use BlkGet to fetch data from Sage 300 using COMAPI in VB6.0
We will be looking into the steps to create a program of the same with a sample code of AR Customer.
Step 1: Include the Sage 300 COMAPI in the project.
Step 2: Once the Advantage DLL is included, create the object of the Session and initialize it.
Step 3: Create, Open and Compose Sage 300 Views.
Step 4:
- Read the data using the index value (IDCUST in our example).
- Fetch the data using BlkGet
First parameter of BlkGet is for accepting the field index whose values are required.
Second parameter of BlkGet is an out object which populates the field values at the same position as that of an Index Array.
Developer can include any number of field index in an Array that are required for performing a particular task.
The list of values fetch for particular set of condition is now available and stored in an object for further processing.
About Us
Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation competence.
Greytrix offers unique GUMU™ integrated solutions of Sage 300 with Sage CRM, Salesforce.com, Dynamics 365 CRM and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration services for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and for Sage 300c development services we offer, upgrades of older codes and screens to new web screens, latest integrations using sData and web services to Sage business partners, end users and Sage PSG worldwide. Greytrix offers 20+ addons for Sage 300 to enhance productivity such as GreyMatrix, Document Attachment, Document Numbering, Auto-Bank Reconciliation, Purchase Approval System, Three way PO matching, Bill of Lading and VAT for Middle East. The GUMU™ integration for Dynamics 365 CRM – Sage ERP is listed on Microsoft Appsource with easy implementation package.
For more details on Sage 300 and Sage 300c Services, please contact us at accpac@greytrix.com, We will like to hear from you.