Featured Post

Dynamics GP 2018 - Upcoming Features

We are counting the days for Dynamics GP 2018 release which is promising to introduce a new set of features that have been highly recogniz...

Monday, October 30, 2017

Dynamics GP 2018 - Upcoming Features

We are counting the days for Dynamics GP 2018 release which is promising to introduce a new set of features that have been highly recognized among the GP community as demanding requirements. Today, the Dynamics GP Support and Service blog has published the schedule for the GP 2018 new feature blog series, Ms connect has started to play a major role in shaping the future of Dynamics GP. 

As derived from the GP Support and Services blog, here are the upcoming features:

Power "Suite" Evolution

·        Support Paging, Filtering and OData V4.
·        Microsoft Dynamics GP Power BI Content Pack.

Comprehensive Doc Attach

·        Check out the windows were document attach was added.
·        You can now view and modify attachments in inquiry windows.
·        Drill back capability from Transnational information.

User Experience

·        New sort options on many windows giving the user easier access to find information.
·        No more annoying prompts for the System password!
·        No more arguing is it check or cheque?  It is PAYMENTS.
·        Better user experience when using web client with Autocomplete, SmartList and Bank Reconciliation.
·        SmartList Favorites with unique password protection.
·        There is a new FABRIKAM DAY to plan for, mark your calendars for the party!! 

Optimized Financial and HRP

·        Who wants to see those pesky garnishment reports that slow down the process of my payroll?
·        HUGE request from customers, ability to roll down items from Payroll Setup to inactive records.
·        Our users like the changer functionality/ability, who wants to be stuck with old code names, so we added DEPARTMENTS!!
·        Copy user access across Analytical Accounting dimension codes.
·        Restrict Inactive records in your Payroll Master look up windows, yeah who wants to see that old stuff?
·        Ability to Email a single statement from the customer card.
·        Purchase Order Gen open PO List with new PO's filter
·        Purchase Order number displays on the Requisition List for originator and sends notifications to the requisition originator.
·        Print Purchase Requisition
·        Display hold Status on the Sales Transaction Entry.
·        Vendor Setting Optimizations - One check per Invoice and Save Select Payment
·        Human Resource & Payroll Solution Series - Reprint Distribution Detail and Summary reports.
·        Human Resource & Payroll Solution Series - Wellness and Health Insurance Integration.


·        Reminder emails for workflow, EPIC!
·        I need an easier way to manage my existing workflow - COPY WORKFLOW STEPS!!  SWEET
·        Reporting for Workflow, I need that.
·        General Ledger Account Workflow Approval
·        Purchase Receiving Workflow (PO Invoices)
·        Purchase Enter/Match Invoice Workflow
·        Payables,  Purchase Order, and EFT Bank Detail  Additional fields for Workflow
·        Project Accounting improvements in Workflow
·        Employee Self Service Workflow / email enhancements.

Stay Tuned until the release of Dynamics GP 2018 

Best Regards,
Mahmoud M. AlSaadi

Tuesday, October 24, 2017

System Requirements for Dynamics GP 2018

Dynamics GP 2018 is expected soon, Microsoft has officially published the system requirements for GP 2018 which can be found on the link below:

It's important to note that the requirements above are still subject to change until the release of Dynamics GP 2018.  

Additionally, the following are no longer supported with Dynamics GP 2018:
  • Windows Server 2008 all editions
  • Microsoft SQL Server 2012 all editions
  • Microsoft Windows 7 all editions

Best Regards, 
Mahmoud M. AlSaadi

Friday, July 14, 2017

Distributing Analytical Accounting Details on Sales Transaction Entry ( Cost of Goods Sold and Sales/Reveue )

One of the complex requirements is generate a profit and loss statement per sales channel, which requires distributing all revenue, cost and expenses account per Sales Channel, in order to be able to generate a profit and loss statement with Analytical Accounting Dimension details from the Management Reporter. 

Analytical Accounting - Expenses

Most expenses can be distributed directly, either from the payable, bank or general ledger. It seems to be a straight forward process as you just need to fill out the expenses on the distribution and fill out the associated sales channel directly. 

Analytical Accounting - Revenue and Cost

Distributing Analytical Accounting on the sales account seems to be straight forward process as well, once the Sales Invoice is created, you can easily go to the distribution and fill out the associated AA dimension (sales channel in this example). 

The bottle neck of this process is the cost accounts, since Inventory/ COGS journal is usually determined after posting the sales transaction and depending on the inventory valuation method (FIFO, LIFO or average). 

For this case specifically, the analytical accounting provides an essential feature which allows you to distribute the Inventory / COGS analytical details before posting the sales transaction entry. 

On the sales transaction entry window, Click on "AA" button on the ribbon of the window to open the Analytical Sales Transaction window

AA - Sales Transaction E

On the Analytical Sales Transaction entry window, there is a button to switch between the Inventory/COGS journal and the main Journal, illustrated below:

Now you can fill out the distribution related to the COGS, and switch back to the Sales/Revenue distribution to fill out the associated analytical accounting dimension as well. 

Best Regards, 
Mahmoud M. AlSaadi