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
How to Manage Requests for Quotes in Sage 300 ERP and Sage CRM
by Sheila Zhang
I have been working on a project that the customer requested the ability to manage requests for quotations in Sage CRM and Sage 300 ERP. The Sage 300 ERP system has a function called Requisition in Purchase Orders module. You can create a requisition of an item without vendor and unit price information. You may need to invite your suppliers to bid on specific products or services....
Read More »
Tagged With:
email
,
Sage CRM
,
supplier
,
quotation
,
Sage 300 ERP
/ 3069 Views
Sage Summit 2013
by Kristi Feng
I very much enjoyed last week at Sage Summit. Thanks to everyone who came to our booth, I’m glad I got to meet all my friends there.
During the keynote session, we saw how the Sage mobile application works. Users can speak to their mobile phone with partial information and ERP data can be pull up instantly.
The data for this mobile application is from the Sage Data C...
Read More »
Tagged With:
Sage Data Cloud
,
Sage Mobile App
,
Sage 300 ERP
,
Sage Summit
/ 1948 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 »
Tagged With:
Accpac
,
Accu-Dart
,
integration
,
PO
,
Sage 300 ERP
/ 2630 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 »
Tagged With:
Accpac
,
LIFO
,
Sage 300 ERP
,
FIFO
,
inventory
,
inventory costing
/ 5330 Views
How CodePartners Develops an Export Program
by Sheila Zhang
Exporting data in
Sage 300 ERP
to some formatted files is a common request in Sage 300 ERP development. The export program can be very simple -- just a couple of hours work -- or be a highly functional program with multiple extra features.
Recently, we finished a project with some value-added functions. The client decided to implement the
SAP
system for their accounting modules, bu...
Read More »
Tagged With:
SAP
,
Expoert
,
Project Development
,
Sage 300 ERP
/ 1300 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 »
Tagged With:
Accpac
,
logon
,
session
,
customization
,
program
,
Sage 300 ERP
/ 3627 Views
How Customer Pricing Works in Sage 300 ERP
By Hrayr Galoyan
Several parameters affect what selling price Sage 300 ERP assigns by default in a new sales order. The price and extended price depend upon:
1. The customer selected
2. Customer’s currency
3. The ship-to location selected
4. Discounts defined in the pricelist
5. Ordering unit of measu...
Read More »
Tagged With:
customer pricing
,
item pricing
,
pricing
,
Sage Accpac
,
contract pricing
,
price list
,
Sage 300 ERP
/ 8308 Views
Streamlining Timecard Entry
By Emma Tsai
A few months ago, I had a conversation with a client about their existing timecard entry process. The client complained that they currently have their employees enter their daily timesheet on the internal web portal, but it takes them lots of time manually printing and entering these timesheets into PJC timecards and equipment usage in
Sage 300 ERP
.
CodePartners developed a solution ...
Read More »
Tagged With:
PJC
,
Sage 300 ERP
,
time entry
/ 2084 Views
How to Transpose a Data Table in Sage 300 ERP Take 2
By Kristi Feng
Several weeks ago Sheila showed
how to transpose GLAFS from columns to rows
.
Sometimes there is also a need to transpose rows to columns. For example, we want to see item quantities for a year in a row we can use the following SQL with ICHIST table.
The following two Transact...
Read More »
Tagged With:
Sage 300 ERP
,
MS SQL
,
Pivot
,
Tips and Tricks
/ 3180 Views
How to Create an Invoice with Data from a PDF File
By Jacky Xu
This week, we received a project that needed to get invoice information from PDF files and generate invoices in
Sage 300 ERP 2012
. We created many projects to generate invoices, so the unique part of this project is how to get the invoice information from a PDF file. The steps were simple:
1. Convert the PDF file to a text file
2. Make sure the format of the text file is ...
Read More »
Tagged With:
PDFBox
,
PDF
,
Sage 300 ERP
/ 1209 Views
Prev
1
2
3
4
5
6
7
Next
Search
Categories
General (166)
Development (158)
Success Stories (40)
Products (29)
Uncategorized (18)
BTerrell Group (5)
Project Management (22)
Web Development (57)
Web application (33)
Integration (19)
Mobile Development (7)
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 / 16200 Addison Rd. STE 270 / Addison, Texas 75001 / Phone:
214-647-2611
/ Toll Free:
866-647-2611
/ Fax:
214-647-2612
/
info@codepartners.com
© 2006 - 2015 codepartners.com All Rights Reserved.