SS01 AudingInCode
Acumatica Cloud ERP

How to Leverage Acumatica’s Auditing in Code

Auditing Feature Summary Let’s start with a refresher on what Auditing is in Acumatica and how to set it up.  Acumatica’s ERP allows a user to track changes made to almost any Acumatica field. Let’s say you want to track whenever a credit line value is changed for a customer

by Joe
Read More
Teams Lock1
M365 and Copilot

How to Resolve File Lock Issues in Microsoft Teams

Microsoft Teams has many great collaboration features for sharing files.  At times, you might receive one or more of the following issues, all regarding file locking.  If you encounter one or more of these messages, try following the resolution steps below. Problem Messages in Teams: Other messages include warnings that

by Joe
Read More
SyncTeam1
Cloud Hosting

Sync Team files with OneDrive for Quicker Access

One of the many benefits of Teams is that you can sync a Teams Channel file space with your local OneDrive.  This allows you to work with files locally without touching the Teams interface. This works great when you need to jump to and from several different files throughout your

by Joe
Read More
Default Value1
Acumatica Cloud ERP

How to Set a Default Value to Auto-fill in Acumatica

Tips from Acumatica Development I recently had a request to set a default value on a grid with the value of the field from the line above it. Let's suppose you want to default the quantity on the Bills and Adjustments screen, with the quantity from the prior line.  Consider using

by Joe
Read More
DSL Credit
Dynamics SL

How to Fix Dynamics SL Credit Manager’s Assistant Screen Bug (SQL Server Message 517)

What happened? Remember Y2K?  Well this isn’t nearly as bad, but a new Microsoft Dynamics SL bug surfaced recently (on June 6th, 2019) for many users.  You could be receiving a “SQL Server Message 517” when running the Credit Manager’s Assistant screen without specifying a date range. The reason for

by Joe
Read More
TeamsSmartsheet1
Acumatica Cloud ERP

Smartsheet Integration with Microsoft Teams

Our award-winning development team is located all around the country. To stay connected and organized, we have been using an app called Smartsheet to great success. Smartsheet allows us to enter a project – from Dynamics GP upgrades to an Acumatica customization – and as it progresses, we can add

by Joe
Read More
SkypeTracka
M365 and Copilot

Skype for Business Tracking Chat and Call Durations in Outlook

Did you know that you can track your Skype chat conversations in Outlook, track call history, and durations?  It can be a useful tool in regard to tracking time with clients or projects.  Here's how I use it. First make sure your Skype Options are set properly.  For some companies

by Joe
Read More
Custom1
Acumatica Cloud ERP

Acumatica Development – Adding GI’s to a Custom Project for Deployment

When a user creates a new GI on their environment the system will auto assign a Screen ID.  This is fine unless you are developing a Custom Project package for deployment to another site.  If you do not change the screen ID to be unique then your deployment might fail.

by Joe
Read More
Source Control ACU1
Acumatica Cloud ERP

The Right Way to Use Source Control for Your Acumatica Customization Packages

Summary Many aspects of a custom solution for Acumatica can be done within the confines of a Visual Studio Project. However a customization project package must still be maintained within an instance of Acumatica.  Here’s a simple method of exporting and importing those changes to be captured by source control.

by Joe
Read More
1 1
M365 and Copilot

Automating Outlook Calendar to Send Daily Agenda

Make my agenda come to me... I love the quote from the overly-ambitious Senator Underwood in “House of Cards.” He was talking to Freddy, a blue-collar owner of a restaurant. Freddy was telling him about his ride to work when he had to swerve to avoid a refrigerator that fell

by Joe
Read More
shortcuts1
M365 and Copilot

Visual Studio – How to Remember 1,000 Shortcut Keys

How many productive Microsoft Visual Studio shortcut keys have you learned but managed to forget? I used to have a shortcut key created using AutoHotkey that would allow me to get to a Word document with a collection of (less often used) shortcuts as a cheat sheet. I recently decided

by Joe
Read More
Vid1
Acumatica Cloud ERP

How to Make Video Help Files in Acumatica

If a picture is worth a thousand words, then what is a video worth? A lot, as it turns out! I am an ERP developer, not a writer, yet I used to spend a lot of time writing instructions or explaining concepts in lengthy documents.  I’ve moved away from writing

by Joe
Read More
B1
Acumatica Cloud ERP

Create a Custom Button to Launch an Acumatica Screen Pre-Loaded with a Record

Here’s a great time-saving project I recently did. I had a customer who wanted a button on a screen in their Acumatica system to launch the Journal Entry window.  Not only did it launch the window, they wanted that screen loaded with data provided from the source page of the

by Joe
Read More
Cdrive1
M365 and Copilot

Upgrade your Drive C: to a bigger SSD drive

Save time upgrading your hard drive.  Here’s how to upgrade your drive C: with more space, without having to reinstall Windows from scratch. Items that you'll need SSD drive to replace the one you have installed. USB thumb drive USB drive with enough space to back up your entire C:

by Joe
Read More
Skype tag
M365 and Copilot

How to Tag People on Skype

Have you ever had that important question, and just wanted to ping someone quickly for the answer, but when you pull them up, you realize they are busy or presenting?  UGH.  Then, you move on and totally forget later to ask? Here’s a great little trick – Tagging You can

by Joe
Read More
Mouse
Cloud Hosting

Mouse Lagging on Remote Connections?

Most of the time I work remotely. It saves me travel time and saves my clients money.  I’m usually connecting to client systems with various VPN’s, etc. Once in awhile, when I’m VPN’d in somewhere, my mouse acts weird. It moves very slowly, like it’s underwater. I found a quick

by Joe
Read More
hack2
General ERP

The #1 Hack to Get More from your Work Day

There are tons of articles on the internet about multi-tasking, and we all do it to varying degrees. However, the research, not to mention common sense, points to the fact that you are better off focusing on one task at a time. Clutter is the Mind Killer Have you ever

by Joe
Read More
AutoHotkey
General ERP

Simple Shortcuts to Make You More Productive Every Day

Extend the life of your fingers and shave minutes off just about everything you do.​ As a software developer I live and breathe shortcut keys.  I use them to quickly navigate between screens, auto type out the current date and time, type my email address, and generate commonly used SQL

by Joe
Read More
General ERP

SQL Table Copy SP

Do you ever get tired of typing 'Select * INTO SourceTable02417 FROM SourceTable' to make a quick backup of a SQL Sever table? I did, so here's a quick and dirty little stored procedure to take care of that manual process. Here's how it works: When you call this Procedure

by Joe
Read More
from ben
M365 and Copilot

Quick Email Searching Tip

Here's a HUGE time-saving tip when searching for an email in Microsoft Outlook and Office 365. Who, what, and when are the key.  Just follow these simple syntax rules, and you'll be amazed how easy it is to find those emails. Replace Who with FROM: ​Replace What with ABOUT: Replace When

by Joe
Read More
SkypeHistory 1
M365 and Copilot

How to Find Call History and Duration Information for Skype Calls

If you use Skype for Business, you can always go in and look at your call history.  However, did you know, if you dig a little bit, you can also get the exact time, date and duration of the call?  There might be other methods of retrieving this information, but

by Joe
Read More
Skype 1
M365 and Copilot

Skype for Business – AutoDial from Microsoft Office

If you are using Microsoft's Skype for Business and Microsoft CRM, have you noticed that the phone numbers in CRM are hyperlinks?  You can click on the links and the system will automatically launch Skype with the phone number all ready queued up to dial. However, did you know that

by Joe
Read More