Recently we had a request come in from one of our X3 customers regarding their increasing need to process inventory adjustments to correct mis-keyed supplier lot data  on inventory receipts. As this field is left untouched by all of the lot maintenance and edit utilities currently available in X3, we opted to develop a simple utility of our own to do this.

[Read the rest of this article...]

In Sage ERP X3, the number of address codes by business partner is controlled by the activity code BPR.  By default it is set to 30 but can be set as high as 9999.   The activity code is managed on a folder basis so you would if you wanted to make the change in all of your folders, you will have to change them individually.

[Read the rest of this article...]

Creating Custom SQL Based Sage CRM SalesLogix Groups for SalesLogix Territory Realignment

I manage our internal installation of Sage SalesLogix CRM (we still use SalesLogix for Sales and Marketing; we currently use Microsoft Dynamics CRM for Service and Support. We are in the process of migrating all of our xRM activity to Dynamics CRM as our single xRM solution). One of the things I’m frequently asked to do is re-align accounts and contacts from one rep. to another. Reasons vary for this, but most frequently it’s to accommodate some sort of ad hoc marketing activity.

[Read the rest of this article...]

A Novel use for Landed Cost and an Explanation of Dynamics GP Landed Cost Postings and Options

This week I’ve been working on a deployment where one line of business sells containers of material which is purchased to order. The ultimate goal is to provide them with very accurate margin analysis on these container Sales Transactions both as a business measure and to provide feedback into their quoting process. Our client is coming from QuickBooks where they’ve been using ‘Job Cost’ to accumulate and report on these costs.

Most of these orders are coming overseas and have both import and overland freight and duty fees, etc. etc. associated with them.  Since these transactions have variable indirect and direct costs and they’re purchased to order, we needed to come up with a way to track both budgetary and actual costs against a  PO without having to go to a Project Solution (which would’ve taken too much setup and maintenance).

[Read the rest of this article...]

Resolving Application Errors in Integration Manager on x64 Servers 

[Read the rest of this article...]

When Is It Time to Spend On IT?

In our Government Practice, we find that as budgets get tighter, there is an increased spend on technology and infrastructure geared toward creating efficiencies. This seems logical inasmuch as spending some money to save more money really makes sense as I write it. However, this isn’t often the case with privately owned companies. More often than not, we find that as the economy slows, IT spending decreases as the focus tends to shift to revenue generating activities.

[Read the rest of this article...]

Microsoft Dynamics GP Users Summit Briefly Previews GP version 11.0

[Read the rest of this article...]