FIFO - Inventory Recalculation - Adjustment on Transfer order

(1) Share

Report

Posted on by Dixita

140

Hi there,

I have a question regarding the behavior of inventory recalculation (FIFO) in the following setup.

When I run the inventory recalculation, I notice that the adjustment is posted only for the Transfer Order Receipt and not for the Transfer Order Shipment. I’ve attached screenshots of my current setup for your reference.

Is this the expected system behavior in Microsoft Dynamics 365? Specifically, is it by design that adjustments are only posted against the 'Transfer order receipt' posting type?

If so, could you please clarify which configuration or setting controls this behavior?

Thank you in advance for your help!

Here is my item model group setup

Storage Dimension Group

Tracking dimension group

InventTrans

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

CA Neeraj Kumar 405 on at

Like (0)

Report

FIFO - Inventory Recalculation - Adjustment on Transfer order

Hi Dixita,

This is standard behavior for inventory Recalculation for transfer order Inventory transactions, system post the adjustment only on transfer order receipt. [Explained well by @Syed]

It also causes a mismatch in inventory vs GL if we are looking for Site level Trial balance due to no accounting entries get posted for this Adjustment even if sites are different.

Regards,

Neeraj Kumar

If this helped, please mark it as "Verified" for others facing the same issue Keep in mind that it is possible to mark more than one answer as verified

Was this reply helpful? Yes No
Verified answer

Syed Haris Shah 252 on at

Like (1)

Report

FIFO - Inventory Recalculation - Adjustment on Transfer order

Hi Dixita,

In FIFO, cost adjustment appears on the in-transit warehouse line because sold transactions use the in-transit inventory issue account while purchased transactions use the inventory receipt account.

When FIFO recalculation runs, the system adjusts both accounts with corresponding debit and credit entries to ensure the inventory value and financials are balanced.

For items under standard costing, recalculation is not required. The system automatically identifies any difference between standard cost and actual cost and posts it to the Standard Cost Variance account, keeping inventory and financials accurate without manual adjustment.

If you find this answer helpful, please consider verifying the answer. 👍

Regards,

Syed Haris Shah

1 people found this reply helpful.

Was this reply helpful? Yes No
Dixita 140 on at

Like (0)

Report

FIFO - Inventory Recalculation - Adjustment on Transfer order

Thank you, Syed, for your response.

I don't understand why the In-Transit warehouse is posting adjustments. This is causing the In-Transit warehouse value to show after recalculation, even though the inventory is zero.

Would this behavior be any different when using Standard Costing instead of FIFO?

Regards

Dixita

Was this reply helpful? Yes No
Syed Haris Shah 252 on at

Like (1)

Report

FIFO - Inventory Recalculation - Adjustment on Transfer order

Hi Dixita,

Yes, this behavior is by design in D365 F&SCM. According to Microsoft's documentation https://learn.microsoft.com/en-us/dynamics365/supply-chain/cost-management/fifo-physical-value-marking:

This means that inventory recalculation relies on financially posted dates to determine how receipts are matched to issues (for example, a Transfer Receipt matched to a Transfer Shipment). The process doesn’t touch the shipment side because adjustments are only made when receipts are financially recognized.

Therefore, the behavior you're seeing. Where adjustments are applied only to the Transfer Order Receipt and not to the Shipment, is expected.

If you find this answer helpful, please consider verifying the answer. 👍

Regards,

Syed Haris Shah

Was this reply helpful? Yes No