Featured Post

Microsoft Dynamics GP 2018 R2 has been released

As promised, It has been recently announced that Microsoft Dynamics GP 2018 R2 is released with lots of new features. The GP team at Mic...

Monday, May 6, 2019

Dynamics GP Support and Enhancement for Existing GP Clients - Free Assessment

Throughout the previous years of implementing and supporting Dynamics GP, I have worked in several complex environments with quite complicated business needs, although, Dynamics GP has always proved how strong and powerful business solution it can be for small and medium sized companies. 

Dynamics GP has a long history not only as a financial but also as a management solution to automate and streamline business processes from supply chain, manufacturing, Human Resources and project management. 

The business environment nowadays is changing so fast, which imposes great pressures on companies to respond to the continuously changing market demands, in this essence, existing Dynamics GP clients might be challenged by such demands as the system might be perceived as traditional accounting system. 

Although, it is simply not correct. Dynamics GP can be extended and utilized as a powerful platform to support the complex business environment needs, they key to that is simply "Enhancements". 

If you are an existing Dynamics GP client who's struggling with certain limitations in the system that can not fulfill your business demands, reach out to me through SIROCo; a Microsoft Partner located in the US with multiple regional offices. I will make sure to provide easy answers and fixes to complex dilemmas . 




We would be more than happy to provide free analysis and assessment to your Dynamics GP environment, propose possible enhancements and put your back on the right track to get your return on investment. 

Let's talk !

Best Regards, 
Mahmoud M. AlSaadi

Monday, December 10, 2018

Dynamics GP 2018 R2 - Transaction Level Posting allows to Post "Through" General Ledger

This has always been a mystery to some clients, and a problem to multiple other clients, the fact that Dynamics GP prevents transaction level posting from posting "Through" general ledger is no longer true. 

With t the release of Dynamics GP 2018 R2, the system now allows end users to post transactions without a batch, although, it will post through GL rather than the need to post these transactions again from the general ledger level.

In order to allow transaction level posting with "Post Through" option, open the posting setup window from Microsoft Dynamics GP > Tools > Setup > Posting > Posting

A new option is added under "Allow Transaction Posting", which is: "Post Through General Ledger Files"

Here is the screen shot from the Posting Setup window:

Posting Setup Window - Post Through General Ledger Files

Below is a list of windows which have an option to "Allow Post Through with Transaction Level Posting" 

Sales Transaction Module:
  • Sales Deposits
  • Invoice Entry
  • Sales Transaction Entry
  • Receivables Sales Entry
  • Receivables Cash Receipts
  • Receivables Apply Doc
  • Voided Transaction Maintenance
 Purchase Order Processing 
  • Receiving Transaction Entry
  • Purchasing Invoice Entry
  • Returns Transaction Entry
  • Payable Transaction Entry
  • Payment Entry
  • Apply To
  • Purchasing Prepayments
Inventory Management
  • Transaction Entry
  • Transfer Entry
  • Assembly Entry
  • Manual Checks
Project Accounting 
  • Time sheet Entry
  • Equipment Log Entry
  • Misc. Log Entry
  • Employee Expense Entry
  • Billing Entry
  • Revenue Recognition Entry
  • Inventory Transfer Entry
  • PA Returns Transaction Entry

Best Regards, 
Mahmoud M. AlSaadi

Dynamics GP 2018 R2 - HITB Include and Exclude Zero Quantity or Value

With the release of Dynamics GP 2018 R2, several new features were introduced to the core functionality in the system. In this post, we will shed a light on an interesting feature provided for the inventory module in regards of the Historical Inventory Trial Balance.

In previous posts, it has been thoroughly discussed that HITB usually encounters issues represented with zero quantity and negative/positive cost. The source of the problem is represented with mismatching issues between inventory cost layers ( IV10200, IV10201) from one side and (SEE30303) from the other side. 

Here is a brief on the issue:
Inventory Cost Layers versus HITB (SEE30303)
I have seen such case with multiple clients, resolving this case requires internal matching or rebuilding of the HITB inventory source in order to recalculate quantity and value records and ensure that historical and current inventory balances are matching.

In the same context, the recent release of Dynamics GP 2018 R2 has introduced an interesting feature for the HITB report represented with the ability to either include or exclude either items with "Zero Quantity" or "Zero Value", this will ensure that HITB report is being filter properly for all the zero quantity or value records. 

In order to print the Historical Inventory Trial Balance report, follow the path below:
Reports > Inventory > Activity > Historical IV Trial Balance,

HITB Report Modification

Best Regards
Mahmoud M. AlSaadi