Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Changing Standard Cost on Sales Credit Memo

(0) ShareShare
ReportReport
Posted on by 1,120

When creating a credit memo from a sales invoice, one would think that the unit cost would match the cost that was on the original sales invoice.

However, we have recently noticed that when using standard cost that the item on the credit memo displays with the current standard cost (not the cost from the original sales invoice).  Furthermore, you cannot change the unit cost (get a validation error saying you cannot change the cost due to the fact the item is set up with standard cost).

Is this a recent change?  

Is the the expected functionality?

  • Verified answer
    rcboiler Profile Picture
    rcboiler 1,120 on at
    RE: Changing Standard Cost on Sales Credit Memo

    Thanks to everyone for their replies.  It would seem this is expected behavior as all of your solutions resulted in the standard cost pulling from its current value and not from the value on the original invoice.  And again, we could not manually change the cost on the CM to reflect the amount on the original invoice.  

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Changing Standard Cost on Sales Credit Memo

    Hello,

    On the Sales & Receivable Setup page, check the field 'Exact Cost Reversing Mandatory'. This will mandate that when an Item is returned it will use the cost from the document in the Credit Memo/Return Order.

    Hope this helps.

    Thanks,

    Steve

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 75,802 Super User 2024 Season 2 on at
    RE: Changing Standard Cost on Sales Credit Memo

    Hi, Hi, was this Credit Memo created manually?

    I think you can use Create Corrective Credit Memo first.

    pastedimage1651795935546v1.png

    Or using Copy Document features (Disable Recalculate Lines)

    pastedimage1651795976644v2.png

    pastedimage1651795996414v3.png

    PS: Just adding to Kim's method, you can enable Exact Cost Reversing Mandatory in Sales & Receivales Setup page to force the user to select Item Entry on the line(s) every time.

    pastedimage1651796127246v4.png

    Hope this info helps.

    Thanks.

    ZHU

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 169 User Group Leader on at
    RE: Changing Standard Cost on Sales Credit Memo

    You could try using the Applies to Item Entry on the line(s) of your credit memo. Pick the original item ledger entries and see if the cost changes (make sure that you run adjust cost - item entries)

  • Guy McKenzie Profile Picture
    Guy McKenzie 1,330 on at
    RE: Changing Standard Cost on Sales Credit Memo

    That would be expected behaviour.

    When the item is returned into stock, it will have a value of the current standard cost on inventory.

    I can see how it may seem a bit weird but it is correct. Your gain in inventory value is reflected in the COGS account entries.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans