Microsoft Dynamics GP 2018 - Top NEW Features: And be sure to suggest your own new functions to Microsoft (HERE
GP 2018 R2 Financial Enhancements
A number of updates have been made to the finance area in Dynamics GP.
Monthly recurring batches
With the release of Dynamics GP 2018 R2, users can specify if a monthly or bi-monthly recurring batch must end on the last day of the month in Payables, Receivables, and Inventory Management. When marked, it will automatically set the posting date to the last day of the month. So, if the batch is posted the next posting date would be set to May 31. This is great because before (and without the box checked) it would default the posting date to May 30.
Three windows have been changed to accommodate the new monthly and bi-monthly recurring batch functionality:
- Receivables Batch Entry
- Payables Batch Entry
- Inventory Batch Entry
A new field, Use last day of the month has been added underneath the Frequency field in all three windows. The Use last day of the month option is available only when the Frequency field has been set to Monthly or Bi-Monthly. When the Use last day of the month option is marked for a monthly recurring batch, the Posting Date will be the last day of each month (EOM). When the Use last day of the month option is marked for a bi-monthly recurring batch, the Posting Date will be the last day of every other month (EOM).
Transaction level post through G/L
Users can now post through the general ledger at the transaction level in several windows. A new option has been added to Posting Setup to allow transactions to post through the general ledger if marked to post through.
Duplicate check numbers
You can now prevent or enable the use of duplicate check numbers for more than just Payables Checks by setting or clearing the Duplicate Check Numbers field in the Checkbook Maintenance window. If the field is cleared, then Dynamics GP will prevent users from using a duplicate check number in the Bank Transaction Entry, Miscellaneous Checks, and Payroll Manual Check-Adjustment Entry windows.
Bulk update master records as inactive from navigation lists
In Dynamics GP 2018 R2, users can inactivate and reactivate master records for accounts, checkbooks, customers, sales people, vendors, employees, and items from Navigation Lists. Additionally, users can inactivate one employee at a time from navigation lists.
The Inactivate option becomes available when the user has selected one or more master records on the navigation list. The Reactivate option becomes available when the user has selected one or more inactive master records on the navigation list. If a master record is marked as inactive, a visual indicator shows to the right of the Select checkbox on the navigation list to indicate that the record is inactive.
For each of the different types of master records, Dynamics GP checks that the record meets the relevant criteria to be marked as inactive. The Inactivate option follows existing rules and logic in Dynamics GP for each master record type. Users will be notified if the change succeeded or failed through the yellow status bar at the top of the list. If the record could not be marked as inactive or reactivated, users can print a Status Message Detail report to get more information around why the change failed.
Options with the names Inactivate and Reactivate have been added to the Modify section of the Accounts Navigation List, Checkbooks Navigation List, Customers Navigation List, Salespeople Navigation List, Vendors Navigation List, Items Navigation List, and Employees Navigation List windows.
Allow partial purchase on a purchase requisition from a purchase order
When you create a purchase order, you can now enter a quantity that is less than the total quantity requested. This is also possible if you create a purchase order from one or more requisitions.
When you create a purchase order from one or more purchase requisitions, you now have the option to purchase a quantity less than what was initially requested in the Purchase Order Preview window. The remaining quantity on the requisition will then be canceled.
For example, if you have a quantity of 70 of the item 128 SDRAM on a requisition, but you only want to purchase 35 items, you can now adjust that quantity in the Purchase Order Preview window. When you adjust the Qty To Purchase field to 35, you receive a warning that the remaining quantity ordered will be canceled. When the purchase order is generated, the purchase requisition will move to history if all lines on the requisition have been fully or partially ordered with the remaining quantity on the partially ordered lines canceled.
If you drill back on the transaction in the Purchase Requisition Inquiry zoom, there will be a red icon as a visual indicator to show that the quantity was only partially ordered.
Warning when the vendor is on hold
If you are entering a payables transaction for a vendor that is marked as on hold, you now get a visual indicator. This is similar to the customer hold status that was implemented in an earlier version of Dynamics GP. Additionally, Dynamics GP throws a warning message when a user attempts to enter a transaction when the vendor is on hold.
New SmartList for deposits associated with unposted sales transactions
In Dynamics GP 2018 R2, users can easily view deposit amounts associated with unposted sales invoices and orders through the new Deposits on Unposted Sales Transactions SmartList. This SmartList is a new option under Sales Transactions so you can quickly see customers that have put a deposit on a sales transaction, but the sales transaction hasn't been posted. No more searching through the sales records to see the deposits, now you have a new SmartList to view the details. This new default SmartList is filtered to look at Sales Order WORK transactions (SOP10100) with a Deposit Received amount (DEPRECVD field) greater than zero.
Email customer statements
In the Customer Maintenance window, you can now email statements with the click of a button. A new email button can be found on the Menu bar of the Customer Maintenance window.
When you click the email button, Dynamics GP will email a customer statement to the customer that you have selected in the window. The settings from your 'BLANK FORM' statement ID will be used for this functionality. If a Statement ID of 'BLANK FORM' does not already exist in your company, then Dynamics GP will create a new Statement ID with the name 'BLANK FORM' with the following settings:
Date to Print End of Month
Form On Blank Paper Print
For All Options Marked
*Email functionality is dependent on Word Templates being enabled and properly configured in your company.
Dynamics GP 2018 R2 includes a new Sales Transaction Approval workflow where you can create approvals based on several conditions such as whether a customer credit limit is exceeded on the transaction or not. Not only can you set workflow approval on customer credit limits, but you can set workflow approvals on all transaction types in Sales Transaction Entry. We added a new email message to work with sales transactions, just like the other workflow types. Workflow history is displayed in inquiry windows too.
The following are no longer supported with Dynamics GP 2018 R2: GP 2018 System Requirements
- Windows Server 2008 all editions
- Microsoft SQL Server 2012 all editions
- Microsoft Windows 7 all editions Updated - Windows 7 client and server are supported as of Jan 2018.
- Microsoft Office 2010