Skip to main content
Post a question

Notifications

Community site session details

Community site session details

Session Id : 3iOCBoYf3zkQgPvE2pbQBe
Small and medium business | Business Central, N...
Answered

adjust Item Cost for wrong positive adjustment entry

Like (0) ShareShare
ReportReport
Posted on 25 Aug 2020 13:54:31 by 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
    72 on 27 Aug 2020 at 07:51:01
    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
    on 26 Aug 2020 at 21:21:05
    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
    72 on 26 Aug 2020 at 08:56:17
    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
    83 on 26 Aug 2020 at 07:45:35
    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
    72 on 26 Aug 2020 at 05:48:15
    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
    83 on 25 Aug 2020 at 19:08:25
    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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,127 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,871 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Loading started