Skip to main content
Microsoft Dynamics GP forum
Suggested answer

Is there a way to update the unit cost on a sales order after it has been invoiced?

editSubscribe (0) ShareShare
ReportReport
Posted on by 185

Commissions for salespeople are calculated based on the margin on the order. A specific vendor provides a rebate at the end of each month to offset costs from the previous month. Without this rebate, cost is greater than price, so there is a negative margin. Applying the rebate would update that unit cost for a positive margin. Is there a way to do this? Or a 3rd party product that can do it? The Adjust Cost utility in GP would not work because it applies to purchase receipts, not sales orders.

Ethotech's Commission Plan product is used for calculating commissions. 

Categories:
  • Suggested answer
    Dean Marty Profile Picture
    Dean Marty on at
    RE: Is there a way to update the unit cost on a sales order after it has been invoiced?

    Good Day

    There are no tools/utilities/routines to change costs on posted SOP Orders in GP.

    We would not support making changes to posted data, so any changes to that is at your own discretion.

    Thanks!
    Dean

  • Joseph Markovich Profile Picture
    Joseph Markovich 3,749 on at
    RE: Is there a way to update the unit cost on a sales order after it has been invoiced?

    Is there the possibility that you would be able to use the Commission Plan Entry screen (Sales > Transactions > Commission Plan > Commission Plan Entry) to adjust the unit/extended cost before processing?

    Commission Plan is taking all of the data from the sales transactions and putting it into their own tables. This information is editable before processing takes place.

    I would think you could use something like SmartConnect to automate the cost change on their tables once these rebates are entered. This way you also don't have to mess with posted transactions in the SOP tables either.

    I hope this helps out a bit from a Purdue grad. :)

    Joe

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 282,978 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans