How To Generate a List of Unreconciled Bank Transactions in GP

Creating a List of Unreconciled Bank Transactions in Dynamics GP?

Here is an easy way to create a SmartList of unreconciled Bank Transactions. Go to Microsoft Dynamics GP > SmartList. In SmartList, navigate to Financial > Bank Transactions. Select the option with the asterisk.

Click on Columns and then the add button to add the columns that you would like to appear in the SmartList. Click OK when you are finished.

Next, click on the Search icon. Add the restrictions to the SmartList. Set the checkbook ID equal to your checkbook ID, set Voided equal to no and set Reconciled equal to No. Then click OK.

This will give you the list of unreconciled transactions. Click on Favorites and give your report a name. Then click Add > Add Favorite.

Contact CSSI for GP Technical Support and Training

For GP help and training, please contact CSSI. Our team of experts stand by to assist!

Printing Separate Checks to Vendors, One Check Per Invoice

Have you ever had the need to print separate checks to one vendor, one check per invoice?  GP provides three different options for doing this.

1. If you want to always print one check per invoice for this vendor, go to Vendor Maintenance, select the Vendor, click on Options, and changed the setting highlighted below.

2. If you use the Build Payment Batch window, there is a “One Payment Per” option.  You can select Use Vendor Option, which will look at each vendor’s option shown in method # 1 above.  Or you can select “Invoice”, which will create one payment per invoice (for all vendors in this “Build”).

3. Use different Remit To address IDs in AP invoices.  When you enter an invoice in Payables Transaction Entry, you can change the Remit-To ID.  Each Remit-To ID will receive a separate check.  For example, if you enter three AP invoices for the same vendor, with each invoice containing a different Remit-To ID, then that vendor will receive three checks.

That’s it!

Need Dynamics GP Support?

Do you need technical support or training with Dynamics GP? Contact the GP experts at CSSI for help.

Copy/Paste General Journal Entries from Excel

This is an oldie but goodie. Simplify journal entries by copying and pasting into GP from Excel.

1. Set up the Excel Spreadsheet with four columns in this order:

a. Account Description, Account, Debit Amount, Credit Amount
b. Add a row for each line of data entry and create a balanced General Journal entry

2. Select and copy the data from the Excel spreadsheet. Do not copy the column headings.

3. Open the Financial Transaction Entry Window by going Financial > Transaction > General

  • Create a Batch ID (Optional)
  • Enter the Transaction Type (Standard or Reversing)Enter the Transaction Date
  • Source Document Code will default
  • Enter Reference
  • Currency ID will default

4. Place the cursor in the Account field and click on the Paste option at the top of the menu bar

5. The paste action will populate the journal entry

6. Save the transaction in a batch or Post

    Contact us for GP Help

    If you need help or support with Dynamics GP, please contact CSSI.

    GP Tip: Dynamics GP Posting Setup

    Did you ever wonder why you sometimes have batches that need to be posted in the General Ledger even when your posting setup is set to “Post Through General Ledger Files”? The first “Post Through General Ledger Files” checkbox setting will automatically post transactions assigned to a batch through the General Ledger. The second “Post Through General Ledger Files” checkbox will automatically post transactions through the General Ledger at the transaction level, meaning transactions will be posted to the GL even if they are not assigned to a batch.

    The transaction level Post Through General Ledger Files setting is available on the following posting setup windows:

    Need Dynamics GP Support?

    Need more GP support? Our experienced team of GP consultants is standing by to help. Please contact us to discuss your GP support needs.

    GP Tip: How to make customer or vendor info a GL Transaction Smartlist favorite

    You can take advantage of Dynamics GP’s Smartlist feature in many ways to save time. Here’s how you can make customer and vendor information a favorite in the GL Transaction Smartlist….

    Go to Microsoft Dynamics GP > Smartlist and open Smartlist. Then click on Account Transactions.

    Click on Columns.

    Click Add.

    Scroll to Originating Master ID. Hold down CTRL and select Originating Master ID and Originating Master Name.

    Then click Ok.

    You will then see the Originating Master Id and Originating Master Name displayed on the smartlist.

    Save the smartlist by clicking Favorites. On the Add or Remove Favorites Window give the smartlist a Name and click Add, Add Favorite.

    That’s it! Hope this helps.

    We Provide GP Technical Support

    You should have a GP partner who is responsive and helpful to your needs. Our team of experienced GP experts are ready to provide fast and friendly service when you need it. Contact CSSI for GP support or help?

    GP Tip: How to bring back the navigation pane

    Have you ever had the Navigation Pane disappear while using GP? Here’s how you can bring it back yourself!

    The solution is to click the Layout Button in the top right corner of Microsoft Dynamics GP. Unselect and then re-select the Navigation Pane option.

    When you select the Navigation Pane option the Navigation Pane will then be displayed in GP.

    That’s it!

    Need GP Technical Support

    If you would like GP help, training, or upgrade support, the team of GP experts at CSSI would be glad to help. Please contact us for GP help.

    GP Tip: Save time by copying GP price lists

    If you assign many different Price Levels to your items, then setting up a new inventory item can be time-consuming.  Save time by coping Item Price Lists from one item to another.  (Note:  both items must share the same unit of measure schedule.)

    1 – Go to Inventory > Cards > Price List
    2 – Select an item you want to copy TO
    3 – Click on the Copy button

      4 – Select a Source Item Number (the item to copy FROM)

      5 – Click on Process
      6 – Print the Copy Price List Audit Report to the screen to verify that the copy was successful
      7 – Make any necessary changes
      8 – Click on Save

      Need GP Technical Support?

      If you need help, training or technical support with Dynamics GP, please contact CSSI for help.

        GP TIP: Wondering how to prevent certain documents from appearing on a vendor check stub?

        If you have fully applied documents that you do not want to print on a vendor’s check stub, you can go to the Edit Vendor Payment window.

        This window is available in the Build Payment Batch window.

        prevent-docs-vendor-stub-1

        It is also available in the Edit Payment Batch window.

        prevent-docs-vendor-stub-2

        Or you can go to Purchasing > Transactions > Edit Vendor Payment.

        prevent-docs-vendor-stub-3

        Click on the Check Stub button at the bottom of the window and uncheck the checkboxes beside those documents that you do not want printed on the check stub.

        prevent-docs-vendor-stub-4

        Need More GP Technical Support?

        If you need help or training with GP, please contact CSSI to discuss your needs.

        A’ Go To’ option has been added (also in GP 18.4) to the Sales Order Processing Document Inquiry and the Sales Document Range Inquiry windows to view a document in either the Sales Transaction Inquiry Zoom or Sales Transaction Entry window. To get to these windows, go to Sales > Inquiry and select either Sales Document or Sales Range Inquiry.

        Select a document then click on the “Go To” button and select which window you want to use to view the document.

        goto-from-sop-inquiry

        Get More GP Help

        For more help with GP, please contact CSSI. We can provide:

        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.