Dynamics 365 Business Central: Posting a Sales Refund and applying to a Credit Memo

Introduction

I come from a Dynamics GP background and I’ve always found the process for refunding in Dynamics GP to be rather long winded and not very intuitive. The main issue is there’s no specific option for creating a refund, so I was very interested to test out the option in Dynamics 365 Business Central.

In this article I’ll first explain a potential scenario when a refund would need raising and applying to a credit note, then briefly explain how I’d do this in Dynamics GP, before finally going through the refund process in Dynamics 365 Business Central.

The Scenario

The scenario is as follows:

A customer buys some goods so we issue an invoice. The customer sends us payment which we apply to the invoice however they subsequently send the goods back so a credit note is issued. Finally some time later the customer requests their money back as they aren’t planning on doing business with us anymore.

Therefore, prior to issuing the refund, the account would have an Invoice applied to a Payment and a unapplied Credit Memo as per below

To complete the process we now need to issue the customer with a refund and apply this to the credit memo.

Dynamics GP

In Dynamics GP its not possible to post a “Refund” type cash receipt and apply it to the credit memo. One solution would be to void the credit memo and post a “Return with cash” similar to below:

Alternatively you could post a debit type document, apply this to the credit memo and then create the customer in payables and post a payment, however both cases aren’t ideal. (you can also use “Refund Cheques”, but again this involves having the customer setup in payables which again isn’t ideal)

Dynamics 365 Business Central

In Dynamics 365 Business Central you can post a “Refund” and apply it to the “Credit Memo” using the “Cash Receipts Journal”. Below are the steps to achieve this:

First go to the “Cash Receipt Journal” page:

Enter the refund as per below:

Next apply this to the credit memo we are refunding:

And then post the Cash Receipt Journal.

If we now review the account we can see the refund has been successfully applied to the Credit Memo.

Conclusion

I do like this functionality in Dynamics 365 Business Central. Its intuitive and doesn’t require lots of different steps. Although I’m a firm fan of Dynamics GP I do find this an improvement when compared to the current functionality available in Dynamics GP.

Thanks for reading.

Dynamics 365 Business Central – Error Message “Select Dimension Value Code for Dimension Code” when Applying Documents

I encountered this issue while investigating a dimension error a user received when applying an Invoice to a Credit note in Dynamics 365 Business Central.

In this case the user had just started assigning dimensions to customers however some customers had posted documents without any dimension analysis. They found when they attempted to apply documents with no dimension analysis they now received the error “Select Dimension Value Code for Dimension Code”.

To illustrate the issue below are some customer ledger entries for customer C00070 that have no dimension analysis (as this wasn’t required when the documents were posted)

We will now configure a requirement for analysis to the dimension “DEPARTMENT” on the customer:

Now when you attempt to post the application of the invoice to the credit note you are presented with the error below:

The only solution I could find other than reversing both the invoice and the credit was to temporarily remove the “Code Mandatory” for the dimension on the customer.

I guess as the system may have to post GL entries as a result of the application it therefore checks for the existence of dimensions on the source documents.

Something to watch out for when adding new dimensions onto existing customers and suppliers.

Thanks for reading!

Dynamics 365 Business Central – Posting a Payables invoice to multiple GL codes using a Purchase Journal

Introduction

As I learn and familiarise myself with Dynamics 365 Business Central I often post something in Dynamics GP and then wonder how this same task could be achieved in Dynamics 365 Business Central.

Today’s pondering was looking for the equivalent to the “Payables Transaction Entry” window that we have in Dynamics GP.

I know you can post to G/L accounts via the “Purchase Invoice” page in Dynamics 365 Business Central but to me this is primarily a “Purchase Order Processing” type window. I wanted to post a sundry payables invoice, onto a vendor, to multiple GL codes, without the need to touch the “Purchase Invoice” window.

As usual there is more than one way to do this however I focus on the “Purchase Journal” page. I also elude to why I think you can achieve the same using other “journal” pages, although you might not necessarily want to use those anyway 🙂

Dynamics GP – Payables Transaction Entry

In Dynamics GP you can post a sundry payables invoice in a very straight forward and easy to understand window called “Payables Transaction Entry”.

This window has no link to Purchase Order Processing. We tend to advise users to use this window for posting invoices for sundry items and things you wouldn’t necessarily have a Purchase Order for. You can click “Distributions” and record multiple GL codes for this one invoice. Its also handy to import transactions into very quickly and users seem to prefer this window for speed of entry.

Dynamics 365 Business Central – Purchase Journal

There are various “journal” pages in Dynamics 365 Business Central so I turned to the “Purchase Journal” page to achieve my goal.

The first thing I found I had to select was the option “Show more columns” as per below.

Crucially this adds the “Account Type” option which gives the user the ability to add “G/L Account” when keying in the Payables document:

Now I had the “Account Type” field available for entry I found as long as you keep the Document Number, External Document No and Posting Date the same you are able to add a payables document with multiple lines.

First you add the “Account Type” of “Vendor” and key in the first line with the total amount of the document. On the subsequent lines you can choose “G/L Account” as the account type and enter the G/L distribution breakdown. Also, if you wish to analyse tax to any of the distributions you must populate the “Gen. Posting Type” with “Purchases” and then populate the “VAT Prod. Posting Group”.

In the end you should have something like this and the document will post successfully

Other takeaways

As with any investigation you usually find some interesting things along the way.

The major takeaway I found is that you can post the same purchase invoice using the “General Journal” page. After looking more closely it seems this is possible as both pages are based on the “Gen. Journal Line” table. Therefore all the fields (and business logic) you need are available on the “General Journal” page as well.

See below. The “Purchase Journal” and “General Journal” pages are based on the same table:

Purchase Journal
General Journal

However, as a word of caution, if you were to post the same purchase invoice from the “General Journal” page the transaction is given a “Source Document” of “GENJNL” in the “G/L Register” rather than “PURCHJNL”.

See below. The top G/L Register was posted using the “General Journal” page and the other using the “Purchase Journal” page.

Therefore I’d suspect its best to use the specific “Purchase Journal” for these postings.

Thanks for reading!