Dynamics Community Forum Thread Details

Conflicting dates in transfer order report

Hi Guys,

I’ve generated a Transfer Order (TO) report, but it’s displaying conflicting dates. I need guidance on the exact meaning and what triggers for the following fields:

Physical Date and Financial Date:
TO Created Date and TO Ship Date:
Created Date & Time – Inventory Transaction Table:
Created Date & Time – Inventory Dimension Table:

Also, I’ve noticed two issues I need help understanding:

Why is the Created Date & Time in the Inventory Transaction Table the same across all rows? I recall a major Microsoft Dynamics 365 update around that time — could this be related?
Why does the Created Date & Time in the Inventory Dimension Table show significantly older dates?

Appreciate your support on this.

Number	Item number	Physical date	Financial date	TO Created Date	TO Ship Date	Created date and time (Inventory transaction Table)	Created date and time (Inventory dimension Table)
1106-15123	10016	1 Jan 2025	1 Jan 2025	2 Jan 2025	1 Jan 2025	8 Feb 2025	1 Jan 2025
1106-15123	10026	1 Jan 2025	1 Jan 2025	2 Jan 2025	1 Jan 2025	8 Feb 2025	2 Jan 2025
1106-15128	10136	1 Jan 2025	1 Jan 2025	2 Jan 2025	1 Jan 2025	8 Feb 2025	2 Jan 2025
1106-15121	10084	1 Jan 2025	1 Jan 2025	2 Jan 2025	1 Jan 2025	8 Feb 2025	1 Jan 2025
1106-15123	10136	1 Jan 2025	1 Jan 2025	2 Jan 2025	1 Jan 2025	8 Feb 2025	28 Dec 2024
1106-15195	10196	1 Jan 2025	1 Jan 2025	2 Jan 2025	1 Jan 2025	8 Feb 2025	28 Dec 2024
1106-15120	10050	1 Jan 2025	1 Jan 2025	2 Jan 2025	1 Jan 2025	8 Feb 2025	2 Jan 2025
1106-15194	10043	1 Jan 2025	1 Jan 2025	2 Jan 2025	1 Jan 2025	8 Feb 2025	1 Jan 2025

Categories:

Dynamics 365 Finance

Hi MM,

This is a great question. I can help with the majority of the details.

Physical versus Financial: The physical date is the date when the goods were received or shipped. This is about the physical action e.g. related to posting of a packing slip. The financial date is the date used for posting the invoice. In case you have inventory transactions created in e.g. an item journal the physical and financial update are at the same time.

TO Created Date versus TO Shipped date: When you create a transfer order, this can be done on another date than the planned shipping. Tranfer orders keep track on creation, shipping and receiving on different moments in time.

Created date/time Inventory transactions: This is the date at which a record is created in the inventory transactions table. This is on the same moment as when you create e.g. a sales order line or item journal line. The physical and financial updates can be on the same or on other dates.

Created date/time Inventory dimensions: The inventory dimensions is a table that keeps all variations of dimension combinations used in the application. If you have a site and warehouse used the first time, it will create a records with an InventDimId. This value will be reused at any future inventory transaction and worksheet table, like sales order lines to know the inventory dimensions used.

As the inventory dimension record is created the first time you have a combination, then most likely, indeed, this has an older date than recent new inventory transactions.

Unfortunately, we don't know how these inventory transactions were created. If it was part of an import, it can be indeed the case that multiple inventory transactions are created or committed in the database at the same moment. You only shared the dates, so we also don't know if the time is exactly the same in your environment.

I hope this clarifies your questions. Let us know if you are in the need for more information.

Quick Links