Dynamics Community Forum Thread Details

Is it Feasible to Unapply and Reapply all the Item Ledger Entries?

In One of our client's production environment we are facing an issue related to Cost Adjustment.

Our client is using two Costing method: Average and FIFO. They have multiple locations and use Transfer order on regular basis. they also use Transit location on all the transfer orders. Some time ago there was a customization that system should allow user to post Transfer Shipment even if the inventory doesn't exist. Also there were some other customization due to which i found below issues on ILEs:

1. When user Shipped Quantities more than available, the Remaining Quantity on ILE went negative. then they purchased new inventory and sold. But Remaining quantity on all the new purchased ILE remained as it is and system started applying all the out bound entries on the ILE on which Remaining Quantity was in negative. Due to this issue, all the out bound entries are applied on the single ILE and upon cost adjustment considered the cost of that one ILE only.

2. On Some of the Outbound ILEs application entries are missing. Due to the unavailability of application entry, Cost Adjustment for these items are getting failed.

3. In above mentioned two issues some ILEs are related to Transfer. Due to this we are not able to Remove Application and Reapply ILE manually. We are getting the Error that "Entries applied to an Outbound Transfer cannot be unapplied."

4. Due to Application entries are wrong, Missing application entries, and cannot unapply and reapply entries as Transfer entries also exist, all these issues combining, cost applied on the Transfer Shipment ILEs and Sales ILEs are not correct. it is impacting on COA and other reports related to Inventory valuations which gets data from Cost Amount (Actual) column of ILEs.

Is there any way using which we can correct the cost applied on Outbound entries? Should we develop any batch with help of technical team which can remove and recreate the application entries as per the system standard?

Categories:

Dynamics 365 Business Central

Hello,

This issue is not a standard costing problem but data corruption caused by past customizations that allowed transfer shipments and outbound postings with negative inventory, which broke item application logic. As a result, BC kept applying all outbound entries to a single negative ILE, left later receipts unapplied, and in some cases never created application entries, so Adjust Cost – Item Entries cannot fix it. Once transfer entries are involved, BC does not allow unapply/reapply, making manual correction impossible. There is no supported standard fix to recalculate or correct costs on these outbound and transfer entries; the only real options are restoring from a clean backup or performing a high-risk, one-time technical data correction with Microsoft support involvement to rebuild application entries per standard logic. The customization allowing negative inventory must be removed, or valuation, COA, and inventory reports will continue to be wrong.

Regards,
Oussama Sabbouh

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS