Month: October 2023

I was asked to deliver a training workshop to users at a client on the Fixed Assets module. Prior to the session, I logged on and gave te module a quick run through of the areas I would be covering, to make sure that everything worked correctly.

I encountered one error when trying to post a write-down; unfortunately I forgot to take a screenshot of the error as it happened, but the error message is shown below verbatim:

FA Posting Type Write-Down must be posted in the FA journal in Gen. Journal Line Journal Template Name='DEFAULT',Line No.='12000'

I was trying to post the write-down journal so the message wasn’t especially helpful in telling me that the write-down must be posted. I did a little checking and realised that on the Depreciation Book Card, the G/L Integration – Write-Down toggle was not enabled.

Once I enabled this setting I was able to post the write-down journal without any further problem:

This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2.

The sixteenth of the new functionality in the Application section is Adjust exchange rates easily, replace the built-in batch job.

When companies operate in multiple countries or regions, it’s important that they can do business and run financial reports in more than one currency. Because exchange rates often change, businesses must periodically update the rates in Business Central. This update gives accountants additional control over how they adjust exchange rates. At the same time, partners can now extend and customize the exchange rate adjustment to meet the needs of specific industries or markets.

Enabled for: Users by admins, makers, or analysts
Public Preview: Sep 2023
General Availability: Oct 2023

Feature Details

You can now preview the effect that an exchange rate adjustment will have on posting before you actually post by choosing the Preview Posting action on the Exch. Rates Adjustment report (Report 596) request page. Specify whether you want a detailed posting to the general ledger by entry, or a summarized posting by currency, by using the Adjust per entry field. You can also specify how the adjustment will handle dimensions for unrealized gains and losses postings by choosing one of the following options in the Dimension Posting field:

• Source Entry Dimensions: G/L entries for unrealized gains and losses will have dimensions values transferred from the entry you’re adjusting.
• No Dimensions: G/L entries for unrealized gains and losses won’t have dimensions values.
• G/L Account Dimensions: G/L entries for unrealized gains and losses will have dimensions values transferred from the unrealized gains and losses G/L account’s dimension settings source entry.

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2: Adjust Exchange Rates Easily, Replace the Built-in Batch Job”

This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2.

The fifteenth of the new functionality in the Application section is Include only open entries on customer statements.

Businesses send customer statements to customers in various formats and for various purposes. Microsoft have added a Statement Style field so that you can include only open entries in the report.

Enabled for: Users, automatically
Public Preview: Sep 2023
General Availability: Oct 2023

Feature Details

If you open the Customer Statement report from the Customers list page or the role explorer, you’ll find the following options in the Statement Style field on the request page:

• Balance gives customers an overview of outstanding amounts and a reminder to pay amounts that are overdue.
• Open Items does the following:
  • Shows only open entries within the specified date range.
  • Shows a balance for open entries before the start date.
  • Ignores entries that have a posting date that’s after the ending date.

My Opinion

While statements are usually produced showing all activity in a specified period, I can see producing one only of open entries would be very useful from a credit control point of view, allowing you to send a statement to a customer of all invoices yet to be paid.

This post is part of the In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

In a previous article of this series on understanding inventory picks, I mentioned there was three ways in which an inventory pick could be processed and which I covered over the last few articles:

1. Process an Inventory Pick from the Source Document
2. Process Multiple Inventory Picks Using a Batch Job
3. Process an Inventory Pick in Two Steps by Releasing the Source Document

Once the inventory pick activities have been created, they need to be procssed. Do this by performing a search for Inventory Picks and, from the list page which opens, select one of the activities:

Continue reading “In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Pick Document”

This post is part of the In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

In a previous article of this series on understanding inventory picks, I mentioned there was three ways in which an inventory pick could be processed:

1. Process an Inventory Pick from the Source Document
2. Process Multiple Inventory Picks Using a Batch Job
3. Process an Inventory Pick in Two Steps by Releasing the Source Document

In this article, I am going to take walk through the processing an inventory pick using a two step process using the BLUE location on which I enabled Require Pick.

The first step is an ordinary one when processing a sales order; that of releasing the document which is done by clicking Release » Release. This is something which you usually have to do in order to email or print he PO document to the vendor.

Continue reading “In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Pick in Two Steps by Releasing the Source Document”