Introduction

When posting journals there may be times when it would be helpful to see what affect the journal would have on balances prior to posting the entries.

In this post we’ll walk through how this can be achieved by using the “Reconciliation Account” feature on the GL account page.

Configure the GL Codes

The first thing you need to do is select the option “Reconciliation Account” on the GL code. You can do this by browsing to the “Chart of Accounts” and selecting a GL code and switching the option “Reconciliation Account” on.

In this example I’m switching the option on for 40500 Prepaid Rent and 30100 Rent Expense.

Create the Journal

Now I create a journal which is going to hit these two GL codes however before I jump in and click “Post” I want a sneak peak at what the balances would be if I were to post the journal.

Run the Test Report

In order to see what the balance of the GL codes would be I need to run the “Test Report” using the following selections:

Then, along with any posting errors, there’s an extra section showing the “Balance after Posting” for each GL code as per below:

In the scenario above this feature could have been especially useful, as I may have wanted the balance in my Pre Paid Rent account to be £0.00 after I’d posted this journal. If this was the case, I can now simply close the Test Report, change the amounts to £510.00 and then post. This would have then prevented an extra journal entry or a potential reversal entry.

Conclusion

This is a handy feature that is going to be espeically useful when posting accrual entries or correcting entries at a reporting period end. This is when accountants maybe checking balances and finalising accounts.

Thanks for reading!

Today I ran into an issue when posting a Warehouse Receipt to a new location I just created. I’m using a new location as I’m testing the processes of Warehouse Receipt and Putaways along with Warehouse Shipments and Picks and I’d rather do this on a new location.

I thought it worth documenting this process as when troubleshooting why the Warehouse Receipt wouldn’t post I found a setup option I could change which gave me a better, more comprehensive error, enabling me to get to the root cause of the issue. This was crucial to understanding why the Warehouse Receipt wouldn’t post.

Starting from the beginning, to create the new location I went to the “Location Setup” window and created the location as per below

I then went ahead and created a Purchase Order so I could work through creating a Purchase Order followed by a Warehouse Receipt and Putaway. I did this by creating a Purchase Order and clicking “Create Whse. Receipt”

Success. This created a Warehouse Receipt, and as all the relevant information was populated, I just need to post this to create the Putaway however when trying to post the document I was presented with the message below:

Hmmm. The error isn’t giving anything away, and when I doubled checked everything seems fine so why isn’t it posting?

After much pondering and testing I stumbled across the setting below in the “Warehouse Setup”

At the moment its set to “Posting errors are not processed”. I therefore switched this to “Stop and show the first posting error” in the hope it would give me more information when posting.

I then tried to post the Warehouse Receipt again and now I get a much better error message

The error is suggesting I haven’t setup posting accounts against my new location. Doh!

I therefore went back to “Location Setup” and clicked “Inventory Posting Setup” and populated the Inventory posting group and posting accounts as per below

I then went back to my Warehouse Receipt and now all the posting accounts have been added it posts fine.

I’m guessing it would have taken much longer to get to the root cause of the issue if it wasn’t for that setting in “Warehouse Setup” so I’m sure this will come in handy in the future as well.

Thanks for reading!

This is a quick post however I thought it was worthwhile postings as there’s not much information online about the Bank Management module.

A client wanted to void a GL type transaction in Bank Management however it wasn’t listed in the “Transaction Enquiry / Void” window in Dynamics GP.

The solution is to click “Upgrade from Recon” which refreshes the enquiry window with data from the reconciliation tables.

The window and button are highlighted below:

The process can take some time depending on the number of transactions as it will read from both open and historical bank management tables.

Once this had completed the transaction was available to void in the “Transaction Enquiry / Void” window.

I hope this comes in useful for someone else in the future.

Thanks for reading