We get a lot of questions in support about how to process prepayments in accounts payable in Acumatica. Prepayments are used when you need to create an advance payment or a down payment to a vendor. There are two ways to create a prepayment. Standard way: enter the prepayment in the Bills and Adjustments screen. … Read more
Missed our GP year-end events? No worries, here’s a recap of the important changes: W-4 form change for 2020 Changes for Employee Self Service W4 form and Cards | Payroll | Tax window (required table changes) No W-2 or ACA form or EFW2 electronic file changes No Payables form changes (1099s) Fixed Asset Luxury Auto Depreciation changes … Read more
The 2020 Round 1 tax update has been released. There are new federal tax tables published based on 15-T, including new head of household status, and withholding tax tables. Additionally, FICA social security limit for 2020 is increased to $137,700. State updates include: California Illinois Iowa Kentucky Maine Michigan Minnesota Missouri North Caroline North Dakota … Read more
If you work in accounts payable, you know that check runs can be a pain, and would welcome any ways to expedite the process of printing checks. Crestwood to the rescue! Did you know that in Acumatica, you can add a digital signature to checks before they print? Here’s how: Adding the Signature to the … Read more
Valuation methods are what determines how the costs of inventory items are calculated. There are several different methods you can use in Microsoft Dynamics GP. I recently had a client question how the various Inventory Valuation Methods in Dynamics GP differ. In this client’s case, the valuation they were using did not make sense for … Read more
Microsoft Dynamics GP has been a mainstay in the ERP community. Designed for small and mid-sized businesses who want a reliable and well-vetted solution, GP has evolved and grown to be one of the most trusted ERP vendors for this market. However, no matter how consistent this solution is, no matter how powerful, there are … Read more
When your legacy Enterprise Resource Planning (ERP) solution is having trouble keeping up with your business, it’s important to weigh your options carefully before you decide whether to upgrade to a new version or make the switch to different software. I recently worked with a client to determine the best course of action for their … Read more
Microsoft Dynamics SL has long been the go-to for project-based businesses in need of a focused solution that delivers financial management, project management and accounting, distribution, field service, payroll, e-business, and more. However, while it does do many things well, there are certain areas where it could be improved, better customized, or better supported. 1. … Read more
All accounting professionals know the importance of a well-designed Chart of Accounts (COA). Whether you’re new to Microsoft Dynamics GP or a seasoned veteran, you’ve pulled the COA report for yourself and the other business leaders within your company. Have you ever wanted to customize it, though? Our team gets this request a lot. Commonly-Requested … Read more
I recently helped a Microsoft Dynamics GP client create a SmartList to pull in purchase order numbers for shipments and match receiving lines. Additionally they wanted to see the number of the receiving line. To accomplish this I created a SmartList Builder Report from the SmartList “Receiving Transactions.” Here’s how: The trick is we had … Read more
Life would be so boring without change, don’t you think? We know that Microsoft agrees with that! One big change is coming that we wanted to make you aware of: the new, modern portal for submitting support requests for all Dynamics products (like Dynamics GP, Dynamics SL, and Dynamics 365 Business Central). Microsoft is working … Read more
Attention Dynamics SL Users: You’ll notice a lot of “Dynamics GP” language used below – that’s only because we used Dynamics GP for our presentation. Management Reporter works exactly the same in Dynamics SL! Management Reporter (MR) in Dynamics GP is known for the valuable financial data it can offer — and in turn the … Read more
I recently had a customer call me and describe that their batches were taking a long time to release in Microsoft Dynamics SL. They have Cash Manager installed and configured properly, but any batches in Cash Manager, Check, or AP Payments, were taking forever to release. They even tried to cancel the release and redo … Read more
One of the most commonly asked questions from my Microsoft Dynamics GP customers is – how do I see how much I paid a certain vendor by GL account? For example: if you need to see all the legal fees paid to several different law firms, where do you go to get this information quickly … Read more
Many times I get asked questions about what all the different dates in Microsoft Dynamics GP do and or mean. All the dates in Dynamics GP can be confusing. So, I created this handy overview to help you out. Basic User Dates Thanks to Jen Kuntz for her post. User Date: Your “User Date” … Read more
I recently came across a client that had issues accessing new Items, Customers, and Vendors. The issue wound up being relatively simple; it was because when these things were setup in Dynamics GP, the Entity Relationship in Multi Entity Management was not setup. What is Multi-Entity Management? If you use multiple companies in Dynamics … Read more
Have you made your plans to go to Phoenix with me for GPUG Summit October 15-18? Great! Send me an email and we can meet up for a meal or a drink that week. Please let me know if you haven’t registered and I will send you a special code to save you 10%! GPUG … Read more
We occasionally get requests from our Microsoft Dynamics GP users to clear unused receipts in the deposit window (Transactions>Financial>Bank Deposits). Sometimes a customer starts to use the bank reconciliation for the first time, or maybe someone just lost track of receipts and they never got posted. No matter the reason, here’s how to clear receipts. … Read more
Have you ever encountered a Purchase Order in Microsoft Dynamics GP that was still open but should be closed? I had a customer run into this problem recently. Here’s what I did to fix it. First, I reviewed the Purchase Order process the client used. We entered a PO like this one. Next, we entered … Read more
I recently got a call from a client and their Scribe integrations had stopped working. This can be very frustrating and hinder your business’s performance. Why would this happen, and how do you fix it? There’s lots of ways to go about finding the problem and fixing it, but here’s what I did to hopefully … Read more
We often receive calls from our clients when auditors want to review security. Microsoft Dynamics GP offers several security reports you can run for audits. How to print the Dynamics GP security reports Go to Reports>System>Security. In this window, you’ll see the list of available reports. The most common reports that auditors look for are: … Read more
I recently helped a customer solve an issue with their Purchase Order (PO) in Microsoft Dynamics GP. They had changed the cost on an inventory item, but the new item cost was not showing up on the PO. Why is this? Here’s what happened First, my customer had changed the “Current Cost” of an item … Read more
Most people export a .csv file of their Trial Balance Detail report right from Microsoft Dynamics GP for their audit team. However, you usually end up spending more time than you would like cleaning it up, re-formatting, and manipulating it first. Sound familiar? Here’s an easy solution: Export using SSRS Instead of exporting from Dynamics GP … Read more
Are you using the Dynamics GP Fixed Asset module? You should be. You own it as part of the Starter Pack (if you are on GP 2013 or later). The Dynamics GP Fixed Asset module can do everything you need for your depreciable and non-depreciable assets. Here are 9 reasons for using the module: Group … Read more