BC GL Closing Entries - Posting Date Only

Introduction

Here is how to identify closing entries on Business Central GL Data:

Business Central records GL closing entries at 23:59:59 rather than midnight.In the Jet Data Manager, you can apply two separate transformations to a new custom "Posting Date Only" field to set the time to midnight and be able to report on the closing entries using the standard Date dimension table.

The Jet Data Manager translates the GUI transformations into the following T-SQL code:CAST(DATEADD(DAY, 0, DATEDIFF(DAY, 0, [Posting Date])) AS datetime) AS [Posting Date Only]

Transformations

JDM Transformation: closing entry

Result