General Ledger Mass Modify

Mass Modify is a tool that can help you quickly create, update, or renumber large groups of General Ledger accounts all at once.

You can generate many new GL accounts based on existing ones using:

• Segment (change one segment across a range)
• Range (copy a block of accounts)
• Mask (replace part of an account number)
• Wildcard (select accounts based on patterns)

This is useful when:

• Adding a new department
• Rolling out new natural accounts
• Creating new cost centers

NOTE: Before using this tool, be sure to have a current backup!

To copy a range of accounts:

1. Go to Financial > Cards > Mass Modify
2. Select Copy in the Modify field
3. Enter the range of accounts you want to modify in the From and To fields
4. In the New Account Mask, enter the new segment number
5. For Display, choose Selected Range to show the range of accounts to be copied
6. Click on Modify to complete the process
7. The fields in the window will be cleared when the process has been completed

GP Upgrade Support

CSSI can help with your GP upgrades! Our experienced GP team can guide you through the process of getting current, even if you have slipped several versions behind! Contact us for GP upgrade help.

Verifying Vendor Tax ID’s & Employee Social Security Numbers

This is not exclusively for GP users but a helpful tip for anyone who files 1099 and W-2 forms. The IRS and the Social Security Administration (SSA) both offer free online tools for taxpayers (payers/employers) to validate taxpayer identification numbers and social security numbers.

You can access these tools from the IRS website below.

Taxpayer identification number (TIN) matching tools | Internal Revenue Service

Why This Matters: Risks of Not Verifying Payee Data

Without proper verification:

• Names and TINs may not match IRS/SSA records, triggering backup withholding, filing rejects or errors, or penalties.
• Employees might not get correct credit for their earnings if W-2s are wrong (wrong SSN/name).
• You may need to file corrections (e.g., 1099-Corr, W-2c), which is time-consuming, and potentially subject you to late-filing penalties.

Need GP Support?

If you need help with GP, please contact the GP experts at CSSI Technologies. We’d be glad to help with general GP support, upgrades, and report creation.

GP Tip – Cleaning Up Auto Complete Selections

Here is an older (but still handy!) tip…  GP has this feature called Auto Complete that remembers what a user had previously typed into a field.  The only problem is that it remembers the invalid data, too. 

You can remove these unwanted values that appear in your list by right-clicking on a selection then clicking on “Remove From List”.  It’s as simple as that!

You can use the AutoComplete Setup window (Microsoft Dynamis GP > User Preferences > Auto Complete) to specify the number of days when unused entries should be removed and the number of entries that can be saved for each field.  You also can remove all existing AutoComplete entries.  If you decide not to use AutoComplete, you can unmark the Show AutoComplete Suggestions option.  Because this is under User Preferences, this is a by-user setting.

GP Support from CSSI

Do you have a solid GP support partner? We can help. For more GP support and help with upgrades or training, please contact CSSI.

Assigning Process Holds to Sales Documents

You can use the Sales Process Holds Setup window to create process holds to assign to your sales documents.  Process holds are user-defined restrictions that control the processing of sales documents at different stages of the sales cycle.

Some examples of process holds are:

• Prevent posting of documents until a manager approves the transactions
• Restrict the printing of invoices until addresses have been verified
• Stop the order fulfillment process because a part has been recalled by the manufacturer
• Prevent the transferring of a quote to an order if the customer is over its credit limit

You can set up passwords to further restrict processing.  The user must enter the password to remove holds from documents.  If you do not use passwords, you can set up a process hold just to remind the user to complete a task before processing a sales document.  Once the task is completed, the user must remove the hold from the document before processing occurs.  You can apply process holds to any sales order processing document type.

To set up process holds, go to Sales > Setup > Process Holds.  Enter an ID and description.  You can assign a password or leave it blank.  Check which processes you want to restrict with this hold.

To assign a Hold to a SOP transaction, go to Sales > Transactions > Sales Transaction and select a document. Click on the Go To button and select Holds.

Select a Process Hold ID and click on Assign. You can assign more than one Hold to a document.

Once a Hold is assigned, you will see a red circle indicating a Hold is on this document. 

To remove the Hold, click on the Go To button, select Holds and Remove.

Add the Hold column to a Sales Transaction SmartList to see all documents on hold.

GP Support from CSSI

For GP support and help with upgrades or training, please contact CSSI.

How to Allocate Inventory to Multiple Bins In GP

Did you know that Microsoft Dynamics GP provides the ability to track inventory quantities in more than one bin location within a site/warehouse?  By default, GP lets you set up one “default” bin per item/site, but if you need more detailed tracking—such as stock spread across aisles, shelves, or zones—you enable Multiple Bins in the Inventory Control module.
 
You can then assign default bins for different types of transactions for each item/site combination.

The Bin Quantity Inquiry window lists all the bins containing quantities for a particular item.

This does add an extra step to each inventory-related type of transaction because GP now must track not just what site an item is in, but also which bin(s) it is stored in. There are certain steps that need to be followed when you enable this feature. 

Need GP Support for Inventory Management?

If you’re looking to improve your inventory management, CSSI offers a warehouse management software solution (WMS) specifically written for GP users. For help with WMS or inventory management, please contact CSSI to discuss.

GP Tip – Printing a Trial Balance

Have you ever had the need for a trial balance for just certain account numbers?  For example, you would like GL Trial Balance detail of accounts 6100 and 6520, but not the accounts in between, so you can’t use a range. You can create your custom report using the GP Trial Balance and Navigation Lists!

1. Open the Financial Area page and click on Accounts in the Navigation Pane to generate your list of GL Accounts.

2. Create a filter for the accounts you want to see.  Select Add Filter, then enter the accounts you want in your report.  When finished select the right pointing arrow to apply the filter you created.  The accounts matching the filter will be displayed.

3. Mark the accounts you want included in the report.  To select all accounts, select the checkbox in the header.

4. Select Reports > Print Trial Balance

5. Select Print and GP will generate a standard Trial Balance in summary or detail (Include details).

6. You can then save the filtered list by clicking on the ‘Accounts (read only)’ menu and choosing a name for the list so you can use it again later.  You will simply have to enter the checkmark to select the accounts to be used in the report and then select print.

GP Support from CSSI

For GP support and help with upgrades or training, please contact CSSI.

Understanding GP’s Multidimensional Analysis Feature

MDA is a feature in Dynamics GP that lets you “tag” transactions with additional “dimensions” for reporting and analysis. 
 
For example, instead of creating a new GL account for every department, region, project, cost center, product line, etc., you can use MDA codes to capture these extra details and keep a streamlined chart of accounts.
 
First you define your MDA Groups and the Codes that will be used within each group.

Next, you link your MDA groups to G/L accounts. You can indicate whether you would also like to track quantities (in addition to dollars). Analysis Types are Fixed, Required, Optional or None. You can enter default percentages to be applied to transaction distributions for each code, which can be overwritten in the transaction. A single G/L account can have multiple MDA groups assigned.

When a G/L account, that has MDA groups assigned, is used in a transaction, the Account Analysis button becomes available (circled below).

Click on the Account Analysis button to open the Analysis Posting Detail window where you can distribute the transaction amount to MDA codes.

MDA transaction history can be viewed in the Account Analysis report, Analysis Inquiry window and in SmartLists.

MDA codes can be used in the following transaction types:

• General Journal Entry
• Payables Transaction Entry
• PO Receiving
• PO Invoice Entry
• Receivables Transaction Entry
• Sales Invoicing
• Sales Transaction Entry

Need a Great GP Support Partner?

Are you in need of a responsive and knowledgeable GP support partner? CSSI provides helpful technical support, training, and upgrade help. Contact us to discuss how we can help you manage your use of Dynamics GP.

How to Use Non-Qualifying Vendor Discounts

Wondering how to handle non-qualifying vendor discounts in GP?

As you know, GP will only automatically deduct vendor terms discounts if you are paying invoices before or on their discount dates.

You can also take discounts AFTER the discount date by checking “Take Non-Qualifying Discounts” box in the Build Payment Batch window.

This option is not available if you mark the Exclude Expired Discounts from Payments option in the Payables Management Setup window (shown below) or for a purchasing prepayment batch.

Another helpful option in the setup window above is “Allow Summary Post to Checkbook for EFT/CC”. This feature was added in GP 18.5. It allows you to post EFT and credit card AP payment batches to the bank reconciliation in a lump sum, rather than as individual amounts. This makes bank reconciliation much easier because these amounts most likely appear on your bank statement as a total amount.

Need GP Help with Upgrades or Support?

If you need help with upgrading your GP or if you need technical support, please contact the team at CSSI for help.

Document Attachments in GP

Are you aware of how easy it is to attach documents to GP transactions and master records?  Document Attachment functionality was introduced in GP 2013 R2 and has gotten more robust in later releases.

1. Document Attachment Setup

• To enable Document Attachment, go to Microsoft Dynamics GP > Tools > Setup > Company > Document Attachment Setup
• Check the “Allow Document Attachments” box

Press the F1 key (or go to Help > About This Window) for more information on the other setup options in this window

2. Using Document Attachment
• Open almost any GP window, select a record then click on the Attach button

• Or click on the Notes icon then click the paper clip icon here

• Click on the Scan button in the Document Attachment Management window
• If you already have a scanned image, you can click on the Attach button to browse to that image file.
• You can then view the status of an attachment by clicking on it to select it then click on the blue arrow to the right of Date.  This will show you the date and the time a user has attached, deleted, or scanned the image.  If, in the setup, you marked to allow a document to flow, this inquiry screen will also show the date and time the document flowed to a transaction.

Contact CSSI for GP Support

Please contact CSSI for GP support, training, and upgrades. Our team of experts is ready to help.

Sales Order Deposits and Down Payments in GP

In this article we discuss how to handle sales order deposits and down payments in GP.

Use the Amount Received field in a Sales Order to record a customer deposit/down payment.
 
You will first need to assign a default Deposits Received account by going to Microsoft Dynamics GP > Tools > Setup > Posting > Posting Accounts.  Change the Display to Sales.

In Sales Transaction Entry, enter the deposit amount in the Amount Received field.

When you tab off the Amount Received field, the Sales Payment Entry window will open. Select a payment Type and a Checkbook ID. The Check Number field will be available for the “Check Deposit” type.

When you save the sales order, and close the Sales Transaction Entry window, a journal entry will be created to debit cash and credit customer deposits. This payment will then appear in the Bank Deposits Entry window to be included on a deposit.

When the order gets transferred to an invoice, and posted, the customer deposits GL account will be debited in the amount of the payment. The amount that debits Accounts Receivable will be the document total amount less the deposit amount received.

The sales order and invoice documents can be modified to display the payment received as shown in the example below.

Need Help with GP?

CSSI Technologies provides expert support for Dynamics GP. We offer technical support, training, upgrades, and more. Please contact us for GP help.