Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Item Ledger Entry Stuck with Expected Cost (Positive Adj. Performed During Data Migration)

Posted on by 20

Hi all,

When migrating inventory data between systems, a positive item journal was imported via config package and "invoiced qty" section of the config package (I believe) was set to 0. This has led to a number of positive item ledger entries (that are now closed as they have been subsequently sold), stuck with "Expected Cost" (see below). I suspect invoiced qty is the culprit here, as subsequent migrations done by another party have used invoiced qty and the issue below isn't a problem with those ledger entries.

pastedimage1678929562618v3.png

As you can see from the inventory valuation of the item, it has a carrying value of $0.00 on the balance sheet (as we now have qty of 0 for this item), however, the splits are now negative actual cost and positive expected cost.

pastedimage1678929417299v1.png

Is there a process that can be run to fix the above? Any suggestions or help would be much appreciated!

Cheers,

Tim

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Item Ledger Entry Stuck with Expected Cost (Positive Adj. Performed During Data Migration)

    Have you performed your cost adjustment procedure?

    If you have and the cost is incorrect you can also revaluate the item to correct the cost.

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 45 on at
    RE: Item Ledger Entry Stuck with Expected Cost (Positive Adj. Performed During Data Migration)

    Hi,

    As per my knowledge expected cost functionality is not used/affected when we use item journal. Its used when receipt and invoice are done at different time and cost is not yet final. Its strange in your case and you might be right because Invoiced must be equal to quantity when journal is used as cost is not going to be changed.

    May be you can try to run Adjust Cost Item entries report, if it can make some corrections.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans