GP Tip: Protecting Your Control Accounts

Do you know how to tighten the reins on what can post where in GP?

A control account is an account within the general ledger that corresponds to a subsidiary ledger, such as Accounts Payable, Accounts Receivable, Cash and Inventory.  Normally, general journal entries should not be posted to these accounts because then they will no longer tie out to subsidiary reports.

You can prevent users from posting to these accounts by going to Financial > Cards > Account and unchecking the “Allow Account Entry” checkbox.

If a user tries to post a journal entry to this account, they will get the message below.

These accounts can still be posted to through the subsidiary module. And you can go back to Account Maintenance and temporarily recheck that box as needed.

Need Microsoft GP Support

Do you need technical support or consulting for GP / Great Plains? The team at CSSI is here to help. Contact us to get started with GP help.

Removing Discontinued Inventory Items

Do you have inventory items that you would like removed? Did you know that there is a process to accomplish this in Dynamics GP? Here’s how:

You can start preparing items to be removed during the year-end process by changing the item type to Discontinued. Go to Inventory > Cards > Item. Change the Type to Discontinued.

Items are tracked the same as Sales Inventory items in that you can still sell Quantities On Hand. You can also enter adjustments for the item and can delete the item when the quantity reaches zero.

You can also remove Discontinued items during the Inventory Year-End process.

Mark this option to remove the records for discontinued items that have been completely sold.  Items assigned the discontinued item type will be removed from the item records during the year-end closing process, unless there are quantities of the item, or one of the following is true:

• The item does not exist on an open transaction (sales document, purchase order, unposted inventory transaction).
• The item is assigned to a kit.
• The item is a component of a bill of materials.
• The item has one or more bills of materials of its own.

Need More GP Help?

Please contact CSSI for more GP help. We’d be glad to help with your questions, and provide Great Plains support.

Register now for a great CSSI webinar on Nov. 11….

There is a tremendous amount of vital operational data locked away in your GP databases that traditional reporting does not and cannot analyze. Harnessing this underutilized and constantly growing data is absolutely critical to your decision-making process and means the difference between success and failure for your organization.

Webinar Registration: Learn About Power BI Report Pack For GP

Join us for a webinar on Nov 11, 2021 at 11:00 AM EST. Attendance is limited so register now to assure your seat at the Power BI table. After registering, you will receive a confirmation email containing information about joining the webinar.

What is Power BI Report Back For Dynamics GP

The Power BI – Report Pack for Dynamics GP is an affordable Data Analytics and AI reporting product containing 100+ pre-built dashboard reports. These pre-built Dashboard Reports surface all of your GP data spanning GL, AR, AP, Sales, and Revenue Analysis, Inventory, and Purchasing. The Report Pack will give you a real 360-degree view of your entire operation using data analytics and AI enabling your decision makers to make quicker and more data-driven decisions for your organization. There is no other pre-built Power BI solution on the market and CSSI Technologies has this solution.

Management Reporter is a powerful interactive financial reporting tool used with Microsoft Dynamics GP and other ERP systems. Management Reporter allows Controllers, Accountants, and other Finance team members to create custom reports without the help of their IT team. Ease of use, native Active Directory integration, and scalability are just a few of the reasons why Management Reporter is a great reporting and financial statement tool.

In this recorded webinar, the CSSI Technologies GP team provides a tutorial on Dynamics GP Management Reporter tutorial for beginners. This is part 1 of a 2 part series (see part 2 here – Intermediate Management Reporter Tutorial).

This Dynamics GP Management Reporter tutorial includes:

• Management Reporter overview
• Report structure – report definition and how to build a report
• Running reports – sample report outputs, and how to export reports to Microsoft Excel

Management Reporter can be used as a report designer for many different types of financial data reports:

• Income Statement
• Balance Sheet
• Cash Flow Statement
• General Ledger

Ready to move on to the second webinar in this series: Did you miss the first webinar in this series, GP Intermediate Management Reporter Tutorial? Click here to view.

CSSI can support you with report creation and training using Management Reporter, Power BI, and SSRS (SQL Server Reporting Services) and other tools. Interested to learn how CSSI Technologies can help to support your Dynamics GP usage, or to learn about future webinars? Contact us:

Microsoft Dynamics GP users — it’s time for year-end processing. To help you out, the GP team at CSSI has prepared an update guide with a whole bunch of notes and time-saving tips. Our free Microsoft Dynamics GP Year-End Processing Guide contains tips and guidance on:

• What to do before your year-end close
• Recommended order for closing sub-ledgers
• Modules which are mandatory vs. optional for year-end closing
• Notes on tax-table updates

Click here to get your free download: [Download not found]

CSSI is a certified Microsoft Dynamics GP partner with over 25 years of experience supporting Great Plains ERP users in Pennsylvania, Delaware, Maryland, New Jersey and New York. CSSI works with GP users in a broad range of industries, such as manufacturing, distribution, warehousing, construction, hospitality, healthcare and education. CSSI’s team of experienced GP and accounting professionals is complemented by teams dedicated to custom software development as well as auto ID (barcoding and RFID) and mobile computing technologies.