How To Record Unused Check Numbers in GP

Keep Track of Unused Check Numbers

Many times, check stock will be forgotten in the printer and then printed on by accident. If you would like to keep track of wasted, unused check numbers in GP, here is a simple method.

  1. Go to Financial > Transactions > Bank Transaction Entry
  2. Option: Enter Transaction
  3. Type: Check
  4. Select the Checkbook ID
  5. Enter the Check Number
  6. Enter something descriptive in the Paid To field
  7. Leave the Amount set to zero
  8. You do not need to add another distribution account since it’s a zero transaction
  9. Click on Post

Your zero check will now appear in the Checkbook.

Need GP Technical Support?

If you need more Dynamics GP tech support, please contact CSSI for help. We can help with troubleshooting, training, customizations, and 3rd party app support.

Here’s a new Dynamics GP feature which was added in the GP 18.4 release – how to save inquiry window sort options.

This option is available in the following windows: Receivables – Transaction by Customer, Receivables – Transaction by Document, Sales Item, Payables – Transaction by Vendor, Payables – Transaction by Document, Bank Reconciliation – Checkbook Register, Checkbook Balance.

Select your default Sort by option then click on View > Save Window Preferences.

In addition to the sort options being saved, the “Include” Type (Work/Open/History) will be saved, along with the size of the window if you change it.

save-inquiry-window

These saved default settings are per individual user and are system wide, so the saved setting will default for any company that user logs into.

Need More Help with GP?

Hope that learning how to save inquiry window sort options is helpful for you! For GP technical support or help with upgrades, please contact CSSI.

GP Tip: Find Amounts in GP with GL Transaction SmartList

Here is an easy way to find everywhere that a particular dollar amount posted in GP.  Maybe an aging report doesn’t tie out to the corresponding GL account.  If you’re lucky, the amount of the difference could be one transaction.  Look for that amount with another Financial Accounts Transactions SmartList.

Open SmartList and expand the Financial folder then the Account Transactions folder.

Start with an existing list that contains the columns you want displayed in this new list. 

Click on the Search button. Filter on Debit Amount or Credit Amount. Add a Date Range filter, if needed. If you first searched on Debit Amount and didn’t get any results, try searching on Credit Amount next.

Click on OK to view results.

Remember, you can always double-click on a row to drill-down to the transactions.

Click on Favorites to save the new list with a new name.

Need GP Support?

If you need Dynamics GP support, or if you are ready to upgrade GP, we can help! Contact CSSI for help with GP.

GP Tip: Disabling GP Posting Journals

Ever wonder how to turn off those pesky Posting Journals that no one ever looks at, … or that you print to the screen or cancel?

Here’s how to do it!

  • Go to Microsoft Dynamics GP > Tools > Setup > Posting > Posting
  • Select a Series and an Origin
  • The list of Reports that appear will all be related to whatever Series and Origin you select
  • Uncheck in the Print column to not print the report at all
  • Or choose an option in the Send To columns to set a default destination
  • The question mark column means to Ask Each Time
  • The column with the monitor icon means to always print to the screen
  • The column with the printer icon means to always print to the printer
  • The file folder icon means to always print to a file.  If you choose this option, you will then choose Type of File, File Location and Append or Replace the file.  (Tip:  this is not usually a very helpful option as most GP reports do not look in any of these formats.)
  • NOTE:  Be careful not to change any of the other options in this window as this will affect how transactions post to the general ledger!
  • Click on Save when finished
disable posting journals in GP

That’s it!

Need Help with Dynamics GP?

CSSI’s team of GP experts are available to help you troubleshoot or upgrade your GP installation. Please contact us for help with GP.

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.

Protect control accounts in gp

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

microsoft gp control account tip

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.

GP remove discontinued inventory items 1

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.

GP remove discontinued inventory items 2

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:

  • This field is for validation purposes and should be left unchanged.

Microsoft Dynamics GP Partner 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
CSSI - Dynamics GP 2017 Year-end Processing Guide

 

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.