|
|
-
Viccomp specializes in customizing Microsoft Great Plains and
Solomon, or Dynamics GL and Dynamics SL, and CRM.
-
Great Plains Auto Posting.
-
Data Integration and Conversion with data like Quicken, MySql, and other data sources.
-
Customizations from form and report modification to complex processes like
changing the flow of data entry.
-
With tools like Dexterity, eConnect, Visual Studio and VS Sdk, Crystal Report,
Form and Report Writer, Integration Manager.
-
Also with Sql Server Reporting, Visual Basic, C#, VBA, and Solomon VB
Tools.
-
Write stand alone programs with Microsoft Access, Visual
Basic.Net, Crystal Report, Stored Procedures, and T-Sql.
-
We wrote this website with Visual Basic and C# .Net, and we can also create Sql
Server database website including Web Services.
-
Please use the Service Request page to request for more work experience
and a free consultation.
-
Great Plains and Solomon Customization Successes (please
request for more about the project information and other experience):
-
Project 1:
Create and update Dexterity, Report Writer programs to work with complex
reports. Writing codes to print custom Accounting Statements, Trial Balance
reports, Sales Orders, Invoices, Returns, and Collection Letters for
sub-companies. Also debugged other programmers work.
-
Project 2:
Create and update with Dexterity, Report Writer, Crystal Report to
work with Sales Order and Manufacturing Sales Configurator. Also work with
Create Automatic Returns with the Sales modules. Adding many Crystal reports to
work with the Manufacturing and Sales module data. Also debugged other
programmers work.
-
Project 3:
Create Dexterity and Visual Basic programs to automatically integrate Accounts
Payable, Project Accounting, Analytical Accounting, Sales Order, and Accounts
Receivables modules data for batch posting and single posting. The programs
create custom billing fees based on users percentage, and save many manual work
for the users. Extensive analysis and testing were done to assure data are
integrated correctly and accurately.
-
Project 4:
Create Great Plains, Visual Studio Sdk, and eConnect front and background
Visual Basic.Net programs to transfer Excel and Text data into Great Plains.
Modules include General Ledger, Accounts Receivable, Accounts Payable, and
Project Accounting. The program involves Queuing Service, XML, Ado.Net, .Net,
and other software. The program also allows the users to select data sources
and destination companies to integrate the data files.
-
Project 5:
Create a Solomon to convert its General Ledger accounting data into popular tax
program using complex Visual Basic Tools methods and codes. Creating mapping
tables to accurately convert Solomon data into the correct fields in tax
program.
-
Project 6:
Create Solomon custom forms and reports for Accounts Receivables, Accounts
Payables, and Inventory modules. Placing the reports in User Report folder and
creating manual with security for the forms and reports for the users.
-
Project 7:
Create and update Dexterity program to work with Human Resource tables, and
data to automatically update User Defined fields in Human Resources Payroll
tables. The process will be run during the processing of payroll checks, and
records necessary payroll data in a custom table.
-
Project 8:
Use Dexterity and Visual Basic to write an add-on screen to show data from
Inventory, Sales Order, and Manufacturing modules. The data include Quantity On
Hand, Quantity On Orders, Quantity Available, Quantity In Use, Quantity Sold,
Minimum Order Quantity, Maximum Order Quantity, List Price, Quantity Period to
Date, Quantity Year to Date, Sales Amount Period to Date, Sales Amount Year to
Date, Manufacturing Quote Quantity, Manufacturing Open Quantity, Manufacturing
Complete Quantity, and other Quantities. The users just need to enter an Item
Number or select it from Great Plains’ Inventory Item Lookup Window.
-
Project 9:
Use Form Modifier to add new data fields to Sales Order Entry window. Write
Visual Basic for Application (VBA) to manage the data fields and show various
totals. The program can verify the user entries. Also use VBA to modify
Inventory Popup window to show Order Counts and Print Counts for the users to
view.
-
Project 10:
Convert from an existing accounting program’s data into Great Plains. Using
Access, Visual Basic and Great Plains’ Integration Manager, the General Ledger
text files are converted or transfered into Great Plains. The programs updated
the General Journal Entry data files, General Ledger Account file and other
associated files. The programs do many data verification tasks before actually
converted into Great Plains.
-
Project 11:
Use Visual Basic and Dexterity to write conversion programs to transfer data
from a Point-of-Sales system to Great Plains. Also write another program to
transfer data from Great Plains to a Point-of-Sales system. The middle files
are in text or ASCII format. The programs perform data verifications in both
ways.
-
Project 12:
Write a Microsoft Access Conversion Program to convert Great Plains and Excel
Payroll and Invoice files into Access file format. Create Analysis Reports from
the resulting data files. Create a Great Plains Dexterity Payroll Data Entry
screen as an add-on interface to Great Plains’ Receivable Management Module.
-
Project 13:
Add new data fields to Great Plains’ Sales Order Entry windows like weight,
special quantities. And then Write a Visual Basic for Application program to
update and find the totals for the added-on data fields. Also need to update
the Subtotal, Tax, Discount and Total for the SOP window screen. Use Report
Modifier to update a few SOP reports with new data fields and totals.
-
Project 14: Write a Microsoft Visual Basic Data
Conversion Programs to convert CMS Payroll and Invoice Text files into Great
Plains e-Enterprise Sql Server files. Over thirty Sql Server files are updated
in the background. Write an Invoice Lookup Program to look up Invoice data in a
Microsoft Visual Basic.
-
Other Customization Successes (please request for more
experience about the project information and other experience):
-
Project 1:
Create an eBay Seller website under Viccomp using ASP.Net with Vb and C# and
third party components to automate eBay seller selling process. There is a
scheduled program running in the background on the website to bring data from
eBay periodically like item categories, css data to present graphical items on
the pages, xml data for sellers to select items. The program has all the
maintenance screens and reports to print eBay’s buyer, seller, items, shipping,
bidding and other data. Accounting functions like ordering and invoicing are
also automated. It also automates processes like item listing, re-listing,
revising, feedback, second chance offering to buyers and others, using .Net and
eBay Api functions.
-
Project 2:
Write various kinds of reports in Microsoft Access to present an summarize
clients’ data in an organized pattern. Some of the reports are Accounts
Receivable Aging Report/Summary, Accounts Payable Aging report/Summary, AR
Gross/Net Profit Reports, AR Top Income Reports, Monthly/Yearly Income
Analysis, Credit Returns Report, Sales Return Report, Invoice Summary, Accounts
Payable Reports, Inventory Reports, Chart of Accounts Report, Accounts
Receivable Summaries, Accounts Payable Summaries and many other reports
(involved complex calculations). Also create a Rebate Entry Program in
Microsoft Visual Basic to record their rebates received from the mail. Create
various Rebate Reports to do daily summary for the manager to review everyday.
-
Project 3:
Convert from an existing accounting program’s text data into Sql Server data
using Xml files and Xml Converter. Using Visual Basic as a front program to
select various text files and also to select destination Sql Server table to
convert into. The Xml Converter validates business rules for the Sql Server
files.
-
Project 4:
Write an ASP.Net application with Vb and C# to fill order on the webs. The
users are able to enter orders and view order list counts with a click of the
button and web menu. It uses Sql Server and Ado.Net to manage the databases in
the background.
-
Project 5:
Write an ASP.Net business application with Vb and C# for the service company on
the webs. The users are able to enter use demonstrations and view company
information with a click of the button and web menu. It uses Sql Server and
Ado.Net to manage the databases in the background.
-
Project 6:
Fix and improve an ASP application. Use Ado and T-Sql to fix and improve the
website application for entering property management and membership
information. Also use Javascript and Vbscript for writing the web program.
-
Project 7:
Use Microsoft Access to create a Quote and Purchase Order program to automate
the quote and Purchase order process. The program includes various maintenance
screens and reports for the user to edit/view and print data. The conversion
process enables the user to convert a quote into a purchase orders and be able
to work with multiple manufacturers.
-
Project 8:
Add and update a comprehensive Credit recording program in Access Project and
Sql Server. Use extensive Sql Server Transact Sql statements, Stored
Procedures, and Ado accessing methods. The program helps order entries,
generate billings, various reports. It is the main program for the users to run
their business.
-
Project 9:
Write a Microsoft Visual program to manage property management and client
information. The program allows the users to browse and edit the property and
client information with look up window and editing screen. The program also use
Word Automation to send data to Word to create forms to print to the printer.
The whole process is automatic.
-
Project 10:
Write a cash receipt program in Microsoft Access to record decoder leased and
received from customers. The program can zoom into Customer tables to select
customers, items and accounts. Balances and Discounts are automatically updated
as data are entered. Built in error checking mechanisms to report to the user
if a questionable entry was made. Various database tables are updated as the
data are entered in the network environment. There are also Monthly Billing
Report to generate billings and a Posting Program to post invoices generated to
Platinum Accounting System.
-
Project 11:
Write Crystal Report likes Sales Work Order Report, Sales Report, Sales Ledger
Report and other reports using Crystal Formulas and Grouping functions. Also
Use SubReports to perform look-ahead for subtotals.
-
Project 12: Write various kinds of reports in
Crystal likes Gross Margin MTD/YTD Report, Income Statement Detail MTD/YTD
Report, Sales Analysis Report, Sales Criteria Report, Sales Ledger Report and
other reports using Crystal Formulas and Grouping functions.
|
|
|