Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / adjust Item Cost for w...
Small and medium business | Business Central, N...
Answered

adjust Item Cost for wrong positive adjustment entry

(0) ShareShare
ReportReport
Posted on by OlaQ 72

i have Customer , who just moved to BC 365 newly , 

they have made a Positive adjustment entry for their stock by mistake with 0 unit cost for some items ,

and then also posted sales for these items , 

they just found out , and then need a way to correct it , is there is a way to adjust the cost of the original items , without reversing the transaction , since they already posted , sales and the QTY of some of these items is 0 

i have check revaluation entry , but the entry will only work on remaining qty , not Original QTY

the items all having Average Cost Valuation method

apricating the Help

ItemLedger-Entry1.png

itemLedgerEntries2.png

  • OlaQ Profile Picture
    OlaQ 72 on at
    RE: adjust Item Cost for wrong positive adjustment entry

    Thanks for the Suggestion, this actually work very nicely,

    I have tried this entry before , but did not know that I can apply the entry

    thanks again

  • Verified answer
    TWBlaisdell Profile Picture
    TWBlaisdell on at
    RE: adjust Item Cost for wrong positive adjustment entry

    Hi OlaQ,

    My recommendation is to use the Revaluation Journal.  On the Lines, select the Item and then select the Applies To Entry No and select this entry. This will allow for a back-dated Revaluation of the full quantity on the original Posting Date.  Once you complete the Posting of the Revluation Journal, you should be able to run Adjust Cost Item Entries and correct the cost applied on the applied sale/negative entries.

    Thank you.

    Best Regards,

    Tom

  • OlaQ Profile Picture
    OlaQ 72 on at
    RE: adjust Item Cost for wrong positive adjustment entry

    but I am not able to reverse the inventory entry when the items available is zero , or less than Original QTY

    (reversing positive adjustment will be by creating a negative Adjustment Entry for same qty and Zero Cost ) correct , so if there is another way , please inform Me , as i am also new BC

    thanks for the help

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: adjust Item Cost for wrong positive adjustment entry

    Just the inventory should be fine. After that though use this method for reapplying costs to the sales invoice: docs.microsoft.com/.../finance-how-to-remove-and-reapply-item-entries

  • OlaQ Profile Picture
    OlaQ 72 on at
    RE: adjust Item Cost for wrong positive adjustment entry

    Josh,

    Do you mean, to cancel the sales invoices , then reverse the Positive adjustment , or there is other way around to do this

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: adjust Item Cost for wrong positive adjustment entry

    Given it’s not related to a purchase transaction you are faced with the reversal method. No cost exists and it follows the process flow you say the cleanest way is to go back to the beginning.

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,579 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans