CodePartners - Software Development - Dallas, Texas Software Development - Sage Accpac Customization - SageCRM Customization
Login
pay invoice online  |  remote assistance  |  
  • INTERNET APPLICATION DEVELOPMENT

    • Services
      • Web Application Development
      • Mobile Applications
      • Integration Solutions
      • Staff Augmentation
    • Technologies
    • How we work
    • About us
    • Success stories
    • Blog
  • MID MARKET ERP DEVELOPMENT

    • Intacct
    • Sage CRM
    • Sage
    • Sage Component Catalog
    • How We Work
    • About Us
    • Success Stories
    • Blog

Blog

CodePartners Blog

rss


How to Write a Sage 300 ERP Macro Based on Accpac RVSpy tool (Part 1)

by Jacky Xu

We needed to record a macro from Sage 300 ERP UI and convert it to our Sage 300 ERP project. But sometimes, we struggled to get a useful macro through the Sage 300 ERP record macro tool (E.g. Bank reconcile statement).

In general, we run the record macro tool first. And then we run UI and do some operations to get macro like below:

macro screen...
Read More »

On November 3, 2014 in Development [Post:by] Comment 1
Tagged With: macro, Accpac, Sage 300 ERP / 7014 Views

Importing Invoices from a Third Party Application - Customization

by Emma Tsai
Recently, I received a request from a customer who wants to generate AR invoices based on an imported Excel file from a third party application. The interesting part of this regular import is the sales taxes are imported from the Excel file, instead of being calculated by Sage 300 ERP. If the import file contains tax amounts, then the import process allows Sage 300 ERP to calculate th...
Read More »

On December 13, 2013 in Development, Integration, Success Stories [Post:by] Comment 0
Tagged With: Accpac, Customization, Invoice, Sage 300 ERP / 3245 Views

Creating Customized Client Reports in Sage 300 ERP

 
by Emma Tsai
Last week, I delivered an interesting project to a client. The client needed a customized spreadsheet that allowed them use a formula to create the new base price of an item when new options were added to a base component. 
For instance, if a customer ordered a base item with an option 1 and option A, our client wanted to increase the base price of the finished item by 5...
Read More »

On November 25, 2013 in Development, Success Stories [Post:by] Comment 1
Tagged With: Accpac, Customized reports, Sage, Sage 300 ERP / 4096 Views

Sage 300 ERP Customization: PO Receiving Slips Screen

by Emma Tsai
I recently received a request from a business partner who wanted to customize their PO receiving slips screen within their Sage 300 ERP system. To begin this customization, I modified their standard PO receiving slips screen to filter the PO receipt by date and vendor group.  
Next, I ensured all server and credential information were created in the set-up screen for their users....
Read More »

On November 6, 2013 in Development, Success Stories [Post:by] Comment 1
Tagged With: Accpac, Customization, Sage 300 ERP / 5714 Views

Integrating Sage 300 ERP with Coupa

by Hrayr Galoyan
“What on earth is Coupa?" I asked myself this when I heard about Coupa for a recent project. I quickly learned Coupa is a procurement system designed for businesses to simplify purchasing and ensure the users’ interaction is easy and enjoyable, as if you are shopping on Amazon.com. Technology supposedly makes our lives easier and more enjoyable. However,...
Read More »

On October 23, 2013 in Development, Products, Project Management, Web application, Web Development [Post:by] Comment 1
Tagged With: Accpac, AP invoices, Coupa, integration, procurement, purchasing, Sage, Sage 300 ERP / 4907 Views

Advanced Pricing Options in Sage 300 ERP

by Hrayr Galoyan

Sage 300 ERP has flexible functionality when it comes to defining item prices and discounts. One limitation is that you can only define volume discounts on a per-item basis. But, what if you want to define a volume discount for a group of related items? There is no way to do it in Sage 300 ERP.

Some time back, one of our customers needed exactly that, so we developed a custom so...
Read More »

On August 8, 2013 in General [Post:by] Comment 0
Tagged With: Accpac, pricing, Sage 300 ERP / 2471 Views

Integrating POs through Three Programs

By Jacky Xu

Last month we got a new request for a custom project for Accu-Dart. The client wants to keep temporary PO information before creating a Sage 300 ERP PO receipt and keep some POs to the same group. Then, they want to call the group number a control number. And these functions need to integrate with another system that will create PO information, after the other system fills the data to...
Read More »

On July 30, 2013 in Development, Integration, Success Stories [Post:by] Comment 0
Tagged With: Accpac, Accu-Dart, integration, PO, Sage 300 ERP / 3353 Views

FIFO/LIFO Costing in Sage 300 ERP Inventory Control

By Hrayr Galoyan

Sage 300 ERP has a very strong inventory control module, with different costing methods supported. Here’s how the FIFO (First In First Out) and LIFO (Last In First Out) costing methods are handled with Sage 300 ERP. Knowing internal mechanics helps if you even need to write a custom report and an application that should handle FIFO/LIFO costing.

Start by creating a new loc...
Read More »

On July 29, 2013 in General [Post:by] Comment 0
Tagged With: Accpac, LIFO, Sage 300 ERP, FIFO, inventory, inventory costing / 6848 Views

No More Stuck Sessions for Non-SDK Programs with Sage 300 ERP 2014

By Kristi Feng
Sage 300 ERP provides COM API to allow us to write programs to interact with the system. We usually use Session Manager to handle the sign-on, so we don't need to know a user's id and password. Session Manager uses the open session and if the user has more than one company open, it asks the user to select a company to open.
Starting with Sage 300 ERP version 5.4, if a user has mult...
    Read More »

    On July 19, 2013 in Development, General [Post:by] Comment 0
    Tagged With: Accpac, logon, session, customization, program, Sage 300 ERP / 12886 Views

    Sage 300 ERP vs. Intacct: Revenue Recognition

    By Hrayr Galoyan
    I like both Sage 300 ERP and Intacct, and will write a series of articles comparing various features of the two systems. Today’s article is about revenue recognition. I have some experience with it in Sage so when I learned that Intacct supports it natively, I couldn’t resist investigating.
    Basics of Deferred Revenue
    The basic need in any revenue recognition applica...
    Read More »

    On June 21, 2013 in General [Post:by] Comment 1
    Tagged With: Intacct, revenue deferral, revenue recognition, Accpac, Sage 300 ERP / 4238 Views
    12Next

    Search

    Categories

    • General (166) rss
    • Development (158) rss
    • Success Stories (40) rss
    • Products (29) rss
    • Uncategorized (18) rss
    • BTerrell Group (5) rss
    • Project Management (22) rss
    • Web Development (57) rss
    • Web application (33) rss
    • Integration (19) rss
    • Mobile Development (7) rss

    Archives

    • 2015
      • January (5)
      • February (7)
      • March (6)
      • April (5)
      • May (2)
    • 2014
      • January (13)
      • February (12)
      • March (13)
      • April (12)
      • May (11)
      • June (12)
      • July (11)
      • August (13)
      • September (10)
      • October (8)
      • November (6)
      • December (4)
    • 2013
      • April (73)
      • May (22)
      • June (20)
      • July (20)
      • August (22)
      • September (19)
      • October (13)
      • November (12)
      • December (7)

    Tags

    .NET Accpac app development application customization application development automation Azure C# cloud components Crystal Reports customization development ERP general ledger HTML5 Intacct Intacct Platform Services integration JQuery load balancer mass update mobile development OCR Order Entry outsourcing PO pricing product development project management REST Sage 300 ERP Sage CRM software integration trigger user interface Visual Studio web application web development website development Workforce Go! .NET ACA accpac Ajax Amazon AP invoices application development Arxis ASP.NET automation Axure BTerrell Group C# Cloud computing CodePartners Constant Contact credit card processing CRM crystal reports custom software Customer Service Customization Delete team project design phase Development doc-link DRILLDWNLK ERP event Excel GLAFS Intacct Intacct Advantage Intacct Platform Services Integration Java script JavaScript jQuery Kerr Consulting LinkedIn Microsoft MSSQL Offshoring outsourcing payroll PCI compliance PCI-DSS Pivot PJC project management sage Sage 300 Sage 300 ERP Sage Accpac ERP Sage CRM Smart Rule social media software testing SQL SQL Query SQL Server staff augmentation sub-ledger success success story TFS Trouble shooting UI design Visual Studio WCF Web API web application web design web development Webinar website Windows Windows Azure XML
    ABOUT US / CONTACT US / NEWS & EVENTS
    CodePartners / 17250 Dallas Parkway, Ste. 225 / Dallas, Texas 75248 / Phone: 214-647-2611 / Toll Free: 866-647-2611 / Fax: 214-647-2612 / info@codepartners.com
    © 2006 - 2015 codepartners.com All Rights Reserved.