Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Sales charge allocation
Supply chain | Supply Chain Management, Commerce
Suggested answer

Sales charge allocation

(0) ShareShare
ReportReport
Posted on by DavidSC

Hi all.

We are testing new functionality in D365 related to charges allocation (freight or prices discount for example, so these charges should have an effect on stock value) for sales orders. See original blog: https://exploredynamics365.home.blog/2021/01/08/charge-allocation-on-sales-order-new-feature-in-microsoft-dynamics-365-finance-and-operations/

The problem we see is that we are not able to allocate these charges once the sales order is invoiced. We find an error that says "there are not lines that match with selection criteria".

We want to see the effect on the product margin when our Sales Department does a credit note for price errors, discounts, etc. Nowadays they do "Services credit notes" and the product margin is not corrected. We thought that this new functionality could be the sollution but as I explained it seems that it is not possible to allocate new charges for "closed" sales orders.

Thanks so much.

  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 15,039 Super User 2024 Season 2 on at
    RE: Sales charge allocation

    Looks like We can not add this to COGS on sales side whereas we can do this on AP side to adding the Item cost.

    Reason could be COGS is calculated based on "Inventory valuation defined on item model group" , so system can not override that by adding some charges on that..

    Looks like we just need to account this as Charge revenue in ledger

  • DavidSC Profile Picture
    DavidSC on at
    RE: Sales charge allocation

    Thanks for your answer.

    I tried what you mentioned but when Credit Type "item" is selected, a warning says "Charges on item cannot be used". However, this setup is made on Accounts payable module...

  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 15,039 Super User 2024 Season 2 on at
    RE: Sales charge allocation

    Hi David,

    Mostly charge code setup with "Debit customer" and "Credit Item" will not be allowed to adjust after invoice posting because customer has already been posted with invoice and it can not be modified.

    You can try charge code with setup "Debit Ledger" and Credit Item.

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans