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, 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