Dynamics Community Forum Thread Details

Adjust Cost - Item Entries not working consistently?

Hi all,

I have a scenario where it seems like the Adjust Cost - Item Entries is not working consistently. Below are the details;

We have a case where a client has never run the Adjust Cost - Item Entries in their Business Central environment. They are interested in enabling this feature so we decided to test it out in a sandbox environment first therefore the below steps were carried out;

- Created a sandbox environment (Sandbox 1) that is a copy of Production.

- Ran the Adjust Cost - Item Entries (with posting to G/L switched on) for all items. The batch job ran successfully.

2 days later, we did another sandbox (Sandbox 2) that is a copy of Production. The Adjust Cost - Item Entries batch job was run again with (with posting to G/L switched on) for all items. The batch job ran successfully.

When a trial balance for 2021 was issued from both Sandbox environments, these did not match. We looked for the differences between the 2 sandbox environments and found a small number of G/L entries that were created in Sandbox 2 but not in Sandbox 1 during the Adjust Cost - Item Entries batch job.

We traced one of the transactions to a specific item that was used in a specific sales invoice.

How is this possible if;

- In both sandbox environments, the item's unit cost was the same

- In both sandbox environments, the invoice was the same (this is a 2021 invoice and therefore since both sandboxes were a copy of production, it was the same in both).

- In both sandbox environments, the item's qty. in inventory was 0 as at end of 2023.

The only differences noted is that during those 2 days between creating Sandbox 1 and Sandbox 2, the item was bought (qty +1) and sold (qty -1) with transactions dated 2024 (therefore the item in Sandbox 2 had 2 'extra' item ledger entries that were not in Sandbox 1, but these are dated 2024).

How come in this case, the Adjust Cost - Item Entries batch job in Sandbox 2 created more G/L entries (cost adjustments) dated 2021 for this item? Since as at 2023, everything was the same for both sandboxes and the 'extra' item ledger entries are dated 2024? Although the item is set to FIFO, since the qty in inventory was 0 prior to 2024, the transactions of 2024 should not have referenced/consumed those of 2021 so I do not believe that these 2 transactions caused the difference.