Showing archived posts for: November 2016


Microsoft Dynamics SL: AR or Inventory (IN) Issues Batch Created in Order Management Show as Void

Posted by Michael Broadmeadow, Senior Support Analyst on November 22, 2016

Have you ever encountered the following in Microsoft Dynamics SL? You are running Order Management in Dynamics SL You have AR or Inventory batches (IN) that are voided but appear to have data in them. You are missing AR invoices or IN transactions. The most common cause for this…

Read More

Dynamics SL VBA Debugging in Production

Posted by Joe Jacob, Senior Developer on November 21, 2016

Have you ever tested Microsoft Dynamics SL VBA code in a production environment?   Users don’t always like developers “messing” with their systems, but sometimes it’s necessary. It’s best practice to debug on a test environment, limiting any unwanted contamination of…

Read More

Error with Multiple Upgrades in Dynamics CRM

Posted by Brandon Richards, Implementation Manager on November 14, 2016

If you’re trying to upgrade Microsoft Dynamics CRM from a very old version to a newer one, make note.  I recently had to upgrade a client from Dynamics CRM 4.0 to 2013 SP1 and kept running into a problem.  The Dynamics CRM 2013 SP1 installation kept failing! Here&rsquo…

Read More

Exploding Detail on a Report in Acumatica with the Analytical Report Manager (ARM)

Posted by Tiffany Bennett, Senior Consultant on November 14, 2016

Here’s a great one for your Acumatica reports.  You can explode, yes explode is what Acumatica calls it too, your account detail out on your reports.  This is helpful when you want to simplify having to set up all that account detail on a report. …

Read More

Reporting from Dynamics CRM Online: An Introduction to FetchXML Part 2

Posted by Mike Giuffre on November 14, 2016

In Part 1 of Reporting from Dynamics CRM Online: An Introduction to FetchXML, I explained how important your Advanced Find is for creating your FetchXML SQL Report.  To quickly recap, FetchXML is a way to bring data from Dynamics CRM Online into a SQL Report.  Hopefully you’re…

Read More

Reporting from Dynamics CRM Online: An Introduction to FetchXML

Posted by Mike Giuffre on November 14, 2016

There are basically 2 options for reporting on data in Microsoft Dynamics CRM Online. Using the built-in wizard – which is great for basic reports, but isn’t very flexible. SQL Reporting services – using FetchXML to retrieve your Dynamics CRM Online data. What is FetchXML? FetchXML is a proprietary…

Read More

Clearing Locks in Dynamics GP Manufacturing

Posted by Carla Duquette on November 10, 2016

Ever hear of database locking?  Microsoft Dynamics GP does it all the time.  Basically, a database will temporarily lock a record while someone is working in it, just to make sure no two people try and change the same record at the same time.  It’s…

Read More

Consolidating Shipments and Shipping Separately in Acumatica

Posted by Mike Aichinger on November 10, 2016

Did you know you can save yourself time and money by creating shipments in the Process Orders form in Acumatica?  Quite often, I notice people generally creating shipments using the “Create Shipment” option in the Sales Order form.  However, this action only creates a single shipment…

Read More

Customizing Your Email Messages in Acumatica:

Posted by Mike Aichinger on November 10, 2016

2 Options to Modify Report Notification Messages One of the great features of Acumatica is the ability to email reports to your customers.  For example: Customer Invoices Sales Orders Shipment Confirmations Purchase Orders Great!  However, the tricky part is modifying the verbiage in the emails.  In Acumatica, there…

Read More

Get More Power from Your Acumatica Reports

Posted by Tiffany Bennett, Senior Consultant on November 8, 2016

Statistical Reporting with Acumatica Analytical Report Manager (ARM) Many clients we work with like to track statistical data in combination with their financial information.  This can be a powerful tool for management to track many business measures.  These statistical items can be tracked in a ledger, just like…

Read More